Tool Search: ID State Reporting > ISEE Extracts
The Student Demographics Extract is used to report demographic data on a student level for students enrolled in the district during the selected date range. If a student has multiple primary enrollments on a given date during the date range, a record reports for each enrollment. This extract reports for all calendars chosen in the extract editor unless they are marked as State Exclude.
ISEE Extracts - Student Demographics
Student Demographics Extract Logic
- Only students in a State Grade Level of NG, EC, PK, KG, or 01-12 report.
- Enrollments with Service Type: N do not report.
- Students marked as State Exclude, in a grade level marked as State Exclude, or in a Calendar marked as State Exclude do not report. No Show enrollments are also not reported.
- A record reports for each student actively enrolled at least one day during the extract Date Range. Each student reports one record per School of Primary Responsibility even if the School of Primary Responsibility's calendar is not selected in the extract editor, as long as the student has an active enrollment in at least one selected calendar.
- If "Exclude PK" is marked on the extract editor, students enrolled in grade PK will not report.
- Demographic data reports based on the student's Identity record that is active on the extract End Date.
- Records are reported for each entry/exit into a calendar flagged as JDC Attendance when selected in the extract editor.
School of Primary Responsibility
The School of Primary Responsibility is the school that receives funding for a student, compared to other schools where the student may have partial enrollments. To determine the student's School of Primary Responsibility, all primary enrollments active at the same time are considered.
- If only one enrollment is flagged as Primary on a given date, that enrollment identifies the School of Primary Responsibility.
- If more than one enrollment is flagged as Primary on a given date, the School of Primary Responsibility whose calendar has the highest calendarID.
- If the student has no primary enrollments on a given date, the School of Primary Responsibility is the one of the secondary enrollment whose calendar has the highest calendarID.
- Enrollments in a calendar marked as JDC Attendance are not considered when determining a student's School of Primary Responsibility.
Day records report the same derived calendarID value as long as their School of Primary Responsibility enrollment remains active. A new value reports if the student's enrollment transitions. If a dual-enrolled student has an attendance record on a day when their School of Primary Responsibility is closed (reporting isntructionTime as 0.0 in the District Calendar extract), a record does not report for that day in this extract.
Extract Field | Attribute/Dictionary Path |
|---|---|
maxPeriod | System Administration > Custom > Attribute/Dictionary > Enrollment > Max Allowable Periods |
maxCredit | System Administration > Custom > Attribute/Dictionary > Enrollment > Max Allowable Credits |
Report Editor Field Descriptions
Field | Description |
|---|---|
Report Type | Select Student Demographics. The following ISEE extract types are also available: |
Start Date | The earliest date from which data is pulled for the report. (Required) |
End Date | The latest date from which data is pulled for the report. (Required) |
Exclude PK | This checkbox indicates that students with a State Grade Level of PK should not be included in the report. |
Ad Hoc Filter | This field allows users to use an Ad hoc filter that was created in the Ad hoc Filter Designer. Only one Ad hoc filter may be selected. |
Format | The format in which the report will generate. Options include CSV and HTML. |
Select Calendars | The calendar(s) from which data is pulled for the report. Can be set to display only the active year's calendars, or be sorted by school or by year. |
Batch Queue | Users have the option of submitting a District Calendar report request to the batch queue by clicking Submit to Batch instead of Generate Extract. This process will allow 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. |
Student Demographics Extract Layout
Column | Description & Format | Campus Location |
|---|---|---|
idStuId | The student's unique Idaho Student Identification Number. Numeric, 9 digits | Census > People > Demographics > Person Identifiers > Student State ID Person.stateID |
lastName | The student's last name. Reports the Legal Last Name if entered. Alphanumeric, 35 characters | Census > People > Demographics > Person Information > Last Name Identity.lastName |
firstName | The student's first name. Reports the Legal First Name if entered. Alphanumeric, 35 characters | Census > People > Demographics > Person Information > First Name Identity.firstName |
middleName | The student's middle name or initial. Reports the Legal Middle Name if entered. Alphanumeric, 40 characters | Census > People > Demographics > Person Information > Middle Name Identity.middleName |
suffix | The students name suffix; e.g., Jr., Sr., III. Alphanumeric, 8 characters | Census > Demographics > Person Information > Suffix Identity.suffix |
birthDate | The student's date of birth. Date Field, 10 digits in MM/DD/YYYY | Census > People > Demographics > Person Information > Birth Date Identity.birthDate |
gender | The student's gender, either male or female. Reports Legal Gender if entered. Alphanumeric, 1 character | Census > People > Demographics > Person Information > Gender Identity.gender |
hispanic | Indicates whether the student is Hispanic or Latino in Y/N format. Alphanumeric, 1 character | Census > People > Demographics > Person Information > Race/Ethnicity > Hispanic/Latino Identity.hispanicEthnicity |
asian | Indicates whether the student is Asian in Y/N format. Alphanumeric, 1 character | Census > People > Demographics > Person Information > Race/Ethnicity > Asian Identity.raceEthnicity |
indian | Indicates whether the student is American Indian or Alaska Native in Y/N format. Alphanumeric, 1 character | Census > People > Demographics > Person Information > Race/Ethnicity > Indian Identity.raceEthnicity |
black | Indicates whether the student is Black or African American in Y/N format. Alphanumeric, 1 character | Census > People > Demographics > Person Information > Race/Ethnicity > Black Identity.raceEthnicity |
islander | Indicates whether the student is Native Hawaiian or Other Pacific Islander in Y/N format. Alphanumeric, 1 character | Census > People > Demographics > Person Information > Race/Ethnicity > Native Hawaiian or Other Pacific Islander Identity.raceEthnicity |
white | Indicates whether the student is White in Y/N format. Alphanumeric, 1 character | Census > People > Demographics > Person Information > Race/Ethnicity > White Identity.raceEthnicity |
| openEnrolled | Indicates whether a student with residence outside of the base school's designated school boundaries open enrolled into the base school at any time during the selected enrollment. Y/N format. Null field reports as N, not null field reports as Y. Alphanumeric, 1 character | Student Information > General > Enrollments > State Reporting Fields > Open Enrolled enrollment.stateAid |
baseSchoolId | Reports the State School Number based on the School of Primary Responsibility or JDC Attendance enrollment record being reported. Numeric, 4 digits | School & District Settings > School > School Information > State School Number School.number |
| county | The county where the student lives. Reports the number of the Resident County selected on the student's enrollment. If blank, reports the county of the student's primary address, if the student only has one primary address. If the student has more than one primary address, reports from the address with the earliest start date. If the student does not have a primary address, reports from the Secondary address. If the county field is null, reports the last entered county of the District. Numeric, 2 digits | Student Information > General > Enrollments > State Reporting Fields > Resident County; School & District Settings > District > District Information > County Enrollment. residentCounty District.county |
zip | The Zip Code from the student's primary address. If the student's Primary Address changes during the selected date range, the Zip Code from the Address that is active on the End Date of the range reports. If the Student's Primary Address ends during the selected date range, and there is not a new Primary Address, the Zip Code from the most recently active Primary Address reports. If the student does not have a primary address, reports from the Secondary address. Numeric, 9 digits | Census > Address Info > Zip Address.zip |
| phSchool | Indicates if the student is private or home schooled while being enrolled at the local school district. If Private Schooled is marked or Non-Public is P, reports as P. If Home Schooled is marked or Non-Public is H, reports as H. Otherwise reports as X. Alphanumeric, 1 character | Student Information > General > Enrollments > State Reporting Fields > Non Public, Home School, Private School EnrollmentID. nonPublic EnrollmentID. homeSchool EnrollmentID. privateSchool |
gradeLevel | The State Grade Level associated with the student's grade. Reports the grade level of the student's enrollment in the School of Primary Responsibility or JDC Attendance school on the extract End Date. Numeric, 2 digits | Scheduling & Courses > Calendar Setup > Grade Level Setup > State Grade Level GradeLevel.stateCode |
| uGPA | Reports the student's unweighted GPA. If the student is enrolled in a grade mapped to a State Grade other than 09, 10, 11, or 12, reports as null. Otherwise, reports the unweighted GPA from the transcript at the time the extract is generated. If there are no transcript entries or a unweighted GPA value is not available, reports as 0.00. Numeric, 3 digits, #.## | Calculated |
econDisStatus | Indicates whether the student is eligible for free or reduced price lunches through the National School Lunch Program. If the student has an active Eligibility with Free or Reduced selected and Direct marked, reports as D. If the student has an active enrollment on the extract End Date with Economically Disadvantaged marked, reports as S. Otherwise, reports based on the student's Eligibility record as follows:
Alphanumeric, 1 character | School & District Setup > School > School Information > School History > Provision FRAM > Eligibility > Eligibility Student Information > General > Enrollments > State Reporting Fields > Economically Disadvantaged (S) SchoolAttribute. provision POSEligibility. eligibility |
specialEd | Indicates whether the student has an active IEP under the IDEA part B or part C programs. Reports Y if the student has an active, locked IEP at any time during the selected Date Range; otherwise, reports N. Y or N, 1 character | Student Information > Special Ed > Documents > IEP > Enrollment Status editor > Special Ed Status PlanState.specialEdStatus |
504 | Indicates whether the student has an active education plan under the rules of section 504 of the Rehabilitation act. If the student has a 504 PLP record (Plan Format = 504) or a 504 program record in Program Participation that is active at some point between 07/01 and 06/30 of the school years selected, reports as Y. Otherwise reports as N. Y or N, 1 character | Student Information > PLP > General > Documents > PLPCurrent > Plan Outline PLP > Start Date, Program Exit Date, Type; Student Information > Program Participation > 504 > Start Date, End Date Enrollment.section504 |
| atRisk | Indicates if the student is considered to be at risk. If a value is selected for the At Risk field for any enrollment active at any point on or between 07/01 and 06/30 of the selected school year, reports as Y. Otherwise reports as N. Y or N, 1 character | Student Information > General > Enrollments > State Reporting Fields > At Risk Enrollment.atRisk |
| militaryConnected | Indicates if the student is connected to a member of the military. If the Military Connections record is active on the End Date entered on the extract editor, reports the standard code of the Status if the Relationship selected is not Self and is marked as Guardian. Otherwise reports as N. Alphanumeric, 1 character | Census > People > Military Connections ImpactAidEmployment.militaryStatus |
servedTitle1 | Indicates whether the student is receiving services under the rules of Title IA of NCLB. Reports first based on the Title 1 value selected in the School History tab of the student's School of Primary Enrollment. If Title 1 value of SWELIGSWPROG is selected, reports as Y. If the schools is identified as Not a Title 1 School, reports as N. Second, reports based on the individual student's Title 1 designation. If the student has a Title 1 program in Program Participation that is active between 07/01 and 06/30 of the school year selected, reports as Y. Otherwise reports as N. Y or N, 1 character | School & District Setup > School > School Information > School History > Title 1; Student Information > Program Participation > Title 1 > Start Date, End Date SchoolAttribute.title1 Title1.startDate Title1.endDate |
| idResident | Indicates if the student is a citizen of Idaho. Reports as N if either of the following is true: the student's Base or JDC Attendance Calendar of Enrollment has a Border Student record active on the extract End Date with a status of I OR if the student's Visa Type is J1 on the Identity active on the extract End Date. Otherwise reports as Y. Reports as N if the student is marked as an Immigrant, has a Citizenship Status value of EV or has a Border Student value of I. Otherwise reports as Y. Y or N, 1 character | Student Information > Program Participation > State Programs > Border Student > Status; Census > People > Identities > Visa Type BorderStudent.borderStatus |
| onVisa | Indicates if the student in the US on a temporary visa. If the student is enrolled in a grade level mapped to a State Grade of 09, 10, 11, or 12 and the student has a Visa Type of F1, reports as Y. Otherwise reports as N. Reports as X if the student is not enrolled in a grade mapped to a State Grade Level of 09-12. Alphanumeric, 1 character | Census > People > Identities > Visa Type Scheduling & Courses > Calendar Setup > Grade Level Setup > State Grade Level Code Identity.visaType |
gifted | Indicates whether the student is Gifted and/or Talented. Reports as Y if the student was both actively enrolled and has a locked PLP with a Plan Type of "Gifted/Talented" Y or N, 1 character | Student Information > PLP > Documents PlanState.gifted |
homeless | Indicates that the student lacks a fixed, regular, and adequate nighttime residence and is considered homeless. If the student has a Homeless record in Program Participation that is active at least one day on or between 07/01 and 06/30 of the selected school year, reports as Y. Otherwise reports as N. Y or N, 1 character | Student Information > Program Participation > Homeless > Dates, Primary Nighttime Residence Homeless.primaryNighttimeResidence |
homelessUAY | Indicates if the student is considered to be an Unaccompanied Youth. This field only reports if the Homeless field above reports as Y. If the student has a Homeless record in Program Participation that is active at least one day on or between 07/01 and 06/30 of the selected school year with Unaccompanied Youth marked and a Homeless Residence selected, reports as Y. Otherwise reports as N. Y or blank, 1 character | Student Information > Program Participation > Homeless > Unaccompanied Youth Homeless.unaccompaniedYouth |
homelessResidence | An indication of a homeless student's primary nighttime residence at the time they were identified as being homeless. Reports based on the first Homeless program active at any point on or between 07/01 and 06/30 of the selected school year.
Alphanumeric, 1 character | Student Information > Program Participation > Homeless > Dates, Primary Nighttime Residence Homeless.primaryNighttimeResidence |
| busRider | Indicates if the student has a Transportation record. If the student has a Transportation record active on the extract End Date that has Bus Eligible marked, reports as Y. Otherwise reports as N. Y or N, 1 character | Student Information > General > Transportation > Bus Eligible Transportation.busEligible |
| borderstudent | Reports the code selected on the Border Student record active on the extract End Date. Otherwise reports as X. Alphanumeric, 1 character | Student Information > Program Participation > State Programs > Border Student > Status BorderStudent.borderStatus |
borderId | Reports the Border District Number entered on the student's Border record that is active on the extract End Date. Otherwise reports as blank. Alphanumeric, 10 character | Student Information > Program Participation > State Programs > Border Student > Border District Number BorderStudent.borderDistrictNumber |
immigrant | Indicates that the student is an immigrant. Reports based on checkbox selection. Y or N, 1 character | Student Information > General > Enrollment > State Reporting > Immigrant Enrollment.immigrant |
immigrantEntry | For immigrant students, the date they entered the United States. Reports Date Entered US School if previous field (immigrant) reports as Y. Otherwise reports blank. Date Field, 10 digits in MM/DD/YYYY | Census > Demographics > Person Information > Date Entered US School Identity.dateEnteredUSSchool |
| nativeLanguage | The Home Primary Language selected on the student's active Identity. Alphanumeric, 2 characters | Census > People > Demographics > Home Primary Language Identity.homePrimaryLanguage |
country | The code for the country in which the student was born. Reports Birth Country from the student's Identity record active at the end of the reporting date range. Alphanumeric, 2 characters | Census > People > Demographics > Birth Country Identity.birthCountry |
tdPeer | Indicates whether the student is a Typically Developing Peer in an early childhood or pre-kindergarten program. Reports Y If the student is enrolled in a state grade of PK and has the Typically Developing Peer checkbox marked on their enrollment. Otherwise, reports as N. Alphanumeric, 1 character | Student Information > General > Enrollments > State Reporting Fields > Typically Developing Peer Enrollment.tdPeer |
| selfDirectedLearner | Indicates whether the student is considered a Self-Directed Learner. Reports as Y if the student has a Self-Directed Learner record that is active on at least one day on or between 07/01 and 06/30 of hte selected school year, where the Participation School selected on the record matches the school reported for BaseSchoolID. Otherwise reports as N. Alphanumeric, 1 character | Student Information > Program Participation > State Programs > Self-Directed Learner PlanOfStudy.startDate PlanOfStudy.endDate |
| earnedIndustryCert | Indicates if the student is enrolled in a Career Tech Prog Certification program at the school in which they are enrolled. If the following is true:
then this field reports based on the school selected in the Location Earned field on the CTE Program Participation tab.
If the student is enrolled in a grade level mapped to a State Grade of 09, 10, 11, or 12 BUT
If the student is not enrolled in a grade level mapped to a State Grade of 09, 10, 11, or 12, reports as null. Alphanumeric, 1 character | Student Information > Academic Planning > Program Type Calculated |
| apprenticeshipParticipant | Indicates if the student participates in a STRAP (School to Registered Apprenticeship Program) program. If the student is enrolled in a grade mapped to a state grade of 09, 10, 11, or 12 and has a STRAP program record active in the extract date range, and the Participation School selected on their STRAP record matches the Base School ID reported above, reports as Y. Otherwise, reports as N. If the student in not enrolled in a reportable state grade level, reports as blank. Alphanumeric, 1 character | Student Information > Program Participation > State Programs > STRAP ApprenticeshipProgram.startDate ApprenticeshipProgram.endDate |
| chronicallyAbsent | Reports as Y if the student is chronically absent, having missed at least 10% of total school days. Otherwise reports as N. Also reports as N for students who do not have a minimum of 10 unique cumulative days of enrollment in a JDC calendar or in their School of Primary Responsibility. Does not report if the student is enrolled in State Grades other than KG or 1-12 or if the SchoolExitDate field reports as blank. See the Chronically Absent Logic section following for more information about how Chronic Absenteeism is calculated. Alphanumeric, 1 character | Calculated |
| onSchoolGrounds | For current year enrolled K-12 students, indicates the majority of their instruction was received at a physical facility owned or leased by the reporting LEA. The field will default to null. Users may choose Y:Yes, N:No or X:Not Applicable when populating this field. | Student Information > General > Enrollments > State Reporting Fields > On School Grounds enrollment.onSchoolGrounds |
districtEntryDate | The month, day, and year on which the student entered and began to receive instructional services in the district during the current school year. For the first enrollment, reports Start Date. For additional enrollment records reports as follows:
Reports based all primary and/or partial enrollments. Date Field, 10 digits, MM/DD/YYYY | Student Information > General > Enrollments > Start Date Enrollment.stateDate |
districtEntryType | The process by which the student entered the district. Reports the Start Status from the enrollment reported in the districtEntryDate field. See the list of Enter Codes following this table. Alphanumeric, 2 characters | Student Information > General > Enrollments > Start Status Enrollment.startStatus |
| schoolEntryDate | The date on which the student entered and began to receive instruction at the school. Reports enrollment Start Date. Records are reported based on the "Include Partial Enrollments" checkbox on the extract editor. Date field, 10 digits, MM/DD/YYYY | Student Information > General > Enrollments > Start Date Enrollment.stateDate |
| schoolEntryType | The process by which the student entered the school. Report the Start Status of the enrollment reported in the SchoolEntryDate field. See the list of Enter Codes following this table. Alphanumeric, 2 characters | Student Information > General > Enrollments > Start Status Enrollment.startStatus |
| schoolExitDate | The date of a student's last attendance in school. If the enrollment End Date is on or within the extract date range, reports End Date. Otherwise reports blank. Reports based on the "Include Partial Enrollments" checkbox on the extract editor. Date field, 10 digits, MM/DD/YYYY | Student Information > General > Enrollments > End Date Enrollment.endDate |
| schoolExitType | The circumstances under which the student exited from membership in the school. Report the End Status of the enrollment reported in the SchoolExitDate field. Otherwise reports blank. See option in the following Leave Code Options table. Alphanumeric, 2 characters | Student Information > General > Enrollments > End Status Enrollment.endStatus |
districtExitDate | The date of a student's last attendance in district. If the student's enrollment active during the extract Date Range is not End Dated and the extract End Date is on or after the last instructional day of the calendar, reports calendar End Date. If the student's enrollment End Date falls during the extract Date Range and the extract End Date is on or after the last instructional day of the calendar, reports enrollment End Date. If the student's enrollment End Date falls during the extract Date Range and the extract End Date is before the last instructional day of the calendar and the enrollment End Status is not 1A or 1B, reports enrollment End Date. If End Status is 1A or 1B, reports blank. Otherwise reports as blank. Reports based all primary and/or partial enrollments. Date Field, 10 digits in MM/DD/YYYY | Student Information > General > Enrollments > End Date Enrollment.endDate |
districtExitType | The circumstances under which the student exited from membership in the district. Reports the End Status of the enrollment reported in the DistrictExitDate field. See option in the following Leave Code Options table. Alphanumeric, 2 characters | Student Information > General > Enrollments > End Status Enrollment.endStatus |
Chronically Absent Logic
Chronic Absenteeism is calculated at the school level as follows. The chronicallyAbsent field reports as Y/N based on the running total of eligible absent days divided by the maximum possible instructional/scheduled days for each School of Primary Responsibility record reported.
The maximum possible instructional/scheduled days value is calculated as the total number of unique instructional days from the student's earliest enrollment date to either the end date of the School of Primary Responsibility or the extract end date, whichever is earliest. For an instructional day to count towards the total, the student must be scheduled into at least one class that takes attendance on that day.
The eligible absent days value is calculated as days in which the student was marked as absent (excused, unexcused, or unknown) for at least 50% of their scheduled attendance time. Students with multiple enrollments must be absent for at least 50% of all possible attendance minutes across all enrollments. If a student is enrolled in a calendar flagged as JDC, the calculation only considers instructional days in this calendar only to determine absence thresholds.
Enter Codes
Code | Name |
|---|---|
1A | Returning Student |
1B | Transfer from Within District |
1C | Initial Enrollment |
2A | Transfer from Other Public ID District or Charter |
2B | Transfer in from Non Public Setting |
2C | Transfer in From Out of State |
3A | Returning Dropout |
4A | Entering Foreign Exchange Student |
4B | Entering Foreign Student |
5A | Returning Expelled or from Other Temporary Ban |
5B | Return from Medical Leave |
5E | Re-enrolling Student after Temporary Parental Withdrawal |
6B | Re-enrolling Former Completer |
Leave Code Options
Code | Description |
|---|---|
1A | Within District Same School |
1B | Within District Transfer-Different Public School |
1C | Within District Transfer to No Particular School |
2A | Within ID to Different Public School District |
2B | Within ID to Private Sch or Fed-State Setting |
2C | Transfer Out of ID to US Public or Non-Public |
| 2D | Transfer Out of Country |
| 2E | Within Idaho to Homeschool |
3A | Confirmed Drop Out |
3B | Reached Maximum Age |
3C | Expelled |
3D | Transfer to Adult Ed. |
3E | Unknown |
4A | Graduated - Met State Standards |
4B | Completed, Did not Meet All Graduation Requirement |
4C | Completed - Adapted Requirements |
| 4G | Early Graduate 1 Year |
| 4H | Early Graduate 2 Year |
| 4I | Early Graduate 3 Year |
5A | Temporarily Unenrolled |
5B | Medical Leave |
5C | US Resident Exiting to Foreign Exchange Program |
| 5F | Foreign Exchange Student Exiting District/School |
6A | Deceased |
6B | Exit of Returning Completer |
