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: The Select [Number] Students Only - Run the report for a predefined selection of students. All Students - Run the report for all students who meet selection criteria. Notes: When running for a selection of students, select the students from the Start Page prior to running the report. When All Students is the selected option, the report includes both active and inactive students who have at least one enrollment record during the date range for the report Start Date and End Date.
Collection Code	Collection Code with options for SUMR and EXYR
School Year	Select the school year
Specify Incomplete Grades	Specify Incomplete Grades
Records to Include	Records to Include All (default) Scheduled Classes Remote Classes Manual Entry Stored Grades
Exclude Students with Missing Unique ID*	Select Yes if you want to Exclude Students with Missing Unique ID
Exclude Students with Missing SSN*	Select Yes if you want to Exclude Students with Missing SSN*

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