District Administration

User Tools

Site Tools

Trace: • Student Directory • District Logos - DA1240 • Connection - DA2100 • Fall Finance TSDS Data - DA1200
tables:districtinformation:fallfinancetsdsdata

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
tables:districtinformation:fallfinancetsdsdata [2025/01/07 21:41] – emorenotables:districtinformation:fallfinancetsdsdata [2026/08/19 15:36] (current) – emoreno
Line 8: Line 8:
  
  
-The data on this tab is obtained from the latest Fall extracts after period 10 is closed, incorporating all TSDS crosswalks, automatic crosswalks, and data summaries. Accounts are summarized by fund, function, object class (6100), organization, and program intent code. For instance, 199-11-6119.00-001-511000 will display as 199 11 6100 001 11. Users should cross-reference balances with the Finance application and may need to combine amounts to ensure accurate budget reporting.+The data on this tab is obtained from the latest Fall extracts after period 10 is closed, incorporating all TSDS crosswalks, automatic crosswalks, and data summaries. Accounts are summarized by fund, function, object class (6100), organization, and program intent code. For instance, 199-11-6119.00-001-611000 will display as 199 11 6100 001 6 11. Users should cross-reference balances with the Finance application and may need to combine amounts to ensure accurate budget reporting. 
  
  
-  
 **Notes**:  **Notes**: 
-  * This tab is only available if accounting period 10 in Finance is closed. 
   * Data cannot be duplicated. Duplicated data will receive an error upon submission.    * Data cannot be duplicated. Duplicated data will receive an error upon submission. 
   * Enter data carefully on this tab. Incorrect or improperly formatted data may cause errors upon submission.   * Enter data carefully on this tab. Incorrect or improperly formatted data may cause errors upon submission.
 +
 +
 +**TSDS Extract Notes**:
 +
 +VCV The budget and payroll data extracts are run nightly along with the other TSDS extracts until accounting period 10 (October) is closed in Finance. 
 +
 +  * After period 10 (October) closes, the budget and payroll data extracts are paused for the current school year.
 +  * After period 10 (October) closes and the nightly extract is run, the Fall Finance TSDS Data tab in District Administration is enabled allowing users to begin making corrections to budget and payroll data.
 +
 +VCV Although data is extracted nightly at 6:00 p.m., there may be instances where you need to send corrections before the next scheduled (nightly) extract. If any changes are made to financial (budget, actuals, payroll) data, you must first extract data in ASCENDER and then schedule a run in ASCENDER DataConnect (ADC). Complete the following steps: 
 +<div indent>
 +1. District Administration > Options > TSDS > Domains & Entities
 +
 +  * Verify that the** Submission Year** is correct. 
 +  * Click **Extract**. 
 +
 +2. ASCENDER DataConnect (ADC)
 +  * Schedule a run to transfer the changes to the IODS, and if applicable, to the EODS.
 +</div>
 +
  
 [[https://help.ascendertx.com/business/doku.php/general/finance_tsdscrosswalk_tables|Finance TSDS Crosswalk Tables]] [[https://help.ascendertx.com/business/doku.php/general/finance_tsdscrosswalk_tables|Finance TSDS Crosswalk Tables]]
Line 25: Line 44:
  
 ^ Field                                        ^ Description   ^  /*Table with two rows*/ ^ Field                                        ^ Description   ^  /*Table with two rows*/
-^Year|Verify that the correct reporting year is displayed. If not, type the correct four-digit reporting year for which you want to add or retrieve data and click **Retrieve**. For example, the reporting year for the 2024-2025 school year is 2025.|+^Year|Verify that the correct reporting year is displayed. If not, type the correct four-digit reporting year for which you want to add or retrieve data and click **Retrieve**. For example, the reporting year for the 2025-2026 school year is 2026.|
  
 VCV Click {{:images:dropdown.gif|Drop-down Arrow}} to select a the type of data to retrieve: VCV Click {{:images:dropdown.gif|Drop-down Arrow}} to select a the type of data to retrieve:
  
-  * //1 - Budget Data// +  * //1 - Budget// 
-  * //2 - Payroll Data//+  * //2 - Payroll//
  
 To narrow your search results, you can filter data using account code components. For Payroll-specific data, you can further refine your search by using the **Unique Staff ID** field. To narrow your search results, you can filter data using account code components. For Payroll-specific data, you can further refine your search by using the **Unique Staff ID** field.
Line 41: Line 60:
  
  
-**Budget Data**:+===== Budget =====
  
 +{{page>general:tsds_recordupdates}}
  
-<WRAP box> **Note**:  
-  * The **Account Code** fields can only be edited for new or existing records until they are submitted to TEA. After TEA submission and assignment of an ODS ID, the **Account Code** becomes read-only. 
-  * Account codes (rows) are validated to prevent duplicate records.  
-</WRAP>  
  
-^Delete|The trashcan icon is only displayed for new or existing records that have not been submitted to TEA (i.e., the ODS ID is blank or the record is blank or unsaved). To delete a previously submitted record, set its amount to zero. This will mark it for deletion and resubmission.\\  \\  Click {{:images:trash_delete.gif|Trashcan Icon}} to delete the selected row. The row is shaded red to indicate that it will be deleted when the record is saved. |   +^Delete|The trashcan icon is only displayed for new or existing records that have not been submitted to TEA (i.e., the ODS ID is blank or the record is blank or unsaved).\\  \\  Click {{:images:trash_delete.gif|Trashcan Icon}} to delete the selected row. The row is shaded red to indicate that it will be deleted when the record is saved. |   
 ^School Year|Displays the school year of the budget entry. This field cannot be edited. | ^School Year|Displays the school year of the budget entry. This field cannot be edited. |
 ^Fund|Displays the three-digit fund code that identifies the fund group and specific fund (when applicable) for budget data.  | ^Fund|Displays the three-digit fund code that identifies the fund group and specific fund (when applicable) for budget data.  |
Line 59: Line 75:
 ^Budget Amount|Displays the dollar value associated with budget financial account information.| ^Budget Amount|Displays the dollar value associated with budget financial account information.|
 ^Begin Date|Displays the first day for the BudgetAmount.\\  \\  BBB The begin date must be less than or equal to the As-of-Date (PEIMS Fall Snapshot Date).\\  BBB The begin date must be greater than or equal to the School Year start date. | ^Begin Date|Displays the first day for the BudgetAmount.\\  \\  BBB The begin date must be less than or equal to the As-of-Date (PEIMS Fall Snapshot Date).\\  BBB The begin date must be greater than or equal to the School Year start date. |
 +^End Date|Displays the first day after the last day for the BudgetAmount. |
 +^Status|Displays the record status.\\  \\  BBB //N - New//\\  BBB //E - Error//\\ BBB //R - Resubmit//\\ BBB  //S - Successful//    |
 +^Action|Displays the action type for the record.\\  \\  BBB //I - Insert//\\  BBB //D - Delete//\\  BBB //U - Update//\\  \\  <WRAP box> **Note**: Records (rows) marked for deletion (**Action** = //D - Delete//) cannot be modified. Instead, new records (**Status** = //N - New// and **Action** = //I - Insert//) will be created. </WRAP>    |
 +
  
  
Line 66: Line 86:
  
  
-**Payroll Data**:+===== Payroll ===== 
  
-<WRAP box> **Note**:  +{{page>general:tsds_payrollrecordupdates}}
-  * The **Account Code** fields can only be edited for new or existing records until they are submitted to TEA. After TEA submission and assignment of an ODS ID, the **Account Code** becomes read-only. +
-  * Account codes (rows) are validated to prevent duplicate records.  +
-</WRAP> +
  
-^Delete|The trashcan icon is only displayed for new or existing records that have not been submitted to TEA (i.e., the ODS ID is blank or the record is blank or unsaved). To delete a previously submitted record, set its amount to zero. This will mark it for deletion and resubmission.\\  \\  Click {{:images:trash_delete.gif|Trashcan Icon}} to delete the selected row. The row is shaded red to indicate that it will be deleted when the record is saved. |     +^Delete|The trashcan icon is only displayed for new or existing records that have not been submitted to TEA (i.e., the ODS ID is blank or the record is blank or unsaved).\\  \\  Click {{:images:trash_delete.gif|Trashcan Icon}} to delete the selected row. The row is shaded red to indicate that it will be deleted when the record is saved. |     
 ^School Year|Displays the school year of the payroll entry. This field cannot be edited. | ^School Year|Displays the school year of the payroll entry. This field cannot be edited. |
 ^Unique Staff ID|Displays the 10-digit unique staff ID assigned to the staff member by the Texas Education Agency.  | ^Unique Staff ID|Displays the 10-digit unique staff ID assigned to the staff member by the Texas Education Agency.  |
Line 85: Line 103:
 ^Pay Activity|Displays the two-digit payroll activity type of duty for which a staff member receives a salary, salary supplements, or bonuses. | ^Pay Activity|Displays the two-digit payroll activity type of duty for which a staff member receives a salary, salary supplements, or bonuses. |
 ^Begin Date|Displays the first day a staff is paid the PayrollAmount. | ^Begin Date|Displays the first day a staff is paid the PayrollAmount. |
 +^End Date|Displays the first day after the last day a staff was paid the PayrollAmount. |
 +^Status|Displays the record status.\\  \\  BBB //N - New//\\  BBB //E - Error//\\ BBB //R - Resubmit//\\ BBB  //S - Successful//    |
 +^Action|Displays the action type for the record.\\  \\  BBB //I - Insert//\\  BBB //D - Delete//\\  BBB //U - Update//\\  \\  <WRAP box> **Note**: Records (rows) marked for deletion (**Action** = //D - Delete//) cannot be modified. Instead, new records (**Status** = //N - New// and **Action** = //I - Insert//) will be created. </WRAP>    |
    
 VCV Click **+Add** to add a record (row).  VCV Click **+Add** to add a record (row). 
Line 102: Line 123:
  
 {{indexmenu_n>20}} {{indexmenu_n>20}}
- 
tables/districtinformation/fallfinancetsdsdata.1736286101.txt.gz · Last modified: 2025/01/07 21:41 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.