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. |