S_IL_STU_Prenatal_C (ver 20.5.2.0)
This table is a child of the [Students] table.
| Column Name | Version | Data Type | Description |
|---|---|---|---|
| ID | 20.5.2.0 | Number(10,0) | ID field of the extension table. |
| StudentsDCID | 20.5.2.0 | Number(10,0) | Primary key that relates this extended table back to the Students table. |
| Services_Start_Date | 20.5.2.0 | Date | The date the Prenatal Services started. |
| Due_Date | 20.5.2.0 | Date | The mother's due date. |
| Exit_Reason | 20.5.2.0 | Varchar2(2) | The reason the mother stopped prenatal care. |
| Exit_Date | 20.5.2.0 | Date | The date the mother stopped prenatal care. |
| Total_No_HomeVisits | 20.5.2.0 | Varchar2(3) | The total number of Home Visits during the year. |
| TotNo_ParentGrpsOrSess_Att | 20.5.2.0 | Varchar2(3) | The total number of Parent Groups or Sessions the mother attended during the year. |
| Number_Of_Birthed_Children | 20.5.2.0 | Varchar2(2) | The number of children to which the mother gave birth |
| MotherDelivered_Child | 20.5.2.0 | Varchar2(30) | Where the mother delivered the child. |
| MotherDelivered_ChildCity | 20.5.2.0 | Varchar2(30) | The town or city where the mother delivered the child. |
| MotherDelivered_ChildState | 20.5.2.0 | Varchar2(2) | The state where the mother delivered the child. |
| MotherDelivered_ChildCounty | 20.5.2.0 | Varchar2(30) | The county where the mother delivered the child. |
| Care_Start_Trimester | 20.5.2.0 | Varchar2(2) | The trimester in which the prenatal care started. |
| Delivery_Date | 20.5.2.0 | Date | The date the mother delivered the child. |
| Delivery_Place | 22.2.2.0 | Varchar2(2) | The place the mother delivered the child. |
| Delivery_County | 22.2.2.0 | Varchar2(3) | The county the mother delivered the child. |
| Doula_Received | 22.2.2.0 | Number(11) | The total number of Doula Services received during the year. |
| Fiscal_Year | 22.2.2.0 | Number(11) | Fiscal year. |