Tool Search: 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.
Prenatal Extract - HTML Format
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 | District Information > State District Number, Type, Region Number, County School Information > 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 | State Programs > Prenatal > Prenatal ID Prenatal.prenatalName |
Mother's 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 | Demographics > Person Information > First Name Identity.firstName Identities > Protected Identity Information > Legal First Name Identity.legalFirstName |
Mother's 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 | Demographics > Person Information > Middle Name Identity.middleName Identities > Protected Identity Information > Legal Middle Name Identity.legalMiddleName |
Mother's 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 | Demographics > Person Information > Last Name Identity.lastName Identities > Protected Identity Information > Legal Last Name Identity.legalLastName |
Mother's Maiden Name | The 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 | Demographics > Person Information > Mother's Maiden Name Identity.motherMaidenName |
| Mother's Birthdate | The mother's date of birth. Date field, 10 characters (MM/DD/YYYY) | Census > People > Demographics > Person Information > Birth Date Identity.birthDate |
| Mother's SIS Student ID | Reports the mother's Student State ID, if availalb.e Otherwise, reports blank. | Demographics > Person Identifiers > Student State ID Person.stateID |
| Mother's Race | The student's race ethnicity.
Numeric, 2 digits | Demographics > Person Information > Race Ethnicity Identity.raceEthnicity |
| Mother's Marital Status | Indicates whether the student is married, has ever been married, etc. Numeric, 2 digits | Prenatal > Marital Status of Mother Prenatal.motherMaritalStatus |
| Mother's Education Received | Reports the assigned code indicating the mother's highest level of education received. Numeric, 2 digits | Prenatal > Mother's Education Received Prenatal.educationReceived |
| Mother's Employment Status | Reports the assigned code indicating the mother's current employment status. Numeric, 2 digits | Prenatal > Mother's Employment Status Prenatal.employmentStatus |
| Mother is Homeless | Reports a value of Yes when the student has an active homeless record for the selected enrollment. Otherwise, reports a value of No. Alphanumeric, 3 characters | Homeless > Start Date, End Date Homeless.startDate Homeless.endDate |
| Mother's Street Address | Reports the student's current primary address. Alphanumeric, 50 characters | Households > Address > Number, Tag, Street, Direction Address.number Address.street Address.tag Address.direction |
| Mother's City | Reports the city of the mother's primary address. Alphanumeric, 30 characters | Households > Address > City Address.city |
| Mother's Zip Code | Reports the first five digits of the student's primary address. Numeric, 5 digits | Households > Address > Zip Address.zip |
| Mother's Zip +4 | Reports the last four digits of the zip code of the student's primary address. Numeric, 4 digits | Households > Address > Zip Address.zip |
| Mother's County | Reportst the mother's county of resident. | Census > People > Households > Address > County Address.county |
| Mother's Phone Area Code | 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 |
| Mother's Phone Prefix | 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 |
| Mother's Phone Suffix | 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 |
| RCDT for Grantee | 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 for 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 |
| Delivery 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 Care Start Trimester | Indicates during which trimester the mother began receiving prenatal services. Numeric, 2 digits | Student Information > Program Participation > State Programs > Prenatal > Prenatal Care Start Trimester Prenatal.prenatalCareStartTrimester |
| Prenatal Services Start Date | Reports the date of when the mother began receiving prenatal services. Date field, 10 digits (MM/DD/YYYY) | Student Information > Program Participation > State Programs > Prenatal > Prenatal Care Start Date Prenatal.startDate |
| Prenatal Services Exit Date | Reports the date of when the mother stopped receiving prenatal services. Date field, 10 digits (MM/DD/YYYY) | Student Information > Program Participation > State Programs > Prenatal > Prenatal Care Start Date Prenatal.endDate |
| 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 |
| Delivery Date | Reports the date the mother gave birth. Date field, 10 digits (MM/DD/YYYY) | Student Information > Program Participation > State Programs > Prenatal > Actual Delivery Date Prenatal.deliveryDueDate |
| Place of Delivery | Reports the location of the delivery. Alphanumeric, 30 characters | Student Information > Program Participation > State Programs > Prenatal > Place of Delivery Prenatal.placeOfDelivery |
| City of Delivery | Reports the city of delivery. Alphanumeric, 30 characters | Student Information > Program Participation > State Programs > Prenatal > City of Delivery Prenatal.townOrCityOfDelivery |
| State of Delivery | Reports the State of Delivery. Alphanumeric, 2 characters | Student Information > Program Participation > State Programs > Prenatal > State of Delivery Prenatal.stateOfDelivery |
| County of Deliver | Reports the County of Delivery. Alphanumeric, 30 characters | Student Information > Program Participation > State Programs > Prenatal > City of Delivery Prenatal.countyOfDelivery |
| Total 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 |
| 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/ 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 |
| Total Number of Doula Services Received During the Year | Reports the total number of Doula services the mother received during the year. A Doula is a person who is trained to assist a woman during childbirth and who may provide support to the family after the baby is born. | Student Information > Program Participation > State Programs > Prenatal > Number of Doula Services Rec'd/Yr Prenatal.servicesReceived |
| Fiscal Year | Reports the fiscal year (July 1 to June 30) in which the baby was delivered. Numeric, 4 digits (XX-XX) | Student Information > Program Participation > State Programs > Prenatal > Fiscal Year Prenatal.endYear |
