LA EdLink Transcript Extract

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 File

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

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

Data Element

Description

[Table]FieldName

SCHOOL_YEAR

The year of the school session. Required.

[Terms]FirstDay,
[Terms]LastDay

SPONSOR_CD

Sponsor (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_LASID

A unique ID as it exists in the eScholar system. Required.

[Students]State_StudentNumber

STUDENT_LOCAL_ID

LEA-assigned student ID must be for students, and must not match their SSN or UID (LASID). Required.

[Students]Student_Number

SITE_CD

Site 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_PLACEMENT

The 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_YEAR

YYYY 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_DATE

MM/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_CD

Identifies 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_PATHWAY

The 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_CONSENT

Parental/Guardian Consent on file

• Y if Yes

• N if No

[S_LA_STU_X]LOSFAConsentFlag
[S_LA_REN_X]LOSFAConsentFlag

FAFSA_APP

Indicates 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_ENDORSEMENT

If 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_ENDORSEMENT

If 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_ELA

This 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_MATH

This 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_SCIENCE

This 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_STUDIES

This 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_CODE

Indicates 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

Data Element

Description

[Table]FieldName

SCHOOL_YEAR

The year of the school session. Required.

[Terms]FirstDay,
[Terms]LastDay

SPONSOR_CD

Sponsor (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_LASID

A unique ID as it exists in the eScholar system. Required.

[Students]State_StudentNumber

COURSE_BSSY

Beginning School Session Year (BSSY) of the course. For example, 2012 for 2012-2013 school year. Required.

[StoredGrades]TermID

COURSE_CD

Valid Course Code for the course that the student is enrolled in. Required.

[Courses]alt_course_number or [StoredGrades]Course_Number

COURSE_PART_NUM

Distinguishes 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_CD

Semester 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_GRADE

Letter 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_CNT

Credit/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_CNT

Credit/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_CNT

Maximum 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_CD

Sponsor 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_CD

Site 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_AWARDED

The 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_CD

Code 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_CD

Code 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_CD

LEA 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_SITE

If 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_NAME

Identifies 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]

Data Element

Description

[Table]FieldName

SCHOOL_YEAR

The year of the school session. Required.

[Terms]FirstDay,
[Terms]LastDay

SPONSOR_CD

Sponsor (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_CD

Site code of the submitting district. Required.

[S_LA_STU_X]SiteCodeOverride or [S_LA_SCH_X]SiteCode

STUDENT_LOCAL_ID

Student’s Local ID. Required.

[Students]Student_Number

STUDENT_LASID

A unique ID as it exists in the eScholar system. Required.

[Students]State_StudentNumber

IBC_CD

3 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_EARNED

1 = Fall, 2 = Spring, 3 = Summer. Required.

[S_LA_STU_IBC_C]SemesterIBCEarned

YR_IBC_EARNED

The 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_FLG

Indicates if Student Passed or Failed Test: P = Passed, F = Failed. Required.

[S_LA_STU_IBC_C]PassFail

SPONSOR_CD_IBC_EARNED

The Sponsor Code where the student was enrolled when IBC was earned. Required.

[S_LA_STU_IBC_C]SponsorCodeIBCEarned

SITE_CD_IBC_EARNED

The current LEA must send all IBCs the student has earned, including those earned in another district. Required.

[S_LA_STU_IBC_C]SiteCodeIBCEarned