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 |