Table Detail Report

WH_PCA_QUALITY_MEASURE



Column Section Top of Page


Table-level Detail

Description: WH_PCA_QUALITY_MEASURE
Definition: This table Details the procedures that have been determined as measurements of some Topic. This table may serve as a dimension table for certain fact tables containing aggregations related to this Quality Measure.
Table Type: ACTIVITY





Column Detail - WH_PCA_QUALITY_MEASURE


Column Name Type Null? Definition
CALC_SCRIPT_NAME VARCHAR(40) Y The Discern Explorer program object which does the processing on the data that was qualified for this Quality Measure.
DESCRIPTION_TXT VARCHAR(255) Y Comment which provides additional meaning or context to the Quality Measure.
DISPLAY_TXT VARCHAR(60) Y The textual displayed description for this Quality Measure.
EXTRACT_DT_TM DATETIME Y The date and time for which extracts were run.
FIRST_PROCESS_DT_TM DATETIME Y The date/time that the first ETL process started that created this record.
HEALTH_SYSTEM_ID DOUBLE N The unique identifier that identifies a client health system id
HEALTH_SYSTEM_SOURCE_ID DOUBLE N The unique identifier that identifies a client health system source id
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
MEASURE_CD DOUBLE N The CODE VALUE record which identifies the Quality Measure.
MEASURE_TYPE_FLAG DOUBLE Y Indicates the type of measure being created. 0 = Person Measure, 1 = Visit measure
PCA_QUALITY_MEASURE_ID DOUBLE N The Discern Explorer program object which does the processing on the data that was qualified for this Quality Measure.
PCA_SOURCE_ID DOUBLE N The source that supplied this Quality Measure.
PREP_SCRIPT_NAME VARCHAR(40) Y The Discern Explorer program which is used to prepare the associated activity tables for data associated with this quality measure.
QUAL_SCRIPT_NAME VARCHAR(40) Y The Discern Explorer program object which is used to determine which data needs to be processed for this quality measure.
UPDT_DT_TM DATETIME Y 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) Y 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.
UPDT_USER VARCHAR(40) Y The user that performs the insert or update to the record