User Tools

Site Tools


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 [2026/01/07 19:16] – emorenogeneral:fallbusinesspeims_dataqualitytips [2026/09/25 20:24] (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\\  \\  BBB As of the 2026-2027 fiscal year, the following PICS will be removed from the Financial Accountability Resource Guide (FASRG): PICs 26, 28, 29, and 30.\\  \\  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, TEA 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\\  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/data-reports/financial-accountability/fasrg/fasrg20-matrices-districts-clean.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 31: Line 31:
  
 ^**ASCENDER Breadcrumb**^Step^ ^**ASCENDER Breadcrumb**^Step^
-|[[https://help.ascendertx.com/business/doku.php/personnel/maintenance/staffdemo/demographicinformation|Personnel > Maintenance > Staff Demo > Demographic Information]]|Verify the following fields are completed for all regular employees, contracted instructional staff, and long-term substitutes:\\  \\  BBB **Texas Unique Staff ID**\\  BBB **DOB**\\  BBB **Sex**\\  BBB **Race**\\  BBB **Ethnicity**\\  \\  Generate a user-created report to verify accuracy.\\  \\  Staff Entity|+|[[https://help.ascendertx.com/business/doku.php/personnel/maintenance/staffdemo/demographicinformation|Personnel > Maintenance > Staff Demo > Demographic Information]]|Verify the following fields are completed for all regular employees, contracted instructional staff, and long-term substitutes:\\  \\  BBB **Name (Legal)**\\  BBB **Texas Unique Staff ID**\\  BBB **DOB**\\  BBB **Sex**\\  BBB **Race**\\  BBB **Ethnicity**\\  \\  Generate a user-created report to verify accuracy.\\  \\  Staff Entity|
 |[[https://help.ascendertx.com/business/doku.php/personnel/maintenance/staffdemo/credentials|Personnel > Maintenance > Staff Demo > Credentials]]|Ensure the PK Teacher Specialization is added to all PK Teachers of Record.\\  \\  PK Teacher Requirement - Table ID C207| |[[https://help.ascendertx.com/business/doku.php/personnel/maintenance/staffdemo/credentials|Personnel > Maintenance > Staff Demo > Credentials]]|Ensure the PK Teacher Specialization is added to all PK Teachers of Record.\\  \\  PK Teacher Requirement - Table ID C207|
 | |Ensure all TIA teachers have TIA data added.  If TIA eligible, generate a user-created report to ensure they also have **Creditable Years of Service**. This is reported in Class Roster.\\  \\  TIA Designation - Table ID C322| | |Ensure all TIA teachers have TIA data added.  If TIA eligible, generate a user-created report to ensure they also have **Creditable Years of Service**. This is reported in Class Roster.\\  \\  TIA Designation - Table ID C322|
Line 54: Line 54:
 |[[https://help.ascendertx.com/business/doku.php/personnel/maintenance/employmentinfo|Personnel > Maintenance > Employment Info]]|Verify the employee record has a **Termination Date** and **Termination Reason**.\\  \\  [[https://help.ascendertx.com/business/doku.php/academy/tsds_bestpractices_termemployees|TSDS Best Practices for Terminated Employee Records]]|  |[[https://help.ascendertx.com/business/doku.php/personnel/maintenance/employmentinfo|Personnel > Maintenance > Employment Info]]|Verify the employee record has a **Termination Date** and **Termination Reason**.\\  \\  [[https://help.ascendertx.com/business/doku.php/academy/tsds_bestpractices_termemployees|TSDS Best Practices for Terminated Employee Records]]| 
 | |Verify the employee record has an **End Date** for the **Auxiliary Role ID** and/or **Paraprofessional Certification**.| | |Verify the employee record has an **End Date** for the **Auxiliary Role ID** and/or **Paraprofessional Certification**.|
-| |Select **Extract for TSDS** to include the employee in TSDS Staff Domain extracts regardless of their employment status.|+| |If the staff member is employed on the Snapshot date, select **Extract for TSDS** to include the employee in TSDS Staff Domain extracts regardless of their employment status.|
 | |Verify the employee record has an updated **Employment Status**, if not, select the appropriate code.|  | |Verify the employee record has an updated **Employment Status**, if not, select the appropriate code.| 
 |[[https://help.ascendertx.com/business/doku.php/personnel/maintenance/staffdemo/responsibility|Personnel > Maintenance > Staff Demo > Responsibility]]|Verify the employee record has an **End Date** on the Responsibility record if one exists.\\  \\  [[https://help.ascendertx.com/business/doku.php/academy/tsds_bestpractices_termemployees|TSDS Best Practices for Terminated Employee Records]]|  |[[https://help.ascendertx.com/business/doku.php/personnel/maintenance/staffdemo/responsibility|Personnel > Maintenance > Staff Demo > Responsibility]]|Verify the employee record has an **End Date** on the Responsibility record if one exists.\\  \\  [[https://help.ascendertx.com/business/doku.php/academy/tsds_bestpractices_termemployees|TSDS Best Practices for Terminated Employee Records]]| 
Line 64: Line 64:
  
 ^**ASCENDER Breadcrumb** ^Step^ ^**ASCENDER Breadcrumb** ^Step^
-|[[https://help.ascendertx.com/business/doku.php/payroll/reports/usercreatedreports/hrreport|Payroll > Reports > User Created Report]]|Review employee distributions. Verify organization codes on all payroll. No payroll expenditure codes should use org 000, 700, 709-719, 726-749, or 800-997.\\  \\  [[https://tea.texas.gov/finance-and-grants/financial-accountability/fasrg/fasrg19-module1-far-appendices.pdf|Account Code Matrices in FAR]]|  +|[[https://help.ascendertx.com/business/doku.php/payroll/reports/usercreatedreports/hrreport|Payroll > Reports > User Created Report]]|Review employee distributions. Verify organization codes on all payroll. No payroll expenditure codes should use org 000, 700, 709-719, 726-749, or 800-997.\\  \\  [[https://tea.texas.gov/data-reports/financial-accountability/fasrg/fasrg20-matrices-districts-clean.pdf|Account Code Matrices in FAR]]|  
-| |Verify admin staff coded to functions 41, 53, or 99 use valid org codes 701-750.\\  \\  [[https://tea.texas.gov/finance-and-grants/financial-accountability/fasrg/fasrg19-module1-far-appendices.pdf|Account Code Matrices in FAR]]|  +| |Verify admin staff coded to functions 41, 53, or 99 use valid org codes 701-750.\\  \\  [[https://tea.texas.gov/data-reports/financial-accountability/fasrg/fasrg20-matrices-districts-clean.pdf|Account Code Matrices in FAR]]|  
-| |Verify program intent codes on all payroll.  No payroll program intent codes should use org 00.\\  \\  [[https://tea.texas.gov/finance-and-grants/financial-accountability/fasrg/fasrg19-module1-far-appendices.pdf|Account Code Matrices in FAR]]| +| |Verify program intent codes on all payroll. No payroll program intent codes should be org 00.\\  \\  [[https://tea.texas.gov/data-reports/financial-accountability/fasrg/fasrg20-matrices-districts-clean.pdf|Account Code Matrices in FAR]]| 
 | |Verify all staff have at least one payroll code with a Payroll Activity code of 80.| | |Verify all staff have at least one payroll code with a Payroll Activity code of 80.|
 | |Staff paid with object 6129 must have an **Auxiliary Role ID** or responsibility with **Staff Classification** of 033 or 036 or Classroom Position record of 05 in the Schedule.| | |Staff paid with object 6129 must have an **Auxiliary Role ID** or responsibility with **Staff Classification** of 033 or 036 or Classroom Position record of 05 in the Schedule.|
Line 72: Line 72:
  
  
- +<WRAP center round alert> 
- +The District PEIMS Coordinator is responsible for setting up the following, unless other arrangements have been established. 
-\\   +
-<WRAP center round alert >The District PEIMS Coordinator is responsible for setting up the following, unless other arrangements have been established. +
  
 **Do not** make changes to this information unless authorized. **Do not** make changes to this information unless authorized.
Line 83: Line 81:
 |[[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]].|  +
- +
- +
general/fallbusinesspeims_dataqualitytips.1767813393.txt.gz · Last modified: 2026/01/07 19:16 by emoreno