Table Detail Report

UKRWH_CDS_APC_BIRTH



Column Section Relationship Section Top of Page


Table-level Detail

Description: UK Reporting Warehouse Commissioning Data Set Birth
Definition: Contains CDS Birth details at the level of a Brith relating to an Admitted Patient Care CDS Event.
Table Type: ACTIVITY





Column Detail - UKRWH_CDS_APC_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.
ACTIVITY_LOCATION_TYPE_NHS VARCHAR(3) Y The type of LOCATION for an ACTIVITY
ACT_DELIVERY_PLACE_TYPE_NHS VARCHAR(1) Y This is the actual place type of delivery
BABY_BIRTH_DT_TM DATETIME Y The date & time on which a baby was born or is officially deemed to have been born.
BABY_BIRTH_WEIGHT_GRAMS_TOT DOUBLE Y The baby's weight in grams between 0001 to 9998 grams.
BABY_LOCAL_PATIENT_IDENT VARCHAR(10) Y This uniquely identifies the baby within CDS Delivery Episode and CDS Home Delivery where the mother's identity is recorded by use of LOCAL PATIENT IDENTIFIER.
BABY_LOCAL_PATIENT_ORG_NACS VARCHAR(12) Y This is the ORGANISATION CODE of the ORGANISATION that assigned the LOCAL PATIENT IDENTIFIER (BABY).
BABY_NHS_NBR_IDENT VARCHAR(10) Y The NHS Number of the baby within CDS Delivery Episode and CDS Home Delivery where the mother is recorded by use of NHS NUMBER.
BABY_NHS_NBR_STATUS_NHS VARCHAR(2) Y The NHS Number Status Indicator of the NHS NUMBER (BABY) within CDS Delivery Episode and CDS Home Delivery.
BABY_OVERSEAS_VS_NHS VARCHAR(1) Y The status of a BABY who is an Overseas Visitor
BABY_SEX_CD_NHS VARCHAR(1) Y The gender code of the baby at birth
BABY_WITHHELD_FLG VARCHAR(1) Y Indicates whether baby's data has been anonymised
BABY_WITHHELD_IDENT_REASON_NHS VARCHAR(2) Y NHS values which identifys that the baby's record has been purposely anonymised for a valid reason
BIRTH_ORDER_NBR DOUBLE Y The sequence in which the baby was born, if part of a delivery having multiple births
CDS_BATCH_CONTENT_SK VARCHAR(40) N Unique identifier for each cds item. This is the unique CDS ID reported to the NHS.
DELIVERY_LOC_IDENT VARCHAR(1) Y A coded classification for place of delivery
DELIVERY_METHOD_NHS VARCHAR(1) Y The method by which a woman is delivered of a baby which is a REGISTERABLE BIRTH.
DELIVERY_PRSNL_STATUS_NHS VARCHAR(1) Y This is normally the status of the individual who delivers the baby. When the delivery is carried out by a student, the individual supervising the delivery should be the one recorded as conducting it. This may be different for each birth in a multiple birth.
FIRST_PROCESS_DT_TM DATETIME N Date and time of the first process
GESTATION_ASSESSMENT_NBR_WEEKS DOUBLE Y This is the same as attribute GESTATION LENGTH and records a period of between 10 to 49 weeks in completed weeks that is a clinical assessment of gestation length within a CDS message.
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 N Date and time of the second process
LIVE_STILL_BIRTH_IND_NHS VARCHAR(1) Y An indicator of whether the birth was a live or still birth. A still birth is a birth after a gestation of 24 weeks (168 days) where the baby shows no identifiable signs of life at delivery
LOCATION_CLASS_NHS VARCHAR(2) Y A classification for use within CDS messages of the physical location within which the recorded patient event occurs
RESUSCITATION_METHOD_NHS VARCHAR(1) Y It records the means by which regular respiration of the baby was attempted. This is not recorded for stillbirths.
TOTAL_UPDATES DOUBLE N The numbers of updates that have occurred on this table.
UKRWH_CDS_APC_BIRTH_KEY DOUBLE N This is a unique local ACTIVITY IDENTIFIER used to identify a birth in augmented care period.
UKRWH_CDS_APC_DELIVERY_KEY DOUBLE N This is a unique local ACTIVITY IDENTIFIER used to identify a delivery in augmented care period.
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.
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.



Relationship Detail - UKRWH_CDS_APC_BIRTH


Child Column in UKRWH_CDS_APC_BIRTH(FK) Parent Table Name Parent Column Name
Parents: UKRWH_CDS_APC_DELIVERY_KEY UKRWH_CDS_APC_DELIVERY UKRWH_CDS_APC_DELIVERY_KEY


UKRWH_CDS_APC_DELIVERY



Column Section Relationship Section Top of Page


Table-level Detail

Description: UK Reporting Warehouse Commissioning Data Delivery
Definition: Contains CDS Delivery details at the level of a Brith relating to an Admitted Patient Care CDS Event.
Table Type: ACTIVITY





Column Detail - UKRWH_CDS_APC_DELIVERY


Column Name Type Null? Definition
ACTIVITY_LOCATION_TYPE_NHS VARCHAR(3) Y The type of LOCATION for an ACTIVITY
ANAESTHETIC_DURING_LABOUR_NHS VARCHAR(1) Y ANAESTHETIC GIVEN DURING LABOUR OR DELIVERY is derived from attribute ANAESTHETIC OR ANALGESIC CATEGORY and PERIOD ADMINISTERED which records whether anaesthetic was given during labour/delivery, and the type used
ANAESTHETIC_POST_LABOUR_NHS VARCHAR(1) Y ANAESTHETIC GIVEN POST LABOUR OR DELIVERY is derived from attribute ANAESTHETIC OR ANALGESIC CATEGORY and PERIOD ADMINISTERED which records whether anaesthetic was given after delivery, and the type used.
ANTENATAL_GMP_IDENT VARCHAR(8) Y This is the GENERAL MEDICAL PRACTITIONER PPD CODE for the GENERAL MEDICAL PRACTITIONER responsible for the PATIENT's antenatal care
ANTENATAL_GP_PRACTICE_ORG_NACS VARCHAR(12) Y This is the ORGANISATION CODE for the General Medical Practitioner Practice responsible for the PATIENT's antenatal care
CDS_BATCH_CONTENT_SK VARCHAR(40) N Unique identifier for each cds item. This is the unique CDS ID reported to the NHS.
DELIVERY_DT_TM DATETIME Y This records the date & time of delivery for each registrable birth and corresponds to the attribute PERSON BIRTH DATE.
DELIVERY_LOC_CHANGE_REASON_NHS VARCHAR(1) Y If the place of delivery is different from the place originally intended, either in the type of place or geographically, the reasons for change should be classified as below
FIRST_ANTENATAL_ASSMNT_DT_TM DATETIME Y 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 N Date and time of the first process
GESTATION_LABOUR_ONSET_WEEKS DOUBLE Y This is the same as attribute GESTATION LENGTH. This records a period of between 10 to 49 weeks in completed weeks of the gestation length at the onset of labour within a CDS message.
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.
INTND_DELIVERY_LOC_TYPE_NHS VARCHAR(1) Y This is the delivery place type where the pregnant woman plans to have her baby. The first intended delivery place type is recorded, as designated by the caring professional in consultation with the client.
LABOUR_DLVRY_ONSET_METHD_NHS VARCHAR(1) Y The method by which the process of labour began, or delivery by caesarean section occurred.
LAST_PROCESS_DT_TM DATETIME N Date and time of the second process
LOCATION_CLASS_NHS VARCHAR(2) Y A classification for use within CDS messages of the physical location within which the recorded patient event occurs
MOTHER_ADDRESS_FORMAT_NHS VARCHAR(2) Y A code to determine the format of the associated PATIENT USUAL ADDRESS (MOTHER) data within CDS Birth Episode and CDS Home Birth
MOTHER_BIRTH_DT_TM DATETIME Y The birth date & time for the mother
MOTHER_LINE1_ADDR VARCHAR(35) Y The first text string comprising one line of an ADDRESS (of Mother).
MOTHER_LINE2_ADDR VARCHAR(35) Y The second text string comprising one line of an ADDRESS.(of Mother)
MOTHER_LINE3_ADDR VARCHAR(35) Y The third text string comprising one line of an ADDRESS.(of Mother)
MOTHER_LINE4_ADDR VARCHAR(35) Y The fourth text string comprising one line of an ADDRESS.(of Mother)
MOTHER_LINE5_ADDR VARCHAR(35) Y The fifth text string comprising one line of an ADDRESS.(of Mother)
MOTHER_LOCAL_PATIENT_IDENT VARCHAR(10) Y This uniquely identifies the mother within CDS Birth Episode and CDS Home Birth where the baby's identity is recorded by use of LOCAL PATIENT IDEN
MOTHER_LOCAL_PATIENT_ORG_NACS VARCHAR(12) Y This is the ORGANISATION CODE of the ORGANISATION that assigned the LOCAL PATIENT IDENTIFIER (MOTHER).
MOTHER_NHS_NBR_IDENT VARCHAR(10) Y The NHS Number of the mother within CDS Birth Episode and CDS Home Birth where the baby is recorded by use of NHS NUMBER.
MOTHER_NHS_NBR_STATUS_NHS VARCHAR(2) Y The NHS Number Status Indicator of the NHS NUMBER (MOTHER) within CDS Birth Episode and CDS Home Birth. The values to be used are as for NHS NUMBER STATUS INDICATOR.
MOTHER_OVERSEAS_VS_NHS VARCHAR(1) Y The status of a MOTHER who is an Overseas Visitor
MOTHER_PATIENT_UNSTRUCT_ADDR VARCHAR(175) Y Mother's full unstructured address
MOTHER_PCT_RESIDENCE_ORG_NACS VARCHAR(12) Y PCT OF RESIDENCE is the same as the attribute ORGANISATION CODE (retired 1 Sep 2008)
MOTHER_POSTCODE VARCHAR(25) Y The code allocated by the Post Office to identify a group of postal delivery points
MOTHER_WITHHELD_FLG VARCHAR(1) Y Indicates whether mother's data has been anonymised
MOTHER_WITHHLD_IDENT_REASN_NHS VARCHAR(2) Y NHS values which identifys that the mother's record has been purposely anonymised for a valid reason
NBR_OF_BABIES_TOT DOUBLE Y This derived data item records the number of REGISTERABLE BIRTHS (live or still born at a particular delivery).
NBR_PREVIOUS_PREGNANCIES_TOT DOUBLE Y The number of previous pregnancies resulting in one or more REGISTERABLE BIRTHS
TOTAL_UPDATES DOUBLE N The numbers of updates that have occurred on this table.
UKRWH_CDS_APC_DELIVERY_KEY DOUBLE N This is a unique local ACTIVITY IDENTIFIER used to identify a delivery during the encounter
UKRWH_CDS_APC_EPISODE_KEY DOUBLE N This is the value of the unique primary identifier of the ukrwh cds apc episode 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.
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.



Relationship Detail - UKRWH_CDS_APC_DELIVERY


Child Column in UKRWH_CDS_APC_DELIVERY(FK) Parent Table Name Parent Column Name
Parents: UKRWH_CDS_APC_EPISODE_KEY UKRWH_CDS_APC_EPISODE UKRWH_CDS_APC_EPISODE_KEY




Parent Column in UKRWH_CDS_APC_DELIVERY (PK) Child Table Name Child Column Name
Children: UKRWH_CDS_APC_DELIVERY_KEY UKRWH_CDS_APC_BIRTH UKRWH_CDS_APC_DELIVERY_KEY


UKRWH_CDS_APC_EPISODE



Column Section Relationship Section Top of Page


Table-level Detail

Description: UK Reporting Warehouse Commissioning Data Set Episode
Definition: Contains CDS Consultant Episode details relating to an Admitted Patient Care CDS Event.
Table Type: ACTIVITY





Column Detail - UKRWH_CDS_APC_EPISODE


Column Name Type Null? Definition
ADMISSION_DT_TM DATETIME Y Date and time of admission
ADMISSION_METHOD_NHS VARCHAR(2) Y The method of admission to a Hospital Provider Spell.
AMBULANCE_INCIDENT_IDENT VARCHAR(20) Y A single trip to, or a return from, a place where a PATIENT receives medical care or treatment.
CDS_BATCH_CONTENT_SK VARCHAR(40) N Unique identifier for each cds item. This is the unique CDS ID reported to the NHS.
DECIDED_TO_ADMIT_DT_TM DATETIME Y This date may be the same as the date & time of admission (e.g. most emergency admissions). Alternatively, a decision can be made to admit at a future date.
DISCHARGE_DESTINATION_NHS VARCHAR(2) Y The destination of a PATIENT on completion of a Hospital Provider Spell, or a note that the PATIENT died or was a still birth
DISCHARGE_DT_TM DATETIME Y Date and time of discharge
DISCHARGE_METHOD_NHS VARCHAR(1) Y The method of discharge from a Hospital Provider Spell
DISCHARGE_READY_DT_TM DATETIME Y The date that a PATIENT was medically ready for discharge from a hospital bed but could not be discharged, thereby qualifying for Delayed Discharge Payments under the provisions of the Community Care (Delayed Discharges etc.) Act 2003
DISCH_HOSP_HOME_SERV_IND_NHS VARCHAR(1) Y An indication of whether a PATIENT was discharged from a Hospital Provider Spell to a Hospital At Home Service.
DURATION_OF_ELECTIVE_WAIT_DAYS DOUBLE Y This derived item records the waiting time from the ORIGINAL DECIDED TO ADMIT DATE to the admission date at the provider where the treatment actually takes place.
EARLIEST_RSNBL_OFFER_DT_TM DATETIME Y It is the date of the earliest of the Reasonable Offers made to a PATIENT for an APPOINTMENT or Elective Admission. It should only be included on the Commissioning Data Sets where the PATIENT has declined at least two Reasonable Offers.
EPISODE_END_DT_TM DATETIME Y The date and time that an Episode ends.
EPISODE_SEQ DOUBLE Y EPISODE NUMBER is the same as attribute ACTIVITY IDENTIFIER and is used to uniquely identify episodes, and is a sequence number for each Consultant Episode (Hospital Provider) in a Hospital Provider Spell. The first episode of each new Hospital Provider Spell (including re-admitted PATIENTS) commences at 01
EPISODE_START_DT_TM DATETIME Y The date and time that an Episode starts.
EPSD_E_WRD_AGEGRP_INTND_NHS VARCHAR(1) Y The age group of PATIENTS intended to use a WARD indicated in the operational plan (at end of the episode)
EPSD_E_WRD_CODE_AT_EOE_NHS VARCHAR(12) Y SITE CODE (OF TREATMENT) is the ORGANISATION SITE CODE of the ORGANISATION where the PATIENT was treated
EPSD_E_WRD_DAY_PRD_AVAIL_NHS VARCHAR(1) Y For WARDS this is the number of day periods in a week for which it is planned to be available. Where a WARD is closed availability will be zero (at end of the episode)
EPSD_E_WRD_INTND_CC_INTNS_NHS VARCHAR(2) Y The level of resources and intensity of care which it is intended to provide or is provided in a particular WARD (at end of the episode)
EPSD_E_WRD_LOCATION_CLASS_NHS VARCHAR(2) Y A classification for use within Commissioning Data Set messages of the physical location within which the recorded patient event occurs at end of the episode
EPSD_E_WRD_LOCATION_TYPE_NHS VARCHAR(3) Y A classification for use within Commissioning Data Set messages of the physical location within which the recorded patient event occurs at end of the episode
EPSD_E_WRD_NGHT_PRD_AVAIL_NHS VARCHAR(1) Y For WARDS this is the number of night periods in a week for which it is planned to be available. Where a WARD is closed availability will be zero (at end of the episode)
EPSD_E_WRD_PATIENT_SEX_CD_NHS VARCHAR(1) Y The gender code of the patient (at end of the episode)
EPSD_E_WRD_SECURITY_LEVEL_NHS VARCHAR(1) Y The level of security for a WARD
EPSD_E_WRD_SITE_TREAT_NACS VARCHAR(12) Y SITE CODE (OF TREATMENT) is the ORGANISATION SITE CODE for the ORGANISATION SITE where the PATIENT was treated. (at end of the episode)
EPSD_S_WRD_AGEGRP_INTND_NHS VARCHAR(1) Y The age group of PATIENTS intended to use a WARD indicated in the operational plan. (at beginning of the episode)
EPSD_S_WRD_CODE_AT_SOE_NHS VARCHAR(12) Y SITE CODE (OF TREATMENT) is the ORGANISATION SITE CODE of the ORGANISATION where the PATIENT was treated
EPSD_S_WRD_DAY_PRD_AVAIL_NHS VARCHAR(1) Y For WARDS this is the number of day periods in a week for which it is planned to be available. Where a WARD is closed availability will be zero (at beginning of the episode)
EPSD_S_WRD_INTND_CC_INTNS_NHS VARCHAR(2) Y The level of resources and intensity of care which it is intended to provide or is provided in a particular WARD (at beginning of the episode)
EPSD_S_WRD_LOCATION_CLASS_NHS VARCHAR(2) Y A classification for use within Commissioning Data Set messages of the physical location within which the recorded patient event occurs at beginning of the episode
EPSD_S_WRD_LOCATION_TYPE_NHS VARCHAR(3) Y The type of LOCATION for an ACTIVITY at the beginning of the episode
EPSD_S_WRD_NGHT_PRD_AVAIL_NHS VARCHAR(1) Y For WARDS this is the number of night periods in a week for which it is planned to be available. Where a WARD is closed availability will be zero (at beginning of the episode)
EPSD_S_WRD_PATIENT_SEX_CD_NHS VARCHAR(1) Y The gender code of the patient (at beginning of the episode)
EPSD_S_WRD_SECURITY_LEVEL_NHS VARCHAR(1) Y The level of security for a WARD
EPSD_S_WRD_SITE_TREAT_NACS VARCHAR(12) Y SITE CODE (OF TREATMENT) is the ORGANISATION SITE CODE for the ORGANISATION SITE where the PATIENT was treated. (at beginning of the episode)
FIRST_PROCESS_DT_TM DATETIME N Date and time of the first process
FIRST_REG_DAY_NIGHT_ADMIT_NHS VARCHAR(1) Y The first admission in a series of regular day/night admissions for a course of treatment
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.
HOSPITAL_PRVDR_SPELL_IDENT VARCHAR(40) Y A number to provide a unique identifier for each Hospital Provider Spell for a Health Care Provider.
INTENDED_MANAGEMENT_NHS VARCHAR(1) Y This categorisation describes what is intended to happen to the PATIENT
LAST_EPISODE_IN_SPELL_NHS VARCHAR(1) Y This derived data element identifies whether the consultant episode is the final episode in the Hospital Provider Spell.
LAST_PROCESS_DT_TM DATETIME N Date and time of the second process
LEGAL_STATUS_CLS_ADMISSION_NHS VARCHAR(2) Y A classification of Legal Status at Admission. The classification 'informal' is used for those PATIENTS who are not formally detained or not receiving supervised aftercare
LENGTH_OF_STAY_ADJ_REHAB DOUBLE Y The total number of days within a Consultant Episode (Hospital Provider) that a discrete period of Rehabilitation activity occurred, which requires an adjustment to the total length of stay for Payment by Results purposes.
LENGTH_OF_STAY_ADJ_SPC DOUBLE Y The total number of days within a Consultant Episode (Hospital Provider) that a discrete period of Specialist Palliative Care activity occurred, which requires an adjustment to the total length of stay for Payment by Results purposes.
MP_OR_MD_CON_IND_CD_NHS VARCHAR(1) Y An indication of whether a PATIENT was seen by a single or multiple CARE PROFESSIONALS during an Clinic Attendance Consultant or Clinic Attendance Non-Consultant, recorded for the purposes of Payment by Results.
NEONATAL_CARE_LEVEL_NHS VARCHAR(1) Y The level of care received by a neonate during a Neonatal Level Of Care Period. For all WARDS caring for neonates, data should be collected daily about the level of care provided for each neonate.
OPERATION_STATUS_NHS VARCHAR(1) Y OPERATION STATUS should be used once for each record to record states of knowledge regarding the operative procedure
ORG_CD_CONVEYING_AMB_TRUST VARCHAR(12) Y "The code of an Ambulance Service which conveys a PATIENT on a PATIENT TRANSPORT JOURNEY"
PATIENT_CLASSIFICATION_NHS VARCHAR(1) Y A coded classification of PATIENTS who have been admitted to a Hospital Provider Spell.
PSYCH_PATIENT_STATUS_NHS VARCHAR(1) Y Where a PATIENT has a history of admissions to several Hospital Provider, then priority between National Codes 1 and 2 should be given to the current Hospital Provider, and National Code 1 selected, irrespective of whether or not the last admission was to the same Hospital Provider
REFERRER_IDENT VARCHAR(8) Y The number of a referral, used to assist in the unique identification of a specific referral (retired 1 Jan 2006)
REFERRER_ORG_NACS VARCHAR(12) Y This is the ORGANISATION CODE of the ORGANISATION from which the referral is made, such as GP Practice or NHS Trust.
REHAB_ASSESSMENT_TEAM_TYPE_NHS VARCHAR(1) Y An indication of whether the CARE PROFESSIONAL TEAM undertaking a Rehabilitation Assessment, is specialised or non-specialised. This information is recorded for the purposes of Payment by Results.
SOURCE_OF_ADMISSION_NHS VARCHAR(2) Y The coded source of admission to a Hospital Provider Spell or a Nursing Episode when the PATIENT is in a Hospital Site or a Care Home.
TOTAL_UPDATES DOUBLE N The numbers of updates that have occurred on this table.
UKRWH_CDS_APC_EPISODE_KEY DOUBLE N This is the value of the unique primary identifier of the ukrwh cds apc episode table. It is an internal system assigned number.
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.
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.
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.



Relationship Detail - UKRWH_CDS_APC_EPISODE


Child Column in UKRWH_CDS_APC_EPISODE(FK) Parent Table Name Parent Column Name
Parents: UKRWH_CDS_HEADER_KEY UKRWH_CDS_HEADER UKRWH_CDS_HEADER_KEY




Parent Column in UKRWH_CDS_APC_EPISODE (PK) Child Table Name Child Column Name
Children: UKRWH_CDS_APC_EPISODE_KEY UKRWH_CDE_APC_EPISODE UKRWH_CDS_APC_EPISODE_KEY
UKRWH_CDS_APC_ACP UKRWH_CDS_APC_EPISODE_KEY
UKRWH_CDS_APC_DELIVERY UKRWH_CDS_APC_EPISODE_KEY
UKRWH_CDS_APC_WARDSTAY UKRWH_CDS_APC_EPISODE_KEY


UKRWH_CDS_APC_WARDSTAY



Column Section Relationship Section Top of Page


Table-level Detail

Description: UK Reporting Warehouse Commissioning Data Set Wardstay
Definition: Contains CDS Wardstay details at the level of a Wardstay relating to an Admitted Patient Care CDS Event.
Table Type: ACTIVITY





Column Detail - UKRWH_CDS_APC_WARDSTAY


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.
CDS_BATCH_CONTENT_SK VARCHAR(40) N Unique identifier for each cds item. This is the unique CDS ID reported to the NHS.
FIRST_PROCESS_DT_TM DATETIME N Date and time of the first process
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 N Date and time of the second process
TOTAL_UPDATES DOUBLE N The numbers of updates that have occurred on this table.
UKRWH_CDS_APC_EPISODE_KEY DOUBLE N This is the value of the unique primary identifier of the ukrwh cds apc episode table. It is an internal system assigned number.
UKRWH_CDS_APC_WARDSTAY_KEY DOUBLE N This is the value of the unique primary identifier of the ukrwh cde apc wardstay 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.
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.
WARD_AGE_GRP_INTENDED_NHS VARCHAR(1) Y The age group of PATIENTS intended to use a WARD indicated in the operational plan (at end of the episode)
WARD_CODE_NHS VARCHAR(12) Y A unique identification of a WARD within a Health Care Provider.
WARD_DAY_AVAIL_NHS VARCHAR(1) Y For WARDS this is the number of day periods in a week for which it is planned to be available. Where a WARD is closed availability will be zero.
WARD_INTND_CC_INTNS_NHS VARCHAR(2) Y The level of resources and intensity of care which it is intended to provide or is provided in a particular WARD (at end of the episode)
WARD_LOCATION_CLASS VARCHAR(2) Y A classification for use within Commissioning Data Set messages of the physical location within which the recorded patient event occurs
WARD_LOCATION_TYPE VARCHAR(3) Y The type of LOCATION for an ACTIVITY
WARD_NIGHT_AVAIL_NHS VARCHAR(1) Y For WARDS this is the number of night periods in a week for which it is planned to be available. Where a WARD is closed availability will be zero.
WARD_PATIENT_SEX_CD_NHS VARCHAR(1) Y The gender code of the patient (at end of the episode)
WARD_SECURITY_LEVEL_NHS VARCHAR(1) Y The level of security for a WARD
WARD_STAY_END_DT_TM DATETIME Y Ward stay end Date and time
WARD_STAY_SEQ DOUBLE Y A number indicating the sequence of the patients ward stay. Ward stay is the time a PATIENT, using a bed and/or using a delivery facility, stays in one WARD.
WARD_STAY_START_DT_TM DATETIME Y Ward stay start Date and time
WARD_TREATMENT_SITE_NACS VARCHAR(12) Y SITE CODE (OF TREATMENT) is the ORGANISATION SITE CODE for the ORGANISATION SITE where the PATIENT was treated. (at end of the episode)



Relationship Detail - UKRWH_CDS_APC_WARDSTAY


Child Column in UKRWH_CDS_APC_WARDSTAY(FK) Parent Table Name Parent Column Name
Parents: UKRWH_CDS_APC_EPISODE_KEY UKRWH_CDS_APC_EPISODE UKRWH_CDS_APC_EPISODE_KEY




Parent Column in UKRWH_CDS_APC_WARDSTAY (PK) Child Table Name Child Column Name
Children: UKRWH_CDS_APC_WARDSTAY_KEY UKRWH_CDE_WARDSTAY UKRWH_CDS_APC_WARDSTAY_KEY


UKRWH_CDS_CC_ACTIVITY



Column Section Top of Page


Table-level Detail

Description: UKRWH_CDS_CC_ACTIVITY
Definition: Contains details for Critical Care activity within a Critical Care period.
Table Type: ACTIVITY





Column Detail - UKRWH_CDS_CC_ACTIVITY


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.
CARE_ACTIVITY_DT DATETIME Y The ACTIVITY DATE where the CARE ACTIVITY is during a CRITICAL CARE PERIOD. Unique per critical care activity.
CDS_BATCH_CONTENT_SK VARCHAR(40) Y Unique identifier for each cds item. This is the unique CDS ID reported to the NHS.
CRITICAL_CARE_ACTIVITY_SEQ DOUBLE Y Number between 1-100 that identifies a unique critical care activity within a period when combined with UKRWH_CRITICAL_CARE_KEY.
FIRST_PROCESS_DT_TM DATETIME N The date/time that the first ETL process started that created this record.
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 N The date/time that the last ETL process started that updated this record.
PATIENT_WEIGHT_KG VARCHAR(7) Y Records the Weight of the PERSON. The field must be padded to match the Format/Length pattern of n3.n3, for example 001.100 is a valid entry (1.1 is invalid).
TOTAL_UPDATES DOUBLE N The numbers of updates that have occurred on this table.
UKRWH_CDS_CC_ACTIVITY_KEY DOUBLE N Unique generated number that identifies a single row on the UKRWH_CDS_CC_ACTIVITY table.
UKRWH_CDS_CRITICAL_CARE_KEY DOUBLE N Unique generated number that identifies a single row on the UKRWH_CRITICAL_CARE table.
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_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 VARCHAR(40) 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.