LA EdLink Courses

Contents

Introduction

This report extracts Course Offering and Student Schedules data in the format required to be submitted to the EdLink warehouse.

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. Use PowerSchool's Remote Connection Management feature to set up a SFTP connection to allow for automatic uploading of files to EdLink. Use with the report's scheduling feature to set up a recurring upload of files to EdLink.

Student_Schedules

School Selection

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

The school must not be excluded from State Reporting.
If running the report for a sub-district, the school must be assigned to the sub-district.

Student Selection

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

The student must not be excluded from State Reporting.
A record is created for each class the student is registered in, including any cross-enrollments.

Section Selection

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

The section must not be excluded from State Reporting
The section must not be marked as Duplicate Non-LEA Class.

Course_Offerings and Course_Offerings_Ext

School Selection

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

The school must not be excluded from State Reporting.
If running the report for a sub-district, the school must be assigned to the sub-district.

Section Selection

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

The section must not be excluded from State Reporting.
The section must not be marked as Duplicate Non-LEA Class.

Student Marks

School Selection

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

The school must not be excluded from State Reporting.
If running the report for a sub-district, the school must be assigned to the sub-district.

Student Mark Selection

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

The student must not be excluded from State Reporting.
The section must not be excluded from State Reporting
The stored grade must have a course number and section specified and must not be excluded from State Reporting
The stored grade must not be associated with a reporting term that is flagged as Exclude Reporting Term from Student Marks Extract on the Final Grades Setup page.
Stored grades records must have a mark of A, B, C, D, E, F, N, P, S, or U. Other marks or blank marks are not included as records in the file.

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.
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. Selection by Student is only applicable when generating the student_schedules extract.
Output File Name	Select the extract to generate.
Select School Year	Select the school year for which to run the report. The options are controlled by the Term currently selected by the user.
Identify as a Partial File	Select Enabled to create and submit an EdLink file containing only a subset of the students without overwriting the complete file or another partial file. This field is unchecked by default. 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.
SFTP connections	If 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 output of the report is described below. See Understanding the Report Output Table for a definition of each column in the table.

Course_Offerings

Data Element	Description	[Table]FieldName
LOCAL_COURSE_OFFERINGS_KEY	Value that uniquely identifies each course section/offering record submitted. Required.	Concatenated field [Terms]Firstday; [S_LA_SCH_X]SiteCode (first 3 digits); [S_LA_SCH_X]SiteCode; [S_LA_SEC_X]NonLEAClassCode (if populated) or [Courses]Course_Number + [Sections]Section_Number+ Course_Section_Start_Date
SCHOOL_YEAR	The year of the school session. Required.	[Terms]FirstDay [Terms}LastDay
DISTRICT_CODE	The three-digit Sponsor Code assigned by LDOE. Required.	[Prefs]Value where [Prefs]Name=districtnumber If subdistrict is enabled then first three digits of [CST_Subdistricts]SubDistrict_Number
LOCAL_SCHOOL_KEY	The school’s site code. Required.	[S_LA_SCH_X]SiteCode
LOCAL_COURSE_KEY	Unique identifier for a course within the school. This must match the LOCAL_COURSE_KEY in the COURSES file extract. Required.	[Terms]FirstDay (Year); [Courses]Alt_Course_Number if populated, or [Sections]Course_Number
COURSE_SECTION_START_DATE	The starting date (typically first meeting) for this specific course section. Required.	[Terms]FirstDay
COURSE_SECTION_END_DATE	The projected/assumed ending date for the course section. Required.	[Terms]LastDay
COURSE_SECTION	The section designation for the Course being offered (to distinguish this course from the same course being offered during the same semester/term) at the same school. Required.	[S_LA_SEC_X]NonLEAClassCode if populated, or [Courses]Course_Number +[Sections]Section_Number
SCHOOL_DEPARTMENT_CODE	Repurposed this field to identify the type of course Required.	[S_LA_SEC_X]OverrideCourseType if populated, or [S_LA_CRS_X]CourseType
COURSE_DURATION	Length of the course section in minutes for the entire semester or term. Required.	[S_LA_SEC_X]TotalClassTimeDesc
COURSE_PERIOD	Period for which this course section is scheduled for the related semester/term. Multiple periods are reported as a comma-delimited list (03, 04 or 06, 07, etc.). Periods must be reported as a two digit number.	[S_LA_SEC_X]ClassSettingIdentifier

Course_Offerings_Ext

Data Element	Description	[Table]FieldName
LOCAL_COURSE_OFFERINGS_KEY	Fully-defined academic year string: CCYY-CCYY (2008-2010, 2015-2016, etc.) Required.	Concatenated field [Terms]Firstday; [S_LA_SCH_X]SiteCode (first 3 digits); [S_LA_SCH_X]SiteCode; [S_LA_SEC_X]NonLEAClassCode (if populated) or [Courses]Course_Number + [Sections]Section_Number+ Course_Section_Start_Date (use NonLEAClassCode if populated, else use Course number and section number)
SCHOOL_YEAR	The year of the school session. Required.	[Terms]FirstDay [Terms}LastDay
DISTRICT_CODE	The three-digit Sponsor Code assigned by LDOE. Required.	[Prefs]Value where [Prefs]Name=districtnumber If subdistrict is enabled then first three digits of [CST_Subdistricts]SubDistrict_Number
SPED_PLACEMENT_SETTING_CODE	Instructional setting of a Special Education Classroom.	[S_LA_SEC_X]SPEDPlacementSettingCode
DIST_LEARN_COURSE_TYPE_CODE	Code which identifies Distance Learning type courses This value is extracted from the Override Distance Learning Type Code field on the Edit Section page. If the section field is blank, then the value is extracted from the Distance Learning Type Code field on the Edit Course District Information page. Valid values: Blank – Not Applicable 01 – Louisiana Virtual School courses 02 – 8g Satellite courses 03 – Other Distance Learning	[S_LA_SEC_X]OverrideDistanceLearningType if populated, or [S_LA_CRS_X]DistanceLearning
LOCAL_COURSE_CODE	Optional description used by the LEA to hold the local course name.	[Courses]Course_number
LOCAL_COURSE_NAME	Optional description used by the LEA to hold the local course name.	[Courses]Course_Name
STARTING_SEMESTER	Semester in which a class starts. Required.	[S_LA_SEC_X]StartingSemesterNumber
TEAM_TEACHING_INDICATOR	Identifies a course as being taught by multiple teachers. Values are 'Y' or 'N'.	[S_LA_SEC_X]TeamTeachingFlag_YN
LANGUAGE_FOR_IMMERSION_CODE	Describes the language in which the immersion class will be taught.	Calculated from the reporting_value of the Immersion Language code set for the code entered for [S_LA_CRS_X]IMM_CLASS_LANG
LEARNING_PODS	Identifies a course as being taught as part of a Learning Pod. Values are 'Y' or 'N'.	[S_LA_SEC_X]LearningPod [S_LA_CRS_X]LearningPod

Student_Schedules

Data Element	Description	[Table]FieldName
LOCAL_STUDENT_SCHEDULES_KEY	The value uniquely identifying each student schedule record that is submitted. Required.	[Terms]FirstDay; [S_LA_SCH_X]SiteCode (left 3 diigits); [S_LA_SCH_X]SiteCode (depending on District preference, uses the student's enrollment_schoolid or schoolid to determine the school that the student attended) [S_LA_SEC_X]NonLEAClassCode if populated, or [Courses]Course_Number + [Sections]Section_Number; [Students]State_StudentNumber+ Schedule_Start_Date
SCHOOL_YEAR	The year of the school session. Required.	[Terms]FirstDay [Terms}LastDay
DISTRICT_CODE	The three-digit Sponsor Code assigned by LDOE. Required.	[Prefs]Value where [Prefs]Name=districtnumber If subdistrict is enabled then first three digits of [CST_Subdistricts]SubDistrict_Number
LOCAL_SCHOOL_KEY	The school’s site code. Required.	[S_LA_SCH_X]SiteCode (depending on District preference, uses the student's enrollment_schoolid or schoolid to determine the school that the student attended)
LOCAL_STUDENT_KEY	Unique identifier for the student. The StateID/Louisiana Secure ID (LASID) assigned by eScholar to this student. Required.	[Students]State_StudentNumber
LOCAL_COURSE_KEY	Unique identifier for a course within the district applications that this student schedule record is associated with. This must align with the COURSES.LOCAL_COURSE_KEY field. Required.	[Terms]FirstDay; [Courses]Alt_Course_Number if populated, or [Sections]Course_Number
LOCAL_COURSE_OFFERINGS_KEY	Unique identifier for a course section/offering within the district that this student schedule record is associated. This must align with the COURSES_OFFERINGS.LOCAL_COURSE_OFFERING_KEY field. Required.	Concatenated field [Terms]Firstday; [S_LA_SCH_X]SiteCode (first 3 digits); [S_LA_SCH_X]SiteCode; [S_LA_SEC_X]NonLEAClassCode (if populated) or [Courses]Course_Number + [Sections]Section_Number+ Course_Section_Start_Date
SCHEDULE_START_DATE	The date when the student entered the class.	[CC]DateEnrolled
SCHEDULE_END_DATE	The date when the student exited the class.	[CC]DateLeft
SCHEDULED_CREDIT_VALUE	The credit value for the scheduled course section.	[Courses]Credit_Hours

Student_Marks

Data Element	Description	[Table]FieldName
LOCAL_STUDENT_MARK_KEY	Value which uniquely identifies each curriculum/standard record submitted. This may be a single code value. If multiple codes/values are required to uniquely identify a curriculum/standard item within a district, school and academic year than these codes should be concatenated.	[Terms]FirstDay; [S_LA_SCH_X]SiteCode (left 3 diigits); [S_LA_SCH_X]SiteCode (depending on District preference, uses the student's enrollment_schoolid or schoolid to determine the school that the student attended) [S_LA_SEC_X]NonLEAClassCode if populated, or [Courses]Course_Number + [Sections]Section_Number; [Students]State_StudentNumber+ Schedule_Start_Date
SCHOOL_YEAR	Fully-defined academic year string: CCYY-CCYY (e.g. 2020-2021)	[Terms]FirstDay [Terms}LastDay
LOCAL_STUDENT_KEY	Unique identifier for the student. The StateID/Louisiana Secure ID (LASID) assigned by eScholar.	[S_LA_SCH_X]SiteCode (first three characters)
LOCAL_SCHOOL_KEY	Historically is the 6-digit site code assigned by the Sponsor Site (SPS) legacy system.	[S_LA_SCH_X]SiteCode (depending on District preference, uses the student's enrollment_schoolid or schoolid to determine the school that the student attended)
LOCAL_COURSE_KEY	Unique identifier for a course within the district applications that this student schedule/roster record is associated. LDOE State Course Code. This must align to the COURSES.LOCAL_COURSE_KEY field.	[Students]State_StudentNumber
LOCAL_COURSE_OFFERINGS_KEY	Unique identifier for a course section/offering within the district applications that this student schedule/roster record is associated. This must align to the COURSES_OFFERINGS.LOCAL_COURSE_OFFERING_KEY field.	[Terms]FirstDay; [Courses]Alt_Course_Number if populated, or [Sections]Course_Number
DISTRICT_CODE	Historically is the 3-digit sponsor code assigned by the Sponsor Site (SPS) legacy system.	[Prefs]Value where [Prefs]Name=districtnumber If subdistrict is enabled then first three digits of [CST_Subdistricts]SubDistrict_Number
MARK_PERIOD	Represents the term for which the grade is being provided. Must align with the CALENDARS TBL (e.g.1st six weeks [T61], 1st nine weeks [T91], Semester [S01], etc)	[CC]DateEnrolled
MARK_TYPE	Designates whether the grade is for Progress or Final based upon the MARK_PERIOD. P=Progress F=Final	[CC]DateLeft
MARK_SCALE_CODE	we need to build scales from this. The short name for the performance group: A, B, C, D, F, E, P E=Exempt P=Pass	[Courses]Credit_Hours
PASSING_INDICATOR	A Yes/No indicator of whether the mark earned is a passing one or not
HIGH_SCHOOL_CREDIT_INDICATOR	A Yes/No indicator of whether the credit is for a high-school level course (particularly critical for marks awarded in middle-schools).