District Administration

User Tools

Site Tools

Trace: • Assign Travel Accounts - DA5100 • Reports
options:tsds:domainsandentities

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
options:tsds:domainsandentities [2024/08/02 15:08] – emorenooptions:tsds:domainsandentities [2025/11/19 16:02] (current) – apape
Line 4: Line 4:
  
 //**District Administration > Options > TSDS > Domains & Entities**// //**District Administration > Options > TSDS > Domains & Entities**//
 +
 +
 +
  
 <WRAP round intro>This tab is used to extract and send Texas Student Data System (TSDS) data to Texas Education Agency (TEA) for Ed-Fi processing.  <WRAP round intro>This tab is used to extract and send Texas Student Data System (TSDS) data to Texas Education Agency (TEA) for Ed-Fi processing. 
 +
 +<WRAP box>
 +**IMPORTANT**: Use the [[https://help.ascendertx.com/districtadmin/doku.php/academy/district_admin_newsy_best_practice_gde|ASCENDER TSDS New School Year Best Practice Guide]] to assist you in making selections of the domains and entities to send to TSDS.
 +</WRAP>
 +
  
 **Submission Levels**:  **Submission Levels**: 
Line 17: Line 25:
  
 <WRAP box> <WRAP box>
-**Note**: While the following dependencies are specific to ASCENDER and not part of the official TSDS Domain Dependency chart, they assist in accurate and reliable data flow. These additional validations group your data in an organized manner, allowing the system to extract and send your data efficiently. +**Note**: These dependencies originate from Ed-Fi/TSDS but are being separated to enhance clarity and processing efficiency. 
 </WRAP> </WRAP>
   * Enrollment Domain **depends** on Student Identification and Demographic > Student   * Enrollment Domain **depends** on Student Identification and Demographic > Student
-  * Student Identification and Demographics Domain > StudentEducationOrganizationAssociation **depends** on Enrollment Domain+  * Student Identification and Demographic Domain > StudentEducationOrganizationAssociation **depends** on Enrollment Domain
   * Teaching and Learning > Course Offering **depends** on Teaching and Learning > Course   * Teaching and Learning > Course Offering **depends** on Teaching and Learning > Course
   * Teaching and Learning > Section **depends** on Teaching and Learning > CourseOffering   * Teaching and Learning > Section **depends** on Teaching and Learning > CourseOffering
Line 42: Line 50:
  
 **Extract & Send Process**: **Extract & Send Process**:
 +
 +<WRAP center round important>
 +The automatic nightly TSDS Extract/Send process is disabled for prior school years effective the day after the fourth Thursday in August. To generate or send data for a prior school year, use the **Extract & Send** button.
 +</WRAP>
 +
 +
 +<WRAP box>
 +**Note**: The **Extract & Send** button is disabled if the Ed-Fi API Connection Migration flag is set to Y. This allows only API commands to process data.
 +</WRAP>
  
 The data is extracted from ASCENDER tables, transformed per TEA requirements to meet the national Ed-Fi data standard, and loaded into the ASCENDER Ed-Fi staging tables.  The data is extracted from ASCENDER tables, transformed per TEA requirements to meet the national Ed-Fi data standard, and loaded into the ASCENDER Ed-Fi staging tables. 
  
-VCV If the Extract & Send process occurs via the automatic scheduled extract, the TSDS Extract Errors report is generated and emailed to the defined TSDS Extract Errors Distribution List on the [[options:tsds:options|District Administration > Options > TSDS > Options]] tab. +VCV If the **Extract & Send** process occurs via the automatic scheduled extract, the TSDS extract emails are generated at 6:15 AM. These emails include the TSDS Extract Error report as well as the Prior Year Actuals, Budget, and Payroll reports (as applicable), and are sent to the defined TSDS Extract Errors Distribution List on the [[options:tsds:options|District Administration > Options > TSDS > Options]] tab.    
  
 VCV If the Extract & Send process occurs manually via the **Extract & Send** button, the TSDS Extract Errors report is not generated and emailed; however, you can navigate to the [[inquiry:tsdslevel1errors|District Administration > Inquiry > TSDS Level 1 Errors]] page and click **Extract Errors Reprint** to generate the TSDS Extract Errors report from the last instance of the Extract & Send process. VCV If the Extract & Send process occurs manually via the **Extract & Send** button, the TSDS Extract Errors report is not generated and emailed; however, you can navigate to the [[inquiry:tsdslevel1errors|District Administration > Inquiry > TSDS Level 1 Errors]] page and click **Extract Errors Reprint** to generate the TSDS Extract Errors report from the last instance of the Extract & Send process.
Line 55: Line 72:
   * Data errors listed on the TSDS Extract Errors report do not necessarily mean that you will have TSDS Level 1 Errors.    * Data errors listed on the TSDS Extract Errors report do not necessarily mean that you will have TSDS Level 1 Errors. 
   * TSDS extract errors are typically data errors that require record(s) in ASCENDER to be corrected.   * TSDS extract errors are typically data errors that require record(s) in ASCENDER to be corrected.
 +  * If the **Extract TSDS** database column is set to 0, the Budget and Payroll extract file/PDF will not be generated and sent via email. This discontinues the emails for Budget and Payroll until after the Fiscal Year Close process is done for the current year. If the **Extract TSDS** database column is set to 1, 2 or 3, the Budget and Payroll extract/PDF will be generated and emailed as usual.
 </WRAP> </WRAP>
  
Line 94: Line 112:
  
 ^**Education Organization Domain & Descriptors**|BBB LocalEducationAgency\\  BBB EducationServiceCenter\\ BBB SSAOrgAssociationExt(TX)\\ BBB School| ^**Education Organization Domain & Descriptors**|BBB LocalEducationAgency\\  BBB EducationServiceCenter\\ BBB SSAOrgAssociationExt(TX)\\ BBB School|
-^**School Calendar Domain**|BBB Calendar\\  BBB CalendarDate\\  BBB Session\\  BBB ReportingPeriodExt(TX)| +^**School Calendar Domain**|BBB Calendar\\  BBB CalendarDate\\  BBB Session\\  BBB ReportingPeriodExt(TX)\\ BBB Grading Period* | 
 +<WRAP box>**Exchange clients only**: An asterisk (*) indicates a //Data Beyond TSDS Domain/Entity//. If any issues are encountered with this data, submit an Exchange ticket.</WRAP>
  
 VCV Under **Second Level Submission**: VCV Under **Second Level Submission**:
 +
 +^**Student Application Domain**|BBB StudentApplication(TX)|
  
  
Line 107: Line 127:
 ^**StudentEducationOrganizationAssociation**|     ^**StudentEducationOrganizationAssociation**|    
  
-^**Enrollment Domain**|BBB StudentSchoolAssociation\\  BBB StudentEducationOrganizationResponsibilityAssociation|+^**Enrollment Domain**|BBB StudentSchoolAssociation\\  BBB StudentEducationOrganizationResponsibilityAssociation\\ BBB GraduationPlan*|
 ^**Staff Domain**|BBB Staff\\  BBB StaffEducationOrganizationAssignmentAssociation\\  BBB StaffEducationOrganizationEmploymentAssociation\\  BBB StaffSchoolAssociation|  ^**Staff Domain**|BBB Staff\\  BBB StaffEducationOrganizationAssignmentAssociation\\  BBB StaffEducationOrganizationEmploymentAssociation\\  BBB StaffSchoolAssociation| 
 +^**Prior Year Leaver Domain**|BBB PriorYearLeaver(TX)\\  BBB PriorYearLeaverParent\\  BBB PriorYearLeaverStudentParentAssociation|
 +<WRAP box>**Exchange clients only**: An asterisk (*) indicates a //Data Beyond TSDS Domain/Entity//. If any issues are encountered with this data, submit an Exchange ticket.</WRAP>
  
 VCV Under **Third Level Submission**: VCV Under **Third Level Submission**:
  
-^**Finance Domain**|BBB PriorYearActualExt(TX)\\  BBB BudgetExt(TX)\\  BBB SharedServiceArrangementExt(TX)\\  BBB PayrollExt(TX)\\  BBB ContractedInstructionalStaffFTEExct(TX)|+^**Finance Domain**|BBB PriorYearActualExt(TX)\\  BBB BudgetExt(TX)\\  BBB SharedServiceArrangementExt(TX)\\  BBB PayrollExt(TX)\\  BBB ContractedInstructionalStaffFTEExt(TX)|
 ^**Alternative and Supplemental Services Domain**|BBB Program\\  BBB StudentCTEProgramAssociation\\  BBB StudentTitle1PartAProgramAssociation\\  BBB Student Special EducationProgramAssociation\\  BBB StudentLanguageInstructionProgramAssociation| ^**Alternative and Supplemental Services Domain**|BBB Program\\  BBB StudentCTEProgramAssociation\\  BBB StudentTitle1PartAProgramAssociation\\  BBB Student Special EducationProgramAssociation\\  BBB StudentLanguageInstructionProgramAssociation|
-^**Prior Year Leaver Domain**|BBB PriorYearLeaver(TX)\\  BBB PriorYearLeaverParent\\  BBB PriorYearLeaverStudentParentAssociation| 
-^**Student Application Domain**|BBB StudentApplication(TX)| 
  
  
Line 128: Line 148:
  
  
 +^**Student Grade Domain**|BBB Grade*|
 +
 +<WRAP box>**Exchange clients only**: An asterisk (*) indicates a //Data Beyond TSDS Domain/Entity//. If any issues are encountered with this data, submit an Exchange ticket.</WRAP>
  
 VCV Under **Fourth Level Submission**: VCV Under **Fourth Level Submission**:
Line 158: Line 181:
      
  
-VCV Click **Send Status** to view the extract status details. The Send Status pop-up window is displayed with a list of the following details: **Domain**, **Entity**, **Total Nbr Records**, and **Success** percentage. This list excludes domains/entities for which no data has been sent.+VCV Click **Send Status** to view the extract status details. Domains/entities with no data sent are excluded from this list. The Send Status pop-up window is displayed with the following details:  
 + 
 + 
 +  * **Domain** 
 +  * **Entity** 
 +  * **Total Nbr Records** 
 +  * **Success** percentage  
 +  * **Extract Start Time** - Indicates the time the extract started sending data to the staging table.  
 +  * **Extract End Time** - Indicates the time the extract completed sending data to the staging table. 
 +  * **Send Start Time** - Indicates the time the API started sending data to the Operational Data Store (ODS). 
 +  * **Send End Time** - Indicates the time the API completed sending data to the Operational Data Store (ODS). 
 + 
 +VCV If you have the appropriate access, you will see checkboxes for each Domain/Entity (row). You can use the extract and send buttons to extract/send data as needed. Only one Domain/Entity (row) can be selected and processed at a time. 
 + 
 + 
 +VCV Click **Extract & Send** to extract data to the staging table and send data via the API to the Operational Data Store (ODS). 
 + 
 +VCV Click **Extract Only** to **only** extract data to the staging table. 
 + 
 +VCV Click **Send Only** to **only** send data via the API to the Operational Data Store (ODS). 
 + 
 +<WRAP center round tip> 
 +Click [[general:send_status_window|here]] to see how the **Time** fields correspond to the execution of the **Extract & Send**, **Extract Only**, and **Send Only** buttons. 
 +</WRAP> 
 + 
 + 
 + 
 +VCV Click **Cancel** to return to the Domains & Entities tab.
  
 +<WRAP box>**Notes**: 
   * This information can be used as a measure in the decision to continue adding entities/domains to the Extract & Send process.    * This information can be used as a measure in the decision to continue adding entities/domains to the Extract & Send process. 
   * If the success rate is lower than the recommended threshold of 90%, a warning message is displayed next to the **Send Status** button to inform users that it is not recommended to add and send additional domains/entities at this time.   * If the success rate is lower than the recommended threshold of 90%, a warning message is displayed next to the **Send Status** button to inform users that it is not recommended to add and send additional domains/entities at this time.
Line 165: Line 216:
   * Access the [[https://www.texasstudentdatasystem.org/tsds/about/resources#UpgradeProjectDocumentation|TSDS Resources]] page and click //Domain Dependencies// to view the current TSDS Domain Dependency chart. Use the chart to troubleshoot errors.   * Access the [[https://www.texasstudentdatasystem.org/tsds/about/resources#UpgradeProjectDocumentation|TSDS Resources]] page and click //Domain Dependencies// to view the current TSDS Domain Dependency chart. Use the chart to troubleshoot errors.
  
 +</WRAP>  
  
 ====Other functions and features:==== ====Other functions and features:====
options/tsds/domainsandentities.1722611281.txt.gz · Last modified: 2024/08/02 15:08 by emoreno

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International

Americans with Disabilities Act (ADA) and Web Accessibility

The Texas Computer Cooperative (TCC) is committed to making its websites accessible to all users. It is TCC policy to ensure that new and updated content complies with Web Content Accessibility Guidelines (WCAG) 2.0 Level AA. We welcome comments and suggestions to improve the accessibility of our websites. If the format of any material on our website interferes with your ability to access the information, use this form to leave a comment about the accessibility of our website.