Schedule a demo

Delivering Data You Can Trust

2 min read

How to Accurately Complete PEIMS State Reporting in Texas

June 16, 2022 at 3:55 PM

The Public Education Information Management System (PEIMS) encompasses all data requested and received by Texas Education Agency (TEA) about public education, including student demographic and academic performance, personnel, financial, and organizational information.

Technical support for gathering the data from district databases is supplied by one of the twenty educational service centers (ESCs) or by private vendors. A software system of standard edits, to enhance the quality of data, is used by ESCs and again by the agency on district data submissions. Currently, the major categories of data collected are:

  • organizational
  • budget
  • actual financial
  • staff
  • student demographic
  • program participation
  • school leaver
  • student attendance
  • course completion
  • discipline

TEA manages other collections for evaluation, monitoring, funding, or auditing. Many are automated, electronic collections.

In compliance with the Texas Education Code, PEIMS contains only the data necessary for the legislature and TEA to perform their legally authorized functions in overseeing public education.

That's where Level Data comes in!

Student Information Systems Supported

Complete List of PEIMS Data Validation Rules

Listed below is the complete list of state reporting validation rules we provide for Texas districts using PowerSchool and Skyward to make their PEIMS submission as easy and timely as possible and to maximize both state and federal funding.

PowerSchool

RealTime Validation Rules

Demographics

  • TX: Demographics: Federal Ethnicity
  • TX: Demographics: Home Language Code
  • TX: Demographics: Home Language Survey Date
  • TX: Demographics: Race
  • TX: Demographics: SSN
  • TX: Demographics: Street
  • TX: Demographics: Student Language Code
  • TX: Demographics: Unique Student Identifier

Historical Grades

  • TX: Historical Grades: Alternate Course Number (Manual Entries Only)
  • TX: Historical Grades: ATC Indicator Code
  • TX: Historical Grades: Beginning Date
  • TX: Historical Grades: Class ID Number
  • TX: Historical Grades: College Credit
  • TX: Historical Grades: Credit Type
  • TX: Historical Grades: Dual Credit Indicator Code
  • TX: Historical Grades: Non-Campus Based Ins Code

Special Programs

  • TX: Special Programs: All: Entry Date
  • TX: Special Programs: At-Risk: At-Risk Indicator
  • TX: Special Programs: Career and Tech: CTE Indicator
  • TX: Special Programs: Career and Tech: CTE Indicator Override
  • TX: Special Programs: LEP/EL: Alternative Language Program
  • TX: Special Programs: LEP/EL: Bilingual Program Type
  • TX: Special Programs: LEP/EL: Bilingual/ESL Summer School
  • TX: Special Programs: LEP/EL: ESL Program Type
  • TX: Special Programs: LEP/EL: LEP/EL Indicator
  • TX: Special Programs: LEP/EL: Parental Permission
  • TX: Special Programs: Pre-K: Pre-K Program Type
  • TX: Special Programs: Pre-K: Primary PK Funding Source
  • TX: Special Programs: Pre-K: Secondary PK Funding Source
  • TX: Special Programs: Special Education: District of RDSPD Service
  • TX: Special Programs: Special Education: PPCD Service Location
  • TX: Special Programs: Special Education: Speech Therapy

Staff

  • TX: Staff: Information: Ethnicity
  • TX: Staff: Information: First Name
  • TX: Staff: Information: Gender
  • TX: Staff: Information: Last Name
  • TX: Staff: Information: Middle Name
  • TX: Staff: Information: Race
  • TX: Staff: Information: SSN

State/Province

  • TX: State/Province: Assessment: School Year
  • TX: State/Province: Assessment: SSI Promotion Retention
  • TX: State/Province: Graduation Information: Advanced Measures 1
  • TX: State/Province: Graduation Information: Advanced Measures 2
  • TX: State/Province: Graduation Information: Advanced Measures 3
  • TX: State/Province: Graduation Information: Arts and Humanities Endorsement Indicator Code
  • TX: State/Province: Graduation Information: Assessment Exit Requirement Met Dates – Language Arts
  • TX: State/Province: Graduation Information: Assessment Exit Requirement Met Dates – Mathematics
  • TX: State/Province: Graduation Information: Assessment Exit Requirement Met Dates – Science
  • TX: State/Province: Graduation Information: Assessment Exit Requirement Met Dates – Social Studies
  • TX: State/Province: Graduation Information: Associate Degree Indicator
  • TX: State/Province: Graduation Information: Business and Industry Endorsement Indicator Code
  • TX: State/Province: Graduation Information: Date of Graduation
  • TX: State/Province: Graduation Information: FHSP Distinguished Level Achievement Indicator Code
  • TX: State/Province: Graduation Information: FHSP Participant Code
  • TX: State/Province: Graduation Information: Graduation Type Code
  • TX: State/Province: Graduation Information: Multi-Disciplinary Studies Endorsement Indicator Code
  • TX: State/Province: Graduation Information: Public Services Endorsement Indicator Code
  • TX: State/Province: Graduation Information: STEM Endorsement Indicator Code
  • TX: State/Province: Graduation Information: Texas Grant Indicator
  • TX: State/Province: Manual Flexible Attendance: Attendance Date
  • TX: State/Province: Manual Flexible Attendance: Daily Minutes
  • TX: State/Province: Manual Flexible Attendance: Flexible Attendance Program Type
  • TX: State/Province: Manual Flexible Attendance: School of Enrollment
  • TX: State/Province: PEIMS General Information: ADA Code
  • TX: State/Province: PEIMS General Information: Campus ID of Residence
  • TX: State/Province: PEIMS General Information: ECHS Override
  • TX: State/Province: PEIMS General Information: ECHS Override EXYR
  • TX: State/Province: PEIMS General Information: Entry Date
  • TX: State/Province: PEIMS General Information: Foster Care Indicator
  • TX: State/Province: PEIMS General Information: Military Connected Student
  • TX: State/Province: PEIMS General Information: Student Attribution Code
  • TX: State/Province: PEIMS General Information: T-STEM Override
  • TX: State/Province: PEIMS General Information: T-STEM Override EXYR
  • TX: State/Province: PEIMS General Information: Unaccompanied Youth Status Code
  • TX: State/Province: PEIMS General Information: Unschooled-Asylee/Refugee Code
  • TX: State/Province: Student Contacts: Contact
  • TX: State/Province: Student Contacts: Relationship
  • TX: State/Province: Student Contacts: Start Date
  • TX: State/Province: Student Early Reading: Early Reading Indicator (EOY)
  • TX: State/Province: Student Early Reading: Early Reading Indicator (FALL)
  • TX: State/Province: Student Early Reading: Effective Date
  • TX: State/Province: Student Extended School Year (ESY): Campus ID
  • TX: State/Province: Student Extended School Year (ESY): Contact Hours in Instructional Setting 1
  • TX: State/Province: Student Extended School Year (ESY): Contact Hours in Instructional Setting 2
  • TX: State/Province: Student Extended School Year (ESY): Grade Level Code
  • TX: State/Province: Student Extended School Year (ESY): Instructional Setting 1
  • TX: State/Province: Student Extended School Year (ESY): Instructional Setting 2
  • TX: State/Province: Student Extended School Year (ESY): School Year
  • TX: State/Province: Student Restraints: Campus ID of Restraint
  • TX: State/Province: Student Restraints: Date of Restraint
  • TX: State/Province: Student Restraints: Restraint Instance Number
  • TX: State/Province: Student Restraints: Restraint Reason
  • TX: State/Province: Student Restraints: Restraint Staff Type

Transfer Info

  • TX: Transfer Info: Current Enrollment: Full-Time Equivalency
  • TX: Transfer Info: Current Enrollment: State Grade Level
  • TX: Transfer Info: Previous Enrollment: State Grade Level
 

State Validation Rules

Demographics

  • Age/Grade Level Mismatch
  • Duplicate Race Code
  • Invalid ECHS Override
  • Invalid Foster Care Indicator
  • Invalid Middle Name
  • Invalid SSN/Student ID
  • Invalid Student (Secondary) Language Code
  • Invalid T-STEM Override
  • Missing/Invalid Address Information
  • Missing/Invalid Birth Country
  • Missing/Invalid Date First Enrolled in US Schools
  • Missing/Invalid Date of Birth
  • Missing/Invalid Early Reading Indicator
  • Missing/Invalid Federal Ethnicity
  • Missing/Invalid Federal Race
  • Missing/Invalid First Name
  • Missing/Invalid Gender
  • Missing/Invalid Home Language Survey Date
  • Missing/Invalid Last Name
  • Missing/Invalid Primary (Home) Language Code
  • Missing/Invalid Unique Student Identifier

Enrollment

  • District Entry Date/School Entry Date Mismatch
  • District Entry Grade Level/School Entry Grade Level Mismatch
  • Exit Date Prior to Entry Date
  • Grade Level/Unschooled-Asylee/Refugee Code Mismatch
  • Invalid Course Completion Indicator
  • Invalid Course Sequence Override - Current Courses
  • Invalid Course Sequence Override - Stored Grades
  • Invalid Grade Level for Assigned School
  • Invalid Graduation Type Code
  • Invalid Homeless Status Code
  • Invalid Individual Graduation Committee Graduate Code
  • Invalid Individual Graduation Committee Review Code
  • Invalid Pass/Fail Indicator Code
  • Invalid Section Enrollment Entry Date
  • Invalid Section Enrollment Exit Date
  • Invalid SSI Promotion Retention Code
  • Invalid Unaccompanied Youth Status Code
  • Missing/Invalid ADA Code
  • Missing/Invalid Entry Code
  • Missing/Invalid Entry Date
  • Missing/Invalid Exit Code
  • Missing/Invalid Exit Date
  • Missing/Invalid Full-Time Equivalency
  • Missing/Invalid Next School Indicator
  • Missing/Invalid School ID
  • Missing/Invalid Texas Grant Indicator
  • Next Year School/Next Year Grade Mismatch
  • Overlapping School Enrollments
  • Required Fields for Student Test Record
  • Required Graduation Fields for Graduate Leavers
  • Student Age/Special Education Indicator/ADA Code Mismatch
  • Student Attribution Code/Campus ID of Residence Mismatch
  • Student Attribution Code/Special Education Indicator/ADA Code Mismatch
  • Unaccompanied Youth Status/Homeless Mismatch

Incident Management

  • Invalid Restraint Reason
  • Invalid Restraint Staff Type
  • Misplaced Action
  • Missing Incident Action
  • Missing Incident Behavior
  • Missing Offender
  • Restraint Staff Type/Restraint Reason Mismatch

Staff

  • Invalid Class ID Number
  • Invalid Class Type
  • Invalid Staff Middle Name
  • Invalid Staff Monthly Minutes
  • Missing/Invalid Staff Federal Ethnicity
  • Missing/Invalid Staff Federal Race
  • Missing/Invalid Staff First Name
  • Missing/Invalid Staff Gender
  • Missing/Invalid Staff Last Name
  • Missing/Invalid Staff Service ID
  • Missing/Invalid Staff SSN
  • Required Staff Responsibility Fields by Role ID
  • Staff Responsibility Role ID/Campus ID Mismatch
  • Staff Responsibility Role ID/Instructional Service ID Mismatch
  • Staff Total Years Experience/Years Experience in District Mismatch
  • Staff with two or more Staff IDs

Special Programs

  • At-Risk Indicator/At-Risk Elements Mismatch
  • At-Risk/CTE Indicators Mismatch
  • At-Risk/EB/EL Indicator Mismatch
  • Bilingual Program Type/ESL Program Type Mismatch
  • EB/EL Indicator/Parental Permission Mismatch
  • EB/EL/ESL/Bilingual/Alternative Language/Parental Permission Mismatch
  • Economically Disadvantaged/Transportation CTE Support Service Mismatch
  • Grade Level/Gifted and Talented Indicator Mismatch
  • Instructional Setting/ADA Eligibility Mismatch
  • Invalid Parental Permission
  • Invalid Pre-K Program Type
  • Invalid Preschool Program for Children with Disabilities
  • Invalid Primary Disability
  • Invalid Secondary Pre-K Funding Source
  • Invalid Secondary/Tertiary Disability
  • Missing/Invalid Primary Pre-K Funding Source Code
  • Preschool Program for Children with Disabilities/Instructional Setting/PPCD Service Location Mismatch
  • Primary/Secondary/Tertiary Disability Code Mismatch
  • Restraint Staff Type Code/Primary Disability/Special Education Indicator Mismatch
  • Secondary/Tertiary Disability Code Mismatch
  • Student Age/Child Count Funding Type Mismatch
  • Title I Part A Indicator/Homeless Mismatch
  • Transportation CTE Service/Economic Disadvantaged Status Mismatch

Reports/Lists

  • Duplicate Unique Student Identifier
  • Home Address/Lives With Address Mismatch
  • List of Students Excluded from State Reporting
  • Possible Duplicate Students with Different Student Numbers
 

Skyward

Connect Validation Rules

Special Programs

  • Invalid Lunch Status For Homeless Status
  • Restraint Staff Type/Restraint Reason Mismatch

Staff

  • Staff Marked as Teacher Must Have TSDS ID Populated

Discipline

  • Days Served Must Not Be Between 201 and 260 School Days
  • Discipline Incidents with State Action Codes "05" or "25" and Total Time is Greater than 3 days
  • Discipline Ordered Date Must be between July 1 and June 30 of Current School Year
  • Discipline Records with Matching Incident Numbers Must Not Use Both State Action Code "27 And "28"
  • JJAEP County/ Action Code Mismatch
  • Offense Reason "01" or "59"/ State Location Code Mismatch
  • Offense Reason "04", "05", "06", "07", "27", "28", "49", or "60"/ State Location Code Mismatch
  • Offense Reason "08" / State Location Code Mismatch
  • Offense Reason "09" or "10"/ State Location Code Mismatch
  • Offense Reason "11", "12", "14", "16"-"19", "30"-"32", or "57" / State Location Code Mismatch
  • Offense Reason "21", "22", "23", "41", "55", "56", or "61"/ State Location Code Mismatch
  • Offense Reason "36" or "37" / State Location Code Mismatch
  • Offense Reason other than "21", "22", "23", "41", "55", "56", or "61"/ State Location Code "00" Mismatch
  • Students 10 Years and Older with Expulsion Action Missing Matching Discipline Record
  • Students Under 6 Years Old on Date of Offense /DAEP Action Code Mismatch
  • Total Time and Actual Time must not exceed 10 days for Students with State Offense Code "23"
  • Total Time should not exceed 200 days

Courses

  • Active Courses with No Attached Sections
  • Active Sections with No Attached Meets.
  • If Non Campus Based Instruction Code is "10", then Service ID must be "PES00008" or "PES00011".

Enrollment

  • FHSP Graduation Type Code / FHSP Distinguished Level Mismatch

State Submission

  • Transportation CTE Service/Economic Disadvantaged Status Mismatch

Demographics

  • Missing Primary (Home) Language Code
  • Missing/Invalid Home Language Survey Date

Connect Validation Rules (In Development)

Special Programs

  • Invalid Lunch Status For Homeless Status
  • Restraint Staff Type/Restraint Reason Mismatch

Staff

  • Staff Marked as Teacher Must Have TSDS ID Populated

Discipline

  • Days Served Must Not Be Between 201 and 260 School Days
  • Discipline Incidents with State Action Codes "05" or "25" and Total Time is Greater than 3 days
  • Discipline Ordered Date Must be between July 1 and June 30 of Current School Year
  • Discipline Records with Matching Incident Numbers Must Not Use Both State Action Code "27 And "28"
  • JJAEP County/ Action Code Mismatch
  • Offense Reason "01" or "59"/ State Location Code Mismatch
  • Offense Reason "04", "05", "06", "07", "27", "28", "49", or "60"/ State Location Code Mismatch
  • Offense Reason "08" / State Location Code Mismatch
  • Offense Reason "09" or "10"/ State Location Code Mismatch
  • Offense Reason "11", "12", "14", "16"-"19", "30"-"32", or "57" / State Location Code Mismatch
  • Offense Reason "21", "22", "23", "41", "55", "56", or "61"/ State Location Code Mismatch
  • Offense Reason "36" or "37" / State Location Code Mismatch
  • Offense Reason other than "21", "22", "23", "41", "55", "56", or "61"/ State Location Code "00" Mismatch
  • Students 10 Years and Older with Expulsion Action Missing Matching Discipline Record
  • Students Under 6 Years Old on Date of Offense /DAEP Action Code Mismatch
  • Total Time and Actual Time must not exceed 10 days for Students with State Offense Code "23"
  • Total Time should not exceed 200 days

Courses

  • Active Courses with No Attached Sections
  • Active Sections with No Attached Meets.
  • If Non Campus Based Instruction Code is "10", then Service ID must be "PES00008" or "PES00011".

Enrollment

  • FHSP Graduation Type Code / FHSP Distinguished Level Mismatch

State Submission

  • Transportation CTE Service/Economic Disadvantaged Status Mismatch

Demographics

  • Missing Primary (Home) Language Code
  • Missing/Invalid Home Language Survey Date
 
If you have any questions or would like to request additional rules, please reach out to helpdesk@leveldata.com
Al Momrik
Written by Al Momrik

Al Momrik works at Level Data as a Data Quality Analyst, arriving in 2013. He works primarily with the State Data Validation Suite, a series of services which help PowerSchool users to find errors in their data and correct them in a shorter amount of time. Before coming to Level Data, Al worked in a school district in Michigan for 23 years. He was a Technology Director, a SysAdmin for PowerSchool, and was responsible for all State data submissions. He has worked with PowerSchool since 2007. Al also is a presenter at 6-8 PowerSchool conferences around the country annually.

Post a Comment

Featured Case Studies

Most districts struggle with data quality which influences learning and funding. At Level Data, we provide simple solutions that deliver data districts can trust so they can lead with confidence and focus on what really matters.

Contact Us

269-488-2050 | 866-511-3282

sales@leveldata.com

6850 Stadium Drive
Kalamazoo, MI 49009

Sign up for updates

© 2021 Level Data, Inc. All rights reserved.