IL Demographics Enrollment
Introduction
The IL Demographics Enrollment report contains demographic and enrollment information for currently enrolled students in grades 0 and above. Submit this report to obtain State Student Identifiers from the state of Illinois Department of Education.
You can print this report for all students, students that require an ISBE State Student Identifier number, or students that are already assigned an ISBE State Student Identifier number.
The report format is comma-delimited (CSV) with a .txt extension. If a student field is blank for a mandatory field, the field default is used in the extract. If a student field is blank for an optional field, the field is blank on the extract.
Pre-K student records are typically extracted using the Demographics and Early Childhood report. However, for pre-K students who are excluded from the Early Childhood report, the students can be included in this report using the Birth to 3 reporting parameter. See Report Input below for details.
Concurrent PDA Output
When a student has a concurrent Percent of Day Attended (PDA) record with a start date that is on or after the report start date, the report extracts data for the following elements from the concurrent PDA record:
Report Output Column Name | Extracted from Concurrent PDA Field |
---|---|
Enrollment Date | Start Date |
RCDTS for Serving School | RCDTS Serving School Number |
Percent of Day Student Attends School | Percent Day Attended (PDA) (Formerly FTE) |
Entry/Grade Level | Grade Level |
Selection Criteria
Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.
School Selection
The report selects which school records to use based on the following criteria:
The school must be associated with a student included in the report.
The school must not be excluded from state reporting.
Student Selection
The report selects which student records to use based on the following criteria:
The student must not be excluded from state reporting.
The enrollment for the student must not be excluded from state reporting.
The student is currently enrolled as of the submission (enroll_status = 0).
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
Field | Description |
Use | If run at the district level, choose one of the following :
If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list. |
Students to Include | Indicate which students to include in the report by selecting one of the following options:
If running the report for a single student, or group of students, select the student(s) prior to running the report. |
Processing Options | Choose a time to run the report :
|
Specific Date/Time | To run the report on a specific day, enter a date using the format mm/dd/yyyy or mm-dd-yyyy. An incorrect format is displayed as an alert and the date is submitted as a blank entry. Schedule the report to be run at a specific hour and minute. Example: 7/29/2011 @ 10:05 AM. |
Select District | (Optional) If this option appears, select the District for which you want to run the report. |
Select Filter | Choose the record selection filter for this report:
|
15-digit RCDTS Number | Enter the 15-digit RCDTS (Region, Country, District, Type, and School) number. The value entered here is used in the file name and the header in the report results. |
Birth to 3 | Choose Yes or No to indicate if pre-K students (students aged from birth until three years old) should be included in the report. The default is No. |
Lunch Status, Low Income Indicator | Choose the code that indicates the student’s Lunch Status, Low Income Indicator.
|
Start Date | Enter the enrollment start date for the students to be reported. |
End Date | Enter the enrollment end date for the students to be reported. |
Report Output
Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.
Item # | Data Element | Description | [Table]FieldName | Field Type | Field Length |
1 | State Student Identifier (ISBE SIS Assigned Student ID#) | The student identification code assigned to each student in your district by the Illinois State Board of Education (ISBE). Should be blank for all students upon first submission of the student. Extracted from the Demo tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Student Demographic/Enrollment Information. When run for students who do not yet have valid ISBE SIS State IDs, the report generates a record for the home school only. | [Students]State_StudentNumber | Numeric | 9 |
2 | PowerSchool Student Number / SAP ID | The PowerSchool student identification code. Extracted from the Demo tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Student Demographic/ Enrollment Information. | [Students]Student_Number | Alpha-numeric | N/A |
3 | Legal Last Name | The legal last name of the student. Extracted from the Demo tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Student Demographic/Enrollment Information. If the Legal Last Name field is left blank, the student’s last name entered on the Demographics page is used. | [S_IL_STU_Demographics_X]Legal_Last_Name | Alpha-numeric | 30 |
4 | Legal First Name | The legal first name of the student. Extracted from the Demo tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Student Demographic/Enrollment Information. If the Legal First Name field is left blank, the student’s first name entered on the Demographics page is used. | [S_IL_STU_Demographics_X]Legal_First_Name | Alpha-numeric | 30 |
5 | Legal Middle Name | The legal middle name of the student. Extracted from the Demo tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Student Demographic/Enrollment Information. If the Legal Middle Name field is left blank, the student’s middle name entered on the Demographics page is used. | [S_IL_STU_Demographics_X]Legal_Middle_Name | Alpha-numeric | 30 |
6 | Lineage (Suffix) | The suffix identifying the student’s lineage (Jr., Sr., III, etc.). Extracted from the Demo tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Student Demographic/Enrollment Information. | [S_IL_STU_Demographics_X]Lineage_Code | Alpha-numeric | 3 |
7 | Mother’s Maiden Name | The maiden name of the students’ mother. Extracted from the Demo tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Student Demographic/ Enrollment Information. | [S_IL_STU_Demographics_X] Mother_Maiden_Name | Alpha-numeric | 30 |
8 | IL Race / Ethnicity Code | The code identifying the student’s ethnicity. Extracted from the Demo tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Student Demographic/ Enrollment Information. | [S_IL_STU_Demographics_X]FER | Numeric | N/A |
9 | Gender | The code identifying the student’s gender. Extracted from the Demo tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Student Demographic/ Enrollment Information. Valid values:
| [Students]Gender | Alpha-numeric | 2 |
10 | Birth Date | The student’s birth date. Extracted from the Demo tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Student Demographic/ Enrollment Information. | [Students]DOB | Numeric | 10 |
11 | Birth Place Name | The name of the city where the student was born. Extracted from the Demo tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Student Demographic/ Enrollment Information. | [S_IL_STU_Demographics_X]Birth_Place | Alpha-numeric | 30 |
12 | Reading 1st Indicator | (Optional) Indicates whether the kindergarten or elementary student (grades K-3) is a participant in the reading 1st program. Extracted from the Demo tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Student Demographic/Enrollment Information. | [S_IL_STU_X]Reading_First | Numeric | 2 |
13 | Reading Improvement Block Grant Program Indicator | (Optional) Indicates whether the kindergarten or elementary student (grades K-6) was selected to receive services provided with Reading Improvement Block Grant funds. Extracted from the Demo tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Student Demographic/Enrollment Information. | [S_IL_STU_X]Reading_Improve | Numeric | 2 |
14 | Title I Indicator | Indicates whether the student is a participant in a federally funded Title I reading or mathematics instruction program. Extracted from the Demo tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Student Demographic/Enrollment Information. If no value is entered for the Title I Indicator field on IL Demo page and School Info page, the value is automatically set to 13. | [S_IL_STU_X]Title1 | Numeric | 2 |
15 | Eligible for Immigrant Education Program | Indicates whether the student is eligible for an immigrant education program.
| [S_IL_STU_X]Elig_Immig_Edu_Prog | Numeric | 2 |
16 | Home Language | The student’s native language, English or non-English; or, if the student’s native language is English and a language other than English is spoken in the student’s home, The home language that is the predominant non-English language spoken by the student in the student’s home; or the student’s parents or legal guardians, with the student’s non-English language taking precedence. Extracted from the Demo tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Student Demographic/Enrollment Information. | [S_IL_STU_Demographics_X] Home_Language_Code | Numeric | 3 |
17 | Native Language | The student’s native language. Extracted from the Demo tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Student Demographic/Enrollment Information. | [S_IL_STU_Demographics_X]NELB | Numeric | 3 |
18 | Homeless Indicator | Indicates whether the student is considered homeless.
Extracted from the Demo tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Student Demographic/Enrollment Information. | [S_IL_STU_Homeless_X]Homeless | Alpha-numeric | 2 |
19 | Migrant Indicator | Indicates whether the student is a migrant.
Extracted from the Demo tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Student Demographic/Enrollment Information. | [S_IL_STU_X]Migrant | Alpha-numeric | 2 |
20 | Private School Student (PSS) Indicator | Indicates whether the student attends a private school.
The field is extracted from the Demo tab of the State/Province-IL page found at Start Page>Student Selection>State/Province-IL > Demo tab. | [S_IL_STU_X]Private_School_Student | Alpha-numeric | 2 |
21 | Military-Connected Field | Indicates whether the student military connected.
Extracted from the Demo tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Student Demographic/Enrollment Information. | [S_IL_STU_X]Military_Connected [S_IL_REN_X]Military_Connected | Alpha-numeric | 2 |
22 | Supplemental Educational Services (SES) Indicator | Indicates whether the student is a participant in Supplemental Education Services.
Extracted from the Demo tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Student Demographic/Enrollment Information. | [S_IL_STU_X]SES | Alpha-numeric | 2 |
23 | EL Indicator | Indicates whether the student is a participant in EL program(s).
Extracted from the Demo tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Student Demographic/Enrollment Information. | [S_IL_STU_X]EL | Alpha-numeric | 2 |
24 | IDEA Services | Indicates whether the student is a participant in IDEA Services
Extracted from the Demo tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Student Demographic/Enrollment Information | [S_IL_STU_X]IDEA | Alpha-numeric | 2 |
25 | Alternate Assessment Indicator | Indicates whether the student is a participant in Alternate Assessment Program.
Extracted from the Demo tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Student Demographic/Enrollment Information | [S_IL_STU_X]AlternateAssessmentIndicator | Alpha-numeric | 2 |
26 | Dual Language | The dual-language program in which the student is enrolled. Valid values:
The default is 03 – Not a Participant in Dual Language Program | [S_IL_STU_X]Dual_Language | Alpha-numeric | 3 |
27 | Language of Instruction | The language of instruction for the dual-language program. Download the language codes from the Illinois State Board of Education Student Information System Web site at https://www.isbe.net/Documents/language-codes-alpha.pdf | [S_IL_STU_X]Language_Of_Instruction | Alpha-numeric | 3 |
28 | Free or Reduced Meal Benefits (Low Income Family) Indicator | Indicates whether the student is a participant in the Free or Reduced Meal Plan.
Extracted from the Demo tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Student Demographic/Enrollment Information. | [S_IL_STU_X]LII | Alpha-numeric | 2 |
29 | Century 21 Indicator | Indicates whether the student is a participant in the 21st Century Community Learning Centers (After School Program)
Extracted from the Demo tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Student Demographic/Enrollment Information. | [S_IL_STU_X]Century_21 | Alpha-numeric | 2 |
30 | Enrollment Type Code | The student’s current enrollment code. Extracted from the Edit Current Enrollment Page under Illinois State Information section, Start Page > Student Selection > Transfer Info > Edit Current Enrollment> Illinois State Information section. If the above Enrollment Type Code field is blank , Extracted from the Edit Current Enrollment page, Start Page > Student Selection > Transfer Info > Edit Current Enrollment. | [S_IL_STU_X]Enrollment_Entry_Type_Code | Alpha-numeric | 2 |
31 | Enrollment Entry Date (Current) | The student’s current enrollment entry date. Extracted from the Edit Current Enrollment Page, Start Page > Student Selection >Transfer Info > Edit Current Enrollment.
| [Students]EntryDate [S_IL_STU_CONENR_C]EntryDate | Numeric | 10 |
32 | RCDTS Home School Number (Student Level) | The Region, County, District, Type, School (RCDTS) code that uniquely identifies the student’s home school. Extracted from the Demo tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Student Demographic/ Enrollment Information. If left blank, the RCDTS Home School entered on the Edit School page is extracted. | [S_IL_STU_X]RCDTS_Home_School [S_IL_STU_CONENR_C]RCDTS_Home_School | Alpha-numeric | 15 |
33 | RCDTS Serving School Number | The Region, County, District, Type, School (RCDTS) code that uniquely identifies the student’s serving school. Extracted from the Demo tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Student Demographic/ Enrollment Information.
| [S_IL_STU_X]RCDTS_Serving_School [S_IL_STU_CONENR_C]RCDTS_Serving_School | Alpha-numeric | 15 |
34 | Entry/Grade Level | The student’s current grade level. Extracted from the Demo tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Student Demographic/Enrollment Information. If there is a concurrent PDA, the report extracts the value from the concurrent PDA record. If the Student is grade 0 and below, it will be reported as given below grade_level: -3 is reported as '00' | [Students]Grade_Level [S_IL_STU_ELL_X]Grade_Level [S_IL_STU_CONENR_C]Grade_Level | Alpha-numeric | 2 |
35 | Current School Year (last active enrollment) | The school year of the student’s last active enrollment. Extracted from the Demo tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Student Demographic/ Enrollment Information. This value is updated on the Edit Current Enrollment page, Start Page > Student Selection > Transfer Info > Edit Current Enrollment. | Derived from [Students]ExitDate | Numeric | 4 |
36 | Percent of Day Student Attends School (Formerly FTE) | The percent of day the student attends school. Extracted from the Demo tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Student Demographic/ Enrollment Information. If there is a concurrent PDA record, the report extracts the value from the concurrent PDA. | [S_IL_STU_X]FTE [S_IL_STU_CONENR_C]FTE | Numeric | 4 |
37 | Tuition-In Indicator | Indicates whether the student chooses to attend a school in a district other than her or his residing district, and that the student's parents pay tuition to that school district.
| [S_IL_STU_X]Tuition_In_Indicator | Alpha-numeric | 2 |