Table Detail Report

LH_ABS_GLOBAL_PSYCH_POP



Column Section Top of Page


Table-level Detail

Description: LH_ABS_GLOBAL_PSYCH_POP
Definition: This table will have details about the cases that qualify for global psych population
Table Type: ACTIVITY





Column Detail - LH_ABS_GLOBAL_PSYCH_POP


Column Name Type Null? Definition
DISCHARGE_DT_TM DATETIME Y The date/time the patient was discharged.
ENCNTR_ID DOUBLE N Identifies the encounter that qualifies for global psych population. Foreign key to 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_GLOBAL_PSYCH_POP_ID DOUBLE N Unique generated number that identifies a single row on the LH_ABS_GLOBAL_PSYCH_POP table.
SAMPLE_IND DOUBLE N Indicates if the case is sampled.
SAMPLE_MISMATCH_IND DOUBLE N Indicates if the case is sampled for some but not all the global psych condition.
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 that inserted or updated the row.
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_HBIPS_DISC_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_ABS_HBIPS_DISC_METRICS
Definition: Hold discharged patient information for the eQualityCheck Solution for HBIPS Abstraction
Table Type: ACTIVITY





Column Detail - LH_ABS_HBIPS_DISC_METRICS


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.
ADMIT_DT_TM DATETIME Y The date/time on which the patient was admitted
ADMIT_UTC_DT_TM DATETIME Y The date/time on which the patient was admitted normalized to GMT.
ARRIVAL_DT_TM DATETIME Y The date/time on which the patient arrived at the facility.
ARRIVAL_UTC_DT_TM DATETIME Y The date/time on which the patient arrived at the facility normalized to GMT.
CCP_DISC_MED_FLAG DOUBLE Y Is there a continuing care plan which includes the discharge medications, dosage and indication for use or states no medications were prescribed at discharge AND was the plan transmitted to the next level of care provider no later than the fifth post-discharge day?
CCP_NEXT_LEVEL_FLAG DOUBLE Y Is there a continuing care plan which includes next level of care recommendations AND was the plan transmitted to the next level of care provider no later than the fifth post-discharge date.
CCP_PRIN_DX_FLAG DOUBLE Y Is there a continuing care plan which includes the reason for hospitalization AND was the plan transmitted to the next level of care provider no later than the fifth post-discharge day?
CCP_REASON_HOSP_FLAG DOUBLE Y Is there a continuing care plan which includes the discharge medications, dosage and indication for use or states no medications were prescribed at discharge AND was the plan transmitted to the next level of care provider no later than the fifth post-discharge day?
COMM_MRN_TXT VARCHAR(50) Y Identifies the community medical record number of the patient.
COMPLETED_DT_TM DATETIME Y The Date and Time the abstracted case was completed
DISCHARGE_DT_TM DATETIME Y The date/time on which the patient was discharged.
DISCHARGE_UTC_DT_TM DATETIME Y The date/time on which the patient was discharged normalized to GMT.
DISC_DISP_FLAG DOUBLE Y Identifies the discharge disposition of the patient.
DISC_STAT_FLAG DOUBLE Y Identifies the patient's status at discharge.
D_ADMIT_BUILDING_ID DOUBLE N The building to which the patient was admitted.
D_ADMIT_FACILITY_ID DOUBLE N The facility to which the patient was admitted.
D_ADMIT_NURSE_UNIT_ID DOUBLE N The nurse unit to which the patient was admitted.
D_ADMIT_SRC_ID DOUBLE N Identifies the place from which the patient came before being admitted.
D_ADMIT_TYPE_ID DOUBLE N Indicates the circumstances under which the patient was admitted.
D_ATTEND_PRSNL_ID DOUBLE N Identifies the final attending physician associated to the encounter.
D_BR_CCN_ID DOUBLE N The CMS Certification Number for the patient for the quality measure
D_BR_HCO_ID DOUBLE N The Healthcare Organization Number for the patient for the quality measure
D_DISCHARGE_BUILDING_ID DOUBLE N The building from which the patient was discharged
D_DISCHARGE_FACILITY_ID DOUBLE N The facility from which the patient was discharged
D_DISCHARGE_NURSE_UNIT_ID DOUBLE N The nurse unit from which the patient was discharged
D_ENCNTR_TYPE_ID DOUBLE N Categorizes the encounter into a logical group or type.
D_MED_SERVICE_ID DOUBLE N The type or category of medical service that the patient is receiving in relation to their encounter. The category may be treatment type surgery general resources or others.
D_METRIC_1_ID DOUBLE N Identifies the patient population associated with the HBIPS-1 metric.
D_METRIC_4_ID DOUBLE N Identifies the patient population associated with the HBIPS-4 metric.
D_METRIC_5_ID DOUBLE N Identifies the patient population associated with the HBIPS-5 metric.
D_METRIC_6_ID DOUBLE N Identifies the patient population associated with the HBIPS-6 metric.
D_METRIC_7_ID DOUBLE N Identifies the patient population associated with the HBIPS-7 metric.
D_PERSON_ID DOUBLE N The person that qualified for the quality metric.
ENCNTR_ID DOUBLE N Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table.
EXCLUDE_1_IND DOUBLE Y Identifies patients excluded from HBIPS-1.
EXCLUDE_4_IND DOUBLE Y Identifies patients excluded from HBIPS-4.
EXCLUDE_5_IND DOUBLE Y Identifies patients excluded from HBIPS-5.
EXCLUDE_6_IND DOUBLE Y Identifies patients excluded from HBIPS-6.
EXCLUDE_7_IND DOUBLE Y Identifies patients excluded from HBIPS-7.
EXTRACT_DT_TM DATETIME Y The date/time that the record was extracted from the source system.
FINANCIAL_NBR_TXT VARCHAR(50) Y The financial number alias associated to the encounter.
FIRST_PROCESS_DT_TM DATETIME Y The date/time that the first ETL process started that created this record.
HBIPS1_REASON_TXT VARCHAR(250) Y Stores the category reason for HBIPS-1 obtained during the completion of abstraction.
HBIPS5_REASON_TXT VARCHAR(250) Y Stores the category reason for HBIPS-5 obtained during the completion of abstraction.
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.
JUSTIFICATION_PSYCH_FLAG DOUBLE Y Identifies if the patient was justified to be discharged on psych meds
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_ABS_HBIPS_DISC_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_ABS_HBIPS_DISC_METRICS 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.
NEXT_LVL_FLAG DOUBLE Y Was the patient was referred to the next level of care provider upon discharge from a hospital-based inpatient psychiatric setting?
NUMERATOR_1_IND DOUBLE Y Identifies patients rejected from HBIPS-1 due to missing data.
NUMERATOR_4_IND DOUBLE Y Identifies patients rejected from HBIPS-4 due to missing data.
NUMERATOR_5_IND DOUBLE Y Identifies patients rejected from HBIPS-5 due to missing data.
NUMERATOR_6_IND DOUBLE Y Identifies patients rejected from HBIPS-6 due to missing data.
NUMERATOR_7_IND DOUBLE Y Identifies patients rejected from HBIPS-7 due to missing data.
NUM_PSYCH_MED VARCHAR(10) Y What is the documented number of antipsychotic medications prescribed for the patient at discharge?
ORG_MRN_TXT VARCHAR(50) Y Identifies the medical record number of the patient.
OTH_DIAGNOSIS_LIST VARCHAR(400) Y The list of other non-principle diagnoses.
OTH_PROCEDURE_DATES_LIST VARCHAR(400) Y The list of dates for when the other non-principle procedures were performed.
OTH_PROCEDURE_LIST VARCHAR(400) Y The list of other non-principle procedures.
PARTITION_DT_TM DATETIME Y The date/time the encounter was discharged from the facility
PATIENT_STR VARCHAR(10) Y Was the patient screened for a minimum of two patient strengths within the first three days of admission?
PAYMENT_SOURCE_FLAG DOUBLE Y Identifies the patient's source of payment.
PHYSICIAN_1_TXT VARCHAR(50) Y First physician identifier.
PHYSICIAN_2_TXT VARCHAR(50) Y Second physician identifier.
PRIN_DIAGNOSIS VARCHAR(10) Y The principle diagnosis.
PRIN_PROCEDURE VARCHAR(10) Y The principle procedure.
PRIN_PROCEDURE_DATE_TXT VARCHAR(10) Y The date/time on which the principle procedure was performed.
PRIN_PROCEDURE_DT_TM DATETIME Y The date/time on which the principle procedure was performed.
PRIN_PROCEDURE_UTC_DT_TM DATETIME Y The date/time on which the principle procedure was performed normalized to GMT.
PRS_TXT VARCHAR(10) Y Identifies the Patient Reliability Score (PRS).
PSYCH_SETTING VARCHAR(10) Y Did the patient receive care in an inpatient psychiatric setting?
PSYCH_TRAMA_HIST VARCHAR(10) Y Was the patient screened for a psychological trauma history within the first three days of admission?
REJECT_1_IND DOUBLE Y Identifies patients rejected from HBIPS-1 due to missing data.
REJECT_4_IND DOUBLE Y Identifies patients rejected from HBIPS-4 due to missing data.
REJECT_5_IND DOUBLE Y Identifies patients rejected from HBIPS-5 due to missing data.
REJECT_6_IND DOUBLE Y Identifies patients rejected from HBIPS-6 due to missing data.
REJECT_7_IND DOUBLE Y Identifies patients rejected from HBIPS-7 due to missing data.
SAMPLE_IND DOUBLE Y Identifies if the patient is part of a sample.
STRATUM_TITLE VARCHAR(50) Y The stratum title of the condition.
SUBSTANCE_USE VARCHAR(10) Y Documentation that the patient was screened for alcohol and substance use which occurred over the past twelve (12) months within the first three days of admission?
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_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_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.
VIOLENCE_OTHERS VARCHAR(10) Y Was a patient screening for violence risk to others over the past six months performed within the first three days of admission?
VIOLENCE_SELF VARCHAR(10) Y Was a patient screening for violence risk to self over the past six months performed within the first three days of admission?



Relationship Detail - LH_ABS_HBIPS_DISC_METRICS


Child Column in LH_ABS_HBIPS_DISC_METRICS(FK) Parent Table Name Parent Column Name
Parents: D_ADMIT_SRC_ID LH_D_ADMIT_SRC D_ADMIT_SRC_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ADMIT_SRC HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_TYPE_ID LH_D_ADMIT_TYPE D_ADMIT_TYPE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ADMIT_TYPE HEALTH_SYSTEM_SOURCE_ID
D_BR_CCN_ID LH_D_BR_CCN D_BR_CCN_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BR_CCN HEALTH_SYSTEM_SOURCE_ID
D_BR_HCO_ID LH_D_BR_HCO D_BR_HCO_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BR_HCO HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
D_DISCHARGE_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BUILDING HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BUILDING HEALTH_SYSTEM_SOURCE_ID
D_ENCNTR_TYPE_ID LH_D_ENCNTR_TYPE D_ENCNTR_TYPE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ENCNTR_TYPE HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
D_DISCHARGE_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FACILITY HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FACILITY HEALTH_SYSTEM_SOURCE_ID
D_MED_SERVICE_ID LH_D_MED_SERVICE D_MED_SERVICE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_MED_SERVICE HEALTH_SYSTEM_SOURCE_ID
D_METRIC_1_ID LH_D_METRIC D_METRIC_ID
D_METRIC_4_ID LH_D_METRIC D_METRIC_ID
D_METRIC_5_ID LH_D_METRIC D_METRIC_ID
D_METRIC_6_ID LH_D_METRIC D_METRIC_ID
D_METRIC_7_ID LH_D_METRIC D_METRIC_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_NURSE_UNIT_ID LH_D_NURSE_UNIT D_NURSE_UNIT_ID
D_DISCHARGE_NURSE_UNIT_ID LH_D_NURSE_UNIT D_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_NURSE_UNIT HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_NURSE_UNIT HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_D_PERSON D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PERSON HEALTH_SYSTEM_SOURCE_ID
D_ATTEND_PRSNL_ID LH_D_PERSONNEL D_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PERSONNEL HEALTH_SYSTEM_SOURCE_ID


LH_ABS_HBIPS_EVENTS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_ABS_HBIPS_EVENTS
Definition: Holds relation information between an encounter/person and an HBIPS event
Table Type: ACTIVITY





Column Detail - LH_ABS_HBIPS_EVENTS


Column Name Type Null? Definition
ADDED_PRSNL_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that added the case on the HBIPS Events tab of eQualityCheck.
AUTO_POP_RSLT VARCHAR(100) Y The result of the qualifying clinical event.
ENCNTR_ID DOUBLE N The person id of the patient
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.
LAST_UPDT_PRSNL_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.
LH_ABS_HBIPS_EVENTS_ID DOUBLE N Unique generated number that identifies a single row on the LH_ABS_HBIPS_EVENTS table.
PERSON_ID DOUBLE N The encounter id of the patient
RESULT_DT_TM DATETIME Y The date/time of the qualifying clinical event.
STATUS_FLAG DOUBLE Y The status of the HBIPS event abstraction
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_ABS_HBIPS_EVENTS




Parent Column in LH_ABS_HBIPS_EVENTS (PK) Child Table Name Child Column Name
Children: HEALTH_SYSTEM_SOURCE_ID LH_ABS_COMP_TIME HEALTH_SYSTEM_SOURCE_ID
LH_ABS_HBIPS_EVENTS_ID LH_ABS_COMP_TIME LH_ABS_HBIPS_EVENTS_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_RESPONSE HEALTH_SYSTEM_SOURCE_ID
LH_ABS_HBIPS_EVENTS_ID LH_ABS_RESPONSE LH_ABS_HBIPS_EVENTS_ID


LH_ABS_HBIPS_EVNT_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_ABS_HBIPS_EVNT_METRICS
Definition: This table is used to store metrics for the NHIQM HBIPS event metrics.
Table Type: ACTIVITY





Column Detail - LH_ABS_HBIPS_EVNT_METRICS


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.
ADMIT_DT_TM DATETIME Y The date/time on which the patient was admitted
ADMIT_UTC_DT_TM DATETIME Y The date/time on which the patient was admitted normalized to GMT.
ARRIVAL_DT_TM DATETIME Y The date/time on which the patient arrived at the facility.
ARRIVAL_UTC_DT_TM DATETIME Y The date/time on which the patient arrived at the facility normalized to GMT.
COMM_MRN_TXT VARCHAR(50) Y Identifies the community medical record number of the patient.
COMPLETED_DT_TM DATETIME Y The Date and Time the abstracted case was completed
DISCHARGE_DT_TM DATETIME Y The date/time on which the patient was discharged.
DISCHARGE_UTC_DT_TM DATETIME Y The date/time on which the patient was discharged normalized to GMT.
D_ADMIT_SRC_ID DOUBLE N Identifies the place from which the patient came before being admitted.
D_ADMIT_TYPE_ID DOUBLE N Indicates the circumstances under which the patient was admitted.
D_ATTEND_PRSNL_ID DOUBLE N Identifies the final attending physician associated to the encounter.
D_BR_CCN_ID DOUBLE N CMS Certification Number.
D_BR_HCO_ID DOUBLE N Healthcare organization Number.
D_ENCNTR_TYPE_ID DOUBLE N Categorizes the encounter into a logical group or type.
D_EVENT_BUILDING_ID DOUBLE N The building to which the patient was admitted.
D_EVENT_FACILITY_ID DOUBLE N The facility to which the patient was admitted.
D_EVENT_NURSE_UNIT_ID DOUBLE N The nurse unit to which the patient was admitted.
D_MED_SERVICE_ID DOUBLE N The type or category of medical service that the patient is receiving in relation to their encounter. The category may be treatment type surgery general resources or others.
D_METRIC_2_ID DOUBLE N Identifies the patient population associated with the HBIPS-2 metric.
D_METRIC_3_ID DOUBLE N Identifies the patient population associated with the HBIPS-3 metric.
D_PERSON_ID DOUBLE N The person that qualified for the quality metric.
ENCNTR_ID DOUBLE N Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table.
EVENT_DT DATETIME Y Holds the date of the event
EVENT_TYPE_FLAG DOUBLE Y Holds the type of event (can be both)
EXCLUDE_2_IND DOUBLE Y Identifies patients excluded from HBIPS-2.
EXCLUDE_3_IND DOUBLE Y Identifies patients excluded from HBIPS-3.
EXTRACT_DT_TM DATETIME Y The date/time that the record was extracted from the source system.
FINANCIAL_NBR_TXT VARCHAR(50) Y The financial number alias associated to the encounter.
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_HBIPS_EVENTS_ID DOUBLE N The primary key of the associated row from the lh_abs_hbips_events table
LH_ABS_HBIPS_EVNT_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_ABS_HBIPS_EVNT_METRICS 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.
METRIC_2_IND DOUBLE Y Identifies the patient population associated with the HBIPS-2 metric.
METRIC_3_IND DOUBLE Y Identifies the patient population associated with the HBIPS-3 metric.
NUMERATOR_2_IND DOUBLE Y Identifies patients rejected from HBIPS-2 due to missing data.
NUMERATOR_3_IND DOUBLE Y Identifies patients rejected from HBIPS-3 due to missing data.
ORG_MRN_TXT VARCHAR(50) Y Identifies the medical record number of the patient.
OTH_DIAGNOSIS_LIST VARCHAR(400) Y A comma separated list of other diagnoses associated with the encounter.
OTH_PROCEDURE_DATES_LIST VARCHAR(400) Y A comma separated list of dates the other procedures associated with the encounter were performed.
OTH_PROCEDURE_LIST VARCHAR(400) Y A comma separated list of other procedures associated with the encounter.
PARENT_EVNT_ID DOUBLE N Sometimes rows in this table need a parent id which this column provides when applicable.
PARTITION_DT_TM DATETIME Y The date/time the encounter was discharged from the facility
PAYMENT_SOURCE_FLAG DOUBLE Y Identifies the patient's source of payment.
PHYSICAL_MIN VARCHAR(50) Y Holds the minutes of physical restraint
PHYSICIAN_1_TXT VARCHAR(50) Y First physician identifier.
PHYSICIAN_2_TXT VARCHAR(50) Y Second physician identifier.
PRIN_DIAGNOSIS VARCHAR(10) Y Identifies the principle diagnosis associated with the encounter.
PRIN_PROCEDURE VARCHAR(10) Y Identifies the principle procedure associated with the encounter.
PRIN_PROCEDURE_DATE_TXT VARCHAR(10) Y The date on which the principle procedure was performed.
PRIN_PROCEDURE_DT_TM DATETIME Y The date/time on which the principle procedure was performed.
PRIN_PROCEDURE_UTC_DT_TM DATETIME Y The date/time on which the principle procedure was performed; normalized to GMT
PSYCH_SETTING_IND DOUBLE Y Identifies if the patient was in a psychiatric setting.
REJECT_2_IND DOUBLE Y Identifies patients rejected from HBIPS-2 due to missing data.
REJECT_3_IND DOUBLE Y Identifies patients rejected from HBIPS-3 due to missing data.
SECLUSION_MIN VARCHAR(50) Y Holds the minutes of seclusion
STRATUM_TITLE VARCHAR(50) Y The stratum title of the condition.
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_ID DOUBLE Y 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_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_ABS_HBIPS_EVNT_METRICS


Child Column in LH_ABS_HBIPS_EVNT_METRICS(FK) Parent Table Name Parent Column Name
Parents: D_ADMIT_SRC_ID LH_D_ADMIT_SRC D_ADMIT_SRC_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ADMIT_SRC HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_TYPE_ID LH_D_ADMIT_TYPE D_ADMIT_TYPE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ADMIT_TYPE HEALTH_SYSTEM_SOURCE_ID
D_BR_CCN_ID LH_D_BR_CCN D_BR_CCN_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BR_CCN HEALTH_SYSTEM_SOURCE_ID
D_BR_HCO_ID LH_D_BR_HCO D_BR_HCO_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BR_HCO HEALTH_SYSTEM_SOURCE_ID
D_EVENT_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BUILDING HEALTH_SYSTEM_SOURCE_ID
D_ENCNTR_TYPE_ID LH_D_ENCNTR_TYPE D_ENCNTR_TYPE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ENCNTR_TYPE HEALTH_SYSTEM_SOURCE_ID
D_EVENT_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FACILITY HEALTH_SYSTEM_SOURCE_ID
D_MED_SERVICE_ID LH_D_MED_SERVICE D_MED_SERVICE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_MED_SERVICE HEALTH_SYSTEM_SOURCE_ID
D_METRIC_2_ID LH_D_METRIC D_METRIC_ID
D_METRIC_3_ID LH_D_METRIC D_METRIC_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
D_EVENT_NURSE_UNIT_ID LH_D_NURSE_UNIT D_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_NURSE_UNIT HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_D_PERSON D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PERSON HEALTH_SYSTEM_SOURCE_ID
D_ATTEND_PRSNL_ID LH_D_PERSONNEL D_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PERSONNEL HEALTH_SYSTEM_SOURCE_ID


LH_ABS_HBIPS_PATIENTS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_ABS_HBIPS_PATIENTS
Definition: Holds relation information between an encounter/person and an HBIPS event
Table Type: ACTIVITY





Column Detail - LH_ABS_HBIPS_PATIENTS


Column Name Type Null? Definition
ARRIVE_DT_TM DATETIME Y When the patient arrived to the pysch location
ARRIVE_UTC_DT_TM DATETIME Y When the patient arrived to the pysch location
DEPART_DT_TM DATETIME Y When the patient departed from the pysch location
DEPART_UTC_DT_TM DATETIME Y When the patient departed from the pysch location
D_BR_CCN_ID DOUBLE N CMS Certification Number
D_BR_HCO_ID DOUBLE N Healthcare Organization Number
D_BUILDING_ID DOUBLE N The building to which the patient was admitted
D_FACILITY_ID DOUBLE N The facility to which the patient was admitted
D_NURSE_UNIT_ID DOUBLE N The nurse unit to which the patient was admitted
D_PERSON_ID DOUBLE N The person that qualifies for the quality metric
ENCNTR_ID DOUBLE N Identifies the encounter for the qualify measure
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.
LEAVE_IND DOUBLE N Indicator used to determine if the table row is psych day row or psych leave row. 0 - psych day row, 1 - psych leave row.
LH_ABS_HBIPS_PATIENTS_ID DOUBLE N Unique generated number that identifies a single row on the LH_ABS_HBIPS_PATIENTS table.
PAYMENT_SOURCE_FLAG DOUBLE N Identifies if the patient has a medicare payment source.
STRATUM_TITLE VARCHAR(50) Y The stratum title of the condition.
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_ABS_HBIPS_PATIENTS


Child Column in LH_ABS_HBIPS_PATIENTS(FK) Parent Table Name Parent Column Name
Parents: D_BR_CCN_ID LH_D_BR_CCN D_BR_CCN_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BR_CCN HEALTH_SYSTEM_SOURCE_ID
D_BR_HCO_ID LH_D_BR_HCO D_BR_HCO_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BR_HCO HEALTH_SYSTEM_SOURCE_ID
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
D_PERSON_ID LH_D_PERSON D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PERSON HEALTH_SYSTEM_SOURCE_ID