Table Detail Report

UKRWH_MSDS_DETAILS



Column Section Top of Page


Table-level Detail

Description: UKRWH_MSDS_DETAILS
Definition: Contains pregnancy, fetus and birth activity details from NHS Maternity Services Data Set.
Table Type: ACTIVITY





Column Detail - UKRWH_MSDS_DETAILS


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
EXTRACT_DT_TM DATETIME Y Date and Time of when extract was created.
FIRST_PROCESS_DT_TM DATETIME Y First date/time row was inserted into table.
HEALTH_SYSTEM_ID DOUBLE N Unique number assigned by Health Facts. Typically the universal Cerner assigned client id of the health system.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Unique number assigned by Health Facts. Typically the universal Cerner assigned client id of the sending health system but may be adjusted if there is >1 HF feed from the client.
LAST_PROCESS_DT_TM DATETIME Y Last date/time row was updated.
LOC_MSDS_VALUE_IN_DT_TM DATETIME Y Value in date and time converted to local datetime.
MSDS_DETAILS_SEQUENCE DOUBLE Y Sequence of occurrence.
MSDS_ELEMENT VARCHAR(100) Y Maternity Services Data Set element Description.
MSDS_ELEMENT_GROUP_DESC VARCHAR(100) Y Maternity Services Data Set (MSDS) group element description.
MSDS_ELEMENT_GROUP_NO VARCHAR(20) Y Maternity Services Data Set (MSDS) group element number.
MSDS_PARENT_ELEMENT_DESC VARCHAR(100) Y Maternity Services Data Set (MSDS) parent element description.
MSDS_PARENT_ELEMENT_NO VARCHAR(20) Y Maternity Services Data Set (MSDS) parent element number.
MSDS_VALUE VARCHAR(100) Y Value of Maternity Services Data Set (MSDS) element.
MSDS_VALUE_IN_NBR DOUBLE Y Value in number.
MSDS_VALUE_IN_NHS VARCHAR(100) Y Value in NHS reference code.
MSDS_VALUE_TYPE_DESC VARCHAR(100) Y Reference value type description - NHS reference code, Number, Date or String.
PARENT_ENTITY_KEY DOUBLE Y PIEDW system generated unique identifier for a pregnancy or fetus.
PARENT_ENTITY_NAME VARCHAR(100) Y Parent type of entity - pregnancy or fetus.
PARENT_ENTITY_SK VARCHAR(40) Y Millennium system generated unique identifier for a pregnancy or fetus.
TOTAL_UPDATES DOUBLE Y The numbers of updates that have occurred on this table.
UKRWH_MSDS_DETAILS_KEY DOUBLE N Unique generated number that identifies a single row on the UKRWH_MSDS_DETAILS table.
UPDT_CNT DOUBLE Y 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 Y The date and time the row was last inserted or updated.
UPDT_TASK VARCHAR(40) Y The registered (assigned) task number for the process that inserted or updated the row.
UPDT_USER VARCHAR(40) Y The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.


UKRWH_MSDS_FETUS



Column Section Top of Page


Table-level Detail

Description: UKRWH_MSDS_FETUS
Definition: Contains fetus and birth details from NHS Maternity Services Data Set.
Table Type: ACTIVITY





Column Detail - UKRWH_MSDS_FETUS


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ACT_DEL_PLACE_TYPE_NHS VARCHAR(10) Y The NHS code for the actual place type of delivery.
ACT_DEL_SITE_CODE_NACS VARCHAR(10) Y The Organisation Site Code of the Organisation where the baby was delivered as part of a Maternity Episode.
ACT_DEL_WARD_TYPE_NHS VARCHAR(10) Y The NHS code of midwife unit or ward type of the actual place of delivery for the registrable birth.
APGAR_SCORE_AT_5MIN VARCHAR(10) Y The Apgar score at five minutes after birth. The Apgar Score is determined by evaluating the newborn baby on five criteria (Appearance, Pulse, Grimace, Activity and Respiration) on a scale from zero to two, then summing up the values obtained. The resulting Apgar Score ranges from zero to ten.
BABY_PHENOT_SEX_NHS VARCHAR(10) Y The NHS code for classification of person (Baby) phenotypic sex.
BIRTH_ORDER_NBR DOUBLE Y The sequence in which the baby was born, with 1 indicating the first or only birth in the sequence (i.e. singleton), 2 indicating the second birth in the sequence, 3 indicating the third, etc.
BIRTH_WEIGHT VARCHAR(10) Y The birth weight where the unit of measurement is grams (g).
DEL_IN_WATER_IND VARCHAR(10) Y An indication of whether the registrable birth was delivered in a birthing pool.
DEL_METHOD_NHS VARCHAR(10) Y The NHS delivery method code for the current baby.
DIS_BFEEDING_STATUS_NHS VARCHAR(10) Y The breastfeeding status recorded at the discharge date time (mother post delivery hospital provider spell).
EXTRACT_DT_TM DATETIME Y Date and Time of when extract was created.
FETUS_ORDER_NBR DOUBLE Y The outcome of a fetus episode for the current maternity episode.
FIRST_FEED_BM_STATUS_NHS VARCHAR(10) Y The type of breast milk a baby receives for a Baby First Feed.
FIRST_PROCESS_DT_TM DATETIME Y The date/time that the first ETL process started that created this record.
GEST_AGE_AT_BIRTH VARCHAR(40) Y Gestation length in days at the person birth date of the registrable birth.
HEALTH_SYSTEM_ID DOUBLE N Unique number assigned by Health Facts. Typically the universal Cerner assigned client id of the health system.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Unique number assigned by Health Facts. Typically the universal Cerner assigned client id of the sending health system but may be adjusted if there is >1 HF feed from the client.
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LOCAL_PATIENT_IDENT VARCHAR(40) Y The Local Patient Identifier of the baby.
LOCAL_PATIENT_IDENT_MUM VARCHAR(40) Y The Local Patient Identifier of the mother in a maternity episode.
LOC_BABY_BIRTH_DT_TM DATETIME Y Date and time of birth of the baby converted to local datetime.
LOC_BABY_DEATH_DT_TM DATETIME Y Person death date and time converted to local datetime for a baby (registrable birth), if the child died within 28 days after the Person Birth Date (Baby).
LOC_FIRST_ANTE_APP_DT_TM DATETIME Y The date converted to local datetime on which the pregnant woman was assessed and arrangements made for antenatal care as part of the Pregnancy Episode. This is not necessarily the occasion on which arrangements were made for delivery.
LOC_FIRST_FEED_DT_TM DATETIME Y The start date and time of a baby first feed converted to local datetime.
LOC_PREG_OUTCOME_DT_TM DATETIME Y Date and Time of the pregnancy outcome for the current Fetus.
NHS_NBR_IDENT VARCHAR(40) Y The NHS Number of the baby.
NHS_NBR_STATUS_NHS VARCHAR(10) Y The NHS status indicator code of the NHS Number (Baby).
PCT_MRN_NACS VARCHAR(10) Y The Organisation Code of the Organisation that assigned the Local Patient Identifier (Baby).
PREGNANCY_FETUS_SK VARCHAR(40) Y Millennium Pregnancy Identifier with fetus order number to link fetus with registrable birth.
PREGNANCY_SK VARCHAR(40) Y Millennium system generated unique identifier for a pregnancy.
PREG_FETUS_OUTCOME_NHS VARCHAR(10) Y The NHS code for pregnancy outcome of a fetus episode for the current maternity episode.
SKIN_TO_SKIN_1HR_IND VARCHAR(10) Y An indication of whether skin to skin contact was made between mother and baby within one hour of delivery of the baby, following Labour and Delivery.
TOTAL_UPDATES DOUBLE Y The numbers of updates that have occurred on this table.
UKRWH_MSDS_FETUS_KEY DOUBLE N Unique generated number that identifies a single row on the UKRWH_MSDS_FETUS table.
UKRWH_MSDS_PREG_KEY DOUBLE N Unique generated number that identifies a single row on the UKRWH_MSDS_PREGNANCY table.
UPDT_CNT DOUBLE Y 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 Y 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_TASK VARCHAR(40) Y 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.
UPDT_USER VARCHAR(40) Y The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.


UKRWH_MSDS_PREGNANCY



Column Section Top of Page


Table-level Detail

Description: UKRWH_MSDS_PREGNANCY
Definition: Contains pregnancy details from NHS Maternity Services Data Set.
Table Type: ACTIVITY





Column Detail - UKRWH_MSDS_PREGNANCY


Column Name Type Null? Definition
ABNORMALITY_AT_DT_US_SCAN_IND VARCHAR(10) Y An indication of whether any abnormalities were detected during a clinical investigation for a dating ultrasound scan.
ACTIVE_IND DOUBLE Y The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
AGREED_EDD_METHOD_NHS VARCHAR(10) Y The NHS code for the method used to calculate the Estimated Date of Delivery (Agreed).
CARE_PRO_TYPE_NHS VARCHAR(10) Y The NHS care professional type code of the first care professional seen by the mother within a maternity episode for antenatal care.
CIG_PER_DAY_NBR DOUBLE Y The number of cigarettes per day smoked by the mother, as identified at the Appointment Date (Formal Antenatal Booking).
DEL_PLACE_CH_REASON_NHS VARCHAR(10) Y The NHS code for delivery place change reason if the place of delivery is different from the place originally intended, either in the type of place or geographically.
DT_US_SCAN_OFER_STATUS_NHS VARCHAR(10) Y The NHS code for dating ultrasound scan offer status.
EOP_SMOKING_STATUS_NHS VARCHAR(10) Y The NHS code for smoking status of the mother, reported by the mother after the delivery of the baby.
EPISIOTOMY_REASON_NHS VARCHAR(10) Y The NHS code for episiotomy performed reason during Labour and Delivery.
ETHNIC_CAT_MOTHER_NHS VARCHAR(10) Y The NHS ethnic category code for the mother in a maternity episode.
EXTRACT_DT_TM DATETIME Y Date and Time of when extract was created.
FETUS_PRE_ONSET_LAB_NHS VARCHAR(10) Y The NHS code for presentation of the Fetus.
FIRST_LANG_ENG_FLG VARCHAR(10) Y An indication of whether a persons first language is English. N - First language is not English, Y - First language is English.
FIRST_PROCESS_DT_TM DATETIME Y First date/time row was inserted into table.
FOLIC_ACID_SUPP_STATUS_NHS VARCHAR(10) Y The NHS status code of whether a woman has been taking or intends to take folic acid supplements.
GEST_AGE_AT_DT_US_SCAN VARCHAR(40) Y The gestation length of a fetus episode recorded as the total number of days measured at the dating ultrasound scan.
HEALTH_SYSTEM_ID DOUBLE N Unique number assigned by Health Facts. Typically the universal Cerner assigned client id of the health system.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Unique number assigned by Health Facts. Typically the universal Cerner assigned client id of the sending health system but may be adjusted if there is >1 HF feed from the client.
HEIGHT_AT_BOOKING VARCHAR(10) Y the height of the mother measured during an antenatal period. The unit of measurement is metres (m).
INTED_DEL_PLACE_TYPE_NHS VARCHAR(10) Y The NHS delivery place type code where the pregnant woman plans to have her baby. The first intended delivery place type is recorded, as designated by the care professional in consultation with the patient.
INTED_DEL_SITE_CODE_NACS VARCHAR(10) Y The Organisation Site Code of the organisation that is the intended place of delivery of the baby as part of a maternity episode.
INTED_DEL_WARD_TYPE_NHS VARCHAR(10) Y The NHS code of midwife unit or ward type that is intended as the place of delivery for the current midwife episode.
LAST_PROCESS_DT_TM DATETIME Y Last date/time row was updated.
LEAD_CARE_PRO_TYPE_NHS VARCHAR(10) Y The NHS code of care professional type identified in the care plan with overall responsibility for care of the mother during the maternity episode.
LOCAL_PATIENT_IDENT VARCHAR(40) Y The Local Patient Identifier of the mother in a maternity episode.
LOC_AGREED_EDD_DT_TM DATETIME Y The clinically agreed estimated date of delivery converted to local datetime.
LOC_C_SECTION_PROC_DT_TM DATETIME Y The procedure date and time when the Caesarean Section took place during labour and delivery converted to local datetime.
LOC_DECEASED_DT_TM DATETIME Y Person death date and time for the mother in a maternity episode converted to local datetime.
LOC_DECISION_TO_DELIVER_DT_TM DATETIME Y The start date and time of the decision to deliver converted to local datetime.
LOC_DELIVERY_HPS_ST_DT_TM DATETIME Y The start date and time for a mother during a maternity episode as part of the onset of labour, or for a caesarean section procedure converted to local datetime.
LOC_DISCH_POST_DEL_HPS_DT_TM DATETIME Y The date and time that a Patient is discharged from hospital, following readmission in the Postpartum period converted to local datetime.
LOC_DT_SCAN_ACT_OFFER_DT_TM DATETIME Y An activity offer date for dating scan converted to local datetime.
LOC_DT_US_SCAN_PROC_DT_TM DATETIME Y An activity date for the Clinical Investigation of dating ultrasound scan converted to local datetime.
LOC_FIRST_ANTE_APP_DT_TM DATETIME Y The date converted to local datetime on which the pregnant woman was assessed and arrangements made for antenatal care as part of the Pregnancy Episode. This is not necessarily the occasion on which arrangements were made for delivery.
LOC_LABOUR_ONSET_DT_TM DATETIME Y The start date and time for Established Labour Onset converted to local datetime.
LOC_LAST_MENSTRUAL_DT_TM DATETIME Y The date of the first day of the last menstrual period for a female person converted to local datetime.
LOC_MAT_CARE_PLAN_DT_TM DATETIME Y The date on which a care plan was agreed with the patient for a maternity episode converted to local datetime.
LOC_MAT_DISCHARGE_DT_TM DATETIME Y The date on which the mother ceased to be cared for in a maternity episode converted to local datetime. This will be the last contact date with a midwife when care is then continued by a specialist community public health nurse, health visitor.
LOC_MOTHER_DOB_DT_TM DATETIME Y Date of birth of the mother in a maternity episode converted to local datetime.
LOC_PREG_FIRST_CONTACT_DT_TM DATETIME Y The date at which a pregnant woman first contacted the NHS to access antenatal care converted to local datetime.
LOC_ROM_DT_TM DATETIME Y The start date and time of the rupture of membranes during labour and delivery converted to local datetime.
LOC_SECOND_LAB_ONSET_ST_DT_TM DATETIME Y The start date and time for second stage of labour onset converted to local datetime.
LOC_THIRD_LAB_ONSET_END_DT_TM DATETIME Y The end date and time for third stage of labour end converted to local datetime.
MAT_CARE_PLAN_TYPE_NHS VARCHAR(10) Y The NHS code of care plan type for a maternity episode.
MOTHER_COMPLEX_SOC_FCT_IND VARCHAR(10) Y An indication of whether the mother in a maternity episode is deemed to be subject to complex social factors, as defined by the National Institute for Health and Care Excellence guidance.
MOTHER_EMP_STATUS_NHS VARCHAR(10) Y Employment status of the mother at the Appointment Date (Formal Antenatal Booking).
MOTHER_MH_PREDICT_DETECT_IND VARCHAR(10) Y An indication of whether the recommended questions for prediction and detection of mental health issues have been asked of the mother at the Appointment Date (Formal Antenatal Booking).
MOTHER_SUPPORT_STATUS_FLG VARCHAR(10) Y An indication of whether the mother reports feeling she is supported in pregnancy and looking after the baby, from partner, family or friends. N - Does not feel supported, Y - Feels supported. Z - Person asked but declined to respond.
NHS_NBR_IDENT VARCHAR(40) Y The NHS Number of the mother in a maternity episode.
NHS_NBR_STATUS_NHS VARCHAR(10) Y The NHS status indicator code of the NHS Number (Mother).
NO_FETUSES_DT_US_SCAN_NBR DOUBLE Y The number of fetuses counted within a particular pregnancy episode noted at the dating ultrasound scan.
PARTNER_EMP_STATUS_NHS VARCHAR(10) Y Employment status of the partner of the mother at the Appointment Date (Formal Antenatal Booking).
PCT_MRN_NACS VARCHAR(10) Y The Organisation Code of the Organisation that assigned the Local Patient Identifier (Mother).
PCT_RESIDENCE_NACS VARCHAR(10) Y The Organisation Code derived from the patients postcode of usual address.
PHYSICAL_DISABILITY_FLG VARCHAR(10) Y An indication of whether a person has a physical disability. This does not include learning disabilities. N - Does not have disability, Y - Has disablity.
PLACENTA_DELIV_METHOD_NHS VARCHAR(10) Y The NHS code for method by which a placenta was removed at the end of Labour and Delivery.
PNATAL_LEAD_PRVD_NACS VARCHAR(10) Y The Organisation Code of the postnatal lead provider Organisation for the purpose of the Maternity Services Data Set.
POSTCODE VARCHAR(10) Y The Postcode of the address nominated by the patient (Mother).
PREGNANCY_SK VARCHAR(40) Y Millennium system generated unique identifier for a pregnancy.
PREV_C_SECTIONS_NBR DOUBLE Y The number of previous caesarean sections performed.
PREV_TOT_LIVE_BIRTHS_NBR DOUBLE Y The number of registrable live births by the mother.
PREV_TOT_LOSSES_24WKS_NBR DOUBLE Y The recorded number of terminations and previous losses before 24 weeks of pregnancy (i.e. less than 23 weeks and 6 days) for a woman.
PREV_TOT_STILL_BIRTHS_NBR DOUBLE Y The number of registrable still births by the mother i.e. a birth after a gestation of 24 weeks (168 days), or more, where a baby shows no identifiable signs of life at delivery.
ROM_METHOD_NHS VARCHAR(10) Y The NHS code for method by which membranes were ruptured during labour and delivery.
ROM_REASON_NHS VARCHAR(10) Y The NHS reason code of why an Artificial Rupture of Membranes (ARM) was performed during labour and delivery.
SMOKING_STATUS_NHS VARCHAR(10) Y The NHS code for smoking status of the mother during a maternity episode, reported by the mother at the Appointment Date (Formal Antenatal Booking).
SUBSTANCE_USE_STATUS_NHS VARCHAR(10) Y The NHS code for substance misused status reported by the mother, for a substance misused other than alcohol or tobacco, at the Appointment Date (Formal Antenatal Booking).
TOTAL_UPDATES DOUBLE Y The numbers of updates that have occurred on this table.
UKRWH_MSDS_PREG_KEY DOUBLE N Unique generated number that identifies a single row on the UKRWH_MSDS_PREGNANCY table.
UPDT_CNT DOUBLE Y 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 Y The date and time the row was last inserted or updated.
UPDT_TASK VARCHAR(40) Y The registered (assigned) task number for the process that inserted or updated the row.
UPDT_USER VARCHAR(40) Y The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
WEEKLY_ALCOHOL_UNITS_NBR DOUBLE Y The number of alcohol units per week consumed by the mother as identified at the Appointment Date (Formal Antenatal Booking).
WEIGHT_AT_BOOKING VARCHAR(10) Y The weight of the mother measured during an antenatal period. The unit of measurement is kilograms (kg).