Table Detail Report

LH_QRDA_SOCIAL_HISTORY



Column Section Top of Page


Table-level Detail

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





Column Detail - LH_QRDA_SOCIAL_HISTORY


Column Name Type Null? Definition
EFFECTIVE_DT_TM DATETIME Y Represents the time the social history was created/noted
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_QRDA_SOCIAL_HISTORY_ID DOUBLE N Unique generated number that identifies a single row on the LH_QRDA_SOCIAL_HISTORY table.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain.
PARENT_ENTITY_ID DOUBLE N The value of the primary identifier of the table to which the Problem section is related (i.e. lh_qrda_pqrs_id)
PARENT_ENTITY_ID2 DOUBLE N The value of the primary identifier of millennium source table
PARENT_ENTITY_NAME VARCHAR(50) Y The name of the table this Problem section is related (i.e. LH_QRDA_PQRS)
PARENT_ENTITY_NAME2 VARCHAR(50) N The name of millennium source table
SHX_CODE VARCHAR(50) Y The code associated with a social history result
SHX_CODE_SYSTEM VARCHAR(50) Y Represents the codeSystem string of the observation/code/@codesystem
SHX_CODE_SYSTEM_NAME VARCHAR(100) Y String Representation of Social History Code OID
SHX_DISPLAY VARCHAR(500) Y Text description of a social history result
SHX_ID DOUBLE N Unique social history id
SHX_STATUS_CODE VARCHAR(50) Y The code associated with a social history status value
SHX_STATUS_DISPLAY VARCHAR(500) Y Text description of a social history status value
SHX_STATUS_TYPE VARCHAR(50) Y The type of code associated with a given social history status value (e.g. SNOMED CT / CPT-4)
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.


LH_QRDA_VITAL_SIGNS



Column Section Top of Page


Table-level Detail

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





Column Detail - LH_QRDA_VITAL_SIGNS


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.
EFFECTIVE_DT_TM DATETIME Y The date and time on which the status of the problem was changed
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.
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_QRDA_VITAL_SIGNS_ID DOUBLE N Unique generated number that identifies a single row on the LH_QRDA_VITAL_SIGNS 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.
NEGATION_IND DOUBLE Y Indicates whether a negation exists or not
NEG_EFFECTIVE_DT_TM DATETIME Y The date/time when the negation was recorded
NEG_OBSERVATION_CODE VARCHAR(50) Y CMS code that describes the negation
NEG_OBSERVATION_CODE_SYSTEM VARCHAR(50) Y The code system from which neg_observation_code was derived from
NEG_OBSERVATION_DISPLAY VARCHAR(500) Y Text description of the negation
NEG_OBS_CODE_SYSTEM_NAME VARCHAR(50) Y Represents the codeSystem string of the code node (negation)
NEG_OBS_CODE_SYSTEM_SDTC VARCHAR(50) Y The OID of the code system's value set (negation)
OBSERVATION_CODE VARCHAR(50) Y Code derived from Appendix_F-Results tab of Downloadable Resources Table
OBSERVATION_CODE_DISPLAY VARCHAR(500) Y Text description of the observation
OBSERVATION_CODE_SYSTEM VARCHAR(50) Y The code system from which observation_code was derived from
OBS_CODE_SYSTEM_NAME VARCHAR(50) Y Represents the codeSystem string of the code node
OBS_CODE_SYSTEM_SDTC VARCHAR(50) Y The OID of the code system's value set
PARENT_ENTITY_ID DOUBLE N The value of the primary identifier of the table to which the VITAL SIGNS section is related (i.e. lh_qrda_pqrs_id)
PARENT_ENTITY_ID2 DOUBLE N The name of millennium source table
PARENT_ENTITY_NAME VARCHAR(50) Y The name of the table this VITAL SIGNS section is related (i.e. LH_QRDA_PQRS)
PARENT_ENTITY_NAME2 VARCHAR(50) N The value of the primary identifier of millennium source table
REPORTING_YEAR DOUBLE Y Stores the reporting year.
RESULT_CODE VARCHAR(50) Y The code associated with a result
RESULT_DISPLAY VARCHAR(500) Y Text description of the result
RESULT_ID DOUBLE N Unique result id
RESULT_TYPE VARCHAR(50) Y The type of code associated with a given result (e.g. SNOMED CT / CPT-4 / LOINC)
RESULT_UNIT VARCHAR(50) Y Represents the unit (e.g. %) for a result_value
RESULT_VALUE VARCHAR(255) Y Represents the value that is within the range of values for the chosen observation_cd
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.
VITAL_SIGNS_TEMPLATE VARCHAR(50) Y Template name of event


LH_RULES



Column Section Top of Page


Table-level Detail

Description: LH_RULES
Definition: This table is used to store the rules that calculate the measures of Lighthouse topics.
Table Type: REFERENCE





Column Detail - LH_RULES


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.
BR_DATAMART_CATEGORY_ID DOUBLE N ID relating to the Lighthouse Topic (FALLS, HAPU, SSI, etc.) Foreign Key to BR_DATAMART_CATEGORY
BR_DATAMART_FILTER_ID DOUBLE N ID relating to the user-configurable filters Foreign Key to BR_DATAMART_FILTER
CATEGORY_MEAN VARCHAR(30) Y Unique string to identify the category from BR_DATAMART_CATEGORY
CHILD_LH_RULES_ID DOUBLE N The rules_id that this rule is linked to
CUSTOM_RULE_IND DOUBLE Y Identifies rules that are not loaded from the standard Lighthouse Rules definitions
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.
FILTER_MEAN VARCHAR(255) Y String that identifies the filter from BR_DATAMART_FILTER
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifies the unique source within the delivery network responsible for supplying the data.
LH_RULES_ID DOUBLE N Unique identifier for the rule.
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_DESC VARCHAR(50) Y Description of the Measure (AT_RISK, ASSESSED_DAILY, etc.) for the Lighthouse Topic
OPERATION VARCHAR(25) Y If this rule is linked to another rule, this is the operation that is performed to link them (AND, OR, etc.)
PROCESS_DT_TM DATETIME Y The date/time the record was loaded into the table.
REQUIRED_IND DOUBLE Y Shows if this rule is required or optional
RULES_SEQ DOUBLE Y The sequence a group of rules are put together
RULE_TXT VARCHAR(255) Y The rule being applied to calculate the measure
SUB_RULE_IND DOUBLE Y Indicates if the rule field points to a sub-rule or if the rule field contains the text of the rule.
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_TABLE



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_TABLE
Definition: This table is used to store the tables and aliases that are used in rules for measures of Lighthouse topics.
Table Type: REFERENCE





Column Detail - LH_TABLE


Column Name Type Null? Definition
ALIAS VARCHAR(50) Y An alias for the table
EXTRACT_DT_TM DATETIME Y The date/time that the record was extracted from the source system.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifies the unique source within the delivery network responsible for supplying the data.
LH_TABLE_ID DOUBLE N Unique identifier for the table
PROCESS_DT_TM DATETIME Y The date/time the record was loaded into the table.
TABLE_NAME VARCHAR(50) Y Name of the table
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.



Relationship Detail - LH_TABLE




Parent Column in LH_TABLE (PK) Child Table Name Child Column Name
Children: HEALTH_SYSTEM_SOURCE_ID LH_TABLE_RELTN HEALTH_SYSTEM_SOURCE_ID
LH_TABLE_RELTN HEALTH_SYSTEM_SOURCE_ID
LH_TABLE_ID LH_TABLE_RELTN LH_TABLE_ID
LH_TABLE_RELTN RELATED_LH_TABLE_ID


LH_TABLE_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_TABLE_RELTN
Definition: This table is used to store the table relationships used in rules for measures of Lighthouse topics.
Table Type: REFERENCE





Column Detail - LH_TABLE_RELTN


Column Name Type Null? Definition
EXTRACT_DT_TM DATETIME Y The date/time that the record was extracted from the source system.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifies the unique source within the delivery network responsible for supplying the data.
JOIN_TXT VARCHAR(255) Y Details the join between lh_table_id and related_lh_table_id. This text will be placed in the WHERE clause of the query.
LH_TABLE_ID DOUBLE N A table involved in a query for a Measure's rule Foreign Key to LH_TABLE
LH_TABLE_RELTN_ID DOUBLE N Unique identifier for the table relationship
PROCESS_DT_TM DATETIME Y The date/time the record was loaded into the table.
RELATED_LH_TABLE_ID DOUBLE N A table being joined to lh_table_id Foreign Key to LH_TABLE
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.



Relationship Detail - LH_TABLE_RELTN


Child Column in LH_TABLE_RELTN(FK) Parent Table Name Parent Column Name
Parents: HEALTH_SYSTEM_SOURCE_ID LH_TABLE HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_TABLE HEALTH_SYSTEM_SOURCE_ID
LH_TABLE_ID LH_TABLE LH_TABLE_ID
RELATED_LH_TABLE_ID LH_TABLE LH_TABLE_ID