Table Detail Report

LH_AMB_REPORT_PARAM



Column Section Top of Page


Table-level Detail

Description: LH_AMB_REPORT_PARAM
Definition: This table contains the list of parameters selected for MU EP Report through lh_amb_report_param prompt.
Table Type: REFERENCE





Column Detail - LH_AMB_REPORT_PARAM


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.
BEG_EXTRACT_DT_TM DATETIME N This column stores the Reporting Start Date & Time
BR_ELIGIBLE_PROVIDER_ID DOUBLE N List of EP's br_eligible_provider_ids
CMS_PROGRAM VARCHAR(50) Y Indicates the cms program to be run (NQF, PQRS, CPC¿)
CUST_END_DT_TM DATETIME N This column stores the Custom Reporting Period End Date & Time
CUST_START_DT_TM DATETIME N This column stores the Custom Reporting Period Start Date & Time
END_EXTRACT_DT_TM DATETIME N Reporting End Date & Time
EP_NAME_FILTER VARCHAR(10) Y Eligible Providers' Name Filter
LH_AMB_REPORT_PARAM_ID DOUBLE N Unique generated number that identifies a single row on the LH_AMB_REPORT_PARAM table.
LH_CQM_REPORT_TYPE_TFLG VARCHAR(5) Y Determines the reporting type as MIPs or MVPs.
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_NAME VARCHAR(2000) Y List of measures, the MU Report would be executed
OPT_INITIATIVE VARCHAR(25) Y This column stores the 'Reporting Time Frame'
ORGANIZATION_ID DOUBLE N List of Organization_ID, for which the MU Report would be executed
OUTPUT_DEVICE VARCHAR(50) N OUTPUT_DEVICE for future use. which can be used by the client to give the output csv file name.. By default this will be 'MINE' for now.
REPORT_BY VARCHAR(50) N Indicates the run mode of the report. Individual provider mode ("INDV"), group mode ("GPRO") or "CPC" mode.
REPORT_FORMAT VARCHAR(25) Y Stores format of the report to be generated. Possible Value: PS,CSV.
RUN_SUMMARY_REPORT DOUBLE N 0 = Run Detailed Report; 1 = Run summary report
STAGE1A_DT_TM DATETIME N This column stores the 90-Day Reporting Period Start Date & Time
STAGE1B_YEAR DOUBLE N This column stores 12 month Reporting Period's Year
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_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_CQM_DOMAIN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Lighthouse Clinical Quality Measures Domain
Definition: The domains that relate to clinical quality measures. Possible examples; Population/Public Health, Patient Safety
Table Type: REFERENCE





Column Detail - LH_CQM_DOMAIN


Column Name Type Null? Definition
DOMAIN_MEANING VARCHAR(12) N A description of the domain
LH_CQM_DOMAIN_ID DOUBLE N Unique generated number that identifies a single row on the LH_CQM_DOMAIN table.
LH_CQM_DOMAIN_NAME VARCHAR(100) N The display string for the domain.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
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_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - LH_CQM_DOMAIN




Parent Column in LH_CQM_DOMAIN (PK) Child Table Name Child Column Name
Children: LH_CQM_DOMAIN_ID LH_CQM_MEAS LH_CQM_DOMAIN_ID


LH_CQM_MEAS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Lighthouse Clinical Quality Measures Measure
Definition: Contains the defined measures for the program.
Table Type: REFERENCE





Column Detail - LH_CQM_MEAS


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.
CPC_IND DOUBLE Y *OBSOLETE* - ** POST-IMPLEMENTATION DISCOVERY DETERMINED THIS COLUMN NO LONGER NEEDED - DO NOT USE ** This field indicates that the particular measure belongs to CPC
HIGH_PRIORITY_IND DOUBLE Y This field indicates if the measure is a high-priority measure.
LH_CQM_DOMAIN_ID DOUBLE N The CQM domain that this measure pertains to.
LH_CQM_MEAS_ID DOUBLE N Unique generated number that identifies a single row on the LH_CQM_MEAS table.
MEASURE_SHORT_DESC VARCHAR(40) N The short description of the measure, giving the client additional details about the measure.
MEAS_DESC VARCHAR(1000) N The display string for the measure.
MEAS_IDENT VARCHAR(50) N Identifier provided by Content.
OUTCOME_IND DOUBLE Y This field indicates if the measure is an outcome-based measure.
POPULATION_CATEGORY_TXT VARCHAR(100) Y The population that is affected by this measure.
SVC_ENTITY_TYPE_FLAG DOUBLE N The type of service entity that this measure pertains to.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. 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_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_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE 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.



Relationship Detail - LH_CQM_MEAS


Child Column in LH_CQM_MEAS(FK) Parent Table Name Parent Column Name
Parents: LH_CQM_DOMAIN_ID LH_CQM_DOMAIN LH_CQM_DOMAIN_ID




Parent Column in LH_CQM_MEAS (PK) Child Table Name Child Column Name
Children: LH_CQM_MEAS_ID LH_CQM_MEAS_SVC_ENTITY_R LH_CQM_MEAS_ID


LH_CQM_MEAS_SVC_ENTITY_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Lighthouse Clinical Quality Measures Service Entity Relation
Definition: Relates the measure to the entity that the measure applies to, i.e. a hospital or eligible provider.
Table Type: REFERENCE





Column Detail - LH_CQM_MEAS_SVC_ENTITY_R


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.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
END_EFFECTIVE_DT_TM DATETIME N 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.
LH_CQM_MEAS_ID DOUBLE N The measure that is being related to this service entity.
LH_CQM_MEAS_SVC_ENTITY_R_ID DOUBLE N Unique generated number that identifies a single row on the LH_CQM_MEAS_SVC_ENTITY_R table.
LH_CQM_REPORT_TYPE_TFLG VARCHAR(5) Y Determines the reporting type as MIPs or MVPs.
ORIG_LH_CQM_MEAS_SVCENT_R_ID DOUBLE N Used for versioning. Contains the value of the PK for a particular set of rows in LH_CQM_MEAS_SVC_ENTITY_R.
PARENT_ENTITY_ID DOUBLE N Identifies the Eligible Provider or Hospital that is being related to this measure.
PARENT_ENTITY_NAME VARCHAR(32) N A pointer to the table that holds the service entity being related to this measure.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. 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_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_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE 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.



Relationship Detail - LH_CQM_MEAS_SVC_ENTITY_R


Child Column in LH_CQM_MEAS_SVC_ENTITY_R(FK) Parent Table Name Parent Column Name
Parents: LH_CQM_MEAS_ID LH_CQM_MEAS LH_CQM_MEAS_ID
ORIG_LH_CQM_MEAS_SVCENT_R_ID LH_CQM_MEAS_SVC_ENTITY_R LH_CQM_MEAS_SVC_ENTITY_R_ID




Parent Column in LH_CQM_MEAS_SVC_ENTITY_R (PK) Child Table Name Child Column Name
Children: LH_CQM_MEAS_SVC_ENTITY_R_ID LH_CQM_MEAS_SVC_ENTITY_R ORIG_LH_CQM_MEAS_SVCENT_R_ID


LH_D_QUERY



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_D_QUERY
Definition: Dimension table contain query and measure information for Meaningful Use QM and PQRI solutions.
Table Type: REFERENCE





Column Detail - LH_D_QUERY


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_EFFECTIVE_DT_TM DATETIME Y The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
D_QUERY_ID DOUBLE N Unique generated number that identifies a single row on LH_D_QUERY table.
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.
EXECUTION_MODE_FLAG DOUBLE N The Oracle optimizer execution mode. 0 = default, 1=RBO, 2=CBO
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. This time should be in UTC time.
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.
HINT_NAME VARCHAR(200) Y Contains the name of the hint that is to be used for the query.
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.
POPULATION_GROUP VARCHAR(50) Y Name of the measure.
PROCESS_DT_TM DATETIME Y The date/time the record was first loaded into the table.
QUERY_NAME VARCHAR(100) N Name of the individual queries associated with a measure.
REPORT_SECTION_GRAIN VARCHAR(100) Y This column will be used to store grain of the report_writer_section for all queries. This will allow us to dynamically change the grain of a query.
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 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) 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.



Relationship Detail - LH_D_QUERY




Parent Column in LH_D_QUERY (PK) Child Table Name Child Column Name
Children: D_QUERY_ID LH_AMB_EVENT_DATA D_QUERY_ID
LH_AMB_EVENT_DATA_2016 D_QUERY_ID
LH_AMB_EVENT_DATA_2017 D_QUERY_ID
LH_AMB_EVENT_DATA_2018 D_QUERY_ID
LH_AMB_EVENT_DATA_2019 D_QUERY_ID
LH_AMB_EVENT_DATA_2020 D_QUERY_ID
LH_AMB_EVENT_DATA_2021 D_QUERY_ID
LH_AMB_EVENT_DATA_2022 D_QUERY_ID
LH_AMB_EVENT_DATA_2023 D_QUERY_ID
LH_AMB_EVENT_DATA_2024 D_QUERY_ID
LH_AMB_QUAL_ENCNTR D_QUERY_ID
LH_AMB_QUAL_ENCNTR_2016 D_QUERY_ID
LH_AMB_QUAL_ENCNTR_2017 D_QUERY_ID
LH_AMB_QUAL_ENCNTR_2018 D_QUERY_ID
LH_AMB_QUAL_ENCNTR_2019 D_QUERY_ID
LH_AMB_QUAL_ENCNTR_2020 D_QUERY_ID
LH_AMB_QUAL_ENCNTR_2021 D_QUERY_ID
LH_AMB_QUAL_ENCNTR_2022 D_QUERY_ID
LH_AMB_QUAL_ENCNTR_2023 D_QUERY_ID
LH_AMB_QUAL_ENCNTR_2024 D_QUERY_ID