Student Transcript (TSDS) (Texas)

Last Modified on 10/22/2022 10:38 am CDT

Classic View: TX State Reporting > TSDS Extract > Student Transcript

Search Terms: Student Transcript

The Student Transcript is used to exchange a wide range of grade information. The schema can be used to exchange a complete academic record, select transcript information, report card grades for a grading period, or end-of-year report card or graduation associated with a student.

TSDS Extract Editor/Student Transcript

Report Logic

Logic for the Student Transcript differs based on the Submission selected. See the following section for information about reporting logic per submission.

Enrollment records are ignored if:

  • The ADA Eligibility Code = 0 or blank.
  • Student ID is blank/null.
  • The State Exclude field is marked. 
  • The enrollment record is for a grade level marked Exclude from State Reporting.
  • The student is in grades EE, PK or KG.
  • The enrollment record is in a calendar marked Exclude.
  • The No Show checkbox is marked.

Submission 3

  • All enrollment records with a Service Type of Primary are reported.
  • For all courses, if a student repeats a course during the year with a different outcome, each Course Completion is reported.

Course/section records are ignored if:

  • The State Code (Service ID) on the Course Editor and the State Code Override on Roster Batch Edit are both blank.
  • State Code (Service ID) begins with a value of SA, SE, SR, SS or 8.

  • There is NO Grading Task that has a Pass/Fail Credit Code marked, OR

    • there is NO Grading Task that has the Display Pass/Fail Credit Code box checked, OR

    • there IS a Grading Task with the Display Pass/Fail Credit Code box checked BUT the Course/Section effective dates occur after the fall snapshot.

Submission 4

  • One record is reported for each unique class (course/section where the Course is equal to Dual Credit) that was attended during the summer (between school years) for the purpose of the student attempting to earn dual credit.
  • A course is considered Dual Credit if the Dual Credit field is marked on the course.
  • No teacher is required to be identified on the course/section in order for a record to report.
  • There cannot be more than six records reported for a particular Student ID.
  • Students in grade levels 1-12 must meet all of the following criteria in order to report:
    • Student must be enrolled in a Summer School Calendar (enrollment).
    • Student will have a Summer School Calendar attached to the Main School and have a Summer School enrollment record with a Roster schedule for the Summer school enrollment.
    • The Summer School calendar is selected on the extract editor.
    • The Summer School field is marked on Calendar > Calendar.
    • Dual Credit Indicator field is marked on the Course Editor.
    • A Student may only report one record per Class ID Number (sectionID).
    • The Course must have a Grading Task where the Pass/Fail Credit Indicator box is marked.
    • Grading Tasks must have a Code value of CG and/or F and the State Reporting field is marked.
    • A Grading Score associated to the Grading Task of CG and/or F does not need to be posted for a student in order for a Section to report.
    • If the Dual Credit Course does not contain a Grading Score for the Grading Task CG, than the College Credit Hours would report 0 and the Dual Credit Indicator Code would report a 1.
    • The student does NOT need to be in Membership to report (ADA Eligibility can be equal to 0 - 8).
    • Multiple records will report if the Course > Section has multiple State Codes (Service ID's) within the Roster Batch Edit (Course State Code override) and a student is/was actively enrolled into that Course > Section at any time during the Summer school enrollment.
    • Students who dropped the Dual Credit Course at some point during their Summer School Enrollment will report a record even if the student was enrolled for 1 day.
    • If there is no enrollment with a Service Type of P, than report from the Summer School enrollment where the Service Type is equal to S or N as long as that enrollment record fits all criteria for reporting.

A course/section is ignored if:

  • The Dual Credit field is not marked.
  • The State Code (Service ID) on the Course Editor and the State Code Override on Roster Batch Edit are both blank.
  • State Code (Service ID) begins with a value of SA, SE, SR, SS or 8.
  • There is no Grading Task that has a Pass/Fail Credit Code marked.

Enrollment records are ignored if:

  • The ADA Eligibility Code = 0 or blank.
  • Student ID is blank/null.
  • The State Exclude field is marked. 
  • The enrollment record is for a grade level marked Exclude from State Reporting.
  • The student is in grades EE, PK or KG.
  • The enrollment record is in a calendar marked Exclude.
  • The No Show checkbox is marked.

Definition of Course Completion for TX: Grading Score is entered for a State Reported Grading Task (codes CG or F) where the Pass/Fail Credit Indicator box is checked on the Grading Task - Course > Grading Tasks > Course Grading Task Editor and the Pass/Fail Indicator Code is greater than 00.

Report Editor

Field Description
Submission

3 - Summer

4 - Extended
Interchanges
Interchanges are XML Schema Definitions (XSDs) which group related complex types.

Select Student Transcript.
Effective Date

Only data as of this date reports. Default value is today's date.
Status
  • Regular
  • Resubmission
  • Working Collection
Report Type XML
Filter By

This field allows you to narrow the report results to specific Calendars, Calendar Years (District), or Schools.

Option Description
Calendar

This option allows you to select the specific calendar(s) to include in the report.
District

This option allows you to select the specific Calendar Year to include in the report.

            
School

This option allows you to select the specific school(s) to include in the report.
Population This option allows you to limit report results to Unique IDs. The Unique ID option only considers students with a Unique ID. The All option considers all students.
Ad Hoc Filter Select an Ad Hoc filter to limit report results to those that meet filter requirements.

Report Generation

The report can be marked to generate immediately using the Generate Extract button or can be marked to generate at a later time using the Submit to Batch button. See the Batch Queue article for additional guidance. 


XML Elements

StudentAcademicRecord

Submission 3 ONLY: 

  • Only students in grades 9-12 will report UNLESS a student in grades 3-8 is taking a course where a high school credit is earned.
  • A course is considered as high school credit if:
    • The course has a Special Explanation code of J OR the student has a Special Explanation code of J assigned to them in the Roster Batch Edit tool. 
Element
 Description
 Location
StudentAcademicRecordId
 N/A

Submission:
3, 4
 N/A
StudentReference
StudentIndentity > StudentUniqueStateId
 The reporting student's unique Student ID. Students with no Texas-unique Student ID are not reported.

Submission:
3, 4

Numeric, 10 digits
 Census > People > Demographics > Student Unique State ID

Database:
Student.stateID

CourseTranscript

Submission 3 ONLY: 

  • Only students in grades 9-12 will report UNLESS a student in grades 3-8 is taking a course where a high school credit is earned.
  • A course is considered as high school credit if:
    • The course has a Special Explanation code of J OR the student has a Special Explanation code of J assigned to them in the Roster Batch Edit tool. 
Element
 Description
 Location
CourseReference

CourseIdentity > CourseCode IdentitificationSystem

Required


 Reports as State course code.

Submission:
3, 4

String, 31 characters
 N/A

CourseIdentity > CourseCode IdentitificationSystem > ID

Required

Reports the State Code from the course.


If a student is enrolled in the course that has Course State Code (override) value, then the Course State Code (override) value is reported.


A course with a blank State Code (Service ID) will not report unless a Course State Code (override) value exists in the Roster Batch Edit.


A course State Code or Course State Code (override) value that begins with SA, SE, SR, SS or 8 are not reported.


For Submission 4 only, ServiceIDs beginning with an A are not reported.


Submission:

3, 4


Coded, 8 characters

Scheduling > Course >   Course/Section > Section Editor > Roster Batch Editor > Section ID

OR 

Scheduling> Course > Course Editor > State Code


Database:
Section.sectionID
EducationOrganizationReference

EducationalOrgIdentity > StateOrganizationId

Required


 The District Number (6 digits) + State School Number (3 digits) of the school where the teacher/staff performs their services.

Submission:
3, 4

Coded, 9 characters

System Administration > Resources > District Information > State District Number 


System Administration > Resources > School > School Detail > State School Number


Database:
District.number School.number

StudentAcademic
RecordReference

Required


 N/A

Submission:
3, 4
 N/A

TX-GradeLevel

Required


 The student's grade level per their most recent active enrollment as of the Effective Date (Snapshot Date: last Friday in October).

Submission:
3, 4

Coded, 2 characters
 Student Information > General > Enrollments > General Enrollments Information > Grade Level

Database:
Enrollment.grade

TX-Pass
FailCreditIndicator

Required

Submission 3 Logic


The Pass/Fail Indicator can only be reported from a Grading Task that has a code of CG and/or F where the State Reporting field is marked and the Grading Task has value in the Pass/Fail Credit Indicator field.


If the Pass/Fail Indicator code is null/blank on the Grading Task with a Grading Score entered, a value of 00 is reported. If a Pass/Fail value exists, the Pass/Fail Indicator value is reported. If no Grading Score is entered on the Grading Task, the Pass/Fail Indicator will report as 00.


For High School courses: If there is a Grading Score for the Grading Task with a value of CG and the State Reporting checkbox is marked and a Grading Score for a Grading Task with a value of F and the State Reporting field marked and the Pass/Fail Indicator code is entered on both tasks, the Pass/Fail Indicator code from the Grading Score containing a value of CG will report.


For Non-High School courses: If there is a Grading Score for the Grading Task with a value of A and the State Reporting checkbox is marked and there is a Grading Score for the Grading Task with a value of CG and the State Reporting checkbox is marked and a Grading Score for a Grading Task with a value of F and the State Reporting field marked and the Pass/Fail Indicator code is entered on both tasks, the Pass/Fail Indicator code from the Grading Score containing a value of F will report.


Submission 4 Logic


A Pass/Fail Indicator code is only reported from Grading Tasks with a value of CG, the State Reporting field marked and the Grading Task has the Pass/Fail Indicator field marked. 


Otherwise, the Pass/Fail Indicator from the Section > Grading by Task or Grading by Student is reported if the student has a Grading Score associated with the CG Grading Score associated with the CG Grading Task that is not null. 


A value of 00 is reported if there is no Grading Score entered on the CG Grading Task where the Pass/Fail Indicator is marked.


If there is a Grading Score for the Grading Task with a code of CG,the State Reporting field is marked, Grading Score for the Grading Task is a value of F with the State Reporting field as marked and there is a value in the Pass/Fail Indicator field, the Pass/Fail Indicator from the Grading Score with a value of CG is reported.


Submission:

3, 4


Coded, 2 characters

Course/Section > Section > Grading By Task > Pass/Fail Codes

AND

Course/Section > Section >   Grading by Student > Pass/Fail Codes


Database:
Calculated, not dynamically stored

TX-DualCredit
Indicator

Required

Submission 3 Logic

  • If Dual Indicator is No, a value of 0 is reported.
  • If Dual Indicator is Yes, a value of 1 is reported.

Submission 4 Logic

  • If Dual Indicator is Yes, a value of 1 is reported.
  • If Dual Indicator is No, the course/section is not reported.
Submissions:
3, 4

Coded, 1 character
 Course/Section > Course Editor > Dual Credit Indicator

Database:
Course.dualCredit

TX-ATCIndicator

Required

Submission 3 Logic

  • If ATC Indicator is marked, a value of 1 is reported.
  • If ATC Indicator is not marked, a value of 0 is reported.

Submission 4 Logic

  • A value of 0 is reported for all records.
Submissions:
3, 4

Coded, 1 character
Course/Section > Course > ATC Indicator Code

Database:
Course.cteWork BasedInstruction
TX-CollegeCredit
Hours
Optional

Default value is 0 for grade levels 1-12.


If College Credit Hours is greater than 0 and the student has a Course Completion Code = 1 and there is a Grading Score, the College Credit Hours value entered is reported. If the student reports a Course Completion Code = 1 and the Pass/Fail is a value other than 01, 04 or 05, a value of 0 is reported, regardless if a College Credit Hours value exists. If Course Completion = 0, a value of 0 is reported regardless if a College Credit Hours value exists.


Submissions:
3, 4

Numeric, 2 digits
 Course/Section > Course   Editor

Database:
Calculated, not dynamically stored

TX-CampusIdOf
Enrollment

Required


 The District Number (6 digits) + State School Number (3 digits) of the school the student attends.

Submissions:
3, 4


Coded, 9 characters

System Administration > Resources > District Information > State District Number 


System Administration > Resources > School > School Detail > State School Number


Database:

District.number

School.number

TX-CourseSequence

Required

The unique part(s) of a course when a course is taught during a single grading period, semester, or across multiple grading periods or semesters,


The code for the first semester of Algebra I is reported as 1, no matter if the course is taken in the fall semester or the spring semester.


Submissions:

3, 4


Coded, 2 characters
 Course/Section > Course   Editor > Sequence Code

Database:
Calculated, not dynamically stored

UniqueSectionCode

Required

A number identifying a unique course section, that is unique for a particular school year, Campus, and SERVICE-ID.


If the course only contains students with a Course State Override value, the original Section ID does not report. ONLY the Section IDs with alpha numeric characters report as there are no students tied to the original Section ID.


Submissions:

3, 4


Alphanumeric, 14 characters
 Scheduling > Course > Course Editor > SectionID

Database:

CourseSection.

sectionNumber

TX-OnRampsDualEnrollmentIndicator

Optional


 If the Onramps Dual Credit checkbox is marked in Course/Section > Course, 1 reports in this element. Otherwise, this element does not report.

Submissions:
Currently NOT reporting

Numeric, 1 digit
 Course/Section > Course > Onramps Dual Credit

Database:
Course.substituteCredit


Previous Versions

Student Transcript (TSDS) (Texas) [.1949-.2024]

Related Articles

Was this helpful?
Thank you for your feedback!
User Icon

Thank you!

Copyright ©️ 2010-2023 Infinite Campus, Inc. All rights reserved. | Terms of Use | Privacy Policy | infinitecampus.com