Student English Language Acquisition File Layout

12.01

Record Type Code

Y

Always SELA

12.02

Transaction Type Code

N

Not found in eSchoolPlus. This field tells CALPADS if the data being sent is an update, deletion or new record.

12.03

Local Record ID

N

Not being sent in files created in eSchoolPlus

12.04

Reporting LEA

Y

reg_entry_with

building

Get reg_building.
state_code_equiv

First 7 characters of State Equivalency Code for the building on the Entry/Withdrawal record being reported for the student. The Building State Equivalency Code is found by going to Administration > Registration Setup > Building > Building Definition > Preferences panel.

12.05

School of Attendance

Y

reg_entry_with

building

Get reg_building.
state_code_equiv

Last 7 characters of State Equivalency Code for the building on the Entry/Withdrawal record being reported for the student. The Building State Equivalency Code is found by going to Administration > Registration Setup > Building > Building Definition > Preferences panel.

12.06

Academic Year ID

Y

reg_entry_with

school_year

From the School Year prompt on CALPADS extract/download page.

12.07

SSID

Y

reg_personal

state_report_id

Registration > Entry & Reports > Student Demographic > Personal—SSID field.

12.08

Student Legal First Name

Y

reg

first_name

Registration > Entry & Reports > Student Demographic > Registration—First Name field. Since the State file may only include Alphabetic letters, numbers, periods, hyphens and apostrophes, any other characters in this field will be stripped out for the State File.

12.09

Student Legal Last Name

Y

reg

last_name

Registration > Entry & Reports > Student Demographic > Registration—Last Name field. Since the State file may only include Alphabetic letters, numbers, periods, hyphens and apostrophes, any other characters in this field will be stripped out for the State File.

12.10

Student Birth Date

Y

reg

birthdate

Registration > Entry & Reports > Student Demographic > Registration—Birth Date field. Student Age must be between 0 and 22. If Grade Level is AD, student age must be between 15 and 80.

12.11

Student Gender Code

Y

reg

gender

Registration > Entry & Reports > Student Demographic > Personal —Gender field.

12.12

Local Student ID

N

reg

student_id

Student ID field

12.13

English Language Acquisition Status Code

If field 1.25 = AD, then "Y"

Y

reg_programs

program_value where reg_program_column.state_code_equiv = ca120_prof

Registration > Entry & Reports > Student Demographic > Programs > CA120 – English Proficiency: English Proficiency value

Perform additional validation if there is a value in Registration > Entry & Reports > Student District Defined > CA Demographics: CALPADS Status ELA field. Verify this value matches English Proficiency.

In your database, CALPADS Status ELA is reg_user.field_value where page_number = 200 and field_number = 24

12.14

English Language Acquisition Status Start Date

Y

Y

reg_programs

start_date where reg_program_column.state_code_equiv = ca120_prof

Registration > Entry & Reports > Student Demographic > Programs > CA120 – English Proficiency: English Proficiency Start Date

Perform additional validation if there is a value in Registration > Entry & Reports > Student District Defined > CA Demographics: CALPADS Status ELA Start Date field. Verify this value matches Eng Proficiency Status Date shown on CA Demographics.

In your database, CALPADS Status ELA Start Date is reg_user.field_value where page_number = 200 and field_number = 25

12.15

Primary Language Code

Y

Y

reg

home_language
Get regtb_language.state_code_equiv

Registration > Entry & Reports > Student Demographic > Registration > Current Year tab: Home Language field

Administration > General Setup > District > Validation Tables > select Registration: State Code Equiv field

Perform additional validation if there is a value in Registration > Entry & Reports > Student District Defined > CA Demographics: CALPADS Status ELA Language field. Verify this value matches the student's Home Language from the Registration page.

In your database, CALPADS Status ELA Language is reg_user.field_value where page_number = 200 and field_number = 26

Registration > Entry & Reports > Student Demographic > Programs > CA120 – Status ELA Correction Reason: Status ELA Correction Reason value

Perform additional validation if there is a value in Registration > Entry & Reports > Student District Defined > CA Demographics: CALPADS Status ELA Correction Reason field. Verify this value matches Status ELA Correction Reason.