Otherwise, reports null.

1. Qualifying EL record:
   • Identified Date NOT = null and <= extract Reporting Period End Date
   • Program Exit Date = null or >= extract Reporting Period Start Date
   • Parent Declined Date = null or > Identified Date
     • Test Scenarios:
       • When Parent Declined <= Identified Date, LIEPStartDate must report blank
       • When Parent Declined > Identified Date, LIEPStartDate must report when a qualifying Service exists
2. More than 1 qualifying EL record:
   1. Reports the Start Date of the EL Service with the earliest Start Date <= extract Reporting Period End Date from the student's EL record with the EARLIEST Identified Date.
   2. When the qualifying Service has Start Date = null or > extract reporting period End Date, OR when no Service exists in the EARLIEST qualifying EL record with Start Date <= extract Reporting Period End Date, reports blank
3. Only 1 qualifying EL record:
   1. Reports the Start Date of the EL Service with the earliest Start Date <= extract Reporting Period End Date from the student's EL record with the EARLIEST Identified Date.
   2. When the qualifying Service has Start Date = null or > extract reporting period End Date, OR when no Service exists in the EARLIEST qualifying EL record with Start Date <= extract Reporting Period End Date, reports blank

Program Participation > English Learners (EL) > EL > Identified Date

Program Participation > English Learners (EL) > EL > Start Date

Lep.startDate

1. Qualifying EL record:
   • Identified Date NOT = null and <= extract Reporting Period End Date
   • Program Exit Date = null or >= extract Reporting Period Start Date
   • Parent Declined Date = null or > Identified Date
     • Test Scenarios:
       1. When Parent Declined <= Identified Date, LIEPStartDate must report blank
       2. When Parent Declined > Identified Date, LIEPStartDate must report when a qualifying Service exists
2. More than 1 qualifying EL record:
   1. Reports the Start Date of the EL Service with the earliest Start Date <= extract Reporting Period End Date from the student's EL record with the 2nd EARLIEST Identified Date.
   2. When the qualifying Service has Start Date = null or > extract reporting period End Date, OR when no Service exists in the 2nd EARLIEST qualifying EL record with Start Date <= extract Reporting Period End Date, reports blank
3. Only 1 qualifying EL record:
   • Reports blank

Program Participation > English Learners (EL) > EL > Identified Date

Program Participation > English Learners (EL) > EL > Start Date

Lep.startDate

• Identified Date NOT = null and <= extract Reporting Period End Date
• Program Exit Date = null or >= extract Reporting Period Start Date
• Parent Declined Date = null or > Identified Date
  • Test Scenarios:
    1. When Parent Declined <= Identified Date, LIEPEndDate must report blank
    2. When Parent Declined > Identified Date, LIEPEndDate must report when a qualifying Service exists

1. Reports the End Date of the EL Service with the earliest Start Date <= extract Reporting Period End Date from the student's 2nd EARLIEST EL record with the latest Identified Date.
2. When the qualifying Service has End Date = null or > extract reporting period End Date, OR when no Service exists in the 2nd EARLIEST qualifying EL record with Start Date <= extract Reporting Period End Date, reports blank

• Reports blank

Program Participation > English Learners (EL) > EL > Identified Date

Program Participation > English Learners (EL) > EL > End Date

Lep.exitDate

1. Reports the Parent Declined Date from the student's EL record with the EARLIEST Identified Date, where:
   • Parent Declined Date NOT = null and <= extract Reporting Period End Date
   • Identified Date NOT = null and <= extract Reporting Period End Date
   • Program Exit Date = null or >= extract Reporting Period Start Date
2. When no qualifying EL record exists, or when Parent Declined Date is blank or > extract Reporting Period End Date, reports blank

The ELP screener is administered as the final step to determine eligibility for language instruction educational program (LIEP) placement for students in grades K through 12.

• When no EL records have a Screener Date entered that is <= extract Reporting Period End Date, reports the Identified Date of the EL record with the earliest Identified Date where:
  1. Identified Date = not null and <= extract Reporting Period End Date
  2. Program Exit Date = null or >= extract Reporting Period Start Date

Otherwise, reports blank.

Date field, 8 digits (YYYYMMDD)

When "Use Enrollment Programs"  is checked, reports Y. Otherwise, N.

• The student has a Gifted & Talented program record with:
  • Start Date <= extract Reporting Period End Date
  • Start Date <= the earlier of:
    • Enrollment End Date when not = null
      AND
    • The last instructional calendar day in the calendar when enrollment End Date = null
  • End Date = null or >= earlier of:
    • Enrollment End Date when not = null, otherwise last instructional calendar day
      AND
    • The extract Reporting Period End Date

1 = Fulltime on premises

2 = Hybrid (partial in person on premises/partial remote instruction)

3 = Fulltime remote—district choice

4 = Fulltime remote—parental or guardian choice

Reports the number of remote (virtual) instruction days a student is marked as present during the annual reporting period from July 1 through June 30.

1. No Half Day Logic. If Absent Minutes < (Less Than) Full Days Absent Minutes in Calendar Setting then Day is Marked as Present. 
2. Don't Count if State Code = 3, 4, 6, 8, or 9 (State Excused Absences DE#91)
3. If Enrollment Type = S (DE#19)
   1. Each day of membership counts as a half or .5
   2. Example 175 Present Days would be reported as 87.5

Numeric, up to 5 characters

Reports the number of remote (virtual) instruction days a student is marked as absent and scheduled to receive instruction in a remote learning environment during the annual reporting period from July 1 through June 30.

1. No Half Day Logic. If Absent Minutes =>(Greater Then or Equal To) Full Days Absent Minutes in Calendar Setting then Day is Marked as Absent.
2. Status = Absent
3. Excuse = Unknown, Excused, or Unexcused
4. Don't Count if State Code = 3, 4, 6, 8, or 9 (State Excused Absences DE#91)
5. These Days Should be subtracted from Number of Days Present
6. If there is an Absent Day with State Code = 5 (Half Day Absence) Then count that day as a Full Day Present.
7. If Enrollment Type = S (DE#19)
   1. Each day of membership counts as a half or .5
   2. Example 5 Absent Days would be reported as 2.5

Numeric, up to 5 characters

• 1 = Personal, dedicated device (student is the sole user)
• 2 = Personal device, shared with others
• 3 = School or district-provided, dedicated device (student is the sole user)
• 4 = School or district-provided device, shared with others
• 5 = Other
• 6 = Unknown
• 7 = None

Reports the Code selected in the Bridge Year field when the enrollment grade is mapped to a State Grade Level Code of 12.

Reports blank when the enrollment grade is not mapped to a State Grade Level Code of 12.

Alphanumeric, 1 character

Indicates whether a student has met the federal requirement to take Algebra I (or one of the exceptions noted below) while in high school.

Reports the selected code (A -G) from the student's enrollment record. When not populated, a blank value reports.

The name of the city in which the student lives.  

If there is more than one primary city of residence, the most current city by start date reports. Any secondary city of residence does not report.

Alphanumeric, 30 characters

Census > Address > City

Address.city

Indicates if the student is eligible for migrant education services.

1. Reports "Y" when the student has a Migrant program record with:
   • Start Date <= extract Reporting Period End Date
   • Start Date <= the earlier of:
     • Enrollment End Date when not = null
       AND
     • The last instructional calendar day in the calendar when enrollment End Date = null
   • End Date = null or >= earlier of:
     • Enrollment End Date when not = null, otherwise last instructional calendar day
       AND
     • The extract Reporting Period End Date

Alphanumeric, 1 character (Y or N)

Enrollments > State Reporting Fields > Migrant

Enrollment.migrant

Indicates whether the student has met the eighth-grade criteria of technological proficiency.

• 8th grade students report either the default or selected value for the 8 Tech Literacy
• All other grades should be reported as Blank value.

• Y = Deemed to be technologically proficient
• N = Deemed to not be technologically proficient
• NE = Not evaluated

Alphanumeric, 2 characters

Enrollments > State Reporting Fields > 8 Tech Literacy

EnrollmentNJ.8TechLiteracy

Indicates whether the student has health insurance coverage.

Alpha, 1 character (Y or N)

Enrollments > State Reporting Fields > Health Coverage

EnrollmentNJ.healthCoverage

The name of the student's health insurance provider.

Alphanumeric, 50 characters

Enrollments > State Reporting Fields > Health Insurance Provider

EnrollmentNJ.healthInsurance Provider

The primary language or dialect that students use to communicate at home.

Alphanumeric, 3 characters

Identities > Home Primary Language

Identity.homePrimaryLanguage

Must be submitted once for all students. Additional data only needs to be submitted if the student has been identified as speaking more than one Home Language as reported on the Home Language Survey. However, the data elements must still be repeated 5 times in the file.

(HomeLanguage1, HomeLanguage2, HomeLanguage3, HomeLanguage4, HomeLanguage5) even if the additional four iterations are not needed.

When null, reports blank

Selection indicates student meets the Federal definition of being an immigrant:

• aged 3-21
• not born in any state
• have not been attending one or more schools in any one or more States for over three full academic years.

• Null
• N: No
• Y: YES

Alphanumeric, 1 character

Enrollments > State Reporting Fields > Immigrant

Enrollment.immigrant

Date the student first received schooling at a school in the United States.

Reports the date associated with the student's Date Entered US School if the student's Birth Country is any selection other than 2330: United States or 1790: Puerto Rico.

Reports a blank value if the Birth Country is the United States or Puerto Rico.

Date field, 8 characters (YYYYMMDD)

Demographics > Date Entered US School

Census > Person Information > Birth Country

Identity.dateEnteredSchool

An indication that the student lacks a fixed, regular, and adequate residence.

• Reports Y1 when Unaccompanied Youth = No.
• Reports Y2 when Unaccompanied Youth = Yes.
• Homeless record must be NOT null anytime during the Reporting Period Start and End Dates.
• Reports from the Homeless tab record with the latest Start Date that was active on or between the extract editor dates.

Alphanumeric, 2 characters

Program Participation > Homeless

Homeless.unaccompaniedYouth

Indication of the nighttime residence of homeless students.

• 1 = Shelters Transitional Housing
• 2 = Doubled-Up.
• 3 = Unsheltered.
• 4 = Hotels or Motels

Alphanumeric, 1 character

Program Participation > Homeless > Primary Night Time Residence

Homeless.primaryNightTimeResdence

Indication of whether a homeless student is receiving or not receiving instructional services under 42 U.S.C. §11432(a).

Y = Yes, the student receives instructional services. See Additional Notes for a list of services.

N = No, the student does not receive instructional services

• Start Date <= extract End Date and End Date of null or >= extract Start Date
• Instructional Services = Y

Otherwise, reports 'N'

Indication of whether or not a homeless student is receiving support services under 42 U.S.C. §11432(a).

Y = Yes, the student receives support services. See Additional Notes for a list of services.

N = No, the student does not receive support services.

• Start Date <= extract End Date and End Date of null or >= extract Start Date
• Support Services = Y

Otherwise, reports 'N'

Alphanumeric, 1 character (Y or N)

Indication that the student is enrolled in an alternative education program.

• If Alternative Program check box is selected, then report a Y value. Else report an N value

• Reports "Y" when the student has an Alternative Program record with:
  • Start Date <= extract Reporting Period End Date
  • Start Date <= the earlier of:
    1. Enrollment End Date when not = null
       AND
    2. The last instructional calendar day in the calendar when enrollment End Date = null
  • End Date = null or >= earlier of:
    1. Enrollment End Date when not = null, otherwise last instructional calendar day
       AND
    2. The extract Reporting Period End Date

Alphanumeric, 1 character (Y or N)

Enrollments > State Reporting Fields > State Reporting Fields > Alternative Program

Enrollment.atlProgram

Indication that the student is participating in and being served by programs under Title I, Part A of ESEA as amended.

• Reports 01 when:
  1. School > Title 1 = Targeted Assistance Program or is blank
     AND
  2. Any Title 1 checkbox on the student's enrollment = checked:
     • Title 1 Language Arts
     • Title 1 Math
     • Title 1 Science
     • Title 1 Spanish Math
     • Title 1 Biology
• Reports 02 when:
  • School > Title 1 Schoolwide Program
• Reports 05 when:
  • School > Title 1 = Targeted Assistance Eligible - No Program
    OR
  • School > Title 1 = Schoolwide Eligible - No Program
    OR
  • School > Title 1 = Not a Title I School
    OR
    When Blank, and the student's enrollment doesn't have any Title 1 checkboxes = checked:
    • Title 1 Language Arts
    • Title 1 Math
    • Title 1 Science
    • Title 1 Spanish Math
    • Title 1 Biology
  • Else, reports 05.
• When "Use Enrollment Programs" is NOT checked:
  
  • Reports 01 when:
    1. School > Title 1 = Targeted Assistance Program or is blank
       AND
    2. The student has a Title 1 program record with:
       • Start Date <= extract Reporting Period End Date
       • Start Date <= the earlier of:
         • Enrollment End Date when not = null
           AND
         • The last instructional calendar day in the calendar when enrollment End Date = null
       • End Date = null or >= earlier of:
         • Enrollment End Date when not = null, otherwise last instructional calendar day
           AND
         • The extract Reporting Period End Date
  • Reports 02 when:
    1. School > Title 1 Schoolwide Program
  • Reports 05 when:
    1. School > Title 1 = Targeted Assistance Eligible - No Program
       OR
    2. School > Title 1 = Schoolwide Eligible - No Program
       OR
    3. School > Title 1 = Not a Title I School
       OR
       When Blank, and the student does not have a qualifying Title 1 program record, where:
       1. The student has a Title 1 program record with:
          1. Start Date <= extract Reporting Period End Date
          2. Start Date <= the earlier of:
             1. Enrollment End Date when not = null
                AND
             2. The last instructional calendar day in the calendar when enrollment End Date = null
          3. End Date = null or >= earlier of:
             1. Enrollment End Date when not = null, otherwise last instructional calendar day
                AND
             2. The extract Reporting Period End Date
  • Else, reports 05.

Alphanumeric, 2 characters

School Information > School History > Title I

Enrollments > State Reporting Fields > Title 1 (multiple fields)

• If Enrollment End Date >= Report Editor End Date

• If Enrollment End Date < Report Editor End Date

Alphanumeric, 1 character (A or I)

Enrollments > General Enrollment Editor > End Date

Enrollment.endDate

Enrollments > General Enrollment Editor > Local Start Status

Enrollment.localStartStatus

1. No Half Day Logic. If Absent Minutes < (Less Than) Full Days Absent Minutes in Calendar Setting then Day is Marked as Present.
2. Base logic is Days Open then Subtracting Out Absent Days
3. Don't Count if State Code = 3, 4, 6, 8, 9, 10 or 11 (State Excused Absences DE#91)
4. If Enrollment Type = S (DE#19)
   • Each day of membership counts as a half or .5
   • Example 175 Present Days would be reported as 87.5

1. No Half Day Logic. If Absent Minutes =>(Greater Then or Equal To) Full Days Absent Minutes in Calendar Setting then Day is Marked as Absent.
2. Status = Absent
3. Excuse = Unknown, Excused, or Unexcused
4. Don't Count if State Code = 3, 4, 6, 8, 9, 10, or 11 (State Excused Absences DE#91)
5. These Days Should be subtracted from Number of Days Present
6. If there is an Absent Day with State Code = 5 (Half Day Absence) Then count that day as a Full Day Present.
7. If Enrollment Type = S
   1. Each day of membership counts as a half or .5
   2. Example 5 Absent Days would be reported as 2.5

1. Status = Absent
2. Excuse = Exempt
3. State Code = 3, 4, 6, 8, 9, 10 or 11.
4. These days Do Not Add or Subtract from Number of Days Present or Days Absent

The student must be enrolled in a non-excluded enrollment with a preschool state grade level of 3H, 3F, 4H, 4F, 5H, or 5F.

Alphanumeric, 1 character (Y or N)

1. In the extract editor Start and End Date range, the student has a non-excluded enrollment with a state grade level of 3H, 3F, 4H, 4F, 5H, or 5F
2. During the qualifying enrollment in the extract editor date range, the Special Ed > General > State Reporting tab record has a Start Date <= extract End Date, and End Date of null or >= extract Start Date, in the record with the latest Start Date, where::
   • Deaf or Hard of Hearing = Checked
   • Language Acquisition is not null