❏ Modified the program to restrict editing of Account Code fields for Budget and Payroll records that have been submitted to TEA. After TEA submission and assignment of an ODS ID, the Account Code fields will become read-only.

❏ Created/applied an SQL to resolve the following TSDS fatal error 20030-0016: If BudgetObject is within the range “6100”-“6600”, then BudgetProgramIntent must not be “00”. If the record in the Budget staging table includes an ODS ID and the amount is zero, it is marked to be deleted in the ODS and the record will remain in the staging table. If the record does not have ODS ID and the amount is zero, it is removed from the Budget staging table.

❏ Modified the program so it will no longer calculate the AsOfCodes in the 6:00pm nightly extract.

❏ Corrected TSDS extracts to automatically include non-employees who are under active contract, provided they have valid data (Begin Date, End Date, TX Unique Staff ID, Race, Days Employed, and Percent of Day). This eliminates the requirement of selecting the Extract for TSDS checkbox for these individuals.

❏ Modified the program to only require the TSDS Staff Type field to be populated if the TX Unique Staff ID field is populated.

❏ Corrected the program to only allow valid characters (selected from the ellipsis) to be saved in the Staff Service field.

❏ Implemented a daily cron job to run at 3:15 AM to reset the Ed-Fi API connection flag. This allows the connection flag to reset daily allowing disrupted databases to restart TSDS processing at the scheduled 4:15 AM run.

❏ Corrected the issues with missing end dates that triggered Fatal Errors 30090-0007.