Table Detail Report

UKRWH_CDS_RTT_EVENT



Column Section Top of Page


Table-level Detail

Description: UK Reporting Warehouse Commissioning Data Set Refferal To Treatment Event
Definition: Contains Referral to Treatment details relatign to CDS events as well as detaisl relating to non CDS administrative event.
Table Type: REFERENCE





Column Detail - UKRWH_CDS_RTT_EVENT


Column Name Type Null? Definition
ACTIVITY_DT_TM DATETIME Y Any date or time that is pertinent to an ACTIVITY.
ADC_COMMENTS VARCHAR(255) Y This is the value of the comments recorded on the RTT Powerform
CDS_BATCH_CONTENT_SK VARCHAR(40) N Unique identifier for each cds item. This is the unique CDS ID reported to the NHS.
CDS_RECORD_TYPE_NHS VARCHAR(3) Y A code to identify the specific type of Commissioning Data Set data.
DECEASED_DT_TM DATETIME Y The date on which a PERSON died or is officially deemed to have died.
ENCOUNTER_SK VARCHAR(40) Y This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
EPISODE_SK VARCHAR(40) Y This is the value of the unique primary identifier of the episode table. It is an internal system assigned number.
EXTRACT_DT_TM DATETIME N The date and time the row was extracted.
FIN_IDENT VARCHAR(12) Y This is the value of the unique primary identifier of the encounter financial table. It is an internal system assigned number.
FIRST_PROCESS_DT_TM DATETIME N The date/time that the first ETL process started that created this record.
GP_PRACTICE_ORG VARCHAR(40) Y The Millennium organization identifier for a GP Practice.
GP_PRSNL VARCHAR(40) Y The Millennium Personnel Identifier for GP
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.
ITT_RTT_START_DT_TM DATETIME Y The start date of a REFERRAL TO TREATMENT PERIOD from an Inter Trust Transfer
LAST_PROCESS_DT_TM DATETIME N The date/time that the last ETL process started that updated this record.
LOCAL_PATIENT_IDENT VARCHAR(10) Y An identifier, other than a name, which identifies a PERSON.
LOC_ACTIVITY_DT_TM DATETIME Y Any date or time that is pertinent to an activity.
LOC_ITT_RTT_START_DT_TM DATETIME Y The start date of a referral to treatment period from an inter trust transfer.
LOC_RTT_EVENT_DT_TM DATETIME Y The applicable effective date time of an rtt event.
MAIN_SPECIALTY_REF VARCHAR(40) Y The Millennium code identifier for the main specialty code of the responsible health care provider
NHS_NBR_IDENT VARCHAR(10) Y A number used to identify a person uniquely within the NHS in England and Wales. This field contains the NHS Number of the patient, which is the primary identifier of a person registered for health care; it is unique. Records for babies under six weeks of age and for patients admitted through accident and emergency tend to have null entries for this field.
OUTCOME_NHS VARCHAR(2) Y This field contains the outcome of the RTT event
PARENT_ENTITY_NAME VARCHAR(30) Y This is the value of the parent entity name on the Millennium CDS_BATCH_CONTENT table
PARENT_ENTITY_SK VARCHAR(40) Y This is the value of the parent entity id on the Millennium CDS_BATCH_CONTENT table
PATIENT_PATHWAY_IDENT VARCHAR(20) Y An identifier, which together with the ORGANISATION CODE of the issuer, uniquely identifies a PATIENT PATHWAY.
PATIENT_PATHWAY_ISSUER_NACS VARCHAR(6) Y The ORGANISATION CODE of the issuer, which is used to uniquely identify a PATIENT PATHWAY.
PERSON_SK VARCHAR(40) Y This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PROVIDER_ORG_NACS VARCHAR(5) Y An ORGANISATION providing patient care services within a NHS SERVICE AGREEMENT.
RESPONSIBLE_HCP_PRSNL VARCHAR(40) Y The Millennium Personnel Identifier for HCP
RTT_EVENT_DT_TM DATETIME Y The applicable effective date time of an rtt event.
RTT_EVENT_UNIQUE_ID VARCHAR(35) Y This is the unique identifier for the RTT event
RTT_PERIOD_KEY DOUBLE N This is the value of the unique identifier of the UKRWH_CDS_RTT_PERIOD table. It is an internal system assigned number
RTT_PERIOD_STATUS VARCHAR(10) Y The interpretation of the rtt event status. e.g. START, STOP, OTHER
RTT_REF VARCHAR(40) Y This is the value of the Millennium Code Value for the RTT Status
RTT_START_DT_TM DATETIME Y The start date of a REFERRAL TO TREATMENT PERIOD.
RTT_STATUS_NHS VARCHAR(2) Y The status of an ACTIVITY (or anticipated ACTIVITY) for the 18 week REFERRAL TO TREATMENT PERIOD decided by the lead CARE PROFESSIONAL.
RTT_STOP_DT_TM DATETIME Y The end date of a REFERRAL TO TREATMENT PERIOD.
RTT_UPDATE_DEL_FLG DOUBLE Y This field contains the count of the number of times the record has been marked for update / deletion
SUSPENSION_REASON_TXT VARCHAR(100) Y A period of time during which a PATIENT with an ELECTIVE ADMISSION LIST ENTRY on an ELECTIVE ADMISSION LIST is unavailable for admission due to medical or PATIENT initiated reasons and therefore should not be given an OFFER OF ADMISSION for that interval.
TOTAL_UPDATES DOUBLE N The numbers of updates that have occurred on this table.
TREATMENT_FUNCTION_REF VARCHAR(40) Y The Millennium code identifier for the treatment function code of the responsible health care provider
UKRWH_CDS_HEADER_KEY DOUBLE N This is the value of the unique primary identifier of the ukrwh cds header table. It is an internal system assigned number.
UKRWH_CDS_RTT_EVENT_KEY DOUBLE N This is the value of the unique primary identifier of the ukrwh cds rtt event table. It is an internal system assigned number.
UPDATE_USER VARCHAR(40) 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_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_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.


UKRWH_CDS_RTT_PERIOD



Column Section Top of Page


Table-level Detail

Description: UKRWH_CDS_RTT_PERIOD
Definition: UK Reporting Warehouse Commissioning Data Set Referral To Treatment Periods
Table Type: REFERENCE





Column Detail - UKRWH_CDS_RTT_PERIOD


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N 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.
EPISODE_SK VARCHAR(100) Y This is the value of the unique primary identifier of the episode table. It is an internal system assigned number.
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.
LOC_RTT_PERIOD_END_DT_TM DATETIME Y The end date of a referral to treatment period.
LOC_RTT_PERIOD_START_DT_TM DATETIME Y The start date of a referral to treatment period.
PATIENT_PATHWAY_IDENT VARCHAR(20) Y An identifier, which together with the organization code of the issuer uniquely identifies a patient pathway.
RTT_PERIOD_END_DT_TM DATETIME Y The end date of a referral to treatment period.
RTT_PERIOD_KEY DOUBLE N This is the value of the unique identifier of the UKRWH_CDS_RTT_PERIOD table. It is an internal system assigned number
RTT_PERIOD_SEQ DOUBLE Y The sequence of the RTT period within a patient pathway.
RTT_PERIOD_START_DT_TM DATETIME Y The start date of a referral to treatment period.
RTT_PERIOD_START_EVENT_SK VARCHAR(100) Y This is the unique identifier for the rtt event that represents the start of an rtt period
RTT_PERIOD_STOP_EVENT_SK VARCHAR(100) Y This is the unique identifier for the rtt event that represents the stop of an rtt period
UPDATE_USER VARCHAR(40) N The user that performs the insert or update to the record
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_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.


UKRWH_MAT_BIRTH



Column Section Top of Page


Table-level Detail

Description: UKRWH_MAT_BIRTH
Definition: Contains birth details associated to a maternity encounter.
Table Type: ACTIVITY





Column Detail - UKRWH_MAT_BIRTH


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.
APGAR_1_MIN_SCORE DOUBLE Y The Apgar score of the neonate 1 minute after the delivery.
APGAR_5_MIN_SCORE DOUBLE Y The Apgar score of the neonate 5 minutes after the delivery.
BABY_ALIVE_LABOUR_ONSET_NM_SK VARCHAR(100) Y Fetal Heart Rate Heard at Onset of Labour Millennium Nomenclature Identifier.
BABY_BIRTH_DT_TM DATETIME Y Date and time of birth of baby.
BABY_NAME VARCHAR(255) Y A number to provide a unique identifier for each Hospital Provider Spell for a Health Care Provider.
BABY_PERSON_SK VARCHAR(40) Y The Millennium system generated unique person identifier of the baby.
BBA_NM_SK VARCHAR(100) Y Unattended delivery Millennium Nomenclature Identifier.
BIRTH_LOC_DETAIL_NM_SK VARCHAR(100) Y Actual Delivery Location Detail Millennium Nomenclature Identifier. Indicates if delivered in ambulance - theatre or toilet.
BIRTH_LOC_NM_SK VARCHAR(100) Y Actual Delivery Location Millennium Nomenclature Identifier. Type of unit in which baby was delivered.
BIRTH_ORDER_NBR DOUBLE Y Sequence in which the baby was born.
BIRTH_WEIGHT VARCHAR(9) Y Weight of baby in grammes at birth. Output as a string in the following format nnnn.nn g .
CORD_PH_RESULT DOUBLE Y Cord pH Result Mixed.
C_SECTION_GRADE_NM_SK VARCHAR(100) Y Caesarean Section Grading Millennium Nomenclature Identifier.
C_SECTION_INDICATION_NM_SK VARCHAR(100) Y Primary Indication for C Section Millennium Nomenclature Identifier
DELIVERED_BY_NAME VARCHAR(255) Y Baby Delivered by Person Name.
DEL_METHOD_REF VARCHAR(40) Y Delivery Method (Current Baby) Millennium Code Value. The method for delivering baby.
DEL_OUTCOME_NM_SK VARCHAR(100) Y Method of Delivery Millennium Nomenclature Identifier. The delivery method for each baby.
DEL_PRSNL_STATUS_NM_SK VARCHAR(100) Y Status of Clinician Conducting Delivery Millennium Nomenclature Identifier.
EXTRACT_DT_TM DATETIME N Date and Time of when extract was created.
FEEDING_METHOD_NM_SK VARCHAR(100) Y Baby Feed Type (At Discharge from Hospital) Millennium Nomenclature Identifier. Method of feed - as captured at the point of baby s discharge from hospital. In the case of a home birth - this will be captured at the postnatal visit closest to 48 hours of birth.
FIRST_PROCESS_DT_TM DATETIME N First date/time row was inserted into table.
GEST_AGE_DEL VARCHAR(15) Y Gestation at DATE TIME OF BIRTH (BABY) in weeks and days in the format # weeks - # days .
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.
HR_10_MIN_NM_SK VARCHAR(100) Y Heart Rate at 10 minutes Millennium Nomenclature Identifier
HR_20_MIN_NM_SK VARCHAR(100) Y Heart Rate at 20 minutes Millennium Nomenclature Identifier
HR_5_MIN_NM_SK VARCHAR(100) Y Heart Rate at 5 minutes Millennium Nomenclature Identifier
LABOUR_START_DT_TM DATETIME Y Onset of Established Labour Date Time. Date/time when established labour is confirmed - regular painful contractions and progressive cervical dilatation from 4 cm.
LAST_PROCESS_DT_TM DATETIME N Last date/time row was updated.
LOCAL_PATIENT_IDENT VARCHAR(40) Y An identifier - other than a name - which identifies a PERSON.
LOC_BABY_BIRTH_DT_TM DATETIME Y Date and time of birth of baby converted to local date/time.
LOC_LABOUR_START_DT_TM DATETIME Y Onset of Established Labour Date Time converted to local date/time.
LOC_MEM_RUPTURE_DT_TM DATETIME Y Date and time on which membranes ruptured converted to local date/time.
LOC_NEO_DEATH_DT_TM DATETIME Y Date and time of death of baby converted to local date/time.
MEM_RUPTURE_DT_TM DATETIME Y Date and time on which membranes ruptured.
NB_GEST_ASSESS_NM_SK VARCHAR(100) Y Gestation Appearance Millennium Nomenclature Identifier.
NB_SEX_REF VARCHAR(40) Y Child s Gender.
NEO_CARE_LEVEL_NM_SK VARCHAR(100) Y Critical Care level for the day.
NEO_DEATH_DT_TM DATETIME Y Date and time of death of baby.
NEO_OUTCOME_REF VARCHAR(40) Y Neonate Outcome Millennium Code Value . Neonatal outcome indicating live birth - fetal death or neonatal death.
NHS_NBR_IDENT VARCHAR(40) Y A number used to identify a person uniquely within the NHS in England and Wales. This field contains the NHS Number of the patient - which is the primary identifier of a person registered for health care; it is unique. Records for babies under six weeks of age and for patients admitted through accident and emergency tend to have null entries for this field.
NOTIFYING_MIDWIFE_NAME VARCHAR(255) Y Name of notifying midwife.
PREGNANCY_CHILD_SEQ_SK VARCHAR(40) Y Millennium system generated unique identifier for a fetus / birth with appended for sequence
PREGNANCY_CHILD_SK VARCHAR(40) Y Millennium system generated unique identifier for a fetus / birth.
PREGNANCY_SK VARCHAR(40) Y Millennium system generated unique identifier for a pregnancy.
PREG_OUTCOME_REF VARCHAR(40) Y Pregnancy Outcome (Current Fetus) Millennium Code Value. Outcome of each fetus identified at the dating scan.
PRES_DEL_NM_SK VARCHAR(100) Y Presentation at Onset of Labour Millennium Nomenclature Identifier. The presentation of the (first) fetus at onset of labour.
RESP_10_MIN_NM_SK VARCHAR(100) Y Respiratory Effort at 10 minutes Millennium Nomenclature Identifier.
RESP_20_MIN_NM_SK VARCHAR(100) Y Respiratory Effort at 20 minutes Millennium Nomenclature Identifier.
RESP_5_MIN_NM_SK VARCHAR(100) Y Respiratory Effort at 5 minutes Millennium Nomenclature Identifier.
TOTAL_LABOUR_LENGTH VARCHAR(5) Y Total length of labour in hours and minutes formatted as a string in HH:MM .
TOTAL_NBR_BABIES DOUBLE Y Total newborns delivered in the pregnancy.
TOTAL_UPDATES DOUBLE N The numbers of updates that have occurred on this table.
UKRWH_MAT_BIRTH_KEY DOUBLE N Unique generated number that identifies a single row on the UKRWH_MAT_BIRTH table.
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_TASK VARCHAR(40) N The registered (assigned) task number for the process that inserted or updated the row.
UPDT_USER VARCHAR(40) 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.
WATER_BIRTH_NM_SK VARCHAR(100) Y Delivered In Water Indicator Millennium Nomenclature Identifier. Whether or not the baby was delivered in a birthing pool.


UKRWH_MAT_DETAILS



Column Section Top of Page


Table-level Detail

Description: UKRWH_MAT_DETAILS
Definition: Contains maternity pregnanacy and birth activity details
Table Type: ACTIVITY





Column Detail - UKRWH_MAT_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.
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.
MAT_DETAIL_TYPE_DESC VARCHAR(40) Y Maternity activity name
MAT_DETAIL_TYPE_FLG DOUBLE Y Maternity activity type flag
PARENT_ENTITY_KEY DOUBLE Y PIEDW system generated unique identifier for a pregnancy or birth
PARENT_ENTITY_NAME VARCHAR(40) Y Parent type of entity - Pregnancy or Birth
PARENT_ENTITY_SK VARCHAR(40) Y Millennium system generated unique identifier for a pregnancy or birth
SEQUENCE DOUBLE Y Sequence of occurrence
TOTAL_UPDATES DOUBLE Y The numbers of updates that have occurred on this table.
UKRWH_MAT_DETAILS_KEY DOUBLE N Unique generated number that identifies a single row on the UKRWH_MAT_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(100) 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.
VALUE VARCHAR(100) Y Reference value for activity
VALUE_TYPE_DESC VARCHAR(40) Y Reference value type Snowmed - Nomenclature or code value


UKRWH_MAT_PREGNANCY



Column Section Top of Page


Table-level Detail

Description: UKRWH_MAT_PREGNANCY
Definition: Contains pregnancy details assocaited to a maternity encounter
Table Type: ACTIVITY





Column Detail - UKRWH_MAT_PREGNANCY


Column Name Type Null? Definition
ACCOMMODATION_NM_SK VARCHAR(100) Y Current Accommodation Type (Mother at Booking) Millennium Nomenclature Identifier
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.
ALCOHOL_USE_NBR DOUBLE Y The typical number of units of alcohol the mother drinks - per week - as reported at the Booking Appointment
BLOOD_PATCH_IND DOUBLE Y Blood Patch Procedure performed Indicator. 1 indicates a Blood Patch procedure was recorded - 0 that no procedure was recorded.
BMI_BOOKING DOUBLE Y Body Mass Index at Booking
CHOOSING_TERMINTION_PREG_NM_SK VARCHAR(100) Y Haemaglobinopathy Plan of Care
DEATH_LAB_WD_DT_TM DATETIME Y Date/time of death of mother
DEL_LOC_CHG_REASON_PREG_NM_SK VARCHAR(100) Y Planned place of birth change reason
DOWNS_SERUM_SCREEN_NM_SK VARCHAR(100) Y Whether or not screening for Downs Syndrome was offered - accepted or declined
ECV_SCT_IND DOUBLE Y An Indicator of whether the woman has had a procedure external cephalic version based on Procedures recorded. 1 indicates a procedure has occurred - 0 that none has been recorded.
EDUCATION_NM_SK VARCHAR(100) Y Latest education level at booking
EMPLOY_STATUS_NM_SK VARCHAR(100) Y Whether or not the mother is in employment - as identified at the Booking Appointment
EPISIOTOMY_NM_SK VARCHAR(40) Y Indication for episiotomy
EXTRACT_DT_TM DATETIME Y Date/time of extraction execution time
FAMILY_ORIGIN_MOTHER_NM_SK VARCHAR(100) Y The ethnicity of the mother in a maternity episode as specified by herself
FAMILY_ORIGIN_PARTNER_NM_SK VARCHAR(100) Y The ethnicity of the babies father in a maternity episode
FINAL_EDD_DT_TM DATETIME Y The Estimated Date of Delivery - as agreed by ultrasound scan - LMP or Clinical Assessment.
FIRST_ANTE_ASSESS_DT_TM DATETIME Y Referred to as the Booking Appointment - the date 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.
FIRST_PROCESS_DT_TM DATETIME Y First date/time row was inserted into table.
FULL_DIL_DT_TM DATETIME Y Date/time when established labour is confirmed - regular painful contractions and progressive cervical dilatation from 4 cm
GEST_AGE_PREG_END VARCHAR(40) Y Gestation at DATE TIME OF BIRTH (BABY) in in weeks and days - in the format #Weeks#Days .
GEST_AGE_PREG_START VARCHAR(40) Y Gestation date at the time of the open pregnancy start date. In weeks and days - in the format #Weeks#Days . This will be earliest Estimate for the Pregnancy.
GEST_DEATH_CONF_DT_TM DATETIME Y The date associated to the entry of Fetal Death being associated to a Pregnancy in the Diagnosis and Problems Control.
GRAVIDA_NBR DOUBLE Y Count of all past pregnancies including the current one in context
HAEMAGLOBINOPATHY_SCREEN_NM_SK VARCHAR(100) Y Whether or not a mother was offered a haemoglobinopathy serum screening test - and the subsequent response to the offer
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_BOOKING_CM DOUBLE Y The height of a person on a given date. The unit of measurement is metres.
HEPB_ANTIGEN_SCREEN_NM_SK VARCHAR(100) Y Whether or not a mother was offered a screening test and whether or not she declined or accepted.
HIV_SCREEN_NM_SK VARCHAR(100) Y Whether or not a mother was offered a screening test and whether or not she declined or accepted.
HX_EPIDURAL_NBR DOUBLE Y The Number of previous labours with a anesthesia type of Epidural
HX_PREG_CS_EL_NBR DOUBLE Y The Number of previous pregnancies with outcomes of C-Section Elective
HX_PREG_CS_EM_AFT_FAIL_IN_NBR DOUBLE Y The Number of previous pregnancies with outcomes of C-Section EM after failed induction
HX_PREG_CS_EM_NBR DOUBLE Y The Number of previous pregnancies with outcomes of C-Section Emergency
HX_PREG_ECTOPIC_MED_NBR DOUBLE Y The number of previous pregnancies with outcomes of Ectopic pregnancy Medical Management
HX_PREG_ECTOPIC_NBR DOUBLE Y The Number of previous pregnancies with outcomes of Ectopic .
HX_PREG_ECTOPIC_SURG_NBR DOUBLE Y The Number of previous pregnancies with outcomes of Ectopic pregnancy laporotomy
HX_PREG_SPONT_ABORT_DC_NBR DOUBLE Y The Number of previous pregnancies with outcomes of Spontaneous Abortion with D&C .
HX_PREG_SPONT_ABORT_NBR DOUBLE Y The number of previous pregnancies with outcomes of Spontaneous abortion .
HX_PREG_SPONT_NBR DOUBLE Y The Number of previous pregnancies with outcomes of Spontaneous Vertex OR Vaginal Breech spontaneous prior to current pregnancy in context.
HX_PREG_THERAP_ABORT_MED_NBR DOUBLE Y The Number of previous pregnancies with outcomes of Therapeutic Abortion - Medical .
HX_PREG_THERAP_ABORT_SURG_NBR DOUBLE Y The Number of previous pregnancies with outcomes of Therapeutic Abortion - Surgical .
HX_PREG_VAG_BREECH_NBR DOUBLE Y The Number of previous pregnancies with outcomes of Vaginal Breech spontaneous OR Vaginal Breech Assisted
HX_PREG_VAG_DESTRUCTION_NBR DOUBLE Y The Number of previous pregnancies with outcomes of Vaginal Other including destruction .
HX_PREG_VAG_FORCEP_NBR DOUBLE Y The Number of previous pregnancies with outcomes of Vaginal Forcep Assist
HX_PREG_VAG_SPONT_NBR DOUBLE Y The Number of previous pregnancies with outcomes of Vaginal Spontaneous .
HX_PREG_VAG_VACCUM_NBR DOUBLE Y The Number of previous pregnancies with outcomes of Vaginal Vacuum Assist
HX_PREG_VBAC_NBR DOUBLE Y The Number of previous pregnancies with outcomes of Vaginal Birth after Caesarean .
KNOWN_SOC_SERV_NM_SK VARCHAR(100) Y Does the woman have a social worker at time of booking - Yes or No.
LAB_AUGMENTATION_NM_SK VARCHAR(100) Y Augmentation of labour
LAB_ONSET_DT_TM DATETIME Y Date/time when established labour is confirmed - regular painful contractions and progressive cervical dilatation from 4 cm
LAB_ONSET_METHOD_NM_SK VARCHAR(100) Y Method of onset of labour
LAB_STAGE1_TOTAL DOUBLE Y Length of Stage I of Labour in minutes
LAB_STAGE2_TOTAL DOUBLE Y Length of Stage II of Labour in minutes
LAB_STAGE3_TOTAL DOUBLE Y Length of Stage III of Labour in minutes
LAB_SUPPORT_NM_SK VARCHAR(100) Y Support during labour
LAB_TOTAL DOUBLE Y Total length of labour in minutes
LAST_METHOD_CONTRACEPT_NM_SK VARCHAR(100) Y Last method of contraception (Mother at Booking) Millennium Nomenclature Identifier
LAST_PROCESS_DT_TM DATETIME Y Last date/time row was updated.
LOCAL_PATIENT_IDENT VARCHAR(40) Y The Local Patient Identifier of the mother in a maternity episode.
LOC_DEATH_LAB_WD_DT_TM DATETIME Y Date/time of death of mother converted to local datetime
LOC_FINAL_EDD_DT_TM DATETIME Y The Estimated Date of Delivery - as agreed by ultrasound scan - LMP or Clinical Assessment converted to local datetime.
LOC_FIRST_ANTE_ASSESS_DT_TM DATETIME Y Referred to as the Booking Appointment - the date 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 converted to local datetime.
LOC_FULL_DIL_DT_TM DATETIME Y Date/time when established labour is confirmed - regular painful contractions and progressive cervical dilatation from 4 cm converted to local datetime
LOC_MOTHER_DOB_DT_TM DATETIME Y Date of birth of the mother in a maternity episode converted to local datetime
MIDWIFE_TEAM_NAME VARCHAR(255) Y The name of the trust defined midwifery team the woman is assigned to where applicable.
MOTHER_DOB_DT_TM DATETIME Y Date of birth of the mother in a maternity episode
MOTHER_NAME VARCHAR(255) Y The Full Name of the mother in a maternity episode.
NHS_NBR_IDENT VARCHAR(40) Y The NHS Number of the mother in a maternity episode.
OCCUP_MOTHER VARCHAR(255) Y Woman s occupation at booking as Text.
OCCUP_PARTNER VARCHAR(255) Y Husband/Partner s Occupation at booking as Text.
PARA_NBR DOUBLE Y The number live births from previous pregnancies
PARTNER_PAID_EMP_BKING_NM_SK VARCHAR(100) Y Whether or not the partner (who may or may not be the father) is employed - as identified at the Booking Appointment.
PARTNER_REC_SUB_USE_NM_SK VARCHAR(100) Y Partner Substance Use Status (Mother at Booking) Millennium Nomenclature Identifier
PERSON_SK VARCHAR(40) Y The Millennium system generated unique person identifier of the mother in a maternity episode.
PLACENTA_APPEARANCE_NM_SK VARCHAR(100) Y Appearance of placenta
PLACENTA_MAN_REMOVAL_IND DOUBLE Y An indicator of whether a Manual Removal of retained Placenta procedure was carried out. 1 indicates a procedure was recorded - 0 that none was recorded.
PLANNED_DEL_LOC_LAB_NM_SK VARCHAR(100) Y Planned place of birth change reason
PLANNED_DEL_LOC_PREG_NM_SK VARCHAR(100) Y Intended place of delivery
PLANNED_IOL_IND DOUBLE Y Planned induction Indicator. 1 indicates that an order was placed to indicate that an Induction was planned - 0 indicates there was no record of such an order.
PLANNED_LSCS_IND DOUBLE Y Planned Caesarean Indicator. 1 indicates that an order was placed to indicate that an Caesarean was planned - 0 indicates there was no record of such an order.
PREGNANCY_SK VARCHAR(40) Y Millennium system generated unique identifier for a pregnancy.
PREG_TYPE_SCT_VALUE VARCHAR(100) Y Type of pregnancy e.g. singleton - twins - triples etc.
PRES_FETUS_VE_NM_SK VARCHAR(100) Y The presentation of the (first) fetus at onset of labour
PREV_PREG_PROBLEM_IND DOUBLE Y An indicator of whether the mother has a history of any complications listed for any previous pregnancy outcomes . 1 indicating a complication being present for a previous pregnancy - 0 representing no complications associated to previous pregnancy being present.
REC_SUB_USE_NM_NM_SK VARCHAR(100) Y The mother s self-reported status of whether or not she has used or is using non medicinal drugs or other substances at the booking appointment
ROM_DT_TM DATETIME Y Date/time on which membranes ruptured
ROM_METHOD_NM_SK VARCHAR(100) Y The way in which membranes were ruptured
RUBELLA_IGG_SCREEN_NM_SK VARCHAR(100) Y Whether or not a mother was offered a screening test and whether or not she declined or accepted.
SMOKE_BOOKING_NM_SK VARCHAR(100) Y The mother s self-reported smoking status at the Booking Appointment
SMOKE_LIVES_WITH_NM_SK VARCHAR(100) Y Living with anyone who smokes
SMOKING_STATUS_DEL_NM_SK VARCHAR(100) Y The mother s self-reported smoking status - specifically after the birth of the baby (synonym with at delivery ).
SUPPORT_STATUS_NM_SK VARCHAR(100) Y Whether or not the mother feels she is supported in pregnancy and looking after a baby - from partner - family or friends - as identified at the Booking Appointment
SYPHILIS_SCREEN_NM_SK VARCHAR(100) Y Offer status of syphilis screening
TOBAC_USE_NBR DOUBLE Y The number of cigarettes smoked per day - by the mother - as identified at the booking appointment (where they are a current smoker)
TOTAL_BLOOD_LOSS DOUBLE Y Total Blood Loss recorded associated to the Delivery in Millilitres
TOTAL_UPDATES DOUBLE Y The numbers of updates that have occurred on this table.
UKRWH_MAT_PREGNANCY_KEY DOUBLE N Unique generated number that identifies a single row on the UKRWH_MAT_PREGNANCY table.
UNBOOKED_NM_SK VARCHAR(100) Y Booking Status at last Telephone Contact
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(100) 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.
WEIGHT_BOOKING_KG DOUBLE Y Identifies the measured weight of a person on a given date. The type of measurement is Kilograms.
WEIGHT_EST_KG DOUBLE Y Identifies the estimated weight of a person on a given date. The type of measurement is Kilograms.