J - English Learners File 2021-2022
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:
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:
If you are running the report for a single student, or a group of students, select the students before running the report.
|
School Year | Choose the year for which to run the report. |
Scheduling | Select Schedule to run the report on a specific date and time. Default is Run Now. |
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.
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 the student being reported. If Element J17 contains a valid value equaling 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.
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 |
J23 | Overall Placement Test Score | The overall score the student earned upon taking the most recent WIDA screener for the State Transitional Bilingual Instruction Program or English Language Development services. Enter the overall score the student earned upon taking the most recent screener. This element only refers to the most recent screener, and is not for reporting of annual assessment information. Rule: Must be a valid value from the list below. This will appear as a numeric value, even though this is submitted as a character data type, and must include one digit to the right of the decimal point (scale). Data is required if Element J18 –Placement Test Code is 10 – WIDA Screener (in Washington Public Schools). | [S_WA_STU_LEP_C]PlacementTestScore | Con | Char |