QMD_ABS_SUBMISSION_RPT



Column Section Top of Page


Table-level Detail

Description: QMD_ABS_SUBMISSION_RPT
Definition: This table stores the submission level report data for clinically abstracted data.
Table Type: ACTIVITY





Column Detail - QMD_ABS_SUBMISSION_RPT


Column Name Type Null? Definition
ADMIT_DT_TM DATETIME Y The date/time that the admission process is performed.
BIRTH_DT_TM DATETIME Y The birth date time of the patient
CCN_NAME VARCHAR(150) Y Stores the name associated to the CCN.
CCN_NBR_TXT VARCHAR(150) Y The CMS Certification Number (CCN) used to uniquely identify a Facility.
COMM_MRN_TXT VARCHAR(50) Y The patients community medical record number.
DISCHARGE_DT_TM DATETIME Y The actual date/time that the patient was discharged from the facility.
ENCNTR_ID DOUBLE Y This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
FINANCIAL_NBR_TXT VARCHAR(50) Y The financial number alias associated to the encounter.
NAME_FULL VARCHAR(100) Y The full name of the patient.
ORG_MRN_TXT VARCHAR(50) Y Identifies the medical record number of the patient.
TABLE_NAME VARCHAR(25) Y The name of the table that the record points to.
UPDT_DT_TM DATETIME Y The date/time that the patient record was added


QMD_ECQM_METRIC_RULES



Column Section Top of Page


Table-level Detail

Description: QMD_ECQM_METRIC_RULES
Definition: Contains the eCQM Metric rules that are needed for electronic submission.
Table Type: ACTIVITY





Column Detail - QMD_ECQM_METRIC_RULES


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.
CREATED_DT_TM DATETIME Y The date and time that the record was created.
DENOM_IND VARCHAR(1000) Y Indicates that the record qualifies as part of the denominator.
METRIC_CONDITION VARCHAR(50) N The condition that the metric belongs to
METRIC_DISPLAY VARCHAR(50) N The display name of the measure
MINIMUM_CRITERIA VARCHAR(500) Y The logic used for calculating the minimum value required for the measure.
POP_IND VARCHAR(1000) Y Indicates that the record qualifies as part of the population.
SUBMETRIC_CONDITION VARCHAR(50) Y The logic used for calculating the sub measure value.
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(100) 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.
YEAR DOUBLE Y The year for which the measure was calculated.


QMD_EPOP_CNT



Column Section Top of Page


Table-level Detail

Description: QMD_EPOP_CNT
Definition: Stores the electronic population count for submission.
Table Type: ACTIVITY





Column Detail - QMD_EPOP_CNT


Column Name Type Null? Definition
BEGIN_DISCHARGE_DT_TM VARCHAR(20) Y The date and time that the discharge process began.
BR_HCO_ID DOUBLE Y Healthcare organization Number (HCO)
DENOM_CNT DOUBLE Y The count of the number of records in the denominator.
END_DISCHARGE_DT_TM VARCHAR(20) Y The date and time that the discharge process was finished.
ERROR_IND DOUBLE Y Indicates if there was an error in generating the record.
FIVE_OR_FEWER VARCHAR(20) Y The logic for the five or fewer submission qualification.
HCO_NBR DOUBLE Y The Healthcare Organizatoin Number
HEALTH_SYSTEM_SOURCE_ID DOUBLE Y The system generated id for the health system source.
METRIC_CONDITION VARCHAR(50) Y The condition that the measure belongs to.
METRIC_DISPLAY VARCHAR(50) Y The display value of the measure.
PERIOD DOUBLE Y The period that the record qualifies for.
PERIOD_DISPLAY VARCHAR(50) Y The period that the record qualifies for.
POP_CNT DOUBLE Y The count of the number of records in the population.
SUBMETRIC_CONDITION VARCHAR(50) Y The condition that the sub measure belongs to.
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(50) 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.
YEAR DOUBLE Y The year of submission that the record qualifies for.


QMD_EPOP_QUERY_LOG



Column Section Top of Page


Table-level Detail

Description: QMD_EPOP_QUERY_LOG
Definition: Stores the process log information for calculating the electronic population record.
Table Type: ACTIVITY





Column Detail - QMD_EPOP_QUERY_LOG


Column Name Type Null? Definition
BR_HCO_ID DOUBLE Y Healthcare organization Number (HCO)
HCO_NBR DOUBLE Y The Healthcare Organizatoin Number
HEALTH_SYSTEM_SOURCE_ID DOUBLE Y The system generated id for the health system source
METRIC_CONDITION VARCHAR(50) Y The condition that the measure belongs to
PERIOD_NBR DOUBLE Y The period that the record qualifies for.
QUERY_LOG VARCHAR(4000) Y The logged information during the creating of the electronic population record.
QUERY_MESSAGE VARCHAR(500) Y The result of the query
SUB_METRIC_CONDITION VARCHAR(50) Y The sub condition that the measure belongs to
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(100) 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.
YEAR DOUBLE Y The year of submission that the record qualifies for.


QMD_LH_E_MEASURE_OUTCOMES



Column Section Top of Page


Table-level Detail

Description: QMD_LH_E_MEASURE_OUTCOMES
Definition: A table that stores the measure outcomes for electronic hospital quality submission that is leveraged by quality clearing house
Table Type: ACTIVITY





Column Detail - QMD_LH_E_MEASURE_OUTCOMES


Column Name Type Null? Definition
DISCHARGE_DT_TM DATETIME Y A column that acts as an identifier for discharge date time from the submission tables.
ENCNTR_ID DOUBLE N A column that acts as an identifier for encounter id from the submission tables.
METRIC_ID DOUBLE N A column that acts as an identifier for metric id from the submission tables.
METRIC_TYPE VARCHAR(50) Y A column that acts as an identifier for metric type from the submission tables.
OUTCOME_1 VARCHAR(20) Y A column the represents the calculated outcome for a hospital quality measure
OUTCOME_10 VARCHAR(20) Y A column the represents the calculated outcome for a hospital quality measure
OUTCOME_11 VARCHAR(20) Y A column the represents the calculated outcome for a hospital quality measure
OUTCOME_12 VARCHAR(20) Y A column the represents the calculated outcome for a hospital quality measure
OUTCOME_13 VARCHAR(20) Y A column the represents the calculated outcome for a hospital quality measure
OUTCOME_14 VARCHAR(20) Y A column the represents the calculated outcome for a hospital quality measure
OUTCOME_15 VARCHAR(20) Y A column the represents the calculated outcome for a hospital quality measure
OUTCOME_16 VARCHAR(20) Y A column the represents the calculated outcome for a hospital quality measure
OUTCOME_17 VARCHAR(20) Y A column the represents the calculated outcome for a hospital quality measure
OUTCOME_18 VARCHAR(20) Y A column the represents the calculated outcome for a hospital quality measure
OUTCOME_19 VARCHAR(20) Y A column the represents the calculated outcome for a hospital quality measure
OUTCOME_2 VARCHAR(20) Y A column the represents the calculated outcome for a hospital quality measure
OUTCOME_20 VARCHAR(20) Y A column the represents the calculated outcome for a hospital quality measure
OUTCOME_3 VARCHAR(20) Y A column the represents the calculated outcome for a hospital quality measure
OUTCOME_4 VARCHAR(20) Y A column the represents the calculated outcome for a hospital quality measure
OUTCOME_5 VARCHAR(20) Y A column the represents the calculated outcome for a hospital quality measure
OUTCOME_6 VARCHAR(20) Y A column the represents the calculated outcome for a hospital quality measure
OUTCOME_7 VARCHAR(20) Y A column the represents the calculated outcome for a hospital quality measure
OUTCOME_8 VARCHAR(20) Y A column the represents the calculated outcome for a hospital quality measure
OUTCOME_9 VARCHAR(20) Y A column the represents the calculated outcome for a hospital 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(50) 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.
VAL_1 VARCHAR(20) Y A column that represents the outcome value for a given hospital quality measure
VAL_10 VARCHAR(20) Y A column that represents the outcome value for a given hospital quality measure
VAL_2 VARCHAR(20) Y A column that represents the outcome value for a given hospital quality measure
VAL_3 VARCHAR(20) Y A column that represents the outcome value for a given hospital quality measure
VAL_4 VARCHAR(20) Y A column that represents the outcome value for a given hospital quality measure
VAL_5 VARCHAR(20) Y A column that represents the outcome value for a given hospital quality measure
VAL_6 VARCHAR(20) Y A column that represents the outcome value for a given hospital quality measure
VAL_7 VARCHAR(20) Y A column that represents the outcome value for a given hospital quality measure
VAL_8 VARCHAR(20) Y A column that represents the outcome value for a given hospital quality measure
VAL_9 VARCHAR(20) Y A column that represents the outcome value for a given hospital quality measure