Table Detail Report

UKRWH_CDS_EAL_SUSPENSION



Column Section Relationship Section Top of Page


Table-level Detail

Description: UK Reporting Warehouse Commissioning Data Set Elecive Admission List Suspension
Definition: Contains CDS EAL Suspension details relating to an EAL Suspension CDS Event.
Table Type: ACTIVITY





Column Detail - UKRWH_CDS_EAL_SUSPENSION


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 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_SUSPENSION_END_DT_TM DATETIME Y The end date of an elective admission suspension detail at which the patient ceases to be suspended from an elective admission list entry.
LOC_SUSPENSION_START_DT_TM DATETIME Y The start date of an elective admission suspension detail at which the patient is suspended from an elective admission list entry due to medical or patient initiated reasons.
SUSPENSION_END_DT_TM DATETIME Y The End Date of an ELECTIVE ADMISSION SUSPENSION DETAIL at which the PATIENT ceases to be suspended from an ELECTIVE ADMISSION LIST ENTRY.
SUSPENSION_START_DT_TM DATETIME Y The Start Date of an ELECTIVE ADMISSION SUSPENSION DETAIL at which the PATIENT is suspended from an ELECTIVE ADMISSION LIST ENTRY due to medical or PATIENT initiated reasons.
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_SUSPENSION_KEY DOUBLE N A unique ID which denotes an ELECTIVE ADMISSION LIST suspension 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_SUSPENSION


Child Column in UKRWH_CDS_EAL_SUSPENSION(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


UKRWH_CDS_EC_CARE_PROF



Column Section Top of Page


Table-level Detail

Description: UK Reporting Warehouse Commissioning Data Set Emergency Care Care Professionals
Definition: Contains details of the care professionals active during the Emergency Care Attendance.
Table Type: ACTIVITY





Column Detail - UKRWH_CDS_EC_CARE_PROF


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_PROFESSIONAL_SEQ DOUBLE Y Sequence number of Care Professional for Emergency Care.
CARE_PROFESSIONAL_TIER_NHS VARCHAR(2) Y The tier of care professional treating the patient during an emergency care attendance.
CDS_BATCH_CONTENT_SK VARCHAR(40) N Unique identifier for each CDS item. This is the unique CDS ID reported to the NHS.
CLINICAL_RESPONSBLTY_DT_TM DATETIME Y Date and Time when the Care Professional first became clinically responsible for the patient.
DISCH_RESPONSIBILITY_IND_NHS VARCHAR(1) Y An indication of whether a care professional is responsible for discharge of the patient from an emergency care attendance.
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.
LOC_CLINICAL_RESPONSBLTY_DT_TM DATETIME Y The local Date and Time when the Care Professional first became clinically responsible for the patient.
PROFESSIONAL_REG_ENTRY_IDENT VARCHAR(40) Y The registration identifier allocated by an organisation.
PROFESSIONAL_REG_ISSUER_NHS VARCHAR(2) Y A code which identifies the professional registration body.
TOTAL_UPDATES DOUBLE N The numbers of updates that have occurred on this table.
UKRWH_CDS_AE_ATTENDANCE_KEY DOUBLE N A number allocated by an Accident and Emergency Department to provide a unique identifier for each Accident and Emergency Attendance.
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 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.
URKWH_CDS_EC_CARE_PROF_KEY DOUBLE N This is the value of the unique primary identifier of the URKWH_CDS_EC_CARE_PROF table. It is an internal system assigned number.


UKRWH_CDS_EC_CLINICAL_HIST



Column Section Top of Page


Table-level Detail

Description: UK Reporting Warehouse Commissioning Data Set Emergency Care Clinical History
Definition: Contains clinical history of Emergency Department patients.
Table Type: ACTIVITY





Column Detail - UKRWH_CDS_EC_CLINICAL_HIST


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.
CLINICIAL_HISTORY_SEQ DOUBLE Y Sequence number of Emergency Care Clinical History.
COMORBIDITY_SCT VARCHAR(100) Y The SNOMED CT concept ID which is used to identify comorbid conditions.
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_AE_ATTENDANCE_KEY DOUBLE N A number allocated by an Accident and Emergency Department to provide a unique identifier for each Accident and Emergency Attendance.
UKRWH_CDS_EC_CLINICAL_HIS_KEY DOUBLE N This is the value of the unique primary identifier of the UKRWH_CDS_EC_CLINICIAL_HIST 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 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.


UKRWH_CDS_EC_INJURY



Column Section Top of Page


Table-level Detail

Description: UK Reporting Warehouse Commissioning Data Set Emergency Care Injury
Definition: Contains injury characteristics of Emergency Department patients.
Table Type: ACTIVITY





Column Detail - UKRWH_CDS_EC_INJURY


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.
ALCOHOL_DRUG_INVOLVEMENT_SCT VARCHAR(100) Y The SNOMED CT concept ID which is used to identify any drugs or alcohol used by the patient, which are thought likely to have contributed to the need to attend the emergency care department.
ASSAULT_LOCATION_DESC VARCHAR(255) Y Free text description to provide further comment and details of the location where an assault took place.
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 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.
INJURY_ACTIVITY_STATUS_SCT VARCHAR(100) Y The SNOMED CT concept ID which is used to identify the status of activity being undertaken by the patient when the injury occurred.
INJURY_ACTIVITY_TYPE_SCT VARCHAR(100) Y The SNOMED CT concept ID which is used to identify the type of activity being undertaken by the person at the moment the injury occurred.
INJURY_DT_TM DATETIME Y The date and time that the patient was injured. Where this information cannot be obtained directly from the patient (or patient proxy), the Injury Date Time should be estimated.
INJURY_INTENT_SCT VARCHAR(100) Y The SNOMED CT concept ID which is used to identify the most likely human intent in the occurrence of the injury or poisoning as assessed by the care professional.
INJURY_MECHANISM_SCT VARCHAR(100) Y The SNOMED CT concept ID which is used to identify how an injury was caused.
INJURY_SEQ DOUBLE Y Sequence number of Emergency Care Injury Characteristics record.
LAST_PROCESS_DT_TM DATETIME N The date/time that the last ETL process started that updated this record.
LOC_INJURY_DT_TM DATETIME Y The local date and time that the patient was injured. Where this information cannot be obtained directly from the patient (or patient proxy), the Injury Date Time should be estimated.
PLACE_OF_INJURY_LATITUDE VARCHAR(40) Y The latitude of the emergency care place of injury (SNOMED CT), expressed in decimal degrees.
PLACE_OF_INJURY_LONGITUDE VARCHAR(40) Y The longitude of the emergency care place of injury (SNOMED CT), expressed in decimal degrees.
PLACE_OF_INJURY_SCT VARCHAR(100) Y The SNOMED CT concept ID which is used to identify the type of location at which the patient was present when the injury occurred.
TOTAL_UPDATES DOUBLE N The numbers of updates that have occurred on this table.
UKRWH_CDS_AE_ATTENDANCE_KEY DOUBLE N A number allocated by an Accident and Emergency Department to provide a unique identifier for each Accident and Emergency Attendance.
UKRWH_CDS_EC_INJURY_KEY DOUBLE N This is the value of the unique primary identifier of the UKRWH_CDS_EC_INJURY 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 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.


UKRWH_CDS_EC_MENTAL_HEALTH



Column Section Top of Page


Table-level Detail

Description: UK Reporting Warehouse Commissioning Data Set Emergency Care Mental Health
Definition: Contains Mental Health Act Legal Status of Emergency Department patients.
Table Type: ACTIVITY





Column Detail - UKRWH_CDS_EC_MENTAL_HEALTH


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 Commissioning Data Set Batch Content Source 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 Health System Identifier
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Health System Source Identifier
LAST_PROCESS_DT_TM DATETIME N The date/time that the last ETL process started that updated this record.
LOC_MENTAL_HEALTH_EXPIRY_DT_TM DATETIME Y Mental Health Act Legal Status Classification Expiry Local Date Time
LOC_MENTAL_HEALTH_START_DT_TM DATETIME Y Mental Health Act Legal Status Classification Assignment Period Start Local Date Time
MENTAL_HEALTH_EXPIRY_DT_TM DATETIME Y Mental Health Act Legal Status Classification Expiry Date Time
MENTAL_HEALTH_LEGAL_STATUS_NHS VARCHAR(2) Y Mental Health Act Legal Status Classification NHS Code
MENTAL_HEALTH_SEQ DOUBLE Y Emergency Care Mental Health Record Sequence
MENTAL_HEALTH_START_DT_TM DATETIME Y Mental Health Act Legal Status Classification Assignment Period Start Date Time
TOTAL_UPDATES DOUBLE N Total Updates
UKRWH_CDS_AE_ATTENDANCE_KEY DOUBLE N UKRWH Commissioning Data Set Accident & Emergency Attendance Key
UKRWH_CDS_EC_MENTAL_HEALTH_KEY DOUBLE N This is the value of the unique primary identifier of the UKRWH_CDS_EC_MENTAL_HEALTH table. It is an internal system assigned number.
UPDATE_USER VARCHAR(40) N Update User
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 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.