Master Article - TSDS Reporting

This is the Master Article for all available information regarding the TX TSDS Reporting program.

• Payroll
• Financials
• Texas
• TX TSDS Reporting

Informational

Setup and Processing Instructions:

• TX TSDS Setup
• TX TSDS Fall Submission Processing for TSDS GoLive
• TX TSDS Mid-Year Submission Processing
• Setting up Contracted Instructional Staff for TSDS Reporting
• TSDS Orientation Webinar PPT - September.24.2024

General Knowledge

• TSDS API submissions are submission based in EERP
• TSDS API Terminology Crosswalk from PEIMS XML
• TSDS - Can I use a non-Production EERP environment
• TSDS - Can Munis look at the data being sent to TSDS
• TSDS Code Translations - EERP Table ID to TWEDS Code Tables
• TSDS - FTE - Calculated Full-Time Equivalents
• TSDS - JSON Files
• TSDS - Most recent Tyler Deploy Release version for TSDS reporting
• TSDS Reporting Requirements
• TSDS - Staff Do Not Report
• TSDS - Texas Education Exchange - I want to get EERP Munis connected
• TSDS Web-Enabled Data Standards - TWEDS

Go-Live-Specific

• TSDS - 2024-2025 Data Standards Changes
• TSDS - Do I still need to Purge before I Generate
• TSDS - TEA installed SDK Version 2025.2.1 to your ODS October 4th 2024
• TSDS Webinars
• TSDS - When can I publish data to my production ODS from EERP
• TSDS - Required Steps after installing the October 23rd code changes
• TSDS - Will the webinars be recorded
• TSDS - Does the demographic information for instructional staff come from Munis

Setup-Related Questions

• TSDS - Access Denied error selecting TSDS Code Translations or Settings from the Setup tab
• TSDS - Error testing connection with Test Resource Connection option
• TSDS - Error adding SSA Maintenance record
• TSDS - How do I generate a key and secret
• TSDS - How do I verify the API connection
• TSDS - PK and TIA confusion with Area codes in Employee Certifications
• TSDS - SIS vendor said we needed to create Adult Learning Campus in EERP
• TSDS SSA Maintenance - What is Member District Segment Value
• TSDS - What do I do with the key and secret I generated
• TSDS - Which Staff is considered Contracted Instructional Staff
• TSDS - Where is Summary Job Category for TX TSDS PROJOBCAT Crosswalk coming from

Employee Assignments 

• Employee Assignments - Bad MIME in Content-Type error importing
• TSDS Employee Assignments - Cannot insert the value NULL Import error
• TSDS Employee Assignments - Changing field names to reflect TSDS purpose
• TSDS Employee Assignments - Duplicate Key error trying to Import
• TSDS Employee Assignments - How to populate the fields
• TSDS Employee Assignments - Miscellaneous Codes missing
• TSDS Employee Assignments - No excel rows were found for import
• TSDS Employee Assignments - Program does not open from TSDS Setup tab - No access permissions
• TSDS Employee Assignments - Unable to add another record for 2nd SPEDStudentAgeRange
• TSDS Employee Assignments - When to create a record

Generate

• TSDS Generate - Can I re-Generate just the employees with errors
• TSDS Generate - Duplicate Key error trying to Generate
• TSDS Generate - Error building staff details because column HighestCompletedLevelOfEducation truncated
• TSDS Generate - Error encountered while generating records - Error on execute immediate get ssa type
• TSDS Generate - How do I exclude an account from the Generate
• TSDS Generate Validation - Payroll Object segment has an unmapped EERP value
• TSDS Generate Validation - Payroll Rec Not Created

Period Record Data

• TSDS - How do I correct the TSDS Period Record data after I correct the source
• TSDS - No Purge option on Period Record screens
• TSDS ODS Status field
• TSDS - Out of Sync Period Records are not being updated or deleted after Submit

Contracted Instructional Staff FTE Records 

Budget Records

• TSDS Budget Records - Begin Date incorrect when Generating for Next Year
• TSDS Budget Records - Budget adjustments made after the Snapshot date are being included
• TSDS Budget Records - How do the Begin and End Date fields populate
• TSDS Budget Records - Will we be able to Update

Payroll Records

• TSDS Payroll Records - Employee Name details missing
• TSDS Payroll Records - Export does not include employee data
• TSDS Payroll Records - How do the Begin and End Date fields populate
• TSDS Payroll Records - Object Generates with XXXX but the same record in PEIMS has the correct value
• TSDS Payroll Records - Organization missing leading zeros
• TSDS Payroll Records - Record being created for emp with no Staff record
• TSDS Payroll Records - Records missing

Prior Year Actual Records

SSA Org Association Records

• TSDS SSA Org Association Records - Missing records

Shared Service Arrangement Records

• TSDS Shared Service Arrangement Records - Will we be able to Add and Update

Staff Records

• TSDS Staff Assignments - How do I report assignment details for staff with an Auxiliary Role ID
• TSDS Staff Assignments - Is the record Generating from Employee Assignments or Employee Job Salary
• TSDS Staff Assignments - Monthly Minutes missing
• TSDS Staff Assignments - Not being created with Employee Assignments details
• TSDS Staff Assignments - Number of Students missing
• TSDS Staff Assignments - Record Generating that should not be
• TSDS Staff Assignments - Records Missing
• TSDS Staff Assignments - SIS or EERP
• TSDS Staff Assignments - SPED Student Age Range missing
• TSDS Staff Assignments - Where is School Id Generating from
• TSDS Staff Assignments - Where is Staff Service Generating from
• TSDS Staff Employment - Number Days Employed Blank
• TSDS Staff Employment - Begin and End dates
• TSDS Staff Entity - Creditable Years of Service not Generating correctly for TIA teachers
• TSDS Staff Entity - How do I get a record to Generate for Staff Type 4
• TSDS Staff Entity - Not enough Years reporting in Years of Experience
• TSDS Staff Entity - Paraprofessional Certification missing for Paraprofessionals
• TSDS Staff Entity - Total Years of Professional Experience equals Total Years of Prior Teaching Experience
• TSDS Staff Records - Job Summary 2 defined as Excluded and Staff records still being created
• TSDS Staff Records - Need to Search by UID or Name
• TSDS Staff Records - RaceJSON column in Excel file created from Export Data 
• TSDS Staff Records - Record missing for Contracted staff that changed positions after Snapshot
• TSDS Staff Records - Record missing for employee that switched positions
• TSDS Staff Records - Record not Generating for this employee
• TSDS Staff Records - Records not deleting after re-Gen with Employee Master Filters set to Exclude these employees
• TSDS Staff Schools - Should there be information here for Fall Submission
• TSDS Staff Schools - Where does this information Generate from

Submission

• TSDS Submission - Days Employed Set not publishing to ODS
• TSDS Submission - Error Authenticating - Check API Credentials
• TSDS Submission - Error converting JSON record data into string
• TSDS Submission - Error fetching contract FTE period record data into JSON
• TSDS Submission - Error retrieving connection information from Application Storage
• TSDS Submission - Error Submission cannot be completed because Generate errors were not corrected
• TSDS Submission - Error trying to change permissions for Shared Report Definition
• TSDS Submission - Error Unable to acquire bearer token with no Status Code provided
• TSDS Submission - Error Unexpected API response
• TSDS Submission - If I upload a file and get errors can I make corrections and upload again
• TSDS Submission - Request Method in Submission Errors
• TSDS Submission Error - No relationships have been established between the callers education organization id claim and the resource items EducationOrganizationId value
• TSDS Submission Error - Request Timeout
• TSDS Submission Error - Status Code 400 - NumberDaysEmployed must be between 1 and 366
• TSDS Submission Error - Status Code 400 - StaffId is required FirstName is required LastSurname is required
• TSDS Submission Error - Status Code 400 - StaffServiceDescriptorId is required
• TSDS Submission Error - Status Code 405
• TSDS Submission Error - Status Code 409 - levelOfEducationDescriptor resource does not exist
• TSDS Submission Error - Status Code 409 - Staff cannot be deleted because it is a dependency
• TSDS Submission Error - Status Code 409 - Staff was not found
• TSDS Submission Error - The value supplied for the related PKTeacherREquirement resource does not exist

Fatals

• TSDS Fatal - 10020-0011 - SchoolId must be a valid campus registered with the TEA
• TSDS Fatal - 30040-0044 - If StaffType is 1 then Payroll record required with PayrollActivity 80 or 78
• TSDS Fatal - 30040-0051 - Each staff needs StaffSectionAssociation or Staff Assignment or Aux Role ID on Staff Employment
• TSDS Fatal - 30040-0058 - CreditableYearOfService must be reported for all teachers with a TeacherIncentiveAllotmentDesignation
• TSDS Fatal - 30060-0017 - If Payroll Fund is an SSA Fund Organization must be 751 or 999
• TSDS Fatal - 30060-0069 - If Payroll Object is 6129 then Staff Assignment record or Auxiliary Role ID is required
• TSDS Fatal - 30090-0034 - If StaffClassification is 027 SchoolId must end in 701
• TSDS Fatal - 30090-0104 - If StaffClassification is 008 then MonthlyMinutes must not be blank