Table Detail Report
LH_ABS_PC_BF_METRICS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_ABS_PC_BF_METRICS |
Definition: | This table is used to store Breast Feeding PC metrics from the Lighthouse Abstractor (eQuality Check). This table is at the encounter grain. |
Table Type: | ACTIVITY |
Column Detail - LH_ABS_PC_BF_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_NICU_IND | DOUBLE | Y | Identifies if the patient was admitted to a NICU |
ADMIT_UTC_DT_TM | DATETIME | Y | The date/time on which the patient was admitted normalized to GMT. |
BIRTH_WEIGHT | VARCHAR(10) | Y | Holds the birthweight of the encounter and PC Abstraction. |
CLINICAL_TRIAL_FLAG | DOUBLE | Y | Identifies if the patient is excluded from the measure due to participation in a clinical trial. |
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. |
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_DISCH_DISP_ID | DOUBLE | N | The conditions under which the patient left the facility at the time of discharge. |
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_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 | Represents if the person is excluded for PC1 |
EXCLUDE_2_IND | DOUBLE | Y | Represents if the person is excluded for PC2 |
EXCL_BREAST_FEED_IND | DOUBLE | Y | Identifies if exclusive breastfeeding during hospitalization occurred |
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_PC_BF_METRICS_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_ABS_PC_BF_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_1_IND | DOUBLE | Y | Represents if the person is in the numerator for PC1 |
NUMERATOR_2_IND | DOUBLE | Y | Represents if the person is in the numerator for PC2 |
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. |
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 |
PC5_REASON_TXT | VARCHAR(250) | Y | Stores the category reason for PC-05 obtained during the completion of abstraction. |
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 |
PRS_TXT | VARCHAR(10) | Y | Identifies the Patient Reliability Score (PRS). |
REASON_NO_EXCL_BF_FLAG | DOUBLE | Y | Identifies the patient has a reason for not using exclusive breastfeeding |
REJECT_1_IND | DOUBLE | Y | Represents if the person is rejected for PC1 |
REJECT_2_IND | DOUBLE | Y | Represents if the person is rejected for PC2 |
SAMPLE_IND | DOUBLE | Y | This case represent part of a sample |
TERM_NEWBORN_FLAG | DOUBLE | Y | A flag indicating if a newborn had completed 37 or more weeks of gestation. 0 - No, 1 - Yes, 999 - Missing. |
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_PC_BF_METRICS
Child Column in LH_ABS_PC_BF_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_DISCH_DISP_ID | LH_D_DISCH_DISP | D_DISCH_DISP_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_DISCH_DISP | 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 | |
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_PC_BSI_METRICS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_ABS_PC_BSI_METRICS |
Definition: | This table is used to store Blood Stream Infection PC metrics from the Lighthouse Abstractor (eQuality Check). This table is at the encounter grain. |
Table Type: | ACTIVITY |
Column Detail - LH_ABS_PC_BSI_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. |
BIRTH_WEIGHT | VARCHAR(10) | Y | Weight of the birth |
BLOODSTREAM_INFECTION_FLAG | DOUBLE | Y | Identifies if the patient had a bloodstream infection present on admission.1 - Yes, there was a bloodstream infection present on admission0 - No, there was not a bloodstream infection present on admission999 - Question was not answered |
BLOOD_INF_CONFIRMED_FLAG | DOUBLE | Y | A flag indicating if a bloodstream Infection is confirmed. 0 - No, 1 - Yes, 999 - Missing. |
CLINICAL_TRIAL_FLAG | DOUBLE | Y | Identifies if the patient is excluded from the measure due to participation in a clinical trial. |
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. |
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_DISCH_DISP_ID | DOUBLE | N | The conditions under which the patient left the facility at the time of discharge. |
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_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 | Represents if the person is excluded for PC1 |
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 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_PC_BSI_METRICS_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_ABS_PC_BSI_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_1_IND | DOUBLE | Y | Represents if the person is in the numerator for PC1 |
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. |
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. |
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 |
PRS_TXT | VARCHAR(10) | Y | Identifies the Patient Reliability Score (PRS). |
REJECT_1_IND | DOUBLE | Y | Represents if the person is rejected for PC1 |
SAMPLE_IND | DOUBLE | Y | This case represent part of a 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. |
UPDT_DT_TM | DATETIME | Y | 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) | 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_PC_BSI_METRICS
Child Column in LH_ABS_PC_BSI_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_DISCH_DISP_ID | LH_D_DISCH_DISP | D_DISCH_DISP_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_DISCH_DISP | 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 | |
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_PC_MOTHER_METRICS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_ABS_PC_MOTHER_METRICS |
Definition: | This table is used to store Mother PC metrics from the Lighthouse Abstractor (eQuality Check). This table is at the encounter grain. |
Table Type: | ACTIVITY |
Column Detail - LH_ABS_PC_MOTHER_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. |
ANT_STER_IND | DOUBLE | Y | Identifies if antenatal steroid therapy was initiated |
CLINICAL_TRIAL_FLAG | DOUBLE | Y | Identifies if the patient is excluded from the measure due to participation in a clinical trial. |
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. |
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_DISCH_DISP_ID | DOUBLE | N | The conditions under which the patient left the facility at the time of discharge. |
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_PERSON_ID | DOUBLE | N | The person that qualified for the quality metric. |
D_REASON_1_ID | DOUBLE | N | The reason for the PC-1 outcome. Relates to parent table LH_D_MEASURE_REASON. |
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 | Represents if the person is excluded for PC1 |
EXCLUDE_2_IND | DOUBLE | Y | Represents if the person is excluded for PC2 |
EXCLUDE_3_IND | DOUBLE | Y | Represents if the person is excluded for PC3 |
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. |
GESTATION_AGE | VARCHAR(10) | Y | Age in weeks of gestation |
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. |
HXSTILLBIRTH_IND | DOUBLE | Y | History of Still birth indicator |
LABOR_IND | DOUBLE | Y | Identifies if the patient was in labor |
LAST_PROCESS_DT_TM | DATETIME | Y | The date/time that the last ETL process started that updated this record. |
LH_ABS_PC_MOTHER_METRICS_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_ABS_PC_MOTHER_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_1_IND | DOUBLE | Y | Represents if the person is in the numerator for PC1 |
NUMERATOR_2_IND | DOUBLE | Y | Represents if the person is in the numerator for PC2 |
NUMERATOR_3_IND | DOUBLE | Y | Represents if the person is in the numerator for PC3 |
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. |
PARITY | VARCHAR(10) | Y | How many deliveries did the patient experience prior to current hospitalization |
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 |
PC1_REASON_TXT | VARCHAR(250) | Y | Stores the category reason for PC-1 obtained during the completion of abstraction. |
PC2_REASON_TXT | VARCHAR(250) | Y | Stores the category reason for PC-2 obtained during the completion of abstraction. |
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 |
PRIOR_UTER_SURG_IND | DOUBLE | Y | Identifies if prior uterine surgery had been performed |
PRS_TXT | VARCHAR(10) | Y | Identifies the Patient Reliability Score (PRS). |
REASON_NO_ANT_STER_IND | DOUBLE | Y | Identifies the patient has a reason for not having antenatal steroid therapy initiated |
REJECT_1_IND | DOUBLE | Y | Represents if the person is rejected for PC1 |
REJECT_2_IND | DOUBLE | Y | Represents if the person is rejected for PC2 |
REJECT_3_IND | DOUBLE | Y | Represents if the person is rejected for PC3 |
SAMPLE_IND | DOUBLE | Y | This case represent part of a sample |
SPON_RUPT_MEM_IND | DOUBLE | Y | Identifies if spontaneous rupture of membranes had been documented |
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_PC_MOTHER_METRICS
Child Column in LH_ABS_PC_MOTHER_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_DISCH_DISP_ID | LH_D_DISCH_DISP | D_DISCH_DISP_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_DISCH_DISP | 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_REASON_1_ID | LH_D_MEASURE_REASON | D_MEASURE_REASON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_MEASURE_REASON | 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 | |
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_PC_UNC_METRICS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_ABS_PC_UNC_METRICS |
Definition: | Stores information about Perinatal Care Newborn Unexpected Complications encounters |
Table Type: | ACTIVITY |
Column Detail - LH_ABS_PC_UNC_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. |
BIRTH_WEIGHT | VARCHAR(10) | Y | Weight of the newborn at birth. |
COMM_MRN_TXT | VARCHAR(50) | Y | Identifies the community medical record number of the patient. |
COMPLETED_DT_TM | DATETIME | Y | The Date and Time at which 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. |
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 LH_D_BR_CCN. |
D_BR_HCO_ID | DOUBLE | N | Healthcare organization Number. Foreign key to 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_DISCH_DISP_ID | DOUBLE | N | The conditions under which the patient left the facility at the time of discharge. Foreign key to LH_D_DISCH_DISP. |
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_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. |
EXCLUDE_6_IND | DOUBLE | Y | Represents if the person is excluded for PC-06. |
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_PC_UNC_METRICS_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_ABS_PC_UNC_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_6_IND | DOUBLE | Y | Represents if the person is in the numerator for PC-06. |
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. |
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. |
PC6_1_IND | DOUBLE | Y | Identifies if there are Unexpected Complications in Term Newborns - Severe Rate |
PC6_2_IND | DOUBLE | Y | Identifies if there are Unexpected Complications in Term Newborns - Moderate Rate |
PC6_CATEGORY_REASON_TXT | VARCHAR(200) | Y | Identifies the category reason for the measure outcome. |
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. |
PRS_TXT | VARCHAR(10) | Y | Identifies the Patient Reliability Score (PRS). |
REJECT_6_IND | DOUBLE | Y | Represents if the person is rejected for PC-06. |
SAMPLE_IND | DOUBLE | Y | Indicates if the case is sampled. |
TERM_NEWBORN_FLAG | DOUBLE | Y | A flag indicating if a newborn had completed 37 or more weeks of gestation. 0 - No, 1 -Yes, 999 - Missing. |
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_PC_UNC_METRICS
Child Column in LH_ABS_PC_UNC_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_DISCH_DISP_ID | LH_D_DISCH_DISP | D_DISCH_DISP_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_DISCH_DISP | 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 | |
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 |
LH_ABS_PN_METRICS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_ABS_PN_METRICS |
Definition: | This table is used to store PN metrics from the Lighthouse Abstractor (eQuality Check). This table is at the encounter grain. |
Table Type: | ACTIVITY |
Column Detail - LH_ABS_PN_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. |
ANOTHERINF_FLAG | DOUBLE | Y | Identifies if the patient with another suspected source of bacterial infection in addition to pneumonia within 24 hours of arrival. |
ANTIALLERGY_FLAG | DOUBLE | Y | Identifies patients that have allergies - sensitivities or intolerance to beta-lactam/penicillin antibiotic or cephalosporin medications |
ANTIBIRCVD_FLAG | DOUBLE | Y | Identifies the patient receive antibiotics within 24 hours of arrival or the day prior to arrival and/or during this hospital stay. |
ARRIVAL_DATE_TXT | VARCHAR(10) | Y | The earliest documented date the patient arrived at the hospital. User Entered (MM-DD-YYYY) Includes dashes |
ARRIVAL_DT_TM | DATETIME | Y | The date/time on which the patient arrived at the facility. |
ARRIVAL_TIME_TXT | VARCHAR(10) | Y | The earliest documented date the patient arrived at the hospital. User Entered (Military format with or without colon - HH:MM) |
ARRIVAL_UTC_DT_TM | DATETIME | Y | The date/time on which the patient arrived at the facility normalized to GMT. |
BLOODCAFTRAR_FLAG | DOUBLE | Y | Identified when/if the patient have blood cultures collected. |
CLINICAL_TRIAL_FLAG | DOUBLE | Y | During this hospital stay - the patient enrolled in a clinical trial in which patients with the same condition as the measure set were being studied |
CMO_FLAG | DOUBLE | Y | The earliest physician/APN/PA documentation of comfort measures only |
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 |
COMPROMISED_FLAG | DOUBLE | Y | Identifies patients with a compromising condition |
CXRAY_FLAG | DOUBLE | Y | Identifies the patient have a chest x-ray/CT scan the day prior to hospital arrival through acute inpatient discharge. |
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 | The patient s discharge disposition on the day of discharge. |
DTABX_LIST | VARCHAR(1000) | Y | A comma separated list of the date of antibiotic administered after hospital arrival and within the specified timeframe. User Entered (MM-DD-YYYY) Includes dashes |
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 BR_CCN. |
D_BR_HCO_ID | DOUBLE | N | Healthcare organization Number. Foreign key to 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_DISCH_DISP_ID | DOUBLE | N | The conditions under which the patient left the facility at the time of discharge. |
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_10_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric |
D_METRIC_11_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric |
D_METRIC_12_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric |
D_METRIC_13_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric |
D_METRIC_14_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric |
D_METRIC_15_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric |
D_METRIC_16_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric |
D_METRIC_17_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric |
D_METRIC_18_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric |
D_METRIC_19_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric |
D_METRIC_1_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric |
D_METRIC_20_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_METRIC_9_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse 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_3A_IND | DOUBLE | Y | Identifies patients excluded from PN-3a |
EXCLUDE_3B_IND | DOUBLE | Y | Identifies patients excluded from PN-3b |
EXCLUDE_6A_IND | DOUBLE | Y | Identifies patients excluded from PN-6a |
EXCLUDE_6B_IND | DOUBLE | Y | Identifies patients excluded from PN-6b |
EXCLUDE_6_IND | DOUBLE | Y | Identifies patients excluded from PN-6 |
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 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. |
HLTHCAREPN_FLAG | DOUBLE | Y | Identifies if the patient has a documentation of risk for healthcare associated pneumonia |
ICU24_FLAG | DOUBLE | Y | Identifies if the patient admitted or transferred to the intensive care unit (ICU) during this hospitalization. |
INITBLOODCDT_TXT | VARCHAR(10) | Y | Date the Initial Blood Culture Collection. User Entered (MM-DD-YYYY) Includes dashes |
INITBLOODCTM_TXT | VARCHAR(10) | Y | Time the Initial Blood Culture Collection. User Entered (HH-MM) Includes dashes |
INITBLOOD_DT_TM | DATETIME | Y | The Initial Blood Culture Collection date/time. |
INITBLOOD_UTC_DT_TM | DATETIME | Y | The Initial Blood Culture Collection date/time; normalized to GMT. |
LAST_PROCESS_DT_TM | DATETIME | Y | The date/time the record was last loaded into the table. |
LH_ABS_PN_METRICS_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_ABS_PN_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. |
NAMEABX_LIST | VARCHAR(2000) | Y | A comma separated list of the names of the antibiotic dose(s) administered after hospital arrival and within the specified timeframe |
NUMERATOR_3A_IND | DOUBLE | Y | Identifies patients that qualify for PN-3a |
NUMERATOR_3B_IND | DOUBLE | Y | Identifies patients that qualify for PN-3b |
NUMERATOR_6A_IND | DOUBLE | Y | Identifies patients that qualify for PN-6a |
NUMERATOR_6B_IND | DOUBLE | Y | Identifies patients that qualify for PN-6b |
NUMERATOR_6_IND | DOUBLE | Y | Identifies patients that qualify for PN-6 |
ORG_MRN_TXT | VARCHAR(50) | Y | Identifies the medical record number of the patient. |
OTH_DIAGNOSIS_LIST | VARCHAR(500) | Y | A comma separated list of other diagnoses associated with the encounter. |
OTH_PROCEDURE_DATES_LIST | VARCHAR(500) | Y | A comma separated list of dates the other procedures associated with the encounter were performed. |
OTH_PROCEDURE_LIST | VARCHAR(500) | Y | A comma separated list of other procedures 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. |
PNDIAGNOSIS_FLAG | DOUBLE | Y | Identifies if the pneumonia diagnosis was in the ED or upon direct admission. |
PN_AB_ADMIN_DT_TM | DATETIME | Y | The date/time of the initial antibiotic administration |
PN_AB_ADMIN_UTC_DT_TM | DATETIME | Y | The date/time of the initial antibiotic administration; normalized to GMT |
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 |
PRS_TXT | VARCHAR(10) | Y | Identifies the Patient Reliability Score (PRS). |
PSEUDOMONALRISK_FLAG | DOUBLE | Y | Identifies the patient has risk of pseudomonas. |
REJECT_3A_IND | DOUBLE | Y | Identifies patients reject for PN-3a |
REJECT_3B_IND | DOUBLE | Y | Identifies patients reject for PN-3b |
REJECT_6A_IND | DOUBLE | Y | Identifies patients reject for PN-6a |
REJECT_6B_IND | DOUBLE | Y | Identifies patients reject for PN-6b |
REJECT_6_IND | DOUBLE | Y | Identifies patients reject for PN-6 |
ROUTEABX_LIST | VARCHAR(500) | Y | A comma separated list of the routes of the antibiotic dose(s) administered after hospital arrival and within the specified timeframe |
RSNALTABX_FLAG | DOUBLE | Y | Reason for Alternative Empiric Antibiotic Therapy question flag. |
SAMPLE_IND | DOUBLE | Y | This case represent part of a sample |
TMABX_LIST | VARCHAR(1000) | Y | A comma separated list of the time of antibiotic administered after hospital arrival and within the specified timeframe. User Entered (HH-MM) Includes dashes |
TRANSFERED_FLAG | DOUBLE | Y | Identifies if the patient received as a transfer from an inpatient - outpatient or emergency/observation department of another hospital or from an ambulatory surgery center. |
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 script name responsible for updating the record. |
UPDT_TASK | VARCHAR(50) | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - LH_ABS_PN_METRICS
Child Column in LH_ABS_PN_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_DISCH_DISP_ID | LH_D_DISCH_DISP | D_DISCH_DISP_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_DISCH_DISP | 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_10_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_11_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_12_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_13_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_14_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_15_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_16_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_17_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_18_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_19_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_1_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_20_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 | |
D_METRIC_9_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 | |
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 | |
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 |