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