Table Detail Report
UKRWH_CDS_CRITICAL_CARE
Column Section | Top of Page |
Table-level Detail
Description: | UKRWH_CDS_CRITICAL_CARE |
Definition: | Contains details for Critical Care periods. |
Table Type: | ACTIVITY |
Column Detail - UKRWH_CDS_CRITICAL_CARE
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. |
ADV_CARDIO_SUPPORT_DAYS | DOUBLE | Y | The total number of days that the PATIENT received advance cardiovascular support during a CRITICAL CARE PERIOD, ranging from 000 to 997 days. |
ADV_RESPIRATORY_SUPPORT_DAYS | DOUBLE | Y | The total number of days that the PATIENT received advance respiratory support during a CRITICAL CARE PERIOD. |
BASIC_CARDIO_SUPPORT_DAYS | DOUBLE | Y | The total number of days that the PATIENT received basic cardiovascular support during a CRITICAL CARE PERIOD, ranging from 000 to 997 days. |
BASIC_RESPIRATORY_SUPPORT_DAYS | DOUBLE | Y | The total number of days that the PATIENT received basic respiratory support during a CRITICAL CARE PERIOD. |
CDS_BATCH_CONTENT_SK | VARCHAR(40) | Y | Unique identifier for each cds item. This is the unique CDS ID reported to the NHS. |
CDS_UNIQUE_IDENT | VARCHAR(35) | Y | When exchanging Commissioning Data Set data, this is an optional data element and when used is a unique number generated by the sender and inserted into the Commissioning Data Set data to enable senders and recipients to be able to cross-match and uniquely identify each and every Commissioning Data Set record. |
CRITICAL_CARE_LOCAL_SK | VARCHAR(40) | Y | A unique local ACTIVITY IDENTIFIER used to identify the start of CARE ACTIVITY within a CRITICAL CARE PERIOD.This locally defined variable should as a minimum include a sequential numerical component that can discriminate two or more CRITICAL CARE PERIODS occurring on the same calendar day for the same patient. |
CRITICAL_CARE_LVL_2_DAYS | DOUBLE | Y | The total number of days a PATIENT received level 2 care during a CRITICAL CARE PERIOD. From 000 to 997 days can be recorded; if 998 or more days have occurred the default code should be used. |
CRITICAL_CARE_LVL_3_DAYS | DOUBLE | Y | The total number of days a PATIENT received level 3 care during a CRITICAL CARE PERIOD. From 000 to 997 days can be recorded; if 998 or more days have occurred the default code should be used. |
CRITICAL_CARE_PERIOD_SEQ | DOUBLE | Y | Number between 1-9 that identifies a unique critical care period when combined with cds_batch_content_sk. |
CRITICAL_CARE_SRC_LOC_NHS | VARCHAR(2) | Y | The type of location the PATIENT was in prior to the start of the CRITICAL CARE PERIOD. |
CRITICAL_CARE_SRC_OF_ADM_NHS | VARCHAR(2) | Y | The primary organisation type that the PATIENT has been admitted from prior to the start of the CRITICAL CARE PERIOD. |
CRITICAL_CARE_START_DT_TM | DATETIME | Y | The start date and time of a CRITICAL CARE PERIOD. |
CRITICAL_CARE_TYPE_NHS | VARCHAR(2) | Y | An identifier for the type of Critical Care period. Possible values: 01 - Neonatal Critical Care Period02 - Paediatric Critical Care Period03 - Adult Critical Care Period |
CRITICAL_CARE_TYPE_OF_ADM_NHS | VARCHAR(2) | Y | An indication of whether a CRITICAL CARE PERIOD was initiated as a result of a non-emergency treatment plan, for example, for elective major surgery. This relates only to the period of critical care and not to the nature of the hospital admission. |
CRITICAL_CARE_UNIT_FUNC_NHS | VARCHAR(2) | Y | The National Codes for non standard locations may be recorded where the delivery of care is CRITICAL CARE LEVEL National Code 02 'Level 2' or 03 'level 3' and the duration of care is greater than four hours. |
DERMATALOGICAL_SUPPORT_DAYS | DOUBLE | Y | The total number of days that the PATIENT received dermatological system support during a CRITICAL CARE PERIOD, ranging from 000 to 997 days. |
DISCHARGE_DESTINATION_NHS | VARCHAR(2) | Y | The primary organisation type that the PATIENT has been discharged to at the end of the CRITICAL CARE PERIOD. |
DISCHARGE_DT_TM | DATETIME | Y | The end date and time of a CRITICAL CARE PERIOD. This may be the date the PATIENT is discharged from the critical care unit, the date the PATIENT died or the date of declaration of brainstem death. |
DISCHARGE_LOCATION_NHS | VARCHAR(2) | Y | The principal location that the PATIENT is discharged to at the end of the CRITICAL CARE PERIOD. |
DISCHARGE_READY_DT_TM | DATETIME | Y | The date and time on which the PATIENT has been declared clinically ready for discharge or transfer from the CRITICAL CARE PERIOD and a formal request has been made to the Hospital Bed management system (or appropriate staff with authority to admit at the intended destination) and the date and time of this status is recorded as such in the clinical record. |
DISCHARGE_STATUS_NHS | VARCHAR(2) | Y | This is the same as attribute CRITICAL CARE DISCHARGE STATUS. |
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. |
FIRST_PROCESS_DT_TM | DATETIME | N | First date/time row was inserted into table. |
GASTRO_INTESTINAL_SUPPORT_DAYS | DOUBLE | Y | The total number of days that the PATIENT received gastro-intestinal system support during a CRITICAL CARE PERIOD, ranging from 000 to 997 days. |
GESTATION_LABOUR_ONSET_WEEKS | DOUBLE | Y | This is the same as attribute GESTATION LENGTH and records a period of between 10 to 49 weeks in completed weeks at delivery. |
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(12) | Y | A number to provide a unique identifier for each Hospital Provider Spell for a Health Care Provider. |
LAST_PROCESS_DT_TM | DATETIME | N | Last date/time row was updated. |
LIVER_SUPPORT_DAYS | DOUBLE | Y | The total number of days that the PATIENT received liver support during a CRITICAL CARE PERIOD, ranging from 000 to 997 days. |
LOCAL_PATIENT_IDENT | VARCHAR(10) | Y | An identifier, other than a name, which identifies a PERSON. |
MAX_NBR_OF_ORGAN_SUPPORT | DOUBLE | Y | The maximum number of ORGAN SYSTEMS SUPPORTED on any one day during a CRITICAL CARE PERIOD. Each organ system can only be counted once on any calendar day. Both basic and advanced categories cannot be counted at the same time. The number of organ systems supported can be between 00 to 07, although for the purposes of recording on the Commissioning Data Set messages Gastro-intestinal support days are not recorded so the maximum is effectively 06. |
NEURO_SUPPORT_DAYS | DOUBLE | Y | The total number of days that the PATIENT received neurological system support during a CRITICAL CARE PERIOD, ranging from 000 to 999 days. |
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. |
RENAL_SUPPORT_DAYS | DOUBLE | Y | The total number of days that the PATIENT received renal system support during a CRITICAL CARE PERIOD. |
TOTAL_UPDATES | DOUBLE | N | The numbers of updates that have occurred on this table. |
UKRWH_CDS_APC_EPISODE_KEY | DOUBLE | Y | Unique generated number that identifies a single row on the UKRWH_CDS_APC_EPISODE table. |
UKRWH_CDS_CRITICAL_CARE_KEY | DOUBLE | N | Unique generated number that identifies a single row on the UKRWH_CDS_CRITICAL_CARE table. |
UNIT_BED_CONFIG_NHS | VARCHAR(2) | Y | The main composition of critical care bed types for the WARD. |
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. |
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. |
UKRWH_CDS_DIAGNOSIS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | UK Reporting Warehouse Commissioning Data Set Diagnosis |
Definition: | Contains CDS Diagnois details at the level of a Diagnosis relating to a CDS Event. |
Table Type: | ACTIVITY |
Column Detail - UKRWH_CDS_DIAGNOSIS
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. |
DIAGNOSIS_CD_TXT | VARCHAR(6) | Y | This field contains the diagnostic observations recorded about a PATIENT. |
DIAGNOSIS_PRES_ADM_IND_NHS | VARCHAR(1) | Y | An indication of whether a PATIENT DIAGNOSIS was already present when the PATIENT started a Hospital Provider Spell. |
DIAGNOSIS_SCHEME_NHS | VARCHAR(2) | Y | This is used in the Commissioning Data Set - Clinical Information Group to denote the Coding Scheme basis of the Diagnosis. |
DIAGNOSIS_SEQ | DOUBLE | Y | Sequence number of the Diagnosis |
EC_DIAGNOSIS_QUALIFIER_SCT | VARCHAR(100) | Y | The SNOMED CT concept ID which is used to express the level of certainty of a patient diagnosis. |
EC_DIAGNOSIS_SCT | VARCHAR(100) | Y | The SNOMED CT concept ID which is used to identify the patient diagnosis. |
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. |
TOTAL_UPDATES | DOUBLE | N | The numbers of updates that have occurred on this table. |
UKRWH_CDS_DIAGNOSIS_KEY | DOUBLE | N | This is the value of the unique primary identifier of the ukrwh cds diagnosis 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. 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. |
Relationship Detail - UKRWH_CDS_DIAGNOSIS
Child Column in UKRWH_CDS_DIAGNOSIS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | UKRWH_CDS_HEADER_KEY | UKRWH_CDS_HEADER | UKRWH_CDS_HEADER_KEY |
UKRWH_CDS_EAL_ENTRY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | UK Reporting Warehouse Commissioning Data Set Elective Admission List Entry |
Definition: | Contains CDS EAL Entry details relating to an EAL CDS Event. |
Table Type: | ACTIVITY |
Column Detail - UKRWH_CDS_EAL_ENTRY
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVITY_LOC_TYPE_NHS | VARCHAR(3) | Y | The type of LOCATION for an ACTIVITY. |
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 | The date a DECISION TO ADMIT was made. |
EAL_ENTRY_SK | VARCHAR(40) | Y | A number to provide a unique identifier for each ELECTIVE ADMISSION LIST ENTRY within an ELECTIVE ADMISSION LIST. |
EAL_STATUS_NHS | VARCHAR(2) | Y | This data item is derived and indicates whether a PATIENT is available for treatment or suspended from the ELECTIVE ADMISSION LIST for medical or social reasons. |
EAL_TYPE_NHS | VARCHAR(2) | Y | This data item is derived and indicates whether a PATIENT is available for treatment or suspended from the ELECTIVE ADMISSION LIST for medical or social reasons. |
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. |
FIRST_PROCESS_DT_TM | DATETIME | N | Date and time of the first process |
GUARANTEED_ADMISSION_DT_TM | DATETIME | Y | The date by which a PATIENT on an ELECTIVE ADMISSION LIST is guaranteed to be admitted |
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. |
INTENDED_MANAGEMENT_NHS | VARCHAR(1) | Y | This is the intended pattern of bed use for a PATIENT, decided when the decision is made to admit. |
INTENDED_PROC_STATUS_NHS | VARCHAR(1) | Y | Indicates whether an Operative procedure is intended, NOT intended or Not known. |
INTNDD_TREATMENT_SITE_NACS | VARCHAR(12) | Y | This is the ORGANISATION SITE CODE for the ORGANISATION SITE where it is intended to treat the PATIENT. This enables those organisations to be recorded which have been sub-commissioned to provide treatment. |
LAST_DNA_CANCELLED_DT_TM | DATETIME | Y | The DATE recorded when PATIENTS who have been offered a date for admission have missed this admission date with or without advance notice. |
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. |
LOC_DECIDED_TO_ADMIT_DT_TM | DATETIME | Y | The date a decision to admit was made. |
LOC_GUARANTEED_ADMISSION_DT_TM | DATETIME | Y | The date by which a patient on an elective admission list is guaranteed to be admitted |
NHS_SRVC_AGREEMENT_CHG_DT_TM | DATETIME | Y | The date of a change to a SERVICE PROVIDED UNDER AGREEMENT |
ORIG_DECIDED_TO_ADMIT_DT_TM | DATETIME | Y | This is the date of the first DECISION TO ADMIT a PATIENT to a Health Care Provider for a given condition which results in the PATIENT being placed on a ELECTIVE ADMISSION LIST. |
PRIORITY_TYPE_NHS | VARCHAR(1) | Y | This is the priority of a request for services; in the case of services to be provided by a CONSULTANT, it is as assessed by or on behalf of the CONSULTANT. |
SUSPENDED_DAYS | DOUBLE | Y | SUSPENDED DAYS IN REPORTING PERIOD is the sum of the calculated periods of suspension and should be recorded left justified with leading zeros. |
TOTAL_UPDATES | DOUBLE | N | The numbers of updates that have occurred on this table. |
UKRWH_CDS_EAL_ENTRY_KEY | DOUBLE | N | A unique ID which denotes an entry on an ELECTIVE ADMISSION LIST denoting a PATIENT for whom the DECISION TO ADMIT has been made. |
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. |
WL_ENTRY_LAST_REVIEW_DT_TM | DATETIME | Y | The date on which an ELECTIVE ADMISSION LIST ENTRY was last reviewed. |
Relationship Detail - UKRWH_CDS_EAL_ENTRY
Child Column in UKRWH_CDS_EAL_ENTRY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | UKRWH_CDS_HEADER_KEY | UKRWH_CDS_HEADER | UKRWH_CDS_HEADER_KEY |
Parent Column in UKRWH_CDS_EAL_ENTRY (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | UKRWH_CDS_EAL_ENTRY_KEY | UKRWH_CDE_EAL_ENTRY | UKRWH_CDS_EAL_ENTRY_KEY |
UKRWH_CDS_EAL_OFFER | UKRWH_CDS_EAL_ENTRY_KEY | ||
UKRWH_CDS_EAL_REMOVAL | UKRWH_CDS_EAL_ENTRY_KEY | ||
UKRWH_CDS_EAL_SUSPENSION | UKRWH_CDS_EAL_ENTRY_KEY |
UKRWH_CDS_EAL_OFFER
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | UK Reporting Warehouse Commissioning Data Set Elective Admission List Offer |
Definition: | Contains CDS EAL Offer details relating to an EAL Offer CDS Event. |
Table Type: | ACTIVITY |
Column Detail - UKRWH_CDS_EAL_OFFER
Column Name | Type | Null? | Definition |
---|---|---|---|
ADMISSION_OFFER_OUTCOME_NHS | VARCHAR(1) | Y | A code which indicates the outcome of an OFFER OF ADMISSION to a PATIENT on an ELECTIVE ADMISSION LIST. |
CDS_BATCH_CONTENT_SK | VARCHAR(40) | N | Unique identifier for each cds item. This is the unique CDS ID reported to the NHS. |
CDS_UPDATE_DEL_FLG | DOUBLE | Y | A code to indicate the required database update process for the submitted cds message. |
EAL_ENTRY_SK | VARCHAR(40) | Y | A number to provide a unique identifier for each ELECTIVE ADMISSION LIST ENTRY within an ELECTIVE ADMISSION LIST. |
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. |
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 |
LOC_UKRWH_CDS_EAL_OFFER_DT_TM | DATETIME | Y | The date offered for admission to hospital to start a hospital provider spell. |
OFFER_FOR_ADMISSION_DT_TM | DATETIME | Y | Date offered for admission to hospital to start a Hospital Provider Spell. |
QMCO_BREACH_FLG | DOUBLE | Y | A flag to denote whether a hospital cancellation for non-clinical reasons, of a scheduled elective surgery has breached the 28 days rule to offer a reschedule and attend a new surgery. |
TOTAL_UPDATES | DOUBLE | N | The numbers of updates that have occurred on this table. |
UKRWH_CDS_EAL_ENTRY_KEY | DOUBLE | N | A unique ID which denotes an entry on an ELECTIVE ADMISSION LIST denoting a PATIENT for whom the DECISION TO ADMIT has been made. |
UKRWH_CDS_EAL_OFFER_KEY | DOUBLE | N | A unique ID which denotes an ELECTIVE ADMISSION LIST offer for a PATIENT for whom the DECISION TO ADMIT has been made. |
UKRWH_HEADER_KEY | DOUBLE | N | Uniquely identifies the Header id related to a cds extract load. |
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_EAL_OFFER
Child Column in UKRWH_CDS_EAL_OFFER(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | UKRWH_CDS_EAL_ENTRY_KEY | UKRWH_CDS_EAL_ENTRY | UKRWH_CDS_EAL_ENTRY_KEY |
UKRWH_HEADER_KEY | UKRWH_CDS_HEADER | UKRWH_CDS_HEADER_KEY |
Parent Column in UKRWH_CDS_EAL_OFFER (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | UKRWH_CDS_EAL_OFFER_KEY | UKRWH_CDE_SCH_EVENT_ACTION | UKRWH_CDS_EAL_OFFER_KEY |
UKRWH_CDS_EAL_REMOVAL
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | UK Reporting Warehouse Commissioning Data Set Elective Admission List Removal |
Definition: | Contains CDS EAL Removal details relating to an EAL Removal CDS Event. |
Table Type: | ACTIVITY |
Column Detail - UKRWH_CDS_EAL_REMOVAL
Column Name | Type | Null? | Definition |
---|---|---|---|
CDS_BATCH_CONTENT_SK | VARCHAR(40) | N | Unique identifier for each cds item. This is the unique CDS ID reported to the NHS. |
CDS_UPDATE_DEL_FLG | DOUBLE | Y | A code to indicate the required database update process for the submitted cds message. |
EAL_ENTRY_SK | VARCHAR(40) | Y | A number to provide a unique identifier for each ELECTIVE ADMISSION LIST ENTRY within an ELECTIVE ADMISSION LIST. |
FIRST_PROCESS_DT_TM | DATETIME | N | Date and time of the first process |
HEALTH_SYSTEM_ID | DOUBLE | Y | Unique number assigned by Health Facts. Typically the universal Cerner assigned client id of the health system. |
HEALTH_SYSTEM_SOURCE_ID | DOUBLE | Y | 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 |
LOC_REMOVAL_DT_TM | DATETIME | Y | The date removed from the elective admission list. Removal may be due to admission to a hospital provider spell, death or other reasons. |
REMOVAL_DT_TM | DATETIME | Y | Date removed from the ELECTIVE ADMISSION LIST. Removal may be due to admission to a Hospital Provider Spell, death or other reasons. |
REMOVAL_REASON_NHS | VARCHAR(1) | Y | This records the reason why a PATIENT was removed from the ELECTIVE ADMISSION LIST. |
TOTAL_UPDATES | DOUBLE | N | The numbers of updates that have occurred on this table. |
UKRWH_CDS_EAL_ENTRY_KEY | DOUBLE | N | A unique ID which denotes an entry on an ELECTIVE ADMISSION LIST denoting a PATIENT for whom the DECISION TO ADMIT has been made. |
UKRWH_CDS_EAL_REMOVAL_KEY | DOUBLE | N | A unique ID which denotes an ELECTIVE ADMISSION LIST removal for a PATIENT for whom the DECISION TO ADMIT has been made. |
UKRWH_HEADER_KEY | DOUBLE | Y | Uniquely identifies the Header id related to a cds extract load. |
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_EAL_REMOVAL
Child Column in UKRWH_CDS_EAL_REMOVAL(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | UKRWH_CDS_EAL_ENTRY_KEY | UKRWH_CDS_EAL_ENTRY | UKRWH_CDS_EAL_ENTRY_KEY |
UKRWH_HEADER_KEY | UKRWH_CDS_HEADER | UKRWH_CDS_HEADER_KEY |