Table Detail Report

LH_ABS_IPFQR_INFO



Column Section Top of Page


Table-level Detail

Description: LH_ABS_IPFQR_INFO
Definition: Holds information for reporting on IPFQR discharged patients
Table Type: ACTIVITY





Column Detail - LH_ABS_IPFQR_INFO


Column Name Type Null? Definition
DISCH_DT_TM DATETIME Y The local date/time on which the patient was discharged
DISCH_UTC_DT_TM DATETIME Y The utc date/time on which the patient was discharged
D_BR_CCN_ID DOUBLE N CMS Certification Number. Foreign key to the LH_D_BR_CCN table.
ENCNTR_ID DOUBLE N Unique identifier for the Encounter table.
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_ABS_IPFQR_INFO_ID DOUBLE N Unique generated number that identifies a single row on the LH_ABS_IPFQR_INFO 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.
MEDICARE_IND DOUBLE Y Indicator to describe the case as medicare or non-medicare
PAT_DISCH_AGE DOUBLE Y Age at discharge of patient, to be used for stratum
PRIN_DIAG_CAT_FLAG DOUBLE Y Category of the principle diagnosis
SAMPLE_IND DOUBLE Y A value of 1 indicates this case is part of the sample.
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.


LH_ABS_LAYOUT



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_ABS_LAYOUT
Definition: Defined layout of the Sections displayed in the Lighthouse Abstractor (eQuality Check)
Table Type: REFERENCE





Column Detail - LH_ABS_LAYOUT


Column Name Type Null? Definition
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.
BR_DATAMART_CATEGORY_ID DOUBLE N Identifies the Category (i.e. Stroke, VTE, or ED Throughput). Foreign Key to BR_DATAMART_CATEGORY
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.
GWTG_TJC_IND DOUBLE Y Indicates a question that should be marked because it is only used for GWTG and/or TJC
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_ABS_LAYOUT_ID DOUBLE N Unique generated number that identifies a single row on the LH_ABS_LAYOUT table.
LH_ABS_QUESTION_ID DOUBLE N Identifies the Question that are grouped under the specified Section. Foreign Key to LH_ABS_QUESTION
LH_ABS_SECTION_ID DOUBLE N Identifies Section. Foreign Key to LH_ABS_SECTION
QUESTION_POS_SEQ DOUBLE N Used to determine the position of a question if grouped within a question_seq.
QUESTION_SEQ DOUBLE Y Assigns the order the Questions will appear under the specified section
SCRATCHPAD_IND DOUBLE N Indicator to determine if scratchpad will be visible for this question.
SECTION_SEQ DOUBLE Y Assigns the order the Sections will appear in the Abstractor
SHARED_RESPONSE_IND DOUBLE Y The indicator to represent if a response is being shared across multiple conditions for the same patient. 0 - Yes; 1 - No.
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.
USER_ID DOUBLE Y The user that is assigned to a customized layout



Relationship Detail - LH_ABS_LAYOUT


Child Column in LH_ABS_LAYOUT(FK) Parent Table Name Parent Column Name
Parents: HEALTH_SYSTEM_SOURCE_ID LH_ABS_QUESTION HEALTH_SYSTEM_SOURCE_ID
LH_ABS_QUESTION_ID LH_ABS_QUESTION LH_ABS_QUESTION_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_SECTION HEALTH_SYSTEM_SOURCE_ID
LH_ABS_SECTION_ID LH_ABS_SECTION LH_ABS_SECTION_ID




Parent Column in LH_ABS_LAYOUT (PK) Child Table Name Child Column Name
Children: HEALTH_SYSTEM_SOURCE_ID LH_ABS_MEASURE_RELTN HEALTH_SYSTEM_SOURCE_ID
LH_ABS_LAYOUT_ID LH_ABS_MEASURE_RELTN LH_ABS_LAYOUT_ID


LH_ABS_LOG



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_ABS_REF
Definition: Hold debugging and informational information about eQualityCheck (abstrctor) processes
Table Type: ACTIVITY





Column Detail - LH_ABS_LOG


Column Name Type Null? Definition
CALLING_PROGRAM_TXT VARCHAR(100) Y Where the message was logged from
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 the record was first loaded into the table.
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 the record was last loaded into the table.
LH_ABS_LOG_ID DOUBLE N Unique generated number that identifies a single row on the table. The Primary Key.
MESSAGE_SEQ DOUBLE N If a message needs to be split over multiple rows (due to limited message_txt size) used to order the rows.
MESSAGE_TXT VARCHAR(3000) Y Log messages text to store
MESSAGE_TYPE_FLAG DOUBLE N Type of message we are storing - 0 = Unknown, 1 = Info, 2 = Warning, 3 = Error
PARENT_LOG_ID DOUBLE N Unique identifier for the Parent LH_ABS_LOG_ID of a message or sequenced group of messages (sequence = 1)
PRSNL_ID DOUBLE N User id of the user running the application
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_SOURCE VARCHAR(100) Y Script that created the message row
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.
UPDT_TASK_TXT VARCHAR(50) Y The registered (assigned) task number for the process that inserted or updated the row (TEXT FORMAT)



Relationship Detail - LH_ABS_LOG


Child Column in LH_ABS_LOG(FK) Parent Table Name Parent Column Name
Parents: PARENT_LOG_ID LH_ABS_LOG LH_ABS_LOG_ID
PRSNL_ID PRSNL PERSON_ID




Parent Column in LH_ABS_LOG (PK) Child Table Name Child Column Name
Children: LH_ABS_LOG_ID LH_ABS_LOG PARENT_LOG_ID


LH_ABS_MEASURE



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_ABS_MEASURE
Definition: Contains measure info for each condition
Table Type: ACTIVITY





Column Detail - LH_ABS_MEASURE


Column Name Type Null? Definition
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.
BR_DATAMART_CATEGORY_ID DOUBLE N Identifies the category which the quality measures are associated with. Foreign key to the BR_DATAMART_CATEGORY table.
CMS_REQ_IND DOUBLE Y Identifies if the measure is a required for CMS submission
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 the record was first loaded into the table.
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 the record was last loaded into the table.
LH_ABS_MEASURE_ID DOUBLE N Unique generated number that identifies a single row on the LH_ABS_MEASURE table.
MEASURE_DESC VARCHAR(200) Y Identifies the measures description
MEASURE_NAME VARCHAR(20) Y Identifies the measure name
MEASURE_SEQ DOUBLE N Identifies the order of the measures
PARTITION_DT_TM DATETIME Y The date/time that the record was partitioned
PROCESS_DT_TM DATETIME Y The date/time the record was processed
TJC_REQ_IND DOUBLE Y Identifies if the measure is a required for The Joint Commission submission.
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.
UPDT_DT_TM DATETIME Y The date and time the row was last inserted or updated.
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.



Relationship Detail - LH_ABS_MEASURE


Child Column in LH_ABS_MEASURE(FK) Parent Table Name Parent Column Name
Parents: BR_DATAMART_CATEGORY_ID BR_DATAMART_CATEGORY BR_DATAMART_CATEGORY_ID




Parent Column in LH_ABS_MEASURE (PK) Child Table Name Child Column Name
Children: HEALTH_SYSTEM_SOURCE_ID LH_ABS_MEASURE_RELTN HEALTH_SYSTEM_SOURCE_ID
LH_ABS_MEASURE_ID LH_ABS_MEASURE_RELTN LH_ABS_MEASURE_ID


LH_ABS_MEASURE_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_ABS_MEASURE_RELTN
Definition: Contains measure info for each condition
Table Type: ACTIVITY





Column Detail - LH_ABS_MEASURE_RELTN


Column Name Type Null? Definition
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.
BR_DATAMART_CATEGORY_ID DOUBLE N Identifies the category which the quality measures are associated with. Foreign key to the BR_DATAMART_CATEGORY 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 record was extracted from the source system.
FIRST_PROCESS_DT_TM DATETIME Y The date/time the record was first loaded into the table.
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 the record was last loaded into the table.
LH_ABS_LAYOUT_ID DOUBLE N Identifies the layout row which the measure is associated with. Foreign key to the LH_ABS_LAYOUT table.
LH_ABS_MEASURE_ID DOUBLE N Identifies the measure which the condition is associated with. Foreign key to the LH_ABS_MEASURE table.
LH_ABS_MEASURE_RELTN_ID DOUBLE N Unique generated number that identifies a single row on the LH_ABS_MEASURE_RELTN table.
PARTITION_DT_TM DATETIME Y The date/time that the record was partitioned
PROCESS_DT_TM DATETIME Y The date/time the record was processed
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.
UPDT_DT_TM DATETIME Y The date and time the row was last inserted or updated.
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.



Relationship Detail - LH_ABS_MEASURE_RELTN


Child Column in LH_ABS_MEASURE_RELTN(FK) Parent Table Name Parent Column Name
Parents: BR_DATAMART_CATEGORY_ID BR_DATAMART_CATEGORY BR_DATAMART_CATEGORY_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_LAYOUT HEALTH_SYSTEM_SOURCE_ID
LH_ABS_LAYOUT_ID LH_ABS_LAYOUT LH_ABS_LAYOUT_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_MEASURE HEALTH_SYSTEM_SOURCE_ID
LH_ABS_MEASURE_ID LH_ABS_MEASURE LH_ABS_MEASURE_ID