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. |