Table Detail Report
WHC_D_PERSON
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | WHC_D_PERSON |
Definition: | WHC Reporting - Dimension Table identifying the Mother and Child |
Table Type: | REFERENCE |
Column Detail - WHC_D_PERSON
Column Name | Type | Null? | Definition |
---|---|---|---|
MILL_PERSON_ID | DOUBLE | Y | Foreign key to PERSON.PERSON_ID, representing the corresponding patient in Millennium. |
PERSON_NAME | VARCHAR(255) | Y | Patient 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_PERSON_ID | DOUBLE | N | Primary Key |
Relationship Detail - WHC_D_PERSON
Parent Column in WHC_D_PERSON (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | WHC_D_PERSON_ID | WHC_F_CHILD | CHILD_ID |
WHC_F_CHILD | MOTHER_ID | ||
WHC_F_DELIVERY | MOTHER_ID | ||
WHC_F_DELIVERY_CHILD | CHILD_ID | ||
WHC_F_MOTHER_PREGNANCY | MOTHER_ID |
WHC_D_PERSONNEL
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | WHC_D_PERSONNEL |
Definition: | WHC Reporting - Dimension Table identifying all PERSONNEL involved in treatment of the Mother and Child during Pregnancy and Delivery. |
Table Type: | REFERENCE |
Column Detail - WHC_D_PERSONNEL
Column Name | Type | Null? | Definition |
---|---|---|---|
MILL_PERSON_ID | DOUBLE | Y | Foreign key to PRSNL.PERSON_ID, representing the corresponding member of personnel in Millennium. |
PRSNL_NAME | VARCHAR(255) | Y | Personnel 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_PERSONNEL_ID | DOUBLE | N | Primary Key |
Relationship Detail - WHC_D_PERSONNEL
Parent Column in WHC_D_PERSONNEL (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | WHC_D_PERSONNEL_ID | WHC_F_DELIVERY | ATTENDING_PHYSICIAN_ID |
WHC_F_DELIVERY_CHILD | ANESTHESIOLOGIST_ID | ||
WHC_F_DELIVERY_CHILD | ANESTHETIST_ID | ||
WHC_F_DELIVERY_CHILD | ASST_PHYSICIAN_1_ID | ||
WHC_F_DELIVERY_CHILD | ASST_PHYSICIAN_2_ID | ||
WHC_F_DELIVERY_CHILD | DELIVERY_CNM_ID | ||
WHC_F_DELIVERY_CHILD | DELIVERY_PEDIATRICIAN_ID | ||
WHC_F_DELIVERY_CHILD | DELIVERY_PHYSICIAN_ID | ||
WHC_F_DELIVERY_CHILD | DELIVERY_RN_1_ID | ||
WHC_F_DELIVERY_CHILD | DELIVERY_RN_2_ID | ||
WHC_F_DELIVERY_CHILD | RESUS_RN_1_ID | ||
WHC_F_DELIVERY_CHILD | SCRUB_TECHNICIAN_ID |
WHC_D_ROM
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | WHC_D_ROM |
Definition: | WHC Reporting - Dimension Table identifying Rupture of Membrane (ROM) type and associated Nomenclature |
Table Type: | REFERENCE |
Column Detail - WHC_D_ROM
Column Name | Type | Null? | Definition |
---|---|---|---|
MILL_NOMENCLATURE_ID | DOUBLE | Y | Foreign key to NOMENCLATURE.NOMENCLATURE_ID, represeting the corresponding 'Rupture of membranes' value in Millennium. |
ROM_TYPE_DESC | VARCHAR(255) | Y | User-readable description of 'Rupture of membranes' value, taken from the clinical result recorded against CKI CERNER!47715EC6-68B7-4A2A-94F4-EFC4F27C05AE. Accepted values are 'ARTIFICIAL RUPTURE', 'SPONTANEOUS RUPTURE'. |
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_ROM_ID | DOUBLE | N | Primary Key |
Relationship Detail - WHC_D_ROM
Parent Column in WHC_D_ROM (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | WHC_D_ROM_ID | WHC_F_DELIVERY_CHILD | ROM_ID |
WHC_D_TRANSACTION_PROFILE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | WHC_D_TRANSACTION_PROFILE |
Definition: | WHC Reporting - Dimension Table containing transaction profile Indicators |
Table Type: | REFERENCE |
Column Detail - WHC_D_TRANSACTION_PROFILE
Column Name | Type | Null? | Definition |
---|---|---|---|
COPD_PRESENT_IND | DOUBLE | Y | this indicator corresponds to the clinical result recorded against cki CERNER!7963B3E1-0F6C-40A0-AA21-4D57220CF9AE in associated delivery. 1 = an alpha-response of 'Cephalopelvic disproportion' is recorded against the C-section indication field. |
CORD_BLOOD_PH_DRAWN_IND | DOUBLE | Y | This indicator corresponds to the clinical result recorded against CKI CERNER!00B16C8B-7AB3-4E46-A569-CA61275B4416 for the associated delivery. 1 = cord blood pH drawn (any result recorded), 0 = cord blood PH not drawn (no result recorded). |
CSECTION_ELECTIVE_IND | DOUBLE | Y | NOT IMPLEMENTED AT THIS TIME |
CSECTION_EMERGENT_IND | DOUBLE | Y | NOT IMPLEMENTED AT THIS TIME |
FETALHEARTRATE_MON_IND | DOUBLE | Y | This indicator corresponds to the clinical result recorded against CKI CERNER!5F5D6B1C-C75E-48A7-A1A5-672942D2AD06 in the associated delivery. 1 = fetal heart rate was monitored (any result recorded), 0 = fetal heart rate was not monitored (no result recorded). |
FHR_MON_DUS_IND | DOUBLE | Y | this indicator corresponds to the clinical result recorded against cki cerner!5f5d6b1c-c75e-48a7-a1a5-672942d2ad06 in the associated delivery. 1 = fetal heart rate was using monitoring type Doppler Ultrasound, 0 fetal heart rate was not monitored using this specific monitoring type |
FHR_MON_FSE_IND | DOUBLE | Y | this indicator corresponds to the clinical result recorded against cki cerner!5f5d6b1c-c75e-48a7-a1a5-672942d2ad06 in the associated delivery. 1 = fetal heart rate was using monitoring type Fetal Scalp Electrode, 0 fetal heart rate was not monitored using this specific monitoring type |
FHR_MON_HHD_IND | DOUBLE | Y | this indicator corresponds to the clinical result recorded against cki cerner!5f5d6b1c-c75e-48a7-a1a5-672942d2ad06 in the associated delivery. 1 = fetal heart rate was using monitoring type Hand-held Doppler, 0 fetal heart rate was not monitored using this specific monitoring type |
FHR_MON_US_IND | DOUBLE | Y | this indicator corresponds to the clinical result recorded against cki cerner!5f5d6b1c-c75e-48a7-a1a5-672942d2ad06 in the associated delivery. 1 = fetal heart rate was using monitoring type Ultrasound, 0 fetal heart rate was not monitored using this specific monitoring type |
FORCEPS_USE_IND | DOUBLE | Y | Forceps Use indicator derived from WHC_F_DELIVERY_CHILD.FORCEPS_TYPE_DESC. If WHC_F_DELIVERY_CHILD.FORCEPS_TYPE_DESC is populated for any child delivered in associated pregnancy then this indicator is set to 1, if it is not then this indicator is set to 0. |
GEST_AGE_GRTR_37_IND | DOUBLE | Y | This indicator is populated with a 1 if, for any child delivered in associated pregnancy, the gestational age result (PREGNANCY_CHILD.GESTATION_AGE) is greater than 37 weeks. |
HISTORY_IND | DOUBLE | Y | History indicator is populated with a 1 if, for the associated pregnancy, the PREGNANCY_INSTANCE.HISTORICAL_IND is set to 1. |
MULTIPLE_GEST_IND | DOUBLE | Y | Multiple Gestation indicator is populated with a 1 if, for the associated pregnancy, there are multiple WHC_F_CHILD rows. |
PLACENTA_TO_PATHOLOGY_IND | DOUBLE | Y | This indicator corresponds to the clinical result recorded against CKI CERNER!26AE96BE-DD2A-4EA9-83E8-85A45AF7085C in the associated delivery. 1 = placenta sent to pathology (any result recorded), 0 = not sent (no result recorded). |
PRENATAL_CARE_IND | DOUBLE | Y | This indicator corresponds to the clinical result recorded against CKI CERNER!CE9ADF19-C172-45B2-82EF-001F40C85214 in the associated delivery. 1 = Prenatal Care (any result recorded except 'NONE'), 0 = No prenatal care (no result recorded or 'NONE' recorded). |
PRIMIP_IND | DOUBLE | Y | This field is populated with a 1 if WHC_F_MOTHER_PREGNANCY.PARA_NBR is 0 and WHC_F_MOTHER_PREGNANCY.GRAVIDA_NBR is 1 for the associated pregnancy. If the calculation results in anything else, than this field is populated with a 0. |
PROLONGED_LABOR_IND | DOUBLE | Y | This indicator corresponds to the clinical result recorded against CKI CERNER!F088C990-B188-42DE-8CD8-36D33FBC1E1A in the associated delivery. 1 = Prolonged Labor (any result recorded except 'NO'), 0 = No prolonged labor (no result recorded or 'NO' recorded). |
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. |
UTCON_MON_EXT_IND | DOUBLE | Y | this indicator corresponds to the clinical result recorded against cki cerner!ce2b6444-ef47-4242-974b-e3568b4eda6a in the associated delivery. 1 = uterine contraction was monitored using monitoring type External, 0 uterine contraction was not monitored using this specific monitoring type |
UTCON_MON_IUPC_IND | DOUBLE | Y | this indicator corresponds to the clinical result recorded against cki cerner!ce2b6444-ef47-4242-974b-e3568b4eda6a in the associated delivery. 1 = uterine contraction was monitored using monitoring type Intrauterine Pressure Catheter Placement, 0 uterine contraction was not monitored using this specific monitoring type |
UTCON_MON_PALP_IND | DOUBLE | Y | this indicator corresponds to the clinical result recorded against cki cerner!ce2b6444-ef47-4242-974b-e3568b4eda6a in the associated delivery. 1 = uterine contraction was monitored using monitoring type Palpation, 0 uterine contraction was not monitored using this specific monitoring type |
UTERINECONTRACTION_MON_IND | DOUBLE | Y | This indicator corresponds to the clinical result recorded against CKI CERNER!CE2B6444-EF47-4242-974B-E3568B4EDA6A in the associated delivery. 1 = uterine contraction was monitored (any result recorded), 0 = uterine contraction was not monitored (no result recorded). |
VACUUM_USE_IND | DOUBLE | Y | Vacuum Use indicator derived from WHC_F_DELIVERY.VACUUM_TYPE_DESC. If WHC_F_DELIVERY.VACUUM_TYPE_DESC is populated then this indicator is set to 1, if it is not then this indicator is set to 0. |
VAGINAL_BIRTH_AFTER_CS_IND | DOUBLE | Y | Indicator set to 1 if, for the associated millennium pregnancy, the clinical result recorded against cki cerner!0b07155e-2e5c-461f-ade6-cb5768257107(delivery type) represents vaginal birth and there exists a c-section type delivery recorded prior to contextual pregnancy. indicator is set to 0 if no vaginal birth delivery type was found for the contextual pregnancy or if no cesarean sections were ever performed.For historical pregnancy, this indicator is set to 1 if the delivery method is `VBAC¿ |
WHC_D_TRANSACTION_PROFILE_ID | DOUBLE | N | Primary Key |
Relationship Detail - WHC_D_TRANSACTION_PROFILE
Parent Column in WHC_D_TRANSACTION_PROFILE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | WHC_D_TRANSACTION_PROFILE_ID | WHC_F_CHILD | TRANSACTION_PROFILE_ID |
WHC_F_DELIVERY | TRANSACTION_PROFILE_ID | ||
WHC_F_DELIVERY_CHILD | TRANSACTION_PROFILE_ID | ||
WHC_F_MOTHER_PREGNANCY | TRANSACTION_PROFILE_ID |
WHC_D_UOM_TYPE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | WHC_D_UOM_TYPE |
Definition: | WHC Reporting - Dimension table identifying Unit of Measure Tye and associated Nomenclature |
Table Type: | REFERENCE |
Column Detail - WHC_D_UOM_TYPE
Column Name | Type | Null? | Definition |
---|---|---|---|
MILL_CODEVALUE_ID | DOUBLE | Y | This value comes from code_value.code_value, represeting the corresponding -unit of mesure type- value in millennium. |
UOM_DESC | VARCHAR(255) | Y | user-readable description of -Unit Of Measure Type- value |
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_UOM_TYPE_ID | DOUBLE | N | PRIMARY KEY |
Relationship Detail - WHC_D_UOM_TYPE
Parent Column in WHC_D_UOM_TYPE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | WHC_D_UOM_TYPE_ID | WHC_F_CHILD | ABDOMINAL_CIRCUMFRNCE_UOM_ID |
WHC_F_CHILD | BIRTH_HEIGHT_UOM_ID | ||
WHC_F_CHILD | BIRTH_WEIGHT_UOM_ID | ||
WHC_F_CHILD | CHEST_CIRCUMFERENCE_UOM_ID | ||
WHC_F_CHILD | HEAD_CIRCUMFERNENCE_UOM_ID | ||
WHC_F_DELIVERY | EBL_ANTEPARTUM_NBR_UOM_ID | ||
WHC_F_DELIVERY | EBL_DELIVERY_NBR_UOM_ID | ||
WHC_F_DELIVERY | EBL_POSTPART_NBR_UOM_ID |