Table Detail Report

WHC_D_LABOR_ONSET_METHOD



Column Section Relationship Section Top of Page


Table-level Detail

Description: WHC_D_LABOR_ONSET_METHOD
Definition: WHC Reporting - Dimension Table identifying Labor Onset and associated Nomenclature
Table Type: REFERENCE





Column Detail - WHC_D_LABOR_ONSET_METHOD


Column Name Type Null? Definition
LABOR_ONSET_DESC VARCHAR(255) Y User-readable description of 'Labor onset method' value, taken from the clinical result recorded against CKI CERNER!F4497987-EBEA-452A-8E7A-E9A11D9B0C63.
MILL_NOMENCLATURE_ID DOUBLE Y Foreign key to NOMENCLATURE.NOMENCLATURE_ID, represeting the corresponding 'Labor onset 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_LABOR_ONSET_METHOD_ID DOUBLE N Primary Key



Relationship Detail - WHC_D_LABOR_ONSET_METHOD




Parent Column in WHC_D_LABOR_ONSET_METHOD (PK) Child Table Name Child Column Name
Children: WHC_D_LABOR_ONSET_METHOD_ID WHC_D_LABOR_ONS_MTHD_BRIDGE WHC_D_LABOR_ONSET_METHOD_ID


WHC_D_LABOR_ONS_MTHD_BRIDGE



Column Section Relationship Section Top of Page


Table-level Detail

Description: WHC_D_LABOR_ONS_MTHD_BRIDGE
Definition: A Dimension Bridge table to allow the Fact table row to be associated to many Labor Onset Dimensions
Table Type: REFERENCE





Column Detail - WHC_D_LABOR_ONS_MTHD_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_LABOR_ONSET_METHOD_ID DOUBLE N Foreign key to WHC_D_LABOR_ONSET_METHOD. WHC_D_LABOR_ONSET_METHOD_ID .
WHC_D_LABOR_ONS_MTHD_BRIDGE_ID DOUBLE N Primary Key
WHC_D_LABOR_ONS_MTHD_GROUP_ID DOUBLE N Foreign key to WHC_D_LABOR_ONS_MTHD_GROUP.WHC_LABOR_ONS_MTHD_GROUP_ID.



Relationship Detail - WHC_D_LABOR_ONS_MTHD_BRIDGE


Child Column in WHC_D_LABOR_ONS_MTHD_BRIDGE(FK) Parent Table Name Parent Column Name
Parents: WHC_D_LABOR_ONSET_METHOD_ID WHC_D_LABOR_ONSET_METHOD WHC_D_LABOR_ONSET_METHOD_ID
WHC_D_LABOR_ONS_MTHD_GROUP_ID WHC_D_LABOR_ONS_MTHD_GROUP WHC_D_LABOR_ONS_MTHD_GROUP_ID


WHC_D_LABOR_ONS_MTHD_GROUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: WHC_D_LABOR_ONS_MTHD_GROUP
Definition: A Dimension Group table to allow the connection the Fact table row to many Labor Onset Dimensions via the Bridge Table relationship
Table Type: REFERENCE





Column Detail - WHC_D_LABOR_ONS_MTHD_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_LABOR_ONS_MTHD_GROUP_ID DOUBLE N Primary Key



Relationship Detail - WHC_D_LABOR_ONS_MTHD_GROUP




Parent Column in WHC_D_LABOR_ONS_MTHD_GROUP (PK) Child Table Name Child Column Name
Children: WHC_D_LABOR_ONS_MTHD_GROUP_ID WHC_D_LABOR_ONS_MTHD_BRIDGE WHC_D_LABOR_ONS_MTHD_GROUP_ID
WHC_F_DELIVERY_CHILD LABOR_ONSET_METHOD_GROUP_ID


WHC_D_LACERATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: WHC_D_LACERATION
Definition: WHC Reporting - Dimension Table identifying Laceration information at time of delivery
Table Type: REFERENCE





Column Detail - WHC_D_LACERATION


Column Name Type Null? Definition
LACERATION_DEGREE VARCHAR(255) Y User-readable description of 'Laceration degree' value, taken from clinical result recorded against CKI CERNER!AF0246A9-BE66-4EB2-978F-C2090B8AAE2F.
LACERATION_LOCATION VARCHAR(255) Y User-readable description of 'Laceration location' value, taken from clinical result recorded against CKI CERNER!EC433F99-663D-4A9C-92F2-09D6AB766188.
LACERATION_REPAIR VARCHAR(255) Y User-readable description of 'Laceration repair' value, taken from clinical result recorded against CKI CERNER!7A835932-1863-408C-A379-FAFCB64788C3.
MILL_LAC_DEGREE_NOMEN_ID DOUBLE Y Foreign key to NOMENCLATURE.NOMENCLATURE_ID, represeting the corresponding 'Laceration degree' value in Millennium.
MILL_LAC_LOCATION_NOMEN_ID DOUBLE Y Foreign key to NOMENCLATURE.NOMENCLATURE_ID, represeting the corresponding 'Laceration location' value in Millennium.
MILL_LAC_REPAIR_NOMEN_ID DOUBLE Y Foreign key to NOMENCLATURE.NOMENCLATURE_ID, represeting the corresponding 'Laceration repair' 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_LACERATION_ID DOUBLE N Primary Key



Relationship Detail - WHC_D_LACERATION




Parent Column in WHC_D_LACERATION (PK) Child Table Name Child Column Name
Children: WHC_D_LACERATION_ID WHC_F_DELIVERY LACERATION_ID


WHC_D_ORGANIZATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: WHC_D_ORGANIZATION
Definition: WHC Reporting - Dimension Table identifying the Organization where birth occurred
Table Type: REFERENCE





Column Detail - WHC_D_ORGANIZATION


Column Name Type Null? Definition
MILL_ORGANIZATION_ID DOUBLE Y Foreign key to ORGANIZATION.ORGANIZATION_ID, represeting the corresponding organization in Millennium.
ORGANIZATION_NAME VARCHAR(255) Y Organization name
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_ORGANIZATION_ID DOUBLE N Primary Key



Relationship Detail - WHC_D_ORGANIZATION




Parent Column in WHC_D_ORGANIZATION (PK) Child Table Name Child Column Name
Children: WHC_D_ORGANIZATION_ID WHC_F_CHILD ORGANIZATION_ID
WHC_F_DELIVERY ORGANIZATION_ID
WHC_F_MOTHER_PREGNANCY ORGANIZATION_ID