Table Detail Report

LH_D_ROOM



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_D_ROOM
Definition: Dimension table to hold Room information for Lighthouse Reporting
Table Type: REFERENCE





Column Detail - LH_D_ROOM


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 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_ROOM_ID DOUBLE N Unique generated number that identifies a single row on the LH_D_ROOM 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.
EXTRACT_DT_TM DATETIME Y The date/time that the program running the extracts was started. This filed 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_SOURCE_ID DOUBLE N Identifies the unique source within the delivery network responsible for supplying the data
LOC_ROOM_CD DOUBLE N The location of the room. CODE SET 220
PROCESS_DT_TM DATETIME Y The date/time the record wad first loaded into the table.
ROOM_DESCRIPTION VARCHAR(50) Y The description of the room
ROOM_DISPLAY VARCHAR(50) Y The display value for the room
ROOM_MEANING VARCHAR(50) Y The Cerner-identified meaning for the room
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.



Relationship Detail - LH_D_ROOM




Parent Column in LH_D_ROOM (PK) Child Table Name Child Column Name
Children: D_ROOM_ID LH_F_IC_MDRO_DTL_METRICS D_COLL_PREV_ROOM_ID
LH_F_IC_MDRO_DTL_METRICS D_COLL_ROOM_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_IC_MDRO_DTL_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_F_IC_MDRO_DTL_METRICS HEALTH_SYSTEM_SOURCE_ID


LH_D_SOURCE



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_D_SOURCE
Definition: Dimension table to hold SOURCE Results for Infection Control Reports
Table Type: REFERENCE





Column Detail - LH_D_SOURCE


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 Y The data and Time for which this table row becomes effective. Normally, this will be the data and time the row is added, but could be a past or future date and time
D_SOURCE_ID DOUBLE N Unique generated number that identifies a single row on the LH_D_SOURCE 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 value with the date that the row became inactive
EXTRACT_DT_TM DATETIME Y The date/time that the program running the extracts was started. This filed 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_SOURCE_ID DOUBLE N Identifies the unique source within the delivery network responsible for supplying the data
PROCESS_DT_TM DATETIME Y The date/time the record wad first loaded into the table.
SOURCE_CD DOUBLE N The location of the source. CODE SET 2052
SOURCE_DESCRIPTION VARCHAR(50) Y The description of the source
SOURCE_DISPLAY VARCHAR(50) Y The display value for the source
SOURCE_MEANING VARCHAR(50) Y The Cerner-identified meaning for the source
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.



Relationship Detail - LH_D_SOURCE




Parent Column in LH_D_SOURCE (PK) Child Table Name Child Column Name
Children: D_SOURCE_ID LH_F_IC_ANTIBGRM_METRICS D_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_IC_ANTIBGRM_METRICS HEALTH_SYSTEM_SOURCE_ID
D_SOURCE_ID LH_F_IC_MDRO_DTL_METRICS D_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_F_IC_MDRO_DTL_METRICS HEALTH_SYSTEM_SOURCE_ID


LH_EC_QRDA_ATTRIB



Column Section Top of Page


Table-level Detail

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





Column Detail - LH_EC_QRDA_ATTRIB


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.
ATTRIB_CODE VARCHAR(50) Y Identifies the value set code for qualifying documentation.
ATTRIB_CODE_DISPLAY VARCHAR(500) Y Identifies the display description of value set code for qualifying documentation.
ATTRIB_CODE_SYSTEM VARCHAR(50) Y Identifies the system of value set code for qualifying documentation.
ATTRIB_CODE_SYSTEM_NAME VARCHAR(50) Y Identifies the system name of value set code for qualifying documentation.
ATTRIB_CODE_SYSTEM_SDTC VARCHAR(50) Y Identifies the sdtc code of value set code for qualifying documentation.
ATTRIB_TEMPLATE VARCHAR(50) Y QRDA tamplate name to identify type of documentation
EFFECTIVE_DT_TM DATETIME Y Identifies the start date and time of dcumentation.
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 program running the extracts was started.
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_EC_QRDA_ATTRIB_ID DOUBLE N Unique generated number that identifies a single row on the LH_EC_QRDA_ATTRIB table.
LH_QRDA_TABLE_ID DOUBLE N The ID of the event type from lh_qrda_table_name.
LH_QRDA_TABLE_NAME VARCHAR(30) Y The table name of the lh_qrda_table_id source.
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 ID of the event type from parent_entity_name.
PARENT_ENTITY_ID2 DOUBLE N Identifies the key field of repective millenium table for which this row is qualifying
PARENT_ENTITY_NAME VARCHAR(30) Y The table name of the parent_entity_id source.
PARENT_ENTITY_NAME2 VARCHAR(30) Y Identifies the repective millenium table for which this row is qualifying
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 Identifies when a record was updated
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_EH_HCO_ISSUE



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_EH_HCO_ISSUE
Definition: Stores possible errors within the Eligible Hospital Quality Reporting Data Architecture
Table Type: ACTIVITY





Column Detail - LH_EH_HCO_ISSUE


Column Name Type Null? Definition
CONDITION_MASK DOUBLE Y A bitmask that identifies what conditions are associated to the record. The conditions correspond to the following numbers: AMI - 1, CAC - 2, ED - 4, EHDI - 8, PC - 16, STK - 32, VTE - 64
D_BUILDING_ID DOUBLE N The building from which the patient was discharged
D_FACILITY_ID DOUBLE N The facility from which the patient was discharged
D_NURSE_UNIT_ID DOUBLE N The nurse unit from which the patient was discharged
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 Identifier of the health system to which the record belongs.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifier of the health system source to which the record belongs.
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_EH_HCO_ISSUE_ID DOUBLE N Unique generated number that identifies a single row on the LH_EH_HCO_ISSUE 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.
QRDA_VERSION DOUBLE N Identifies the version of the QRDA program that was used to insert/update the record. VERSION = VERSION YEAR + (QRDA VERSION / 100)
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 Identifier of the health system to which the record belongs.
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 name of the program that updated the record last.
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_EH_HCO_ISSUE


Child Column in LH_EH_HCO_ISSUE(FK) Parent Table Name Parent Column Name
Parents: D_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BUILDING HEALTH_SYSTEM_SOURCE_ID
D_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FACILITY HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_D_NURSE_UNIT D_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_NURSE_UNIT HEALTH_SYSTEM_SOURCE_ID


LH_EH_MAP_ISSUE



Column Section Top of Page


Table-level Detail

Description: LH_EH_MAP_ISSUE
Definition: Stores possible errors within the Eligible Hospital Quality Reporting Data Architecture
Table Type: ACTIVITY





Column Detail - LH_EH_MAP_ISSUE


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.
CODE_DESCRIPTION VARCHAR(40) Y The description of the mapped code
CONDITION_MASK DOUBLE Y A bitmask that identifies what conditions are associated to the record. The conditions correspond to the following numbers: AMI - 1, CAC - 2, ED - 4, EHDI - 8, PC - 16, STK - 32, VTE - 64
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 Identifier of the health system to which the record belongs.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifier of the health system source to which the record belongs.
ISSUE_FLAG DOUBLE Y Identifies the type of issue. 1 Contradicting encounter mappings - 2=Contradicting discharge disposition mapping 3=Contradicting negation mapping 4= Contradicting device mapping.
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_EH_MAP_ISSUE_ID DOUBLE N Unique generated number that identifies a single row on the LH_EH_MAP_ISSUE 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.
QRDA_VERSION DOUBLE N Identifies the version of the QRDA program that was used to insert/update the record. VERSION = VERSION YEAR + (QRDA VERSION / 100)
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
TEMPLATE_NAME VARCHAR(50) Y QRDA template to be used for e-submission, not currently in Millennium.
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 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_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.
VALUE_SETS VARCHAR(400) Y A list of value sets affected by this mapping issue.