Master Article - TSDS Reporting
- Knowledge Assistant
Owned by Knowledge Assistant
Description of Issue
This is the Master Article for all available information regarding the TX TSDS Reporting program.
Context
- Payroll
- Financials
- Texas
- TX TSDS Reporting
Cause
Informational
Resolution
Setup and Processing Instructions:
- TX TSDS Setup
- TX TSDS – Just the Setup That Didn’t Already Exist for PEIMS XML
- Setting up Contracted Instructional Staff for TSDS Reporting
- TX TSDS Fall Submission Processing for TSDS GoLive
- 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 - 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 - 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
Shared Service Arrangement Records
Staff Records
- TSDS Staff Assignments - How do I report assignment details for staff with an Auxiliary Role ID
- 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 - SIS or EERP
- TSDS Staff Assignments - SPED Student Age Range missing
- 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 - 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 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 - 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 - 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
Additional Information