District Administration

User Tools

Site Tools

Trace: • TSDS Data Quality Checklist
general:fallbusinesspeims_dataqualitytips

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:fallbusinesspeims_dataqualitytips [2025/10/09 21:04] – emorenogeneral:fallbusinesspeims_dataqualitytips [2026/08/14 18:34] (current) – emoreno
Line 6: Line 6:
  
 ^**ASCENDER Breadcrumb**^Step^ ^**ASCENDER Breadcrumb**^Step^
-|[[https://help.ascendertx.com/business/doku.php/finance/inquiry/generalledgerinquiry/generalledgerinquiry|Finance > Inquiry > General Ledger Inquiry]]|Click {{:images:smallpicklist.gif|Ellipsis Icon}} to display all funds. Verify all funds are valid for the 2026 Budget. If not, create TSDS Crosswalks (Fund to Fund).\\  \\  BudgetFund - Table ID C145B| +|[[https://help.ascendertx.com/business/doku.php/finance/inquiry/generalledgerinquiry/generalledgerinquiry|Finance > Inquiry > General Ledger Inquiry]]|Click {{:images:smallpicklist.gif|Ellipsis Icon}} to display all funds. Verify all funds are valid for the 2027 Budget. If not, create TSDS Crosswalks (Fund to Fund).\\  \\  BudgetFund - Table ID C145B| 
-| |Click {{:images:smallpicklist.gif|Ellipsis Icon}} to display all functions. Verify all functions are valid for the 2026 Budget. If not, create TSDS Crosswalks (Function to Function).\\  \\  **TIP**: Expense function codes should not be 00.\\  \\  BudgetFunction - Table ID C146B| +| |Click {{:images:smallpicklist.gif|Ellipsis Icon}} to display all functions. Verify all functions are valid for the 2027 Budget. If not, create TSDS Crosswalks (Function to Function).\\  \\  **TIP**: Expense function codes should not be 00.\\  \\  BudgetFunction - Table ID C146B| 
-| |Click {{:images:smallpicklist.gif|Ellipsis Icon}} to display all objects. Verify all objects are valid for the 2026 Budget. If not, create TSDS Crosswalks (Object to Object).\\  \\  **TIP**: Expense object codes should not end with 0.\\  \\  BudgetObject - Table ID C159B| +| |Click {{:images:smallpicklist.gif|Ellipsis Icon}} to display all objects. Verify all objects are valid for the 2027 Budget. If not, create TSDS Crosswalks (Object to Object).\\  \\  **TIP**: Expense object codes should not end with 0.\\  \\  BudgetObject - Table ID C159B| 
-| |Click {{:images:smallpicklist.gif|Ellipsis Icon}} to display all Program Intent Codes (PICs). Verify all PICs are valid for the 2026 Budget. If not, create TSDS Crosswalks (Program Intent to Program Intent).\\  \\  **TIP**: Expense program intent code should not be 00.\\  \\  BudgetProgramIntent - Table ID C147B| +| |Click {{:images:smallpicklist.gif|Ellipsis Icon}} to display all Program Intent Codes (PICs). Verify all PICs are valid for the 2027 Budget. If not, create TSDS Crosswalks (Program Intent to Program Intent).\\  \\  **TIP**: Expense program intent code should not be 00.\\  \\  BudgetProgramIntent - Table ID C147B\\  \\  Program Intent Codes (PIC) 24, 26, 28, 29, and 30 will remain available for use in the Financial Accountability Resource Guide (FASRG) during fiscal years 2024-2025 and 2025-2026.\\  \\  BBB Beginning fiscal year 2026-2027: PICs 26, 28, 29, and 30 will be removed from the FASRG.\\  \\  BBB School systems are strongly encouraged to continue using PIC 24 internally for budgeting and tracking to maintain clarity and consistency in local documentation and reporting; however, the agency will consolidate the PIC 24 reported expenditures into PIC 11 for state reporting purposes and Public Education Information Management System (PEIMS) financial reports.| 
-| |Click {{:images:smallpicklist.gif|Ellipsis Icon}} to display all organization codes. Verify all organization codes are valid for the 2026 Budget. If not, create TSDS Crosswalks (Org to Org). |+| |Click {{:images:smallpicklist.gif|Ellipsis Icon}} to display all organization codes. Verify all organization codes are valid for the 2027 Budget. If not, create TSDS Crosswalks (Org to Org). |
 | |Verify organizations 001-698 are tied to a campus ID in AskTED. If not, create TSDS crosswalks as needed (Org to Org).| | |Verify organizations 001-698 are tied to a campus ID in AskTED. If not, create TSDS crosswalks as needed (Org to Org).|
 | |Click {{:images:smallpicklist.gif|Ellipsis Icon}} to verify accounts with PIC 91 are using function codes 36, 51 or 52.| | |Click {{:images:smallpicklist.gif|Ellipsis Icon}} to verify accounts with PIC 91 are using function codes 36, 51 or 52.|
 | |Click {{:images:smallpicklist.gif|Ellipsis Icon}} to verify combinations:\\  \\  BBB Org 701-750 should only be used in functions 41, 53, 99\\  BBB Function 71 should be used with object 65XX\\  BBB Funds 205, 255, 270, 429 should be used with PIC 24 rather than 30\\  BBB Expense objects (6XXX) should not be used with Org 000, 709-719, 726-749 or 800-997\\  BBB Expense Objects (6XXX) should not be used with PIC 00\\  BBB Expense Objects (6XXX should not use function 00)\\  \\  [[https://tea.texas.gov/finance-and-grants/financial-accountability/fasrg/fasrg19-module1-far-appendices.pdf|Account Code Matrices in FAR]]|  | |Click {{:images:smallpicklist.gif|Ellipsis Icon}} to verify combinations:\\  \\  BBB Org 701-750 should only be used in functions 41, 53, 99\\  BBB Function 71 should be used with object 65XX\\  BBB Funds 205, 255, 270, 429 should be used with PIC 24 rather than 30\\  BBB Expense objects (6XXX) should not be used with Org 000, 709-719, 726-749 or 800-997\\  BBB Expense Objects (6XXX) should not be used with PIC 00\\  BBB Expense Objects (6XXX should not use function 00)\\  \\  [[https://tea.texas.gov/finance-and-grants/financial-accountability/fasrg/fasrg19-module1-far-appendices.pdf|Account Code Matrices in FAR]]| 
-| |Click {{:images:smallpicklist.gif|Ellipsis Icon}} to verify the fiscal year for PEIMS Budget Funds.  The fiscal year is 6 for the 2025-2026 fiscal year. (Only applies to funds reported for Fall PEIMS:  199, 240, 420, 599)|+| |Click {{:images:smallpicklist.gif|Ellipsis Icon}} to verify the fiscal year for PEIMS Budget Funds.  The fiscal year is 7 for the 2026-2027 fiscal year. (Only applies to funds reported for Fall PEIMS: 199, 240, 420 (Charters), and 599|
 | |Verify expenditures exist for object code 6491 to record Statutorily Required Public Notices.|  | |Verify expenditures exist for object code 6491 to record Statutorily Required Public Notices.| 
 | |Verify at least one account code exists for instructional staff development (function 13) with budget amounts.|  | |Verify at least one account code exists for instructional staff development (function 13) with budget amounts.| 
Line 43: Line 43:
 | |Verify all employees have a **Percent of Day Employed**.| | |Verify all employees have a **Percent of Day Employed**.|
 | |Verify professional staff have **Total** and **In District** years of experience. (exclude current year in count)\\  \\  Total Years Professional Experience| | |Verify professional staff have **Total** and **In District** years of experience. (exclude current year in count)\\  \\  Total Years Professional Experience|
-| |Verify all auxiliary staff have an **Auxiliary Role ID** with a **Begin Date**. Staff who have an **Auxiliary Role ID** should have at least one payroll record coded to object code 612X.\\  \\  Auxiliary Role - Table ID C213|+| |Verify all auxiliary staff have an **Auxiliary Role ID** with a **Begin Date**. Staff who have an **Auxiliary Role ID** should have at least one payroll record coded to object code 612X. For TSDS reporting purposes, multiple auxiliary roles are allowed.\\  \\  Auxiliary Role - Table ID C213|
 | |Verify all paraprofessional staff with a Paraprofessional Certification have **Para Cert** selected with a **Begin Date**.\\  \\  Paraprofessional Certification| | |Verify all paraprofessional staff with a Paraprofessional Certification have **Para Cert** selected with a **Begin Date**.\\  \\  Paraprofessional Certification|
 | |Verify **Employment Status**. Only staff with an **Employment Status** of 01-05 and A are reported to PEIMS. When all employee data is complete and accurate, change the **Employment Status** to include the record in the nightly send job.\\  \\  [[https://help.ascendertx.com/business/doku.php/academy/tsds_bestpractices_newemployees|TSDS Best Practices for New Employee Records]]| | |Verify **Employment Status**. Only staff with an **Employment Status** of 01-05 and A are reported to PEIMS. When all employee data is complete and accurate, change the **Employment Status** to include the record in the nightly send job.\\  \\  [[https://help.ascendertx.com/business/doku.php/academy/tsds_bestpractices_newemployees|TSDS Best Practices for New Employee Records]]|
Line 83: Line 83:
 |[[https://help.ascendertx.com/districtadmin/doku.php/options/tsds/options|District Administration > Options > TSDS > Options]]| Verify that the **As-of-Date** and **School Start Window (SSW) Date** fields have the correct dates.|  |[[https://help.ascendertx.com/districtadmin/doku.php/options/tsds/options|District Administration > Options > TSDS > Options]]| Verify that the **As-of-Date** and **School Start Window (SSW) Date** fields have the correct dates.| 
 | |Ensure that email address(es) are entered under **Finance Extract Distribution List** and **Personnel/Payroll Extract Distribution List**. These designated email addresses allow a person or group of persons to receive extract emails.| | |Ensure that email address(es) are entered under **Finance Extract Distribution List** and **Personnel/Payroll Extract Distribution List**. These designated email addresses allow a person or group of persons to receive extract emails.|
-| [[options:tsds:connection|District Administration > Options > TSDS > Connection]]|Verify the **API URL**, **Key**, and **Secret** are accurate.| +| [[options:tsds:connection|District Administration > Options > TSDS > Connection]]|The key and secret information is only in ASCENDER for Exchange clients. TEA is now separate and has to be set up in ASCENDER DataConnect (ADC).\\  \\  Verify the **API URL**, **Key**, and **Secret** are accurate.| 
 |[[options:tsds:domainsandentities|District Administration > Options > TSDS > Domains & Entities]]|Make selections on **Domains & Entities** as described in the [[https://help.ascendertx.com/districtadmin/doku.php/academy/district_admin_newsy_best_practice_gde|ASCENDER TSDS New School Year Best Practice Guide]].|  |[[options:tsds:domainsandentities|District Administration > Options > TSDS > Domains & Entities]]|Make selections on **Domains & Entities** as described in the [[https://help.ascendertx.com/districtadmin/doku.php/academy/district_admin_newsy_best_practice_gde|ASCENDER TSDS New School Year Best Practice Guide]].| 
  
  
  
general/fallbusinesspeims_dataqualitytips.1760043889.txt.gz · Last modified: 2025/10/09 21:04 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.