Payroll PIC to Responsibility Pop Served Mismatch 

Report Location: Staff > Staff Data Validation > Payroll PIC to Responsibility Pop Served Mismatch

Summary: This report displays staff reporting when payroll program intent codes where the responsibility population served codes potentially do not align. It uses the 30060-Payroll records as the base to compare to the Payroll Program Intent Codes (PIC) to the 30090-Responsibility records Population Served codes.

Usage: Review report to ensure appropriate coding of the payroll program intent codes and the responsibility population served codes. Use export to Excel to remove combination codes that are accurate for your LEA leaving those combinations that need to be modified.

A staff member will be included in the report if they meet any of the criteria in the definitions below. Highlighted PIC codes will indicate that there are PIC code records that do not match any Responsibility _Pop Served Code.

NOTE: In order to avoid duplication of records, this report groups on FUND CODE, CAMPUS/ORGANIZATION AND PIC CODE. As a result, not all details for Payroll or Responsibility Records will display on the report. The hyper-link on the TX Unique Staff ID will open staff profile to review the full details of Payroll Accounting Records and Responsibility Records by inidividual staff.

Data Sources: Fall PEIMS records

• 2024-2025 Ed-Fi reporting
  • Staff Category
    • 30040 – Staff Domain > Staff Entity
    • 30060 – Finance Domain > PayrollExt Entity
    • 30090 – Teacher and Learning Domain > StaffEducationOrganizationAssignmentAssociation Entity

• 2023-2024 and earlier (XML file reporting)
  • InterchangeStaffAssociation
    • 30040 – Staff Extension Complex Type
    • 30060 – Payroll Extension Complex Type
    • 30090 – Staff Responsibilities Extension Complex Type

Definitions:

• Only staff who have both 30060 and 30090 records are included in the analysis (auxiliary staff not included)
• Program Intent E0320 (C147) – 30060
• Population Served E0747 (C030) – 30090
• Staff will be included in the report if:
  • At least one payroll Program Intent = 11-Basic Educational Services and all responsibility Population Served <> 01-Regular Students
  • At least one payroll Program Intent = 21-Gifted & Talented and all responsibility Population Served <> 04-Gifted & Talented Students
  • At least one payroll Program Intent = 22-Career & Technical and all responsibility Population Served <> 05-Career & Technical Students
  • At least one payroll Program Intent = 23-Svcs to Stu w/Disabilities and all responsibility Population Served <> 06-Special Education Students
  • At least one payroll Program Intent = 24-Accelerated Education and all responsibility Population Served <> 03-Compensatory/Remedial Ed Stds
  • At least one payroll Program Intent = 25-Bilingual Ed/Special Language and all responsibility Population Served <> 02-Bilingual Students AND all responsibility Population Served <> 07-ESL Students
  • At least one payroll Program Intent = 26-Non DAEP – AEP Services and all responsibility Population Served <> 01-Regular Students
  • At least one payroll Program Intent = 28-DAEP Basic Services and all responsibility Population Served <> 01-Regular Students
  • At least one payroll Program Intent = 29-DAEP State Compensatory Supplemental Costs and all responsibility Population Served <> 03-Compensatory/Remedial Students
  • At least one payroll Program Intent = 30-Title I Schoolwide/SCE and all responsibility Population Served <> 03-Compensatory/Remedial Ed Stds
  • At least one payroll Program Intent = 33-PreK Svcs to Stu w/Disabilities and all responsibility Population Served <> 06-Special Education Students
  • At least one payroll Program Intent = 36-Early Education and all responsibility Population Served <> 01-Regular Students
  • At least one payroll Program Intent = 37-Dyslexia Regular Ed and all responsibility Population Served <> 01-Regular Students
  • At least one payroll Program Intent = 38-CCMR and all responsibility Population Served <> 01-Regular Students
  • At least one payroll Program Intent = 43-Dyslexia Special Education and all responsibility Population Served <> 06-Special Education Students
  • At least one payroll Program Intent = 91-Athletic Related Services and all responsibility Population Served <> 01-Regular Students
  • At least one payroll Program Intent = 99-Undistributed and all responsibility Population Served <> 01-Regular Students

Features:

• Filters:
  • Year – default is most current Fall PEIMS reporting (Single select)
  • Campus/Orgs – default is all Staff Payroll Organization codes reporting (multi-select)
  • Program Intent (PIC) – default is all Staff Payroll PIC codes reporting (Single Select)
  • Classroom Position/Role ID – default is all Responsibility RoleID reporting (Single Select)
  • Focus List : https://kb.ondatasuite.com/knowledge-base/how-to-use-a-focus-list/
• Drill down on TX Unique Staff ID to review Staff Profile of all staff detailed reporting
  • Use Column Options to add additional columns

Tools Menu:

• Export to Excel
• Bookmark – https://kb.ondatasuite.com/knowledge-base/bookmarking-a-report/
• Report Notes