Table Detail Report

LH_QRDA_ALERTS



Column Section Top of Page


Table-level Detail

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





Column Detail - LH_QRDA_ALERTS


Column Name Type Null? Definition
ALERT_ID DOUBLE N Unique alert id
ALLERGY_STATUS_CD VARCHAR(50) Y The code associated with an allergy
ALLERGY_STATUS_CD_SYSTEM VARCHAR(50) Y Represents the codeSystem string of the observation/code/@codesystem
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.
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_QRDA_ALERTS_ID DOUBLE N Unique generated number that identifies a single row on the LH_QRDA_ALERTS 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
ONSET_DT_TM DATETIME Y Indicates the timing of the concern
PARENT_ENTITY_ID DOUBLE N The value of the primary identifier of the table to which the Problem section is related (i.e. lh_qrda_pqrs_id)
PARENT_ENTITY_ID2 DOUBLE N The value of the primary identifier of millennium source table
PARENT_ENTITY_NAME VARCHAR(50) N The name of the table this Problem section is related (i.e. LH_QRDA_PQRS)
PARENT_ENTITY_NAME2 VARCHAR(50) Y The name of millennium source table
PARTICIPANT_CD VARCHAR(50) Y The value for participant / participantRole / playingEntity / code SHALL be selected from the Appendix_H-Alerts tab of the Downloadable Resources table.
PARTICIPANT_CD_DISPLAY VARCHAR(500) Y String representation of Participant Code
PARTICIPANT_CD_SYSTEM VARCHAR(50) Y Represents the codeSystem string of the observation/code/@codesystem
PARTICIPANT_CD_SYSTEM_NAME VARCHAR(100) Y Description of Participant_CD's OID system
REACTION_CD VARCHAR(50) Y The value for Observation / statusCode in a reaction observation SHALL be completed 2.16.840.1.113883.5.14 ActStatus STATIC.
REACTION_CD_SYSTEM VARCHAR(50) Y Coding system used for the given reaction_cd.
SEVERITY_CD VARCHAR(50) Y The value for Observation / code in a severity observation SHALL be SEV Severity observation 2.16.840.1.113883.5.4 ActCode STATIC.
SEVERITY_CD_SYSTEM VARCHAR(50) Y Coding system used for the given severity_cd.
SEVERITY_VALUE VARCHAR(50) Y Value representing the severity.
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_EC



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_QRDA_EC
Definition: This table is used to store elements that are used to create the EC 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_EC


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
BR_GPRO_SUB_ID DOUBLE Y Unique generated number that identifies a single row on the BR_GPRO_SUB table.
BR_GPRO_SUB_NAME VARCHAR(255) Y The name given to the subgroup by a client.
BR_GPRO_SUB_NBR_TXT VARCHAR(50) Y User-entered alphanumeric value for the subgroup number.
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
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
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_CQM_REPORT_TYPE_TFLG VARCHAR(5) Y Determines the reporting type as MIPs or MVPs.
LH_QRDA_EC_ID DOUBLE N Primary key of the LH_QRDA_EC table.
LOAD_UTC_OFFSET VARCHAR(5) Y Stores the offset value for the timezone. eg: -0600/+0600
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 EC
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
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) Y 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 EC
TIME_ZONE_INDEX DOUBLE Y Stores the time zone index of the local time zone.
UPDT_CNT DOUBLE Y 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 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_SOURCE VARCHAR(50) Y The script name responsible for updating the record.
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.



Relationship Detail - LH_QRDA_EC


Child Column in LH_QRDA_EC(FK) Parent Table Name Parent Column Name
Parents: D_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FACILITY HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_D_PERSON D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PERSON HEALTH_SYSTEM_SOURCE_ID
D_PPR_ID LH_D_PERSONNEL D_PRSNL_ID
D_PRSNL_ID LH_D_PERSONNEL D_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PERSONNEL HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PERSONNEL HEALTH_SYSTEM_SOURCE_ID




Parent Column in LH_QRDA_EC (PK) Child Table Name Child Column Name
Children: HEALTH_SYSTEM_SOURCE_ID LH_QRDA_EC_DETAIL HEALTH_SYSTEM_SOURCE_ID
LH_QRDA_EC_ID LH_QRDA_EC_DETAIL LH_QRDA_EC_ID


LH_QRDA_EC_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_QRDA_EC_DETAIL
Definition: This schema will be used to store the patient outcome information measure wise for each EC.
Table Type: ACTIVITY





Column Detail - LH_QRDA_EC_DETAIL


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.
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. Part of the FK relationship to the LH_QRDA_EC parent table.
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_QRDA_EC_DETAIL_ID DOUBLE N Unique generated number that identifies a single row on the LH_QRDA_EC_DETAIL table.
LH_QRDA_EC_ID DOUBLE N Primary key of lh_qrda_ec table
MEASURE_GROUP VARCHAR(50) Y Name of measure.
OUTCOME_FLAG DOUBLE Y Outcome flag of a patient
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) Y 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 Y 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 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_SOURCE VARCHAR(50) Y The script name responsible for updating the record.
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.



Relationship Detail - LH_QRDA_EC_DETAIL


Child Column in LH_QRDA_EC_DETAIL(FK) Parent Table Name Parent Column Name
Parents: HEALTH_SYSTEM_SOURCE_ID LH_QRDA_EC HEALTH_SYSTEM_SOURCE_ID
LH_QRDA_EC_ID LH_QRDA_EC LH_QRDA_EC_ID


LH_QRDA_ENCOUNTER



Column Section Top of Page


Table-level Detail

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





Column Detail - LH_QRDA_ENCOUNTER


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_CODE_ID DOUBLE N Primary key of the encounter table
ENCNTR_DT_TM DATETIME Y The date and time the encounter was registered on
ENCNTR_END_DT_TM DATETIME Y The date and time the encounter was discharged or departed.
ENCNTR_TEMPLATE VARCHAR(50) Y The name of the template the encounter corresponds to
ENCNTR_TYPE_CODE VARCHAR(50) Y The code associated with the type of an encounter
ENCNTR_TYPE_DISPLAY VARCHAR(500) Y Text description of the encounter type
ENC_CODE VARCHAR(100) Y The encounter code that will be displayed in the documentation of node.
ENC_CODE_DISPLAY VARCHAR(500) Y Coding system name
ENC_CODE_DISPLAY_NEG VARCHAR(500) Y Text representation of a negation reason of a problem
ENC_CODE_NEG VARCHAR(50) Y The problem value code associated with a negation reason for a problem
ENC_CODE_SYSTEM VARCHAR(100) Y The encounter code system that will be displayed in the documentation of node.
ENC_CODE_SYSTEM_NAME VARCHAR(100) Y The encounter code system name that will be displayed in the documentation of node.
ENC_CODE_SYSTEM_NAME_NEG VARCHAR(50) Y Coding system name of negation reason
ENC_CODE_SYSTEM_NEG VARCHAR(50) Y The codeSystem from which the negation reason of a problem_value was derived from
ENC_CODE_SYSTEM_SDTC VARCHAR(50) Y OID of value set
ENC_CODE_SYSTEM_SDTC_NEG VARCHAR(50) Y OID of value set of negation reason
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.
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_QRDA_ENCOUNTER_ID DOUBLE N Unique generated number that identifies a single row on the LH_QRDA_ENCOUNTER 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
PARENT_ENTITY_ID DOUBLE N The value of the primary identifier of the table to which the Plan of Care section is related (i.e. lh_qrda_pqrs_id)
PARENT_ENTITY_ID2 DOUBLE N The value of the primary identifier of millennium source table
PARENT_ENTITY_NAME VARCHAR(50) N The name of the table this Plan of Care section is related (i.e. LH_QRDA_PQRS)
PARENT_ENTITY_NAME2 VARCHAR(50) N The name of millennium source table
REPORTING_YEAR DOUBLE Y Stores the reporting year.
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_IMMUNIZATION



Column Section Top of Page


Table-level Detail

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





Column Detail - LH_QRDA_IMMUNIZATION


Column Name Type Null? Definition
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 the record was first loaded into the table.
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 the record was last loaded into the table.
LH_QRDA_IMMUNIZATION_ID DOUBLE N Unique generated number that identifies a single row on the LH_QRDA_IMMUNIZATION table.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain.
MEDICATION_DT_TM DATETIME Y Indicates the actual or intended time of administration/dispensing of medication
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
PARENT_ENTITY_ID DOUBLE N The value of the primary identifier of the table to which the Immunization section is related (i.e. lh_qrda_pqrs_id)
PARENT_ENTITY_ID2 DOUBLE N The value of the primary identifier of millennium source table
PARENT_ENTITY_NAME VARCHAR(50) Y The name of the table this Immunization section is related (i.e. LH_QRDA_PQRS)
PARENT_ENTITY_NAME2 VARCHAR(50) N The name 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_DISPLAY VARCHAR(500) Y Text description of the product
PRODUCT_FULL_DISPLAY VARCHAR(500) Y Full length text description of the product
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.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
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.