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 |