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). |