District Administration

User Tools

Site Tools

Trace: • attendance_campus_options_alternate_days_pattern • Correct Budget and Payroll data
general:fallpeimsbusiness_financedomain_payrolldata

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
general:fallpeimsbusiness_financedomain_payrolldata [2025/10/07 20:15] – emorenogeneral:fallpeimsbusiness_financedomain_payrolldata [2026/09/25 14:51] (current) – emoreno
Line 1: Line 1:
-==== Verify Payroll data ====+====Correct Budget and Payroll data====
  
  
-[[https://help.ascendertx.com/business/doku.php/payroll/maintenance/staffjobpaydata/distributions|Payroll > Maintenance > Staff Job/Pay Data > Distributions]]+Use the following steps to correct budget and payroll data after accounting period 10 is closed in Finance.
  
-Verify all account codes, amounts, and activity codes.  All employees should have at least one row with **Activity Code**  //78 (non-salary)// or //80 (Base Salary)//.+[[tables:districtinformation:fallfinancetsdsdata|District Administration > Tables > District Information > Fall Finance TSDS Data]]
  
-<WRAP box>**Note**: Activity Code 78 is generally used for Volunteer Services where there is zero pay. If pay should be reported, use Activity Code 79 or 80. +<WRAP round intro>This tab is used to retrieve and edit Fall TSDS financial data, allowing for corrections to Budget and Payroll data in the TSDS staging tables. The staging area temporarily holds data before it is submitted to the Texas Education Agency (TEA) (i.e., promoted to the Operational Data Store (ODS)).
-</WRAP>+
  
-{{:general:finance_domain_distributions_tab.png|Distributions Tab}} 
  
-The following data is reported: +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 in the Budget entity. Users should cross-reference balances with the Finance application and may need to combine amounts to ensure accurate budget reporting.
  
-  * **Amount** - Indicates the dollar value paid to a staff member for a given payroll activity per year. +**Notes**:  
-  * **Account Code** -    +  * Data cannot be duplicated. Duplicated data will receive an error upon submission.  
-    * **Fund** - Identifies the fund group and specific fund (when applicable) for the staff payroll financial data. +  * Enter data carefully on this tab. Incorrect or improperly formatted data may cause errors upon submission.
-    * **Function** - Identifies a general operational area and groups together related activities. +
-    * **Object** - Identifies an account, a transaction, or a source of funds. It indicates the major account group to which a transaction is posted or the associated monies are related. +
-    * **Organization** - Identifies the unique organizational unit within the local education agency with which the account is associated. For campuses, this is the three-digit campus number registered with the Texas Education Agency. For non-campuses, this must be one of the administrative units required in the Resource Guide, or 998 or 999. +
-    * **Fiscal Year** - The last digit of the fiscal year (e.g., the fiscal year is 6 for the 2025-2026 fiscal year). +
-    * **Program Intent** - Identifies the cost of instruction and other services directed toward a particular need of a specific set of students. The intent (the student group toward which the instructional or other service is directed) determines the PayrollProgramIntent, not the demographic makeup of the students served. +
-    * **Activity Code** - Indicates the types of duty for which a staff member receives a salary, salary supplements, or bonuses. PayrollActivity does NOT include fringe benefits such as group health and life insurance, workmen's compensation, sick leave, and others under Object value 6140.+
  
 +**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 remainder of 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.
  
-[[tables:districtinformation:fallfinancetsdsdata|District Administration > Tables > District Information > Fall Finance TSDS 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: 
  
-<WRAP round intro>This tab is used to retrieve and edit Fall TSDS financial data, allowing for corrections to Budget and Payroll data in the TSDS staging tables. The staging area temporarily holds data before it is submitted to the Texas Education Agency (TEA) (i.e., promoted to the Operational Data Store (ODS)).+<div indent> 
 +Navigate to the District Administration > Options > TSDS > Domains & Entities page.
  
 +{{:general:da_doment_extract.png|Domain Entity Extract}}
  
-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.+  * Verify that the** Submission Year** is correct.  
 +  * Click **Extract**.  
 +\\ 
 +Access the ASCENDER DataConnect (ADC). 
 +  * Schedule a run to transfer the changes to the IODS, and if applicable, to the EODS. 
 +</div>
  
 +</WRAP>
  
-  +__Budget__
-**Notes**:  +
-  * This tab becomes available for editing the day after accounting period 10 is closed in Finance. +
-  * 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.+
  
-[[https://help.ascendertx.com/business/doku.php/general/finance_tsdscrosswalk_tables|Finance TSDS Crosswalk Tables]] 
  
-</WRAP>+ 
 +{{:general:fallfinancetsdsdata_budget.png|Fall Finance TSDS Data Budget}} 
 + 
 + 
 +VCV Click {{:images:dropdown.gif|Drop-down Arrow}} to select //1 - Budget//. 
 + 
 + 
 +VCV Make any necessary budget corrections (such as account code or amount changes) to the Budget data in the TSDS staging tables. 
 + 
 +VCV Click **Save**. 
 + 
 +{{page>general:tsds_recordupdates}} 
 + 
 + 
 +---- 
 + 
 +__Payroll__
  
  
Line 52: Line 66:
  
  
 +VCV In the **Unique Staff ID** field, type the 10-digit unique staff ID assigned to the staff member by the Texas Education Agency and click **Retrieve**.
 +
 +
 +VCV Make any necessary payroll corrections (such as account code or amount changes) to the Payroll data in the TSDS staging tables.
 +
 +VCV Click **Save**.
 +
 +{{page>general:tsds_payrollrecordupdates}}
general/fallpeimsbusiness_financedomain_payrolldata.1759868101.txt.gz · Last modified: 2025/10/07 20:15 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.