IL Birth to Three Caregiver report

Introduction

Use the IL Birth to Three Caregiver report to submit caregiver data to the ISBE SIS. This report contains caregiver information of currently enrolled students in grade-level Pre-Kindergarten.

The report format is comma-delimited (CSV) with a .txt extension. If a student field is blank for a mandatory field, the field default value is used in the extract. If a student field is blank for an optional field, the field is blank on the extract.

Selection Criteria

Selection criteria determine which database records are used in the report. See selection criteria for analysis when the report does not return the correct records.

For the IL Caregiver Demographics Report, records for currently enrolled students in grade-level Pre-Kindergarten are selected and the age of the student is 0 to 3 years i.e. the student is less than 4 years as on Report End Date.

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 less than 4 years as on Report End Date.
Students with an exit date before an entry date will not be included in the report.
Students whose any one contact is selected as "Caregiver"

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Field	Description
Use	Choose one of the following: Multiple Schools – Includes all student records associated with multiple schools that meet selection criteria. All Schools – Includes all student records on the PowerSchool server that meet selection criteria. The All Schools option is only available when running the report from the District Office.
Current Selection of Students	Choose one of the following: The Selected Students Only – Includes only the selected students. All Students – Includes all the students.
RCDTS Number (Override) This is an optional field	Enter the unique identifier for the school or district.
Start Date	Select the report start date. Format: MM/DD/YYYY
End Date	Select the report end date. Format: MM/DD/YYYY

Report Output

Each of the fields displayed in the output of the report is described below. See Understanding the Report Output Table for a definition of each column in the table.

Field	Field Name	Description	[Table]FieldName	Field Type	Length	Required
1	State Student ID	The Student ID	[Students]State_Studentnumber	String	9	M
2	Local SAP ID	Local SAS ID	[Students]Student_Number	String	50	O
3	Last Name	Legal Last Name of the Student	[Students]Legal_Last_name [Students]Last Name	String	30	M
4	First Name	Legal First Name of the student	[Students]Legal_First_Name [Students]First Name	String	30	M
5	Date of Birth	Date of birth of the student	[Students]DOB	String	10	M
6	RCDTS Home School	Enrollment RCDTS for Home School (Information from Demo/Enrollment file)	[Students]RCDTS_Home_School [Schools]RCDTS_Home_School	String	15	M
7	RCDTS Serving School	Enrollment RCDTS for Serving School (Information from Demo/Enrollment file)	[Students]RCDTS_Serving_School [S_IL_STU_X]RCDTS_Serving_School	String	15	M
8	Caregiver's Relationship to Child	Caregiver's Relationship to Child	[S_IL_STU_X]RelationshipTypeCodeSetID	String	2	M
9	Caregiver SID	Caregiver SID	N/A	String	9	O
10	Caregiver First Name	Caregiver First Name	[Person]FirstName	String	30	O
11	Caregiver Last Name	Caregiver Last Name	[Person]LastName	String	30	O
12	Birth Date of Caregiver	Birth Date of Caregiver	[Person CoreFields]DateofBirth	String	10	M
13	Caregiver's Race	Caregiver's Race	[Person]Race	String	2	M
14	Educational Background of Caregiver	Educational Background of Caregiver	[Person]EducationLevel	String	2	M
15	Current Employment Status of Caregiver	Current Employment Status of Caregiver	[Person]EmploymentStatus	String	2	M
16	Result Code	Published Result Code	N/A	String	2	N/A
17	Result Message Codes	Published Result Message Codes	N/A	String	200	N/A