July 2023 Major Maintenance Release

Removed extra comma in the values for the September Attendance and Early Attendance extracts.

The Race Field has been divided into five new fields: American Indian or Alaska Native, Asian, Black or African American, Native Hawaiian or Other Pacific Islander, and White in the EOY Report.

Updated the validation tables and business rules for the Maryland Enrollment, Attendance, and Promotion Report:

• Added new code 0 to the MD Pre K Tier Status validation table.
• Updated the description for codes 1, 2, and 3 of the MD Pre K Tier Status validation table.
• Implemented the following nine business rules for the September attendance:
  • When the Migrant value is Y and the FARMs value is not F, then log the warning message.
    Warning Message: FARMs must be F when Migrant is Y.
  • When the Foster value is Y and the FARMs value is not F, then log the warning message.
    Warning Message: FARMs must be F when Foster is Y.
  • When the Homeless value is Y and the FARMs value is not F, then log the warning message.
    Warning Message: FARMs must be F when Homeless is Y.
  • When the State-aid code is 03, grades are 92 or 93, and the Pre-K tier status is blank, then log the warning message; otherwise, must be left NULL for all other state-aid/grade combinations.
    Warning Message: Pre-K Tier status is required when the State-Aid code is 03 and Grades are in 92 or 93.
  • When the State-aid code is 03, grades are 92 or 93, and the Federal Poverty Level (FPL) is blank, then log the warning message; otherwise, FPL should be NULL.
    Warning Message: Federal Poverty Level (FPL) is required when the State-Aid code is 03 and Grades are in 92 or 93.
  • When the Pre-K Tier Status is 1 and Pre-K Full-time Status is not Y, the Grades are not in 92 or 93, and the Age is not 3 or 4 years old as of 9/1/(School Year-1), then log the warning message.
    Warning Message: Pre-K Full-time Status must be Y, Grades must be 92 or 93, and Age must be 3 or 4 years old as of 9/1/XXXX when the Pre-K Tier Status is 1.
  • When the Pre-K Tier Status is 2 and Pre-K Full-time Status is not Y, the Grade is not 92, and the Age is not 4 years old as of 9/1/(School Year-1), then log the warning message.
    Warning Message: Pre-K Full-time Status must be Y, Grade must be 92, and Age must be 4 years old as of 9/1/XXXX when the Pre-K Tier Status is 2.
  • When the Pre-K Tier Status is 3 and Pre-K Full-time Status is not Y, the Grade is not 92, and the Age is not 4 years old as of 9/1/(School Year-1), then log the warning message.
    Warning Message: Pre-K Full-time Status must be Y, Grade must be 92, and Age must be 4 years old as of 9/1/XXXX when the Pre-K Tier Status is 3.
  • When the Pre-K Tier Status is 0 and Federal Poverty Level (FPL) is not equal to 000, then log the warning message.
    Warning Message: Federal Poverty Level must be 000 when the Pre-K Tier Status is 0.