Skip to main content
Skip table of contents

J - English Learners File 2019-2020

Introduction

The English Learners File includes one record for each student enrollment in the State Transitional Bilingual Instruction Program during the current school year. If a student enters, exits, and re-enters the State Transitional Bilingual Instruction Program, there should be two records to reflect the two enrollments. This file also includes a record for each student who is eligible for, but not served by the State Transitional Bilingual Instruction Program.

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis of report results when the report does not return the correct records.

Bilingual Program Selection

The report selects program enrollment records from the [S_WA_STU_LEP_C] table that occurred during the current school year, based on the following criteria:

  • The Program Start Date must be on or before the last day of the current school year.
  • The Program Start Date must be on or before the current date.
  • The Program End Date must be on or after the last day of the current school year.
  • The Program Start Date must be before the Program End Date.
  • The student's school Entry Date must be on or before the last day of the current school year.
  • The student's school Entry Date must be on or before the current date.
  • The student's school Exit Date must be on or after the first day of the current school year.
  • The student must not be excluded from State Reporting.
  • The student must not be excluded from CEDARS reporting.

Report Input

For help with report navigation and generation, see How to Find and Generate a Report.

Field

Description

Select Schools

Choose one of the following:

  • Current School Only – Includes all student records associated with the current school that meet selection criteria. To change the current school, click the School link at the top of the page and choose the appropriate school from the list.
  • All Schools – Includes all student records on the PowerSchool server that meet selection criteria.

Note: The All Schools option is only available when running the report from the District Office.

Current Selection 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.

Note: If running the report for a single student, or group of students, select the students prior to running report.

School YearChoose the year for which to run the report.

Scheduling

Default is Run Now. Select Schedule to run the report on a specific date and time.

Back to Top

Report Output

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.

Item

Data Element

Description

 [Table]FieldName

Reqd

Field Type

Length

J01

School Year

The four-digit year in which the school year ends.

[Terms]LastDay

Yes

Char

4

J02

Serving County District Code

The county district code for the district providing service to the student. Use leading zeroes where necessary.

[Prefs]Value

[Prefs]Name=districtnumber

Yes

Char

5

J03

District Student ID

The locally assigned student identifier.

[Students]Student_Number

Yes

VarChar

50

J04

State Student ID (SSID)

The identifier assigned to each WA public school student by OSPI.

[Students]State_studentnumber

Yes

Char

10

J05

Location ID

The Location ID for the school. The school number is reported.

[Schools]School_Number

[S_WA_STU_LEP_C]SchoolId

Yes

VarChar

4

J06

Instructional Model Code

The Instructional Model Code associated with the student.

[S_WA_STU_LEP_C]instModelCode

Con

Char

1

J07

Program Status Start Date

The date the student enrolled in the program, reported in the format MM/DD/YYYY, or the first in-session day at the student’s school, whichever is later.

[S_WA_STU_LEP_C]startDate

Yes

Date

10

J08

Program Exit Date

The date the student exited the program, reported in the format MM/DD/YYYY.

Rule: This field should be reported if data element J09 is reported.

[S_WA_STU_LEP_C]endDate

Con

Date

10

J09

Exit Reason Code

The reason the student exited the program.

Rule: This field should be blank unless the student exited the program.

[S_WA_STU_LEP_C]ExitReasonCode

Con

Char

1

J10

No longer an Active Data Element.

Formerly Placement Test Scale Score

Beginning with the 2012-2013 school year, Placement Test Scale score will be collected through Element J20 – Placement Test Scale Score.

This position in the extract is now filler (null).

N/A

N/A

N/A


J11

No longer an Active Data Element.

Formerly Placement Test Level Score

Beginning with the 2012-2013 school year, Placement Test Level score will be collected through Element J21 – Placement Test Level Score.

N/A

N/A

N/A


J12

No longer an Active Data Element.

Formerly Placement Test Date

Beginning with the 2012-2013 school year, Placement Test Date will be collected through Element J22 – Placement Test Date.

N/A

N/A

N/A


J13

Initial WA Placement Date

The first date the student was placed in the program in WA state, reported in the format MM/DD/YYYY.

[S_WA_STU_LEP_C]InitialWAPlacementDate


Yes

Date

10

J14

No longer an Active Data Element.

Formerly Initial USA Placement Date

This data element has been moved to District Student File (B), Element B32 – Initial USA School Enrollment Date.

N/A

N/A

N/A


J15

No longer an Active Data Element.

Formerly Number of Months US Attendance

This data element has been moved to District Student File (B), Element B33 – Number of Months US Attendance in School.

N/A

N/A

N/A


J16

No longer an Active Data Element.

Formerly Number of Months Non US Formal Education

This data element has been moved to District Student File (B), Element B34 – Number of Months Non US Attendance in School.

N/A

N/A

N/A


J17

Program Designation

Program designation appropriate for student being reported.

If Element J17 contains valid value = 3, the student must have Element M05 – Race Code (American Indian/Alaskan Native). In addition, Element B17 Primary Language Code must equal 639 – English.

[S_WA_STU_LEP_C]ProgramEligDesignation

Yes

Numeric

1

J18

Placement Test Code

The code that represents the most recent placement test the student took in Washington as described in Element J22 – Placement Test Date.

[S_WA_STU_LEP_C]PlacementTestCode

Con

Numeric

1

J19

Grade Level at Placement

The student’s grade level at the time of the most recent placement test as reported in Elements J18 – Placement Test Code, J20 – Placement Test Scale Score, J21 – Placement Test Level Score, and J22 – Placement Test Date.

[S_WA_STU_LEP_C] GradeLevelAtPlacement

Yes

VarChar

2

J20

Placement Test Score

The student’s program placement test score as described in Element J22 – Placement Test Date.

[S_WA_STU_LEP_C] PlacementTestScaleScore


Con

Numeric

4

J21

Placement Level

The student’s level score as described in Element J22 – Placement Test Date.

[S_WA_STU_LEP_C]placementLevel

Con

Char

2

J22

Placement Test Date

The date the student took the most recent placement test, reported in the format MM/DD/YYYY.

Note: If the student took only one placement exam, the report extracts the same date in J13 – Initial Placement Test Date for this field.

[S_WA_STU_LEP_C]PlacementTestDate

Yes

Date

10

Back to Top

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.