Table Detail Report

LH_QRDA_NQF_TAG_MAP



Column Section Top of Page


Table-level Detail

Description: LH_QRDA_NQF_TAG_MAP
Definition: Maps a QRDA tag to a group of QRDA records.
Table Type: ACTIVITY





Column Detail - LH_QRDA_NQF_TAG_MAP


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.
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_QRDA_NQF_TAG_MAP_ID DOUBLE N Unique generated number that identifies a row on the table
PARENT_ENTITY_ID DOUBLE N The primary key of the table declared in parent_entity_name.
PARENT_ENTITY_NAME VARCHAR(50) N The name of a table.
QRDA_TAG VARCHAR(50) Y The tag associated with the filtered QRDA data records.
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.


LH_QRDA_OTH_TEMPLATE



Column Section Top of Page


Table-level Detail

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





Column Detail - LH_QRDA_OTH_TEMPLATE


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.
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_QRDA_OTH_TEMPLATE_ID DOUBLE N Unique generated number that identifies a single row on the LH_QRDA_OTH_TEMPLATE 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)
OTHER_TEMPLATE VARCHAR(200) N The name of the template the particular event corresponds to.
PARENT_ENTITY_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)
PARENT_ENTITY_ID2 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)
PARENT_ENTITY_NAME VARCHAR(50) N The name of the table this Other Template section is related (i.e. LH_QRDA_PQRS)
PARENT_ENTITY_NAME2 VARCHAR(50) N The name of the table this Other Template section is related (i.e. LH_QRDA_PQRS)
REPORTING_YEAR DOUBLE Y Stores the reporting year.
RESULT_UNIT VARCHAR(50) Y The units of the numeric result value for the record. This field contains the result unit associated with the respective template data.
RESULT_VALUE_TXT VARCHAR(255) Y This field contains the result value associated with the respective template data.
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_PAYER



Column Section Top of Page


Table-level Detail

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





Column Detail - LH_QRDA_PAYER


Column Name Type Null? Definition
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.
INSRNCE_GRP_NBR DOUBLE Y The group or contract number related to the insurance policy or program
INSRNCE_NAME VARCHAR(50) Y The name of the insurance company
INSRNCE_PLAN_TYPE VARCHAR(50) Y The plan type of the insurance (e.g. PI for Private Insurance)
LAST_PROCESS_DT_TM DATETIME Y The date/time the record was last loaded into the table.
LH_QRDA_PAYER_ID DOUBLE N Unique generated number that identifies a single row on the LH_QRDA_PAYER table.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain.
PARENT_ENTITY_ID DOUBLE N The value of the primary identifier of the table to which the Payer 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 Payer section is related (i.e. LH_QRDA_PQRS)
PARENT_ENTITY_NAME2 VARCHAR(50) N The name of millennium source table
PAYER_ID DOUBLE N Unique identifier for lighthouse PQRS QRDA Payer section
POLICY_TYPE VARCHAR(50) Y The policy or program coverage role type (e.g. 'Self')
POLICY_TYPE_DISPLAY VARCHAR(500) Y Text description of the policy type
POLICY_TYPE_SYSTEM VARCHAR(50) Y String representation of the code system that policy_type was derived from
POLICY_TYPE_SYSTEM_NAME VARCHAR(50) Y Represents the codeSystem string of the code node
POLICY_TYPE_SYSTEM_SDTC VARCHAR(200) Y OID of codeSystem string.
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.


LH_QRDA_PLAN_OF_CARE



Column Section Top of Page


Table-level Detail

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





Column Detail - LH_QRDA_PLAN_OF_CARE


Column Name Type Null? Definition
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_PLAN_OF_CARE_ID DOUBLE N Unique generated number that identifies a single row on the LH_QRDA_PLAN_OF_CARE 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.
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) Y 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
POC_CODE VARCHAR(50) Y Represents a given code value (not Cerner's code_value) from poc_cd system
POC_CODE_DISPLAY VARCHAR(500) Y Description of Plan Of Care Code
POC_CODE_SYSTEM VARCHAR(50) Y Represents the codeSystem string of the observation/code/@codesystem
POC_CODE_SYSTEM_NAME VARCHAR(100) Y String Representation of Plan Of Care Code OID
POC_DT_TM DATETIME Y The date and time of when the plan of care activity was written
POC_ID DOUBLE N Unique plan of care id
POC_STATUS_CODE VARCHAR(50) Y String representation of the current status of the plan of care
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_PQRS



Column Section Top of Page


Table-level Detail

Description: LH_QRDA_PQRS
Definition: This table is used to store elements that er used to create the PQRS QRDA file for submission.
Table Type: ACTIVITY





Column Detail - LH_QRDA_PQRS


Column Name Type Null? Definition
BEG_RPT_DT_TM DATETIME Y The date and time of the beginning of reporting period.
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 The d_prsnl_id of the PPR Physician for the d_person_id attached to this row.
D_PRSNL_ID DOUBLE N Identifies the provider associated with the patient.
END_RPT_DT_TM DATETIME Y The date and time of the end of reporting period.
ERX_VISIT_DATE DATETIME Y The visit date on which the eRx was executed, this will only be populated when pqrs_erx_ind is set to 1
EXTRACT_DT_TM DATETIME Y The date/time that the record was extracted from the source system.
FAC_CITY VARCHAR(100) Y The city field is the text name of the city associated with the address row.
FAC_STATE VARCHAR(100) Y The state field is the text name of the state or province associated with the facility.
FAC_STREET_ADDR VARCHAR(100) Y This is the first line of the street address for the facility.
FAC_STREET_ADDR2 VARCHAR(100) Y This is the second line of the street address for the facility.
FAC_ZIPCODE VARCHAR(25) Y This field contains the postal code for the street address for the facility.
FIRST_PROCESS_DT_TM DATETIME Y The date/time that the first ETL process started that created this record.
HEALTH_INS_NBR_TXT VARCHAR(200) 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_PQRS_ID DOUBLE N Unique generated number that identifies a single row on the LH_QRDA_PQRS 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.
NPI VARCHAR(200) Y National Provider Identifier for an EP
PERSON_ETHNIC_CODE VARCHAR(10) Y CMS defined ethnicity identifier for the given d_person_id
PERSON_RACE_CODE VARCHAR(10) Y CMS defined race identifier for the given d_person_id
PQRS_102_IND DOUBLE Y The PQRS 102 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
PQRS_110_IND DOUBLE Y The PQRS 110 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
PQRS_111_IND DOUBLE Y The PQRS 111 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
PQRS_112_IND DOUBLE Y The PQRS 112 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
PQRS_113_IND DOUBLE Y The PQRS 113 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
PQRS_117_IND DOUBLE Y The PQRS 117 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
PQRS_119_IND DOUBLE Y The PQRS 119 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
PQRS_128_IND DOUBLE Y The PQRS 128 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
PQRS_12_IND DOUBLE Y The PQRS 12 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
PQRS_163_IND DOUBLE Y The PQRS 163 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
PQRS_173_IND DOUBLE Y The PQRS 173 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
PQRS_18_IND DOUBLE Y The PQRS 18 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
PQRS_197_IND DOUBLE Y The PQRS 197 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
PQRS_19_IND DOUBLE Y The PQRS 19 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
PQRS_1_IND DOUBLE Y The PQRS 1 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
PQRS_200_IND DOUBLE Y The PQRS 200 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
PQRS_201_IND DOUBLE Y The PQRS 201 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
PQRS_204_IND DOUBLE Y The PQRS 204 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
PQRS_226_IND DOUBLE Y The PQRS 226 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
PQRS_236_IND DOUBLE Y The PQRS 236 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
PQRS_237_IND DOUBLE Y The PQRS 237 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
PQRS_238_IND DOUBLE Y The PQRS 238 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
PQRS_239_IND DOUBLE Y The PQRS 239 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
PQRS_240_IND DOUBLE Y The PQRS 240 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
PQRS_241_IND DOUBLE Y The PQRS 241 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
PQRS_2_IND DOUBLE Y The PQRS 2 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
PQRS_305_IND DOUBLE Y The PQRS 305 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
PQRS_306_IND DOUBLE Y The PQRS 306 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
PQRS_307_IND DOUBLE Y The PQRS 307 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
PQRS_308_IND DOUBLE Y The PQRS 308 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
PQRS_309_IND DOUBLE Y The PQRS 309 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
PQRS_310_IND DOUBLE Y The PQRS 310 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
PQRS_311_IND DOUBLE Y The PQRS 311 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
PQRS_312_IND DOUBLE Y The PQRS 312 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
PQRS_313_IND DOUBLE Y The PQRS 313 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
PQRS_316_IND DOUBLE Y The PQRS 316 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
PQRS_317_IND DOUBLE Y The PQRS 317 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
PQRS_39_IND DOUBLE Y The PQRS 39 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
PQRS_3_IND DOUBLE Y The PQRS 3 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
PQRS_47_IND DOUBLE Y The PQRS 47 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
PQRS_48_IND DOUBLE Y The PQRS 48 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
PQRS_53_IND DOUBLE Y The PQRS 53 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
PQRS_5_IND DOUBLE Y The PQRS 5 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
PQRS_64_IND DOUBLE Y The PQRS 64 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
PQRS_66_IND DOUBLE Y The PQRS 66 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
PQRS_6_IND DOUBLE Y The PQRS 6 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
PQRS_71_IND DOUBLE Y The PQRS 71 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
PQRS_72_IND DOUBLE Y The PQRS 72 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
PQRS_7_IND DOUBLE Y The PQRS 7 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
PQRS_8_IND DOUBLE Y The PQRS 8 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
PQRS_9_IND DOUBLE Y The PQRS 9 measure is active or inactive. An active measure indicates that the patient has qualified for the measure
PQRS_ERX_IND DOUBLE Y The PQRS ERX measure is active or inactive. An active measure indicates that the patient has qualified for the measure.
TAX_ID_NBR_TXT VARCHAR(50) Y Stores the eligible provider's tax id number.
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.