Birth to Three Programs Report

Contents

Introduction

This report is to generate Illinois Birth to Three Programs data for the Illinois State Board of Education (ISBE) collection.

Selection Criteria

Student Selection

The report selects which student records to use based on the following criteria:

Students must be enrolled within the school year as per the user-defined report date.
Students must have a Birth to Three Program record added.
The Enrollment Entry/Grade Level must be 00 for the Birth to Three Record to be created.
Students must be between the age of birth to 3 years old and have Birth to 3 data to be included in the report.
This report only includes students who are between the ages of 0 - 3 during the current school year.
Students with an exit date before an entry date will not be included in the report.
This report only includes students who are included in State Reporting.
This report only includes students whose enrollments are from schools which are included in State Reporting.

Report Input

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

Field	Description
Schools to Include	Choose one of the following: Current School Only – Includes all student records associated with the current school that meet selection criteria. To change the current school, click the School link at the top of the page and choose the appropriate school from the list. All Schools – Includes all student records on the PowerSchool server that meet selection criteria. Note: The All Schools option is only available when running the report from the District Office.
Students to Include	Indicate which students to include in the report by selecting one of the following options: The selected [number] students only – Run the report for students in the current selection. All students – Run the report for all students in the current school or district that meet the selection criteria. Note: If running the report for a single student, or group of students, select the students prior to runningreport.
RCDTS Number (Override)	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.
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

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.

	Data Element	Description	[Table]FieldName	Field Type	Field Length
	Student ID	The identification code assigned to each student in your district by the Illinois State Board of Education (ISBE).	[Students]State_StudentNumber	String	9
	SAP ID	The PowerSchool student identification code.	[Students]Student_Number	String	50
	Legal Last Name	The legal last name of the student.	[S_IL_STU_Demographics_X] Legal_Last_Name	String	30
	Legal First Name	The legal first name of the student.	[S_IL_STU_Demographics_X] Legal_First_Name	String	30
	Birth Date	The student’s birth date.	[Students]DOB	String	10
	RCDTS Home School	The RCDTS number that identifies the student’s home school. Note: 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	String	15
	RCDTS Serving School	The RCDTS number that identifies the school that provides service to the student. Note: If the RCDTS Serving School is blank for a student, the RCDTS Home School entered on the Edit School page is extracted.	[S_IL_STU_X]RCDTS_Serving_School [S_IL_SCH_X]RCDTS_Home_School	String	15
8	Program	The type of program in which the student is enrolled.	[S_IL_STU_BirthTo3_C]Program	String	2
9	Service Location	The location where the services are provided. Identify the type of program/services this child receives: DCFS Licensed Day Care/Center-Based, Family Child Care Home, or Home Visiting.	[S_IL_STU_BirthTo3_C]Service_Location	String	2
10	Program Model	The preventative program in which the student is enrolled.	[S_IL_STU_BirthTo3_C]Program_Model	String	2
11	Program Start Date	The Program start date. Program start date and Program end date will be matched with Enrollment Entry date and Enrollment Exit date respectively for the report output. Other enrollments will not be pulled.	[S_IL_STU_BirthTo3_C]Program_Start_Date	String	10
12	Program End Date	The Program end date. Program start date and Program end date will be matched with Enrollment Entry date and Enrollment Exit date respectively for the report output. Other enrollments will not be pulled. Note: Program end date can be left blank in case enrollment exit date is in future. Report will also pull this data.	[S_IL_STU_BirthTo3_C]Program_End_Date	String	10
13	Reason for Ending Program	The reason for ending the program.	[S_IL_STU_BirthTo3_C]Reason_Ending_Program	String	2
14	Provider Type	Indicates the specific role of the provider.	[S_IL_STU_BirthTo3_C]Provider_Type	String	3
15	IEIN	Indicates the Illinois Educator Identifying Number (IEIN) of the teacher.	[S_IL_STU_BirthTo3_C]IEIN	Numeric
16	Gateways Registry Member ID	The Gateways Registry Member ID	[S_IL_STU_BirthTo3_C]GatewaysRegistryMemberId	String	10
17	Provider has a Gateways Credential	Indicates if the provider has Gateways Credential	[S_IL_STU_BirthTo3_C]HasGatewaysCredential	String	2
18	Provider Start Date	Indicates the Provider Start Date	[S_IL_STU_BirthTo3_C]Provider_Start_Date	String	10
19	Provider End Date	Indicates the Provider End Date	[S_IL_STU_BirthTo3_C]Provider_End_Date	String	10
20	Reason for Ending Provider	Indicates the Reason for Ending Provider	[S_IL_STU_BirthTo3_C]Reason_Ending_Provider	String	2
21	Result Code	N/A	N/A	String	2
22	Result Message	N/A	N/A	String	200