The following extensions are included in InterchangeStudentTranscriptExtension.
Submissions:
(3) = Summer PEIMS (Submission 3)
(4) = Extended PEIMS (Submission 4)
* Aeries Table.Fields that have an asterisk must be mapped on Texas State Reporting > Code Translations.
The StudentTranscript interchange:
- Includes high school credit courses for grade levels 3 and higher (Submission 3)
- Excludes local service IDs (i.e., service IDs that begin with SA, SE, SR, SS, 01, or 8)
- Reported for all students with COURSE-COMPLETION-INDICATOR = 1 (Rule 40110-0162).
- Only includes course completion records where Date of Completion field on Transcripts (HIS.DC) contains a value.
- See Referential Integrity for Course Sections in PEIMS Submission 3.
For Submission 4 the StudentTranscript interchange is extracted for students with a 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
- Student's grade level is 9-12, and
- Service ID (CRS.SVC) for course on transcript (HIS.CN) contains one of the following:
- Dual Credit Courses: Course Sequence is part of dual credit (CRS.CSQ = D0-D9) and Course Level is dual credit (CRS.CL = 24), or
- Course is college prep language arts/math (CRS.SVC = CP110100 or CP111200), or
- CTE Course: Population Served on Course record is CTE (CRS.PSV = 05)
StudentAcademicRecord
| Submission | Element ID (Code Table) | Data Element | Aeries Table.Field | Aeries Page | Label |
| (3) (4) | StudentAcademicRecord id | STU.ID | Demographics | Student ID | |
<StudentAcademicRecord id="SAR_XXXXX"> </StudentAcademicRecord> where XXXXX = STU.ID | |||||
| (3) (4) | E1523 | TX-UNIQUE-STUDENT-ID | STU.CID | Demographics > Student Data 2 | Unique ID |
<StudentAcademicRecord id="SAR_XXXXX"> <StudentReference> <StudentIdentity> <StudentUniqueStateId>UUUUUUUUUUU</StudentUniqueStateId> </StudentIdentity> </StudentReference> </StudentAcademicRecord> where UUUUUUUUUUU = STU.CID | |||||
Rules (FATAL):
| |||||
Additional Rule:
- 43415-000N: For a Student Academic Record, the following must be provided: TX-UNIQUE-STUDENT-ID.
CourseTranscriptExtension ↑
| Submission | Element ID (Code Table) | Data Element | Aeries Table.Field | Aeries Page | Label |
| (3) (4) | E1089 (DC036) | COURSE-IDENTIFICATION-SYSTEM | "State course code" | ||
| <CourseTranscript> <CourseReference> <CourseIdentity> <CourseCode IdentificationSystem="State course code"> <ID>XXXXXXXX</ID> </CourseCode> </CourseIdentity> </CourseReference> </CourseTranscript> | |||||
Rule (FATAL):
| |||||
| (3) (4) | E0724 (C022) | SERVICE-ID | CRS.SVC | Courses > Other | Service ID |
| <CourseTranscript> <CourseReference> <CourseIdentity> <CourseCode IdentificationSystem="State course code"> <ID>UUUUUUUU</ID> </CourseCode> </CourseIdentity> </CourseReference> </CourseTranscript> where UUUUUUUU = CRS.SVC | |||||
Rules (FATAL):
Special Warning:
| |||||
| (3) (4) | E0266 | CAMPUS-ID | LOC.CC + LOC.DC + LOC.SC | School Options | County + District + Campus |
| <CourseTranscript> <EducationOrganizationReference> <EducationalOrgIdentity> <StateOrganizationId>CCCDDDSSS</StateOrganizationId> </EducationalOrgIdentity> </EducationOrganizationReference> </CourseTranscript> where:
| |||||
Special Warning:
| |||||
| (3) (4) | StudentAcademicRecordReference ref | STU.ID | Demographics | Student ID | |
| <CourseTranscript> <StudentAcademicRecordReference ref="SAR_XXXXX" /> </CourseTranscript> where XXXXXX = STU.ID | |||||
| (3) (4) | E0017 (C050) | GRADE-LEVEL-CODE | HIS.GR | Transcripts | Grd |
| <CourseTranscript> <TX-GradeLevel>NN</TX-GradeLevel> </CourseTranscript> where NN = HIS.GR | |||||
| (3) (4) | E0949 (C136) | PASS/FAIL-CREDIT-INDICATOR-CODE | HIS.PF | Transcripts | Pass/Fail Credit |
| <CourseTranscript> <TX-PassFailCreditIndicator>XX</TX-PassFailCreditIndicator> </CourseTranscript> where XX = HIS.PF | |||||
Rules (FATAL):
Special Warnings:
| |||||
| (3) (4) | E1011 (C088) | DUAL-CREDIT-INDICATOR-CODE | CRS.CL = 24 | Courses > Other | Crs Lvl |
| HIS.SDE > 0 | Transcripts | Dual Enrollment Credit School (College Level Courses) | |||
| <CourseTranscript> <TX-DualCreditIndicator>0/1</TX-DualCreditIndicator> </CourseTranscript> where 0/1 = 1 if CRS.CL = 24 and HIS.SDE > 0; otherwise 0 | |||||
Rules (FATAL):
Special Warnings:
| |||||
| (3) (4) | E1058 (C088) | ATC-INDICATOR-CODE | MST.AC | Master Schedule | Articulated Crs |
| <CourseTranscript> <TX-ATCIndicator>0/1</TX-ATCIndicator> </CourseTranscript> where 0/1 = 1 if MST.AC = Yes; otherwise 0 | |||||
Rules (FATAL):
| |||||
| (3) (4) | E1081 | COLLEGE-CREDIT-HOURS | HIS.CH | Transcripts | College Credit Hours |
| <CourseTranscript> <TX-CollegeCreditHours>N</TX-CollegeCreditHours> </CourseTranscript> where N = HIS.CH HIS.CH is only available for courses where CRS.CL = 24 | |||||
Rules (FATAL):
Special Warnings:
| |||||
| (3) (4) | E0782 | CAMPUS-ID-OF-ENROLLMENT | HIS.ST | Transcripts | Schl |
| <CourseTranscript> <TX-CampusIdOfEnrollment>CCCDDDSSS</TX-CampusIdOfEnrollment> </CourseTranscript> where:
| |||||
Rules (FATAL):
| |||||
| (3) | E0948 (C135) | COURSE-SEQUENCE-CODE | CRS.SEQ | Courses > Other | Crs Seq |
| <CourseTranscript> <TX-CourseSequence>XX</TX-CourseSequence> </CourseTranscript> where XX = CRS.SEQ | |||||
Rules (FATAL):
Special Warning:
| |||||
| (3) (4) | E1056 | CLASS-ID-NUMBER | LOC.CD | School Options | Code |
| MST.SE | Master Schedule | Section | |||
| <CourseTranscript> <UniqueSectionCode>CCCCCCCCCC _SSSS</UniqueSectionCode> </CourseTranscript> where:
| |||||
Additional Rules:
- (4) 40110-0162: If COURSE-COMPLETION-INDICATOR is 1, there must be a corresponding Course Transcript.
- 43415-000A: The combination of the following fields must be unique for each CourseTranscript: COURSE-IDENTIFICATION-SYSTEM, SERVICE-ID, CAMPUS-ID, StudentAcademicRecordReference, COURSE-SEQUENCE-CODE, and CLASS-ID-NUMBER.
- 43415-000B: For a CourseTranscript, the following must be provided: COURSE-IDENTIFICATION-SYSTEM, SERVICE-ID, CAMPUS-ID, StudentAcademicRecordReference, GRADE-LEVEL-CODE, PASS/FAIL-CREDIT-INDICATOR-CODE, DUAL-CREDIT-INDICATOR-CODE, ATC-INDICATOR-CODE, CAMPUS-ID-OF-ENROLLMENT, COURSE-SEQUENCE-CODE, and CLASS-ID-NUMBER.
- (3) 43415-0006: For a particular TX-UNIQUE-STUDENT-ID reporting a CourseTranscript, there must be Attendance and/or Flexible Attendance where GRADE-LEVEL-CODE is 03-12.
- (3) 43415-0007: For a CourseTranscript, there must be Attendance and/or Flexible Attendance with a matching TX-UNIQUE-STUDENT-ID and CAMPUS-ID-OF-ENROLLMENT.
- 43415-0008: For each CourseTranscript, there must be a corresponding Course SectionExtension where CAMPUS-ID-OF-ENROLLMENT matches CAMPUS-ID, and SERVICE-ID, CLASS-ID-NUMBER, and COURSE-SEQUENCE-CODE are the same.
- (4) 43415-0009: There should not be more than six Course Transcripts for a particular TX-UNIQUE-STUDENT-ID.
- 43415-0011: For a particular CAMPUS-ID-OF-ENROLLMENT, TX-UNIQUE-STUDENT-ID, SERVICE-ID, CLASS-ID-NUMBER, and COURSE-SEQUENCE-CODE, there may be only one CourseTranscript.