STS - Student Transcript System

Select Schools

Choose one of the following:

• Current School Only – Includes all student records associated with the current school that meet selection criteria. To change the current school, click the School link at the top of the page and choose the appropriate school from the list.
• All Schools – Includes all student records on the PowerSchool server that meet selection criteria. Only available when running the report from the District Office.

Select District

(Optional) If this option appears, select the District for which to run the report.

Select 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.

If you are running the report for a single student, or a group of students, select the students before running the report.

Report Start Date

Enter the report start date.

Report End Date

Query Type (Usedbyquery)*

Choose one of the following file types.

• 1 – Uses Partial File Indicator
• 3 – All Students

File Type 1 extracts students with a Partial File Indicator. If you run the report for the current selection of students, File Type 1 extracts students in the current selection with a Partial File Indicator.

File Type (Used for header record)*

Choose one of the following file types.

• 1 – 1 is placed in the header record
• 3 – 3 is placed in the header record

File Type 1 extracts students with a Partial File Indicator. If you run the report for the current selection of students, File Type 1 extracts students in the current selection with a Partial File Indicator.

LEA Code*

Enter the three-digit LEA code for the District.

• If sub-districts are set up and the current school is included in a sub-district, the LEA code defaults to the first three characters of the associated sub-district number. If sub-districts are set up and the current school is not included in a sub-district, the LEA code defaults to the first three characters of the district number.
• If sub-districts are set up but PowerSchool is set to report from the district level, the LEA code defaults to empty and a value must be entered.
• If no sub-districts are set up, the LEA code defaults to the first three characters of the district number.

Grade Point Max Regular*

Enter the 3 digit Grade Point Maximum value for Regular classes (no decimal)

Example: 4.00 will be entered as 400

Applies to Course/Section/StoredGrade records with a Course Type Code of ‘RG’

Grade Point Max - Honors

Enter the 3 digit Grade Point Maximum value for Honors classes (no decimal)

Example: 5.00 will be entered as 500

Applies to Course/Section/StoredGrade records with a Course Type Code of ‘HR’

Grade Point Max - Gifted

Enter the 3 digit Grade Point Maximum value for Gifted classes (no decimal)

Example: 4.00 will be entered as 400

Applies to Course/Section/StoredGrade records with a Course Type Code of ‘GT’

Grade Point Max – Adv Placement

Enter the 3 digit Grade Point Maximum value for Advanced Placement classes (no decimal)

Example: 5.00 will be entered as 500

Applies to Course/Section/StoredGrade records with a Course Type Code of ‘AP’

Grade Point Max – Intl Baccalaureate

Enter the 3 digit Grade Point Maximum value for International Baccalaureate classes (no decimal)

Example: 4.00 will be entered as 400

Applies to Course/Section/StoredGrade records with a Course Type Code of ‘IB’

Grade Point Max – Special Ed

Enter the 3 digit Grade Point Maximum value for Special Education classes (no decimal)

Example: 4.00 will be entered as 400

Applies to Course/Section/StoredGrade records with a Course Type Code of ‘SE’

Grade Point Max – Talented

Enter the 3 digit Grade Point Maximum value for Talented classes (no decimal)

Example: 4.00 will be entered as 400

Applies to Course/Section/StoredGrade records with a Course Type Code of ‘TA’

Grade Point Max – Dual Enrollment

Enter the 3 digit Grade Point Maximum value for Dual Enrollment classes (no decimal)

Example: 4.00 will be entered as 400

Applies to Course/Section/StoredGrade records with a Course Type Code of ‘DE’

Grade Point Max – Dual Enrollment/ Honors

Enter the 3 digit Grade Point Maximum value for Dual Enrollment/Honors classes (no decimal)

Example: 4.00 will be entered as 400

Applies to Course/Section/StoredGrade records with a Course Type Code of ‘DH’

Grade Point Max – Dual Enrollment/ Advanced Placement

Enter the 3 digit Grade Point Maximum value for Dual Enrollment/ Advanced Placement classes (no decimal)

Example: 4.00 will be entered as 400

Applies to Course/Section/StoredGrade records with a Course Type Code of ‘DA’

Grade Point Max – Dual Enrollment/ International Baccalaureate

Enter the 3 digit Grade Point Maximum value for Dual Enrollment/ International Baccalaureate classes (no decimal)

Example: 4.00 will be entered as 400

Applies to Course/Section/StoredGrade records with a Course Type Code of ‘DI’

Check to include GPA and Rank

Select this checkbox to include GPA and Class Rank in the extract

Credit Value for 7^th Sem Grades

Enter the three-digit credit value of your 7th-semester grades (no decimal).

Example: 0.50 will be entered as 050

If a grade has potential credit hours or earned credit hours of 0, this value will be used instead of 0.

Include students with the following exit codes (Multiple codes can be selected)

Select the exit codes that will be used for student selection.

All active and inactive students with exit codes matching the exit codes selected will be included in the report.

Check to report Pre-Sept 1^st Graduates Only

Select to output Pre-September 1^st graduates only.

Check to override Grade Point Maximum Count (not used)

This parameter is no longer used.

Select Sub District

If your District has sub-districts, select the sub-district.

1

System Indicator

Always extracted as “STS.” Required.

“STS”

3

1

2

Transaction Code

Always extracted as “020.” Required.

“020”

3

4

3

Session Year

The year of a school session, such as 2017-2018. This is the school year selected at report runtime. To change this value, click Term at the top of the page, choose the correct term, and re-run the report.

Required.

[Terms]FirstDay

[Terms]LastDay

4

7

4

LEA/Sponsor Code

The sponsor code of the district submitting data. The report extracts the first three digits of the site code. The value is extracted from the Student Override Site Code field on the Louisiana State Information page. Otherwise, the value is extracted from the Edit School page at the district level.

Required.

Notes:

• If sub-districts are set and the current school is included in a sub-district, the LEA code defaults to the first three characters of the associated sub-district number. If sub-districts are set and the current school is not included in a sub-district, the LEA code defaults to the first three characters of the district number.
• If sub-districts are set but PowerSchool is set to report from the district level, the LEA code defaults to empty and needs to be entered.
• If no sub-districts are set, the LEA code defaults to the first three characters of the district number.

[S_LA_STU_X]SiteCodeOverride

[S_LA_SCH_X]SiteCode

3

11

5

Student’s State ID Number

The student’s state-assigned identifier. Required.

[Students]State_StudentNumber

10

14

6

Student’s Local ID Number

The locally assigned student identifier.

[Students]Student_Number

9

24

7

School/Site Code

The sponsor code of the district submitting data. The value is extracted from the Student Override Site Code field on the Louisiana State Information page. Otherwise, the value is extracted from the Edit School page at the district level.

Required.

[S_LA_STU_X]SiteCodeOverride

[S_LA_SCH_X]SiteCode

6

33

8

Partial Student First Name

The first character of the student’s first name.

Derived from [Students]First_Name

1

39

9

Filler

Filler

Spaces

28

40

10

Partial Student Last Name

The first three characters of the student’s last name.

Derived from [Students]Last_Name

3

68

11

Filler

Filler

Spaces

22

71

12

Day of Birth

The day the student was born as appears on the student’s birth certificate.

Derived from [Students]DOB

2

93

13

Filler

Filler

Spaces

5

95

14

Gender Code

The student’s gender.

Valid values:

• M – Male
• F – Female

[Students]Gender

1

100

15

Grade Placement Code

The student’s grade level as of the submission year.

Valid values:

• 06-08
• T9-12

[Students]Grade_Level

If [Students]Grade_Level = 9 and [S_LA_STU_TransNinthGrade_X] TransNinthYearID = current school year ID then T9.

2

101

16

Grade 9 Entry Year

The year during which the student entered grade 9. For example, 2018 for 2017-2018. Required only for grade levels T9-12.

[S_LA_STU_Academics_X] YearEnteredNinthGrade

4

103

17

Graduation Date

The date of the student’s graduation. This date must fall between 9/1 and 8/31 of the current beginning school session year (such as 2018 for 2017-2018). This field should be blank if the student did not graduate or has not met all graduation requirements.

[S_LA_STU_Academics_X] GraduationDate

8

107

18

Career Option Code

The student's career option code, if applicable, which corresponds to the Area of Concentration or Jumpstart Pathway in the TOPS Core Reference Tables. Blank if not applicable or if the student is in grades 6-8.

See the Appendix for valid values.

Reporting_Value from Career_Option_Code code set for [S_LA_STU_Academics_X] CareerOptionCode field

3

115

19

Academic Endorsement

The student’s academic endorsement, if applicable. Used for students in grades T9-12 only.

[S_LA_STU_Academics_X] AcademicEndorsement

2

118

20

Career/Tech Endorsement

The student’s career/tech endorsement, if applicable. Used for students in grades T9-12 only.

[S_LA_STU_Academics_X] CareerTechEndorsement

2

120

21

Met Assessment Requirements for Diploma

Indicates if the student met the requirements on GEE, if applicable.

Valid values:

• Y – Student met graduation requirement on GEE or EOC
• N - The student has not taken or not successfully passed the subject area assessment

Used for students in grades T9-12 only.

[S_LA_STU_Academics_X] MetAssessRequirementsDiploma

1

122

22

Local GPA

The GPA of the student using a local (non-state) GPA Calculation Method. The GPA Calculation Method must be set up with the name LASRC via Start Page > District Setup > GPA Calculations > Calculation Methods > New/Edit GPA Calculation Method. See District Setup for more information.

[Gen]Name=LASRC

8

123

23

Local Rank in Class: Position in Class

The student’s rank placement within the grade level. This field is optional. The value is calculated using a Class Rank Method with the name LASRC, which must be set up via Start Page > School Setup > Class Rank > Class Rank Methods. See School Setup for more information. If there is no value for the field, then the words Not Ranked are reported.

Used only for students in grades T9-12.

[Gen]Name=LASRC

[Gen]Cat=classrankmethod

4

131

24

Local Rank in Class: Size of Class

The size of the class for the student’s grade level. This field is optional. If there is no value for the field, then the words Not Ranked are reported.

Valid values:

• Y – Yes
• N – No

Used only for students in grades T9-12.

[Gen]Name=LASRC

[Gen]Cat=classrankmethod

4

135

25

Hispanic/Latino Ethnicity Flag

Indicates if the student’s ethnicity is Hispanic.

Valid values:

• Y – Yes
• N – No

[Students]Fedethnicity

1

139

26

American Indian or Alaskan Native Race Flag

Indicates if the student’s race is American Indian or Alaskan Native.

Valid values:

• Y – Yes
• N – No

[StudentRace]RaceCd = AA

1

140

27

Asian Race Flag

Indicates if the student’s race is Asian.

Valid values:

• Y – Yes
• N – No

[StudentRace]RaceCd = AS

1

141

28

Black or African American Race Flag

Indicates if the student’s race is Black or African American.

Valid values:

• Y – Yes
• N – No

[StudentRace]RaceCd = BA

1

142

29

Native Hawaiian or Other Pacific Islander Race Flag

Indicates if the student’s race is Native Hawaiian or Other Pacific Islander.

Valid values:

• Y – Yes
• N – No

[StudentRace]RaceCd = NO

1

143

30

White Race Flag

Indicates if the student’s race is white.

Valid values:

• Y – Yes
• N – No

[StudentRace]RaceCd = WH

1

144

31

Diploma Pathway

Indicates the diploma pathway the student has chosen.

Valid values:

• Blank
• CA – TOPSTech Jumpstart Career Diploma
  
• L1 – TOPSTech Jumpstart Career Diploma alternate pathway for students assessed on LAA1
• TU – TOPS University Diploma
  
• ND – Not Declared
• CD – Historical career diploma/older graduates.
• NG - Non-Graduate/Non-Diploma Seeking
• C4 – Core 4 pathway (Discontinued for students who graduated 2016-17 and later.)
• C5 – Basic Core pathway (Discontinued for students who graduated 2016-17 and later.)
• C6 – Core 4 with CTE (Discontinued for students who graduated 2016-17 and later.)

Required for students in grades T9-12 only.

[S_LA_STU_Demographics_X] DiplomaPathway

[S_LA_REN_X]DiplomaPathway

2

145

32

LOSFA/BOR Consent Flag

Indicates if a parental consent form is on file with the school allowing the school to disclose transcript data to LOSFA or postsecondary institutions.

Valid values:

• Y – Yes
• N – No

[S_LA_STU_X]LOSFAConsentFlag

[S_LA_REN_X]LOSFAConsentFlag

1

147

33

FAFSA Collection

Indicates if the student has a FAFSA application on file.

Valid values:

• 1 - FAFSA Completion
• 2 - TOPS Form Completion
• 3 - Parental/Guardian Waiver
• 4 - Hardship Waiver
• Blank if unknown or not completed (non-graduates)

Required for graduates beginning in the 2017-18 school year.

[S_LA_STU_X]FAFSAApplication

1

148

35

Community Service Endorsement

The student’s community service endorsement, if applicable.

Valid values:

• Blank
• C1 - Documented approved community service hours

Used for students in grades T9-12 only.

[S_LA_STU_Academics_X] CommunityServiceEndorsement

2

149

34

State Seal of Bi-Literacy

The student’s biliteracy endorsement, if applicable.

Applies to grades T9-12 only.

Valid values:

• Blank
• D1 - AP Course (test score 3 or higher)
• D2 - IB Course (test score 4 or higher)
• D3 - DOE-approved equivalent summative test
• D4 - 4 units in World Language/7 units or more in world language immersion
• D5 - Internationally-benchmarked language exam (DELF, DELE, ACTFL)
• D6 - Primary Language w/Early Advanced on ELDA;
• OE-approved equivalent summative test

Used for students in grades T9-12 only.

[S_LA_STU_Academics_X] BiliteracyEndorsement

2

151

36

EOC Subject Area (ELA)

Indicates how the student met the diploma assessment requirements for ELA.

Valid values:

• • P – The student passed the subject area assessment
  • A – The student is April Dunn eligible and met the subject area assessment requirement using alternate means
  • G – The student was LEAP Connect and used a growth portfolio
  • E - The student was exempt due to out of state or nonpublic enrollment while earning the credit or due to other DOE waiver
  • N - The student has not taken or not successfully passed the subject area assessment
  • L - The student is LEAP Connect eligible and was taking LEAP Connect

Used for students in grades T9-12 only.

[S_LA_STU_Academics_X] DiplomaReq_ELA

1

153

37

EOC Subject Area (Math)

Indicates how the student met the diploma assessment requirements for Math.

Valid values:

• • P – The student passed the subject area assessment
  • A – The student is April Dunn eligible and met the subject area assessment requirement using alternate means
  • G – The student was LEAP Connect and used a growth portfolio
  • E - The student was exempt due to out of state or nonpublic enrollment while earning the credit or due to other DOE waiver
  • N - The student has not taken or not successfully passed the subject area assessment
  • L - The student is LEAP Connect eligible and was taking LEAP Connect

Used for students in grades T9-12 only.

[S_LA_STU_Academics_X] DiplomaReq_Math

1

154

38

EOC Subject Area (Science)

Indicates how the student met the diploma assessment requirements for Science.

Valid values:

• • P – The student passed the subject area assessment
  • A – The student is April Dunn eligible and met the subject area assessment requirement using alternate means
  • G – The student was LEAP Connect and used a growth portfolio
  • E - The student was exempt due to out of state or nonpublic enrollment while earning the credit or due to other DOE waiver
  • N - The student has not taken or not successfully passed the subject area assessment
  • L - The student is LEAP Connect eligible and was taking LEAP Connect

Used for students in grades T9-12 only.

[S_LA_STU_Academics_X] DiplomaReq_Science

1

155

39

EOC Subject Area (Social Studies)

Indicates how the student met the diploma assessment requirements for Social Studies.

Valid values:

• • Blank - The student has not taken or not successfully passed the subject area assessment
  • P – The student passed the subject area assessment
  • A – The student is April Dunn eligible and met the subject area assessment requirement using alternate means
  • G – The student was LEAP Connect and used a growth portfolio
  • E - The student was exempt due to out of state or nonpublic enrollment while earning the credit or due to other DOE waiver
  • N - The student has not taken or not successfully passed the subject area assessment
  • L - The student is LEAP Connect eligible and was taking LEAP Connect

Used for students in grades T9-12 only.

[S_LA_STU_Academics_X] DiplomaReq_SocialStudies

1

156

Indicates the student's plans after graduation.

Valid values:

• Blank
• 01 - 4 year college
• 02 - 2 year college
• 03 - Military
• 04 - Propel
• 05 - Employment
• 06 - OneGoal
• 07 - Advanced Training
• 08 - Extension Academy
• 09 - Service Program
• 10 - Other

1

System Indicator

Always extracted as “STS.” Required.

“STS”

3

2

Transaction Code

Always extracted as “030.” Required.

“030”

3

3

Session Year

The year of a school session, such as 2010-2011. This is the school year selected at report runtime. To change this value, click Term at the top of the page, choose the correct term, and re-run the report.

Required.

[Terms]FirstDay

[Terms]LastDay

4

4

LEA/Sponsor Code

The sponsor code of the district submitting data. The report extracts the first three digits of the site code. Required.

[S_LA_SCH_X]SiteCode or

[S_LA_SGR_X]PostSecCourseSiteCode

3

5

Student’s State ID Number

The student’s state-assigned identifier. Required.

[Students]State_StudentNumber

10

6

Course Beginning School Session Year

The year in which the course began. For 2010-2011, report 2010. The value is reported based on the term associated with the stored grade.

[StoredGrades]TermID

4

7

Course Code

The valid course code of the course in which the student was enrolled. The value is reported from the Alternate Course Number field on the Edit Course District Information page. If this field is blank, the value is reported from the stored grade.

[StoredGrades]Course_Number

[Courses]alt_course_number

6

8

Course Part Number

Distinguishes the first half of the course from the second half of the course. This value is required for LEAs that report 1.0 unit courses as two 0.5 unit courses. Use a value of 1 for the first part and 2 for the second part. Leave this field blank if not applicable. This value is reported from the Course Part Number field on the Edit Stored Grade field for the student.

[StoredGrades]GPA_Custom1

[S_LA_SEC_X]CoursePartNumber

1

9

Semester Code

The semester code in which the student was enrolled in the course. The values Q1, Q2, Q3, and Q4 are converted to B1, B2, B3, and B4, respectively. The value is reported from the Store code field on the Edit Stored Grade page.

Valid values:

• B1
• B2
• B3
• B4
• C1
• C2
• S1
• S2
• Z1
• Z2
• Y1

[StoredGrades]StoreCode

2

10

Letter Grade Code

The letter grade awarded to the student for the course.

Valid values:

• A
• B
• C
• D
• F
• P (Pass)
• E (Exempt)

[StoredGrades]Grade

1

11

Credit Attempted Count

The credit attempted by the student for the course, such as 0.25, 0.50, or 1.00. The value is reported from the “Credit Value for 7th Sem Grades” field, which can be populated on the report run page. If this field was not populated when running the report, then the value is reported from the Potential credit hours field on the Edit Stored Grades page.

[StoredGrades]PotentialCrHrs

3

12

Credit Earned Count

The credit earned by the student for the course, such as 0.25, 0.50, or 1.00. This value is reported if the student’s letter grade for the course is not F. The value is reported from the “Credit Value for 7th Sem Grades” field, which can be populated on the report run page. If this field was not populated when running the report, then the value is reported from the Earned credit hours field on the Edit Stored Grades page.

[StoredGrades]EarnedCrHrs

3

13

Grade Point Maximum Count

The maximum grade points that can be earned for the course, such as 4.00 or 5.00, i.e. the number of grade points awarded for a grade of A. This value is reported based on the Course Type Code entered on the Edit Stored Grades page.

Valid values:

• Course Type RG = “Grade Point Max Regular” entered at report runtime.
• Course Type HR = “Grade Point Max – Honors” entered at report runtime.
• Course Type GT = “Grade Point Max – Gifted” entered at report runtime.
• Course Type AP = “Grade Point Max - Adv Placement” entered at report runtime.
• Course Type IB = “Grade Point Max - Intl Baccalaureate” entered at report runtime.
• Course Type SE = “Grade Point Max - Special Ed” entered at report runtime.
• Course Type TA = “Grade Point Max – Talented” entered at report runtime.
• Course Type DE = “Grade Point Max - Dual Enrollment” entered at report runtime.
• Course Type DH = “Grade Point Max - Dual Enrollment Honors” entered at report runtime.
• Course Type DA = “Grade Point Max - Dual Enrollment Advanced Placement” entered at report runtime.
• Course Type DI = “Grade Point Max - Dual Enrollment International Baccalaureate” entered at report runtime.

Based on [S_LA_SEC_X]OverrideCourseType

Or [S_LA_SGR_X]OverrideCourseTypeCode

3

14

Core Curriculum Waiver Flag

Indicates if the student was exempted from a core course.

Valid values:

• Y
• N

[StoredGrades]GPA_Custom2

1

15

Course Sponsor Code

The sponsor code of the LEA in which the student took the course. This field is required for public school districts. If the Course Equivalent field is blank and if the Taken Out of State field is not selected, then the report extracts the first three digits of the Sponsor Code.

[StoredGrades]Course_Equiv

[S_LA_SGR_X]TakenOutOfStateInd_TF

[S_LA_SCH_X]SiteCode

If Course Type Code = DE then [S_LA_SEC_X]
PostSecCourseSponsorCode

3

16

Course Site Code

The sponsor code of the LEA in which the student took the course. This field is required for public school districts. If the Course Equivalent field is blank and if the Taken Out of State field is not selected, then the report extracts the SiteCode.

[StoredGrades]Course_Equiv

[S_LA_SGR_X]TakenOutOfStateInd_TF

[S_LA_SCH_X]SiteCode

If Course Type Code = DE then [S_LA_SEC_X]
PostSecCourseSponsorCode

6

17

Course Site Name

The name of the school in which the student took the course. This field is used for transfer credit only and only required if the Course Site Code is not reported.

[StoredGrades]SchoolName

46

18

Transcript Course Name

The name of the course in which the student was enrolled. This field is only required if the name is different from the LDE course description.

[StoredGrades]Course_Name

60

19

Quality Points Awarded Count

The number of points awarded for the letter grade for the course. This field is reported as the number of GPA points associated with the letter grade plus the number of Added Value points associated with the letter grade. The letter grade is automatically assigned a point value via Start Page > District Setup > Grade Scales > Edit Scale > Edit Grade > Grade Points. Otherwise, the point value can be edited on the Historical Grades student page.

[StoredGrades]GPA_Points

[StoredGrades]GPA_AddedValue

3

20

Course Type Code

Identifies the type of course.

[S_LA_CRS_X]CourseType

[S_LA_SGR_X]OverrideCourseTypeCode

[S_LA_SEC_X]OverrideCourseType

2

21

Distance Learning Course Type Code

Indicates the type of distance learning course, if applicable.

Valid values:

• 01 –Louisiana Virtual School Courses
• 02 – 8g Satellite Courses
• 03 – Other Distance Learning

[S_LA_CRS_X]DistanceLearning

[S_LA_SEC_X]
OverrideDistanceLearningType

2

22

Local Course Code

The course code assigned by the district/LEA.

[Sections]Course_Number

[StoredGrades]Course_Number

6

23

Dual Enrollment Post-Secondary Credit Hours

If Course Type Code = DE, DA, DH, or DI then [S_LA_SEC_X] DualEnrollPostSecCreditHours

4

24

Dual Enrollment Secondary Site

If the Course Type Code is DE, DA, DH, or DI this field indicates the high school the student was in when they were enrolled in the course.

[Schools]School_Number

[StoredGrades]Course_Equiv

Identifies the category of the work based learning activity.

Valid values:

• 01 = Agriculture, Food & Natural Resources
• 02 = Architecture & Construction
• 03 = Arts, Audio/Video Technology & Communications
• 04 = Business, Management & Administration
• 05 = Education & Training
• 06 = Health Science
• 07 = Hospitality & Tourism
• 08 = Human Services
• 09 = Information Technology
• 10 = Law, Public Safety, Corrections & Security
• 11 = Manufacturing
• 12 = Science, Technology, Engineering & Mathematics
• 13 = Transportation, Distribution & Logistics

[S_LA_SGR_X]WORK_LRN_CAT

[S_LA_SEC_X]WORK_LRN_CAT

[S_LA_CRS_X]WORK_LRN_CAT

[S_LA_SGR_X]WORK_LRN_NAME

[S_LA_SEC_X]WORK_LRN_NAME

[S_LA_CRS_X]WORK_LRN_NAME

1

2

3

4