PEIMS Transcript Records Verification Report
On this page:
Introduction
This is a verification report for the course completion transcript records reported in PEIMS Student Transcript Interchange.
Selection Criteria
A separate record is output for each PEIMS Course Transcript record as reported in the Transcript Interchange.
If the SUMR collection is selected, these records are included:
Completed high school credit classes based on the TEA C022 Service ID table in PowerSchool
Completed TX VSN courses with Non-Campus Based Instruction Code of 04 or 05
If the EXYR collection is selected, manual entry stored grades records for Dual Credit or College Prep courses taken over the summer are included when the following conditions are met:
The Associated Section must be “None”
The Special Explanation Code must be “R” (summer or night school)
The school year in the record is the prior school year
For College Prep Courses, the Service ID must be CP110100 (College Prep English Language Arts) or CR111200 (College Prep Mathematics)
Report Input
Each of the available run options and data fields for the report are described below. For help with report navigation and generation, see Generate Reports.
Note: To include all modifications within the specified start and end date, leave the Modified options blank.
Field | Description |
|---|---|
Select Schools | The multi-select list allows the user to use the Ctrl or SHIFT key on your keyboard to click each school for which you want to run the extract. Note: At the school level, only the current school is available. |
Select Students | Select one of the following to indicate which students to include in the report:
Notes:
|
| Collection Code | Collection Code with options for SUMR and EXYR |
| School Year | Select the school year |
| Specify Incomplete Grades | |
Records to Include
| |
| Select Yes if you want to Exclude Students with Missing Unique ID | |
| Select Yes if you want to |
Report Output
Data Element | Description | [Table]FieldName |
|---|---|---|
Last Name | The student's last name. | [Students]Last_Name |
| First First | The student's first name. | [Students]First_Name |
| Student Number | The student's locally assigned ID number. | [Students]Student_Number |
| UID | The student's state-assigned ID number. | [Students]State_StudentNumber |
| Grade Level | The student's grade level at the time of the record. | [Students]Grade_Level |
| Current School | The school where the record exists. | [Schools]Name |
| Record Type | The record type | |
| School ID | The school ID | [Schools]ID |
| Remote School | The remote school | [Schools]Alternate_School_Number [Schools]School_Number |
| Course Name | The course name | [Courses]Course_Name |
| Course # | The course number | [Courses]Course_Number |
| Section | The section ID | [Sections]Section_Number |
| Section ID | The section ID | [Sections]Section_ID |
| Service ID | The alternate course number. | [Courses]Alt_Course_Number |
| Class ID | The class ID number | [Prefs]tx_classid_part1 [Prefs]tx_classid_part2 [Prefs]tx_classid_part3 [Prefs]tx_classid_part4 [Prefs]tx_classid_part5 |
| Store Code | The store code associated with the record | [StoredGrades]StoreCode |
| Course Seq | The course sequence | [S_TX_CRS_X]Course_Sequence |
| Grade | The grade earned for the course | [StoredGrades]Grade |
| Percent | The numeric grade earned for the course | [StoredGrades]Percent |
| Course Credit | The course credit | [S_TX_CRS_X]Course_Credit |
| Pass/Fail Credit | The PEIMS Pass/Fail Credit Indicator code for the course. | [StoredGrades]GPA_Custom2 |
| Dual Credit | Dual credit | [S_TX_CRS_X]E1011_Dual_Credit [S_TX_SEC_X]E1011_Dual_Credit |
| College Credit | The college credit | [S_TX_CRS_X]E1081 [S_TX_SEC_X]E1081_College_Credit |
| ATC | ATC Indicator | [S_TX_CRS_X]E1058_ATC_Indicator [S_TX_SEC_X]E1058_ATC_Indicator |