ElevatePEIMS Rule Library Extended Year Submission Scorecard
This document outlines the Extended Year Submission Scorecard for ElevatePEIMS, which includes over 180 validation rules currently active in the system. Each rule includes a Rule ID, the Submission Code(s) it applies to, and a brief description of its logic or validation behavior.
These rules help ensure data reported by Local Education Agencies (LEAs) meets TEA standards before official submission. This scorecard is intended for all users, and rules may continue to expand as TEA requirements evolve.
Rule ID | Submission Codes | Description |
10010-0015 | 1234 | For each Local Education Agency's data submission, there must be data reported for the LEA itself. |
10020-0005 | 1234 | The last three characters of SchoolId must be "001"-"698". |
10020-000F | 4 | For a Campus/School being reported for PEIMS Submission 4 (Extended Year) the following must be provided: Local EducationAgency (Local EducationAgencyId, Local EducationAgencyCategory), and ExpandedLearning Opportunity. |
10020-0012 | 34 | SchoolId must match an entry registered with TEA as an active instructional campus. |
10020-0048 | 134 | For each campus registered with TEA as an approved Texas Science, Technology, Engineering, and Mathematics (T-STEM) Academy campus, there should be at least one student with a StudentCharacteristic of T-STEM ("05"), or else a warning will display for verification. |
10020-0049 | 134 | For each campus registered with TEA as an approved Early College High School (ECHS) campus, there should be at least one student with a StudentCharacteristic of ECHS ("06"), or else a warning will display for verification. |
10020-0050 | 134 | For each campus registered with TEA as an approved campus to run a Pathways in Technology (P-TECH) program, there should be at least one student with a StudentCharacteristic of P-TECH ("07"), or else a warning will display for verification. |
10020-0051 | 34 | If ExpandedLearning Opportunity is TRUE, then at least one ELOType and at least one ELOActivity must be reported. |
10020-0052 | 34 | If ExpandedLearning Opportunity is FALSE or not reported, then ELOType and ELOActivity data must not be reported. |
10020-0055 | 4 | If ELOType is not blank, then ELOType must be "04". |
10020-0057 | 134 | For each campus that has entered into an agreement with the New Tech Network to operate as a New Tech Network campus, there should be at least one student with a StudentCharacteristic of "08" (New Tech), or else a warning will display for verification. |
10020-0061 | 4 | If this SchoolId is registered with TEA as an active instructional campus serving any of the grade levels "PK", "KG", or "01"-"05", then Additional Days Program must not be blank. |
10020-0062 | 4 | If Additional Days Program is TRUE, then there should be at least one student reported with a StudentCharacteristic of Additional Days Program Participation ("20"). |
10020-0063 | 4 | If Additional Days Program is TRUE, then there must be at least one staff person with Additional Days Program Teacher of TRUE. |
10200-0021 | 34 | EndDate must be greater than or equal to BeginDate. |
10200-0056 | 34 | EndDate should be greater than BeginDate. |
10200-0061 | 4 | If a ReportingPeriodExt is reported, then Reporting Period must be "7", "8", or "9". |
10200-0062 | 4 | If a Calendar is reported, then Calendar Type must be "16" or "17". |
30040-0003 | 14 | Each character of StaffId must not be the same number. |
30040-0004 | 14 | The first three characters of StaffId must be between "001" and "899" (excluding "666"), the fourth and fifth characters must be between "01" and "99", and the last four characters must be between "0001" and "9999". |
30040-0005 | 14 | StaffId must be 9 numeric characters. |
30040-0008 | 14 | A staff person's age on the PEIMS Fall snapshot date of the current school year must be between 14 and 98 years old. |
30040-0009 | 14 | Each staff person must be reported with at least one value for Race. |
30040-000E | 14 | For Staff data being reported for PEIMS Submission 1 (Fall) or PEIMS Submission 4 (Extended Year) the following must be reported: BirthDate, Sex, HispanicLatinoEthnicity, StaffTypeSet (StaffType, BeginDate), HighestCompletedLevelOfEducation, and at least one Race. |
30040-0014 | 14 | Total Years ProfExperience must be greater than or equal to YearsExperienceInDistrict. |
30040-0015 | 14 | If a StaffId matches a StudentId, then FirstName, LastSurname, and BirthDate must also match. |
30040-0016 | 14 | If a staff person is 18 years old or younger on the PEIMS Fall snapshot date, then TotalYears Prof Experience must be 0. |
30040-0018 | 14 | Total Years Prof Experience should be less than 41. |
30040-0019 | 14 | Years ExperienceInDistrict should be less than 41. |
30040-0022 | 14 | FirstName, MiddleName, and/or LastSurname should not end with "JR", "SR", "I", "II", "III", "IV", "V", "VI", "VII", "VIII", "IX", or "X" (not case sensitive). |
30040-0023 | 14 | A staff person's age on the PEIMS Fall snapshot date of the current school year should be between 16 and 75 years old. |
30040-0024 | 14 | FirstName, LastSurname, Sex, and BirthDate should not be identical on staff reported with two or more different StaffIds. |
30040-0048 | 14 | StaffId must not match StaffId for any other staff person reported for this LEA. |
30040-0053 | 4 | For a particular StaffUniqueId reported for PEIMS Submission 4 (Extended Year), there must be at least one StaffSectionAssociation reported. |
30040-0060 | 14 | For Staff data being reported for PEIMS Submission 1 (Fall) or PEIMS Submission 4 (Extended Year), if at least one professional StaffClassification (any value other than "033" and "036") is reported, then the following must be reported: Years ExperienceInDistrict and Total Years ProfExperience. |
30090-0122 | 4 | ClassroomPosition must be "01", "02", "03", or "04". |
30090-0123 | 4 | Additional Days Program Teacher must be TRUE. |
30090-0125 | 4 | If Additional Days Program Teacher is TRUE, then CourseCode for the CourseOffering of this staff person's StaffSectionAssociations must not be a high school course (Eligible for State HS Credit = "Y"). |
30090-0126 | 4 | If Additional Days Program Teacher is TRUE, then the following must not be blank: NumberOfStudentsInClass, and Class Type on the corresponding Section. |
30305-0003 | 4 | SchoolId for the CourseOffering of a StaffSectionAssociation must match an entry registered with the TEA as an active instructional campus in the reporting LEA ending in "001"-"698". |
40100-0000 | 4 | For a StudentEducationOrganizationAssociation being reported for PEIMS Submission 4 (Extended Year) the following must be provided: HispanicLatinoEthnicity, and at least one Race. |
40100-0012 | 134 | The first character of StudentId must be "S" or "0"-"8". |
40100-0013 | 1 | Each character of StudentId must not be the same number. |
40100-0014 | 134 | If StudentId does not have a first character of "S", then the first three characters of StudentId must be between "001" and "899" (excluding "666"). |
40100-0015 | 134 | If StudentId does not have a first character of "S", then the fourth and fifth characters must not be "00", and the last four characters must not be "0000". |
40100-0018 | 134 | BirthDate must not be equal to or greater than the PEIMS Fall snapshot date for PEIMS Submission 1 (Fall); otherwise BirthDate must not be equal to or greater than the submission date for PEIMS Submission 3 (Summer) and Submission 4 (Extended Year). |
40100-0035 | 134 | Each student must be reported with at least one value for Race. |
40100-0058 | 134 | If a student's age on September 1 of the current school year is less than 3, then EntryGradeLevel should be "EE". |
40100-0078 | 134 | A student's September 1 age should not be greater than 25. |
40100-0079 | 134 | FirstName, MiddleName, or LastSurname should not contain "0"-"9". |
40100-0080 | 134 | FirstName, MiddleName, and/or LastSurname should not end with "JR", "SR", "I", "II", "III", "IV", "V", "VI", "VII", "VIII", "IX", or "X" (not case sensitive). |
40100-0085 | 134 | If EntryGradeLevel is "EE", then September 1 age should be less than 6. |
40100-0086 | 134 | If EntryGradeLevel is "PK", then September 1 age should be 3 or 4. |
40100-0087 | 134 | If EntryGradeLevel is "KG", then September 1 age should be 5 or 6. |
40100-0088 | 134 | If EntryGradeLevel is "12", then September 1 age should be 16-25. |
40100-0091 | 134 | If there are any students where MiddleName is blank, then a warning message showing the total number of students in this category will be issued asking for verification. |
40100-0120 | 134 | On the PEIMS Fall snapshot date, or on the submission date for PEIMS Submission 3 (Summer) or PEIMS Submission 4 (Extended Year), if FosterCareType is "2" or "3", then EntryGradeLevel must be "PK". |
40100-0136 | 134 | For this StudentUniqueId, Sex must be "F" or "M" in the TSDS Unique ID system. |
40100-0148 | 134 | On the PEIMS Fall snapshot date, or on the submission date for PEIMS Submission 3 (Summer) or PEIMS Submission 4 (Extended Year), if a StudentCharacteristic of T-STEM ("05") is reported, then EntryGradeLevel must be "06"-"12". |
40100-0149 | 134 | On the PEIMS Fall snapshot date, or on the submission date for PEIMS Submission 3 (Summer) or PEIMS Submission 4 (Extended Year), if a StudentCharacteristic of ECHS ("06") is reported, then EntryGradeLevel must be "09"-"12". |
40100-0153 | 134 | StudentId must not match StudentId for any other student reported for this LEA. |
40100-0168 | 134 | On the PEIMS Fall snapshot date, or on the submission date for PEIMS Submission 3 (Summer) or PEIMS Submission 4 (Extended Year), if a StudentCharacteristic of "07" (P-TECH) is reported, then EntryGradeLevel must be "09"-"12". |
40100-0175 | 134 | CrisisEvent must not be reported. |
40100-0194 | 134 | On the PEIMS Fall snapshot date, or on the submission date for PEIMS Submission 3 (Summer) or PEIMS Submission 4 (Extended Year), if a StudentCharacteristic of "08" (New Tech) is reported, then EntryGradeLevel must be "07"-"12". |
40110-0001 | 134 | For each student reported with enrollment data, there must be corresponding student data reported. |
40110-000F | 34 | For a StudentSectionAssociation being reported for the PEIMS Submission 3 (Summer) or PEIMS Submission 4 (Extended Year), the following must be provided: EndDate. |
40110-0023 | 134 | If EntryGradeLevel is "EE" or "PK", then a StudentCharacteristic of Gifted And Talented ("15") must not be reported. |
40110-0042 | 134 | At least one student should have a StudentCharacteristic of Gifted And Talented ("15"). |
40110-0081 | 34 | For a StudentSectionAssociation, EndDate must be greater than or equal to BeginDate. |
40110-0084 | 134 | On the PEIMS Fall snapshot date, if StudentAttribution is "02", then a CampusIdOfResidence must be reported, and must not be a DAEP or JJAEP, and the first six characters must match the reporting LEA. |
40110-0097 | 134 | CampusIdOfResidence must be "255000000" or match an entry registered with the TEA as an active instructional campus ending in "001"-"698", but must not be a charter, a JJAEP, Texas School for the Deaf (227906), Texas School for the Blind and Visually Impaired (227905), Texas Juvenile Justice Department (227622), South Texas ISD (031916), Windham School District (236903), Texas Tech University K-12 (152504), or University of Texas at Austin HS (227506). |
40110-0098 | 134 | CampusIdOfResidence must be reported, and the first six characters must not match the reporting LEA. |
40110-0099 | 134 | For each student in the Texas School for the Deaf (227906), the Texas School for the Blind and Visually Impaired (227905), or South Texas ISD (031916), the CampusIdOfResidence must be reported. |
40110-0100 | 134 | CampusIdOfResidence should not be a campus registered with TEA as an alternative education program (AEP) campus or a disciplinary alternative education program (DAEP) campus. |
40110-0105 | 4 | Student Attribution must not be "12". |
40110-0106 | 134 | StudentAttribution must not be "03". |
40110-0107 | 134 | StudentAttribution must not be "01" or "30". |
40110-0108 | 134 | StudentAttribution should be "01" or "30". |
40110-0109 | 134 | StudentAttribution should not be "06". |
40110-0110 | 134 | If StudentAttribution is "12", "22", "24", "26", or "28", then CampusIdOfResidence must be blank/not reported. |
40110-0111 | 134 | If StudentAttribution is "03", "06", "07", "10", or "32", then CampusIdOfResidence must be reported and the first six characters must not match the reporting LEA. |
40110-0112 | 134 | If StudentAttribution is "07", then CampusIdOfResidence must be "255000000". |
40110-0113 | 134 | If CampusIdOfResidence is "255000000", then StudentAttribution must be "07". |
40110-0114 | 134 | If StudentAttribution is "21", "23", "25", or "27", then CampusIdOfResidence should not be blank and the first six characters should not match the reporting LEA. |
40110-0118 | 4 | If this student is reported with a StudentCharacteristic of Bilingual/ESL Summer School ("19"), then EntryGradeLevel must be "EE", "PK", "KG" or "01" at the same time. |
40110-0165 | 34 | For each StudentSectionAssociation, EndDate must be between June 1, 2024 and August 31, 2025. |
40110-0166 | 34 | For each Student SectionAssociation, EndDate must be between June 1, 2024 and August 31, 2025. |
40110-0193 | 134 | If StudentAttribution is "10", then SchoolId must be in the Texas School for the Deaf (227906). |
40110-0194 | 134 | If StudentAttribution is "29", then SchoolId must be in South Texas ISD (031916). |
40110-0221 | 4 | If this student is reported with a StudentCharacteristic of Additional Days Program Participation ("20"), then EntryGradeLevel must be "PK", "KG", "01", "02", "03", "04", or "05" at the same time. |
40110-0222 | 4 | If this student is reported with a StudentCharacteristic of Additional Days Program Participation ("20"), then this student must be reported with BasicReporting PeriodAttendance for ReportingPeriod "9". |
42400-0002 | 34 | SchoolId must match an entry registered with the TEA as an active instructional campus in the reporting LEA ending in "001"-"698". |
42400-0003 | 34 | The first six characters of SchoolId must not be a Local Education Agency registered with the TEA as an ESC. |
42400-0007 | 34 | The last character of Total EligibleDays Present must be either "0" or "5". |
42400-0017 | 34 | For a particular SchoolId, CalendarCode, and Reporting Period, NumberDays Taught must be identical on all BasicReporting PeriodAttendance. |
42400-0067 | 34 | For a particular SchoolId and CalendarCode reported on BasicReporting PeriodAttendance data, there must be a Calendar with a matching SchoolId and CalendarCode. |
42400-0069 | 34 | For a particular SchoolId, CalendarCode, and Reporting Period, the NumberDays Taught must be identical on all BasicReporting PeriodAttendance and Flexible Regular Program Reporting PeriodAttendance. |
42400-0075 | 4 | Reporting Period must be "9". |
42400-0076 | 4 | If Reporting Period is "9", then this student must be reported with a StudentCharacteristic of Additional Days Program Participation ("20"). |
42400-0086 | 4 | For each BasicReporting PeriodAttendance data item, the sum of TotalEligibleDays Present must not be greater than NumberDays Taught. |
42400-0087 | 4 | For each BasicReporting PeriodAttendance data item reported for PEIMS Submission 4 (Extended Year), Total EligibleDays Present must be greater than 0. |
42400-0089 | 4 | If Reporting Period is "9", then GradeLevel must be "PK", "KG", "01", "02", "03", "04", or "05". |
42401-0001 | 34 | If Total Elig BilingualESLDays Present is not blank, then the last character of TotalElig Bilingual ESL Days Present must be either "0" or "5". |
42401-0002 | 34 | If Total Elig PregRelSvcsDays Present is not blank, then the last character of Total Elig Preg RelSvcsDays Present must be either "0" or "5". |
42401-0003 | 34 | If Total EligSpEdMainstream Days Present is not blank, then the last character of TotalEligSpEdMainstream Days Present must be either "0" or "5". |
42401-0004 | 34 | For each Bilingual ESL Program Reporting Period Attendance data item, if GradeLevel is "EE", then TotalEligBilingualESLDays Present should generally be 0.0 or blank. |
42401-0005 | 34 | For a particular StudentUniqueId, SchoolId, CalendarCode, and Reporting Period, if TotalElig Bilingual ESLDays Present is greater than 0, and BilingualESLFunding is "BE" or "D1", then EmergentBilingualIndicator must be "1". |
42401-0008 | 34 | For a particular StudentUniqueId, If Total EligPreg RelSvcsDays Present is greater than 0, then Sex must be "F" for the student. |
42401-0009 | 34 | For each Special Programs Reporting PeriodAttendance data item, if GradeLevel is "EE", "PK", "KG", "01", "02", or "03", then TotalElig PregRelSvcsDays Present should be 0.0 or blank. |
42401-0013 | 34 | The Texas School for the Deaf (227906), the Texas School for the Blind and Visually Impaired (227905), and the Texas Juvenile Justice Department (227622) must not submit BilingualESLProgram Reporting PeriodAttendance. |
42401-0014 | 34 | For the Texas Juvenile Justice Department (227622), the following fields must all be 0.0 or blank/not reported: Flex Total Elig Preg RelSvcsDays Present and Flex TotalEligSpEdMainstream Days Present. |
42401-0016 | 4 | Reporting Period must be "7", "8", or "9". |
42401-0020 | 34 | For each BilingualESL Program Reporting PeriodAttendance data item, if the matching BasicReporting Period Attendance has TotalDaysAbsent equal to 0.0, then Total Elig BilingualESLDays Present must be greater than 0. |
42401-0027 | 34 | For the Texas School for the Deaf (227906), the Texas School for the Blind and Visually Impaired (227905), and the Texas Juvenile Justice Department (227622), the following fields must all be 0 or blank/not reported: Total Elig Preg RelSvcsDays Present, and Total EligSpEdMainstream Days Present. |
42401-0029 | 34 | For a particular Student UniqueId, SchoolId, CalendarCode, Reporting Period, and Gradelevel, the sum of all TotalElig Bilingual ESLDays Present on BilingualESLProgram Reporting PeriodAttendance must not be greater than TotalEligibleDays Present on the matching BasicReporting PeriodAttendance. |
42401-0032 | 34 | For each Special Programs Reporting PeriodAttendance data item, TotalElig PregRelSvcsDays Present must not be greater than Total EligibleDays Present on the matching BasicReporting PeriodAttendance. |
42401-0035 | 34 | For each Special Programs Reporting PeriodAttendance data item, TotalEligSpEdMainstreamDays Present must not be greater than TotalEligibleDaysPresent on the matching BasicReporting PeriodAttendance. |
42401-0046 | 34 | For each Bilingual ESL Program Reporting PeriodAttendance data item, there must be a matching BasicReporting PeriodAttendance data item. |
42401-0047 | 4 | If Total Elig BilingualESLDays Present is greater than 0, then the student's EmergentBilingualIndicator must be reported. |
42405-0003 | 34 | For a particular SchoolId, CalendarCode, ReportingPeriod, and NumberDays Taught, there must be BasicReporting PeriodAttendance with matching SchoolId, CalendarCode, Reporting Period, and NumberDays Taught. |
42405-0004 | 34 | The Texas School for the Deaf (227906), the Texas School for the Blind and Visually Impaired (227905), and the Texas Juvenile Justice Department (227622) must not submit Special Education Program Reporting PeriodAttendance. |
42405-0005 | 34 | For a particular StudentUniqueId, if September 1 age is greater than 21, then no Special Education Program Reporting PeriodAttendance can be reported. |
42405-0008 | 34 | The last character of EligibleDays PresentInInstrSetting must be either "0" or "5". |
42405-0009 | 34 | SchoolId must match an entry registered with the TEA as an active instructional campus in the reporting LEA ending in "001"-"698". |
42405-0012 | 34 | For a particular StudentUniqueId, SchoolId, CalendarCode, Reporting Period, and GradeLevel, the sum of all instances of EligibleDays PresentInInstrSetting (where Instructional Setting is not "00") must not be greater than Total EligibleDays Present on the matching BasicReporting PeriodAttendance. |
42405-0013 | 34 | For a particular StudentUniqueId, SchoolId, CalendarCode, Reporting Period, and GradeLevel, the sum of all instances of EligibleDays PresentInInstrSetting (where Instructional Setting is "00") must not be greater than Total EligibleDays Present on the matching BasicReporting PeriodAttendance. |
42405-0016 | 34 | For a particular SchoolId, CalendarCode, and Reporting Period, NumberDays Taught must be identical on all Special Education Program Reporting PeriodAttendance. |
42405-0021 | 34 | If RegionalDaySchool ProgramForDeaf is "0", then LEAOFRDSPDService must not be reported. |
42405-0022 | 34 | If RegionalDaySchool ProgramForDeaf is not "0" or blank, then LEAOFRDSPDService must not be blank. |
42405-0023 | 34 | If LEAOIRDSPDService is not blank, then the value for LEAOIRDSPDService must match a Regional Day School Program for the Deaf district in the Texas School Directory. |
42405-0031 | 4 | For each Special Education Program Reporting PeriodAttendance data item, there must be a matching BasicReporting PeriodAttendance data item. |
42405-0053 | 34 | For each Special Education Program Reporting PeriodAttendance data item, if the matching BasicReporting PeriodAttendance has TotalDaysAbsent equal to 0.0, then EligibleDays PresentInInstrSetting must be greater than 0. |
42408-0001 | 4 | For each Extended School Year Services Attendance data item, there must be a StudentSchoolAssociation with matching StudentUniqueId and SchoolId where EntryGradeLevel matches attendance GradeLevel. |
42408-0002 | 4 | The last character of TotalESYContactHoursInFirstInstructional Setting must be either "0" or "5". |
42408-0003 | 4 | Instructional Setting must not be "31", "32", "34", "40", "50", "60", "70", or "71". |
42408-0004 | 4 | SchoolId must match an entry registered with the TEA as an active instructional campus in the reporting LEA ending in "001"-"698". |
42408-0005 | 4 | If SecondInstructionalSetting is not blank, then FirstInstructional Setting must not equal SecondInstructional Setting. |
42408-0006 | 4 | If SecondInstructionalSetting is not blank, then either FirstInstructional Setting or SecondInstructional Setting must be "00". |
42408-0007 | 4 | If SecondInstructionalSetting is not blank, then TotalESYContactHoursInSecondInstructional Setting must not be blank or 0. |
42408-0008 | 4 | If TotalESYContactHoursInSecondInstructional Setting is not blank, then SecondInstructional Setting must not be blank. |
42408-0009 | 4 | The Texas School for the Deaf (227906), the Texas School for the Blind and Visually Impaired (227905), and the Texas Juvenile Justice Department (227622) must not submit ExtendedSchool Year Services Attendance. |
42500-0002 | 34 | SchoolId must match an entry registered with the TEA as an active instructional campus in the reporting LEA ending in "001"-"698". |
42500-0003 | 34 | The first six characters of SchoolId must not be a Local Education Agency registered with the TEA as an ESC. |
42500-0004 | 34 | SchoolId must not be a campus registered with the TEA as a Juvenile Justice Alternative Education Program (JJAEP) campus. |
42500-0005 | 4 | SchoolId must not be a campus registered with the TEA as a Discipline Alternative Education Program (DAEP) campus. |
42500-0007 | 4 | Reporting Period must be "7" or "8". |
42500-0009 | 4 | FlexAttendance Program must be "3". |
42500-0010 | 4 | NumberDays Taught must be 30. |
42500-0011 | 34 | The value for FlexAttend Total Eligible Minutes Present must be 0 or equal to or greater than 45. |
42500-0012 | 34 | The value for FlexAttend TotalIneligible Minutes Present must be 0 or equal to or greater than 45. |
42500-0015 | 34 | Flex Total Elig Preg RelSvcsDays Present, Flex TotalEligSpEdMainstreamDays Present, and Flex Total EligResidential Facility Days Present must each be less than or equal to NumberDays Taught. |
42500-0016 | 34 | For a particular StudentUniqueId, if Flex Total Elig PregRelSvcsDays Present is greater than 0, then Sex must be "F" for the student. |
42500-0017 | 34 | For a particular SchoolId, CalendarCode, and Reporting Period, NumberDays Taught must be identical on all Flexible Regular Program Reporting PeriodAttendance. |
42500-0020 | 34 | For a particular StudentUniqueId, if September 1 age is greater than 21, then FlexTotalEligSpEdMainstreamDays Present must not be greater than 0. |
42500-0025 | 34 | For a particular Student UniqueId, SchoolId, CalendarCode, and ReportingPeriod, the sum of FlexAttend Total EligibleMinutes Present and FlexAttend TotalIneligible Minutes Present must be equal to or greater than 45. |
42500-0030 | 34 | For each FlexibleRegular Program Reporting Period Attendance data item, GradeLevel should be found in the grade range registered with TEA for the campus reported in the SchoolId, unless there is matching Flexible Special Education Program Reporting PeriodAttendance. |
42500-0031 | 34 | For each FlexibleRegular Program Reporting PeriodAttendance data item, FlexAttend Total Eligible Minutes Present should not be greater than NumberDays Taught multiplied by 360. |
42500-0037 | 34 | SchoolId must not be "019907006", "072801145", "101912100", "102904010", "220906007", "221801022", "236902008", "236902048", or "236902108", or TxVSN waiver campus "015835011", "031912203", "031916009", "046802011", "057905340", "057905554", "101846008", "101911040", "129902005", "170902220", "177901104", "186902040", "186902698", "221801079", or "246906006". |
42500-0038 | 34 | For a particular StudentUniqueId, SchoolId, CalendarCode, and Reporting Period, if Flex Total Elig BilingualESLDays Present is greater than 0, and BilingualESLFunding is "BE" or "D1", then EmergentBilingualIndicator must be "1". |
42500-0041 | 34 | If SchoolId is in the Texas School for the Deaf (227906) or the Texas School for the Blind and Visually Impaired (227905), then FlexAttend TotalIneligible Minutes Present must be greater than 0. |
42500-0042 | 34 | For the Texas School for the Deaf (227906) or the Texas School for the Blind and Visually Impaired (227905), the following fields must all be 0 or blank/not reported: FlexAttend Total EligibleMinutes Present, Flex Total Elig Preg RelSvcsDays Present, and Flex TotalEligSpEdMainstream Days Present. |
42500-0044 | 34 | If FlexAttend Total Eligible Minutes Present is reported, then it must be 0-32400. |
42500-0047 | 34 | Except for the Excel Center (for Adults) (227827) and New Heights (220822) and Texas Works (061806), for a particular StudentUniqueId, if September 1 age is 26 or greater, then all instances of FlexAttend Total Eligible Minutes Present must be 0. |
42500-0048 | 34 | If Flex Total Elig BilingualESLDays Present is greater than 0, then FlexAttend Total Eligible Minutes Present must be greater than 0 on the matching Flexible Regular Program Reporting PeriodAttendance. |
42500-0049 | 34 | For each FlexibleRegular Program Reporting PeriodAttendance data item, if Flex Total Elig Preg RelSvcsDays Present is greater than 0, then FlexAttend Total Eligible Minutes Present must be greater than 0. |
42500-0050 | 34 | For the Excel Center (for Adults) (227827) and New Heights (220822) and Texas Works (061806), for a particular StudentUniqueId, if September 1 age is 51 or greater, then all instances of FlexAttend Total Eligible Minutes Present must be 0. |
42500-0051 | 4 | If Flex TotalElig BilingualESLDays Present is greater than 0, then the student's EmergentBilingualIndicator must be reported. |
42500-0052 | 34 | If Flex Total EligResidential Facility Days Present not blank, then the last character of Flex Total EligResidential Facility Days Present must be "0". |
42500-0053 | 34 | If Flex Total Elig Preg RelSvcsDays Present is not blank, then the last character of Flex Total Elig Preg RelSvcsDays Present must be "0". |
42500-0054 | 34 | If Flex Total EligSpEdMainstreamDays Present is not blank, then the last character of Flex Total EligSpEdMainstream Days Present must be "0". |
42500-0055 | 34 | If Flex Total Elig BilingualESLDays Present is not blank, then the last character of Flex Total Elig BilingualESLDays Present must be "0". |
42500-0060 | 34 | For each FlexibleBilingual ESL Program Reporting PeriodAttendance data item, Flex TotalElig Bilingual ESL Days Present must be greater than 0. |
42500-0061 | 34 | The Texas School for the Deaf (227906), the Texas School for the Blind and Visually Impaired (227905), and the Texas Juvenile Justice Department (227622) must not submit FlexibleBilingual ESLProgram Reporting PeriodAttendance. |
42500-0062 | 34 | Flex Total Elig Bilingual ESLDays Present must each be less than or equal to NumberDays Taught. |
42505-0003 | 34 | For a particular SchoolId, CalendarCode, Reporting Period, and NumberDays Taught, there must be FlexibleRegular Program Reporting PeriodAttendance with matching SchoolId, Calendar Code, Reporting Period, and NumberDays Taught. |
42505-0004 | 34 | The Texas School for the Deaf (227906), the Texas School for the Blind and Visually Impaired (227905), and the Texas Juvenile Justice Department (227622) must not submit FlexibleSpecialEducation Program Reporting PeriodAttendance. |
42505-0005 | 34 | For each FlexibleSpecial Education Program Reporting PeriodAttendance data item, if FlexAttendExcessMinutesInInstrSetting is greater than 0, then there must be a matching FlexibleCTEProgram Reporting PeriodAttendance data item. |
42505-0006 | 34 | SchoolId must match an entry registered with the TEA as an active instructional campus in the reporting LEA ending in "001"-"698". |
42505-0008 | 34 | Instructional Setting must not be "31", "32", "34", "40", "50", "60", "70", or "71". |
42505-0009 | 34 | FlexAttendDays EligibleInInstrSetting must not be 0.0. |
42505-0011 | 4 | Reporting Period must be "7" or "8". |
42505-0013 | 4 | FlexAttendance Program must be "3". |
42505-0014 | 4 | NumberDays Taught must be 30. |
42505-0016 | 34 | For a particular SchoolId, CalendarCode, and Reporting Period, NumberDays Taught must be identical on all FlexibleSpecial Education Program Reporting PeriodAttendance. |
42505-0017 | 34 | If this Local Education Agency's data submission includes any students with Flexible Attendance, then the submission should include at least one Special Education Flexible Attendance, except for Texas School for the Deaf (227906), Texas School for the Blind and Visually Impaired (227905), and Texas Juvenile Justice Department (227622). |
42505-0023 | 4 | For each Flexible Special Education Program Reporting PeriodAttendance data item, there must be a matching Flexible Regular Program Reporting PeriodAttendance data item. |
42505-0024 | 34 | For a particular Student UniqueId, SchoolId, CalendarCode, Reporting Period, GradeLevel, and FlexAttendance Program, if the sum of all instances of FlexAttendDaysEligibleInInstrSetting is greater than 0, then FlexAttend Total Eligible Minutes Present on the matching FlexibleRegular Program Reporting PeriodAttendance must be greater than 0. |
42505-0026 | 34 | For a particular StudentUniqueId, If September 1 age is greater than 21, then no FlexibleSpecial Education Program Reporting PeriodAttendance can be reported. |
42510-0001 | 34 | For each FlexibleCTEProgram Reporting PeriodAttendance data item, there must be a matching Flexible Regular Program Reporting PeriodAttendance data item. |
42510-0002 | 34 | For a particular SchoolId, CalendarCode, Reporting Period, and NumberDays Taught, there must be Flexible Regular Program Reporting PeriodAttendance with matching SchoolId, CalendarCode, Reporting Period, and NumberDays Taught. |
42510-0004 | 34 | The Texas School for the Deaf (227906), the Texas School for the Blind and Visually Impaired (227905), and the Texas Juvenile Justice Department (227622) must not submit FlexibleCTEProgram Reporting PeriodAttendance. |
42510-0005 | 34 | SchoolId must match an entry registered with the TEA as an active instructional campus in the reporting LEA ending in "001"-"698". |
42510-0007 | 34 | GradeLevel must be "07"-"12". |
42510-0009 | 4 | Reporting Period must be "7" or "8". |
42510-0011 | 4 | FlexAttendanceProgram must be "3". |
42510-0012 | 4 | NumberDays Taught must be 30. |
42510-0013 | 34 | For a particular SchoolId, CalendarCode, and Reporting Period, NumberDays Taught must be identical on all FlexibleCTEProgram Reporting PeriodAttendance. |
42510-0014 | 34 | For a particular StudentUniqueId, the sum of FlexAttend Total Career TechMinutes Present must not be less than 45. |
42510-0017 | 34 | If FlexAttend Total Career TechMinutes Present is reported, then it must be 45-5400. |
42510-0018 | 34 | For each FlexibleCTEProgram Reporting PeriodAttendance data item, FlexAttend Total Career TechMinutes Present must not be greater than FlexAttend Total EligibleMinutes Present on the matching Flexible Regular Program Reporting PeriodAttendance. |
43415-0020 | 4 | CourseCode must be a high school course (Eligible for State HS Credit = "Y") and must not begin with "8". |
43415-0023 | 34 | SchoolId must match an entry registered with the TEA as an active instructional campus in the reporting LEA ending in "001"-"698". |
43415-0025 | 4 | CourseAttemptResult must not be "13" or "14". |
43415-0034 | 34 | If ATCIndicator is TRUE, then DualCreditIndicator must be FALSE or blank. |
43415-0035 | 34 | If DualCreditIndicator is TRUE, then ATCIndicator must be FALSE or blank. |
43415-0037 | 34 | If DualCreditIndicator is FALSE or blank/not reported, then CollegeCreditHours must be 0 or blank/not reported. |
43415-0050 | 34 | If CourseCode is not a high school course (Eligible for State HS Credit not = "Y"), then DualCreditIndicator must be FALSE or blank (not reported), and CollegeCreditHours must be 0 or blank (not reported). |
43415-0051 | 34 | If DualCreditIndicator is TRUE, then CourseCode must be a high school course (Eligible For State HS Credit = "Y"). |
43415-0056 | 34 | If DualCreditIndicator is TRUE and CollegeCreditHours is greater than 0, then CourseAttemptResult should be "01". |
43415-0071 | 34 | If CourseCode is "A3580110", then there must be another Course Transcript reported with a matching StudentUniqueId and CourseAttemptResult where CourseCode is "A3580120". |
43415-0072 | 34 | If CourseCode is "A3580120", then there must be another Course Transcript reported with a matching StudentUniqueId and CourseAttemptResult where CourseCode is "A3580110". |
43415-0073 | 34 | If CourseCode is "13580310", then there must be another Course Transcript reported with a matching StudentUniqueId and CourseAttemptResult where CourseCode is "13580320". |
43415-0074 | 34 | If CourseCode is "13580320", then there must be another Course Transcript reported with a matching StudentUniqueId and CourseAttemptResult where CourseCode is "13580310". |