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