Table Detail Report

LH_QRDA_PROBLEM



Column Section Top of Page


Table-level Detail

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





Column Detail - LH_QRDA_PROBLEM


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.
EVENT_END_DT_TM DATETIME Y This field is to specify the end date time of the event either Diagnosis or Problem
EXTRACT_DT_TM DATETIME Y The date/time that the record was extracted from the source system.
FAMILY_MBR_CODE VARCHAR(50) Y Family member associated with the patient for family history diagnosis
FAMILY_MBR_CODE_NAME VARCHAR(50) Y Family member associated with the patient for family history diagnosis
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_PROBLEM_ID DOUBLE N Unique generated number that identifies a single row on the LH_QRDA_PROBLEM 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) N The name of millennium source table
PRIORITY_LEVEL DOUBLE Y Indicates the priority of the diagnosis.
PROBLEM_INSTANCE_ID DOUBLE N Unique identifier for PROBLEM table
PROBLEM_STATUS_CODE VARCHAR(50) Y The code that will be used to represent the @code attribute in value node
PROBLEM_STATUS_CODE_SYSTEM VARCHAR(50) Y The code system from which problem_status_cd was derived from
PROBLEM_STATUS_DISPLAY VARCHAR(500) Y Text representation of the status of a problem
PROBLEM_STATUS_DT_TM DATETIME Y The date and time on which the status of the problem was changed
PROBLEM_TEMPLATE VARCHAR(50) Y The name of the template the problem corresponds to
PROBLEM_VALUE VARCHAR(50) Y The problem value code associated with a problem
PROBLEM_VALUE_DISPLAY VARCHAR(500) Y Text representation of a problem
PROBLEM_VALUE_DISPLAY_NEG VARCHAR(500) Y Text representation of a negation reason of a problem
PROBLEM_VALUE_NEG VARCHAR(50) Y The problem value code associated with a negation reason for a problem
PROBLEM_VALUE_SYSTEM VARCHAR(50) Y The codeSystem from which the problem_value was derived from
PROBLEM_VALUE_SYSTEM_NAME VARCHAR(50) Y Coding system name
PROBLEM_VALUE_SYSTEM_NAME_NEG VARCHAR(50) Y Coding system name of negation reason
PROBLEM_VALUE_SYSTEM_NEG VARCHAR(50) Y The codeSystem from which the negation reason of a problem_value was derived from
PROBLEM_VALUE_SYSTEM_SDTC VARCHAR(50) Y OID of value set
PROBLEM_VALUE_SYSTEM_SDTC_NEG VARCHAR(50) Y OID of value set of negation reason
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_PROCEDURE



Column Section Top of Page


Table-level Detail

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





Column Detail - LH_QRDA_PROCEDURE


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.
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_PROCEDURE_ID DOUBLE N Unique generated number that identifies a single row on the LH_QRDA_PROCEDURE 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 Procedure section is related (i.e. lh_qrda_pqrs_id)
PARENT_ENTITY_ID2 DOUBLE N The value of the primary identifier of the millennium table to which the Procedure section is related
PARENT_ENTITY_NAME VARCHAR(50) Y The name of the table this Procedure section is related (i.e. LH_QRDA_PQRS)
PARENT_ENTITY_NAME2 VARCHAR(50) N The name of the millennium table this Procedure section is related
PRIORITY_LEVEL DOUBLE N Indicates the priority of the procedure.
PROCEDURE_ID DOUBLE N Unique identifier for PROCEDURE table
PROC_CODE VARCHAR(50) Y Represents a given code value (not Cerner's code value) from proc_cd_system
PROC_CODE_DISPLAY VARCHAR(500) Y Text representation of the procedure
PROC_CODE_DISPLAY_NEG VARCHAR(500) Y Text representation of the procedure (negation)
PROC_CODE_NEG VARCHAR(50) Y Represents a given code value (not Cerner's code value) from proc_cd_system (negation)
PROC_CODE_SYSTEM VARCHAR(50) Y Represents the codeSystem string of the code node
PROC_CODE_SYSTEM_NAME VARCHAR(50) Y The name of the procedure's code system (e.g. SNMCT)
PROC_CODE_SYSTEM_NAME_NEG VARCHAR(50) Y The name of the procedure's code system (negation) (e.g. SNMCT)
PROC_CODE_SYSTEM_NEG VARCHAR(50) Y Represents the codeSystem string of the code node (negation)
PROC_CODE_SYSTEM_SDTC VARCHAR(50) Y The OID of the code system's value set
PROC_CODE_SYSTEM_SDTC_NEG VARCHAR(50) Y The OID of the code system's value set (negation)
PROC_DT_TM DATETIME Y The date and time the procedure was performed.
PROC_END_DT_TM DATETIME Y The date/time the record was end date for procedure into the table.
PROC_STATUS_CODE VARCHAR(50) Y The status code of the procedure
PROC_TEMPLATE VARCHAR(50) Y The name of the template the procedure corresponds to
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_PROV_DET



Column Section Top of Page


Table-level Detail

Description: LH_QRDA_PROV_DET
Definition: This table is used to store elements that are used to provide additional information for each provider needed in QRDA Category 1 and 3 file for submission. This table is at the grain of one provider per row.
Table Type: ACTIVITY





Column Detail - LH_QRDA_PROV_DET


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.
AUTHOR_CITY VARCHAR(50) Y The author's location city
AUTHOR_NPI VARCHAR(50) Y The author's national provider ID
AUTHOR_ORG_NAME VARCHAR(50) Y The name of the author's organization
AUTHOR_STATE VARCHAR(50) Y The author's location state
AUTHOR_STREET_ADDR VARCHAR(200) Y The author's street address
AUTHOR_STREET_ADDR2 VARCHAR(200) Y The second line of the author's street address
AUTHOR_TELECOM VARCHAR(50) Y The author's phone number
AUTHOR_ZIPCODE VARCHAR(50) Y The author's location zip code
BR_CPC_ID DOUBLE N The id of the cpc practice site set in bedrock
BR_GPRO_ID DOUBLE N The id of the provider group set in bedrock
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'
CUSTODIAN_CITY VARCHAR(50) Y The custodian's location city
CUSTODIAN_NPI VARCHAR(50) Y The custodian's national provider ID
CUSTODIAN_ORG_NAME VARCHAR(50) Y The name of the custodian's organization
CUSTODIAN_STATE VARCHAR(50) Y The custodian's location state
CUSTODIAN_STREET_ADDR VARCHAR(200) Y The custodian's street address
CUSTODIAN_STREET_ADDR2 VARCHAR(200) Y The second line of the custodian's street address
CUSTODIAN_TELECOM VARCHAR(50) Y The custodian's phone number
CUSTODIAN_ZIPCODE VARCHAR(50) Y The custodian's location zip code
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)
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.
LEGAL_AUTH_CITY VARCHAR(50) Y The legal authenticator's location city
LEGAL_AUTH_NPI VARCHAR(50) Y The legal authenticator's national provider ID
LEGAL_AUTH_ORG_NAME VARCHAR(50) Y The name of the legal authenticator's organization
LEGAL_AUTH_STATE VARCHAR(50) Y The legal authenticator's location state
LEGAL_AUTH_STREET_ADDR VARCHAR(200) Y The legal authenticator's street address
LEGAL_AUTH_STREET_ADDR2 VARCHAR(200) Y The second line of the legal authenticator's street address
LEGAL_AUTH_TELECOM VARCHAR(50) Y The legal authenticator's phone number
LEGAL_AUTH_ZIPCODE VARCHAR(50) Y The legal authenticator's location zip code
LH_QRDA_PROV_DET_ID DOUBLE N Unique generated number that identifies a single row on the LH_QRDA_PROV_DET 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.
PROV_CITY VARCHAR(100) Y The provider's location city
PROV_ORG_NAME VARCHAR(255) Y The name of the provider's organization
PROV_STATE VARCHAR(50) Y The provider's location state
PROV_STREET_ADDR VARCHAR(200) Y The provider's street address
PROV_STREET_ADDR2 VARCHAR(200) Y The second line of the provider's street address
PROV_TELECOM VARCHAR(50) Y The provider's phone number
PROV_ZIPCODE VARCHAR(50) Y The provider's location zip code
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. This column is used only for date extraction and will not be populated on the client site.
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. This column is used only for date extraction and will not be populated on the client site.
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_RESULT



Column Section Top of Page


Table-level Detail

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





Column Detail - LH_QRDA_RESULT


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_RESULT_ID DOUBLE N Unique generated number that identifies a single row on the LH_QRDA_RESULT 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
OBSERVATION_CODE VARCHAR(50) Y Code derived from Appendix_F-Results tab of Downloadable Resources Table
OBSERVATION_CODE_SYSTEM VARCHAR(50) Y The code system from which observation_code was derived from
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_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 Result 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 Result section is related (i.e. lh_qrda_pqrs_id)
PARENT_ENTITY_NAME VARCHAR(50) Y The name of the table this Result section is related (i.e. LH_QRDA_PQRS)
PARENT_ENTITY_NAME2 VARCHAR(50) N The name of the table this Result section is related (i.e. LH_QRDA_PQRS)
REPORTING_YEAR DOUBLE Y Stores the reporting year.
RESULT_CODE VARCHAR(50) Y The code associated with a result
RESULT_DISPLAY VARCHAR(500) Y Text description of the result
RESULT_ID DOUBLE N Unique result id
RESULT_TEMPLATE VARCHAR(50) Y The name of the template the result corresponds to
RESULT_TYPE VARCHAR(50) Y The type of code associated with a given result (e.g. SNOMED CT / CPT-4 / LOINC)
RESULT_UNIT VARCHAR(50) Y Represents the unit (e.g. %) for a result_value
RESULT_VALUE VARCHAR(255) Y Represents the value that is within the range of values for the chosen observation_cd
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_SETUP_DATA



Column Section Relationship Section Top of Page


Table-level Detail

Description: Lighthouse Quality Reporting Document Architecture Setup Data
Definition: Stores data in relation to how an entity is setup when running the QRDA loads.
Table Type: ACTIVITY





Column Detail - LH_QRDA_SETUP_DATA


Column Name Type Null? Definition
BR_CPC_ID DOUBLE N The BR_CPC_ID for the CPC the QRDA load was run for when run for CPCs.
BR_GPRO_ID DOUBLE N The BR_GPRO_ID for the group the QRDA load was run for when run for Groups.
BR_GPRO_SUB_ID DOUBLE Y Unique generated number that identifies a single row on the BR_GPRO_SUB table.
CATEGORY_NUMBER DOUBLE Y Whether the QRDA load was run as a Category 3 or Category 1 load.
D_PRSNL_ID DOUBLE N The LH_D_PERSONNEL_ID for the provider the QRDA load was run for when run for individuals.
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_SETUP_DATA_ID DOUBLE N Unique generated number that identifies a single row on the LH_QRDA_SETUP_DATA table.;
REPORTING_YEAR DOUBLE Y The year the QRDA load was run for.
SETUP_TYPE VARCHAR(50) Y A short identifier for the type of data being stored.
SETUP_VALUE DOUBLE N An ID of a value represented in setup, such as a location ID.
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_SETUP_DATA


Child Column in LH_QRDA_SETUP_DATA(FK) Parent Table Name Parent Column Name
Parents: BR_CPC_ID BR_CPC BR_CPC_ID
BR_GPRO_ID BR_GPRO BR_GPRO_ID
D_PRSNL_ID LH_D_PERSONNEL D_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PERSONNEL HEALTH_SYSTEM_SOURCE_ID