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 |