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