Skip to main content
Skip table of contents

LA EdLink Transcript Extract

Contents

Introduction

This report extracts student transcript data in the format required for submission to the EdLink warehouse. If the extract is to be automatically uploaded to EdLink, select the SFTP connection that has been defined for reporting to EdLink.

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.

Student Selection

The report selects records from the [Students] table based on the following criteria:

  • The student’s school entry and exit dates indicate that the student was enrolled in the school at some point in the selected school year

  • The student, the student’s school, and the student’s school enrollment must not be excluded from state reporting

  • The student must not be excluded from the STS report ([S_LA_STU_X]State_ExcludeFromSTS = 1 if excluded)

  • The student must be enrolled in grade-level T9, 9, 10, 11, 12 or in grade-level 6, 7, 8 if Include Students in Grades 6-8 is selected on the report run page

  • The student's exit code must match one of the codes selected in the report parameters

  • The student’s school entry date must occur on or before the report run date (Pre-registered students will not be included in the file).

Grade Selection

The report selects stored grades records from the [StoredGrades] table that meet any one of the following criteria are met:

  • The potential credit hours ([StoredGrades]PotentialCrHrs) of the stored grade record must be greater than zero

  • The Include in STS Despite Potential Credit ([StoredGrades]AB_Lng_CD=1) box is checked

  • The letter grade stored is an E ([StoredGrades]Grade)

  • The stored grade course number is 230000 ([StoredGrades]Course_Number)

    The report does not consider Credits Earned for determining whether or not the grade record should be included in the report.

School Selection

The report selects records from the [Schools] table if the school is not excluded from State Reporting.

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Field

Description

Select Schools

Indicate which schools to include in the report by selecting from the following options:

If sub-districts are not enabled:

  • Select Multiple Schools – Select schools to include in the report. To select a single school, click that school. To select multiple schools, use Ctrl+Click and select each school to be included.
  • All Schools – Run the report for the entire district. Only available when running the report from the District Office.

If sub-districts are enabled:

  • Select Sub-district Select sub-districts to include in the report. To select a single sub-district, click that sub-district. To select multiple schools, use Ctrl+Click and select each sub-district to be included.
  • Select Multiple Schools – Select schools to include in the report. To select a single school, click that school. To select multiple schools, use Ctrl+Click and select each school to be included.
  • All Schools in selected sub-district (default) – Run the report for all schools in the selected sub-district. Includes all student records on the PowerSchool server that meet the selection criteria. Only available when running the report from the District Office.

Output File Name

Choose the extract to generate.

School Year

Enter the school year of the report.

Identify as a Partial FileSelect this checkbox if the file being generated is not including all students that should be reported to EdLink. As a partial file, the file name will have '_partial' plus a unique number added to the name to ensure each file is unique when it is uploaded to EdLink.

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 that match the selected exit codes will be included in the report.

Include Students in Grades 6-8

Select the checkbox to include students in grades 6 through 8.

Grade Point Max Regular*

Enter the three-digit Grade Point Maximum value for Regular classes (no decimal). This applies to Course/Section/StoredGrade records that have a Course Type Code - RG.

For example, 4.00 is entered as 400.

Grade Point Max - Honors

Enter the three-digit Grade Point Maximum value for Honors classes (no decimal). This applies to Course/Section/StoredGrade records that have a Course Type Code - HR.

For example, 5.00 is entered as 500.

Grade Point Max - Gifted

Enter the three-digit Grade Point Maximum value for Gifted classes (no decimal). This applies to Course/Section/StoredGrade records that have a Course Type Code - GT.

For example, 4.00 is entered as 400.

Grade Point Max - Adv Placement

Enter the three-digit Grade Point Maximum value for Advanced Placement classes (no decimal). This applies to Course/Section/StoredGrade records that have a Course Type Code - AP.

For example, 5.00 will be entered as 500.

Grade Point Max - Intl Baccalaureate

Enter the three-digit Grade Point Maximum value for International Baccalaureate classes (no decimal). This applies to Course/Section/StoredGrade records that have a Course Type Code - IB.

For example, 4.00 will be entered as 400.

Grade Point Max - Special Ed

Enter the three-digit Grade Point Maximum value for Special Education classes (no decimal). This applies to Course/Section/StoredGrade records that have a Course Type Code - SE.

For example, 4.00 is entered as 400.

Grade Point Max - Talented

Enter the three-digit Grade Point Maximum value for Talented classes (no decimal). This applies to Course/Section/StoredGrade records that have a Course Type Code of - TA.

For example, 4.00 is entered as 400.

Grade Point Max - Dual Enrollment

Enter the three-digit Grade Point Maximum value for Dual Enrollment classes (no decimal). This applies to Course/Section/StoredGrade records that have a Course Type Code - DE.

For example, 4.00 is entered as 400.

Grade Point Max - Dual Enrollment/Honors

Enter the three-digit Grade Point Maximum value for Dual Enrollment/Honors classes (no decimal). This applies to Course/Section/StoredGrade records that have a Course Type Code - DH.

For example, 4.00 is entered as 400.

Grade Point Max – Dual Enrollment/ Advanced Placement

Enter the three-digit Grade Point Maximum value for Dual Enrollment/ Advanced Placement classes (no decimal). This applies to Course/Section/StoredGrade records with a Course Type Code - DA.

For example, 4.00 is entered as 400.

Grade Point Max – Dual Enrollment/ International Baccalaureate

Enter the three-digit Grade Point Maximum value for Dual Enrollment/ International Baccalaureate classes (no decimal). This applies to Course/Section/StoredGrade records that have a Course Type Code - DI.

For example, 4.00 is entered as 400.

Credit Value for 7th Sem Grades

Enter the three-digit credit value of your 7th-semester grades (no decimal). For example, 0.50 is entered as 050. If a grade has potential credit hours or earned credit hours of 0, this value is used instead of 0.

Check to use Grade Scale for Grade Point Max

Select this checkbox to output the maximum GPA based on grade scale value.

Check to include GPA and Rank

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

SFTP connectionsIf the extract is to be automatically uploaded to EdLink, select the SFTP connection that has been defined for reporting to EdLink.

Report Output

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

Sts Demographics

Data Element

Description

[Table]FieldName

SCHOOL_YEARThe year of the school session. Required.[Terms]FirstDay,
[Terms]LastDay
SPONSOR_CDSponsor (LEA) code of district submitting transcript data via STS. Required.

[Prefs]Value where

[Prefs]Name=districtnumber

If subdistrict is enabled then first three digits of [CST_Subdistricts]SubDistrict_Number

STUDENT_LASIDA unique ID as it exists in the eScholar system. Required.[Students]State_StudentNumber
STUDENT_LOCAL_IDLEA-assigned student ID must be for students, and must not match their SSN or UID (LASID). Required.[Students]Student_Number
SITE_CDSite code where the student is currently enrolled when transcript data is submitted. Required.[S_LA_STU_X]SiteCodeOverride or [S_LA_SCH_X]SiteCode
GRADE_PLACEMENTThe grade placement code represents the student’s grade level for the school year. Two-digit grade placement codes 6-8 or T9-12 accepted only. Required.[Students]Grade_Level
GRADE_9_ENTRY_YEARYYYY Beginning School Session Year that the student entered grade 9. For example, 2012 for the 2012-2013 school year. If the student’s grade placement code is T9, this date will be the following school year. If the student’s grade placement code is 6, 7, or 8, the Grade 9 Entry Year should be blank. Required if applicable.[S_LA_STU_Academics_X] YearEnteredNinthGrade
GRAD_DATEMM/DD/YYYY Date the student’s graduation took or will take place. The date must fall between 9/1 and 8/31 of the current Beginning School Session Year in order to match the OSFA Annual Academic Year. Enter only after all graduation requirements are met. Leave blank if the student did not graduate.[S_LA_STU_Academics_X] GraduationDate
CAREER_OPTION_CDIdentifies the career option of a student and corresponds to the Area of Concentration or Jumpstart Pathway in the TOPS Core Reference Tables. Leave blank if not applicable.Reported_value from the Career Option Codes code set for the [S_LA_STU_Academics_X] CareerOptionCode field
MET_ASSESSMENT_REQ

Indicator of whether the student took or met the assessment requirements for graduation. Required for all public school students, who are assigned a Graduation Date. One of the following values should be used:

  • Y if student passed all assessments required for graduation (including the LAA1 and is marked as eligible in SER)
  • A if student is applying Act 833 (marked eligible in SER) and met one or more of the assessment requirements for a diploma through alternate means
  • G if the student participated in the LAA1 assessment as marked in SER and met the requirements by achieving exceeds or meets on the LAA1 assessment or meets the components through a portfolio of student achievement (growth portfolio)
  • E if the student is exempt from all requirements
  • Null if all requirements are not met

If Y, the Subject areas in positions 153-156 must be blank. Non-public schools may leave this data element blank.

[S_LA_STU_Academics_X] MetAssessRequirementsDiploma
LOCAL_GPA

Locally defined grading. Optional.



[Gen]Name=LASRC
LOCAL_CLASS_RANK_POSITION

Student’s rank placement within grade level (pad with leading zeros). Optional. If not used, leave blank.


[Gen]Name=LASRC
[Gen]Cat=classrankmethod
LOCAL_CLASS_RANK_SIZE

Size of class for student’s grade level (pad with leading zeros). Optional.


[Gen]Name=LASRC
[Gen]Cat=classrankmethod
DIPLOMA_PATHWAYThe diploma the student is working towards completing. Required for 11th and 12th graders.
  • C4 –Core 4 pathway – discontinue use after graduates of 2016-17
  • C5 – Basic Core pathway - discontinue use after graduates of 2016-17
  • C6 – Core 4 with CTE - discontinue use after graduates of 2016-17
  • CA – TOPS Tech Jumpstart Career Diploma - begin use for graduates of 2017-18
  • L1 – TOPS Tech Jumpstart Career Diploma alternate pathway for students assessed on LAA1 – begin use for graduates of 2017-18
  • TU – TOPS University Diploma – begin use for graduates of 2017-18
  • ND – Not declared - use for students prior to the end of 10th grade before declaring a pathway
  • CD – Historical career diploma/older graduates
  • NG – Non graduate diploma path
[S_LA_STU_Demographics_X] DiplomaPathway
[S_LA_REN_X]DiplomaPathway
LOSFA_PARENTAL_GUARDIAN_CONSENTParental/Guardian Consent on file
  • Y if Yes
  • N if No
[S_LA_STU_X]LOSFAConsentFlag
[S_LA_REN_X]LOSFAConsentFlag
FAFSA_APPIndicates whether a FAFSA application has been completed by the student. Required for graduates. Optional for non-graduates. Allowed values:
  • 1 = FAFSA Completion
  • 2 = TOPS Form Completion
  • 3 = Parent/Guardian Waiver
  • 4 = Hardship Waiver
[S_LA_STU_X]FAFSAApplication
COMMUNITY_SERVICE_ENDORSEMENTIf the student received community service endorsement for documented community service hours, fill in. Otherwise, leave blank. Required when applicable. (C1)[S_LA_STU_Academics_X] CommunityServiceEndorsement
STATE_SEAL_BILITERACY_ENDORSEMENTIf the student received the State Seal of Bi-literacy endorsement for competency in a foreign language, fill in. Otherwise, leave blank. Required when applicable (D1,D2,D3,D4,D5,D6).
  • D1 AP course(test score 3 or higher)
  • D2 1 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
[S_LA_STU_Academics_X] BiliteracyEndorsement
EOC_SUBJECT_AREA_ELAThis field is left blank for most students, but required for those identified in SER as Act 833 eligible or assessed on the LAA1 who also did not meet the ELA EOC assessment requirement for graduation. One of the following values should be used:
  • P if the EOC subject area assessment for ELA was passed or student achieved Exceeds Standards or Meets Standards in the LAA1 assessment
  • A if student is Act 833 eligible and met the ELA assessment requirement using alternate means
  • G if a student was assessed on the LAA1 and used a growth portfolio to meet the ELA assessment requirement
  • Null if not applicable or requirement not met
[S_LA_STU_Academics_X] DiplomaReq_ELA
EOC_SUBJECT_AREA_MATHThis field is left blank for most students, but required for those identified in SER as Act 833 eligible or assessed on the LAA1 who also did not meet the math EOC assessment requirement for graduation. One of the following values should be used:
  • P if the EOC subject area assessment for math was passed or student achieved Exceeds Standards or Meets Standards in the LAA1 assessment
  • A if student is Act 833 eligible and met the math assessment requirement using alternate means
  • G if a student was assessed on the LAA1 and used a growth portfolio to meet the math assessment requirement
  • Null if not applicable or requirement not met
[S_LA_STU_Academics_X] DiplomaReq_Math
EOC_SUBJECT_AREA_SCIENCEThis field is left blank for most students, but required for those identified in SER as Act 833 eligible and using an alternate means to meet the science EOC assessment requirement for graduation. One of the following values should be used:
  • P if the EOC subject area assessment for science was passed
  • A if student is Act 833 eligible and met the science assessment requirement using alternate means
  • Null if not applicable or requirement not met
  • Not required for students assessed on the LAA1
[S_LA_STU_Academics_X] DiplomaReq_Science
EOC_SUBJECT_AREA_SOCIAL_STUDIESThis field is left blank for most students but required for those identified in SER as Act 833 eligible and using an alternate means to meet the science EOC assessment requirement for graduation.
  • P if the EOC subject area assessment for social studies was passed
  • A if student is Act 833 eligible and met the social studies assessment requirement using alternate means
  • Null if not applicable or requirement not met
  • Not required for students assessed on the LAA1
[S_LA_STU_Academics_X] DiplomaReq_SocialStudies
POST_HIGH_SCHOOL_CODEIndicates a student's plans after graduation. Required if applicable.
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
[S_LA_STU_Academics_X]Post_High_School_Code

Sts Transcript

Data Element

Description

[Table]FieldName

SCHOOL_YEARThe year of the school session. Required.[Terms]FirstDay,
[Terms]LastDay
SPONSOR_CDSponsor (LEA) code of district submitting transcript data via STS. Required.

[Prefs]Value where

[Prefs]Name=districtnumber

If subdistrict is enabled then first three digits of [CST_Subdistricts]SubDistrict_Number

STUDENT_LASIDA unique ID as it exists in the eScholar system. Required.[Students]State_StudentNumber
COURSE_BSSYBeginning School Session Year (BSSY) of the course. For example, 2012 for 2012-2013 school year. Required.[StoredGrades]TermID
COURSE_CDValid Course Code for the course that the student is enrolled in. Required.[Courses]alt_course_number or [StoredGrades]Course_Number
COURSE_PART_NUMDistinguishes the first and second half of the course that the student is enrolled. This is required for LEAs that report 1.0 unit courses as two .5 unit courses. Use 1 for the first part and 2 for the second part. Leave blank if not applicable.[StoredGrades]GPA_Custom1 or [S_LA_SEC_X]CoursePartNumber
SEMESTER_CDSemester Code for the course's semester that the student is enrolled (B1, B2, B3, B4, C1, C2, S1, S2, Z1, Z2, Y1). Required.[StoredGrades]StoreCode
LETTER_GRADELetter grade assigned to a student for a course. Must be A B, C, D, F, P (Pass) or E (Exempt). Required.[StoredGrades]Grade
CREDIT_EXPERIENCE_ATTEMPT_CNTCredit/Experience attempted by the student for the course reported with implied decimals. For example, 0.5 would be reported as 050 in the batch record. Required.[StoredGrades]PotentialCrHrs
CREDIT_EXPERIENCE_EARN_CNTCredit/Experience Earned Count – Credit/Experience earned by the student for the course, reported with implied decimals. For example, 0.50 would be reported as 050 in the batch record. Required.[StoredGrades]EarnedCrHrs
GRADE_PT_MAX_CNTMaximum grade points that can be earned for the course/class (4.00, 5.00, etc.), that is, the number of quality points that are awarded for letter grade A (has implied decimal, that is, 4.00 is submitted as 400 in the batch record). Required.Based on [S_LA_SEC_X]OverrideCourseType or [S_LA_SGR_X]OverrideCourseTypeCode
CORE_CURRICULUM_WAIVER

Y if the student is exempted from a course, otherwise N. Optional.


[StoredGrades]GPA_Custom2
COURSE_SPONSOR_CDSponsor Code of the LEA that the student took the course. Must be supplied for all courses taken in Louisiana, otherwise leave blank.

If position 166 (Course Type Code) is DE, this field must contain the Post-secondary Sponsor code instead of the LEA Sponsor code. Required.
[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
COURSE_SITE_CDSite code of the school from where the student took the course. Must be supplied for all courses taken in Louisiana, otherwise leave blank.

If position 166 (Course Type Code) is DE, this field must contain the Post-secondary Site code instead of the LEA Site code. Required if LA course.
[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
COURSE_SITE_NAME

Name of school that the student took the course. Used only for transfer credit. Required if the Course Site Code is not provided, otherwise is optional.


[StoredGrades]SchoolName
TRANSCRIPT_COURSE_NAME

Name of the course that the student is enrolled. Enter only if different from the LDOE course description, otherwise leave blank. Used only for printing transcript. Optional.


[StoredGrades]Course_Name
QUALITY_PTS_AWARDEDThe amount of quality points awarded for the letter grade given for the course (has implied decimal, that, 3.00 submitted as 300 in batch). Required.[StoredGrades]GPA_Points
[StoredGrades]GPA_AddedValue
COURSE_TYPE_CDCode to identify the type of Course. Required.
RG – Regular
GT – Gifted
SE - Special Education
DA - Dual Enrollment and AP
DI - Dual Enrollment and IB
AP - Advanced Placement
IB - International Baccalaureate
HR - Honors
TA - Talented
DE - Dual Enrollment
[S_LA_CRS_X]CourseType
[S_LA_SGR_X]OverrideCourseTypeCode
[S_LA_SEC_X]OverrideCourseType
DISTANCE_LEARNING_COURSE_TYPE_CDCode to identify the type of distance learning course. Leave blank if not applicable.
01 - Local LEA Provided Online Courses
02 - Distance Learning Satellite Courses
03 - Other Distance Learning
04- Course Choice/Supplemental Course Providers
05-Dropout Recovery Program Providers
[S_LA_CRS_X]DistanceLearning

[S_LA_SEC_X]
OverrideDistanceLearningType
LOCAL_COURSE_CDLEA assigned course code. Optional.[Sections]Course_Number
[StoredGrades]Course_Number
DE_POST_SECONDARY_CREDIT_HRS_EARNED

If position 166 (Course Sponsor Code) is designated DE, DA, or DI, this field must be populated with the Dual Enrollment Post-Secondary credit hours earned by the DE course. Otherwise, populated with blank (spaces). This field is added with two leading zeroes and an implied decimal. For example, 4.00 is submitted as 00400. in batch.

If Course Type Code = DE, DA, DH, or DI then [S_LA_SEC_X] DualEnrollPostSecCreditHours
DE_SECONDARY_SITEIf position 166 (Course Sponsor Code) is designated DE, DA, or DI, this field must be populated with the student's high school Site Code, from where they enrolled for the course. Otherwise, populated with blank (spaces).If Course Type Code = DE, DA, DH, or DI then
[Schools]School_Number
[StoredGrades]Course_Equiv
LOCAL_COURSE_OFFERINGS_KEY

Value that uniquely identifies each course section/offering record submitted. This may be a single code value. If multiple codes/values are required to uniquely identify a course section within a district, school, and academic year, then these codes should be concatenated. LEA Class Code.

This field populates only if the course is taken during the current school year.

"[Terms]Firstday,
[S_LA_SCH_X]SiteCode (first 3 digits),
[S_LA_SCH_X]SiteCode (all digits)

[S_LA_SEC_X]NonLEAClassCode or
[Courses]Course_Number +
[Sections]Section_Number

(use NonLEAClassCode if populated, else use Course number and section number)"
WORK_BASED_LEARNING_CATEGORY

Identifies a student's participation in work based learning by identifying the work based learning
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

Required for courses taken in the current year at the submitting LEA.

[S_LA_SGR_X]WORK_LRN_CAT] or [S_LA_SEC_X]WORK_LRN_CAT] or
[S_LA_CRS_X]WORK_LRN_CAT]
WORK_BASED_LEARNING_BUSINESS_NAMEIdentifies a student's participation in work-based learning by identifying where work-based learning occurs. Enter if applicable.[S_LA_SGR_X]WORK_LRN_NAME] or [S_LA_SEC_X]WORK_LRN_NAME] or
[S_LA_CRS_X]WORK_LRN_NAME]

Sts IBC

Data Element

Description

[Table]FieldName

SCHOOL_YEARThe year of the school session. Required.[Terms]FirstDay,
[Terms]LastDay
SPONSOR_CDSponsor (LEA) code of district submitting transcript data via STS. Required

[Prefs]Value where

[Prefs]Name=districtnumber

If subdistrict is enabled then first three digits of [CST_Subdistricts]SubDistrict_Number

SITE_CDSite code of the submitting district. Required.[S_LA_STU_X]SiteCodeOverride or [S_LA_SCH_X]SiteCode
STUDENT_LOCAL_IDStudent’s Local ID. Required.[Students]Student_Number
STUDENT_LASIDA unique ID as it exists in the eScholar system. Required.[Students]State_StudentNumber
IBC_CD3 byte code for the IBC. Refer to the IBC Code code set. Required.Reported_value from the IBC Code code set for the [S_LA_STU_IBC_C]IBCCode field
SEMESTER_IBC_EARNED1 = Fall, 2 = Spring, 3 = Summer. Required.[S_LA_STU_IBC_C]SemesterIBCEarned
YR_IBC_EARNEDThe beginning year of the school session when the IBC was earned. Required.[S_LA_STU_IBC_C]YearIBCEarned
TEST_VENDOR

3 byte code for testing agency of the IBC. Optional.


[S_LA_STU_IBC_C]TestVendor
PASS_FAIL_FLGIndicates if Student Passed or Failed Test: P = Passed, F = Failed. Required.[S_LA_STU_IBC_C]PassFail
SPONSOR_CD_IBC_EARNEDThe Sponsor Code where the student was enrolled when IBC was earned. Required.[S_LA_STU_IBC_C]SponsorCodeIBCEarned
SITE_CD_IBC_EARNEDThe current LEA must send all IBCs the student has earned, including those earned in another district. Required.[S_LA_STU_IBC_C]SiteCodeIBCEarned


JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.