Classic View: IL State Reporting > ISBE Extracts > Prenatal
Search Terms: ISBE Extracts
The ISBE Prenatal Extract reports students and non-students who have a Prenatal record. This is a district-wide extract; a calendar does not need to be selected in order to generate.
ISBE Prenatal Extract
Report Editor
The following fields are available for selection.
| Field | Description |
|---|---|
| Extract Type | Selection determines the extract that is generated. For this instance, select the Prenatal option. |
| Effective Date | Entered date is used to return current Prenatal Records for the report. This field automatically populates with the current date, but can be changed by entering a new date in mm/dd/yyyy format or by clicking the calendar icon to select a date. This date is required in order to generate the report.
|
| File Identifier | Indicates the number attached to the end of the file name and is used to differentiate the file from other files generated. |
| Strip Apostrophes | When marked, the following marks are removed from student names and other reported data:
When not marked, these marks are not removed. |
| Report Protected Identities | When marked, student identity information (last name, first name, etc.) reports from the Protected Identity Information fields. |
| Format | Determines how the report generates. Use the State Format (Comma Delimited) when submitting the report to the state. Use the HTML or Tab Delimited option when reviewing data prior to state submission. |
| Ad hoc | Select a saved ad hoc filter to use when generating this report. Only those students included in the filter will be returned on the report if they meet the reporting requirements. |
| Report Generation | The report can be generated immediately using the Generate Extract button. When there is a larger amount of data chosen (several calendars, large date range, etc.), use the Submit to Batch button, which allows the user to choose when the report is generated. See the Batch Queue article for more information. |
Generate the Report
- Select Prenatal from the Extract Type field.
- Enter the Effective Date for the report.
- Enter a File Identifier. This is a three digit number attached to the file name used to differentiate itself from other ISBE Demographic and Enrollment Extract files generated.
- Mark the Strip Apostrophes checkbox, if desired.
- If desired, mark the Report Protected Identities checkbox.
- Select which Format to generate the report in. To preview information prior to submission to the state, use the HTML format. When submitting data to the state, use the State Format (Comma Delimited).
- If desired, select an Ad hoc Filter from which to pull the student set.
- Select the Generate Extract button or use the Submit to Batch option. The report will appear in a separate window in the designated format.
ISBE Prenatal Extract - HTML Format
ISBE Prenatal Extract - State Format (Comma Delimited)
ISBE Prenatal Extract - Tab Delimited
Prenatal Extract Layout
Header Layout
Element | Description | Location |
|---|---|---|
Report Name | The name of the extract being generated. Always reports a value of Prenatal. | N/A |
Student Count | The total amount of records generated. | N/A |
File Name | EN + RCDT or District Name + _ + Date (mmddyyy)_File Identifier (i.e., Prenatal_310453000260_01302015_001.txt) | N/A |
Date | The date the extract was generated. | N/A |
RCDTS Code | The Region-County-District-Type-School code that uniquely identifies the school generating the extract. RRCCCDDDDDTTSSSS, 15 characters | System Administration > Resources > District Information > State District Number, Type, Region Number, County System Administration > Resources > School > State School Number District.districtID District.county District.region School.number |
Extract Layout
Element | Description | Location |
|---|---|---|
Prenatal ID | The identification number of the prenatal record. Numeric, 9 digits | Student Information > Program Participation > State Programs > Prenatal > Prenatal ID Prenatal.prenatalName |
Mother's Legal First Name | The student's legal first name. When the Report Protected Identities checkbox is marked on the report editor, the student's first name reports from the Legal First Name field if populated. Only alphabetical characters (A-Z) are reported; non-alphabetical characters are removed (apostrophes, hyphens, etc.). Alphabetical, 30 characters | Census > People > Identity Information > First Name Identity.firstName Census > People > Identities > Protected Identity Information > Legal First Name Identity.legalFirstName |
Mother's Legal Middle Name | The student's legal middle name. When the Report Protected Identities checkbox is marked on the report editor, the student's middle name reports from the Legal Middle Name field if populated. Only alphabetical characters (A-Z) are reported; non-alphabetical characters are removed (apostrophes, hyphens, etc.). Alphabetical, 30 characters | Census > People > Identity Information > Middle Name Identity.middleName Census > People > Identities > Protected Identity Information > Legal Middle Name Identity.legalMiddleName |
Mother's Legal Last Name | The student's legal last name. When the Report Protected Identities checkbox is marked on the report editor, the student's last name reports from the Legal Last Name field if populated. Only alphabetical characters (A-Z) are reported; non-alphabetical characters are removed (apostrophes, etc.). Alphabetical, 30 characters | Census > People > Identity Information > Last Name Identity.lastName Census > People > Identities > Protected Identity Information > Legal Last Name Identity.legalLastName |
Mother's Maiden Name | The student's mother's maiden name (used for eliminating multiples when matching). Only alphabetical characters (A-Z) are reported; non-alphabetical characters are removed (apostrophes, hyphens, etc.). Alphabetical, 30 characters | Census > People > Demographics > Person Information > Mother's Maiden Name Identity.motherMaidenName |
| Mother's Address | The student's current primary address. Alphanumeric, 50 characters | Census > People > Households > Address > Number, Tag, Street, Direction Address.number Address.street Address.tag Address.direction |
| City in which Mother Resides | The city of the mother's primary address. Alphanumeric, 30 characters | Census > People > Households > Address > City Address.city |
| Zip code of city in which mother resides | The first five digits of the student's primary address. Numeric, 5 digits | Census > People > Households > Address > Zip Address.zip |
| State name in which mother resides | Reports the current state in which the mother resides. Alphabetic, 2 characters | Census > People > Households > Address > State Address.state |
| Zip + 4 of city in which mother resides | The last four digits of the zip code of the student's primary address. Numeric, 4 digits | Census > People > Households > Address > Zip Address.zip |
| Contact telephone number area code for mother | The area code of the mother's phone number. Reports first from the cell phone; if not populated, reports from Other Phone, then Work Phone, then Pager. Numeric, 3 digits | Census > People > Demographics > Personal Contact Information > Cell Phone Contact.cellPhone |
| Contact telephone number prefix for mother | The prefix of the mother's phone number (three digits after the area code. Reports first from the cell phone; if not populated, reports from Other Phone, then Work Phone, then Pager. Numeric, 3 digits | Census > People > Demographics > Personal Contact Information > Cell Phone Contact.cellPhone |
| Contact telephone number suffix for mother | The last four digits of the mother's phone number (three digits after the area code. Reports first from the cell phone; if not populated, reports from Other Phone, then Work Phone, then Pager. Numeric, 4 digits | Census > People > Demographics > Personal Contact Information > Cell Phone Contact.cellPhone |
Date of Birth | The student's date of birth. Date field, 10 characters (MM/DD/YYYY) | Census > People > Demographics > Person Information > Birth Date Identity.birthDate |
| Marital Status of Mother | Indicates whether the student is married, has ever been married, etc. Numeric, 2 digits | Student Information > Program Participation > State Programs > Prenatal > Marital Status of Mother Prenatal.motherMaritalStatus |
Racial category which most clearly reflects the mother | The student's race ethnicity.
Numeric, 2 digits | Census > People > Demographics > Person Information > Race Ethnicity Identity.raceEthnicity |
RCDTS Home School | The Region-County-District-Type-School code that uniquely identifies the elementary, middle/junior, or high school the student attends or would attend if not placed/transferred to another school/program to receive needed services. If the mother is not a student and does not have an enrollment record, this reports from the Home School field on the Prenatal record. RRCCCDDDDDTTSSSS, 15 characters | Student Information > General > Enrollments > State Reporting Fields > Home School District.districtID District.county District.region School.number Enrollment.resident School Enrollment.resident District Student Information > Program Participation > State Programs > Prenatal > Home School Prenatal.homeSchool |
RCDTS Serving School | The Region-County-District-Type-School code that uniquely identifies the school/program where a student is being educated. If the mother is not a student and does not have an enrollment record, this reports from the Serving School field on the Prenatal record. RRCCCDDDDDTTSSSS, 15 characters | System Administration > Resources > District Information > State District Number, Type, Region Number, County System Administration > Resources > School > State School Number Student Information > General > Enrollment > State Reporting Fields > Home School, Home District District.districtID District.county District.region School.number Enrollment.serving School Student Information > Program Participation > State Programs > Prenatal > Serving School Prenatal.servingSchool |
| Date Prenatal Services Started | Reports the date the mother began receiving prenatal services. Date field, 10 characters (MM/DD/YYYY) | Student Information > Program Participation > State Programs > Prenatal > Prenatal Services Start Date Prenatal.startDate |
| Due Date | Reports the estimated due date of the baby. Date field, 10 characters (MM/DD/YYYY) | Student Information > Program Participation > State Programs > Prenatal > Delivery Due Date Prenatal.deliveryDueDate |
| Prenatal Exit Reason | Indicates the reason the mother stopped receiving prenatal services. Numeric, 2 digits | Student Information > Program Participation > State Programs > Prenatal > Prenatal Services Exit Reason Prenatal.exitReason |
| Exit Date | Reports the date the mother stopped receiving prenatal services. Date field, 10 characters (MM/DD/YYYY) | Student Information > Program Participation > State Programs > Prenatal > Prenatal Services Exit Date Prenatal.endDate |
| Total Number of Home Visits During the Year | Indicates the number of home visits the mother received during the year. Numeric, 3 digits | Student Information > Program Participation > State Programs > Prenatal > Number Home Visits in Year Prenatal.numHomeVisits |
| Total Number of Parent Groups or Sessions Attended During the Year | Indicates the number of parent groups the mother attended during the year. Numeric, 3 digits | Student Information > Program Participation > State Programs > Prenatal > Number Parent Groups in Year Prenatal.numParentGroups |
| Number of Birthed Children | Reports the total number of children the mother has. Numeric, 2 digits | Student Information > Program Participation > State Programs > Prenatal > Number of Birthed Children Prenatal.numBirthedChildren |
| Where mother delivered child | Indicates where the baby was delivered (hospital, at home, etc.). Alphanumeric, 30 characters | Student Information > Program Participation > State Programs > Prenatal > Place of Delivery Prenatal.placeOfDelivery |
| Town or city where mother delivered child | Indicates the city where the baby was delivered. Alphanumeric, 30 characters | Student Information > Program Participation > State Programs > Prenatal > Town or City of Delivery Prenatal.townOrCityOfDelivery |
| State where mother delivered child | Indicates the state in which the baby was delivered (IL, etc.). Alphabetic, 2 characters | Student Information > Program Participation > State Programs > Prenatal > State of Delivery Prenatal.stateOfDelivery |
| County where mother delivered child | Indicates the county in which the baby was delivered. Alphanumeric, 30 characters | Student Information > Program Participation > State Programs > Prenatal > County of Delivery Prenatal.countyOfDelivery |
| Prenatal care start Trimester | Indicates during which pregnancy trimester the mother began receiving services. Numeric, 2 digits | Student Information > Program Participation > State Programs > Prenatal > Prenatal Care Start Trimester Prenatal.prenatalCareStartTrimester |
| Delivery Date | Reports the actual delivery date of the baby. Date field, 10 characters (MM/DD/YYYY) | Student Information > Program Participation > State Programs > Prenatal > Actual Delivery Date Prenatal.actualDeliveryDate |
| Mother's SID | Reports the student ID of the mother. If the mother is not a student, this field reports blank. Numeric, 9 digits | Census > People > Demographics > Person Identifiers > State ID Person.studentStateID |
