The following extensions are included in the InterchangeStudentEnrollmentExtension:
StudentSchoolAssociationExtension
StudentGraduationProgramExtension
StudentResidentialFacilityAssociationExtension
Submissions:
(1) = Fall PEIMS (Submission 1)
(3) = Summer PEIMS (Submission 3)
(4) = Extended PEIMS (Submission 4)
(CF) = TSDS Child Find
(CR) = TSDS Class Roster - Fall & Winter
(CSW) = TSDS Charter School Waitlist
(ECDS-PK) = TSDS ECDS Prekindergarten
(ECDS-KG) = TSDS ECDS Kindergarten
(RFT) = TSDS Residential Facility Tracker
* Aeries Table.Fields that have an asterisk may need to be mapped on Texas State Reporting > Code Translations.
StudentSchoolAssociationExtension
- (CF) For Child Find, only students who have a Child Find Eligibility Determination Date (CSE.EDD) on or between July 1 and June 30 of the current school year are reported. Students are not required to have an enrollment record.
- (CSW) For Charter School Waitlist, only the following students are extracted:
- Has a Texas Unique ID (STU.CID)
- 1st School Choice (SCR.SC1) is a charter school (E0266)
- Waitlist Status = On Waitlist (SCD.WS = Y)
- Waitlist Status = Previously on Waitlist (SCD.WS = P) on the Snapshot Date
- Decision Date is before Snapshot Date (SCD.DDT > Snapshot Date)
- Has applied but is not enrolled in the charter school as of the Snapshot Date
- The student can be enrolled in a different school in the district
- The student can be recorded in the Transfer school in the district
The CSW Snapshot Date is the last Friday in September.
Submission | Element ID (Code Table) | Data Element | Aeries Table.Field | Aeries Page | Label |
(1) (3) (4) (CF) (CR) (CSW) (ECDS-PK) (ECDS-KG) | E1523 | TX-UNIQUE-STUDENT-ID | STU.CID | Demographics > Student Data 2 | Unique ID |
<StudentSchoolAssociation> <StudentReference> <StudentIdentity> <StudentUniqueStateId>UUUUUUUUUU</StudentUniqueStateId> </StudentIdentity> </StudentReference> </StudentSchoolAssociation> where UUUUUUUUUU = STU.CID | |||||
Rules (FATAL):
| |||||
(1) (3) (4) (CF) (CR) (CSW) (ECDS=PK) (ECDS-KG) | E0266 | CAMPUS-ID | LOC.CC + LOC.DC + LOC.SC | School Options | County + District + Campus |
<StudentSchoolAssociation> <EducationalOrgIdentity> <StateOrganizationId>CCCDDDSSS</StateOrganizationId> </EducationalOrgIdentity> </SchoolReference> </StudentSchoolAssociation> where:
| |||||
(CF) (CR) (CSW) (ECDS-PK) (ECDS-KG) | E1517 (DC063) | ENTRY-GRADE-LEVEL-TYPE | ENR.GR , or | Enrollment History | Grd |
STU.GR | Demographics > Student Data 1 | Grd | |||
<StudentSchoolAssociation> <EntryGradeLevel>Grade level</EntryGradeLevel> </StudentSchoolAssociation> where Grade level = ENR.GR (current year enrollment record) Full DC063 Code Translation is used rather than code. for Charter School Waitlist (CSW) where Grade Level = STU.GR (primary instructional level at which a student enters and receives services during a given sch | |||||
Rules (FATAL):
| |||||
(1) (3) (4) | E0017 (C050) | GRADE-LEVEL-CODE | ENR.GR | Enrollment History | Grd |
<StudentSchoolAssociation> <TX-GradeLevel>XX</TX-GradeLevel> </StudentSchoolAssociation> where XX = ENR.GR | |||||
| |||||
(1) (4) | E0782 | CAMPUS-ID-OF-ENROLLMENT | ENR.HS, or | Enrollment History | Campus of Accountability |
ENR.SC | School | ||||
<StudentSchoolAssociation> <TX-CampusIdOfEnrollment>CCCDDDSSS</TX-CampusIdOfEnrollment> </StudentSchoolAssociation> where:
(4) For Submission 4, required and allowed only for students participating in the Bilingual/ESL Summer School program/ADSY (Child Find) An enrollment record is not required for students to be extracted. | |||||
Special Warnings:
| |||||
(1) (3) (4) | E0903 | CAMPUS-ID-OF-RESIDENCE | STU.ITD | Enrollment History | District of Residence |
<StudentSchoolAssociation> <TX-CampusIdOfResidence>CCCDDDSSS</TX-CampusIdOfResidence> </StudentSchoolAssociation> where:
| |||||
Rules (FATAL):
Special Warnings:
| |||||
(1) (3) | E1027 | CAMPUS-ID-OF-ACCOUNTABILITY | ENR.HS, or | Enrollment History | Rptg School |
STU.HS, or | Demographics > Student Data 2 | Campus of Accountability | |||
ENR.SC | Enrollment History | School | |||
LOC.TY | School Options | Education Type | |||
<StudentSchoolAssociation> <TX-CampusIdOfAccountability>CCCDDDSSS</TX-CampusIdOfAccountability> </StudentSchoolAssociation> where:
| |||||
| |||||
(3) | E1044 | LAST-DATE-OF-ENROLLMENT | ENR.LD | Enrollment History | Leave Date |
<StudentSchoolAssociation> <TX-LastDateOfEnrollment>YYYY-MM-DD</TX-LastDateOfEnrollment> </StudentSchoolAssociation> where YYYY-MM-DD = ENR.LD | |||||
Rule (FATAL):
| |||||
(1) (3) (4) | E1000 (C161) | STUDENT-ATTRIBUTION-CODE | STU.IT or | Demographics | Attr Code |
ATT.IT or | Attendance Enrollment | AttrCd | |||
ENR.IT | Enrollment History | Attr Code | |||
LOC.TY | School Options | Education Type | |||
<StudentSchoolAssociation> <TX-Attribution>XX</TX-Attribution> </StudentSchoolAssociation> where XX = STU.IT or ATT.IT or ENR.IT NOTE: If a student's Attribution Code (E1000) = 02 (JJAEP), then LOC.TY must be 05. | |||||
Special Warnings:
| |||||
(1) (ECDS-PK) | E1078 (C185) | PK-PROGRAM-TYPE-CODE | ECD.PTC | Early Childhood Development | Program Type |
<StudentSchoolAssociation> <TX-PKProgramTypeIndicator>XX</TX-PKProgramTypeIndicator> </StudentSchoolAssociation> where XX = ECD.PTC Omitted if blank. C185 code is used rather than full Code Translation. | |||||
Rules (FATAL):
| |||||
(1) (ECDS-PK) | E1079 (C186) | PRIMARY-PK-FUNDING-SOURCE | ECD.FT1 | Early Childhood Development | Primary Funding Type |
<StudentSchoolAssociation> <TX-PrimaryPKFundingSource>X</TX-PrimaryPKFundingSource> </StudentSchoolAssociation> where X = ECD.FT1 Omitted if blank. C186 code is used rather than full Code Translation. | |||||
Rules (FATAL):
| |||||
(1) (ECDS-PK) | E1080 (C186) | SECONDARY-PK-FUNDING-SOURCE | ECD.FT2 | Early Childhood Development | Secondary Funding Type |
<StudentSchoolAssociation> <TX-SecondaryPKFundingSource>X</TX-SecondaryPKFundingSource> </StudentSchoolAssociation> where X = ECD.FT2 Omitted if blank. C186 code is used rather than full Code Translation. | |||||
Rule (FATAL):
| |||||
(ECDS-PK) | E1558 (DC153) | STUDENT-INSTRUCTION | MST.SIT | Master Schedule | Instruction Type |
ECD.SIT | Early Childhood Development | Instruction Type | |||
<StudentSchoolAssociation> <TX-StudentInstruction>Description</TX-StudentInstruction> </StudentSchoolAssociation> where Description = MST.SIT or ECD.SIT Full DC153 Code Translation is used rather than code. | |||||
(ECDS-PK) | E1555 (DC152) | PK-SCHOOL-TYPE | MST.PKT * or | Master Schedule | PK Schl Type |
LOC.PKT * | School Options | PK School Type | |||
<StudentSchoolAssociation> <TX-PKSchoolType>Description</TX-PKSchoolType> </StudentSchoolAssociation> where Description is MST.PKT if present; otherwise LOC.PKT * Full DC152 Code Translation is used rather than code. |
Additional Rules:
- (4) Each student has one StudentSchoolAssociationExtension for the last campus enrolled in.
- (1) GR1: For Submission 1: Each student who is enrolled in the current school year must be reported with a StudentSchoolAssociationExtension. Students who were enrolled last year but have not enrolled in the current year and need to be reported as leavers must be reported with a StudentSchoolAssociationExtension.
- 40100-0167: For a particular TX-UNIQUE-STUDENT-ID, there must be one and only one Enrollment (StudentSchoolAssociation).
- (1) 40110-000B: For a student Enrollment (StudentSchoolAssociation), the following must be provided: TX-UNIQUE-STUDENT-ID, CAMPUS-ID, GRADE-LEVEL-CODE, and STUDENT-ATTRIBUTION-CODE.
- 40110-0049: If a campus is registered with TEA as an active instructional campus, excluding DAEPs, then there should be at least one student enrollment with a matching CAMPUS-ID-OF-ENROLLMENT and GRADE-LEVEL-CODE for each grade registered as a grade of instruction for the campus.
- 40100-0197/40110-0001: For each student reported by the LEA, there must be enrollment (StudentSchoolAssociation) data with a matching TX-UNIQUE-STUDENT-ID.
- See Referential Integrity for Class Roster.
- 40110-0224: For each StudentSectionAssociation, there must be a student enrollment (StudentSchoolAssociation) with a matching TX-STUDENT-UNIQUE-ID and CAMPUS-ID.
- See Referential Integrity for Class Roster.
- 40110-000D: The combination of the following fields must be unique for each student Enrollment (StudentSchoolAssociation): TX-UNIQUE-STUDENT-ID, and CAMPUS-ID.
- (3) (4) 40110-000C/43415-000K: For a StudentSchoolAssociation, the following must be provided: TX-UNIQUE-STUDENT-ID, CAMPUS-ID, GRADE-LEVEL-CODE, and STUDENT-ATTRIBUTION-CODE.
- (3) 40110-000C: For Submission 3, for a student Enrollment (StudentSchoolAssociation), the following must be provided: TX-UNIQUE-STUDENT-ID, CAMPUS-ID, GRADE-LEVEL-CODE, and STUDENT-ATTRIBUTION-CODE.
- (4) 42408-0001: For extended school year services reported, there must be a StudentSchoolAssociation with matching TX-UNIQUE-STUDENT-ID, CAMPUS-ID, and GRADE-LEVEL-CODE.
- (3) 48011-0003: For a student reported in Submission 3 with graduation program intention data, there must be StudentSchoolAssociation data with a matching TX-UNIQUE-STUDENT-ID where GRADE-LEVEL-CODE is 09-12.
StudentSectionAssociation ↑
- Omitted for students with ADA eligibility 0 or 9
- (4) For submission 4 StudentSectionAssociation is extracted for students with an HIS transcript record if:
- Service ID (CRS.SVC) does not start with SA, SE, SR, SS, or 8, and
- School where course was taken (HIS.ST) was selected for extract, and
- School year on transcript (HIS.YR) = school year just ended, and
- Term on Transcript = Summer (HIS.TE = 3), and
- Course Type = Summer (CRS.TY = R), and
- Transcript Mark (HIS.MK) for the course contains a grade and does not equal X (E1068 COURSE-COMPLETION-INDICATOR = 1), and
- Service ID (CRS.SVC) for course on transcript (HIS.CN) contains one of the following:
- Course Sequence is part of dual credit (CRS.CSQ = D0-D9) and Course Level is dual credit (CRS.CL = 24)
- Course is college prep language arts/math (CRS.SVC = CP110100 or CP111200)
- Population Served on Course record is CTE (CRS.PSV = 05)
Submission | Element ID (Code Table) | Data Element | Aeries Table.Field | Aeries Page | Label |
(3) (4) (CR) (ECDS-PK) (ECDS-KG) | E1523 | TX-UNIQUE-STUDENT-ID | STU.CID | Demographics > Student Data 2 | Unique ID |
<StudentSectionAssociation> <StudentReference> <StudentIdentity> <StudentUniqueStateId>UUUUUUUUUU</StudentUniqueStateId> </StudentIdentity> </StudentReference> </StudentSectionAssociation> where UUUUUUUUUU = STU.CID | |||||
Rule (FATAL):
Special Warning:
| |||||
(3) (4) (CR) (ECDS-PK) (ECDS-KG) | E0266 | CAMPUS-ID | LOC.CC + LOC.DC + LOC.SC | School Options | County + District + Campus |
<StudentSectionAssociation> <SectionReference> <SectionIdentity> <StateOrganizationId>CCCDDDSSS</StateOrganizationId> </SectionIdentity> </SectionReference> </StudentSectionAssociation> where:
| |||||
Rule (FATAL):
| |||||
(3) (4) (CR) (ECDS-PK) (ECDS-KG) | E1056 | CLASS-ID-NUMBER | LOC.CD | School Options | Code |
MST.SE | Master Schedule | Section | |||
<StudentSectionAssociation> <SectionReference> <SectionIdentity> <UniqueSectionCode>CCCCCCCCCC_SSSS</UniqueSectionCode> </SectionIdentity> </SectionReference> </StudentSectionAssociation> where:
| |||||
Rule (FATAL):
| |||||
(3) (4) (CR) (ECDS-PK) (ECDS-KG) | E1069 | STUDENT-BEGIN-DATE | CAR.DS | Course Attendance | Start Date |
<StudentSectionAssociation> <BeginDate>YYYY-MM-DD</BeginDate> </StudentSectionAssociation> where YYYY-MM-DD = CAR.DS | |||||
Rules (FATAL):
Special Warning:
| |||||
(3) (4) (CR) (ECDS-PK) (ECDS-KG) | E1070 | STUDENT-END-DATE | CAR.DE | Course Attendance | Stop Date |
<StudentSectionAssociation> <EndDate>YYYY-MM-DD</EndDate> </StudentSectionAssociation> where YYYY-MM-DD = CAR.DE | |||||
Rules (FATAL):
Special Warning:
| |||||
(ECDS-PK) (ECDS-KG) | E1440 | HOME-ROOM-INDICATOR | CAR.SQ | Course Attendance | sequence number - not displayed |
ECDS-KG: CRS.SVC = 01020000 | Courses > Other | Service ID | |||
ECDS-PK: CRS.SVC = 01010000 | |||||
<StudentSectionAssociation> <HomeroomIndicator>true/false</HomeroomIndicator> </StudentSectionAssociation> (ECDS-KG) where true/false = true if CRS.SVC= 01020000 (ECDS-PK) where true/false = true if CRS.SVC = 01010000
| |||||
(3) (4) (CR) (ECDS=PK) (ECDS-KG) | E0948 (C135) | COURSE-SEQUENCE-CODE | CRS.CSQ | Courses > Other | Crs Seq |
<StudentSectionAssociation> <TX-CourseSequence>XX</TX-CourseSequence> </StudentSectionAssociation> where XX = CRS.SEQ | |||||
Rules (FATAL):
| |||||
(3) (4) | E1068 (C088) | COURSE-COMPLETION-INDICATOR | HIS.MK | Transcripts | Mark |
<StudentSectionAssociation> <TX-CourseCompletionIndicator>0/1</TX-CourseCompletionIndicator> </StudentSectionAssociation> where 0/1 = 1 if HIS.MK contains a grade (whether passing or not); otherwise 0 NOTE: Grade X does NOT count toward course completion. | |||||
Rules (FATAL):
Special Warnings:
|
Additional Rules:
- (4) Reporting students that completed courses during the summer (between school years) for the purpose of attempting to earn dual credit, College Preparatory Course English Language Arts (CP110100), or College Preparatory Course Mathematics (CP111200).
- 40100-0187/40110-0211: For each student reported by the LEA, there must be StudentSectionAssociation data with a matching TX-UNIQUE-STUDENT-ID.
- 40110-0180: For each StudentSectionAssociation, there must be a corresponding Course SectionExtension where CAMPUS-ID, CLASS-ID-NUMBER, and COURSE-SEQUENCE-CODE are the same.
- 40110-0224: For each StudentSectionAssociation, there must be a student enrollment (StudentSchoolAssociation) with a matching TX-STUDENT-UNIQUE-ID and CAMPUS-ID.
- 40110-000E/50300-000E: The combination of the following fields must be unique for each StudentSectionAssociation: TX-UNIQUE-STUDENT-ID, CAMPUS-ID, CLASS-ID-NUMBER, COURSE-SEQUENCE-CODE, and STUDENT-BEGIN-DATE.
- 30305-0026: For each TeacherSectionAssociation, there should be at least one StudentSectionAssociation with a matching CAMPUS-ID, CLASS-ID-NUMBER, and COURSE-SEQUENCE-CODE.
- 40110-000E/50300-000E: The combination of the following fields must be unique for each StudentSectionAssociation: TX-UNIQUE-STUDENT-ID, CAMPUS-ID, CLASS-ID-NUMBER, COURSE-SEQUENCE-CODE, and STUDENT-BEGIN-DATE.
- 40110-000F/50300-000F: For a StudentSectionAssociation, the following must be provided: TX-UNIQUE-STUDENT-ID, CAMPUS-ID, CLASS-ID-NUMBER, STUDENT-BEGIN-DATE, STUDENT-END-DATE, COURSE-SEQUENCE-CODE, and COURSE-COMPLETION-INDICATOR.
- 40110-0180: For each StudentSectionAssociation, there must be a corresponding Course Section where CAMPUS-ID, CLASS-ID-NUMBER, and COURSE-SEQUENCE-CODE are the same.
- 40110-0184: For ECDS-KG, if the student assessment REPORT-ASSESSMENT-TYPE is ECDS-KG, for a particular TX-UNIQUE-STUDENT-ID, there must be one and only one StudentSectionAssociation where assessment ADMINISTRATION-DATE is greater than or equal to STUDENT-BEGIN-DATE and less than or equal to STUDENT-END-DATE, and HOME-ROOM-INDICATOR is TRUE.
- 40110-0205: For Submission 3, the following course-sections are extracted:
- Eligible for State HS Credit = Y in code table C022 (See TWEDS)), or
- TxVSN Online Schools program course (CRS.NCI = 04) (Non-Campus Inst field on Courses > Other), or
- TxVSN Statewide Online Course Catalog course (CRS.NCI = 05) (Non-Campus Inst field on Courses > Other)
- Courses with local service IDs (i.e., service IDs that start with SA, SE, SR, SS, 01, or 8) are excluded (CRS.SVC) (Service ID field on Courses > Other).
- 0110-0180: For each StudentSectionaAssociation, a corresponding Course SectionExtension is reported where CAMPUS-ID, CLASS-ID-NUMBER, and COURSE-SEQUENCE-CODE are the same.
- 50300-0002: For each Course SectionExtension, there should be a corresponding StudentSectionAssociation where CAMPUS-ID, CLASS-ID-NUMBER, and COURSE-SEQUENCE-CODE are the same.
SchoolLeaverExtension ↑
Submission | Element ID (Code Table) | Data Element | Aeries Table.Field | Aeries Page | Label |
(1) | E0212 | DISTRICT-ID | LOC.CC + LOC.DC | School Options | County + District |
<SchoolLeaverExtension> <TX-LEAReference> <EducationalOrgIdentity> <StateOrganizationId>CCCDDD</StateOrganizationId> </EducationalOrgIdentity> </TX-LEAReference> </SchoolLeaverExtension> where:
| |||||
(1) | E1523 | TX-UNIQUE-STUDENT-ID | STU.CID | Demographics > Student Data 2 | Unique ID |
<SchoolLeaverExtension> <TX-StudentReference> <StudentIdentity> <StudentUniqueStateId>UUUUUUUUUU</StudentUniqueStateId> </StudentIdentity> </TX-StudentReference> </SchoolLeaverExtension> where UUUUUUUUUU = STU.CID | |||||
Rules (FATAL):
| |||||
(1) | E0266 | CAMPUS-ID | LOC.CC + LOC.DC + LOC.SC | School Options | County + District + Campus |
<SchoolLeaverExtension> <EducationalOrgIdentity> <StateOrganizationId>CCCDDDSSS</StateOrganizationId> </EducationalOrgIdentity> </TX-SchoolReference> </SchoolLeaverExtension> where:
| |||||
| |||||
(1) | E1001 (C162) | LEAVER-REASON-CODE | STU.LVR | Demographics | Leaver Reason |
STU.LD | Schl Leave Dt | ||||
<SchoolLeaverExtension> <TX-LeaverReasonCode>XX</TX-LeaverReasonCode> </SchoolLeaverExtension> where XX = STU.LVR when STU.LD < Aug 31 | |||||
Special Warnings:
| |||||
(1) | E0791 | DATE-OF-GRADUATION | STU.DG | Demographics > Student Data 2 | Grad Type Date |
<SchoolLeaverExtension> <TX-DateOfGraduation>MMYYYY</TX-DateOfGraduation> </SchoolLeaverExtension> where MMYYYY = STU.DG | |||||
Rules (FATAL):
| |||||
(1) | E0806 (C062) | GRADUATION-TYPE-CODE | STU.HSG * | Demographics > Student Data 2 | Grad Type Code |
<SchoolLeaverExtension> <TX-GraduationTypeCode>XX</TX-GraduationTypeCode> </SchoolLeaverExtension> where XX = STU.HSG | |||||
Special Warning:
| |||||
(1) | E1562 (C201) | INDIVIDUAL-GRADUATION-COMMITTEE-GRADUATE-CODE | STU.IGG | Demographics > Student Data 2 | Individual Graduation Committee Grad Code |
STU.GR = 11 or 12 | Demographics | Grd | |||
<SchoolLeaverExtension> <TX-IndividualGraduationCommitteeGraduateIndicator>XX</TX-IndividualGraduationCommitteeGraduateIndicator> </SchoolLeaverExtension> where XX = STU.IGG Only extracted for students in 11th and 12th grades; 00 is extracted if blank. | |||||
Rules (FATAL):
Special Warning:
| |||||
(1) | E1589 (C088) | MILITARY-ENLISTMENT-INDICATOR-CODE | SSD.ADM | Secondary Stu Data | Voc Ed - Act. Military |
<SchoolLeaverExtension> <TX-MilitaryEnlistmentIndicatorCode>0/1</TX-MilitaryEnlistmentIndicatorCode> </SchoolLeaverExtension> where:
|
Additional Rules:
- GR1: Students who graduated during the prior school year, including summer graduates up through August 31st are reported in Submission 1. Students who complete a high school equivalency program are not reported as graduates. Students who have previously completed all graduation requirements in one school year, but do not pass the exit-level TAAS, TAKS or STAAR® until the next year, are reported as graduates in the year in which the TAAS, TAKS or STAAR® test was passed.
- 40203-000A: The combination of the following fields must be unique for each leaver: DISTRICT-ID and TX-UNIQUE-STUDENT-ID.
- 40203-000B: For a student leaver, the following must be provided: DISTRICT-ID, TX-UNIQUE-STUDENT-ID, CAMPUS-ID, LEAVER-REASON-CODE, and MILITARY-ENLISTMENT-INDICATOR-CODE.
- 10020-0016: For each campus registered with TEA as an active instructional campus in the prior school year with any grade 7-12, there should be at least one leaver with a matching CAMPUS-ID-OF-ENROLLMENT.
- 40110-0050: If there is at least one student enrollment where GRADE-LEVEL-CODE is 12 on a campus, there should be at least one leaver with a matching CAMPUS-ID where LEAVER-REASON-CODE is 01.
- 40110-0051: If there is at least one student enrollment where GRADE-LEVEL-CODE is 07-12 on a campus, then there should be at least one leaver with a matching CAMPUS-ID where LEAVER-REASON-CODE is not 01.
- 40203-0009: A student leaver's prior year September 1 age should not be greater than 25 or less than 10.
StudentGraduationProgramExtension ↑
Submission | Element ID (Code Table) | Data Element | Aeries Table.Field | Aeries Page | Label |
(1) (3) | E0212 | DISTRICT-ID | LOC.CC + LOC.DC | School Options | County + District |
<StudentGraduationProgramExtension> <TX-LEAReference> <EducationalOrgIdentity> <StateOrganizationId>CCCDDD</StateOrganizationId> </EducationalOrgIdentity> </TX-LEAReference> </StudentGraduationProgramExtension> where:
| |||||
(1) (3) | E0266 | CAMPUS-ID | LOC.CC + LOC.DC + LOC.SC | School Options | County + District + Campus |
<StudentGraduationProgramExtension> <TX-SchoolReference> <EducationalOrgIdentity> <StateOrganizationId>CCCDDDSSS</StateOrganizationId> </EducationalOrgIdentity> </TX-SchoolReference> </StudentGraduationProgramExtension> where:
| |||||
| |||||
(1) (3) | E1523 | TX-UNIQUE-STUDENT-ID | STU.CID | Demographics > Student Data 2 | Unique ID |
<StudentGraduationProgramExtension> <TX-StudentReference> <StudentIdentity> <StudentUniqueStateId>UUUUUUUUUU</StudentUniqueStateId> </StudentIdentity> </TX-StudentReference> </StudentGraduationProgramExtension> where UUUUUUUUUU = STU.CID | |||||
Rules (FATAL):
| |||||
(3) | E1541 (C199) | FHSP-PARTICIPANT-CODE | STU.HSG * | Demographics > Student Demo 2 | Grad Type - Code |
STU.GRT | Graduation Status | Graduation Track | |||
REQ.GRT * | Graduation Requirements | Track | |||
<StudentGraduationProgramExtension> <TX-GraduationProgramParticipants> <TX-FHSPParticipant>X</TX-FHSPParticipant> </TX-GraduationProgramParticipants> </StudentGraduationProgramExtension> where X =
REQ.GRT/STU.GRT values must be added on the Graduation Requirements page (Track > New). REQ.GRT/STU.GRT values must be mapped in Code Translations (Graduation Plan Type Descriptor (REQ.GRT)). | |||||
Rules (FATAL):
Special Warnings:
| |||||
(1) (3) | E1542 (C199) | FHSP-DISTING-LEVEL-ACHIEVE-INDICATOR-CODE | ACT.TY | Activities and Awards | Type |
ACT.CD | Code | ||||
ACT.RS | Reason | ||||
<StudentGraduationProgramExtension> <TX-FHSPDistingLevelAchieveIndicator>X</TX-FHSPDistingLevelAchieveIndicator> </StudentGraduationProgramExtension> were X =
| |||||
Special Warnings:
| |||||
(1) (3) | E1544 (C199) | STEM-ENDORSEMENT-INDICATOR-CODE | GES.EC = ST * | Graduation Status > Endorsement (Manage) | Endorsement |
GES.ST | Current Status | ||||
STU.EOO | Profile > Endorsement (Manage), or | Opt-out (11th and 12th grade only) | |||
Graduation Status > Endorsement (Manage) | |||||
<StudentGraduationProgramExtension> <TX-EndorsementIndicators> <TX-STEMEndorsementIndicator>X</TX-STEMEndorsementIndicator> </TX-EndorsementIndicators> </StudentGraduationProgramExtension> where X =
On Update Code Tables:
| |||||
Special Warnings:
| |||||
(1) (3) | E1545 (C199) | BUSINESS-AND-INDUSTRY-ENDORSEMENT-INDICATOR-CODE | GES.EC = BI * | Graduation Status > Endorsement (Manage) | Endorsement |
GES.ST | Current Status | ||||
STU.EOO | Profile > Endorsement (Manage), or | Opt-out (11th and 12th grade only) | |||
Graduation Status > Endorsement (Manage) | |||||
<StudentGraduationProgramExtension> <TX-EndorsementIndicators> <TX-BusinessAndIndustryEndorsementIndicator>X</TX-BusinessAndIndustryEndorsementIndicator> </TX-EndorsementIndicators> </StudentGraduationProgramExtension> where X =
On Update Code Tables:
| |||||
Special Warnings:
| |||||
(1) (3) | E1546 (C199) | PUBLIC-SERVICES-ENDORSEMENT-INDICATOR-CODE | GES.EC = PS * | Graduation Status > Endorsement (Manage) | Endorsement |
GES.ST | Current Status | ||||
STU.EOO | Profile > Endorsement (Manage), or | Opt-out (11th and 12th grade only) | |||
Graduation Status > Endorsement (Manage) | |||||
<StudentGraduationProgramExtension> <TX-EndorsementIndicators> <TX-PublicServicesEndorsementIndicator>X</TX-PublicServicesEndorsementIndicator> </TX-EndorsementIndicators> </StudentGraduationProgramExtension> where X =:
On Update Code Tables:
| |||||
Special Warnings:
| |||||
(1) (3) | E1547 (C199) | ARTS-AND-HUMANITIES-ENDORSEMENT-INDICATOR-CODE | GES.EC = AH * | Graduation Status > Endorsement (Manage) | Endorsement |
GES.ST | Current Status | ||||
STU.EOO | Profile > Endorsement (Manage), or | Opt-out (11th and 12th grade only) | |||
Graduation Status > Endorsement (Manage) | |||||
<StudentGraduationProgramExtension> where X =
On Update Code Tables:
| |||||
Special Warnings:
| |||||
(1) (3) | E1548 (C199) | MULTI-DISCIPLINARY-STUDIES-ENDORSEMENT-INDICATOR-CODE | GES.EC = MS * | Graduation Status > Endorsement (Manage) | Endorsement |
GES.ST | Current Status | ||||
STU.EOO | Profile > Endorsement (Manage), or | Opt-out (11th and 12th grade only) | |||
Graduation Status > Endorsement (Manage) | |||||
<StudentGraduationProgramExtension> <TX-EndorsementIndicators> <TX-MultiDisciplinaryStudiesEndorsementIndicator>X</TX-MultiDisciplinaryStudiesEndorsementIndicator> </TX-EndorsementIndicators> </StudentGraduationProgramExtension> where X =
On Update Code Tables:
| |||||
Special Warnings:
| |||||
(3) | E1563 (C201) | INDIVIDUAL-GRADUATION-COMMITTEE-REVIEW-CODE | STU.IGR | Demographics > Student Date 2 | Individual Graduation Committee Review Code |
<StudentGraduationProgramExtension> <TX-IndividualGraduationCommitteeReviewIndicator>XX</TX-IndividualGraduationCommitteeReviewIndicator> </StudentGraduationProgramExtension> where XX = STU.IGR | |||||
Rules (FATAL):
| |||||
(1) | E1724 (C230) | FINANCIAL-AID-APPLICATION-CODE | ACT.CD = G04 | Activities and Awards | Code |
ACT.RS = FA1 or FA2 | Reason | ||||
STU.DG | Demographics > Student Data 2 | Grad Type - Date | |||
<StudentGraduationProgramExtension> <TX-FinancialAidApplication>XX</TX-FinancialAidApplication> </StudentGraduationProgramExtension> where XX =
| |||||
(1) | E1736 (C233) | TEXAS-FIRST-EARLY-HS-COMPLETION-PROGRAM | ACT.TY = 4 | Activities and Awards | Type |
ACT.CD = TEC | Code | ||||
ACT.RS = 01 or 02 | Reason | ||||
<StudentGraduationProgramExtension> <TX-TexasFirstEarlyHSCompletionProgram>XX</TX-TexasFirstEarlyHSCompletionProgram> </StudentGraduationProgramExtension> where XX = ACT.RS when ACT.CD = TEC |
Additional Rules:
- (1) GR1: Submission 1: The StudentGraduationProgramExtension Complex Type is reported for students who have graduated in the prior school year.
- 48011-000A: The combination of the following fields must be unique for each StudentGraduationProgram: DISTRICT-ID and TX-UNIQUE-STUDENT-ID.
- 48011-000B: For a Student Graduation Program, the following must be provided: DISTRICT-ID, TX-UNIQUE-STUDENT-ID, CAMPUS-ID, and FINANCIAL-AID-APPLICATION-CODE.
- 48011-000C: For a StudentGraduationProgram, the following must be provided: DISTRICT-ID, TX-UNIQUE-STUDENT-ID, CAMPUS-ID, and FHSP-PARTICIPANT-CODE.
StudentResidentialFacilityAssociationExtension ↑
Submission | Element ID (Code Table) | Data Element | Aeries Table.Field | Aeries Page | Label |
(RFT) | E1523 | TX-UNIQUE-STUDENT-ID | STU.CID | Demographics > Student Data 2 | Unique ID |
<StudentResidentialFacilityAssociationExtension> <StudentReference> <StudentIdentity> <StudentUniqueStateId>UUUUUUUUUU</StudentUniqueStateId> </StudentIdentity> </StudentReference> </StudentResidentialFacilityAssociationExtension> where UUUUUUUUUU = STU.CID | |||||
Rules (FATAL):
| |||||
(RFT) | E1627 | RESIDENTIAL-FACILITY-ID | RFH.FID | Special Education > Residential Facility | Facility ID |
<StudentResidentialFacilityAssociationExtension> <ResidentialFacilityReference> <EducationalOrgIdentity> <StateOrganizationId>RRRRRR</StateOrganizationId> </EducationalOrgIdentity> </ResidentialFacilityReference> </StudentResidentialFacilityAssociationExtension> where RRRRRR = RFH.FID | |||||
(RFT) | E1630 | DATE-ENTERED-RF | RFH.ED | Special Education > Residential Facility | Entry Date |
<StudentResidentialFacilityAssociationExtension> <TX-DateEnteredRF>YYYY-MM-DD</TX-DateEnteredRF> </StudentResidentialFacilityAssociationExtension> where YYYY-MM-DD = RFH.ED | |||||
Rules (FATAL):
| |||||
(RFT) | E1631 | DATE-EXITED-RF | RFH.LD | Special Education > Residential Facility | Leave Date |
<StudentResidentialFacilityAssociationExtension> <TX-DateExitedRF>YYYY-MM-DD</TX-DateExitedRF> </StudentResidentialFacilityAssociationExtension> where YYYY-MM-DD = RFH.LD only included if applicable | |||||
Rules (FATAL):
| |||||
(RFT) | E1632 | EFFECTIVE-DATE | RFD.ESD | Special Education > Residential Facility | Effective Start Date |
<StudentResidentialFacilityAssociationExtension> <TX-RFStudent> <TX-EffectiveDateRFStudent>YYYY-MM-DD</TX-EffectiveDateRFStudent> </TX-RFStudent> </StudentResidentialFacilityAssociationExtension> where YYYY-MM-DD = RFD.ESD | |||||
Rules (FATAL):
| |||||
(RFT) | E1517 (DC063) | ENTRY-GRADE-LEVEL-TYPE | RFD.GR | Special Education > Residential Facility | Grade |
<StudentResidentialFacilityAssociationExtension> <TX-RFStudent> <EntryGradeLevel>Nth grade</EntryGradeLevel> </TX-RFStudent> </StudentResidentialFacilityAssociationExtension> where Nth grade = RFD.GR | |||||
(RFT) | E0782 | CAMPUS-ID-OF-ENROLLMENT | RFD.SE | Special Education > Residential Facility | School of Enrollment |
<StudentResidentialFacilityAssociationExtension> <TX-RFStudent> <TX-CampusIdOfEnrollment>CCCDDDSSS</TX-CampusIdOfEnrollment> </TX-RFStudent> </StudentResidentialFacilityAssociationExtension> where CCCDDDSSS = RFD.SE | |||||
(RFT) | E1633 | ATTENDANCE-ZONE-CAMPUS | RFD.SAZ | Special Education > Residential Facility | School of Attendance Zone |
<StudentResidentialFacilityAssociationExtension> <TX-RFStudent> <TX-AttendanceZoneCampus>CCCDDDSSS</TX-AttendanceZoneCampus> </TX-RFStudent> </StudentResidentialFacilityAssociationExtension> where CCCDDDSSS = RFD.SAZ | |||||
(RFT) | E1634 | EDUCATED-AT-RESIDENTIAL-FACILITY | RFD.EF | Special Education > Residential Facility | Educated at Facility |
<StudentResidentialFacilityAssociationExtension> <TX-RFStudent> <TX-EducatedAtResidentialFacility>true/false</TX-EducatedAtResidentialFacility> </TX-RFStudent> </StudentResidentialFacilityAssociationExtension> where RFD.EF=Yes = true and RFD.EF=No = false | |||||
(RFT) | E1635 | SURROGATE-PARENT-ASSIGNED | RFD.SP | Special Education > Residential Facility | Surrogate Parent |
<StudentResidentialFacilityAssociationExtension> <TX-RFStudent> <TX-SurrogateParentAssigned>true/false</TX-SurrogateParentAssigned> </TX-RFStudent> </StudentResidentialFacilityAssociationExtension> where RFD.SP=Yes = true and RFD.SP=No = false | |||||
Rules (FATAL):
| |||||
(RFT) | E1636 | NUMBER-OTHER-STUDENTS-ASSIGNED-SAME-SURROGATE-PARENT | RFD.OSS | Special Education > Residential Facility | Other Students w/same Surrogate |
<StudentResidentialFacilityAssociationExtension> <TX-RFStudent> <TX-SurrogateParentAssigned>true</TX-SurrogateParentAssigned> <TX-NumberOtherStudentsAssignedSameSurrogateParent>XX </TX-NumberOtherStudentsAssignedSameSurrogateParent> </TX-RFStudent> </StudentResidentialFacilityAssociationExtension> where XX = RFD.OSS (up to 2 digits), only if TX-SurrogateParentAssigned = true | |||||
Rules (FATAL):
| |||||
(RFT) | E1637 | RESIDENTIAL-FACILITY-STUDENT-SCHOOL-DAY-LENGTH | RFD.RDL | Special Education > Residential Facility | RF Day Length |
<StudentResidentialFacilityAssociationExtension> <TX-RFStudent> <TX-ResidentialFacilityStudentSchoolDayLength>XXX </TX-ResidentialFacilityStudentSchoolDayLength> </TX-RFStudent> </StudentResidentialFacilityAssociationExtension> where XXX = RFD.RDL (up to 3 digits) | |||||
(RFT) | E1638 | CAMPUS-ID-OF-ENROLLMENT-SCHOOL-DAY-LENGTH | RFD.SDL | Special Education > Residential Facility | School Day Length |
<StudentResidentialFacilityAssociationExtension> <TX-RFStudent> <TX-CampusIdOfEnrollmentSchoolDayLength>XXX </TX-CampusIdOfEnrollmentSchoolDayLength> </TX-RFStudent> </StudentResidentialFacilityAssociationExtension> where XXX = RFD.SDL (up to 3 digits) | |||||
(RFT) | E1639 (C035) | PRIOR-INSTRUCTIONAL-SETTING-CODE | RFD.PIS | Special Education > Residential Facility | Prior Instructional Setting |
<StudentResidentialFacilityAssociationExtension> <TX-RFStudent> <TX-PriorInstructionalSettingCode>XX</TX-PriorInstructionalSettingCode> </TX-RFStudent> </StudentResidentialFacilityAssociationExtension> where XX = RFD.PIS (two-digit code) |