TX Interchange Student Transcript

Contents

Introduction

The interchange schema for Student Transcript information is used to exchange information about a student's academic record and completed courses.

Selection Criteria

The following selection criteria determine which database records are used in the Extended Year collection. Refer to selection criteria for analysis when the report does not return the correct records.

TX Interchange Student Transcript: Version 23.9.1 - The Transcript Interchange is updated with logic to source the Pass/Fail Indicator Code from the calculated value in the stored grades record (S_TX_SGR_X.E0949_PF_Calc). If no calculated value exists in stored grades, the calculation is executed on-the-fly.

The PEIMS Extended Year stored grades selection criteria is updated to first check for the Dual Credit Indicator in the stored grades record. If blank, the logic then examines the Dual Credit flag in courses. Records are no longer bypassed due to a missing Dual Credit indicator in stored grades as long as the stored grades record references a district course number where Dual Credit is set to Yes.

Submission 3: Summer Collection

Scheduled Classes and Manual Entry Stored Grade Selection

The scheduled class or stored grade must be associated with the current academic year.
The scheduled class or stored grade must be associated with a student who is or was enrolled in the current year in grades 1-12.
The scheduled class or stored grade must be associated with a student who has a PEIMS General record in effect for at least one day in the current school year, and is not excluded from State Reporting.
The scheduled class or stored grade must not be associated with a course or section which is excluded from 090 reporting.
The stored grade record must not be excluded from 415 reporting.
The Service ID (Alternate Course Number) must not start with SA, SE, SR, SS, 01, 8, or 9.
The Service ID (Alternate Course Number) must not equal 02497009, 02510001, 02520004, 02530002, 02540005, 02550020, 02560005, 02561005, 02620001, 02630001, 02640005, 02650000, 02660009, 02670000, 11400000, 11401800, or 11403600.
The Explanation code for the stored grade must not equal R (summer school), L (local course), or 3 (course taken outside the Texas public/charter school system).
The Alternate CDC Number (if populated) for the stored grade must match a school in the district.
The stored grade record must be for a store code that is mapped as a Final Grade Type of S1, S2, or Average in Texas Store Code Mapping.

Submission 4: Extended Year Collection

Dual Credit Summer School Classes and Manual Entry Stored Grade Selection

The stored grade must be associated with the prior academic year.
The stored grade must not be excluded from 415 reporting.
The stored grade must be associated with a student who was enrolled in the prior school year, or is enrolled in the current year, and is not excluded from State Reporting.
The stored grade must be associated with a student who has a PEIMS General record in effect for at least one day in the prior school year.
The stored grade must be associated with a student who meets the Dual Credit summer school class criteria OR the Bilingual/ESL Summer School or Extended Year Services.
The stored grade must not be associated with a course or section which is excluded from 090 reporting.
The Explanation code for the stored grade must equal R.
The Dual Credit Indicator for the stored grade record must equal 1.
The Alternate CDC Number (if populated) for the stored grade must match a school in the district.
The stored grade record must be for a store code that is mapped as a Final Grade Type of S1, S2 or Average in Texas Store Code Mapping.

Report Input

Each of the available run options and data fields for the report are described below.

Field	Description
Select Schools	At the District Level: Select All Schools to run the extract for all schools not excluded from state reporting. Select Multiple Schools allows the user to use the Ctrl or SHIFT key on your keyboard to click each school you want to run the extract. At the School Level: Select All Schools to run the extract for all schools not excluded from state reporting. Select Current School Only to run the extract just for the current school.
Current Selection Students*	Indicate which students to include in the report by selecting one of the following options: The selected [number] students only – Run the report for students in the current selection. All students – Run the report for all students in the current school or district that meet the selection criteria. Note: If running the report for a single student, or group of students, select the students prior to running report.
Collection Code	Choose the Collection from the pop-up menu for the report generated. This option controls the naming of the file. TSDS is for the Dashboard.
School Year	Choose the School Year from the pop-up menu for the report generated.
Run Now	Select this option if the user wants to run the report immediately.
Schedule	Select this option if the user wants to run this report on a scheduled basis. Once this option is selected the following choices are: Run Once Start Date and Start Time to run the report. Repeat Select Daily, Weekly, Monthly or Yearly for the appropriate re-occurrence for running the report. If Daily is selected, check the Weekdays only box to limit to weekdays. If Weekly is selected, check which weekday to run the report. If Monthly is selected, check the month to run the report. If Yearly is selected, select either the date or the weekday to run the report. Date Range – Select No End Date or a date that the re-occurrence should end.

Back to Top

Report Output

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.

Filename for the PEIMS:

The filename must be in the following format:

District Code: Position 1-6

Underscore: Position 7, 11, 21 and 34.

Campus ID: Position 8-10 – If the file is generated by a user from the District Office, this value is 000. If the file is generated by a user from a school, this value is the three-digit campus id for that user. This allows partial files to be submitted that contain data only for one school.

Collection Code: Position 12-20. This starts with the ending year of the school year followed by the five characters Collection Code (i.e. FALL1).

Timestamp: Position 22-33 – This is YYYYMMDDHHMM where YYYY is year, MM is month, DD is day, HH is hour, and MM is minute.

Interchange: Position 34 starts the name of the Interchange – InterchangeStudentTranscriptExtension.xml

Data Element	Description	[Table]Fields	Collection
Student Academic Record
Student Academic Record – id=ID_SAR_xxx_ccc_sss where xxx is the Unique Student ID, ccc is the Term ID, and sss is the School ID in which the student has stored grades.
	Student Reference
	Student Identity
Student Unique State ID	Unique State Student Number	[Students]State_StudentNumber	SUMMER, EXTENDED YEAR
	Course Reference
	Course Identity
	Course Code
Identification System	Hard coded to State course code	Hard coded	SUMMER, EXTENDED YEAR
ID	Service ID for the course on this stored grade.	[S_TX_SEC_MIXGRD_C]Service_ID [S_TX_SCH_MIXGRD_C]Service_ID [CoursesCoreFields]Alt_Course_Number	SUMMER, EXTENDED YEAR
	Education Organization Reference
	Educational Org Identity
State Organization ID	The School ID for this stored grade.	[Prefs]Value [Prefs]Name=districtnumber	SUMMER, EXTENDED YEAR
TX-Grade Level	The grade level of the student on the stored grade.	[StoredGrades]Grade_Level	SUMMER, EXTENDED YEAR
TX-Pass Fail Credit Indicator	The pass/fail code for the stored grade. Default values: Non-HS credit courses (elementary or regular middle school): 13 (Non-High School Course Passed). If a course was completed, but a final grade is not yet entered, or cannot be identified due to incomplete/incorrect Stored Code Mapping: 09 (Course Work Is Incomplete And No Credit Has Been Awarded).	[StoredGrades]GPA_Custom2 If the Pass/Fail Credit Indicator is not populated, this field reports a value of 01 if the final grade is a passing grade, or 02 if the final grade is a failing grade.	SUMMER, EXTENDED YEAR
TX-Dual Credit Indicator	The dual credit code for the stored grade.	[S_TX_SGR_X]Dual_Credit [StoredGrades]Comment_Value [S_TX_SEC_X]E1011_Dual_Credit	SUMMER, EXTENDED YEAR
TX-ATC Indicator	The Advanced Technical Credit indicator for the stored grade.	[S_TX_SGR_X]ATC_Indicator_Code [S_TX_SEC_X]E1058_ATC_Indicator	SUMMER, EXTENDED YEAR
TX-College Credit Hours	The number of college credit hours earned for this stored grade if it is a dual credit course.	[S_TX_SGR_X]College_Credit_Hours	SUMMER, EXTENDED YEAR
TX-Campus Of Enrollment	The county district campus number of the campus where the student is enrolled.	[S_TX_STU_ESY_C]E0782_Campus_ID	SUMMER, EXTENDED YEAR
TX-Course Sequence Code	The course sequence code for the stored grade.	[S_TX_CRS_X]Course_Sequence [S_TX_SGR_X]E0948	SUMMER, EXTENDED YEAR
Unique Section Code	The Class ID number for the stored grade.	[S_TX_SGR_X]Class_ID_Number Calculated	SUMMER, EXTENDED YEAR
TX-OnRampsDualEnrollmentIndicator	The OnRamps Dual Credit indicator.	[S_TX_SGR_X]E1597_OnRamps [S_TX_SEC_X]E1597_OnRamps [S_TX_CRS_X]E1597_OnRamps If the OnRamps value equals 1: Then if the student has a passing final grade for the class, this field is reported a value of 1. Then if the student has a failing or missing final grade for the class, both this field and College Credit Hours field reports a value of 0.	SUMMER

Back to Top