District Administration

User Tools

Site Tools

Trace:
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 [2025/03/06 20:44] – 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. 
Line 47: 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> <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. **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 box>+</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 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 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 104: 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 117: 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**:
Line 124: Line 136:
 ^**Finance Domain**|BBB PriorYearActualExt(TX)\\  BBB BudgetExt(TX)\\  BBB SharedServiceArrangementExt(TX)\\  BBB PayrollExt(TX)\\  BBB ContractedInstructionalStaffFTEExt(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 138: 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 168: 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 175: 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.1741293845.txt.gz · Last modified: 2025/03/06 20:44 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.