Table Detail Report
WHC_D_EPISIOTOMY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | WHC_D_EPISIOTOMY |
Definition: | WHC Reporting - Dimension Table identifying Episiotomy information at time of delivery |
Table Type: | REFERENCE |
Column Detail - WHC_D_EPISIOTOMY
Column Name | Type | Null? | Definition |
---|---|---|---|
EPISIOTOMY_DEGREE | VARCHAR(255) | Y | User-readable description of 'Epistiotomy degree' value, taken from clinical result recorded against CKI CERNER!93130FE6-0444-4DE2-90C4-DE2CD6A00493/CERNER!919A00D1-41C2-4717-99E5-1D7147DF69A8(free-text). |
EPISIOTOMY_LOCATION | VARCHAR(255) | Y | User-readable description of 'Episiotomy location' value, taken from clinical result recorded against CKI CERNER!9BA38221-D628-4E4B-9D8F-BF7FA6DA0E6F. |
MILL_EPI_DEGREE_NOMEN_ID | DOUBLE | Y | Foreign key to NOMENCLATURE.NOMENCLATURE_ID, represeting the corresponding 'Episiotomy degree' value in Millennium. |
MILL_EPI_LOCATION_NOMEN_ID | DOUBLE | Y | Foreign key to NOMENCLATURE.NOMENCLATURE_ID, represeting the corresponding 'Episiotomy location' value in Millennium. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
WHC_D_EPISIOTOMY_ID | DOUBLE | N | Primary Key |
Relationship Detail - WHC_D_EPISIOTOMY
Parent Column in WHC_D_EPISIOTOMY (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | WHC_D_EPISIOTOMY_ID | WHC_F_DELIVERY | EPISIOTOMY_ID |
WHC_D_INDCTN_METHOD_BRIDGE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | WHC_D_INDCTN_METHOD_BRIDGE |
Definition: | A Dimension Bridge table to allow the Fact table row to be associated to many Induction Method Dimensions |
Table Type: | REFERENCE |
Column Detail - WHC_D_INDCTN_METHOD_BRIDGE
Column Name | Type | Null? | Definition |
---|---|---|---|
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
WHC_D_INDCTN_METHOD_BRIDGE_ID | DOUBLE | N | Primary Key |
WHC_D_INDCTN_METHOD_GROUP_ID | DOUBLE | N | Foreign key to WHC_D_INDCTN_METHOD_GROUP.WHC_D_INDCTN_METHOD_GROUP_ID. |
WHC_D_INDUCTION_METHOD_ID | DOUBLE | N | Foreign key to WHC_D_INDUCTION_METHOD. WHC_D_INDUCTION_METHOD_ID . |
Relationship Detail - WHC_D_INDCTN_METHOD_BRIDGE
Child Column in WHC_D_INDCTN_METHOD_BRIDGE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | WHC_D_INDCTN_METHOD_GROUP_ID | WHC_D_INDCTN_METHOD_GROUP | WHC_D_INDCTN_METHOD_GROUP_ID |
WHC_D_INDUCTION_METHOD_ID | WHC_D_INDUCTION_METHOD | WHC_D_INDUCTION_METHOD_ID |
WHC_D_INDCTN_METHOD_GROUP
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | WHC_D_INDCTN_METHOD_GROUP |
Definition: | A Dimension Group table to allow the connection the Fact table row to many Induction Method Dimensions via the Bridge Table relationship |
Table Type: | REFERENCE |
Column Detail - WHC_D_INDCTN_METHOD_GROUP
Column Name | Type | Null? | Definition |
---|---|---|---|
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
WHC_D_INDCTN_METHOD_GROUP_ID | DOUBLE | N | Primary Key |
Relationship Detail - WHC_D_INDCTN_METHOD_GROUP
Parent Column in WHC_D_INDCTN_METHOD_GROUP (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | WHC_D_INDCTN_METHOD_GROUP_ID | WHC_D_INDCTN_METHOD_BRIDGE | WHC_D_INDCTN_METHOD_GROUP_ID |
WHC_F_DELIVERY_CHILD | INDUCTION_METHOD_GROUP_ID |
WHC_D_INDUCTION_METHOD
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | WHC_D_INDUCTION_METHOD |
Definition: | WHC Reporting - Dimension Table identifying Induction Method and associated Nomenclature |
Table Type: | REFERENCE |
Column Detail - WHC_D_INDUCTION_METHOD
Column Name | Type | Null? | Definition |
---|---|---|---|
INDUCTION_DESC | VARCHAR(255) | Y | User-readable description of 'Induction method' value, taken from clinical result recorded against CKI CERNER!4D713327-956D-46E5-893B-8DAFA44336FE. |
MILL_NOMENCLATURE_ID | DOUBLE | Y | Foreign key to NOMENCLATURE.NOMENCLATURE_ID, represeting the corresponding 'Induction method' value in Millennium. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
WHC_D_INDUCTION_METHOD_ID | DOUBLE | N | Primary Key |
Relationship Detail - WHC_D_INDUCTION_METHOD
Parent Column in WHC_D_INDUCTION_METHOD (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | WHC_D_INDUCTION_METHOD_ID | WHC_D_INDCTN_METHOD_BRIDGE | WHC_D_INDUCTION_METHOD_ID |
WHC_D_INTAKE_TYPE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | WHC_D_INTAKE_TYPE |
Definition: | WHC Reporting - Dimension Table identifying Intake Type (Feeding) information |
Table Type: | REFERENCE |
Column Detail - WHC_D_INTAKE_TYPE
Column Name | Type | Null? | Definition |
---|---|---|---|
FEEDING_DESC | VARCHAR(255) | Y | User-readable description of 'Newborn Intake' value, taken from the clinical result recorded against CKI CERNER!E3108DDF-A5DF-4CDD-BEBE-3D630E081472 (for child) and of 'Feeding Type Newborn' value, taken from the clinical result recorded against CKI CERNER!67FD02F4-5BA3-4EF2-9E3D-16CEB449F5EC (for mother). |
MILL_NOMENCLATURE_ID | DOUBLE | Y | Foreign key to NOMENCLATURE.NOMENCLATURE_ID, represeting the corresponding 'Intake type' value in Millennium. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
WHC_D_INTAKE_TYPE_ID | DOUBLE | N | Primary Key |
Relationship Detail - WHC_D_INTAKE_TYPE
Parent Column in WHC_D_INTAKE_TYPE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | WHC_D_INTAKE_TYPE_ID | WHC_F_CHILD | NEWBORN_INTAKE_TYPE_ID |
WHC_F_MOTHER_PREGNANCY | BIRTH_PLAN_FEEDING_ID |