Table Detail Report

LH_QRDA_INTERVENTION



Column Section Top of Page


Table-level Detail

Description: LH_QRDA_INTERVENTION
Definition: This table is used to store elements that are used to create the Intervention Template Section in the body of a QRDA file for submission
Table Type: ACTIVITY





Column Detail - LH_QRDA_INTERVENTION


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N 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.
EFFECTIVE_DT_TM DATETIME Y The date and time on which the status of the problem was changed
END_EFFECTIVE_DT_TM DATETIME Y The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
EXTRACT_DT_TM DATETIME Y The date/time that the record was extracted from the source system.
FIRST_PROCESS_DT_TM DATETIME Y The date/time that the first ETL process started that created this record.
HEALTH_SYSTEM_ID DOUBLE N Identifies the delivery network responsible for supplying the data.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifies the unique source within the delivery network responsible for supplying the data.
INTERVENTION_TEMPLATE VARCHAR(200) N The name of the template the intervention corresponds to.
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_QRDA_INTERVENTION_ID DOUBLE N Unique generated number that identifies a single row on the LH_QRDA_INTERVENTION table.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
NEGATION_IND DOUBLE Y Indicates whether a negation exists or not
OBS_CODE VARCHAR(50) Y Code derived from Appendix_F-Results tab of Downloadable Resources Table
OBS_CODE_DISPLAY VARCHAR(500) Y Text representation of the result
OBS_CODE_DISPLAY_NEG VARCHAR(500) Y Text representation of the result (negation)
OBS_CODE_NEG VARCHAR(50) Y Represents a given code value (not Cerner's code value) from obs_cd_system (negation)
OBS_CODE_SYSTEM VARCHAR(50) Y The code system from which observation_code was derived from
OBS_CODE_SYSTEM_NAME VARCHAR(50) Y The name of the result's code system (e.g. SNMCT)
OBS_CODE_SYSTEM_NAME_NEG VARCHAR(50) Y The name of the result's code system (negation) (e.g. SNMCT)
OBS_CODE_SYSTEM_NEG VARCHAR(50) Y Represents the codeSystem string of the code node (negation)
OBS_CODE_SYSTEM_SDTC VARCHAR(50) Y The OID of the code system's value set
OBS_CODE_SYSTEM_SDTC_NEG VARCHAR(50) Y The OID of the code system's value set (negation)
PARENT_ENTITY_ID DOUBLE N The value of the primary identifier of the table to which the Intervention section is related (i.e. lh_qrda_pqrs_id)
PARENT_ENTITY_ID2 DOUBLE N The value of the primary identifier of the table to which the Intervention section is related (i.e. lh_qrda_pqrs_id)
PARENT_ENTITY_NAME VARCHAR(50) N The name of the table this Intervention section is related (i.e. LH_QRDA_PQRS)
PARENT_ENTITY_NAME2 VARCHAR(50) N The name of the table this Intervention section is related (i.e. LH_QRDA_PQRS)
REPORTING_YEAR DOUBLE Y Stores the reporting year.
RESULT_OBS_CODE VARCHAR(50) Y Result value set code
RESULT_OBS_CODE_DISPLAY VARCHAR(500) Y Display of value set of result
RESULT_OBS_CODE_SYSTEM VARCHAR(50) Y OID of value set coding system of result
RESULT_OBS_CODE_SYSTEM_NAME VARCHAR(50) Y Value set coding system name of result
RESULT_OBS_CODE_SYSTEM_SDTC VARCHAR(50) Y OID of value set of result
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_SOURCE VARCHAR(50) N The script name responsible for updating the record.
UPDT_TASK VARCHAR(50) 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.


LH_QRDA_MEDICATION



Column Section Top of Page


Table-level Detail

Description: LH_QRDA_MEDICATION
Definition: This table is used to store elements that are used to create the Medication Section in the body of a QRDA file for submission
Table Type: ACTIVITY





Column Detail - LH_QRDA_MEDICATION


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N 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.
DOSE_QUANTITY VARCHAR(50) Y Units of medication to take per administration
EXTRACT_DT_TM DATETIME Y The date/time that the record was extracted from the source system.
FIRST_PROCESS_DT_TM DATETIME Y The date/time that the first ETL process started that created this record.
FREQUENCY VARCHAR(50) Y Indicates the frequency (in hours) of administration
HEALTH_SYSTEM_ID DOUBLE N Identifies the delivery network responsible for supplying the data.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifies the unique source within the delivery network responsible for supplying the data.
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_QRDA_MEDICATION_ID DOUBLE N Unique generated number that identifies a single row on the LH_QRDA_MEDICATION table.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
MEDICATION_DT_TM DATETIME Y Indicates the actual or intended time of administration/dispensing of medication
MEDICATION_END_DT_TM DATETIME Y The date/time the record was end date for medication order into the table.
MEDICATION_TEMPLATE VARCHAR(50) Y Type of medication. Example: Medication Order, Medication Active, Medication Allergy, Medication Intolerance etc.
MEDS_DISPENSE_QTY DOUBLE Y This field contains the dispense quantity of the medication.
MEDS_DISPENSE_QTY_UNIT VARCHAR(100) Y This field contains the unit of the dispense quantity of medication.
MEDS_DURATION DOUBLE Y This field contains the duration for medication.
MEDS_DURATION_UNIT VARCHAR(100) Y This field contains the unit for duration of the medication.
MEDS_FREQUENCY DOUBLE Y This field contains the frequency of the medication.
MEDS_REFILL_CNT DOUBLE Y This field contains the refill count of the medication.
MEDS_STRENGTH_DOSE DOUBLE Y This field contains medication dose's strength.
MEDS_STRENGTH_DOSE_UNIT VARCHAR(100) Y This field contains the unit of the medication dose's strength.
MEDS_VOLUME_DOSE DOUBLE Y This field contains medication dose's volume.
MEDS_VOLUME_DOSE_UNIT VARCHAR(100) Y This field contains the unit of the medication dose's volume.
MED_ID DOUBLE N Unique medication id
MED_STATUS_CODE VARCHAR(50) Y Represents the status of the medication.
NEGATION_IND DOUBLE Y Indicates whether a negation exists or not
NEG_EFFECTIVE_DT_TM DATETIME Y The date/time when the negation was recorded
NEG_PRODUCT_CODE VARCHAR(50) Y CMS code that describes the negation
NEG_PRODUCT_CODE_SYSTEM VARCHAR(50) Y The code system from which neg_product_code was derived from
NEG_PRODUCT_DISPLAY VARCHAR(500) Y Text description of the negation
OBS_CODE_NEG VARCHAR(50) Y Represents a given code value (not Cerner's code value) from obs_cd_system (negation)
OBS_CODE_SYSTEM_NAME_NEG VARCHAR(50) Y The name of the result's code system (negation) (e.g. SNMCT)
OBS_CODE_SYSTEM_NEG VARCHAR(50) Y Represents the codeSystem string of the code node (negation)
OBS_CODE_SYSTEM_SDTC_NEG VARCHAR(50) Y The OID of the code system's value set
OBS_DISPLAY_NEG VARCHAR(500) Y Text representation of the result (negation)
PARENT_ENTITY_ID DOUBLE N The value of the primary identifier of the table to which the Medication section is related (i.e. lh_qrda_pqrs_id)
PARENT_ENTITY_ID2 DOUBLE N The name of millennium source table
PARENT_ENTITY_NAME VARCHAR(50) Y The name of the table this Medication section is related (i.e. LH_QRDA_PQRS)
PARENT_ENTITY_NAME2 VARCHAR(50) N The value of the primary identifier of millennium source table
PRODUCT_CODE VARCHAR(50) Y Code that describes the product/medication
PRODUCT_CODE_SYSTEM VARCHAR(50) Y Code system from which product_cd was derived from
PRODUCT_CODE_SYSTEM_NAME VARCHAR(50) Y The name of the result's code system (e.g. SNMCT)
PRODUCT_CODE_SYSTEM_SDTC VARCHAR(50) Y The OID of the code system's value set
PRODUCT_DISPLAY VARCHAR(500) Y Text description of the product
PRODUCT_FULL_DISPLAY VARCHAR(500) Y Full length text description of the product
REPORTING_YEAR DOUBLE Y Stores the reporting year.
ROUTE_CODE VARCHAR(50) Y Code describing the route of administration
SUPPLY_IND DOUBLE Y Indicates whether the activity is a SubstanceAdministration (medication activity) or Supply (supply activity). 0 indicates medication activity and 1 indicates supply activity
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_SOURCE VARCHAR(50) N The script name responsible for updating the record.
UPDT_TASK VARCHAR(50) 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.


LH_QRDA_NQF



Column Section Top of Page


Table-level Detail

Description: LH_QRDA_PQRS
Definition: This table is used to store elements that are used to create the NQF Stage 2 QRDA file for submission. This table contains one row for each QRDA file that gets created (one file per person per reporting physician).
Table Type: ACTIVITY





Column Detail - LH_QRDA_NQF


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.
BEG_RPT_DT_TM DATETIME Y The date and time of the beginning of reporting period.
BR_CPC_ID DOUBLE N Primary Key of BR_CPC table
BR_CPC_PRACTICE_IDENT VARCHAR(50) Y CPC practice identifier defined in bedrock wizard
BR_CPC_PRACTICE_NAME VARCHAR(255) Y CPC practice name defined in bedrock wizard
BR_GPRO_ID DOUBLE N Primary Key of BR_GPRO table
BR_GPRO_NAME VARCHAR(255) Y Group practice name defined in bedrock wizard
CMS_0022_IND DOUBLE Y The CMS 22 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
CMS_0050_IND DOUBLE Y The CMS 50 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
CMS_0056_IND DOUBLE Y The CMS 56 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
CMS_0061_IND DOUBLE Y The CMS 61 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
CMS_0062_IND DOUBLE Y Indicates if patient qualified for CMS 62.
CMS_0064_IND DOUBLE Y The CMS 64 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
CMS_0065_IND DOUBLE Y The CMS 65 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
CMS_0066_IND DOUBLE Y The CMS 66 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
CMS_0074_1_IND DOUBLE Y To store outcome indicatiore for cms74 pop1
CMS_0074_2_IND DOUBLE Y To store outcome indicatiore for cms74 pop2
CMS_0074_3_IND DOUBLE Y To store outcome indicatiore for cms74 pop3
CMS_0074_4_IND DOUBLE Y To store outcome indicatiore for cms74 pop4
CMS_0074_IND DOUBLE Y The CMS 74 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
CMS_0075_IND DOUBLE Y The CMS 75 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
CMS_0077_IND DOUBLE Y The CMS 77 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
CMS_0082_IND DOUBLE Y The CMS 82 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
CMS_0090_IND DOUBLE Y The CMS 90 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
CMS_0125_IND DOUBLE Y Indicates if patient qualified for CMS 125
CMS_0149_IND DOUBLE Y The CMS 149 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
CMS_0158_IND DOUBLE Y Indicates if patient qualified for CMS 158
CMS_0163_IND DOUBLE Y The CMS 163 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
CMS_0169_IND DOUBLE Y The CMS 169 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
CMS_0179_IND DOUBLE Y The CMS 179 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
CMS_0182_IND DOUBLE Y The CMS 182 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
CMS_PAYER_GROUP VARCHAR(20) Y Indicates the cms payer grouping
CMS_PROGRAM VARCHAR(100) Y Type of submission program: ¿MU_ONLY¿, ¿PQRS_MU_INDIVIDUAL¿, ¿PQRS_MU_GROUP¿, ""CPC""
CPC_TAX_ID_NBR_TXT VARCHAR(50) Y CPC practice tax identification number defined in bedrock wizard
D_FACILITY_ID DOUBLE N Identifies the organization associated with the attribution.
D_PERSON_ID DOUBLE N Identifies the person associated with the quality measure. Foreign key to the PERSON table.
D_PPR_ID DOUBLE N Identifies the primary care provider associated with the patient.
D_PRSNL_ID DOUBLE N Identifies the provider associated with the patient.
ENCNTR_ID DOUBLE N To store encounter id of qualifying patients
END_RPT_DT_TM DATETIME Y The date and time of the end of reporting period.
EXTRACT_DT_TM DATETIME Y The date/time that the record was extracted from the source system.
FIRST_PROCESS_DT_TM DATETIME Y The date/time that the first ETL process started that created this record.
GPRO_TAX_ID_NBR_TXT VARCHAR(50) Y Group practice tax identification number defined in bedrock
HEALTH_INS_NBR_TXT VARCHAR(50) Y Represents the patient's member or subscriber identifier with respect to the payer
HEALTH_SYSTEM_ID DOUBLE N Identifies the delivery network responsible for supplying the data.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifies the unique source within the delivery network responsible for supplying the data.
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_QRDA_NQF_ID DOUBLE N Unique generated number that identifies a single row on the LH_QRDA_NQF table.
LOAD_UTC_OFFSET VARCHAR(5) Y To store the offset difference between local and utc time.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
MRN_TXT VARCHAR(50) Y Used To store MRN for the patient in this table.
NATIONAL_PROVIDER_NBR_TXT VARCHAR(200) Y National Provider Identifier for an EP
NQF2_0002_IND DOUBLE Y The NQF 2 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
NQF2_0004_1_1_IND DOUBLE Y To store outcome indicatiore for nqf4 pop1.1
NQF2_0004_1_2_IND DOUBLE Y To store outcome indicatiore for nqf4 pop1.2
NQF2_0004_1_3_IND DOUBLE Y To store outcome indicatiore for nqf4 pop1.3
NQF2_0004_2_1_IND DOUBLE Y To store outcome indicatiore for nqf4 pop2.1
NQF2_0004_2_2_IND DOUBLE Y To store outcome indicatiore for nqf4 pop2.2
NQF2_0004_2_3_IND DOUBLE Y To store outcome indicatiore for nqf4 pop2.3
NQF2_0004_IND DOUBLE Y The NQF 4 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
NQF2_0018_IND DOUBLE Y The NQF 18 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
NQF2_0022_1_IND DOUBLE Y To store outcome indicatiore for nqf22 pop1
NQF2_0022_2_IND DOUBLE Y To store outcome indicatiore for nqf22 pop2
NQF2_0022_IND DOUBLE Y The NQF 22 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
NQF2_0024_1_1_IND DOUBLE Y To store outcome indicatiore for nqf24 pop1.1
NQF2_0024_1_2_IND DOUBLE Y To store outcome indicatiore for nqf24 pop1.2
NQF2_0024_1_3_IND DOUBLE Y To store outcome indicatiore for nqf24 pop1.3
NQF2_0024_2_1_IND DOUBLE Y To store outcome indicatiore for nqf24 pop2.1
NQF2_0024_2_2_IND DOUBLE Y To store outcome indicatiore for nqf24 pop2.2
NQF2_0024_2_3_IND DOUBLE Y To store outcome indicatiore for nqf24 pop2.3
NQF2_0024_3_1_IND DOUBLE Y To store outcome indicatiore for nqf24 pop3.1
NQF2_0024_3_2_IND DOUBLE Y To store outcome indicatiore for nqf24 pop3.2
NQF2_0024_3_3_IND DOUBLE Y To store outcome indicatiore for nqf24 pop3.3
NQF2_0024_IND DOUBLE Y The NQF 24 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
NQF2_0028_1_IND DOUBLE Y To store outcome indicatiore for nqf28 pop1
NQF2_0028_2_IND DOUBLE Y To store outcome indicatiore for nqf28 pop2
NQF2_0028_3_IND DOUBLE Y To store outcome indicatiore for nqf28 pop3
NQF2_0028_IND DOUBLE Y The NQF 28 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
NQF2_0031_IND DOUBLE Y *** OBSOLETE ***
NQF2_0032_IND DOUBLE Y The NQF 32 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
NQF2_0033_1_IND DOUBLE Y Sub measure NQF2 33_1 stores an outcome mask indicator for measure NQF33 population 1.
NQF2_0033_2_IND DOUBLE Y Sub measure NQF2 33_2 stores an outcome mask indicator for measure NQF33 population 2.
NQF2_0033_3_IND DOUBLE Y Sub measure NQF2 33_3 stores an outcome mask indicator for measure NQF33 population 3.
NQF2_0033_IND DOUBLE Y The NQF 33 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
NQF2_0034_IND DOUBLE Y The NQF 34 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
NQF2_0036_IND DOUBLE Y The NQF 36 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
NQF2_0038_IND DOUBLE Y The NQF 38 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
NQF2_0041_IND DOUBLE Y The NQF 41 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
NQF2_0043_IND DOUBLE Y The NQF 43 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
NQF2_0052_IND DOUBLE Y The NQF 52 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
NQF2_0055_IND DOUBLE Y The NQF 55 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
NQF2_0056_IND DOUBLE Y The NQF 56 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
NQF2_0059_IND DOUBLE Y The NQF 59 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
NQF2_0060_IND DOUBLE Y The NQF 60 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
NQF2_0062_IND DOUBLE Y The NQF 62 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
NQF2_0064_IND DOUBLE Y *** OBSOLETE ***
NQF2_0068_IND DOUBLE Y The NQF 68 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
NQF2_0069_IND DOUBLE Y The NQF 69 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
NQF2_0070_1_IND DOUBLE Y To store outcome indicatiore for nqf70 pop1
NQF2_0070_2_IND DOUBLE Y To store outcome indicatiore for nqf70 pop2
NQF2_0070_IND DOUBLE Y The NQF 70 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
NQF2_0075_IND DOUBLE Y *** OBSOLETE ***
NQF2_0081_1_IND DOUBLE Y To store outcome indicatiore for nqf81 pop1
NQF2_0081_2_IND DOUBLE Y To store outcome indicatiore for nqf81 pop2
NQF2_0081_IND DOUBLE Y The NQF 81 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
NQF2_0083_1_IND DOUBLE Y To store outcome indicatiore for nqf83 pop1
NQF2_0083_2_IND DOUBLE Y To store outcome indicatiore for nqf83 pop2
NQF2_0083_IND DOUBLE Y The NQF 83 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
NQF2_0086_IND DOUBLE Y The NQF 86 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
NQF2_0088_IND DOUBLE Y The NQF 88 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
NQF2_0089_IND DOUBLE Y The NQF 89 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
NQF2_0101_IND DOUBLE Y The NQF 101 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
NQF2_0104_IND DOUBLE Y The NQF 104 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
NQF2_0105_IND DOUBLE Y The NQF 105 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
NQF2_0108_IND DOUBLE Y The NQF 108 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
NQF2_0110_IND DOUBLE Y *** OBSOLETE ***
NQF2_0384_1_IND DOUBLE Y To store outcome indicatiore for nqf384 pop1
NQF2_0384_2_IND DOUBLE Y To store outcome indicatiore for nqf384 pop2
NQF2_0384_IND DOUBLE Y The NQF 384 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
NQF2_0385_IND DOUBLE Y The NQF 385 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
NQF2_0387_IND DOUBLE Y The NQF 387 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
NQF2_0389_IND DOUBLE Y The NQF 389 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
NQF2_0403_IND DOUBLE Y *** OBSOLETE ***
NQF2_0405_IND DOUBLE Y The NQF 405 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
NQF2_0407_IND DOUBLE Y *** OBSOLETE *** The NQF 407 measure is active or inactive. An active measure indicates that the patient has qualified for the measure. This column is obsolete.
NQF2_0418_IND DOUBLE Y The NQF 418 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
NQF2_0419_IND DOUBLE Y The NQF 419 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
NQF2_0421_IND DOUBLE Y The NQF 421 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
NQF2_0564_IND DOUBLE Y The NQF 564 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
NQF2_0565_IND DOUBLE Y The NQF 565 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
NQF2_0608_IND DOUBLE Y *** OBSOLETE *** The NQF 608 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
NQF2_0710_1_IND DOUBLE Y To store outcome indicatiore for nqf710 pop1
NQF2_0710_2_IND DOUBLE Y To store outcome indicatiore for nqf710 pop2
NQF2_0710_3_IND DOUBLE Y To store outcome indicatiore for nqf710 pop3
NQF2_0710_IND DOUBLE Y The NQF 710 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
NQF2_0712_1_1_IND DOUBLE Y To store outcome indicatiore for nqf712 pop1.1
NQF2_0712_1_2_IND DOUBLE Y To store outcome indicatiore for nqf712 pop1.2
NQF2_0712_1_3_IND DOUBLE Y To store outcome indicatiore for nqf712 pop1.3
NQF2_0712_2_1_IND DOUBLE Y To store outcome indicatiore for nqf712 pop2.1
NQF2_0712_2_2_IND DOUBLE Y To store outcome indicatiore for nqf712 pop2.2
NQF2_0712_2_3_IND DOUBLE Y To store outcome indicatiore for nqf712 pop2.3
NQF2_0712_3_1_IND DOUBLE Y To store outcome indicatiore for nqf712 pop3.1
NQF2_0712_3_2_IND DOUBLE Y To store outcome indicatiore for nqf712 pop3.2
NQF2_0712_3_3_IND DOUBLE Y To store outcome indicatiore for nqf712 pop3.3
NQF2_0712_IND DOUBLE Y The NQF 712 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
NQF2_1365_IND DOUBLE Y The NQF 1365 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
NQF2_1401_IND DOUBLE Y *** OBSOLETE *** The NQF 1401 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
PERSON_ETHNIC_CODE VARCHAR(50) Y The code representing the patient's ethnicity
PERSON_ETHNIC_CODE_DISPLAY VARCHAR(500) Y The textual representation of the patient's ethnicity
PERSON_ETHNIC_CODE_SYSTEM VARCHAR(50) Y The code system of the patient's ethnicity
PERSON_ETHNIC_CODE_SYSTEM_NAME VARCHAR(50) Y The name of the patient's ethnicity code system
PERSON_GENDER_CODE VARCHAR(50) Y The code representing the patient's gender
PERSON_GENDER_CODE_DISPLAY VARCHAR(500) Y The textual representation of the patient's gender
PERSON_GENDER_CODE_SYSTEM VARCHAR(50) Y The code system of the patient's gender
PERSON_GENDER_CODE_SYSTEM_NAME VARCHAR(50) Y The name of the patient's gender code system
PERSON_PAYER_CODE VARCHAR(50) Y The policy or program coverage role type (e.g. 'Self').
PERSON_PAYER_CODE_DISPLAY VARCHAR(500) Y Text description of the policy type.
PERSON_PAYER_CODE_SYSTEM VARCHAR(50) Y String representation of the code system that policy was derived from.
PERSON_PAYER_CODE_SYSTEM_NAME VARCHAR(50) Y The name of the policy code system.
PERSON_RACE_CODE VARCHAR(50) Y The code representing the patient's race
PERSON_RACE_CODE_DISPLAY VARCHAR(500) Y The textual representation of the patient's race
PERSON_RACE_CODE_SYSTEM VARCHAR(50) Y The code system of the patient's race
PERSON_RACE_CODE_SYSTEM_NAME VARCHAR(50) Y The name of the patient's race code system
PERSON_TELECOM VARCHAR(50) Y The patient's phone number
SRC_UPDT_DT_TM DATETIME Y Indicates the actual time when the row was inserted or updated at the source
SRC_UPDT_SOURCE VARCHAR(50) N This column is updated with the name of the source program that loaded these rows into this table in Quality Clearinghouse when the Power Insight extracts were executed.
TAX_ID_NBR_TXT VARCHAR(200) Y Tax identifier number for an EP
TIME_ZONE_INDEX DOUBLE Y Stores the time zone index of the local time zone.
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_SOURCE VARCHAR(50) N The script name responsible for updating the record.
UPDT_TASK VARCHAR(50) 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.


LH_QRDA_NQF_AGG



Column Section Top of Page


Table-level Detail

Description: LH_QRDA_NQF_AGG
Definition: This table is used to store elements that are used to store aggregated count for each provider and measure needed in QRDA Category 3 file for submission. This table is at the grain of one provider and measure per row.
Table Type: ACTIVITY





Column Detail - LH_QRDA_NQF_AGG


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.
BR_CPC_ID DOUBLE N Primary Key of BR_CPC table
BR_GPRO_ID DOUBLE N Primary Key of BR_GPRO table
BR_GPRO_SUB_ID DOUBLE Y Unique generated number that identifies a single row on the BR_GPRO_SUB table.
CMS_PROGRAM VARCHAR(100) Y Type of submission program: 'NQF', 'PQRS', 'GPRO-PQRS', 'GPRO-NQF', 'CPC'
DEN_CNT DOUBLE Y The value of the primary identifier of the table to which the Other Template section is related (i.e. lh_qrda_pqrs_id)
DEN_EXCL_CNT DOUBLE Y The value of the primary identifier of the table to which the Other Template section is related (i.e. lh_qrda_pqrs_id)
DEN_EXCP_CNT DOUBLE Y The value of the primary identifier of the table to which the Other Template section is related (i.e. lh_qrda_pqrs_id)
D_PRSNL_ID DOUBLE N The value of the primary identifier of the table to which the Other Template section is related (i.e. lh_qrda_pqrs_id)
EFFECTIVE_DT_TM DATETIME Y The date and time on which the status of the problem was changed
EXTRACT_DT_TM DATETIME Y The date/time that the record was extracted from the source system.
FIRST_PROCESS_DT_TM DATETIME Y The date/time that the first ETL process started that created this record.
HEALTH_SYSTEM_ID DOUBLE N Identifies the delivery network responsible for supplying the data.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifies the unique source within the delivery network responsible for supplying the data.
IPP_CNT DOUBLE Y The value of the primary identifier of the table to which the Other Template section is related (i.e. lh_qrda_pqrs_id)
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_QRDA_NQF_AGG_ID DOUBLE N Unique generated number that identifies a single row on the LH_QRDA_NQF_AGG table.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
MEASURE_GROUP VARCHAR(50) Y The name of the table this Other Template section is related (i.e. LH_QRDA_PQRS)
MSR_PERCENT DOUBLE Y Contains the calculated measure percentage, derived from either a measure-specific calculation or as the result of a generic measure calculation of (numerator / (denominator - exclusions - exceptions)
MSR_POP_CNT DOUBLE Y The value of the primary identifier of the table to which the Other Template section is related (i.e. lh_qrda_pqrs_id)
NUM_CNT DOUBLE Y The value of the primary identifier of the table to which the Other Template section is related (i.e. lh_qrda_pqrs_id)
NUM_EXCL_CNT DOUBLE Y This field contains the count of numerator exclusion patients in respective measures.
NUM_EXCP_CNT DOUBLE Y The value of the primary identifier of the table to which the Other Template section is related (i.e. lh_qrda_pqrs_id)
QRDA_TAG VARCHAR(50) Y The tag associated with the filtered QRDA data records.
REPORTING_CATEGORY DOUBLE Y Indicates if the report category is QRDA 1 or QRDA 3.
REPORTING_YEAR DOUBLE Y Stores the reporting year.
SRC_UPDT_DT_TM DATETIME Y Indicates the actual time when the row was inserted or updated at the source
SRC_UPDT_SOURCE VARCHAR(50) N This column is updated with the name of the source program that loaded these rows into this table in Quality Clearinghouse when the Power Insight extracts were executed.
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_SOURCE VARCHAR(50) N The script name responsible for updating the record.
UPDT_TASK VARCHAR(50) 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.


LH_QRDA_NQF_SUPPLEMENT



Column Section Top of Page


Table-level Detail

Description: LH_QRDA_NQF_SUPPLEMENT
Definition: This table is used to calculate aggregated count for supplement data (gender, race, ethnicity, payer) for each provider and measure needed in QRDA Category 3 file for submission. It contains the outcome for all qualified patients for each measure. This table is at the grain of one patient per provider and measure per row. The combination of parent_entity_id and measure_group is unique.
Table Type: ACTIVITY





Column Detail - LH_QRDA_NQF_SUPPLEMENT


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N 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.
ENCNTR_ID DOUBLE N The ID of the encounter associated to the supplement data.
EXTRACT_DT_TM DATETIME Y The date/time that the program running the extracts was started. This field should be the same across all files and across all records within a file for a given extraction 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 Identifies the delivery network responsible for supplying the data.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifies the unique source within the delivery network responsible for supplying the data.
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_QRDA_NQF_SUPPLEMENT_ID DOUBLE N Unique generated number that identifies a single row on the LH_QRDA_NQF_SUPPLEMENT table.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
MEASURE_GROUP VARCHAR(50) Y Population group like NQF2_0024, CMS_0065 etc. It will also have sub-measure level detail
OUTCOME_FLAG DOUBLE N Numeric value to determine if the patient is in numerator/denominator/exclusion/ipp
PARENT_ENTITY_ID DOUBLE N The value of the primary identifier of the table to which the supplement data is related (i.e. lh_qrda_nqf_id)
PARENT_ENTITY_NAME VARCHAR(50) N The name of the table this supplement data is related (i.e. LH_QRDA_NQF)
SRC_UPDT_DT_TM DATETIME Y Indicates the actual time when the row was inserted or updated at the source
SRC_UPDT_SOURCE VARCHAR(50) N This column is updated with the name of the source program that loaded these rows into this table in Quality Clearinghouse when the Power Insight extracts were executed.
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_SOURCE VARCHAR(50) N The script name responsible for updating the record.
UPDT_TASK VARCHAR(50) 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.