EL Upload (Montana)

Classic Path: MT State Reporting > MT Data Upload > English Learner (EL)

Search Terms: English Learner (EL)

The English Learner (EL) Upload allows users to import EL-specific data en masse. See the Upload Wizard (Montana) article for more information about this tool. 

Image 1: MT Uploads - English Learner (EL)

Importing English Learner (EL) Records

See the Uploading Files section of the MT Data Upload article for detailed information about importing records via the MT Data Upload tool. 

The Retrieve New Student State ID File option is only relevant to Student Demographic uploads. Please ignore this option when uploading EL data.

Header Layout

Data Element

Description

Type, Format and Length

Campus Database

Campus Interface

Record Type

The abbreviation for the type of file upload entered.  This will always report as LP.

Alphanumeric, 2 characters

Not dynamically stored

Not dynamically stored

Date

The most recent date a change was made on the file, or the date the file was generated.

Date field, 10 characters
MM/DD/YYYY

Not dynamically stored

Not dynamically stored

Time

The most recent time a change was made on the file, or the date the file was generated.

Time field, 8 characters
HH:MM:SS

Not dynamically stored

Not dynamically stored

Version

The most current version of the file interface specification and references to the application system. This field will always report as MT9.1.

Alphanumeric, 5 characters 

Not dynamically stored

Not dynamically stored

Upload Layout

Data Element

Description

Type, Format and Length

Campus Database

Campus Interface

Record Type

Always reports a value of "LP".

Alphanumeric, 2 characters

N/A

N/A

District Number

Unique identifier assigned to the district by the OPI.

String, 4 digits
 
Number is zero padded when necessary.

district.number

System Administration > Resources > District Information > State District Number

Student State ID

The reporting student's unique 9-digit statewide student ID number.

String, 9 characters
 
Number is zero padded when necessary.

person.StateID

Census > People > Demographics > Student State ID

Last Name

Last name of the reporting student.

Alphanumeric, 40 characters

person.lastName

Census > People > Demographics > Last Name

First Name

First name of the reporting student.

Alphanumeric, 35 characters

person.firstName

Census > People > Demographics > First Name

EL Program Status

The student's EL Program Status code.

Alphanumeric, 2 characters

English Learner (EL).programStatus

Student Information > Program Participation > EL > EL > EL Program Status

EL Identified Date

The date in which the student was assessed or evaluated and determined to be EL (English Learner).

Date, 10 digits
 
MM/DD/YYYY

English Learner (EL).identifiedDate

Student Information > Program Participation > EL > EL > EL Identified Date

ELP Exit Date

The date in which the student was determined to no longer be EL (English Learner).

Date, 10 digits
 
MM/DD/YYYY

English Learner (EL)exitDate

Student Information > Program Participation > EL > EL > Program Exit Date

Language of Impact

The language other than English which influences the student's English language development.
 
See the Language of Impact table.

Numeric, 2 digits

Identity.languageAlt

Census > People > Identities > Language Of Impact

Primary Home Language

The language first learned and spoken in the student's home. The default language is English.

Alphanumeric, 3 characters

Identity.home PrimaryLanguage

Census > People > Identities > Home Primary Language

EL Service

The student's EL Service. The only acceptable value is Title III.

Please see the Update/Validation Logic section below for a complete breakdown of validation logic.

Will report as "Title III"

ELServiceType.type

Student Information > Program Participation > EL > EL Services > Service Type

EL Service Start Date

The start date of the student's EL service. Only Service Start Dates which meet all the following requirements are imported:


    • The Service Start Date is on or after the EL Identified Date.
    • The Service Start Date is prior to the EL Exit Date.
    • The Service End Date is null or after the Service Start Date.
    • The reporting service must be Title III.

Date, 10 digits
 
MM/DD/YYYY

ELService.startDate

Student Information > Program Participation > EL > EL Services > Start Date

EL Service End Date

The end date of the student's EL service. Only Service End Dates which meet all of the following requirements are imported:


    • The EL Service End Date must be greater than or equal to the EL Identified Date and less than or equal to the EL Exit Date.
    • The Service End Date must be greater than or equal to the EL Service Start Date.
    • If Service End Date is not null, EL Program Status must equal EL or Exited EL.

Date, 10 digits
 
MM/DD/YYYY

ELService.endDate

Student Information > Program Participation > EL > EL Services > End Date

End Year

End year of the reporting calendar year. For example, for the 2011-2012 school year, the end year would be 2012.

Numeric, 4 digits
 
YYYY

Calendar.endYear

System Administration > Calendar > School Years > End Year

Update/Validation Logic

The following update and validation logic occurs during import of an English Learner (EL) file.

Data Element

Validation

Student State ID

The record must match on the student's State ID and the student must have an enrollment record in the current calendar (end year).

EL Program Status

If the current EL Program Status = EL

  • If the EL Identified Date is a match and EL Exit Date is null on the import file, the EL Program Status will remain "EL".
  • If the EL Identified Date is a match and the EL Exit Date is provided, the EL Program Stats is updated to "Exited EL" and the EL Exit Date is updated.
  • If the EL Identified Date does not match the student's existing EL record, an error validation is displayed. 

If the student's current EL Program Status = Exited EL   

  • If the EL Identified Date is a match and EL Exit Date does not match the current EL Exit Date, a error validation is displayed.
  • If the EL Identified Date is a match and the EL Exit Date is null on the import, an error validation is displayed.
  • If the EL Identified Date is after the current EL Exit Date and EL Exit Date on the import file is null, a new EL record is created with a Program Status = EL.
  • If the EL Identified Date is after the current EL Exit Date and EL Exit Date on the import file is not null, a new EL record is created with a Program Status = Exited EL.
  • If the EL Identified Date is before or equal to the current EL Exit Date and the Exit Date is null on the import file, an error validation is displayed. 
  • If the EL Identified Date is before or equal to the current EL Exit Date and the Exit Date is not null on the import file, an error message is displayed. 

If the student's current EL Program Status = Not EL or Pending EL

  • If the EL Identified Date is provided, the EL Program Status is updated to EL and the EL Identified Date is updated.
  • If the EL Identified Date and EL Exit Date is provided, the EL Program Status is updated to Exited EL.

If the student's current EL Program Status = Null

  • If the EL Identified Date is provided, the EL Program Status is updated to EL and the EL Identified Date is updated.
  • If the EL Identified Date and EL Exit Date is provided, the EL Program Status is updated to Exited EL and both dates from the file are uploaded.

EL Identified Date

EL Identified Date is required. This date must be less than or equal to the current date.

EL Exit Date

Date must be less than or equal to the current date. The date must also be greater than or equal to the EL Identified Date.

Language of Impact

Required if EL Identified Date is not null. If this does not match the student's current Language of Impact, an error message is displayed.

Primary Home Language

Required if EL Identified Date is not null. If this does not match the student's current Language of Impact, an error message is displayed.

EL Service

EL Service validations for students with no existing EL Services records:

  • If the student does not have an existing EL Service and EL Service Type on the import file = Title III, then:
    • The EL Service Start Date must be greater than or equal to the EL Identified Date and less than or equal to the EL Exit Date.
    • The EL Service End Date must be greater than or equal to the EL Identified Date and EL Service Start Date and End Date are both less than or equal to the EL Exit Date, an error validation is displayed.
    • If the EL Exit Date is provided but the EL Identified Date is null an error validation is displayed.
    • If the EL Service is provided, the EL Service Start Date and EL Identified Date are required and must be less than or equal to the current date and less than or equal to the EL Service End Date.
    • If the EL Service End Date is provided, EL Service and EL Service Start Date are required.
    • If the EL Service End Date is provided, this date must be greater than or equal to the EL Service Start Date. 
    • If the EL Service End Date is provided, EL Program Status must equal EL or Exited EL and EL Service End Date must be less than or equal to EL Exit Date.
    • If the EL Start Date is provided, an EL Service of Title III must be provided.

EL Service validations for students with existing EL Services records:  

  • If the student has an existing EL Service record with a Service Type = Title III, then:
    • If the EL Service Type and EL Service Start Date match and EL Service End Date is null, no action occurs.
    • If the EL Service Type, EL Service Start Date and EL Service End Date are provided, the EL Service End Date is updated if the End Date is null within Campus.
    • If the EL Service Type matches and EL Service Start Date on the import is greater than the EL Service Start Date on the student's existing record, then a EL Service End Date one day less than the EL Service Start Date on the import is added and a new EL Service record is created.
    • If the EL Service Type matches and EL Service Start Date on the import is less than the EL Service Start Date on the student's existing record and no EL Service End Date exists an error validation is displayed.
    • If the EL Service Type matches and EL Service Start Date on the import is less than the EL Service Start Date on the student's existing record and the EL Service End Date is less than the EL Service Start Date on the existing record, a new record is create.
    • If the EL Service Type matches and EL Service Start Date on the import is less than the EL Service Start Date on the student's existing record and EL Service End Date on the import file is greater than the existing EL Service Start Date, an error validation is displayed.
    • If the EL Service Type, EL Service Start Date and EL Service End Date match, no action occurs.
    • If the EL Service Type and EL Service Start Date match and the EL Service End Date on the student's existing EL Services record is not null and the EL Service End Date on the import is null, an error validation is displayed.
    • If the EL Service Type and EL Service Start Date match and the EL Service End Date on the student's existing EL Services record is not null and EL Service End Date on the import is less than or greater than the EL Service End Date on the existing record, an error validation is displayed.
    • The EL Service Start Date must be greater than or equal to the EL Identified Date and less than or equal to the EL Exit Date.
    • If the EL Service End Date is provided, EL Program Status must = EL or Exited EL and the EL Service End Date must be less than or equal to the EL Exit Date.
    • If the EL Service Type matches and EL Service Start Date and End Date on the import file are after the Service End Date on the student's existing record, a new EL Service record is created with Start and End Dates from the import file.
    • If the EL Service Type matches and EL Service Start Date on the import file is less than the EL Service Start Date on the student's existing EL record and EL Service End Date is null on the import and the current record, an error validation is displayed.

EL Service Start Date

Only Service Start Dates which meet all the following requirements are imported:


    • The Service Start Date is on or after the EL Identified Date.
    • The Service Start Date is prior to the EL Exit Date.
    • The Service End Date is null or after the Service Start Date.
    • The reporting service must be Title III.

EL Service End Date

Only Service End Dates which meet all of the following requirements are imported:


    • The EL Service End Date must be greater than or equal to the EL Identified Date and less than or equal to the EL Exit Date.
    • The Service End Date must be greater than or equal to the EL Service Start Date.
    • If Service End Date is not null, EL Program Status must equal EL or Exited EL.