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 |