ISAT Student Extract (Idaho)

 PATH  :  ID State Reporting > ISAT Student Extract 

The ISAT Student Extract is use to collect student enrollment information and report it to the state.

 
 Image 1: ID State Reporting > ISAT Student Extract 

Report Logic

A record reports for each student enrollment active on the Snapshot Date entered. Students must have a Student State ID to report. Enrollments marked as State Exclude or No Show or in a grade level or calendar marked as State Exclude are not reported.

Results are sorted by Student State ID, then by State School Number

Generating the Extract

  1. Enter a Snapshot Date in mmddyyyy format or by clicking the calendar icon and selecting a date.
  2. Determine which students to include in the extract by selecting a Grade or Ad hoc Filter.
  3. Enter a File Identifier to distinguish the extract. The extract is identified by concatenating this value with the date and timestamp when the report was generated.
  4. Select a Format to generate the extract. Use HTML for data review and verification and State Format (CSV)
  5. Select a Calendar from the list. More than one can be selected.
  6. Click Generate Extract to generate the report in the indicated format or Submit to Batch to schedule when the report will generate.

Users have the option of submitting a report request to the batch queue by clicking Submit to Batch instead of Generate Extract. This 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

Element Name

Description & Format

Campus Location

District ID

State assigned district number.


Numeric, 3 digits

System Administration > Resources> District Information


District.number

School ID

The unique number assigned to identify the school.


Numeric, 4 digits

System Administration > Resources > School


School.number

Last or Surname

The student's legal last name.


Alphanumeric, 20 digits

Census > People > Demographics > Person Information > Last Name


Identity.lastName

First Name

The student's legal first name.


Alphanumeric, 20 digits

Census > People > Demographics > Person Information > First Name


Identity.firstName

Middle Name

The student's legal middle name.


Alphanumeric, 20 digits

Census > People > Demographics > Person Information > Middle Name


Identity.middleName

Birth Date

The student's date of birth.


Date field, 10, MM/DD/CCYY

Census > People > Demographics > Person Information > Birth Date


Identity.birthDate

EDUID

The unique ID assigned to the student by the state.


Numeric, 9 digits

Census > People > Demographics > Person Identifies > Student State ID


Person.stateID

Grade Level When Assessed

The State Grade Level Code mapped to the grade in which the student is enrolled.


Alphanumeric, 2 characters

Calendar > Calendar > Grade Levels > State Grade Level


GradeLevel.StateCode

Gender

The student's gender.


Alphanumeric, 1 character

Census > People > Demographics > Person Information > Gender


Identity.gender

Hispanic or Latino Ethnicity

Indicates whether the student is Hispanic or Latino.


Y or N

Census > People > Demographics > Person Information > Race/Ethnicity > Hispanic/Latino


Identity.hispanicEthnicity

American Indian or Alaska Native

Indicates whether the student is American Indian or Alaska Native in Y/N format.


Y or N

Census > People > Demographics > Person Information > Race/Ethnicity > American Indian or Alaska Native


Identity.raceEthnicity

Asian

Indicates whether the student is Asian.


Y or N

Census > People > Demographics > Person Information > Race/Ethnicity > Asian


Identity.raceEthnicity

Black or African American

Indicates whether the student is Black or African American.


Y or N

Census > People > Demographics > Person Information > Race/Ethnicity > Black or African American


Identity.raceEthnicity

White

Indicates whether the student is White.


Y or N

Census > People > Demographics > Person Information > Race/Ethnicity > White


Identity.raceEthnicity

Native Hawaiian or Other Pacific Islander

Indicates whether the student is Native Hawaiian or Other Pacific Islander.


Y or N

Census > People > Demographics > Person Information > Race/Ethnicity > Native Hawaiian or Other Pacific Islander


Identity.raceEthnicity

Section 504 StatusIndicates if Section 504 is marked on the student's active Identity.

Y or N
Student Information > General > Enrollments > State Reporting Fields > Section 504

Enrollment.section504
Special Education StatusIndicates if the student has an active ID State Reporting Data Entry Plan with a Special Ed Status of SE: Special Education.

Y or N
Student Information > Special Ed > General > Documents

PlanState.specialEdStatus
Alt AssessmentIndicates if the student has an active Test Accommodations record as of the Snapshot Date that includes at least one assessment with a State Code of ISAT and has Alt Assessment marked.

Y or N
Student Information > General > Test Accommodations

TestAccommodations.altAssessment

TestAcoomodations.startDate

TestAccommodations.endDate


Primary Disability TypeReports the Primary Disability code selected on the student's active ID State Reporting Data Entry Plan with a Special Ed Status of SE: Special Education. Alt Assessment must report as Y to report.

Alphanumeric, 3 characters
Student Information > Special Ed > General > Documents

PlanState.disability1
LEP StatusReports as Yes if a value is reported in the LEP Category field.

Y or N
N/A
LEP Category

Reports the derived EL code if the student has an active English Learners (EL) program participation record as of the Snapshot Date.

See the following LEP/EL (English Learners) Status Options table for values and logic.

Alphanumeric, 2 characters
Student Information > Program Participation > LEP > Program Status

Calculated
Economic Disadvantage StatusIndicates if the student has an active FRAM Eligibility of Free or Reduced as of the Snapshot Date.

Y or N
FRAM > Eligibility > Eligibility

FRAMEligibility.eligibility
Migrant StatusIndicates if the student has an active Migrant program participation record as of the Snapshot Date with an MSIX ID entered.

Y or N
Student Information > Program Participation > Migrant

Migrant.lastQualifiyingArrivalDate

Migrant.lastQualifyingMoveDate


Paper TesterIndicates if the student has an active Test Accommodations record as of the Snapshot Date that includes at least one assessment with a State Code of ISAT a Test Format of P: Paper Tester selected.

Y or N
Student Information > General > Test Accommodations > Test Format

TestAccommodations.testFormat
Delete StudentReports as blank. N/A

LEP/EL (English Learners) Status Options

Code

Description

Logic

EW

Waived ELL

Reports if an active EL record with a Program Status of EL has the Parent Declined checkbox marked OR all EL Services active during the extract Date Range have Parent Refused Services marked and all Date Refused dates are before the extract End Date.

FL

Former LEP Student - Now Fluent

Reports if the most recent EL record has a Program Status of Exited EL and the extract End date is after the Fourth Year Monitoring date.

L1

LEP1 - In the first year of U.S. school

Reports if Program Status is EL and Identified Date and First Entered US School are 1 year or less from the extract End Date.

LE

LEP - Limited English Proficient

Reports if Program Status is EL (English Learners), the most recent EL record is active at some point during the extract Date Range and Identified Date and Date Entered US School are more than a year from the extract End Date. Also reports if Identified Date is 1 year or less from the extract End Date and Date Entered US Schools is blank.

LEExited LEPReports if the most recent EL record has a Program Status of Exited EL and the extract End Date falls before the Exited EL Date and on or after the Identified Date.

N

Not LEP

Reports if the student does not have an EL record or the most recent/active EL record has a Program Status of Not EL or Pending.

SONot LEPReports if the most recent EL record has a Program Status of Not EL and a Screened Out date has been entered. 

X1

LEPX1 - Exited first year

Reports if most recent EL record has a Program Status of Exited EL and First Year Monitoring contains a date on or between the Program Exit Date and the extract End Date.

X2

LEPX2 - Exited second year

Reports if most recent EL record has a Program Status of Exited EL and the extract End Date is after First Year Monitoring but on or before the Second Year Monitoring date.

X3LEPX3 - Exited Third Year

Reports if most recent EL record has a Program Status of Exited EL and the extract End Date is after Second Year Monitoring but on or before the Third Year Monitoring date.

X4LEPX4 - Exited Fourth Year

Reports if most recent EL record has a Program Status of Exited EL and the extract End Date is after Third Year Monitoring but on or before the Fourth Year Monitoring date.