ISBE Prenatal Extract (Illinois)

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.

FieldDescription
Extract TypeSelection 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.

  • If a Prenatal record has an end date before the effective date, that record is not included.
  • If a Prenatal record has an end date after the effective date or does not have an end date, that record is included.
File IdentifierIndicates 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:

  • Apostrophes ('), Commas (,), Periods (.)
  • Umlaut (Ö)
  • Tilde (Ñ)
  • Grave Accents (Ò), Acute Accents (Ó)
  • Circumflex (Ô)

When not marked, these marks are not removed.

Report Protected IdentitiesWhen marked, student identity information (last name, first name, etc.) reports from the Protected Identity Information fields.
FormatDetermines 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 hocSelect 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 GenerationThe 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

  1. Select Prenatal from the Extract Type field.
  2. Enter the Effective Date for the report.
  3. 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.
  4. Mark the Strip Apostrophes checkbox, if desired.
  5. If desired, mark the Report Protected Identities checkbox.
  6. 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).
  7. If desired, select an Ad hoc Filter from which to pull the student set.
  8. 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

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 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 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 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 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 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 IDReports the mother's Student State ID, if availalb.e Otherwise, reports blank.

Census > People > Demographics > Person Identifiers > Student State ID


Person.stateID

Mother's Race

The student's race ethnicity.
     
If the Is the Individual Hispanic/Latino? = Yes and all other race ethnicity checkboxes are NULL or No, a value of 11 is reported.
       
If the Is the Individual Hispanic/Latino? = Yes and any other race ethnicity checkbox is selected, a value of 11 is reported.
           
If the Is the Individual Hispanic/Latino? = No and any combination of two or more race ethnicity checkboxes are selected, a value of 17: Two or More Races is reported
       
If the Is the Individual Hispanic/Latino? = No and only one other race ethnicity checkbox is selected, the following is reported:

  • American Indian or Alaska Native = 12
  • Asian = 13
  • Black or African American = 14
  • Native Hawaiian or Other Pacific Islander = 15
  • White = 16

Numeric, 2 digits


Census > People > Demographics > Person Information > Race Ethnicity


Identity.raceEthnicity


Mother's Marital StatusIndicates 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
Mother's Education ReceivedReports the assigned code indicating the mother's highest level of education received.

Numeric, 2 digits
Student Information > Program Participation > State Programs > Prenatal > Mother's Education Received

Prenatal.educationReceived
Mother's Employment StatusReports the assigned code indicating the mother's current employment status.

Numeric, 2 digits
Student Information > Program Participation > State Programs > Prenatal > Mother's Employment Status

Prenatal.employmentStatus
Mother is HomelessReports 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
Student Information > Program Participation > Homeless > Start Date, End Date

Homeless.startDate
Homeless.endDate
Mother's Street AddressReports 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

Mother's CityReports the city of the mother's primary address.

Alphanumeric, 30 characters
Census > People > Households > Address > City

Address.city
Mother's Zip CodeReports the first five digits of the student's primary address.

Numeric, 5 digits
Census > People > Households > Address > Zip

Address.zip
Mother's Zip +4Reports the last four digits of the zip code of the student's primary address.

Numeric, 4 digits
Census > People > Households > Address > Zip

Address.zip
Mother's CountyReportst 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 DateReports 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 TrimesterIndicates 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 DateReports 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 DateReports 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 ReasonIndicates 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 DateReports 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 DeliveryReports the location of the delivery.

Alphanumeric, 30 characters
Student Information > Program Participation > State Programs > Prenatal > Place of Delivery

Prenatal.placeOfDelivery
City of DeliveryReports the city of delivery.

Alphanumeric, 30 characters
Student Information > Program Participation > State Programs > Prenatal > City of Delivery

Prenatal.townOrCityOfDelivery
State of DeliveryReports the State of Delivery.

Alphanumeric, 2 characters
Student Information > Program Participation > State Programs > Prenatal > State of Delivery

Prenatal.stateOfDelivery
County of DeliverReports the County of Delivery.

Alphanumeric, 30 characters
Student Information > Program Participation > State Programs > Prenatal > City of Delivery

Prenatal.countyOfDelivery
Total Number of Birthed ChildrenReports 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 YearIndicates 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 YearIndicates 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 YearReports 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 YearReports 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

Previous Version

ISBE Prenatal Extract (Illinois) [.2124 - .2219]