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