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 |