Table Detail Report

WHC_F_CHILD



Column Section Relationship Section Top of Page


Table-level Detail

Description: WHC_F_CHILD
Definition: WHC Reporting - Fact Table containing data related to the CHILD
Table Type: ACTIVITY





Column Detail - WHC_F_CHILD


Column Name Type Null? Definition
ABDOMINAL_CIRCUMFERENCE_NBR DOUBLE Y Value of the clinical result recorded against CKI CERNER!1A272109-D817-4650-AA83-AC2AE218D594 for the associated child, representing Abdominal Circumference
ABDOMINAL_CIRCUMFRNCE_UOM_DESC VARCHAR(255) Y Description of the unit of measure corresponding to WHC_F_CHILD. ABDOMINAL_CIRCUMFERENCE_NBR, representing the Unit of Measurement for Abdominal Circumference
ABDOMINAL_CIRCUMFRNCE_UOM_ID DOUBLE Y Foreign key to whc_d_uom_type.whc_d_uom_type_id, representing the unit of mesure used for abdominal_circumference_nrb.
AMT_TIME_FOR_SKIN_SKIN_INI_MIN DOUBLE Y Value corresponding to the clinical result recroded against CKI CERNER!43811D11-9A98-4E88-B14B-13AE3D359883 for the associated child, representing the 'Amount of Time for Skin to Skin Contact'.
ANESTHESIA_GROUP_ID DOUBLE N Foreign key to WHC_D_ANESTHESIA_GROUP.ANESTHESIA_GROUP_ID, representing a combination of anesthesia types used during the delivery of the child in context.
APGAR_10_NBR DOUBLE Y value corresponding to the clinical result recorded against cki cerner!9900d029-8186-45d9-b9c6-49594e976ed2 for the associated child, representing the 'apgar score 10 minute'; -1 default for unrecorded score'
APGAR_15_NBR DOUBLE Y value corresponding to the clinical result recorded against cki cerner!b48bbcd8-68fe-40a2-9438-f158cd0caf7f for the associated child, representing the 'apgar score 15 minute'; -1 default for unrecorded score
APGAR_1_NBR DOUBLE Y value corresponding to the clinical result recorded against cki cerner!b6edb709-4db0-4718-b897-e198850fea3e for the associated child, representing the 'apgar score 1 minute'; -1 default for unrecorded score
APGAR_20_NBR DOUBLE Y value corresponding to the clinical result recorded against cki cerner!98807d2c-601b-4b4c-a685-68ace052748c for the associated child, representing the 'apgar score 20 minute'; -1 default for unrecorded score'
APGAR_5_NBR DOUBLE Y value corresponding to the clinical result recorded against cki cerner!a1eedca0-dd0b-4a6b-9381-e7492d5409b1 for the associated child, representing the 'apgar score 5 minute'; -1 default for unrecorded score'
BABY_LABEL VARCHAR(20) Y User-readable description of 'Baby' value, taken from the clinical result recorded against CKI CERNER!D895A6C5-57CA-4406-904E-DC967A1CD161.
BABY_MRN VARCHAR(50) Y Value of ENCNTR_ALIAS.ALIAS (of type 'MRN') for the associated child, representing the Medical Record Number of the child.
BIRTH_HEIGHT_NBR DOUBLE Y Value corresponding to the clinical result recorded against CKI CERNER!28B30F66-EEAF-4016-B0F5-100ECC928477 for the associated child, representing the 'Birth Length'.
BIRTH_HEIGHT_UOM_DESC VARCHAR(255) Y Description of the unit of measure correpsonding to WHC_F_CHILD.BIRTH_HEIGHT_NBR, representing the Unit of Measurement for Birth Height.
BIRTH_HEIGHT_UOM_ID DOUBLE Y Foreign key to whc_d_uom_type.whc_d_uom_type_id, representing the unit of mesure used for birth_height_nbr.
BIRTH_ORDER VARCHAR(10) Y NOT IMPLEMENTED AT THIS TIME
BIRTH_WEIGHT_NBR DOUBLE Y Value of PREGNANCY_CHILD.WEIGHT_AMT for the associated child representing the Birth Weight.
BIRTH_WEIGHT_UOM_DESC VARCHAR(255) Y Display value of PREGNANCY_CHILD.WEIGHT_UNIT_CD for the associated child, representing the Unit of Measurement for Birth Weight.
BIRTH_WEIGHT_UOM_ID DOUBLE Y Foreign key to whc_d_uom_type.whc_d_uom_type_id, representing the unit of mesure used for birth_weight_nbr.
CHEST_CIRCUMFERENCE_NBR DOUBLE Y Value of the clinical result recorded against CKI CERNER!71FDF27E-BB08-4C39-85DE-76662A6A1B53 for the associated child, representing Birth Chest Circumference.
CHEST_CIRCUMFERENCE_UOM_DESC VARCHAR(255) Y Description of the unit of measure correpsonding to WHC_F_CHILD.CHEST_CIRCUMFERENCE_NBR, representing the Unit of Measurement for Chest Circumference.
CHEST_CIRCUMFERENCE_UOM_ID DOUBLE Y Foreign key to whc_d_uom_type.whc_d_uom_type_id, representing the unit of mesure used for chest_circumference_nrb.
CHILD_BIRTH_DATE_NBR DOUBLE N Foreign key to OMF_DATE, corresponding to the clinical result recorded against CKI CERNER!ASYr9AEYvUr1YoPTCqIGfQ for the associated child. This CKI corresponds to the 'Date and Time of Birth' for the child.
CHILD_BIRTH_TIME_NBR DOUBLE N Foreign key to OMF_TIME, corresponding to the clinical result recorded against CERNER!ASYr9AEYvUr1YoPTCqIGfQ for the associated child. This CKI corresponds to the 'Date and Time of Birth' for the child.
CHILD_ID DOUBLE N Foreign key to WHC_D_PERSON.WHC_D_PERSON_ID for the associated child.
CHILD_TRANSFERED_TO_DESC VARCHAR(255) Y User-readable description of 'Transfer To/From' value, taken from the clinical result recorded against CKI CERNER!73F036A3-D3EB-46F8-8A58-47EA59F2DE1A for the associated child.
CORD_DESC VARCHAR(255) Y User-readable description of 'Umbilical Cord Description' value, taken from the clinical result recorded against CKI CERNER!DFC618AA-2F70-4E87-A410-882393B81262 for the associated child.
DELIVERY_TYPE_ID DOUBLE N Foreign key to WHC_D_DELIVERY_TYPE.WHC_D_DELIVERY_TYPE_ID, representing the delivery type for the associated child.
FETAL_COMPLICATION_GROUP_ID DOUBLE Y foreign key to whc_d_complication_group.whc_d_complication_group_id, representing a combination of fetal complication types for the child in context.
GESTATIONAL_AGE_BIRTH_NBR DOUBLE Y Value of PREGNANCY_CHILD.GESTATION_AGE for the associated child.
HEAD_CIRCUMFERENCE_NBR DOUBLE Y Value corresponding to the clinical result recorded against CKI CERNER!DF1F749C-6B87-4AC8-91FF-718C41678BC7 for the associated child, representing Birth Head Circumference.
HEAD_CIRCUMFERNENCE_UOM_DESC VARCHAR(255) Y Description of the unit of measure correpsonding to WHC_F_CHILD.HEAD_CIRCUMFERENCE_NBR, representing the Unit of Measurement for Head Circumference.
HEAD_CIRCUMFERNENCE_UOM_ID DOUBLE Y Foreign key to whc_d_uom_type.whc_d_uom_type_id, representing the unit of mesure used for head_circumference_nrb.
LABOR_DURATION_MINS DOUBLE Y Same value as for WHC_F_DELIVERY_CHILD.TOTAL_LENGTH_LABOR_MINS
MILL_PREGNANCY_ID DOUBLE N Foreign key to PREGNANCY_INSTANCE.PREGNANCY_ID, representing the corresponding pregnancy in Millennium.
MOTHER_ID DOUBLE N Foreign key to WHC_D_PERSON.WHC_D_PERSON_ID for the mother associated to the child on context.
NEONATE_ADMISSION_DATE_NBR DOUBLE N Foreign key to OMF_DATE corresponding to ENCOUNTER.REG_DT_TM for the associated child's encounter created after delivery (between delivery date time for the associated pregnancy and the pregnancy close date time).
NEONATE_ADMISSION_TIME_NBR DOUBLE N Foreign key to OMF_TIME corresponding to ENCOUNTER.REG_DT_TM for the associated child's encounter created after delivery (between delivery date time for the associated pregnancy and the pregnancy close date time).
NEONATE_COMPLICATION_DESC VARCHAR(255) Y User-readable description of 'Neonate Complications' value, taken from the clinical result recorded against CKI CERNER!07B2090C-7AE6-4E14-A702-C20EE3E7D4FD for the associated child.
NEONATE_COMPLICATION_GROUP_ID DOUBLE Y foreign key to whc_d_complication_group.whc_d_complication_group_id, representing a combination of neonatal complication types for the child in context.
NEONATE_DISCHARGE_DATE_NBR DOUBLE N Foreign key to OMF_DATE corresponding to ENCOUNTER.DISCH_DT_TM for the associated child's encounter created when the delivery took place (between delivery date time for the associated pregnancy and the pregnancy close date time).
NEONATE_DISCHARGE_TIME_NBR DOUBLE N Foreign key to OMF_TIME corresponding to ENCOUNTER.DISCH_DT_TM for the associated child's encounter created when the delivery took place (between delivery date time for the associated pregnancy and the pregnancy close date time).
NEONATE_IN_NURSERY_REQUESTS VARCHAR(255) Y User-readable description of 'Requests for Neonate in Nursery' value, taken from the clinical result recorded against CKI CERNER!CF2C6051-A4BE-4294-B7DE-F1E7A8C8D80F for the associated child.
NEONATE_OUTCOME_DESC VARCHAR(255) Y Display value of PREGNANCY_CHILD.NEONATE_OUTCOME_CD for the associated child, representing the outcome of the pregnancy for the child.
NEONATE_OUTPUT_DESC VARCHAR(255) Y User-readable description of 'Newborn Output' value, taken from the clinical result recorded against CKI CERNER!135F4B41-C499-4EFC-BE49-779D5C9CA487 for the associated child.
NEWBORN_INTAKE_TYPE_ID DOUBLE N Foreign key to WHC_D_INTAKE_TYPE.WHC_D_INTAKE_TYPE_ID, representing the intake type for the associated child.
NUCHAL_CORD_INTERVENTION_DESC VARCHAR(255) Y User-readable description of 'Nuchal Cord Interventions' value, taken from the clinical result recorded against CKI CERNER!16007E61-699F-478F-9FDC-8D66E3B880A1 for the associated child.
NUCHAL_CORD_TENSION_DESC VARCHAR(255) Y User-readable description of 'Nuchal Cord Tension' value, taken from the clinical result recorded against CKI CERNER!9746FC5D-DD49-4B55-8036-508FC5448833 for the associated child.
NUCHAL_CORD_TIMES_WRAPPED_NBR DOUBLE Y User-readable description of 'Nuchal Cord Times' value, taken from the clinical result recorded against CKI CERNER!BA37C2F7-8376-4D2F-B7F6-59B262E5FCB7 for the associated child.
ORGANIZATION_ID DOUBLE N Foreign key to WHC_F_ORGANIZATION.WHC_D_ORGANIZATION_ID, for the organization responsible for the child's care.
PRETERM_SS_DESC VARCHAR(255) Y Same value as for WHC_F_DELIVERY.PRETERM_SS_DESC
RESUS_AT_BIRTH_DESC VARCHAR(255) Y User-readable description of 'Resuscitation at Birth' value, taken from the clinical result recorded against CKI CERNER!932A8EBA-84AD-4412-8741-240A9810337E for the associated child.
SEX_OF_CHILD_DESC VARCHAR(40) Y User-readable description of 'Gender' value, taken from the clinical result recorded against CKI CERNER!ASYr9AEYvUr1YoQ0CqIGfQ for the associated child.
SKIN_SKIN_CONTCT_INT_DATE_NBR DOUBLE N Foreign key to OMF_DATE, corresponding to the clinical result recorded against CKI CERNER!E0522A70-AC79-4F21-A52D-A52155B7D727 for the associated child. This CKI corresponds to the 'Skin to Skin Contact Initiated' event date/time.
SKIN_SKIN_CONTCT_INT_TIME_NBR DOUBLE N Foreign key to OMF_TIME, corresponding to the clinical result recorded against CKI CERNER!E0522A70-AC79-4F21-A52D-A52155B7D727 for the associated child. This CKI corresponds to the 'Skin to Skin Contact Initiated' event date/time.
SPONTANEOUS_RESP_ONSET_DESC VARCHAR(255) Y User-readable description of 'Spontaneous Respirations Onset' value, taken from the clinical result recorded against CKI CERNER!27BFCBFC-17A7-4254-B2F0-530483CC8990 for the associated child.
TRANSACTION_PROFILE_ID DOUBLE N Foreign key to WHC_D_TRANSACTION_PROFILE.WHC_D_TRANSACTION_PROFILE_ID.
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_F_CHILD_ID DOUBLE N Primary Key



Relationship Detail - WHC_F_CHILD


Child Column in WHC_F_CHILD(FK) Parent Table Name Parent Column Name
Parents: CHILD_BIRTH_DATE_NBR OMF_DATE DT_NBR
NEONATE_ADMISSION_DATE_NBR OMF_DATE DT_NBR
NEONATE_DISCHARGE_DATE_NBR OMF_DATE DT_NBR
SKIN_SKIN_CONTCT_INT_DATE_NBR OMF_DATE DT_NBR
CHILD_BIRTH_TIME_NBR OMF_TIME MIN_NBR
NEONATE_ADMISSION_TIME_NBR OMF_TIME MIN_NBR
NEONATE_DISCHARGE_TIME_NBR OMF_TIME MIN_NBR
SKIN_SKIN_CONTCT_INT_TIME_NBR OMF_TIME MIN_NBR
ANESTHESIA_GROUP_ID WHC_D_ANESTHESIA_GROUP WHC_D_ANESTHESIA_GROUP_ID
FETAL_COMPLICATION_GROUP_ID WHC_D_COMPLICATION_GROUP WHC_D_COMPLICATION_GROUP_ID
NEONATE_COMPLICATION_GROUP_ID WHC_D_COMPLICATION_GROUP WHC_D_COMPLICATION_GROUP_ID
DELIVERY_TYPE_ID WHC_D_DELIVERY_TYPE WHC_D_DELIVERY_TYPE_ID
NEWBORN_INTAKE_TYPE_ID WHC_D_INTAKE_TYPE WHC_D_INTAKE_TYPE_ID
ORGANIZATION_ID WHC_D_ORGANIZATION WHC_D_ORGANIZATION_ID
CHILD_ID WHC_D_PERSON WHC_D_PERSON_ID
MOTHER_ID WHC_D_PERSON WHC_D_PERSON_ID
TRANSACTION_PROFILE_ID WHC_D_TRANSACTION_PROFILE WHC_D_TRANSACTION_PROFILE_ID
ABDOMINAL_CIRCUMFRNCE_UOM_ID WHC_D_UOM_TYPE WHC_D_UOM_TYPE_ID
BIRTH_HEIGHT_UOM_ID WHC_D_UOM_TYPE WHC_D_UOM_TYPE_ID
BIRTH_WEIGHT_UOM_ID WHC_D_UOM_TYPE WHC_D_UOM_TYPE_ID
CHEST_CIRCUMFERENCE_UOM_ID WHC_D_UOM_TYPE WHC_D_UOM_TYPE_ID
HEAD_CIRCUMFERNENCE_UOM_ID WHC_D_UOM_TYPE WHC_D_UOM_TYPE_ID


WHC_F_DELIVERY



Column Section Relationship Section Top of Page


Table-level Detail

Description: WHC_F_DELIVERY
Definition: WHC Reporting - Fact Table containing data related to the DELIVERY
Table Type: ACTIVITY





Column Detail - WHC_F_DELIVERY


Column Name Type Null? Definition
AMNIOINFUSION_IND DOUBLE Y Indicator dervied from the clinical result recorded against CKI CERNER!009994F5-3734-4358-96AC-89DD83D6744E for the associated delivery. 1 = Amnioinfusion procedure occurred (any result recorded), 0 = No amnioinfusion occurred (no result recorded).
ANESTHESIA_GROUP_ID DOUBLE N Foreign key to WHC_D_ANESTHESIA_GROUP.ANESTHESIA_GROUP_ID, representing a combination of anesthesia types used during the delivery in context.
ATTENDING_PHYSICIAN_ID DOUBLE N foreign key to whc_d_personnel.whc_d_personnel_id corresponding to the clinical result recorded against cki CERNER!B5FCA4F5-DCAC-4CF8-A3E2-941C08D8B725 for the associated delivery.
CMPLT_CERV_DIALTN_DATE_NBR DOUBLE N foreign key to omf_date corresponding to the clinical result recorded against cki CERNER!91F29C38-3415-4390-9FC4-95243AC9FF88 for the associated delivery. this cki corresponds to the date/time of complete cervical dilation.
CMPLT_CERV_DIALTN_TIME_NBR DOUBLE N foreign key to omf_time corresponding to the clinical result recorded against cki CERNER!91F29C38-3415-4390-9FC4-95243AC9FF88 for the associated delivery. this cki corresponds to the date/time of complete cervical dilation.
EBL_ANTEPARTUM_NBR DOUBLE Y Value corresponding to the clinical result recorded against CKI CERNER!B4BFD921-2555-467C-A4F5-D4BDE2A1D20D for the associated delivery, representing Estimated Blood Loss during antepartum.
EBL_ANTEPARTUM_NBR_UOM_ID DOUBLE N Foreign key to whc_d_uom_type.whc_d_uom_type_id, representing the unit of mesure used for EBL_ANTEPARTUM_NBR.
EBL_DELIVERY_NBR DOUBLE Y Value corresponding to the clinical result recorded against CKI CERNER!B86970CF-9387-4327-AD17-D301CC23C9C5 for the associated delivery, representing Estimated Blood Loss during delivery.
EBL_DELIVERY_NBR_UOM_ID DOUBLE N Foreign key to whc_d_uom_type.whc_d_uom_type_id, representing the unit of mesure used for EBL_DELIVERY_NBR.
EBL_POSTPART_NBR DOUBLE Y Value corresponding to the clinical result recorded against CKI CERNER!16B8456F-DF6B-42BC-A6F4-D3D89DFD9C7A for the associated delivery, representing Estimated Blood Loss during postpartum.
EBL_POSTPART_NBR_UOM_ID DOUBLE N Foreign key to whc_d_uom_type.whc_d_uom_type_id, representing the unit of mesure used for EBL_POSTPARTUM_NBR.
EPIDURAL_BOLUS_ANES_DATE_NBR DOUBLE N Foreign key to OMF_DATE corresponding to the clinical result recorded aginst CKI CERNER!818F94B7-6C9A-43D2-80AD-4C3C66D14803 for the associated delivery. This CKI corresponds to the documented date/time of the anesthesia bolus event for the epidural.
EPIDURAL_BOLUS_ANES_TIME_NBR DOUBLE N Foreign key to OMF_TIME corresponding to the clinical result recorded aginst CKI CERNER!818F94B7-6C9A-43D2-80AD-4C3C66D14803 for the associated delivery. This CKI corresponds to the documented date/time of the anesthesia bolus event for the epidural.
EPIDURAL_BOLUS_PATNT_DATE_NBR DOUBLE N Foreign key to OMF_DATE corresponding to the clinical result recorded against CKI CERNER!CB1C7F4D-EB51-4B99-B43E-25052ED8A80E for the associated delivery. This CKI corresponds to the documented date/time of administration of the epidural bolus.
EPIDURAL_BOLUS_PATNT_TIME_NBR DOUBLE N Foreign key to OMF_TIME corresponding to the clinical result recorded against CKI CERNER!CB1C7F4D-EB51-4B99-B43E-25052ED8A80E for the associated delivery. This CKI corresponds to the documented date/time of administration of the epidural bolus.
EPIDURAL_DISCONTINUED_DATE_NBR DOUBLE N Foreign key to OMF_DATE corresponding to the clinical result recorded against CKI CERNER!49D27EC1-2C38-4B02-99D5-E474F7088BF9 for the associated delivery. This CKI corresponds to the epidural discontinue event.
EPIDURAL_DISCONTINUED_TIME_NBR DOUBLE N Foreign key to OMF_TIME corresponding to the clinical result recorded against CKI CERNER!49D27EC1-2C38-4B02-99D5-E474F7088BF9 for the associated delivery. This CKI corresponds to the epidural discontinue event.
EPIDURAL_START_DATE_NBR DOUBLE N Foreign key to OMF_DATE corresponding to the clinical result recorded against CKI CERNER!CE9BF345-3B69-4EDD-A2EB-055F0015D322 for the associated delivery. This CKI corresponds to the start date/time of the epidural.
EPIDURAL_START_TIME_NBR DOUBLE N Foreign key to OMF_TIME corresponding to the clinical result recorded against CKI CERNER!CE9BF345-3B69-4EDD-A2EB-055F0015D322 for the associated delivery. This CKI corresponds to the start date/time of the epidural.
EPIDURAL_TEST_DOSE_DATE_NBR DOUBLE N Foreign key to OMF_DATE corresponding to the clinical result recorded against CKI CERNER!54E47121-0833-440C-A1C3-B70EB9F2EBE3 for the associated delivery. This CKI correspods to the date/time the test dose was administered.
EPIDURAL_TEST_DOSE_TIME_NBR DOUBLE N Foreign key to OMF_TIME corresponding to the clinical result recorded against CKI CERNER!54E47121-0833-440C-A1C3-B70EB9F2EBE3 for the associated delivery. This CKI correspods to the date/time the test dose was administered.
EPISIOTOMY_ID DOUBLE N Foreign key to WHC_D_EPISIOTOMY.WHC_D_EPISIOTOMTY_ID, representing information related to an episiotomy associated to this delivery (if one occurred).
EPISIOTOMY_IND DOUBLE N Indicator derived from the clinical result recorded against either CKI CERNER!A8A46491-3471-4255-BAB1-3A9FB88ECB78 (where the result if 'YES') or CKI CERNER!155683DF-B118-4C15-B603-B750F3A6515F (where the result if 'EPISIOTOMY'). 1 = Episiotomy ocured, 0 = Episiotomy didn't occur.
FETAL_POSITION_DESC VARCHAR(255) Y User-readable description of 'Fetal Presentation' value, taken from the clinical result recorded against CKI CERNER!752D42BB-AD4D-42F9-BA9D-3CB2198588BB for the associated delivery.
INDUCTION_REASON VARCHAR(255) Y User-readable description of 'Indications for Induction' value, taken from the clinical result recorded against CKI CERNER!DCFA6EC4-8DB5-4EDB-B519-DC1E2BF3BBB4 for the associated delivery.
LABOR_ONSET_DATE_NBR DOUBLE N Foreign key to OMF_DATE corresponding to the clinical result recorded against CKI CERNER!148690D8-2679-435F-AEE3-D5F7E601E4E0 for the associated delivery. This CKI corresponds to the labor onset date/time.
LABOR_ONSET_TIME_NBR DOUBLE N Foreign key to OMF_TIME corresponding to the clinical result recorded against CKI CERNER!148690D8-2679-435F-AEE3-D5F7E601E4E0 for the associated delivery. This CKI corresponds to the labor onset date/time.
LACERATION_ID DOUBLE N Foreign key to WHC_D_LACERATION.WHC_D_LACERATION_ID, representing information related to a laceration associated to this delivery (if one occurred).
MATERNAL_AGE_AT_DELIVERY DOUBLE Y Calculation which is equivalent to the following in YEARS: (Delivery_Date/Time - PERSON.BIRTH_DT_TM (corresponding to the person row for MOTHER_ID)
MATERNAL_COMPLICATION_DESC VARCHAR(255) Y User-readable description of 'Maternal Delivery Complications' value, taken from the clinical result recorded against CKI CERNER!2D13D00F-BFD4-44DA-BFC3-73392A695B93 for the associated delivery.
MATERNAL_COMPLICATION_GROUP_ID DOUBLE N foreign key to whc_d_complication_group.complication_group_id, representing a combination of complicaton types during the delivery in context.
MILL_ENCNTR_ID DOUBLE N This is a PK value from encounter.encntr_id, representing the underlying delivery encounter Millennium ID.
MILL_PREGNANCY_ID DOUBLE N Foreign key to PREGNANCY_INSTANCE.PREGNANCY_ID, representing the corresponding pregnancy in Millennium that the delivery in context is related to.
MOTHER_ID DOUBLE N Foreign key to WHC_D_PERSON.WHC_D_PERSON_ID for mother associated to the delivery in context.
MOTHER_TRANSFER_TO_DESC VARCHAR(255) Y User-readable description of 'Transfer To/From' value, taken from the clinical result recorded against CKI CERNER!05AADF41-79E7-4B96-A18F-5FC059CC280E for the associated mother.
ORGANIZATION_ID DOUBLE N Foreign key to WHC_F_ORGANIZATION.WHC_D_ORGANIZATION_ID, for the organization responsible for the mother's care during the delivery.
PERINEUM_INTACT_DESC VARCHAR(255) Y User-readable description of 'Perineum Intact' value, taken from the clinical result recorded against CKI CERNER!D344529E-FBC5-4E8D-99E1-C6195274F252 for the associated delivery.
PRESENTING_PART_DESC VARCHAR(255) Y user-readable description of -Presenting Part- of a baby / each baby during a delivery - value, taken from the clinical result recorded against cki CERNER!5E8EA222-CDC3-4297-B9CA-06165BB8FB69.
PRETERM_SS_DESC VARCHAR(255) Y User-readable description of 'Preterm Labor Signs/Symptoms' value, taken from the clinical result recorded against CKI CERNER!C8C52A77-D16A-465C-8247-C79AC31A82E3 for the associated delivery.
STAGE_1_OF_LABOR_IN_MIN DOUBLE Y Value corresponding to the clinical result recorded against CKI CERNER!ASYr9AEYvUr1YoPjCqIGfQ for the associated delivery, representing the length of labor, 1st Stage in minutes.
TOTAL_PRIOR_C_SECTION_NBR DOUBLE Y sum of all previous cesarean sections for the mother in context; for millennium pregnancies, calculated by counting clinical results recorded against cerner!0b07155e-2e5c-461f-ade6-cb5768257107 (for the mother in context), where the actual result pertains to cesarean section; for historical pregnancies, calculated by counting all values of delivery method where the value represents caesarean sections
TRANSACTION_PROFILE_ID DOUBLE N Foreign key to WHC_D_TRANSACTION_PROFILE.WHC_D_TRANSACTION_PROFILE_ID.
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_F_DELIVERY_ID DOUBLE N Primary Key



Relationship Detail - WHC_F_DELIVERY


Child Column in WHC_F_DELIVERY(FK) Parent Table Name Parent Column Name
Parents: CMPLT_CERV_DIALTN_DATE_NBR OMF_DATE DT_NBR
EPIDURAL_BOLUS_ANES_DATE_NBR OMF_DATE DT_NBR
EPIDURAL_BOLUS_PATNT_DATE_NBR OMF_DATE DT_NBR
EPIDURAL_DISCONTINUED_DATE_NBR OMF_DATE DT_NBR
EPIDURAL_START_DATE_NBR OMF_DATE DT_NBR
EPIDURAL_TEST_DOSE_DATE_NBR OMF_DATE DT_NBR
LABOR_ONSET_DATE_NBR OMF_DATE DT_NBR
CMPLT_CERV_DIALTN_TIME_NBR OMF_TIME MIN_NBR
EPIDURAL_BOLUS_ANES_TIME_NBR OMF_TIME MIN_NBR
EPIDURAL_BOLUS_PATNT_TIME_NBR OMF_TIME MIN_NBR
EPIDURAL_DISCONTINUED_TIME_NBR OMF_TIME MIN_NBR
EPIDURAL_START_TIME_NBR OMF_TIME MIN_NBR
EPIDURAL_TEST_DOSE_TIME_NBR OMF_TIME MIN_NBR
LABOR_ONSET_TIME_NBR OMF_TIME MIN_NBR
ANESTHESIA_GROUP_ID WHC_D_ANESTHESIA_GROUP WHC_D_ANESTHESIA_GROUP_ID
MATERNAL_COMPLICATION_GROUP_ID WHC_D_COMPLICATION_GROUP WHC_D_COMPLICATION_GROUP_ID
EPISIOTOMY_ID WHC_D_EPISIOTOMY WHC_D_EPISIOTOMY_ID
LACERATION_ID WHC_D_LACERATION WHC_D_LACERATION_ID
ORGANIZATION_ID WHC_D_ORGANIZATION WHC_D_ORGANIZATION_ID
MOTHER_ID WHC_D_PERSON WHC_D_PERSON_ID
ATTENDING_PHYSICIAN_ID WHC_D_PERSONNEL WHC_D_PERSONNEL_ID
TRANSACTION_PROFILE_ID WHC_D_TRANSACTION_PROFILE WHC_D_TRANSACTION_PROFILE_ID
EBL_ANTEPARTUM_NBR_UOM_ID WHC_D_UOM_TYPE WHC_D_UOM_TYPE_ID
EBL_DELIVERY_NBR_UOM_ID WHC_D_UOM_TYPE WHC_D_UOM_TYPE_ID
EBL_POSTPART_NBR_UOM_ID WHC_D_UOM_TYPE WHC_D_UOM_TYPE_ID


WHC_F_DELIVERY_CHILD



Column Section Relationship Section Top of Page


Table-level Detail

Description: WHC_F_DELIVERY_CHILD
Definition: WHC Reporting - Fact Table containing data related to the DELIVERY and CHILD
Table Type: ACTIVITY





Column Detail - WHC_F_DELIVERY_CHILD


Column Name Type Null? Definition
AMNIOTIC_FLUID_COLOR_DESC VARCHAR(255) Y Description corresponding to the clinical result recorded agaisnt CKI CERNER!2271786D-245C-448C-BD01-9D6AE23FA313 for the associated child.
ANESTHESIOLOGIST_ID DOUBLE N Foreign key to WHC_D_PERSONNEL.WHC_D_PERSONNEL_ID corresponding to the clinical result recorded against CKI CERNER!676B955C-EB41-4E5D-A847-08914BAD33AE for the associated child.
ANESTHETIST_ID DOUBLE N Foreign key to WHC_D_PERSONNEL.WHC_D_PERSONNEL_ID corresponding to the clinical result recorded against CKI CERNER!239377AD-E73F-4863-B341-D791662E4E2D for the associated child.
ASST_PHYSICIAN_1_ID DOUBLE N Foreign key to WHC_D_PERSONNEL.WHC_D_PERSONNEL_ID corresponding to the clinical result recorded against CKI CERNER!F585EADF-7F01-46CD-8D43-1C7B01C17592 for the associated child.
ASST_PHYSICIAN_2_ID DOUBLE N Foreign key to WHC_D_PERSONNEL.WHC_D_PERSONNEL_ID corresponding to the clinical result recorded against CKI CERNER!F585EADF-7F01-46CD-8D43-1C7B01C17592 for the associated child.
AUGMENT_METHOD_GROUP_ID DOUBLE N Foreign key to WHC_D_AUGMENT_METHOD_GROUP.WHC_D_AUGMENT_METHOD_GROUP_ID, representing a combination of augmentation methods used during the delivery of the child in context.
CHILD_ID DOUBLE N Foreign key to WHC_D_PERSON.WHC_D_PERSON_ID for the associated child.
CORD_BB_TO_LAB_IND DOUBLE Y This indicator corresponds to the clinical result recorded against CKI CERNER!6341CE73-C324-4B96-A633-89A3057DDB4E in the associated delivery of the child. 1 = Cord Blood sent to Lab (any result recorded except 'NO'), 0 = Cord blood not sent to Lab (no result recorded or 'NO' recorded).
CSECTION_INDCN_ID DOUBLE N Foreign key to WHC_D_CSECTION_INDCN.WHC_D_CSECTION_INDCN_ID, representing information related to a casearean section associated to the child in context (if one occurred for the child on context).
DELIVERY_CNM_ID DOUBLE N Foreign key to WHC_D_PERSONNEL.WHC_D_PERSONNEL_ID corresponding to the clinical result recorded against CKI CERNER!61327197-713E-43CE-904C-20C5C98DED1B for the associated child.
DELIVERY_DATE_NBR DOUBLE N Foreign key to OMF_DATE corresponding to the clinical result recorded against CKI CERNER!ASYr9AEYvUr1YoPTCqIGfQ for the associated child.
DELIVERY_PEDIATRICIAN_ID DOUBLE N Foreign key to WHC_D_PERSONNEL.WHC_D_PERSONNEL_ID corresponding to the clinical result recorded against CKI CERNER!ABEA0D57-6F36-4252-9338-C33C70C69978 for the associated child.
DELIVERY_PHYSICIAN_ID DOUBLE N Foreign key to WHC_D_PERSONNEL.WHC_D_PERSONNEL_ID corresponding to the clinical result recorded against CKI CERNER!148D82CA-6CCA-437C-818A-FC0BDE22EF2F for the associated child.
DELIVERY_RN_1_ID DOUBLE N Foreign key to WHC_D_PERSONNEL.WHC_D_PERSONNEL_ID corresponding to the clinical result recorded against CKI CERNER!7DC28206-7A88-4CC1-B53E-1C5C33DF9B9D for the associated child.
DELIVERY_RN_2_ID DOUBLE N Foreign key to WHC_D_PERSONNEL.WHC_D_PERSONNEL_ID corresponding to the clinical result recorded against CKI CERNER!7DC28206-7A88-4CC1-B53E-1C5C33DF9B9D for the associated child.
DELIVERY_TIME_NBR DOUBLE N Foreign key to OMF_TIME corresponding to the clinical result recorded against CKI CERNER!ASYr9AEYvUr1YoPTCqIGfQ for the associated child.
DELIVERY_TYPE_ID DOUBLE N Foreign key to WHC_D_DELIVERY_TYPE.WHC_D_DELIVERY_TYPE_ID, representing the delivery type for the associated child.
FORCEPS_TYPE_DESC VARCHAR(255) Y User-readable description of 'Forceps Type' value, taken from the clinical result recorded against CKI CERNER!AAAC3B27-F5EF-4455-B40F-BF6C8A82669A for the associated child.
INDUCTION_METHOD_GROUP_ID DOUBLE N Foreign key to WHC_D_INDCTN_METHOD_GROUP.WHC_D_INDCTN_METHOD_GROUP_ID, representing a combination of induction methods used during the delivery of the child in context.
LABOR_ONSET_METHOD_GROUP_ID DOUBLE N Foreign key to WHC_D_LABOR_ONS_MTHD_GROUP.WHC_D_LABOR_ONS_MTHD_GROUP_ID, representing a combination of labor onset methods used during the delivery of the child in context.
MILL_PREGNANCY_ID DOUBLE N Foreign key to PREGNANCY_INSTANCE.PREGNANCY_ID, representing the corresponding pregnancy in Millennium.
PLACENTA_DELIVERY_DATE_NBR DOUBLE N Foreign key to OMF_DATE corresponding to the clinical result recorded against CKI CERNER!DBCD00BD-E56D-4987-BDE4-FA7D0BA9449C for the child on context. This CKI corresponds to the placenta delivery event date/time.
PLACENTA_DELIVERY_METHOD_DESC VARCHAR(255) Y User-readable description of 'Placenta Delivery Method' value, taken from the clinical result recorded against CKI CERNER!EEA339C6-8E94-4037-A702-C69A942DBADD for the child in context.
PLACENTA_DELIVERY_TIME_NBR DOUBLE N Foreign key to OMF_TIME corresponding to the clinical result recorded against CKI CERNER!DBCD00BD-E56D-4987-BDE4-FA7D0BA9449C for the child on context. This CKI corresponds to the placenta delivery event date/time.
PRECIPITIOUS_LABOR_IND DOUBLE Y This indicator corresponds to the clinical result recorded against CKI CERNER!F37DB9C1-E43D-402C-B4A8-B90B0D943310 in the associated delivery of the child. 1 = Precipitious Labor (any result recorded except 'NO'), 0 = No precipitious labor (no result recorded or 'NO' recorded).
PROLONGED_ROM_IND DOUBLE Y This indicator corresponds to the clinical result recorded against CKI CERNER!433B91EB-1996-41A7-BE2C-01685AC84927 in the associated delivery of the child. 1 = Prolonged Rupture of Membranes (any result recorded except 'NO'), 0 = No prolonged ROM (no result recorded or 'NO' recorded).
RESUS_RN_1_ID DOUBLE N Foreign key to WHC_D_PERSONNEL.WHC_D_PERSONNEL_ID corresponding to the clinical result recorded against CKI CERNER!D216FB18-2E6A-4341-A200-D22811FDEC58 for the associated child.
ROM_DATE_NBR DOUBLE N Foreign key to OMF_DATE corresponding to the clinical result recorded against CKI CERNER!17A18CD6-CA24-4AC2-B80B-27B61A62D253 for the child on context. This CKI corresponds to the ROM event date/time.
ROM_ID DOUBLE N Foreign key to WHC_D_ROM.WHC_D_ROM_ID, representing the rupture of membranes for the associated child.
ROM_TIME_NBR DOUBLE N Foreign key to OMF_TIME corresponding to the clinical result recorded against CKI CERNER!17A18CD6-CA24-4AC2-B80B-27B61A62D253 for the child on context. This CKI corresponds to the ROM event date/time.
ROM_TO_DELIVERY_TIME_MINS DOUBLE Y Value corresponding to the clinical result recorded against CKI CERNER!7DB3D314-2095-485D-98B9-7E14FA4A1E5F for the child on context, representing the duration between Rupture of Membranes and Delivery in minutes.
SCRUB_TECHNICIAN_ID DOUBLE N Foreign key to WHC_D_PERSONNEL.WHC_D_PERSONNEL_ID corresponding to the clinical result recorded against CKI CERNER!263C8F20-C96A-45F8-99EB-BB7C964F8C3B for the associated child.
STAGE_2_OF_LABOR_IN_MIN DOUBLE Y Value corresponding to the clinical result recorded against CKI CERNER!ASYr9AEYvUr1YoPvCqIGfQ for the associated child, representing the length of labor, 2nd Stage in minutes.
STAGE_3_OF_LABOR_IN_MIN DOUBLE Y Value corresponding to the clinical result recorded against CKI CERNER!ASYr9AEYvUr1YoP7CqIGfQ for the associated child, representing the length of labor, 3rd Stage in minutes.
TOTAL_LENGTH_LABOR_MINS DOUBLE Y Calculation as follows: WHC_F_DELIVERY.STAGE_1_OF_LABOR_IN_MIN (from associated delivery) + WHC_F_DELIVERY_CHILD.STAGE_2_OF_LABOR_IN_MIN + WHC_F_DELIVERY_CHILD.STAGE_3_OF_LABOR_IN_MIN
TRANSACTION_PROFILE_ID DOUBLE N Foreign key to WHC_D_TRANSACTION_PROFILE.WHC_D_TRANSACTION_PROFILE_ID.
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.
VACUUM_TYPE_DESC VARCHAR(255) Y User-readable description of 'Vacuum Type' value, taken from the clinical result recorded against CKI CERNER!B0CEC3B2-1F85-4877-81C4-D33EB13C07B9 for the associated child.
WHC_F_DELIVERY_CHILD_ID DOUBLE N Primary Key



Relationship Detail - WHC_F_DELIVERY_CHILD


Child Column in WHC_F_DELIVERY_CHILD(FK) Parent Table Name Parent Column Name
Parents: DELIVERY_DATE_NBR OMF_DATE DT_NBR
PLACENTA_DELIVERY_DATE_NBR OMF_DATE DT_NBR
ROM_DATE_NBR OMF_DATE DT_NBR
DELIVERY_TIME_NBR OMF_TIME MIN_NBR
PLACENTA_DELIVERY_TIME_NBR OMF_TIME MIN_NBR
ROM_TIME_NBR OMF_TIME MIN_NBR
AUGMENT_METHOD_GROUP_ID WHC_D_AUGMENT_METHOD_GROUP WHC_D_AUGMENT_METHOD_GROUP_ID
CSECTION_INDCN_ID WHC_D_CSECTION_INDCN WHC_D_CSECTION_INDCN_ID
DELIVERY_TYPE_ID WHC_D_DELIVERY_TYPE WHC_D_DELIVERY_TYPE_ID
INDUCTION_METHOD_GROUP_ID WHC_D_INDCTN_METHOD_GROUP WHC_D_INDCTN_METHOD_GROUP_ID
LABOR_ONSET_METHOD_GROUP_ID WHC_D_LABOR_ONS_MTHD_GROUP WHC_D_LABOR_ONS_MTHD_GROUP_ID
CHILD_ID WHC_D_PERSON WHC_D_PERSON_ID
ANESTHESIOLOGIST_ID WHC_D_PERSONNEL WHC_D_PERSONNEL_ID
ANESTHETIST_ID WHC_D_PERSONNEL WHC_D_PERSONNEL_ID
ASST_PHYSICIAN_1_ID WHC_D_PERSONNEL WHC_D_PERSONNEL_ID
ASST_PHYSICIAN_2_ID WHC_D_PERSONNEL WHC_D_PERSONNEL_ID
DELIVERY_CNM_ID WHC_D_PERSONNEL WHC_D_PERSONNEL_ID
DELIVERY_PEDIATRICIAN_ID WHC_D_PERSONNEL WHC_D_PERSONNEL_ID
DELIVERY_PHYSICIAN_ID WHC_D_PERSONNEL WHC_D_PERSONNEL_ID
DELIVERY_RN_1_ID WHC_D_PERSONNEL WHC_D_PERSONNEL_ID
DELIVERY_RN_2_ID WHC_D_PERSONNEL WHC_D_PERSONNEL_ID
RESUS_RN_1_ID WHC_D_PERSONNEL WHC_D_PERSONNEL_ID
SCRUB_TECHNICIAN_ID WHC_D_PERSONNEL WHC_D_PERSONNEL_ID
ROM_ID WHC_D_ROM WHC_D_ROM_ID
TRANSACTION_PROFILE_ID WHC_D_TRANSACTION_PROFILE WHC_D_TRANSACTION_PROFILE_ID


WHC_F_MOTHER_PREGNANCY



Column Section Relationship Section Top of Page


Table-level Detail

Description: WHC_F_MOTHER_PREGNANCY
Definition: WHC Reporting - Fact Table containing data related to the MOTHER and the PREGNANCY
Table Type: ACTIVITY





Column Detail - WHC_F_MOTHER_PREGNANCY


Column Name Type Null? Definition
ABORH_DESC VARCHAR(255) Y NOT IMPLEMENTED AT THIS TIME
ADMIT_DATE_NBR DOUBLE N Foreign key to OMF_DATE, corresponding to ENCOUNTER.REG_DT_TM for the associated mother's encounter during which the delivery occurred.
ADMIT_TIME_NBR DOUBLE N Foreign key to OMF_TIME, corresponding to ENCOUNTER.REG_DT_TM for the associated mother's encounter during which the delivery occurred.
ANTEPARTUM_RISK_FACTORS_DESC VARCHAR(255) Y User-readable description of 'Risk Factors' value, taken from the clinical result recorded against CKI CERNER!28CD17AC-F1BD-4AE3-A9F6-1282F19618AB for the associated pregnancy.
BIRTH_PLAN_FEEDING_ID DOUBLE N Foreign key to WHC_D_INTAKE_TYPE.WHC_D_INTAKE_TYPE_ID, representing the planned intake type for the resultant child or children.
DIAGNOSIS_GROUP_ID DOUBLE N Foreign key to WHC_D_DIAGNOSIS_GROUP.WHC_D_DIAGNOSIS_GROUP_ID, representing a combination of diagnoses recorded against the mother within the specific context of the associated pregnancy.
DISCHARGE_DATE_NBR DOUBLE N Foreign key to OMF_DATE corresponding to ENCOUNTER.DISCH_DT_TM for the associated mother's last encounter within the pregnancy care episode.
DISCHARGE_TIME_NBR DOUBLE N Foreign key to OMF_TIME corresponding to ENCOUNTER.DISCH_DT_TM for the associated mother's last encounter within the pregnancy care episode.
ECTOPIC_PREG_HIST DOUBLE Y Value corresponding to the clinical result recorded against CKI CERNER!ASYr9AEYvUr1YoQHCqIGfQ, where the result was recorded between the previous pregnancy closure date to the current pregnancy closure date for the pregnancy in context.
ED_DATE_NBR DOUBLE Y Foreign key to OMF_DATE corresponding to the most recently entered value in PREGNANCY_ESTIMATE.EST_DELIVERY_DT_TM for the associated mother's pregnancy.
EGA_NBR DOUBLE Y Value of PREGNANCY_ESTIMATE.EST_GEST_AGE_DAYS for the associated pregnancy, representing the gestational age at birth for the last child delivered within the pregnancy for the mother.
GRAVIDA_NBR DOUBLE Y Value corresponding to the clinical result value recorded against CKI CERNER!AEO/PQD7LLZ5Xf6zn4waeg, where the result was recorded between the previous pregnancy closure date to the current pregnancy closure date for the pregnancy in context.
INDUCED_ABORT_PREG_HIST DOUBLE Y Value corresponding to the clinical result recorded against CKI CERNER!ASYr9AEYvUr1YoQlCqIGfQ, where the result was recorded between the previous pregnancy closure date to the current pregnancy closure date for the pregnancy in context.
MILL_PREGNANCY_ID DOUBLE N Foreign key to PREGNANCY_INSTANCE.PREGNANCY_ID, representing the corresponding pregnancy in Millennium.
MOTHER_ID DOUBLE N Foreign key to WHC_D_PERSON.WHC_D_PERSON_ID for the mother associated to the pregnancy in context.
MULTIPLE_BIRTHS DOUBLE Y Value corresponding to the clinical result recorded against CKI CERNER!C33FE830-5C65-4528-83F4-B32CB3C981BC, where the result was recorded between the previous pregnancy closure date to the current pregnancy closure date for the pregnancy in context
ORGANIZATION_ID DOUBLE N Foreign key to WHC_F_ORGANIZATION.WHC_D_ORGANIZATION_ID, for the organization responsible for the mother's care during the pregnancy.
PARA_ABORT_NBR DOUBLE Y Value corresponding to the clinical result recorded against CKI CERNER!AVdLiAEMseBG5YD5CqIGfQ, where the result was recorded between the previous pregnancy closure date to the current pregnancy closure date for the pregnancy in context.
PARA_LIVING_NBR DOUBLE Y Value corresponding to the clinical result recorded against CKI CERNER!ASYr9AEYvUr1YofDCqIGfQ, where the result was recorded between the previous pregnancy closure date to the current pregnancy closure date for the pregnancy in context.
PARA_NBR DOUBLE Y Value corresponding to the clinical result recorded against CKI CERNER!AEO/PQD7LLZ5Xf67n4waeg, where the result was recorded between the previous pregnancy closure date to the current pregnancy closure date for the pregnancy in context.
PARA_PRETERM_NBR DOUBLE Y Value corresponding to the clinical result recorded against CKI CERNER!AVdLiAEMseBG5YDtCqIGfQ, where the result was recorded between the previous pregnancy closure date to the current pregnancy closure date for the pregnancy in context.
PARA_TERM_NBR DOUBLE Y Value corresponding to the clinical result recorded against CKI CERNER!AVdLiAEMseBG5YDhCqIGfQ, where the result was recorded between the previous pregnancy closure date to the current pregnancy closure date for the pregnancy in context.
PREGNANCY_CLOSE_DATE_NBR DOUBLE Y Foreign key to OMF_date corresponding to PROBLEM.LIFE_CYCLE_DT_TM (in case populated for history pregnancy)/PREGNANCY_INSTANCE.PREG_END_DT_TM for the associated pregnancy representing Pregnancy Close Date.
PREGNANCY_CLOSE_TIME_NBR DOUBLE Y Foreign key to OMF_time corresponding to PROBLEM.LIFE_CYCLE_DT_TM (in case populated for history pregnancy)/PREGNANCY_INSTANCE.PREG_END_DT_TM for the associated pregnancy representing Pregnancy Close Time.
PREGNANCY_ONSET_DATE_NBR DOUBLE Y Foreign key to OMF_date corresponding to PROBLEM.ONSET_DT_TM (in case populated)/PREGNANCY_INSTANCE.PREG_START_DT_TM for the associated pregnancy representing Pregnancy Onset Date.
PREGNANCY_ONSET_TIME_NBR DOUBLE Y Foreign key to OMF_time corresponding to PROBLEM.ONSET_DT_TM (in case populated)/PREGNANCY_INSTANCE.PREG_START_DT_TM for the associated pregnancy representing Pregnancy Onset Time.
SPONTANEOUS_ABORT_PREG_HX DOUBLE Y Value corresponding to the clinical result recorded against CKI CERNER!ASYr9AEYvUr1YoQWCqIGfQ, where the result was recorded between the previous pregnancy closure date to the current pregnancy closure date for the pregnancy in context.
TRANSACTION_PROFILE_ID DOUBLE N Foreign key to WHC_D_TRANSACTION_PROFILE.WHC_D_TRANSACTION_PROFILE_ID.
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_F_MOTHER_PREGNANCY_ID DOUBLE N Primary Key



Relationship Detail - WHC_F_MOTHER_PREGNANCY


Child Column in WHC_F_MOTHER_PREGNANCY(FK) Parent Table Name Parent Column Name
Parents: ADMIT_DATE_NBR OMF_DATE DT_NBR
DISCHARGE_DATE_NBR OMF_DATE DT_NBR
ED_DATE_NBR OMF_DATE DT_NBR
PREGNANCY_CLOSE_DATE_NBR OMF_DATE DT_NBR
PREGNANCY_ONSET_DATE_NBR OMF_DATE DT_NBR
ADMIT_TIME_NBR OMF_TIME MIN_NBR
DISCHARGE_TIME_NBR OMF_TIME MIN_NBR
PREGNANCY_CLOSE_TIME_NBR OMF_TIME MIN_NBR
PREGNANCY_ONSET_TIME_NBR OMF_TIME MIN_NBR
DIAGNOSIS_GROUP_ID WHC_D_DIAGNOSIS_GROUP WHC_D_DIAGNOSIS_GROUP_ID
BIRTH_PLAN_FEEDING_ID WHC_D_INTAKE_TYPE WHC_D_INTAKE_TYPE_ID
ORGANIZATION_ID WHC_D_ORGANIZATION WHC_D_ORGANIZATION_ID
MOTHER_ID WHC_D_PERSON WHC_D_PERSON_ID
TRANSACTION_PROFILE_ID WHC_D_TRANSACTION_PROFILE WHC_D_TRANSACTION_PROFILE_ID