IL Multiple SID
Contents
Introduction
Use the IL Multiple SID report to submit student records with multiple student IDs to the ISBE SIS.
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.
The Extract Viewer link is available on the State Reports page in the description area for the IL Multiple SID report. The Extract Viewer can be used as a troubleshooting tool.
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.
For the Illinois Multiple SID report, student enrollment records are selected.
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 was enrolled at any time between the report start and end dates.
- The report includes only students marked as having a Student ID to Delete on the Multiple SID page.
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 from the pop-up menu:
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:
Note: If running the report for a single student, or group of students, select the students prior to running report. |
Processing Options | Choose a time to run the report from the pop-up menu:
|
Specific Date/Time | Enter a date using the format mm/dd/yyyyor mm-dd-yyyyin order to run the report on a specific day. The incorrect format displays an alert and the date field is submitted as a blank entry. Use the pop-up menus to 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 to run the report. |
Report Start Date | Enter the start date for the reporting period. Format: MM/DD/YYYY |
Report End Date | Enter the end date for the reporting period. Format: MM/DD/YYYY |
The RCDTS Number | Enter the 15-digit RCDTS (Region, Country, District, Type, and School) number. The value entered in this field will be used in the file name and the header in the report results. |
Run from the Extract Viewer | Choose one of the following from the pop-up menu:
Note: If you select No, the data in the extract viewer is replaced with the data from the extract. |
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 | This field contains the student identification code assigned to each student in your district by the Illinois State Board of Education (ISBE). This field should be blank for all students upon first submission of the student. This field is 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]State_StudentNumber | Alpha-numeric | 9 |
2 | SAP ID | This field contains the PowerSchool student identification code. This field is extracted from the Multiple SID tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > Multiple SID Information. | [Students]Student_Number | Alpha-numeric | 50 |
3 | Last Name | This field contains the last name of the student. This field is extracted from the Demographics page, Start Page > Student Selection > General Demographics. | [Students]Last_Name | Alpha-numeric | 30 |
4 | First Name | This field contains the first name of the student. This field is extracted from the Demographics page, Start Page > Student Selection > General Demographics. | [Students]First_Name | Alpha-numeric | 30 |
5 | Birth Date | This field contains the student’s birth date. This field is extracted from the Demographics page, Start Page > Student Selection > General Demographics. | [Students]DOB | Alpha-numeric | 10 |
6 | RCDTS Home School | Enter the RCDTS number that identifies the student’s home school. This field is extracted from the Multiple SID tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > Multiple SID Information. If the RCDTS Home School is blank for a student, the RCDTS Home School defined in the Edit School page is extracted. | [S_IL_STU_X]RCDTS_Home_School [S_IL_SCH_X]RCDTS_Home_School | Alpha-numeric | 15 |
7 | RCDTS Serving School | This field contains the RCDTS number that identifies the school that provides service to the student. This field is extracted from the Multiple SID tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > Multiple SID Information. If the RCDTS Serving School is blank for a student, the RCDTS Home School entered on the Edit School page is used in the report. | [S_IL_STU_X]RCDTS_Serving_School [S_IL_SCH_X]RCDTS_Home_School | Alpha-numeric | 15 |
8 | Student ID (Delete) | This field contains the student ID that will be deleted. This field is extracted from the Multiple SID tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > Multiple SID Information. | [S_IL_STU_Demographics_X]SID_To_Delete | Alpha-numeric | 9 |
9 | Last Name (Delete) | This field contains the student last name that will be deleted. This field is extracted from the Multiple SID tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > Multiple SID Information. | [Students]Last_Name [S_IL_STU_Demographics_X]Legal_Last_Name | Alpha-numeric | 30 |
10 | First Name (Delete) | This field contains the student first name to be deleted. This field is extracted from the Multiple SID tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > Multiple SID Information. | [Students]First_Name [S_IL_STU_Demographics_X]Legal_First_Name | Alpha-numeric | 30 |
11 | Birth Date (Delete) | This field contains the student birth date to be deleted. This field is extracted from the Multiple SID tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > Multiple SID Information. | [S_IL_STU_Demographics_X]DOB_To_Delete | Alpha-numeric | 10 |