Table Detail Report

WHC_D_CSECTION_INDCN



Column Section Relationship Section Top of Page


Table-level Detail

Description: WHC_D_CSECTION_INDCN
Definition: WHC Reporting - Dimension Table identifying Csection Indication information and associated Nomenclature
Table Type: REFERENCE





Column Detail - WHC_D_CSECTION_INDCN


Column Name Type Null? Definition
CSECTION_INDICATION_DESC VARCHAR(255) Y User-readable description of 'C-section Indication' value, taken from the clinical result recorded against CKI CERNER!7963B3E1-0F6C-40A0-AA21-4D57220CF9AE.
MILL_NOMENCLATURE_ID DOUBLE N Foreign key to NOMENCLATURE.NOMENCLATURE_ID, represeting the corresponding 'C-section Indication' 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_CSECTION_INDCN_ID DOUBLE N Primary Key



Relationship Detail - WHC_D_CSECTION_INDCN




Parent Column in WHC_D_CSECTION_INDCN (PK) Child Table Name Child Column Name
Children: WHC_D_CSECTION_INDCN_ID WHC_F_DELIVERY_CHILD CSECTION_INDCN_ID


WHC_D_DELIVERY_TYPE



Column Section Relationship Section Top of Page


Table-level Detail

Description: WHC_D_DELIVERY_TYPE
Definition: WHC Reporting - Dimension Table identifying Delivery Type information and associated Nomenclature
Table Type: REFERENCE





Column Detail - WHC_D_DELIVERY_TYPE


Column Name Type Null? Definition
DELIVERY_TYPE_DESC VARCHAR(255) Y User-readable description of 'delivery type' value, taken from clinical result recorded against cki cerner!0b07155e-2e5c-461f-ade6-cb5768257107 for millennium pregnancy or delivery method' value recorded against pregnancy child record for historical pregnancy
MILL_CODEVALUE_ID DOUBLE N foreign key to code_value.code_value, represeting the corresponding 'delivery method' value in millennium.
MILL_NOMENCLATURE_ID DOUBLE Y Foreign key to NOMENCLATURE.NOMENCLATURE_ID, represeting the corresponding 'Delivery type' value in Millennium.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
WHC_D_DELIVERY_TYPE_ID DOUBLE N Primary Key



Relationship Detail - WHC_D_DELIVERY_TYPE




Parent Column in WHC_D_DELIVERY_TYPE (PK) Child Table Name Child Column Name
Children: WHC_D_DELIVERY_TYPE_ID WHC_F_CHILD DELIVERY_TYPE_ID
WHC_F_DELIVERY_CHILD DELIVERY_TYPE_ID


WHC_D_DIAGNOSIS



Column Section Relationship Section Top of Page


Table-level Detail

Description: WHC_D_DIAGNOSIS
Definition: WHC Reporting - Dimension Table identifying Diagnosis and associated Nomenclature
Table Type: REFERENCE





Column Detail - WHC_D_DIAGNOSIS


Column Name Type Null? Definition
DIAGNOSIS_DESC VARCHAR(255) N User-readable description of the diagnosis, retrieved by querying the diagnosis (by ENCOUNTER.encntr_id for the delivery encounter for associated pregnancy) and nomenclature (by DIAGNOSIS.NOMENCLATURE_ID) table for diagnosis_display or diag_ftdesc, and source_string, depending on the situation. If diagnosis_display is longer than 1 character use it, but if not, check if diag_ftdesc is longer than 1 character, and if that is not long enough, use the source_string from the nomenclature table.
MILL_NOMENCLATURE_ID DOUBLE Y Foreign key to NOMENCLATURE.NOMENCLATURE_ID, represeting the corresponding diagnosis 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_DIAGNOSIS_ID DOUBLE N Primary Key



Relationship Detail - WHC_D_DIAGNOSIS




Parent Column in WHC_D_DIAGNOSIS (PK) Child Table Name Child Column Name
Children: WHC_D_DIAGNOSIS_ID WHC_D_DIAGNOSIS_BRIDGE WHC_D_DIAGNOSIS_ID


WHC_D_DIAGNOSIS_BRIDGE



Column Section Relationship Section Top of Page


Table-level Detail

Description: WHC_D_DIAGNOSIS_BRIDGE
Definition: A Dimension Bridge table to allow the Fact table row to be associated to many Diagnosis Dimensions
Table Type: REFERENCE





Column Detail - WHC_D_DIAGNOSIS_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_DIAGNOSIS_BRIDGE_ID DOUBLE N Primary Key
WHC_D_DIAGNOSIS_GROUP_ID DOUBLE N Foreign key to WHC_D_DIAGNOSIS_GROUP.WHC_D_DIAGNOSIS_GROUP_ID.
WHC_D_DIAGNOSIS_ID DOUBLE N Foreign key to WHC_D_DIAGNOSIS.WHC_D_DIAGNOSIS_ID.



Relationship Detail - WHC_D_DIAGNOSIS_BRIDGE


Child Column in WHC_D_DIAGNOSIS_BRIDGE(FK) Parent Table Name Parent Column Name
Parents: WHC_D_DIAGNOSIS_ID WHC_D_DIAGNOSIS WHC_D_DIAGNOSIS_ID
WHC_D_DIAGNOSIS_GROUP_ID WHC_D_DIAGNOSIS_GROUP WHC_D_DIAGNOSIS_GROUP_ID


WHC_D_DIAGNOSIS_GROUP



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - WHC_D_DIAGNOSIS_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_DIAGNOSIS_GROUP_ID DOUBLE N Primary Key



Relationship Detail - WHC_D_DIAGNOSIS_GROUP




Parent Column in WHC_D_DIAGNOSIS_GROUP (PK) Child Table Name Child Column Name
Children: WHC_D_DIAGNOSIS_GROUP_ID WHC_D_DIAGNOSIS_BRIDGE WHC_D_DIAGNOSIS_GROUP_ID
WHC_F_MOTHER_PREGNANCY DIAGNOSIS_GROUP_ID