DLM-AA Pre-ID

Registration > Entry & Reports > Student Demographic > Personal > Legal/Birth Information panel: Last Name field

Registration > Entry & Reports > Student Demographic > Registration > Student panel: Last Name field

Registration > Entry & Reports > Student Demographic > Personal > Legal/Birth Information panel: First Name field

Registration > Entry & Reports > Student Demographic > Registration > Student panel: First Name field

reg_building.state_code_equiv for reg_programs.program_value where program_id = reg_program_column.program_id for state_code_equiv = H_RCDTS

Or,

reg_building.state_code_equiv for reg.alt_building

Or,

reg_building.state_code_equiv for reg_entry_with.building

The download goes through these steps:

1. It checks to see if the student has an active program vector as of the Reporting Date for Home School RCDTS Override (Registration > Entry & Reports > Student Demographic > Programs > click link for RCDTS - RCDTS Overrides).
2. If there is no active vector for this program, the download checks whether the student has an active Alternate Building program vector (Registration > Entry & Reports > Student Demographic > Registration > Other Enrollment panel: Alternate Building field).
3. If there is also no Alternate Building, use the student’s Entry/Withdrawal Building (Registration > Entry & Reports > Student Demographic > Entry/Withdrawal: Building).

reg_building.state_code_equiv for reg_programs.program_value where program_id = reg_program_column.program_id for state_code_equiv = S_RCDTS

Or,

reg_building.state_code_equiv for reg_entry_with.building

The download goes through these steps:

1. It checks to see if the student has an active program vector as of the Reporting Date for Serving School RCDTS Override (Registration > Entry & Reports > Student Demographic > Programs > click link for RCDTS - RCDTS Overrides).
2. If there is no active vector for this program, use the student’s Entry/Withdrawal Building (Registration > Entry & Reports > Student Demographic > Entry/Withdrawal: Building).

reg_building.state_code_equiv for reg_programs.program_value where program_id = reg_program_column.program_id for state_code_equiv = T_RCDTS

Or,

reg_building.state_code_equiv for reg_user.field_value where screen_number = 905 and field_number = 1

Or,

reg_building.state_code_equiv for reg_entry_with.building

The download goes through these steps:

1. It checks to see if the student has an active program vector as of the Reporting Date for Testing School RCDTS Override (Registration > Entry & Reports > Student Demographic > Programs > click link for RCDTS - RCDTS Overrides).
2. If there is no active vector for this program, the download checks whether the student has a Testing School value on Registration > Entry & Reports > Student District Defined > ISBE Pre-ID.
3. If there is also no Testing School value, use the student's Entry/Withdrawal Building (Registration > Entry & Reports > Student Demographic > Entry/Withdrawal: Building).

Registration > Entry & Reports > Student District Defined > IL ELL and ELL Screener: ESOL Participation field

For the reference table, refer to Administration > General Setup > District > Validation Tables > for Applications prompt, select Illinois State Reporting > for Validation Table prompt, select ESOL Participation

Based on reg_user.field_value where screen_number = 905 and field_number = 7.  If the field_value is either 01 for Yes or 02 for No, use that value as an override.

If the field_value = E, calculate based on the building and dates from the student's reg_entry_with records. See if the student's Entry/Withdrawal dates for the reported Home School cover all membership days from the Reporting Date back to 05/01 of the previous school year.

If the student is enrolled in the Home School for all these membership days, report 01 for Yes. Otherwise, report 02 for No.

If the student has no value in field 7, use the default value of 01.

Based on reg_user.field_value where screen_number = 905 and field_number = 8.  If the field_value is either 01 for Yes or 02 for No, use that value as an override.

If the field_value = E, calculate based on the building and dates from the student's reg_entry_with records. See if the student's Entry/Withdrawal dates for the reported Home School cover all membership days from the Reporting Date back to 05/01 of the previous school year.

If the student is enrolled in the Home School for all these membership days, report 01 for Yes. Otherwise, report 02 for No.

If the field_value = R, calculate based on reg.dist_enroll_date.  If this date is on or before 05/01 of the previous school year, report 01 for Yes. Otherwise, report 02 for No.

If the student has no value in field 7, use the default value of 01.

Set this field to 01 for Yes if the student meets these criteria:

The student has reg_programs.program_value = Y as of the prompted Reporting Date for the program_id mapping to reg_program_column.state_code_equiv = ILELL

The student's reg.us_enroll_date is within twelve months of the Reporting Date.

If the student does not meet both criteria, use 02 for No.