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 |