LA EdLink K-3 Assessments

On this page:

Introduction

This report collects kindergarten through third-grade assessment information and creates an extract file for submission to the EdLink warehouse. Use PowerSchool's Remote Connection Management feature to set up an 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 start date.
The student’s school entry date must occur on or before the school year 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 entry date must occur on or between the Include students attending school between date range.
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 (e.g. NoShow students) will be excluded from the file.
For students who have switched between grade levels during the year, only the most recent enrollment record for that year is considered when generating records. The information from the latest school is reported.
Inactive students in grades less than 4 who have attended the school at some point during the year will be included in the file.

A student within a district or sub-district is reported only once in this K-3 extract.

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.
School Year	Select the school year for which to run the report. The options are controlled by the current Term selected.
Select K-3 Screening Cycle to report	Indicate which set of literacy testing data should be included in the EdLink extract file. Values are Beginning of the School Year, Middle of the School Year, and End of the School Year
Include students attending school between Start Date	Indicate that students attending the school during this date range (minimum one day attended) should be included in the K-3 Assessment file. Start date of range
End Date	End date of range
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.

Data Element	Description	[Table]FieldName
STUDENT_LOCAL_ID	The locally assigned student identifier. Required.	[Students]Student_Number
LOCAL_STUDENT_KEY	The student’s state-assigned identifier. Required.	[Students]State_StudentNumber
STUDENT_LAST_NAME	The student's legal last name. Required.	[Students]Last_Name
STUDENT_FIRST_NAME	The student's legal first name. Required.	[Students]First_Name
SCHOOL_YEAR	The school year for which the report is being run. Required.	Derived from: [Terms]FirstDay [Terms]LastDay
LOCAL_SCHOOL_KEY	The six digits of the school site code. Required.	[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)
ENTRY_GRADE_CODE	The student's grade level. Required. Valid values: 25 – Kindergarten 01 – First 02 – Second 03 – Third	[Students]Grade_Level [ReEnrollments]Grade_Level
LITERACY_SCREENER_EXCEPTION_CODE	The reason the student did not complete a literacy screening. Required. Valid values: Blank/Null = Literacy Screener completed 01 = Student not assessed due to extenuating medical reasons 02 = Not first time Kindergartener 04 = Student assessed with TSGOLD 05 = Student has a documented significant disability and was assessed with an approved alternate assessment	[S_LA_STU_K3Assessment_X]LiteracyScreenerExceptCode or [S_LA_STU_K3Assessment_X]LiteracyScExceptCodeMOY or [S_LA_STU_K3Assessment_X]LiteracyScExceptCodeEOY depending on the K-3 screening cycle value selected when running the report.
ALTERNATE_ASSESSMENT_REASON_CODE	Required only if Literacy_Screener_Exception_Code is not blank. Valid values: 01 = Hearing Disabled 02 = Visually Disabled 03 = Verbally Disabled	[S_LA_STU_K3Assessment_X] AltAssessmentReasonCode or [S_LA_STU_K3Assessment_X] AltAssessmentReasonCodeMOY or [S_LA_STU_K3Assessment_X] AltAssessmentReasonCodeEOY depending on the K-3 screening cycle value selected when running the report.
VIRTUAL_SETTING_FLAG	Indicates if the student was assessed virtually. Valid values are Y or N.	[S_LA_STU_K3Assessment_X]VirtualSetting_TF or [S_LA_STU_K3Assessment_X]VirtualSetting_TFMOY or [S_LA_STU_K3Assessment_X]VirtualSetting_TFEOY depending on the K-3 screening cycle value selected when running the report.
LITERACY_SCREENER_TEST_TYPE	The literacy screener test that the student took. Required only if Literacy_Screener_Exception_Code is blank. Valid values: 1 = Acadience Reading (formerly DIBELS Next) 2 = STEEP 3 = STEP 4 = Dibels 8	[S_LA_STU_K3Assessment_X]LiteracyScreenerTestType or [S_LA_STU_K3Assessment_X]LiteracyScreenerTestTypeMOY or [S_LA_STU_K3Assessment_X]LiteracyScreenerTestTypeEOY depending on the K-3 screening cycle value selected when running the report.
LITERACY_SCREENER_SCORE	The score the student received on the screener test. Required only if Literacy_Screener_Exception_Code is blank. Valid values: 0-999.	[S_LA_STU_K3Assessment_X]LiteracyScreenerScore or [S_LA_STU_K3Assessment_X]LiteracyScreenerScoreMOY or [S_LA_STU_K3Assessment_X]LiteracyScreenerScoreEOY depending on the K-3 screening cycle value selected when running the report.
LITERACY_ASSESSMENT_DETERMINATION_CODE	The assessment determination code. Required only if Literacy_Screener_Exception_Code is '05'. Valid values are: 01: Alternative assessment 02: Alternate procedures of administration for standard K-3 literacy screener	[S_LA_STU_K3Assessment_X]LiteracyAssmntDetrCode OR [S_LA_STU_K3Assessment_X]LiteracyAssmntDetrCodeMOY OR [S_LA_STU_K3Assessment_X]LiteracyAssmntDetrCodeEOY depending on the K-3 screening cycle value selected when running the report.
K_ENTRY_ASSESSMENT_EXCEPTION_CODE	The reason the student did not take a K Entry assessment. Required for Kindergarten, not allowed for grades 1-3. Valid values: Blank/Null = K entry assessment completed 01 = Student not assessed due to extenuating medical reasons 02 = Not first time Kindergartener 04 = Student assessed with TSGOLD 05 = Student has a documented significant disability and was assessed with an approved alternate assessment	[S_LA_STU_K3Assessment_X]KEntryAssmntExcptnCode
ATL _REG1_CURIOSITY	The evaluation of the student's curiosity. Required for Kindergarten if K_Entry_Assessment_Exception_Code is blank; not allowed for grades 1-3. Valid values: Kindergarten Entry Assessment Codes	[S_LA_STU_K3Assessment_X]ALTREG1Curiosity
ATL _REG2_SELFCONTROL	The evaluation of the student's self-control. Required for Kindergarten if K_Entry_Assessment_Exception_Code is blank; not allowed for grades 1-3. Valid values: Kindergarten Entry Assessment Codes	[S_LA_STU_K3Assessment_X]ALTREG2SelfControl
ATL _REG3_PERSISTENCE	The evaluation of the student's level of persistence. Required for Kindergarten if K_Entry_Assessment_Exception_Code is blank; not allowed for grades 1-3. Valid values: Kindergarten Entry Assessment Codes	[S_LA_STU_K3Assessment_X]ALTREG3Persistence
ATL _REG4_SHARING	The evaluation of the student's ability to share. Required for Kindergarten if K_Entry_Assessment_Exception_Code is blank; not allowed for grades 1-3. Valid values: Kindergarten Entry Assessment Codes	[S_LA_STU_K3Assessment_X]ALTREG4Sharing
SED1_SELF _IDENTITY	The evaluation of the student's self-identity. Required for Kindergarten if K_Entry_Assessment_Exception_Code is blank; not allowed for grades 1-3. Valid values: Kindergarten Entry Assessment Codes	[S_LA_STU_K3Assessment_X]SED1SelfIdentity
SED2_FEELINGS	The evaluation of the student's feelings. Required for Kindergarten if K_Entry_Assessment_Exception_Code is blank; not allowed for grades 1-3. Valid values: Kindergarten Entry Assessment Codes	[S_LA_STU_K3Assessment_X]SED2Feelings
SED3_INTERACTION_WITH_ADULTS	The evaluation of the student's interaction with adults. Required for Kindergarten if K_Entry_Assessment_Exception_Code is blank; not allowed for grades 1-3. Valid values: Kindergarten Entry Assessment Codes	[S_LA_STU_K3Assessment_X]SED3InteractionWithAdults
SED4_INTERACTION_WITH_PEERS	The evaluation of the student's interaction with peers. Required for Kindergarten if K_Entry_Assessment_Exception_Code is blank; not allowed for grades 1-3. Valid values: Kindergarten Entry Assessment Codes	[S_LA_STU_K3Assessment_X]SED4InteractionWithPeers
SED5_SOCIODRAMATIC_PLAY	The evaluation of the student's sociodramatic play. Required for Kindergarten if K_Entry_Assessment_Exception_Code is blank; not allowed for grades 1-3. Valid values: Kindergarten Entry Assessment Codes	[S_LA_STU_K3Assessment_X]SED5SociodramaticPlay
LLD1_UNDERSTANDING_OF_LANGUAGE	The evaluation of the student's understanding of language. Required for Kindergarten if K_Entry_Assessment_Exception_Code is blank; not allowed for grades 1-3. Valid values: Kindergarten Entry Assessment Codes	[S_LA_STU_K3Assessment_X]LLD1UnderstandingOfLang
LLD2_RESPONSIVENESS_TO_LANGUAGE	The evaluation of the student's responsiveness to language. Required for Kindergarten if K_Entry_Assessment_Exception_Code is blank; not allowed for grades 1-3. Valid values: Kindergarten Entry Assessment Codes	[S_LA_STU_K3Assessment_X]LLD2ResponsivenessToLang
LLD3_USE_OF_LANGUAGE	The evaluation of the student's use of language. Required for Kindergarten if K_Entry_Assessment_Exception_Code is blank; not allowed for grades 1-3. Valid values: Kindergarten Entry Assessment Codes	[S_LA_STU_K3Assessment_X]LLD3UseOfLang
LLD4_CONVERSATION	The evaluation of the student's conversation ability. Required for Kindergarten if K_Entry_Assessment_Exception_Code is blank; not allowed for grades 1-3. Valid values: Kindergarten Entry Assessment Codes	[S_LA_STU_K3Assessment_X]LLD4Conversation
LLD5_INTEREST_IN_LITERACY	The evaluation of the student's interest in literacy. Required for Kindergarten if K_Entry_Assessment_Exception_Code is blank; not allowed for grades 1-3. Valid values: Kindergarten Entry Assessment Codes	[S_LA_STU_K3Assessment_X]LLD5InterestLiteracy
LLD6_COMPREHENSION	The evaluation of the student's literacy comprehension. Required for Kindergarten if K_Entry_Assessment_Exception_Code is blank; not allowed for grades 1-3. Valid values: Kindergarten Entry Assessment Codes	[S_LA_STU_K3Assessment_X]LLD6Comprehension
LLD7_PRINT_CONCEPTS	The evaluation of the student's ability to understand print concepts. Required for Kindergarten if K_Entry_Assessment_Exception_Code is blank; not allowed for grades 1-3. Valid values: Kindergarten Entry Assessment Codes	[S_LA_STU_K3Assessment_X]LLD7PrintConcepts
LLD8_PHONOLOGICAL_AWARENESS	The evaluation of the student's phonological awareness. Required for Kindergarten if K_Entry_Assessment_Exception_Code is blank; not allowed for grades 1-3. Valid values: Kindergarten Entry Assessment Codes	[S_LA_STU_K3Assessment_X]LLD8PhonologicalAwareness
LLD9_LETTER_KNOWLEDGE	The evaluation of the student's understanding of letters. Required for Kindergarten if K_Entry_Assessment_Exception_Code is blank; not allowed for grades 1-3. Valid values: Kindergarten Entry Assessment Codes	[S_LA_STU_K3Assessment_X]LLD9LetterKnowledge
LLD10_WRITING	The evaluation of the student's writing ability. Required for Kindergarten if K_Entry_Assessment_Exception_Code is blank; not allowed for grades 1-3. Valid values: Kindergarten Entry Assessment Codes	[S_LA_STU_K3Assessment_X]LLD10Writing
COG _MATH2_MATH_OPERATIONS	The evaluation of the student's understanding of math operations. Required for Kindergarten if K_Entry_Assessment_Exception_Code is blank; not allowed for grades 1-3. Valid values: Kindergarten Entry Assessment Codes	[S_LA_STU_K3Assessment_X]COG2MathOperation
COG _MATH3_NUMBER_SENSE_ OF_QUANTITY	The evaluation of the student's sense of numeric quantity. Required for Kindergarten if K_Entry_Assessment_Exception_Code is blank; not allowed for grades 1-3. Valid values: Kindergarten Entry Assessment Codes	[S_LA_STU_K3Assessment_X]COG3NoSenseofQuantity
COG _MATH4_MEASUREMENT	The evaluation of the student's understanding of measurement. Required for Kindergarten if K_Entry_Assessment_Exception_Code is blank; not allowed for grades 1-3. Valid values: Kindergarten Entry Assessment Codes	[S_LA_STU_K3Assessment_X]COG4Measurement
COG _MATH6_SHAPES	The evaluation of the student's understanding of shapes. Required for Kindergarten if K_Entry_Assessment_Exception_Code is blank; not allowed for grades 1-3. Valid values: Kindergarten Entry Assessment Codes	[S_LA_STU_K3Assessment_X]COG6Shapes
PD1_PERCEPTUAL_MOTOR	The evaluation of the student's perceptual-motor skills. Required for Kindergarten if K_Entry_Assessment_Exception_Code is blank; not allowed for grades 1-3. Valid values: Kindergarten Entry Assessment Codes	[S_LA_STU_K3Assessment_X]PD1PerceptualMotor
PD2_GROSS_LOCOMOTOR	The evaluation of the student's gross locomotor skills. Required for Kindergarten if K_Entry_Assessment_Exception_Code is blank; not allowed for grades 1-3. Valid values: Kindergarten Entry Assessment Codes	[S_LA_STU_K3Assessment_X]PD2GrossLocomotor
PD3_GROSS_MOTOR_MANIPULATIVE	The evaluation of the student's gross motor manipulation. Required for Kindergarten if K_Entry_Assessment_Exception_Code is blank; not allowed for grades 1-3. Valid values: Kindergarten Entry Assessment Codes	[S_LA_STU_K3Assessment_X]PD3GrossMotorManipulative
PD4_FINE_MOTOR	The evaluation of the student's fine motor manipulation. Required for Kindergarten if K_Entry_Assessment_Exception_Code is blank; not allowed for grades 1-3. Valid values: Kindergarten Entry Assessment Codes	[S_LA_STU_K3Assessment_X]PD4FineMotor