general:fallbusinesspeims_dataqualitytips
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| general:fallbusinesspeims_dataqualitytips [2025/09/12 15:02] – emoreno | general:fallbusinesspeims_dataqualitytips [2025/10/09 21:04] (current) – emoreno | ||
|---|---|---|---|
| Line 5: | Line 5: | ||
| - | ^**ASCENDER Breadcrumb** ^Step^TSDS Web-Enabled Data Standards (TWEDS)/ | + | ^**ASCENDER Breadcrumb**^Step^ |
| - | |[[https:// | + | |[[https:// |
| - | | |Click {{: | + | | |Click {{: |
| - | | |Click {{: | + | | |Click {{: |
| - | | |Click {{: | + | | |Click {{: |
| | |Click {{: | | |Click {{: | ||
| | |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 {{: | | |Click {{: | ||
| - | | |Click {{: | + | | |Click {{: |
| | |Click {{: | | |Click {{: | ||
| - | | |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.| |
| | |Verify at least one account code exists for general administration (function 41) with budget amounts greater than zero.| | | |Verify at least one account code exists for general administration (function 41) with budget amounts greater than zero.| | ||
| | |Verify at least one account code exists for instructional resources and media services (function 12 and object 6100-6600) with a budget and actual expenditures greater than zero.| | | |Verify at least one account code exists for instructional resources and media services (function 12 and object 6100-6600) with a budget and actual expenditures greater than zero.| | ||
| | |Verify at least one account code exists for guidance, counseling, evaluation services or social work services or health services in function 31-33, object 6100-6600 with amounts greater than zero.| | | |Verify at least one account code exists for guidance, counseling, evaluation services or social work services or health services in function 31-33, object 6100-6600 with amounts greater than zero.| | ||
| - | | |Verify at least one account code exists with object code 6212 for audit services. | + | | |Verify at least one account code exists with object code 6212 for audit services. | |
| - | | |Verify one account code exists for Matching State Funds (object 5829) in funds 240 and 410.| | | + | | |Verify one account code exists for Matching State Funds (object 5829) in funds 240 and 410.| |
| | |Verify budgets in object 65XX are tied to function 71.| | | |Verify budgets in object 65XX are tied to function 71.| | ||
| Line 30: | Line 30: | ||
| **Active Employees**: | **Active Employees**: | ||
| - | ^**ASCENDER Breadcrumb** ^Step^TWEDS/FAR Reference^ | + | ^**ASCENDER Breadcrumb**^Step^ |
| - | |[[https:// | + | |[[https:// |
| - | |[[https:// | + | |[[https:// |
| - | | |Ensure all TIA teachers have TIA data added. | + | | |Ensure all TIA teachers have TIA data added. |
| - | |[[https:// | + | |[[https:// |
| - | | |Responsibility records with a **Staff Service** beginning with SE must have **Pop Served** set to 06.|[[https:// | + | | |Responsibility records with a **Staff Service** beginning with SE must have **Pop Served** set to 06.\\ \\ |
| - | | |Responsibility records for aides must have **Number of Students** set to 0|. | + | | |Responsibility records for aides must have **Number of Students** set to 0.| |
| - | |[[https:// | + | |[[https:// |
| - | | |Verify **Employee Status** is 1-5 or A when data is ready to be sent. (**TIP**: It is recommended to set the Employee Status to 0 - Pending while gathering required data elements.|[[https:// | + | | |Verify **Employee Status** is 1-5 or A when data is ready to be sent. (**TIP**: It is recommended to set the Employee Status to 0 - Pending while gathering required data elements.\\ \\ [[https:// |
| | |Verify all employees with a **Latest Re-employment Date** do not have a **Termination Date**. For re-hires, delete the **Termination Date** and **Reason**.| | | |Verify all employees with a **Latest Re-employment Date** do not have a **Termination Date**. For re-hires, delete the **Termination Date** and **Reason**.| | ||
| | |Verify all regular employees have a **Highest Degree**.| | | |Verify all regular employees have a **Highest Degree**.| | ||
| | |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)|[[https:// | + | | |Verify professional staff have **Total** and **In District** years of experience. (exclude current year in count)\\ \\ |
| - | | |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.|[[https:// | + | | |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.\\ \\ |
| - | | |Verify all paraprofessional staff with a Paraprofessional Certification have **Para Cert** selected with a **Begin Date**.|[[https:// | + | | |Verify all paraprofessional staff with a Paraprofessional Certification have **Para Cert** selected with a **Begin Date**.\\ \\ |
| - | | |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:// | + | | |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:// | + | |[[https:// |
| - | | |Ensure all reported staff have a **Percent of Days Employed**.|[[https:// | + | | |Ensure all reported staff have a **Percent of Days Employed**.\\ \\ StaffEducationOrganizationEmploymentAssociation Entity| |
| **Terminated Employees**: | **Terminated Employees**: | ||
| - | |[[https:// | + | ^**ASCENDER Breadcrumb**^Step^ |
| + | |[[https:// | ||
| | |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.| | ||
| | |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:// | + | |[[https:// |
| |[[https:// | |[[https:// | ||
| + | |[[https:// | ||
| ===== Payroll Data ===== | ===== Payroll Data ===== | ||
| - | ^**ASCENDER Breadcrumb** ^Step^TWEDS/FAR Reference^ | + | ^**ASCENDER Breadcrumb** ^Step^ |
| - | |[[https:// | + | |[[https:// |
| - | | |Verify admin staff coded to functions 41, 53, or 99 use valid org codes 701-750|[[https:// | + | | |Verify admin staff coded to functions 41, 53, or 99 use valid org codes 701-750.\\ \\ |
| - | | |Verify program intent codes on all payroll. | + | | |Verify program intent codes on all payroll. |
| | |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.| | ||
| - | |[[https:// | + | |[[https:// |
| - | + | ||
| - | + | ||
| - | ===== Finance Data (Prior Year) ===== | + | |
| - | + | ||
| - | ^**ASCENDER Breadcrumb** ^Step^TWEDS/ | + | |
| - | |[[https:// | + | |
| - | | |Click {{: | + | |
| - | | |Click {{: | + | |
| - | | |Click {{: | + | |
| - | | |Click {{: | + | |
| - | | |Verify organizations 001-698 are tied to a campus ID in AskTED. If not, create TSDS crosswalks as needed (Org to Org).| | + | |
| - | | |Click {{: | + | |
| - | | |Click {{: | + | |
| - | | |Click {{: | + | |
| - | | |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 actual expenditures greater than zero.| | + | |
| - | | |Verify at least one account code exists for general administration (function 41) with actual expenditures greater than zero. | | + | |
| - | | |Verify at least one account code exists for instructional resources and media services (function 12 and object 6100-6600) with a budget and actual expenditures greater than zero.| | + | |
| - | | |Verify at least one account code exists for guidance, counseling, evaluation services or social work services or health services in function 31-33, object 6100-6600 with amounts greater than zero.| | + | |
| - | | |Verify at least one account code exists with object code 6212 for audit services.| | + | |
| - | | |Verify actual expenditures are reported in Fund 199, object 6144.| | + | |
| - | | |Verify expenditure accounts with function 91 or 92 (if applicable), | + | |
| - | | |Verify one account code exists for Matching State Funds (object 5829) in funds 240 and 410.| | + | |
| - | |[[https:// | + | |
| Line 102: | Line 80: | ||
| </ | </ | ||
| - | | |[[https:// | + | ^**ASCENDER Breadcrumb**^Step^ |
| - | | |Verify that the **As-of-Date** and **School Start Window (SSW) Date** fields have the correct dates.| | + | |[[https:// |
| | |Ensure that email address(es) are entered under **Finance Extract Distribution List** and **Personnel/ | | |Ensure that email address(es) are entered under **Finance Extract Distribution List** and **Personnel/ | ||
| - | | |[[options: | + | | [[options: |
| - | | |Verify the **API URL**, **Key**, and **Secret** are accurate.| | + | |[[options: |
| - | | |[[options: | + | |
| - | | |Make selections on **Domains & Entities** as described in the [[https:// | + | |
general/fallbusinesspeims_dataqualitytips.1757689358.txt.gz · Last modified: 2025/09/12 15:02 by emoreno