LA EdLink Staff Extract
Contents
Introduction
This report extracts the staff's and the contract staff's course offering data and mentor information in the format required for submission to the EdLink warehouse. 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.
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.
Staff Selection
For the staff course offering link extract, the extract selects records from the Staff/User tables that meet the following criteria:
- The staff member is a lead or co-teacher of the course.
- The staff member has a unique staff ID entered for [USERS]SIF_State_PrId field.
- The staff member has a Classification Level of 01, 02, 05, 06 or 07
- The staff and the staff's school must not be excluded from state reporting.
For the contract staff course offering link extract, the extract selects records from the Staff/User tables that meet the following criteria:
- The staff member is a lead or co-teacher of the course.
- The staff member has a unique staff ID entered for [USERS]SIF_State_PrId field or a SSN beginning with '998'.
- The staff member has a Classification Level of 03 - contracted professional services person or 04 - third party contract employee.
- The staff and the staff's school must not be excluded from state reporting.
For the vacant staff course offering link extract, the extract selects records from the Staff/User tables that meet the following criteria:
- The staff member is a lead or co-teacher of the course.
- The staff member does not have number recorded for [USERS]SIF_State_PrId field.
- The staff members does not have a Classification Level specified.
- The staff member has a SSN beginning with '999' (which indicates a vacant staff position).
- The staff and the staff's school must not be excluded from state reporting.
For the mentor teacher link extract, the extract selects records from the Staff/User tables that meet the following criteria:
- The staff member has a unique staff ID entered for [USERS]SIF_State_PrId field.
- The staff member has a mentor teacher assignment record for the selected school year.
- The staff and the staff's school must not be 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:
If sub-districts are enabled:
|
Select Staff | Select the staff to include in the report by choosing one of the following options: The Selected [number] Staff Only - Run the report for staff in the current selection. All Staff - Run the report for all staff in the current school or district that meet the selection criteria. Ensure to select the staff prior to running the report, whether the report is for a single or group of staff. |
Output File Name | Choose the extract to generate:
|
School Year | Select the school year for which to run the report. |
Identify as a Partial File | Select this checkbox if the file being generated does not include all staff 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. |
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.
Staff Course Offering Link
Data Element | Description | [Table]FieldName |
LOCAL_STAFF_CRS_OFFRNG_LINK_KEY | The value that uniquely identifies each staff class code record submitted. Required. | [Terms]Firstday, [USERS]SIF_StatePrid OR [S_LA_SEC_X]OverrideTeacherSSN or [USERS]SSN [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) |
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_STAFF_KEY | Unique identifier for the staff. The StateID/Louisiana Secure ID (LASID) assigned by eScholar to the staff. Required. | [USERS]SIF_StatePrid or [S_LA_SEC_X]OverrideTeacherSSN or [USERS]SSN |
LOCAL_COURSE_OFFERINGS_KEY | The Class Code that uniquely identifies a class taught at a school. Required.(See the Curriculum User Guide) To link the students with their respective teachers and their courses, the Class Code submitted in the Curriculum record must match the Class Code submitted in the Student and Teacher Class Schedule records. This data element is used to match staff with their students, staff with their courses, and students with their courses. | [Terms]Firstday, to_char(SectionTeacher.START_DATE,'mm/dd/yyyy')
|
STAFF_CLASS_STATUS | Reports as Active when:
Reports as Inactive when:
Required. | SectionTeacher(table) - if teacher's staff_class_end_date ends prior to the end_date of the class AND the staff_class_end_date is less than today, set the staff_class_status to “Inactive” else "Active" |
STAFF_CLASS_START_DATE | The date the staff member started to teach the class. Required. | SectionTeacher(table) |
STAFF_CLASS_END_DATE | The date the staff member stopped teaching the class. Required. | SectionTeacher(table) |
STAFF_CLASS_PRIMARY_INDICATOR | Y or N based on whether the teacher is teaching the class from their home-base site (or PRIMARY_ASSIGNMENT_IND). Required. | derived from [USERS]HomeSchoolID |
LOCAL_ASSIGNMENT_KEY | The value that uniquely identifies the assignment record submitted by each staff. | Concatenated value of [Terms]Firstday, [USERS]SIF_StatePrid OR [S_LA_SEC_X]OverrideTeacherSSN or [USERS]SSN [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, to_char(SectionTeacher.START_DATE,'mm/dd/yyyy') (use NonLEAClassCode if populated, else use Course number and section number) |
STAFF_CLASS_PERCENT | The percentage of a teacher's class time in a specific class. | [SectionTeacher]Allocation or if null set to 100 |
Staff Course Offering Link Ext (Obsolete beginning 2022-2023 school year)
Data Element | Description | [Table]FieldName |
LOCAL_STAFF_CRS_OFFRNG_LINK_KEY | The value that uniquely identifies each staff class code record submitted. Required. | [Terms]Firstday, [USERS]SIF_StatePrid OR [S_LA_SEC_X]OverrideTeacherSSN or [USERS]SSN [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) |
SCHOOL_YEAR | The year of the school session. Required. | [Terms]FirstDay [Terms]LastDay |
DISTRICT_CODE | The three-digit Sponsor Code assigned by LDOE. Required. | [S_LA_SCH_X]SiteCode (first three characters) |
LOCAL_STAFF_KEY | Unique identifier for the staff. The StateID/Louisiana Secure ID (LASID) assigned by eScholar to the staff. Required. | [USERS]SIF_StatePrid or [S_LA_SEC_X]OverrideTeacherSSN or [USERS]SSN |
TWELVE_HOUR_INDICATOR | A local classification of the primary instructors certification as it relates to this course section. | [S_LA_USR_Courses_C] SubjArea12CrHrFlag |
Mentor Teacher Link
Data Element | Description | [Table]FieldName |
SCHOOL_YEAR | The year of the school session. Required. | [Terms]FirstDay [Terms]LastDay |
DISTRICT_CODE | The three-digit Sponsor Code assigned by LDOE. Required. | [S_LA_SCH_X]SiteCode (first three characters) |
LOCAL_SCHOOL_KEY | The school’s site code. Required. | [S_LA_SCH_X]SiteCode |
MENTOR_LOCAL_STAFF_KEY | The mentor's unique staff member identifier within the district applications. Required. | [S_LA_SSF_MENTOR_C]Schoolstaffdcid |
RESIDENT_LOCAL_STAFF_KEY | The resident's unique staff member identifier within the district applications. Required. | [S_LA_SSF_MENTOR_C]Mentee_id |
RESIDENT_TEACHER_PREP_PROGRAM_TYPE | The prep program type of resident is participating in | [S_LA_SSF_MENTOR_C]Prep_Program_Type |
PLACEMENT_PERCENT | The percentage of their day that the resident is active in the placement | [S_LA_SSF_MENTOR_C]Placement_Percentage |
Contract Staff Course Offering Link
Data Element | Description | [Table]FieldName |
LOCAL_STAFF_CRS_OFFRNG_LINK_KEY | The value that uniquely identifies each staff class code record submitted. Required. | [Terms]Firstday, [USERS]SIF_StatePrid OR [S_LA_SEC_X]OverrideTeacherSSN or [USERS]SSN [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) |
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_STAFF_KEY | Unique identifier for the staff. The StateID/Louisiana Secure ID (LASID) assigned by eScholar to the staff. Required. | [USERS]SIF_StatePrid or [S_LA_SEC_X]OverrideTeacherSSN or [USERS]SSN |
LOCAL_COURSE_OFFERINGS_KEY | The Class Code that uniquely identifies a class taught at a school. Required. (See the Curriculum User Guide) To link the students with their respective teachers and their courses, the Class Code submitted in the Curriculum record must match the Class Code submitted in the Student and Teacher Class Schedule records. This data element is used to match staff with their students, staff with their courses, and students with their courses. | [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) |
STAFF_CLASS_STATUS | Indicates whether the staff is actively teaching the Course Offering (Class Section). Optional. | SectionTeacher(table) - if sys date BETWEEN start_date AND end_date THEN 'Active' ELSE 'Inactive' |
STAFF_CLASS_START_DATE | The date the staff member started to teach the class. Required. | SectionTeacher.start_date |
STAFF_CLASS_END_DATE | The date the staff member stopped teaching the class. Required. | SectionTeacher.end_date |
STAFF_CLASS_PRIMARY_INDICATOR | Y or N based on whether the teacher is teaching the class from their home-base site (or PRIMARY_ASSIGNMENT_IND). Required. | [USERS]HomeSchoolID |
STAFF_CLASS_PERCENT | The percentage of a teacher's class time in a specific class. Optional | [SectionTeacher]Allocation or if null set to 100 |
Contract Staff Course Offering Ext (Obsolete beginning 2022-2023 school year)
Data Element | Description | [Table]FieldName |
LOCAL_STAFF_CRS_OFFRNG_LINK_KEY | The value that uniquely identifies each staff class code record submitted. Required. | [Terms]Firstday, [USERS]SIF_StatePrid OR [S_LA_SEC_X]OverrideTeacherSSN or [USERS]SSN [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) |
SCHOOL_YEAR | The year of the school session. Required. | [Terms]FirstDay [Terms]LastDay |
DISTRICT_CODE | The three-digit Sponsor Code assigned by LDOE. Required. | [S_LA_SCH_X]SiteCode (first three characters) |
LOCAL_STAFF_KEY | Unique identifier for the staff. The StateID/Louisiana Secure ID (LASID) assigned by eScholar to the staff. Required. | [USERS]SIF_StatePrid or [S_LA_SEC_X]OverrideTeacherSSN or [USERS]SSN |
Vacant Staff Course Offering Link
Data Element | Description | [Table]FieldName |
LOCAL_STAFF_CRS_OFFRNG_LINK_KEY | The value that uniquely identifies each staff class code record submitted. Required. | [Terms]Firstday, [S_LA_SEC_X]OverrideTeacherSSN or [USERS]SSN [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) |
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_STAFF_KEY | Unique identifier for the staff. The StateID/Louisiana Secure ID (LASID) assigned by eScholar to the staff. Required. | [S_LA_SEC_X]OverrideTeacherSSN or [USERS]SSN |
LOCAL_COURSE_OFFERINGS_KEY | The Class Code that uniquely identifies a class taught at a school. Required. (See the Curriculum User Guide) To link the students with their respective teachers and their courses, the Class Code submitted in the Curriculum record must match the Class Code submitted in the Student and Teacher Class Schedule records. This data element is used to match staff with their students, staff with their courses, and students with their courses. | [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) |
STAFF_CLASS_STATUS | Indicates whether the staff is actively teaching the Course Offering (Class Section). Optional. | SectionTeacher(table) - if sys date BETWEEN start_date AND end_date THEN 'Active' ELSE 'Inactive' |
STAFF_CLASS_START_DATE | The date the staff member started to teach the class. Required. | SectionTeacher.start_date |
STAFF_CLASS_END_DATE | The date the staff member stopped teaching the class. Required. | SectionTeacher.end_date |
STAFF_CLASS_PRIMARY_INDICATOR | Y or N based on whether the teacher is teaching the class from their home-base site (or PRIMARY_ASSIGNMENT_IND). Required. | [USERS]HomeSchoolID |
STAFF_CLASS_PERCENT | The percentage of a teacher's class time in a specific class. Optional | [SectionTeacher]Allocation or if null set to 100 |