❏ Modified the program to temporarily prevent TSDS emails from being generated.

❏ Corrected the issue where the program incorrectly generated invalid school year records upon creation. For example, attempting to add a record with a school year of 2025 would result in an erroneous record with the school year '202.

❏ Added this tab to extract Texas Student Data System (TSDS) data and send it to Texas Education Agency (TEA) for Ed-Fi processing. Users can select and save domains and entities, view the status of extracted data, and initiate on-demand data submissions.

❏ Added the Prior Teaching Years field to report the total number of years an individual has previously held a teaching position in one or more educational institutions. For TSDS purposes, this information must be reported for Contracted Teachers.

❏ Updated the domain for studentEdOrgAssociationLoadStep in EDFI_ERROR_LOG_TABLE_LIST to be Student Identification and Demographics.

❏ Updated the error listing to sort and group by School Year to assist in identifying information.

❏ Updated the extract to exclude the EducationOrganization > LocalEducationAgency entity from being reported for Education Service Centers (databases with a %950 district ID).

❏ Renamed the ActualExt entity to PriorYearActualExt.

❏ Deleted the BeginDate Data and EndDate Data elements from the PriorYearActualExt entity.

❏ Modified the Payroll Extract entity to extract only employees with a payoff date greater than September 1 of the prior year (09/01/(SY-1)) or those with no payoff date.

❏ Updated the daily automatic extract (6:00 PM, Mon-Fri) to use a new TSDSDatabaseAPIs file for extracting and sending TSDS data via API processing. This update allows system technicians to run TSDS overnight extracts on multiple servers and distribute the load processing for databases. Databases will now be extracted simultaneously rather than one at a time.

❏ Modified the program to generate TSDS extract emails at 6:15 AM. These emails include the TSDS Extract Error report as well as the Prior Year Actuals, Budget, and Payroll reports.

❏ Corrected the issue that caused users to get a blank pop-up screen when selecting the Process Status button.

❏ Modified ASDR reports to show the most current date that ASDR was run rather than the current date/time.

❏ Corrected the issue on DA00001 - User Profile Report and DA00100 - End User License Agreement Report that caused incorrect LEA names to populate for some users.

❏ Modified the program to calculate the AsOfStatusLastDayEnrollment code in the nightly batch using the code from the Summer Attendance Extract.

❏ Updated the program to add data element SummerSchoolIndicator (E3091) to the CourseTranscript entity using Special Consid code R for reporting.

❏ Effective 9/1/2023:
Responsibility Descriptors 01 and 02 are no longer valid and have been moved to StudentSchoolAssociation.

❏ Created extract “P_EXTRACT_EDFI_STU_DISPLN_INC_BEHAV_ASSOC_STG” to extract from entity StudentDisciplineIncidentBehaviorAssociation.

❏ Removed StudentParticiaptionCode element in StudentDisciplineIncidentAssociation.
❏ Moved Behavior entity data elements to StudentDisciplineIncidentBehaviorAssociation.

❏ Updated the extract to report Staff Education Organization Employment Association the day after an employee's termination date.

❏ Updated the program to report begin dates and end dates for the StudentCTEProgramAssociation.CTEProgramService entity.

❏ Modified the CourseTranscript entity to add LocalCourseCode, SchoolId, SectionIdentifier, SessionName and SummerSchoolIndicator to API property tx.CourseTranscriptExtenion.

❏ Corrected an issue in Student Education Organization Association that caused the error: “Extract processed but failed with stored procedure error. Please provide server.log file.”

❏ Updated the API to send data to the .InstructionalSettingSet instead of .SpecialEducationEnvironmentSet in the StudentSpecialEducationProgramAssociation endpoint.

❏ Updated the program to remove the DyslexiaScreeningExceptionReason.

❏ Updated the program to add DyslexiaScreeningExceptionReason to StudentEducationOrganizationAssociation.DyslexiaRiskSet.

❏ Updated the TSDS 2023-24 change logs to add new fields for the StudentSchoolAssociation entity.

❏ Added the CampusIdOfResidence property to the StudentSchoolAssociations API.

❏ Modified the utility to clear the Excessive Unexcused Absence date on Registration > Maintenance > Student Enrollment > Demo3 for the new school year when the other Truancy Indicators are cleared.

❏ Modified the utility to clear TeacherPortal table SR_CRS_ASSGN_COMNT in for the new school year.

❏ Corrected TeacherPortal category errors some users received when they did not select the Clear Categories option for a campus when running the utility.

❏ Modified the utility so TeacherPortal Report Card Skills (Elementary Report Cards > Manage Elementary Skills Based Report Cards) will be retained for the new school year.

❏ Corrected an issue with the utility that caused some students to be on the Dropped Student list even though the student had an Active Code = 1 and were fully scheduled at their Next Year Campus.

❏ Modified the utility to add code that will correctly determine if 0/00 default records should be created for specified tables and columns.

Course Transcript

❏ Corrected the issue that caused some users to receive a “Duplicate record error” when extracting a course transcript when a student has completed 2 courses with the same service ID in the same semester.

❏ Modified the program to extract the 0 descriptor (C067-RegionalDaySchoolProgramForDeaf) to the Student Attendance staging table.

❏ Updated the CTE Program Reporting Period Attendance extract to perform more efficiently.

❏ Renamed the Shared Services Arrangements Amounts section to Shared Services Arrangement Member Amounts and added the Member District ID field.

❏ Corrected an issue with the Discipline Domain Level 1 Error Report that caused the report to not generate.

❏ Modified the Finance Domain > SharedServiceArrangementExt Entity to extract as follows:

• EducationOrganization
• SSAMemberDistrictId
• SSAType
• FiscalYear
• ActualAmount
• SSAFund

❏ Modified all TSDS Level 1 Error reports to display and print in landscape orientation by default.

❏ Corrected the following Level 1 Errors:

• EDFI Student Education Error Transforming Data and Inserting into EDFI Staging Table (EDFI_STU_ED_ORG_RESP_STG)
• Extract processed but failed TSDS Extract Batch Process processed but failed with stored procedure error. Please provide server.log file.

❏ Added this new tab to manually enter prior year ending fund balances (3XXX) as reflected on schedule C-1 of the audit to be used for the ActualExtension complex type during TSDS Mid-Year reporting.

IMPORTANT:

• Pilot LEAs will use this tab to manually enter prior year fund balances (3XXX).
• Non-pilot LEAs will continue to handle prior year fund balances (3XXX) in State Reporting.

❏ Modified the Password Expiration (in days) field to only allow values 1-180. Zero is no longer a valid value.

❏ Added the following three buttons to allow the reprint of the extract reports from the last instance of TSDS Processing. These reports are not resent to the TSDS email distribution lists.

• Extract Errors Reprint - Reprints the TSDS Extract Errors report.
• Extract Budget Reprint - Reprints the TSDS Budget Data Extract report.
• Extract Payroll Reprint - Reprints the TSDS Payroll Extract report.

❏ Updated the EDFI Extract Error report to only report one day of errors.

❏ Added the county district number to the email subject line of the report.

❏ Modified the program to validate TSDS credentials upon saving the record. If validation is not passed, the record is not saved and the following message is displayed: “Information provided does not validate to TEA.”

❏ Added validation to display a message indicating that at least one email address is required for each distribution list (Finance Extract Distribution List, Personnel/Payroll Extract Distribution List, TSDS Extract Errors Distribution List) if the Connection tab contains information.

❏ Updated the program to add Child Care Operation Number tables to the Annual Student Data Rollover (ASDR) process.

❏ Corrected an issue with the program that caused the utility to stop running and give the user an Execute fail message.

❏ Corrected an error when performing the EXECUTE step that caused the utility to stop and give the user an unexplained error message.

❏ Corrected the issue that caused the ASDR extract to fail when a student has multiple records for the IGC Program (State Reporting > Options Local Program for IGC Reporting) on Registration > Maintenance > Student Enrollment Local Programs.