IL Prenatal Services Report

Introduction

This file format pertains to the data submitted to ISBE SIS when submitting information for the ISBE Prenatal Services Data Collection.

Selection Criteria

Student Selection

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

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 running report.
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
1	Prenatal ID	The Prenatal ID	[S_IL_STU_Demographics_X]Prenatal_ID	String	9
2	Mother’s First Name	The Mother’s First Name	[Students]IL_Legal_First_Name	String	30
3	Mother’s Middle Name	The Mother’s Middle Name	[Students]IL_Legal_Middle_Name	String	30
4	Mother’s Last Name	The Mother’s Last Name	[Students]IL_Legal_Last_Name	String	30
5	Mother’s Maiden Name	The Mother’s Maiden Name	[S_IL_STU_Prenatal_C]MothersMaidenName	String	30
6	Mother’s Birthdate	The Mother’s Birthdate	[Students]DOB	String	10
7	Mother’s SIS Student ID	The Mother’s SIS Student ID	[Students]State_StudentNumber	String	9
8	Mother’s Race	The Mother’s Race	[Students]Ethnicity	String	2
9	Mother’s Marital Status	The Mother’s Marital Status	[S_STU_X]MaritalStatus	String	2
10	Mother’s Education Received	Indicates Mother’s Education level	[S_IL_STU_Prenatal_C]MothersEducationReceived	String	2
11	Mother’s Employment Status	Indiccates the Mother’s Employment Status	[S_IL_STU_Prenatal_C]MothersEmploymentStatus	String	2
12	Mother is Homeless	Indicates if the Mother is Homeless	[S_IL_STU_Homeless_X]Homeless	String	2
13	Mother’s Street Address	Mother’s Street Address	[Students]Street	String	50
14	Mother’s City	Mother’s City	[Students]City	String	30
15	Mother’s Zip Code	Mother’s Zip Code	[Students]Zip	Numeric	5
16	Mother’s Zip +4	Mother’s Zip +4	[Students]Zip	Numeric	4
17	Mother’s County	Mother’s County	[S_IL_STU_Prenatal_C]	String	3
18	Mother’s Phone Area Code	Mother’s Phone Area Code	[Students]Home_Phone	Numeric	3
19	Mother’s Phone Prefix	Mother’s Phone Prefix	[Students]Home_Phone	Numeric	3
20	Mother’s Phone Suffix	Mother’s Phone Suffix	[Students]Home_Phone	Numeric	4
21	RCDT For Grantee	RCDT For Grantee	[S_IL_STU_Prenatal_C]RCDTForGrantee	String	11
22	RCDTS for Serving School	RCDTS for Serving School	[S_IL_STU_X]RCDTS_Serving_School [S_IL_SCH_X]RCDTS_Home_School	String	15
23	Delivery Due Date	Delivery Due Date	[S_IL_STU_Prenatal_C]DeliveryDueDate	String	10
24	Prenatal Care Start Trimester	Indicates Prenatal Care Start Trimester	[S_IL_STU_Prenatal_C]Care_Start_Trimester	String	2
25	Prenatal Services Start Date	Prenatal Services Start Date	[S_IL_STU_Prenatal_C]Services_Start_Date	String	10
26	Prenatal Services Exit Date	Prenatal Services Exit Date	[S_IL_STU_Prenatal_C]Exit_Date	String	10
27	Prenatal Services Exit Reason	Prenatal Services Exit Reason	[S_IL_STU_Prenatal_C]Exit_Reason	String	2
28	Delivery Date	Delivery Date	[S_IL_STU_Prenatal_C]Delivery_Date	String	10
29	Place of Delivery	Place of Delivery	[S_IL_STU_Prenatal_C]PlaceOfDelivery	String	2
30	City of Delivery	City of Delivery	[S_IL_STU_Prenatal_C]MotherDelivered_ChildCity	String	30
31	State of Delivery	State of Delivery	[S_IL_STU_Prenatal_C]MotherDelivered_ChildState	String	2
32	County of Delivery	County of Delivery	[S_IL_STU_Prenatal_C]CountyOfDelivery	String	3
33	Total Number of Birthed Children	Total Number of Birthed Children	[S_IL_STU_Prenatal_C]Number_Of_Birthed_Children	Numeric	2
34	Total Number of Home Visits During the Year	Total Number of Home Visits During the Year	[S_IL_STU_Prenatal_C]Total_No_HomeVisits	Numeric	2
35	Total Number of Parent Groups/Sessions Attended During the Year	Total Number of Parent Groups/Sessions Attended During the Year	[S_IL_STU_Prenatal_C]TotNo_ParentGrpsOrSess_Att	Numeric	2
36	Total Number of Doula Services Received During the Year	Total Number of Doula Services Received During the Year	[S_IL_STU_Prenatal_C]TotalNumberOfDoulaSessionsAttendedDuringTheYear	Numeric	2
37	Fiscal Year	Fiscal Year	[S_IL_STU_Prenatal_C]FiscalYear	Numeric	4
38	Result Code	N/A	N/A	String	2
39	Result Message	N/A	N/A	String	200