LA EdLink Students
Contents
Introduction
This report collects student information and creates an extract file for submission to the EdLink warehouse. The report includes demographic, address, Section 504, and program participation information in three extracts. 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.
Student Selection
The report selects records from the [Students] table that meet the following criteria:
The student’s school exit date must occur after the school year's start date.
The student’s school entry date must occur on or before the school year's end date.
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).
The student’s school exit date must occur after their school entry date.
The student, the student’s school, and the student’s school enrollment must not be excluded from state reporting.
Students with entry and exit dates for the same day will be included in the file.
Students with a grade level of -4, -5 or -6 (Infant, Toddler, Pre-Kindergarten Age 3) will be excluded from the extract.
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
Field | Description |
Select Schools |
|
Select Students | Indicate which students to include in the report by selecting one of the following options:
If you are running the report for a single student, or a group of students, select the students before running the report. |
Output File Name | Select the extract to generate. |
School Year | Select the school year for which to run the report. The options are controlled by the current Term selected. |
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. |
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.
Students
Data Element | Description | [Table]FieldName |
LOCAL_STUDENT_KEY | The student’s state-assigned identifier. Required. | [Students]State_StudentNumber |
SCHOOL_YEAR | The year of a school session. Required. | [Terms]FirstDay |
STUDENT_LOCAL_ID | The locally assigned student identifier. Required. | [Students]Student_Number |
STUDENT_STATE_ID | The student’s state-assigned identifier. Required. | [Students]State_StudentNumber |
STUDENT_FEDERAL_ID | The student's ArchivedStudentID number. | [Students]SSN |
STUDENT_LAST_NAME | The student's legal last name. Required. | [Students]Last_Name |
STUDENT_LAST_NAME_SUFFIX | The student's legal suffix name. | [S_LA_STU_X]NameSuffix (periods are stripped on output) |
STUDENT_FIRST_NAME | The student's legal first name. Required. | [Students]First_Name |
STUDENT_MIDDLE_NAME | The student's legal second or middle name (if populated). Required. | [Students]Middle_Name |
STUDENT_BIRTHDATE | The student’s day of birth. Required. | [Students]DOB |
STUDENT_ORIGIN_IND_HISPANIC | Indicates whether the student’s ethnicity is Hispanic. Required. | [Students]FedEthnicity "Yes" is reported if HispanicLatinoEthnicFlg = Y OR EthnicCd = 4 OR FedRaceEthnicityCd = HI7. Otherwise, a "No" is reported. |
STUDENT_ORIGIN_IND_ASIAN | Indicates whether the student’s race is Asian. Required. | [Students]FedEthnicity "Yes" is reported if AsianRaceFlg = Y OR EthnicCd = 2 OR FedRaceEthnicityCd = AS7. Otherwise, a "No" is reported. |
STUDENT_ORIGIN_IND_BLACK | Indicates whether the student’s race is Black or African American. Required. | [Students]FedEthnicity "Yes" is reported if BlackOrAfricanAmericanRaceFlg = Y OR EthnicCd = 3 OR FedRaceEthnicityCd = BL7. Otherwise, a "No" is reported. |
STUDENT_ORIGIN_IND_NATIVE_AMER | Indicates whether the student’s race is American Indian or an Alaskan Native. Required. | [Students]FedEthnicity "Yes" is reported if AmericanIndianOrAlaskanNativeRaceFlg = Y OR EthnicCd = 1 OR FedRaceEthnicityCd = AM7. Otherwise, a "No" is reported. |
STUDENT_ORIGIN_IND_PACIF_ISLND | Indicates whether the student’s race is White. Required. | [Students]FedEthnicity "Yes" is reported if NativeHawaiianOrOtherPacificIslanderRaceFlg = Y OR FedRaceEthnicityCd = PI7. Otherwise, a "No" is reported. |
STUDENT_ORIGIN_IND_WHITE | Indicates whether the student’s race is Native Hawaiian or Other Pacific Islander. Required. | [Students]FedEthnicity "Yes" is reported if WhiteRaceFlg = Y OR EthnicCd = 5 OR FedRaceEthnicityCd = WH7. Otherwise, a "No" is reported. |
STUDENT_TRANSPORT_STATUS | The student's primary form of transportation to and from their current school. | Blank |
STUDENT_INFORMATION_RELEASE | Indicates if there is parental consent to include the student's data in widely distributed or external reports. | [S_LA_STU_X]LOSFAConsentFlag |
DISTRICT_CODE | The three-digit Sponsor Code assigned by LDOE. Required. | [Prefs]Value where |
STUDENT_GENDER_CODE | The student’s gender. Required. Valid values:
| [Students]Gender |
STUDENT_LANGUAGE | The student's primary language. Required. | [S_LA_STU_Language_X]LanguageCode |
STUDENT_COUNTRY_OF_BIRTH | The country in which the student was born. Required. Valid values:
| [S_LA_STU_Demographics_X]BirthCountry |
STUDENT_MILITARY_FAMILY_IND | Indicates whether the student's parents or guardians are affiliated with the military for their career (active duty, reserves, retired). Valid values: Y or N | [S_LA_STU_X]MilitaryAffiliation |
Students_Ext
Data Element | Description | [Table]FieldName |
LOCAL_STUDENT_KEY | The student’s state-assigned identifier. Required. | [Students]State_StudentNumber |
SCHOOL_YEAR | The year of a school session. Required. | [Terms]FirstDay |
DISTRICT_CODE | The three-digit Sponsor Code assigned by LDOE. Required. | [Prefs]Value where |
FIRST_US_ENTRY_DATE | The month, day, and year of the student's initial arrival into the U. S. | [Students]DateOfEntryIntoUSA |
PARENT_INDICATOR | Indicates whether the student is a parent or an expectant parent. Required. Values Y or N. | [S_LA_STU_X]ParentofChild |
GRADE_9_ENTRY_YEAR | The year the student entered 9th grade. Only the beginning year of the school year is reported. For example, 2017-2018 reports as "2017". | [S_LA_STU_Academics_X] YearEnteredNinthGrade |
IAP_REVIEW_DATE | The date a student’s Individual Accommodation Plan (IAP) is reviewed. Required for a special education student. | [S_LA_STU_504SPED_X]IAPReviewDate |
LAST_EVALUATION_DATE | The date of the student’s most recent 504 evaluation. Required for a special education student. | [S_LA_STU_504SPED_X]DateOf504 |
DISABILITY_01_CODE | The student’s first section 504 disability. Required for a special education student. | [S_LA_STU_504SPED_X]Disability1 |
DISABILITY_02_CODE | The student’s second section 504 disability. | [S_LA_STU_504SPED_X]Disability2 |
DISABILITY_03_CODE | The student’s third section 504 disability. | [S_LA_STU_504SPED_X]Disability3 |
DISABILITY_04_CODE | The student’s fourth section 504 disability. | [S_LA_STU_504SPED_X]Disability4 |
DISABILITY_05_CODE | The student’s fifth section 504 disability. | [S_LA_STU_504SPED_X]Disability5 |
DISABILITY_06_CODE | The student’s sixth section 504 disability. | [S_LA_STU_504SPED_X]Disability6 |
DISABILITY_07_CODE | The student’s seventh section 504 disability. | [S_LA_STU_504SPED_X]Disability7 |
SERVICES_EXIT_DATE | The date the student exited all 504 services. | [S_LA_STU_504SPED_X]ExitDate |
SERVICES_EXIT_REASON_CODE | Indicates why a student no longer receives 504 services Valid values
| [S_LA_STU_504SPED_X]ExitReason |
LARGE_PRINT_ACCOM_CODE | Indicates whether a student requires large print assessments. Required. Valid values:
| [S_LA_STU_504SPED_X]LargePrintAccomm |
EXTEND_TIME_ACCOM_CODE | Indicates whether a student requires extended time for assessments. Required. Valid values:
| [S_LA_STU_504SPED_X] ExtendedTimeAccomm |
ANSWER_RECORD_ACCOM_CODE | Indicates whether a student needs to record the answers for assessments. Required. Valid values:
| [S_LA_STU_504SPED_X] AnswersRecordedAccomm |
TRANSFER_ANSWER_ACCOM_CODE | Indicates whether a student requires the answers transferred for assessments. Required. Valid values:
| [S_LA_STU_504SPED_X] TransferredAnswersAccomm |
INDIV_TEST_ACCOM_CODE | Indicates whether a student requires individual testing. Required. Valid values:
| [S_LA_STU_504SPED_X] IndividualTestingAccomm |
SMALL_GROUP_TEST_ACCOM_CODE | Indicates whether a student requires small group testing. Required. Valid values:
| [S_LA_STU_504SPED_X] SmallGroupTestingAccomm |
READ_ELA_ACCOM_CODE | Indicates whether a student requires that tests for English/Language Arts be read aloud. Required. Valid values:
| [S_LA_STU_504SPED_X] ReadEnglishLangArtsAccomm |
READ_MATH_ACCOM_CODE | Indicates whether a student requires that tests for Math be read aloud. Required. Valid values:
| [S_LA_STU_504SPED_X]ReadMathAccomm |
READ_SCI_ACCOM_CODE | Indicates whether a student requires that tests for Science be read aloud. Required. Valid values:
| [S_LA_STU_504SPED_X]ReadScienceAccomm |
READ_SS_ACCOM_CODE | Indicates whether a student requires that tests for Social Studies be read aloud. Required. Valid values:
| [S_LA_STU_504SPED_X]ReadSocStudAccomm |
MILITARY_BASE_RESIDE_FLAG | Indicates if the LEA is allowed to show if the address is located on a military base. This is to help direct funding. | [S_LA_STU_X]MilitaryBaseAddressInd_TF |
NON_DISTRICT_FUND_SITE_FLAG | Indicates if the LEA is allowed to show if the student attending is in a non-district building. This is to help direct funding. | [S_LA_STU_X]NonDistrictBldgFlag or [S_LA_SCH_Charter_X]NonDistrictBldgFlag |
STUDENT_VIRTUAL_INDICATOR_CODE | Indicates whether the student is attending school in person, remotely, or a combination of both. This information is based on the current date. 01 = 100% Virtual If no data is specified for the student, this field will be reported as '01' (100% Virtual). | [S_LA_STU_VirtualIndicator_C]Code where [S_LA_STU_VirtualIndicator_C]EffectiveDate is <= the current date |
EL_BILINGUAL_DICTIONARY | EL Individual Testing Accommodation | [S_LA_STU_Language_X]Bilingual_Dictionary |
EL_COMPOSITIONS | EL Individual Testing Accommodation | [S_LA_STU_Language_X]Compositions |
EL_COOPERATIVE_LEARNING | EL Individual Testing Accommodation | [S_LA_STU_Language_X]Cooperative_Learning |
EL_EXTENDED TIME | EL Individual Testing Accommodation | [S_LA_STU_Language_X]Extended_Time |
EL_INCREASED_HANDS_ON_ACTIVITIES | EL Individual Testing Accommodation | [S_LA_STU_Language_X]Increased_Hands_Activities |
EL_MODIFIED_SHORTENED_TEST | EL Individual Testing Accommodation | [S_LA_STU_Language_X]Modified_Shortened_Test |
EL_PEER_ASSIT_NOTE_TAKING | EL Individual Testing Accommodation | [S_LA_STU_Language_X]Peer_Assit_Note_Taking |
EL_PHOTOCOPIED_NOTES | EL Individual Testing Accommodation | [S_LA_STU_Language_X]Photocopied_Notes |
EL_SPELLING DEDUCTIONS | EL Individual Testing Accommodation | [S_LA_STU_Language_X]Spelling_Deductions |
EL_AUDIOTEXTBOOKS | EL Individual Testing Accommodation | [S_LA_STU_Language_X]Audiotextbooks |
EL_WORD TO WORD DICTIONARY | EL Individual Testing Accommodation | [S_LA_STU_Language_X]Word_to_Word_Dictionary |
EL_SHORTENED_REDUCED_ASSIGNMENTS | EL Individual Testing Accommodation | [S_LA_STU_Language_X]Shortnd_Reduced_Assignmnts |
EL_REPEATED_DIRECTIONS | EL Individual Testing Accommodation | [S_LA_STU_Language_X]Repeated_Directions |
EL_SHORTENED_ASSIGNMENTS | EL Individual Testing Accommodation | [S_LA_STU_Language_X]Shortened_Assignments |
EL_DIRECTIONS_NATIVE_LANGUAGE | EL Individual Testing Accommodation | [S_LA_STU_Language_X]Directions_Native_Language |
EL_NATIVE_LANGUAGE_READING_MATERIAL | EL Individual Testing Accommodation | [S_LA_STU_Language_X]Nativ_Lang_Readng_Material |
EL_MATH_ASSESSMENT_SPANISH | EL Individual Testing Accommodation | [S_LA_STU_Language_X]Math_Assessment_Spanish |
EL_READ_MATH | EL Individual Testing Accommodation | [S_LA_STU_Language_X]Read_Math |
EL_READ_SCIENCE | EL Individual Testing Accommodation | [S_LA_STU_Language_X]Read_Science |
EL_SOCIALSTUDIES | EL Individual Testing Accommodation | [S_LA_STU_Language_X]Socialstudies |
EL_LEAP2025_MATH_ASSESS_SPANISH | EL Individual Testing Accommodation | [S_LA_STU_Language_X]Leap2025_Math_Asses_Spansh |
Program_Membership
Data Element | Description | [Table]FieldName |
LOCAL_PROGRAM_MEMBERSHIP_KEY | A value that uniquely identifies each student program membership record submitted. Required | Derived as BeginningSchoolSessionYear; SponsorCd; StudentIdNumber; SiteCd; ProgramCd; ProgramStartDate [Terms]FirstDay
(uses the student's enrollment_schoolid or schoolid to determine the school that the student attended based on District Preference) |
SCHOOL_YEAR | The year of a school session. Required. | [Terms]FirstDay |
DISTRICT_CODE | The three-digit Sponsor Code assigned by LDOE. Required. | First three digits of [S_LA_SCH_X]SiteCode |
LOCAL_STUDENT_KEY | The student’s state-assigned identifier. Required. | [Students]State_StudentNumber |
LOCAL_PROGRAM_KEY | A value that uniquely identifies each program record submitted. Required. | [S_LA_STU_StudentPrograms_X] (program code translated from PROGCD table),
PROGCD values:
|
LOCAL_SCHOOL_KEY | The school’s site code. Required. | [S_LA_STU_StudentPrograms_X](Program)_OverrideSiteCode if populated, otherwise[S_LA_STU_X]SiteCodeOverride or [S_LA_REN_X]SiteCodeOverride or [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) |
CALENDAR_CODE | The unique, district-assigned code identifying the particular calendar associated with the school and the student. | [S_LA_STU_X]CalendarCode |
MEMBERSHIP_BEGIN_DATE | The start date of the program membership. | [S_LA_STU_StudentPrograms_X](Program)_EntryDate, if populated. Otherwise, the first date in the school's calendar for the corresponding school year. |
MEMBERSHIP_END_DATE | The end date of the program membership. | [S_LA_STU_StudentPrograms_X](Program)_ExitDate, if populated. Otherwise, the last date in the school's calendar for the corresponding school year. |