Changelog

Data Mart 2.7.1, 2021-06-04

Bug Fixes

  • Fix a bug in the CourseTranscripts table by sourcing CreditCategories from the descriptor code value instead of the descriptor id.

Data Mart 2.7.0, 2021-05-03

New Features

  • Add a Staff_v2 table to the Data Mart to address various issues with the Staff table.

Data Mart 2.6.4, 2021-04-08

Bug Fixes

  • Fix a bug in StudentDemographicsAndEnrollment_v2 that was causing section 505 placements to not to count toward the Is504Plan field when there was no BeginDate in the program participation.

Data Mart 2.6.3, 2021-04-08

Improvements

  • Restructure the CourseGrades query to optimize performance and decrease runtime.

Data Mart 2.6.2, 2021-04-07

Bug Fixes

  • Fix a bug that was incorrectly calculating IsCurrentStaffAssociation in the CourseEnrollments_v2 table.

Data Mart 2.6.1, 2021-04-06

Bug Fixes

  • Fix a bug that was incorrectly labeling a very small number of students as having a race of “Two or More Races”.

Data Mart 2.6.0, 2021-04-02

New Features

  • Add StaffClassroomPosition, StaffBeginDate, StaffEndDate, and IsCurrentStaffAssociation fields to the CourseEnrollments_v2 table.

Data Mart 2.5.0, 2021-03-12

New Features

  • Add a CourseTranscripts table to the Data Mart.

Data Mart 2.4.3, 2021-03-09

Improvements

  • Rename the StudentItemResultDescriptor field to ItemResultDescriptor in the AssessmentItemResults table.

Data Mart 2.4.2, 2021-03-09

Improvements

  • Make various improvements to the Assessments, AssessmentResults, AssessmentItemResults, and AssessmentObjectiveAssessments tables.

Data Mart 2.4.1, 2021-03-08

Bug Fixes

  • Mark the AssessmentCategoryDescriptor field in the AssessmentResults and AssessmentObjectiveAssessments tables as NULLABLE.

Data Mart 2.4.0, 2021-03-08

New Features

  • Add Assessments, AssessmentResults, AssessmentItemResults, and AssessmentObjectiveAssessments tables to the Data Mart.

Data Mart 2.3.1, 2021-03-02

Bug Fixes

  • Fix a bug in CourseGrades to use grading period descriptor code value instead of descriptor id.

Data Mart 2.3.0, 2021-02-18

New Features

  • Add a CourseGrades table that includes all course grades for all grading periods in the school year.

Data Mart 2.2.3, 2020-12-03

Bug Fixes

  • Fix a bug in StudentAttendance and StudentDemographicsAndEnrollment_v2 that was causing the NumberOfDaysEnrolled field to be off by one (e.g. showing 90 instead of 89 days enrolled).

Data Mart 2.2.2, 2020-11-23

Bug Fixes

  • Fix a bug in AverageDailyAttendance_v2 that was producing ADA date records for schools that were not in-session on those days if another school in their district was in-session.

Data Mart 2.2.1, 2020-11-09

Bug Fixes

  • Roll the StudentAttendanceByDate.EventDuration data mode back to NULLABLE to account for non-Landing Zone SIS integrations that may not provide this data.
  • Fix a bug in the StudentAttendance.NumberOfDaysEnrolled calculation to default to 0 when a student enrollment does not overlap with an instructional day.
  • Fix a bug in the StudentAttendance count columns to account for NULL EventDurations.

Data Mart 2.2.0, 2020-11-06

New Features

  • Add a NumberOfDaysEnrolled column to the StudentAttendance table to aid in attendance calculations.
  • Add a SisUniqueId column to the StudentDemographicsAndEnrollment_v2 table to aid in joining Data Mart tables to student information system data.
  • Add a StaffClassroomPosition column to the CourseEnrollments_v2 table to better distinguish primary and non-primary teachers.

Improvements

  • Filter out “In Attendance” attendance events from the StudentAttendanceByDate table.
  • Update BigQuery data modes in the StudentAttendance, StudentAttendanceByDate, and CourseEnrollments_v2 tables to better represent the data.

Bug Fixes

  • Fix a bug in the StudentGradesCurrent_v2 table that was causing CourseTitle data to not get pulled from the ODS for some customers.
  • Fix a bug in the StudentGradesCurrent_v2 table that was creating duplicate rows for some customers.
  • Fix a bug in the Staff table that was populating the race descriptor description instead of the more appropriate and concise short description value.

Data Mart 2.1.1, 2020-10-27

Bug Fixes

  • Fix a bug in the CourseEnrollments_v2 table that was causing CourseTitle data to not get pulled from the ODS for some customers.

Data Mart 2.1.0, 2020-10-21

New Features

  • Add an EllDescriptor column to the StudentDemographicsAndEnrollment_v2 table to give further granularity on English language learner status.

Bug Fixes

  • Fix a bug in the StudentDemographicsAndEnrollment_v2 table that was causing LunchStatus data to not get pulled from the ODS for some customers.

Data Mart 2.0.0, 2020-10-09

Bug Fixes

  • Fix a bug in the StudentAttendance table that was calculating ADA incorrectly if the student had multiple enrollments at the same school.
  • Fix a bug in the StudentGradesCurrent_v2 table that was resulting in duplicate rows.

Misc/Internal

  • Migrate all Data Mart queries from Microsoft SQL to PostgreSQL. Change does not affect customer functionality.

Data Mart 1.1.3, 2020-04-21

Bug Fixes

  • Ensure that StudentDemographicsAndEnrollment and StudentDemographicsAndEnrollment_v2 are pulling in the correct values for the ExitWithdrawReason column.

Data Mart 1.1.2, 2020-03-24

Bug Fixes

  • Fix date casting in the StudentAttendance table that 1.1.1 update broke.

Data Mart 1.1.1, 2020-03-24

Bug Fixes

  • Add SELECT DISTINCT to StudentDemographicsAndEnrollment and StudentDemographicsAndEnrollment_v2 to an address edge case where some duplicate records were showing up.
  • Add SELECT DISTINCT to StudentAttendanceByDate to address edge cases where some duplicate records were showing up.
  • Update query for StudentAttendance so that the numerical columns don’t show NULLs. Any NULLs are replaced with 0s.