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