EL WIDA Student Pre-ID Extract (Hawaii)

Classic View: HI State Reporting > EL WIDA Student Pre-ID Extract

Search Terms: EL WIDA

EL WIDA Student Pre-ID Extract is used to load students into WIDA AMS. In some cases, the Pre-ID file upload is used to place the initial order of ACCESS for ELLs testing materials for the state.

Report Logic

  • Student must be in grade KG-12 and 31
  • Student must be actively enrolled on the Effective Date of report generation
    • EL Student Status = J
    • EL Student Status = K
    • EL Student Status = L
    • EL Student Status = M AND Action Code = 06 AND student has a failing grade in a core subject
  • To report, Accommodations must be active as of the report generation date.

Report Editor

FieldDescription
Effective DateThe date for which information reports.
Accommodation RangeThe start and end date that comprises the date range. Accommodations within the date range will report.
FormatThe Format in which the report should generate. Options are CSV and HTML.
Ad Hoc Filter

Selecting a filter limits the results to only those included in the filter.

Choose GradesIdentifies the grade levels to include in the report.
Select CalendarsIdentifies which Calendar(s) should be included in the report. Calendars can be sorted by active year, by school or by year.

Generate Extract/

Submit to Batch


Users have the option of submitting a report request to the batch queue by clicking Submit to Batch instead of immediately generating the report by clicking Generate Extract. The batch process allows larger reports to generate in the background without disrupting the use of Campus. For more information about submitting a report to the batch queue, see the Batch Queue article.

Report Layout

FieldDescription
Effective DateThe date for which information reports.
FormatThe Format in which the report should generate. Options are CSV and HTML.
Ad Hoc Filter

Selecting a filter limits the results to only those included in the filter.

Choose GradesIdentifies the grade levels to include in the report.
Select CalendarsIdentifies which Calendar(s) should be included in the report. Calendars can be sorted by active year, by school or by year.

Generate Extract/

Submit to Batch


Users have the option of submitting a report request to the batch queue by clicking Submit to Batch instead of immediately generating the report by clicking Generate Extract. The batch process allows larger reports to generate in the background without disrupting the use of Campus. For more information about submitting a report to the batch queue, see the Batch Queue article.

Report Layout

#FieldDescriptionLocation
1StateNameAbbreviationReports HI.N/A
2DistrictNameThe district name.System Administration > Resources > District Information > District Name
District.name
3DistrictNumberThe district number.System Administration > Resources > District Information > State District Number
District.number
4SchoolNameThe name of the school.System Administration > Resources > School > School Name
School.name
5SchoolNumberThe school number for the school included in the report.System Administration > Resources > State School Number
School.number
6StudentLastNameThe student's last name.Census > People > Identity > Last Name
identity.lastname
7StudentFirstNameThe student's first name.Census > People > Identity > First Name
identity.firstname
8StudentMiddleNameThe student's middle name.Census > People > Identity > Middle Name
identity.middlename
9BirthDateThe student's birthday.Census > People > Identity > Birth Date
identity.birthdate
10GenderThe student's gender.Census > People > Identity > Gender
identity.gender
11StateStudentIDThe student's state identification number.Census > People > Demographics > Student State ID
Identity.stateID
12DistrictStudentIDThe student's local ID.Census > People > Demographics > Local Student Number
Person.studentnumber
13GradeThe student's grade level.Student Information > General > Enrollment > Grade Level
Enrollment.grade
14HispanicEthnicityReports Y if the student's Federal Race is 1:Hispanic/Latino. Otherwise, N reports.Census > People > Demographics > Identity > Federal Race
Identity.hispanicEthnicity
15AmericanIndianAlaskanNativeReports Y if the student's Federal Race is 2:American Indian or Alaska Native. Otherwise, this field reports blank.Census > People > Demographics > Identity > Federal Race
Identity.raceEthnicityFED
16AsianReports Y if the student's Federal Race is 3:Asian. Otherwise, this field reports blank.Census > People > Demographics > Identity > Federal Race
Identity.raceEthnicityFED
17AfricanAmericanReports Y if the student's Federal Race is 4: Black or African American. Otherwise, this field reports blank.Census > People > Demographics > Identity > Federal Race
Identity.raceEthnicityFED
18PacificIslanderHawaiianReports Y if the student's Federal Race is 5:Native Hawaiian or Other Pacific Islander. Otherwise, this field reports blank.Census > People > Demographics > Identity > Federal Race
Identity.raceEthnicityFED
19WhiteReports Y if the student's Federal Race is L : White. Otherwise, this field reports blank.Census > People > Demographics > Identity > Federal Race
Identity.raceEthnicityFED
20NativeLanguageThe first language the student speaks.Census > People > Demographics > First Language
Identity.homePrimaryLanguage
21DateFirstEnrolledUSSchoolThe date on which the student enrolled in a US School.Census > People > Demographics > Date Entered US School
Identity.dateEnteredUSSchool
22LengthofTimeinLEPELLProgramThe length of time the student was in an LEP ELL program. This value is calculated from the Identified date to the Effective date of report generation.EL > Identified Date
23TitleIIIStatusReports Y for all students in a school where School History > Title III is marked. Otherwise, this field reports blank.School History > Title III
24MigrantReports blank.N/A
25IEPStatusReports blank.N/A
26Plan504Reports blank.N/A
27PrimaryDisabilityReports blank.N/A
28SecondaryDisabilityReports blank.N/A
29LIEPClassificationReports when the EL State Service end date is blank, on, or after the report generation Effective Date.
Reports When State Service Code is...
EEOESL, NP, LT, CB
MEOSI
ETITB
EBLOW-DL
MBLTW-DL
NSPnull

EL Services > State Code
30LIEPParentalRefusalThis field reports Y if the Parent Declined checkbox is marked. Otherwise, this field reports blank.EL > Parent Declined
31LIEPOptionalDataReports blank.N/A
32MCAccommodationReports Y when  the student's EL Accommodations tab has an Accommodation Type = MC. Otherwise, this field reports blank.Reports Y when  the student's EL Accommodations tab has an Accommodation Type = . Otherwise, this field reports blank.
33RAAccommodationReports Y when  the student's EL Accommodations tab has an Accommodation Type = RA. Otherwise, this field reports blank.EL > EL Accommodations > Accommodation Type's State Accommodation Type
34ESAccommodationReports Y when  the student's EL Accommodations tab has an Accommodation Type = ES. Otherwise, this field reports blank.EL > EL Accommodations > Accommodation Type's State Accommodation Type
35LPAccommodationReports Y when  the student's EL Accommodations tab has an Accommodation Type = LP. Otherwise, this field reports blank.EL > EL Accommodations > Accommodation Type's State Accommodation Type
36BRAccommodationReports C when  the student's EL Accommodations tab has an Accommodation Type = BR. Otherwise, this field reports blank.EL > EL Accommodations > Accommodation Type's State Accommodation Type
37SDAccommodationReports Y when  the student's SD Accommodations tab has an Accommodation Type = SD. Otherwise, this field reports blank.EL > EL Accommodations > Accommodation Type's State Accommodation Type
38HRAccommodationReports Y when  the student's EL Accommodations tab has an Accommodation Type = HR. Otherwise, this field reports blank.EL > EL Accommodations > Accommodation Type's State Accommodation Type
39RRAccommodationReports Y when  the student's EL Accommodations tab has an Accommodation Type = RR. Otherwise, this field reports blank.EL > EL Accommodations > Accommodation Type's State Accommodation Type
40HIAccommodationReports Y when  the student's EL Accommodations tab has an Accommodation Type = HI. Otherwise, this field reports blank.EL > EL Accommodations > Accommodation Type's State Accommodation Type
41RIAccommodationReports Y when  the student's EL Accommodations tab has an Accommodation Type = RI. Otherwise, this field reports blank.EL > EL Accommodations > Accommodation Type's State Accommodation Type
42SRAccommodationReports Y when  the student's EL Accommodations tab has an Accommodation Type = SR. Otherwise, this field reports blank.EL > EL Accommodations > Accommodation Type's State Accommodation Type
43WDAccommodationReports Y when  the student's EL Accommodations tab has an Accommodation Type = WD. Otherwise, this field reports blank.EL > EL Accommodations > Accommodation Type's State Accommodation Type
44RDAccommodationReports Y when  the student's EL Accommodations tab has an Accommodation Type = RD. Otherwise, this field reports blank.EL > EL Accommodations > Accommodation Type's State Accommodation Type
45NSAccommodationReports Y when  the student's EL Accommodations tab has an Accommodation Type = NS. Otherwise, this field reports blank.EL > EL Accommodations > Accommodation Type's State Accommodation Type
46ETAccommodationReports Y when  the student's EL Accommodations tab has an Accommodation Type = ET. Otherwise, this field reports blank.EL > EL Accommodations > Accommodation Type's State Accommodation Type
47EMAccommodationReports Y when  the student's EL Accommodations tab has an Accommodation Type = EM. Otherwise, this field reports blank.EL > EL Accommodations > Accommodation Type's State Accommodation Type
48StateDefinedOptionalDataReports blank.N/A
49DistrictDefinedOptionalDataReports blank.N/A
50ModeofAdministrationReports blank.N/A
51PaperTierReports blank.N/A
52AlternateACCESSforELLsTesterReports Y when the student has a State Accommodation = AA and when the end date is blank or on or after the report generation Effective Date.EL > EL Accommodations > Accommodation Type's State Accommodation Type
53StudentTypeReports blank.N/A
54AdditionalFieldReports blank.N/A