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