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