Table Detail Report

UKRWH_CDS_CC_ACTIVITY_CODE



Column Section Top of Page


Table-level Detail

Description: UKRWH_CDS_CC_ACTIVITY_CODE
Definition: Contains details of the type of Critical care activity provided to a patient during a Critical care period.
Table Type: ACTIVITY





Column Detail - UKRWH_CDS_CC_ACTIVITY_CODE


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_CD_NHS VARCHAR(2) Y A type of CRITICAL CARE ACTIVITY provided to a patient during a CRITICAL CARE PERIOD.
ACTIVITY_CD_SEQ DOUBLE Y Number between 1-20 that uniquely identifies the type of activity within a critical care activity when combined with UKRWH_CARE_ACTIVITY_KEY.
CDS_BATCH_CONTENT_SK VARCHAR(40) Y 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.
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_CC_ACTIVITY_CODE_KEY DOUBLE N Unique generated number that identifies a single row on the UKRWH_CDS_CC_ACTIVITY_CODE table.
UKRWH_CDS_CC_ACTIVITY_KEY DOUBLE N Unique generated number that identifies a single row on the UKRWH_CRITICAL_CARE_ACTIVITY 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.


UKRWH_CDS_CC_ACTIVITY_DRUG



Column Section Top of Page


Table-level Detail

Description: UKRWH_CDS_CC_ACTIVITY_DRUG
Definition: Contains details for the use of high cost drugs as per OPCS-4 definitions provided per Critical Care Activity.
Table Type: ACTIVITY





Column Detail - UKRWH_CDS_CC_ACTIVITY_DRUG


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) Y Unique identifier for each cds item. This is the unique CDS ID reported to the NHS.
DRUG_SEQ DOUBLE Y Number between 1-20 that uniquely identifies the use of a high cost drug within a critical care activity when combined with UKRWH_CARE_ACTIVITY_KEY.
DRUG_VALUE VARCHAR(40) Y This is the OPCS-4 definition for a high cost drug used as part of a CRITICAL CARE ACTIVITY.
FIRST_PROCESS_DT_TM DATETIME N First date/time row was inserted into table.
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 Last date/time row was updated.
TOTAL_UPDATES DOUBLE N The numbers of updates that have occurred on this table.
UKRWH_CDS_CC_ACTIVITY_DRUG_KEY DOUBLE N Unique generated number that identifies a single row on the UKRWH_CDS_CC_ACTIVITY_DRUG table.
UKRWH_CDS_CC_ACTIVITY_KEY DOUBLE N Unique generated number that identifies a single row on the UKRWH_CRITICAL_CARE_ACTIVITY 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.
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_CODED_ASSESSMNT



Column Section Top of Page


Table-level Detail

Description: UK Reporting Warehouse Commissioning Data Set Coded Assessment
Definition: Contains details of the SNOMED CT coded scores.
Table Type: ACTIVITY





Column Detail - UKRWH_CDS_CODED_ASSESSMNT


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.
ASSESMT_TOOL_VALIDTN_DT_TM DATETIME Y The date and time that the coded assessment tool type was validated by the care professional.
CDS_BATCH_CONTENT_SK VARCHAR(40) N Unique identifier for each CDS item. This is the unique CDS ID reported to the NHS.
CODED_ASSESSMENT_SEQ DOUBLE Y Sequence number of coded scored assessment.
CODED_ASSESSMENT_TOOL_TYPE_SCT VARCHAR(100) Y The SNOMED CT concept ID which is used to identify an assessment tool.
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_ASSESMT_TOOL_VALIDTN_DT_TM DATETIME Y The local date and time that the coded assessment tool type was validated by the care professional.
PERSON_SCORE VARCHAR(10) Y The score taken from an assessment tool.
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_CODED_ASSESSMNT_KEY DOUBLE N This is the value of the unique primary identifier of the UKRWH_CDS_CODED_ASSESSMENT 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_CODED_FINDING



Column Section Top of Page


Table-level Detail

Description: UK Reporting Warehouse Commissioning Data Set Coded Finding
Definition: Contains details of the SNOMED CT coded clinical findings.
Table Type: ACTIVITY





Column Detail - UKRWH_CDS_CODED_FINDING


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.
CODED_FINDING_DT_TM DATETIME Y The date and time that the clinical finding was recorded by a care professional.
CODED_FINDING_SCT VARCHAR(100) Y The SNOMED CT concept ID which is used to identify a finding.
CODED_FINDING_SEQ DOUBLE Y Sequence number of coded clinical finding.
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_CODED_FINDING_DT_TM DATETIME Y The local date and time that the clinical finding was recorded by a care professional.
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_CODED_FINDING_KEY DOUBLE N This is the value of the unique primary identifier of the UKRWH_CDS_CODED_FINDING 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_CODED_OBSRV



Column Section Top of Page


Table-level Detail

Description: UK Reporting Warehouse Commissioning Data Set Coded Clinical Observations.
Definition: Contains details of the SNOMED CT coded scores.
Table Type: ACTIVITY





Column Detail - UKRWH_CDS_CODED_OBSRV


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.
CODED_OBSERVATION_DT_TM DATETIME Y The date and time that the observable entity was recorded by a care professional.
CODED_OBSERVATION_SCT VARCHAR(100) Y The SNOMED CT concept ID which is used to identify an observable entity.
CODED_OBSERVATION_SEQ DOUBLE Y Sequence number of coded clinical observation.
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_CODED_OBSERVATION_DT_TM DATETIME Y The local date and time that the observable entity was recorded by a care professional.
OBSERVATION_VALUE VARCHAR(10) Y The value of a clinical investigation result item.
TOTAL_UPDATES DOUBLE N The numbers of updates that have occurred on this table.
UCUM_UNIT_OF_MEASUREMENT VARCHAR(10) Y The unit of measurement using the Unified Code for Units of Measure code system.
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_CODED_OBSRV_KEY DOUBLE N This is the value of the unique primary identifier of the UKRWH_CDS_CODED_OBSERVATION 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.