Table Detail Report
LH_ABS_HBIPS_PATIENTS_INFO
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_ABS_HBIPS_PATIENTS_INFO |
Definition: | Contains additional information about cases present in the lh_abs_hbips_patients table |
Table Type: | ACTIVITY |
Column Detail - LH_ABS_HBIPS_PATIENTS_INFO
Column Name | Type | Null? | Definition |
---|---|---|---|
ADMIT_DT_TM | DATETIME | Y | The date/time on which the patient was admitted. |
DISCHARGE_DT_TM | DATETIME | Y | The date/time on which the patient was discharged. |
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. |
ENCNTR_ID | DOUBLE | N | Identifies the encounter against which the psych days are associated. Foreign key to the ENCOUNTER table. |
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_PATIENTS_INFO_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_ABS_HBIPS_PATIENTS_INFO table. |
ORG_MRN_TXT | VARCHAR(50) | Y | Identifies the medical record number of the patient. |
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 reecord. |
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_INFO
Child Column in LH_ABS_HBIPS_PATIENTS_INFO(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_ABS_HELP
Column Section | Top of Page |
Table-level Detail
Description: | LH_ABS_HELP |
Definition: | Structure to define the help documentation for Lighthouse Abstractor (eQuality Check) |
Table Type: | REFERENCE |
Column Detail - LH_ABS_HELP
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 |
DISPLAY | VARCHAR(50) | Y | Help file's display text. This will only be present for top level help. |
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. |
HELP_FILENAME | VARCHAR(100) | Y | Help file's file name |
HELP_PATH | VARCHAR(100) | Y | Relative directory text where the help file is residing |
HELP_SEQ | DOUBLE | Y | Assigns display order for the top level help files |
LAST_PROCESS_DT_TM | DATETIME | Y | The date/time that the last ETL process started that updated this record. |
LH_ABS_HELP_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_ABS_HELP table. |
LH_ABS_QUESTION_ID | DOUBLE | N | The question which the help file is for. This has the potential to be null for top level help. Foreign Key to LH_ABS_QUESTION but can be null/0 |
LINK_TEXT | VARCHAR(50) | Y | Help file's text to be used as a link. |
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_HF_METRICS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_ABS_HF_METRICS |
Definition: | This table is used to store metrics for the NHIQM heart failure metrics. This table is at the encounter grain based upon the heart failure population definition. |
Table Type: | ACTIVITY |
Column Detail - LH_ABS_HF_METRICS
Column Name | Type | Null? | Definition |
---|---|---|---|
ACEIRXDCHG_FLAG | DOUBLE | Y | Identifies if the patient was prescribed an ARB at discharge. |
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. |
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. |
ARBRXDIS_FLAG | DOUBLE | Y | Identifies if there is a valid reason documented for not prescribing an ACEI/ARB at discharge. |
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. |
CLINICAL_TRIAL_FLAG | DOUBLE | Y | Identifies if a patient was excluded due to an order for comfort measures. |
CMO_FLAG | DOUBLE | Y | Identifies the discharge instructions provided to the patient to address activity. |
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 |
CTRACEI_FLAG | DOUBLE | Y | Identifies the patient's source of payment. |
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 if the patient is excluded from the measure due to participation in a clinical trial. |
DSINSTADAC_FLAG | DOUBLE | Y | Identifies the discharge instructions provided to the patient to address diet. |
DSINSTADDI_FLAG | DOUBLE | Y | Identifies the discharge instructions provided to the patient to address follow up. |
DSINSTADFU_FLAG | DOUBLE | Y | Identifies the discharge instructions provided to the patient to address medications. |
DSINSTADMD_FLAG | DOUBLE | Y | Identifies the discharge instructions provided to the patient to address symptoms worsening. |
DSINSTADSW_FLAG | DOUBLE | Y | Identifies the discharge instructions provided to the patient to address weight monitoring. |
DSINSTADWT_FLAG | DOUBLE | Y | Identifies if the patient had an LVS function evaluation. |
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 | CMS Certification Number. |
D_BR_HCO_ID | DOUBLE | N | Healthcare organization Number. |
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 HF2 metric. |
D_METRIC_2_ID | DOUBLE | N | Identifies the patient population associated with the HF3 metric. |
D_METRIC_3_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. |
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 HF-1 |
EXCLUDE_2_IND | DOUBLE | Y | Identifies patients excluded from HF-2 |
EXCLUDE_3_IND | DOUBLE | Y | Identifies patients excluded from HF-3 |
EXTRACT_DT_TM | DATETIME | 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. |
FINANCIAL_NBR_TXT | VARCHAR(50) | Y | The financial number alias associated to the encounter. |
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_HF_METRICS_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_ABS_HF_METRICS table. |
LOGICAL_DOMAIN_ID | DOUBLE | N | Identifies the discharge disposition of the patient. |
LVEFEVAL_FLAG | DOUBLE | Y | Identifies if the patient was prescribed an ACEI at discharge. |
LVSD_FLAG | DOUBLE | Y | Identifies patients with an LVEF of moderate to severe. |
NUMERATOR_1_IND | DOUBLE | Y | Identifies patients that qualify for HF-1 |
NUMERATOR_2_IND | DOUBLE | Y | Identifies patients that qualify for HF-2 |
NUMERATOR_3_IND | DOUBLE | Y | Identifies patients that qualify for HF-3 |
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 |
PAYMENT_SOURCE_FLAG | DOUBLE | Y | The principle diagnosis. |
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). |
REJECT_1_IND | DOUBLE | Y | Identifies patients rejected from HF-1 due to missing data. |
REJECT_2_IND | DOUBLE | Y | Identifies patients rejected from HF-2 due to missing data. |
REJECT_3_IND | DOUBLE | Y | Identifies patients rejected from HF-3 due to missing data. |
SAMPLE_IND | DOUBLE | Y | Identifies if the patient is part of a sample. |
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(50) | N | The date/time that the record was extracted from the source system. |
UPDT_TASK | VARCHAR(50) | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - LH_ABS_HF_METRICS
Child Column in LH_ABS_HF_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_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_HOQR_AMI_METRICS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_ABS_HOQR_AMI_METRICS |
Definition: | This table is used to store HOQR AMI metrics from the Lighthouse Abstractor (eQuality Check). This table is at the encounter grain. |
Table Type: | ACTIVITY |
Column Detail - LH_ABS_HOQR_AMI_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 earliest documented date/time on which the patient arrived at the hospital. |
ARRIVAL_TIME_TXT | VARCHAR(10) | Y | The earliest documented time the patient arrived at the hospital. User Entered (Military format with or without colon, HH:MM) |
ARRIVAL_UTC_DT_TM | DATETIME | Y | The earliest documented date/time on which the patient arrived at the hospital normalized to GMT. |
ASPIRINRCVD_FLAG | DOUBLE | Y | Identifies if the patient received Aspirin. |
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 |
CTRASPRN_FLAG | DOUBLE | Y | Identifies the patient has a documented reason for no Aspirin on arrival. |
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_TXT | VARCHAR(10) | Y | The patient's discharge disposition on the day of 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 | CMS Certification Number. |
D_BR_HCO_ID | DOUBLE | N | Healthcare organization Number. |
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 metric identifier for the Lighthouse metric |
D_METRIC_2_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric |
D_METRIC_3_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric |
D_METRIC_4_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric |
D_METRIC_5_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric |
D_METRIC_6_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric |
D_METRIC_7_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric |
D_METRIC_8_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric |
D_PERSON_ID | DOUBLE | N | The person that qualified for the quality metric. |
ECGDONE_FLAG | DOUBLE | Y | Identifies if the patient has an ECG performed. |
ECGDT_TXT | VARCHAR(10) | Y | Date of the initial ECG. User Entered (MM-DD-YYYY) Includes dashes |
ECGTM_TXT | VARCHAR(10) | Y | Time of the initial ECG. User Entered (Military format with or without colon, HH:MM) |
ECG_DT_TM | DATETIME | Y | The date/time of the initial ECG |
ECG_UTC_DT_TM | DATETIME | Y | The date/time of the ECG; normalized to GMT. |
ED_DEPART_DATE_TXT | VARCHAR(10) | Y | Date the patient departed from the emergency department. User Entered (MM-DD-YYYY) Includes dashes. |
ED_DEPART_DT_TM | DATETIME | Y | Time the patient departed from the emergency department. |
ED_DEPART_TIME_TXT | VARCHAR(10) | Y | Time the patient departed from the emergency department. User Entered (Military format with or without colon, HH:MM) |
ED_DEPART_UTC_DT_TM | DATETIME | Y | Time the patient departed from the emergency department normalized to GMT. |
EMCODE | VARCHAR(10) | Y | Identifies the patient E/M code documented |
ENCNTR_ID | DOUBLE | N | Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table. |
EXCLUDE_16_IND | DOUBLE | Y | Identifies patients excluded from OP-16 |
EXCLUDE_1_IND | DOUBLE | Y | Identifies patients excluded from OP-1, OP-2 |
EXCLUDE_3_IND | DOUBLE | Y | Identifies patients excluded from OP-3 |
EXCLUDE_4_IND | DOUBLE | Y | Identifies patients excluded from OP-4 |
EXCLUDE_5_IND | DOUBLE | Y | Identifies patients excluded from OP-5 |
EXTRACT_DT_TM | DATETIME | Y | The date/time that the record was extracted from the source system. |
FIBADMINDT_TXT | VARCHAR(10) | Y | Date of the Fibrinolytic Administration. User Entered (MM-DD-YYYY) Includes dashes |
FIBADMINTM_TXT | VARCHAR(10) | Y | Time of the Fibrinolytic Administration. User Entered (Military format with or without colon, HH:MM) |
FIBADMIN_DT_TM | DATETIME | Y | The date/time of the Fibrinolytic Administration |
FIBADMIN_FLAG | DOUBLE | Y | Identifies if the patient has fibrinolytic administration. |
FIBADMIN_UTC_DT_TM | DATETIME | Y | The date/time of the Fibrinolytic Administration; normalized to GMT. |
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. |
INITECGINT_FLAG | DOUBLE | Y | Identifies if the patient had an elevated ST or LBBB. |
LAST_PROCESS_DT_TM | DATETIME | Y | The date/time that the last ETL process started that updated this record. |
LH_ABS_HOQR_AMI_METRICS_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_ABS_HOQR_AMI_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. |
NUMERATOR_16_IND | DOUBLE | Y | Identifies patients that qualify for OP-16 |
NUMERATOR_2_IND | DOUBLE | Y | Identifies patients that qualify for OP-2 |
NUMERATOR_3A_IND | DOUBLE | Y | Identifies patients that qualify for OP-3 overall rate |
NUMERATOR_3B_IND | DOUBLE | Y | Identifies patients that qualify for OP-3 Reporting Rate |
NUMERATOR_3C_IND | DOUBLE | Y | Identifies patients that qualify for OP-3 Quality Improvement Rate |
NUMERATOR_4_IND | DOUBLE | Y | Identifies patients that qualify for OP-4 |
OP1_MEASUREMENT_VALUE | DOUBLE | Y | Identifies the time of fibrinolyisis (minutes) |
OP2_REASON_TXT | VARCHAR(250) | Y | Stores the category reason for OP-2 obtained during the completion of abstraction. |
OP3_MEASUREMENT_VALUE | DOUBLE | Y | Identifies the time in ED (minutes) |
OP3_REASON_TXT | VARCHAR(250) | Y | Stores the category reason for OP-3 obtained during the completion of abstraction. |
OP5_MEASUREMENT_VALUE | DOUBLE | Y | Identifies the time of ECG (minutes) |
ORG_MRN_TXT | VARCHAR(50) | Y | Identifies the medical record number of the patient. |
OTH_DIAGNOSIS_LIST | VARCHAR(250) | Y | A comma separated list of other diagnoses associated with the encounter. |
PARTITION_DT_TM | DATETIME | Y | The date/time the encounter was discharged from the facility |
PAYMENT_SOURCE_FLAG | DOUBLE | Y | Identifies the source of payment for the encounter |
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. |
PRS_TXT | VARCHAR(10) | Y | Identifies the Patient Reliability Score (PRS). |
REASONDELFIB_FLAG | DOUBLE | Y | Identifies the patient has a documented reason for a delay in initiating fibrinolytic therapy. |
REASONNOFIBADMIN_FLAG | DOUBLE | Y | Identifies the patient has a documented reason for not administering fibrinolytic therapy. |
REJECT_16_IND | DOUBLE | Y | Identifies patients reject for OP-16 |
REJECT_1_IND | DOUBLE | Y | Identifies patients reject for OP-1, OP-2 |
REJECT_3_IND | DOUBLE | Y | Identifies patients reject for OP-3 |
REJECT_4_IND | DOUBLE | Y | Identifies patients reject for OP-4 |
REJECT_5_IND | DOUBLE | Y | Identifies patients reject for OP-5 |
SAMPLE_IND | DOUBLE | Y | This case represent part of a sample |
TRANSFERCORINT_FLAG | DOUBLE | Y | Identifies if the patient was transferred for acute coronary intervention is documented. |
TROPORD_FLAG | DOUBLE | Y | Identifies if the patient has troponin orders |
TROPRESDT_TXT | VARCHAR(10) | Y | Date of troponin order. User Entered (MM-DD-YYYY) Includes dashes |
TROPRESTM_TXT | VARCHAR(10) | Y | Time of troponin order. User Entered (Military format with or without colon, HH:MM) |
TROPRES_DT_TM | DATETIME | Y | The date/time of troponin order |
TROPRES_UTC_DT_TM | DATETIME | Y | The date/time of troponin order; normalized to GMT. |
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. |
Relationship Detail - LH_ABS_HOQR_AMI_METRICS
Child Column in LH_ABS_HOQR_AMI_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_2_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_3_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 | |
D_METRIC_8_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 | |
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_HOQR_CATA_METRICS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | SCR_LH_ABS_HOQR_CATA_METRICS |
Definition: | Contains information based on HOQR OP-31: Appropriate Follow-up Interval for Normal Colonoscopy in Average Risk Patients condition for an encounters |
Table Type: | ACTIVITY |
Column Detail - LH_ABS_HOQR_CATA_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. |
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 |
CPTCODE | VARCHAR(10) | Y | Identify the CPT code is selected for the patient |
CPTCODEDT_TXT | VARCHAR(10) | Y | The date for CPT code performed. User Entered (MM-DD-YYYY) Includes dashes |
CPTCODE_DESC_TXT | VARCHAR(255) | Y | Textual description of the CPTCODE documented for the case |
CPTCODE_DT_TM | DATETIME | Y | The date/time on which CPT code performed. |
CPTCODE_UTC_DT_TM | DATETIME | Y | The The date/time on which CPT code performed. normalized to GMT. |
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_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 | CMS Certification Number. Foreign key to the LH_D_BR_CCN |
D_BR_HCO_ID | DOUBLE | N | Healthcare organization Number. Foreign key to the LH_D_BR_HCO |
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 metric identifier for the Lighthouse metric. |
D_METRIC_2_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric. |
D_METRIC_3_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric. |
D_METRIC_4_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric. |
D_METRIC_5_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric. |
D_PERSON_ID | DOUBLE | N | Identifies the person associated with the quality measure. Foreign key to the LH_D_PERSON |
ENCNTR_ID | DOUBLE | N | Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table. |
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_HOQR_CATA_METRICS_ID | DOUBLE | N | Unique generated number that identifies a single row on the SCR_LH_ABS_HOQR_CATA_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. |
NUMERATOR_31_IND | DOUBLE | Y | Identifies if this case meets the criteria to be 'met' or 'not met' |
OP31_REASON_TXT | VARCHAR(250) | Y | Stores the category reason obtained during the completion of abstraction. |
ORG_MRN_TXT | VARCHAR(50) | Y | Identifies the medical record number of the patient. |
PARTITION_DT_TM | DATETIME | Y | The date/time the encounter was discharged from the facility |
PHYSICIAN_1_TXT | VARCHAR(50) | Y | First physician identifier |
PHYSICIAN_2_TXT | VARCHAR(50) | Y | Second physician identifier |
PRS_TXT | VARCHAR(10) | Y | Identifies the Patient Reliability Score (PRS). |
SAMPLE_IND | DOUBLE | Y | Indicates if the case was sampled |
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 | 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. |
VSLFNCTNSRVY_FLAG | DOUBLE | Y | Identifies if a pre and post operative visual function instrument was completed |
VSLIMPRVMNT_FLAG | DOUBLE | Y | Identifies if there was improvement in patients visual function within 90 days post cataract surgery |
Relationship Detail - LH_ABS_HOQR_CATA_METRICS
Child Column in LH_ABS_HOQR_CATA_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_2_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_3_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 | |
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 |