Table Detail Report
LH_F_REST_HST_METRICS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_F_REST_HST_METRICS |
Definition: | Fact table for Restraint Management History Lighthouse Reporting |
Table Type: | ACTIVITY |
Column Detail - LH_F_REST_HST_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. |
ARRIVAL_DT_TM | DATETIME | Y | The date/time on which the patient arrived at the unit |
ARRIVAL_UTC_DT_TM | DATETIME | Y | The date/time on which the patient arrived at the unit.; normalized to GMT |
AT_RISK_IND | DOUBLE | Y | Identifies if the patient is at risk. |
DEPART_DT_TM | DATETIME | Y | The date/time on which the patient left the unit. |
DEPART_UTC_DT_TM | DATETIME | Y | The date/time on which the patient left the unit; normalized to GMT. |
D_BUILDING_ID | DOUBLE | N | The building the patient spent time in. |
D_FACILITY_ID | DOUBLE | N | The facility the patient spent time in. |
D_NURSE_UNIT_ID | DOUBLE | N | The nurse unit the patient spent time in. |
EDUCATION_IND | DOUBLE | Y | Identifies if the patient has received restraint education. |
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. |
FIRST_PROCESS_DT_TM | DATETIME | Y | The date/time the record was first loaded into the table. |
F_REST_HST_METRICS_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_F_REST_HST_METRICS 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. |
LOGICAL_DOMAIN_ID | DOUBLE | N | The unique identifier for the logical domain. This identifier allows the data to be grouped by logical domain. |
PARTITION_DT_TM | DATETIME | Y | The date/time the encounter was discharged. |
PLAN_INITIATED_IND | DOUBLE | Y | Identifies if patient has a restraint prevention plan of care was initiated |
RESTRAINT_IND | DOUBLE | Y | Identify if the patient has the restraint in the unit. |
RISK_PRIOR_RESTRAINT_IND | DOUBLE | Y | Identifies patients that are at risk- had an restrained document- and were at risk prior to the restraint |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_SOURCE | VARCHAR(50) | N | The script name responsible for updating the record. |
UPDT_TASK | VARCHAR(50) | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - LH_F_REST_HST_METRICS
Child Column in LH_F_REST_HST_METRICS(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_F_REST_METRICS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_F_REST_METRICS |
Definition: | Fact table for Restraint Management Lighthouse Reporting |
Table Type: | ACTIVITY |
Column Detail - LH_F_REST_METRICS
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
ADMIT_DT_TM | DATETIME | Y | The date/time on which the patient was admitted. |
ADMIT_UTC_DT_TM | DATETIME | Y | The date/time on which the patient was admitted; normalized to GMT. |
ARRIVAL_DT_TM | DATETIME | Y | The date/time on which the patient arrived at the facility. |
ARRIVAL_UTC_DT_TM | DATETIME | Y | The date/time on which the patient arrived at the facility normalized to GMT. |
AT_RISK_IND | DOUBLE | Y | Identifies if the patient is at risk. |
COMM_MRN_TXT | VARCHAR(50) | Y | Identifies the community medical record number of the patient. |
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 during the visit. |
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. Foreign key to the CODE_VALUE table. |
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 | Identifies the person associated with the quality measure. Foreign key to the PERSON table. |
D_PRIN_DIAGNOSIS_ID | DOUBLE | N | Identifies the principle diagnosis associated with the encounter. |
D_PRIN_PROCEDURE_ID | DOUBLE | N | Identifies the principle procedure associated with the encounter. |
EDUCATION_IND | DOUBLE | Y | Identifies patients that has restraint at risk education documented. |
ED_ENCNTR_ID | DOUBLE | Y | Identifies if the current or previous encounter was admitted to the ED. In order to qualify- the previous encounter should have been discharged within 30 minutes. |
ED_RESTRAINT_IND | DOUBLE | Y | Identifies patients who were restrained on admission to ED |
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 the record was first loaded into the table. |
F_REST_METRICS_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_F_REST_METRICS 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. |
LOGICAL_DOMAIN_ID | DOUBLE | N | The unique identifier for the logical domain. This identifier allows the data to be grouped by logical domain. |
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 |
PLAN_INITIATED_IND | DOUBLE | Y | Identifies patients if the PowerPlan has been initiated or the order set has been ordered. |
POPULATION_IND | DOUBLE | Y | Identifies patients that qualify for the ventilated population for the Lighthouse metric. |
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 |
RESTRAINT_IND | DOUBLE | Y | Identifies patients who are restrained |
RISK_DT_TM | DATETIME | Y | Identifies when the first at risk document for restraint for patients |
RISK_PRIOR_RESTRAINT_IND | DOUBLE | Y | Identifies patients that are at risk- had an restrained document- and were at risk prior to the restraint |
RISK_UTC_DT_TM | DATETIME | Y | Identifies when the first at risk document for restraint for patients; normalized to GMT |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_SOURCE | VARCHAR(50) | N | The script name responsible for updating the record. |
UPDT_TASK | VARCHAR(50) | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - LH_F_REST_METRICS
Child Column in LH_F_REST_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_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_PRIN_DIAGNOSIS_ID | LH_D_DIAGNOSIS | D_DIAGNOSIS_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_DIAGNOSIS | 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 | |
D_PRIN_PROCEDURE_ID | LH_D_PROCEDURE | D_PROCEDURE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_PROCEDURE | HEALTH_SYSTEM_SOURCE_ID |
LH_F_RRT_METRICS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_F_RRT_METRICS |
Definition: | Fact table for Rapid Response Team Lighthouse Report. |
Table Type: | ACTIVITY |
Column Detail - LH_F_RRT_METRICS
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
ADMIT_DT_TM | DATETIME | Y | The date/time on which the patient was admitted. |
ADMIT_UTC_DT_TM | DATETIME | Y | The date/time on which the patient was admitted; normalized to GMT. |
ARRIVAL_DT_TM | DATETIME | Y | The date/time on which the patient arrived at the facility. |
ARRIVAL_UTC_DT_TM | DATETIME | Y | The date/time on which the patient arrived at the facility; normalized to GMT. |
CODE_BLUE_CNT | DOUBLE | Y | Number of RRT-related code blues during the visit |
COMM_MRN_TXT | VARCHAR(50) | Y | Identifies the community medical record number of the patient. |
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_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. Foreign key to the CODE_VALUE table. |
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 | The unique identifier for the quality measure. |
D_METRIC_11_ID | DOUBLE | N | The unique identifier for the quality measure. |
D_METRIC_12_ID | DOUBLE | N | The unique identifier for the quality measure. |
D_METRIC_13_ID | DOUBLE | N | The unique identifier for the quality measure. |
D_METRIC_14_ID | DOUBLE | N | The unique identifier for the quality measure. |
D_METRIC_15_ID | DOUBLE | N | The unique identifier for the quality measure. |
D_METRIC_16_ID | DOUBLE | N | The unique identifier for the quality measure. |
D_METRIC_17_ID | DOUBLE | N | The unique identifier for the quality measure. |
D_METRIC_18_ID | DOUBLE | N | The unique identifier for the quality measure. |
D_METRIC_19_ID | DOUBLE | N | The unique identifier for the quality measure. |
D_METRIC_1_ID | DOUBLE | N | The unique identifier for the quality measure. |
D_METRIC_20_ID | DOUBLE | N | The unique identifier for the quality measure. |
D_METRIC_2_ID | DOUBLE | N | The unique identifier for the quality measure. |
D_METRIC_3_ID | DOUBLE | N | The unique identifier for the quality measure. |
D_METRIC_4_ID | DOUBLE | N | The unique identifier for the quality measure. |
D_METRIC_5_ID | DOUBLE | N | The unique identifier for the quality measure. |
D_METRIC_6_ID | DOUBLE | N | The unique identifier for the quality measure. |
D_METRIC_7_ID | DOUBLE | N | The unique identifier for the quality measure. |
D_METRIC_8_ID | DOUBLE | N | The unique identifier for the quality measure. |
D_METRIC_9_ID | DOUBLE | N | The unique identifier for the quality measure. |
D_PERSON_ID | DOUBLE | N | The person that qualified for the quality metric. |
D_PRIN_DIAGNOSIS_ID | DOUBLE | N | Identifies the principle diagnosis associated with the encounter. |
D_PRIN_PROCEDURE_ID | DOUBLE | N | Identifies the principle procedure associated with the encounter. |
ENCNTR_ID | DOUBLE | N | Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table. |
EXPIRED_IND | DOUBLE | Y | Identifies if the patient expired during the visit. |
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. |
F_RRT_METRICS_ID | DOUBLE | N | Unique identifier for the lighthouse rapid response team metrics |
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. |
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. |
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 |
POPULATION_IND | DOUBLE | Y | Identifies patients that qualify for the base population for the Lighthouse metric. |
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. |
RRT_ACT_CNT | DOUBLE | Y | Number of RRT activations during the visit |
RRT_ACT_REASON_MASK | DOUBLE | Y | Identifies the reason for RRT activation 1 = Activation w/out reason 2 = Systolic blood pressure 4 = Heart rate range 8 = Respiratory evaluation 16 = Neurological evaluation 32 = Blood glucose evaluation 64 = Staff concern |
RRT_ACT_TO_BEDSIDE_CNT | DOUBLE | Y | The number of RRT activations where arrival at bedside is documented. |
RRT_ACT_TO_BEDSIDE_MIN | DOUBLE | Y | The number of minutes from RRT activation to arrival at bedside. |
RRT_ACT_TO_DEPART_CNT | DOUBLE | Y | The number of RRT activations where departure from bedside is documented. |
RRT_ACT_TO_DEPART_MIN | DOUBLE | Y | The total duration of the RRT event. |
RRT_ACT_TO_ICU_CNT | DOUBLE | Y | The number of RRT activations where the patient was transferred to the ICU. |
RRT_ACT_TO_ICU_DAYS | DOUBLE | Y | The total number of days in the ICU after an RRT transfer. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_SOURCE | VARCHAR(50) | N | The script name responsible for updating the record. |
UPDT_TASK | VARCHAR(50) | N | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
Relationship Detail - LH_F_RRT_METRICS
Child Column in LH_F_RRT_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_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_PRIN_DIAGNOSIS_ID | LH_D_DIAGNOSIS | D_DIAGNOSIS_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_DIAGNOSIS | 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 | |
D_PRIN_PROCEDURE_ID | LH_D_PROCEDURE | D_PROCEDURE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_PROCEDURE | HEALTH_SYSTEM_SOURCE_ID |
LH_F_SCIP_METRICS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_F_SCIP_METRICS |
Definition: | This table is used to store metrics for the Lighthouse Surgical Care Improvement quality measure. |
Table Type: | ACTIVITY |
Column Detail - LH_F_SCIP_METRICS
Column Name | Type | Null? | Definition |
---|---|---|---|
ABX_EXTEND_REASON_MASK | DOUBLE | Y | Identifies the reasons to extend antibiotics |
ABX_RECD_MASK | DOUBLE | Y | Identifies when the patient received antibiotics. |
AB_24H_ANES_EXCL_IND | DOUBLE | Y | Identified all antibiotic does administrated date/time are more than 24 hours after anesthesia end date. |
AB_ADMIN_IND | DOUBLE | Y | Identified patient has antibiotic dose(s) administered |
AB_ALLERGY_FLAG | DOUBLE | Y | Identifies patients that have allergies, sensitivities or intolerance to beta-lactam/penicillin antibiotic or cephalosporin medications |
AB_ANES_EXCL_IND | DOUBLE | Y | Identifiedall antibiotic does administrated date are not in propertiy days range after anesthesia end date. |
AB_DISC_24H_IND | DOUBLE | Y | Identifies if the patient had antibiotics discontinued within 24 hours of the end of surgery. |
AB_DISC_MORE_24H_IND | DOUBLE | Y | Identifies patients that had any antibiotics discontinue more than 24 hours of surgery end. |
AB_NAME_3_11_EXCL_IND | DOUBLE | Y | Identified patient has antibiotic name on table 3.11 |
AB_RECD_24H_ADM_EXCL_IND | DOUBLE | Y | Identifies patients excluded from the SCIP metric. |
AB_RECD_24H_SURG_EXCL_IND | DOUBLE | Y | Identifies patients excluded from the SCIP metric. |
AB_RECD_WIN_1H_IND | DOUBLE | Y | Identifies if the patient received an antibiotic within 1 hour of surgical incision. |
AB_ROUTE_IM_EXCL_IND | DOUBLE | Y | Identified patient all of Antibiotic Administration Route are IM (Intramuscular) or other not oral/IV. |
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. |
ACTIVE_WARMING_IND | DOUBLE | Y | Identifies patients that had active warming performed intraoperatively. |
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. |
AGE_EXCL_IND | DOUBLE | Y | Identifies patients excluded from the SCIP metric. |
ANES_END_DT_TM | DATETIME | Y | The anesthesia end date/time for the principle procedure. |
ANES_END_UTC_DT_TM | DATETIME | Y | The anesthesia end date/time for the principle procedure. |
ANES_START_DT_TM | DATETIME | Y | The anesthesia start date/time for the principle procedure. |
ANES_START_UTC_DT_TM | DATETIME | Y | The anesthesia start date/time for the principle procedure. |
ANES_TYPE_EXCL_IND | DOUBLE | Y | Identifies patients excluded from the SCIP metric. |
ANES_TYPE_FLAG | DOUBLE | Y | Identifies the type of anesthesia received. |
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. |
BASE_POPULATION_IND | DOUBLE | Y | Identifies the patients that qualify for the SCIP base population. |
BETA_BLK_PERIOP_FLAG | DOUBLE | Y | Identifies patients that received a beta blocker perioperatively. |
BETA_BLK_PERIOP_MASK | DOUBLE | Y | Identifies patients that received beta blocker perioperatively. |
BETA_BLK_PREG_FLAG | DOUBLE | Y | Identifies female patients that are on a beta blocker during pregnancy. |
BETA_BLK_PRIOR_FLAG | DOUBLE | Y | Identifies patients that were on a beta blocker prior to arrival. |
BETA_PERIOP_INCL_IND | DOUBLE | Y | Identifies patients that received a beta blocker perioperatively. |
BETA_PREG_EXCL_IND | DOUBLE | Y | Identifies patients excluded from the SCIP metric. |
BETA_PRIOR_ADMIT_INCL_IND | DOUBLE | Y | Identifies patients that were on a beta blocker prior to arrival. |
BURN_DX_EXCL_IND | DOUBLE | Y | Identifies patients excluded from the SCIP metric. |
CARD_2_REJECT_IND | DOUBLE | Y | Identifies if the patient record was rejected from the SCIP metric due to missing data. |
CARD_PROC_IND | DOUBLE | Y | Identifies patients that had cardiac procedures performed. |
CLIN_TRIAL_EXCL_FLAG | DOUBLE | Y | Identifies if the patient is excluded from the measure due to participation in a clinical trial. |
CLIN_TRIAL_EXCL_IND | DOUBLE | Y | Identifies patients excluded from the SCIP metric. |
COLON_PROC_ORAL_ABX_FLAG | DOUBLE | Y | Identifies color surgery patients that received oral antibiotics |
COMM_MRN_TXT | VARCHAR(50) | Y | Identifies the community medical record number of the patient. |
CONTROLLED_GLUCOSE_FLAG | DOUBLE | Y | Identifies patients with a controlled post-operative blood glucose level. |
CONTROLLED_GLUCOSE_IND | DOUBLE | Y | Identifies patients with controlled glucose levels. |
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_CARD_2_METRIC_ID | DOUBLE | N | The unique identifier for the SCIP metric. |
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. Foreign key to the CODE_VALUE table. |
D_INF_10_METRIC_ID | DOUBLE | N | The unique identifier for the SCIP metric. |
D_INF_1_METRIC_ID | DOUBLE | N | The unique identifier for the SCIP metric. |
D_INF_2_METRIC_ID | DOUBLE | N | The unique identifier for the SCIP metric. |
D_INF_3_METRIC_ID | DOUBLE | N | The unique identifier for the SCIP metric. |
D_INF_4_METRIC_ID | DOUBLE | N | The unique identifier for the SCIP metric. |
D_INF_6_METRIC_ID | DOUBLE | N | The unique identifier for the SCIP metric. |
D_INF_9_METRIC_ID | DOUBLE | N | The unique identifier for the SCIP metric. |
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_PERSON_ID | DOUBLE | N | The person that qualified for the quality metric. |
D_PRIN_DIAGNOSIS_ID | DOUBLE | N | Identifies the principle diagnosis associated with the encounter. |
D_PRIN_PROCEDURE_ID | DOUBLE | N | Identifies the principle procedure associated with the encounter. |
D_PROC_GROUP_ID | DOUBLE | N | Identifies the surgical procedure group associated with the principle procedure. |
D_VTE_1_METRIC_ID | DOUBLE | N | The unique identifier for the SCIP metric. |
D_VTE_2_METRIC_ID | DOUBLE | N | The unique identifier for the SCIP metric. |
ENCNTR_ID | DOUBLE | N | Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table. |
EXCLUDE_CARD_2_IND | DOUBLE | Y | Identifies if the patient is excluded from the measure. |
EXCLUDE_INF_10_IND | DOUBLE | Y | Identifies if the patient is excluded from the measure. |
EXCLUDE_INF_1_IND | DOUBLE | Y | Identifies if the patient is excluded from the measure. |
EXCLUDE_INF_2_IND | DOUBLE | Y | Identifies if the patient is excluded from the measure. |
EXCLUDE_INF_3_IND | DOUBLE | Y | Identifies if the patient is excluded from the measure. |
EXCLUDE_INF_4_IND | DOUBLE | Y | Identifies if the patient is excluded from the measure. |
EXCLUDE_INF_6_IND | DOUBLE | Y | Identifies if the patient is excluded from the measure. |
EXCLUDE_INF_9_IND | DOUBLE | Y | Identifies if the patient is excluded from the measure. |
EXCLUDE_VTE_1_IND | DOUBLE | Y | Identifies if the patient is excluded from the measure. |
EXCLUDE_VTE_2_IND | DOUBLE | Y | Identifies if the patient is excluded from the measure. |
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. |
F_SCIP_METRICS_ID | DOUBLE | N | Unique identifier for the lighthouse PN Metrics |
HAIR_REMOVAL_MASK | DOUBLE | Y | Identifies the preoperative hair removal method. |
HAIR_REMOVE_APPROP_IND | DOUBLE | Y | Identifies patients that had hair removed via an appropriate method. |
HAIR_REMOVE_PT_EXCL_IND | DOUBLE | Y | Identifies patients excluded from the SCIP metric. |
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. |
HIP_FRAC_DX_IND | DOUBLE | Y | Identifies Hip Fracture diagnosis patients. |
HYST_WITH_CSECT_EXCL_IND | DOUBLE | Y | Identifies patients excluded from the SCIP metric. |
INF_10_REJECT_IND | DOUBLE | Y | Identifies if the patient record was rejected from the SCIP metric due to missing data. |
INF_1_REJECT_IND | DOUBLE | Y | Identifies if the patient record was rejected from the SCIP metric due to missing data. |
INF_2_REJECT_IND | DOUBLE | Y | Identifies if the patient record was rejected from the SCIP metric due to missing data. |
INF_3_REJECT_IND | DOUBLE | Y | Identifies if the patient record was rejected from the SCIP metric due to missing data. |
INF_4_REJECT_IND | DOUBLE | Y | Identifies if the patient record was rejected from the SCIP metric due to missing data. |
INF_6_REJECT_IND | DOUBLE | Y | Identifies if the patient record was rejected from the SCIP metric due to missing data. |
INF_9_REJECT_IND | DOUBLE | Y | Identifies if the patient record was rejected from the SCIP metric due to missing data. |
INF_DISEASE_DX_EXCL_IND | DOUBLE | Y | Identifies patients excluded from the SCIP metric. |
INF_PRIOR_ANES_EXCEPT_FLAG | DOUBLE | Y | Identifies if a patient has infection exceptions prior to anesthesia documented |
INF_PRIOR_ANES_EXCL_FLAG | DOUBLE | Y | Identifies patients that had an infection prior to anesthesia |
INF_PRIOR_ANES_EXCL_IND | DOUBLE | Y | Identifies patients excluded from the SCIP metric. |
INTENT_HYPOTHERM_EXCL_FLAG | DOUBLE | Y | Identifies patients that had intentional hypothermia documented. |
INTENT_HYPOTHERM_EXCL_IND | DOUBLE | Y | Identifies patients excluded from the SCIP metric. |
JOINT_REVISION_EXCL_IND | DOUBLE | Y | Identifies patients excluded from the SCIP metric. |
LAPAROSCOPE_EXCL_FLAG | DOUBLE | Y | Identifies patients that had the procedure performed entirely by laparoscope. |
LAPAROSCOPE_EXCL_IND | DOUBLE | Y | Identifies patients excluded from the SCIP metric. |
LAST_PROCESS_DT_TM | DATETIME | Y | The date/time the record was last loaded into the 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. |
LOS_EXCL_IND | DOUBLE | Y | Identifies patients excluded from the SCIP metric. |
LVAD_PROC_IND | DOUBLE | Y | Identifies patients with Ventricular Assist Devices or Heart Transplantation procedure |
NHIQM_VERSION | DOUBLE | Y | Identifies the version of NHIQM for which the row qualifies. |
NO_AB_RECD_EXCL_IND | DOUBLE | Y | Identifies patients excluded from the SCIP metric. |
NO_BETA_BLK_REASON_FLAG | DOUBLE | Y | Identifies patients with a valid reason documented for not receiving a beta blocker perioperatively. |
NO_BETA_BLK_REASON_MASK | DOUBLE | Y | Identifies patients with valid reason documented for not receiving a beta blocker perioperatively. |
NO_BETA_REASON_EXCL_IND | DOUBLE | Y | Identifies patients excluded from the SCIP metric. |
NO_PROPH_AB_RECD_EXCL_IND | DOUBLE | Y | Identifies patients excluded from the SCIP metric. |
NO_PROPH_RECD_EXCL_IND | DOUBLE | Y | Identifies patients excluded from the SCIP metric. |
NO_VTE_MECH_EXCL_IND | DOUBLE | Y | Identifies patients excluded from the SCIP metric. |
NO_VTE_PHARM_EXCL_IND | DOUBLE | Y | Identifies patients excluded from the SCIP metric. |
NO_VTE_PROPH_REASON_MASK | DOUBLE | Y | Identifies the reasons documented for not administering VTE prophylaxis. |
NO_VTE_PROPH_RECD_FLAG | DOUBLE | Y | Identifies patients that did not receive VTE prophylaxis. |
NUMERATOR_CARD_2_IND | DOUBLE | Y | Identifies if the patient qualifies for the measure. |
NUMERATOR_INF_10_IND | DOUBLE | Y | Identifies if the patient qualifies for the measure. |
NUMERATOR_INF_1_IND | DOUBLE | Y | Identifies if the patient qualifies for the measure. |
NUMERATOR_INF_2_IND | DOUBLE | Y | Identifies if the patient qualifies for the measure. |
NUMERATOR_INF_3_IND | DOUBLE | Y | Identifies if the patient qualifies for the measure. |
NUMERATOR_INF_4_IND | DOUBLE | Y | Identifies if the patient qualifies for the measure. |
NUMERATOR_INF_6_IND | DOUBLE | Y | Identifies if the patient qualifies for the measure. |
NUMERATOR_INF_9_IND | DOUBLE | Y | Identifies if the patient qualifies for the measure. |
NUMERATOR_VTE_1_IND | DOUBLE | Y | Identifies if the patient qualifies for the measure. |
NUMERATOR_VTE_2_IND | DOUBLE | Y | Identifies if the patient qualifies for the measure. |
ORG_MRN_TXT | VARCHAR(50) | Y | Identifies the medical record number of the patient. |
OTHER_SURG_PROC_EXCL_FLAG | DOUBLE | Y | Identifies patients that had other surgical procedures performed within days of the current procedure. |
OTHER_SURG_PROC_EXCL_IND | DOUBLE | Y | Identifies patients excluded from the SCIP metric. |
PARTITION_DT_TM | DATETIME | Y | The date/time the encounter was discharged from the facility |
PERIOP_DEATH_EXCL_FLAG | DOUBLE | Y | Identifies patients that suffered a perioperative death. |
PERIOP_DEATH_EXCL_IND | DOUBLE | Y | Identifies patients excluded from the SCIP metric. |
POSTOP_CATH_EXCL_IND | DOUBLE | Y | Identifies patients excluded from the SCIP metric. |
POSTOP_CATH_INCL_IND | DOUBLE | Y | Identifies patients that received an indwelling catheter post-op. |
POST_OP_INF_EXCL_IND | DOUBLE | Y | Identifies patients excluded from the SCIP metric. |
PREOP_CATH_EXCL_IND | DOUBLE | Y | Identifies patients excluded from the SCIP metric. |
PRE_WARFARIN_EXCL_IND | DOUBLE | Y | Identifies patients excluded from the SCIP metric. |
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. |
PROC_GROUP_MEANING | VARCHAR(50) | Y | Identifies the Cerner-defined meaning associated with the procedure group. |
PROPH_AB_SELECTED_IND | DOUBLE | Y | Identifies if the patient had a prophylactic antibiotic selected. |
SURG_INCISION_DT_TM | DATETIME | Y | Identifies if the date/time that the incision for the principal procedure was made |
SURG_INCISION_UTC_DT_TM | DATETIME | Y | Identifies if the date/time that the incision for the principal procedure was made |
TEMP_CONTROL_MASK | DOUBLE | Y | Identifies how the temperature was controlled during surgery. |
TRANSPLANT_DX_EXCL_IND | DOUBLE | Y | Identifies patients excluded from the SCIP metric. |
UC_CONTINUE_REASON_FLAG | DOUBLE | Y | Identifies the reasons for continuing the urinary catheter |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_SOURCE | VARCHAR(50) | N | The script name responsible for updating the record. |
UPDT_TASK | VARCHAR(50) | N | The registered (assigned) task number for the process that inserted or updated the row. |
URINARY_ANTI_EXCL_IND | DOUBLE | Y | Identifies patients excluded from the SCIP metric. |
URINARY_CATHETER_FLAG | DOUBLE | Y | Identifies when the urinary catheter was placed. |
URO_GYN_PROC_EXCL_IND | DOUBLE | Y | Identifies patients excluded from the SCIP metric. |
UR_CATH_NO_RMV_EXCL_IND | DOUBLE | Y | Identifies patients excluded from the SCIP metric. |
UR_CATH_RMV_DT_TM | DATETIME | Y | The date abd time the urinary catheter was removed. |
UR_CATH_RMV_UTC_DT_TM | DATETIME | Y | The date abd time the urinary catheter was removed.normalized to GMT. |
VANCOMYCIN_MASK | DOUBLE | Y | Identifies the VTE prophylaxis selected. |
VTE_1_REJECT_IND | DOUBLE | Y | Identifies if the patient record was rejected from the SCIP metric due to missing data. |
VTE_2_REJECT_IND | DOUBLE | Y | Identifies if the patient record was rejected from the SCIP metric due to missing data. |
VTE_PROC | VARCHAR(50) | Y | Identifies patients with procedures specific to the VTE metrics. |
VTE_PROC_IND | DOUBLE | Y | Identifies if the patient had a principle procedure specific to the VTE metric. |
VTE_PROPHYLAXIS_MASK | DOUBLE | Y | Identifies the VTE prophylaxis selected. |
VTE_PROPH_IND | DOUBLE | Y | Identifies patients that had VTE prophylaxis ordered and documented. |
VTE_PROPH_RECD_IND | DOUBLE | Y | Identifies patients that received VTE prophylaxis. |
VTE_TIMELY_MASK | DOUBLE | Y | Identifies VTE prophylaxis selected with timely document |
WARFARIN_PRIOR_ADMIT_FLAG | DOUBLE | Y | Identifies patients that were on warfarin prior to admission. |
Relationship Detail - LH_F_SCIP_METRICS
Child Column in LH_F_SCIP_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_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_PRIN_DIAGNOSIS_ID | LH_D_DIAGNOSIS | D_DIAGNOSIS_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_DIAGNOSIS | 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_PROC_GROUP_ID | LH_D_GROUP | D_GROUP_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_GROUP | 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_CARD_2_METRIC_ID | LH_D_METRIC | D_METRIC_ID | |
D_INF_10_METRIC_ID | LH_D_METRIC | D_METRIC_ID | |
D_INF_1_METRIC_ID | LH_D_METRIC | D_METRIC_ID | |
D_INF_2_METRIC_ID | LH_D_METRIC | D_METRIC_ID | |
D_INF_3_METRIC_ID | LH_D_METRIC | D_METRIC_ID | |
D_INF_4_METRIC_ID | LH_D_METRIC | D_METRIC_ID | |
D_INF_6_METRIC_ID | LH_D_METRIC | D_METRIC_ID | |
D_INF_9_METRIC_ID | LH_D_METRIC | D_METRIC_ID | |
D_VTE_1_METRIC_ID | LH_D_METRIC | D_METRIC_ID | |
D_VTE_2_METRIC_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 | |
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 | |
D_PRIN_PROCEDURE_ID | LH_D_PROCEDURE | D_PROCEDURE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_PROCEDURE | HEALTH_SYSTEM_SOURCE_ID |
LH_F_SEPSIS_CCPS_METRICS
Column Section | Top of Page |
Table-level Detail
Description: | LH_F_SEPSIS_CCPS_METRICS |
Definition: | This table is used to store Sepsis_CCPS . This table is at the Alert Grain. |
Table Type: | ACTIVITY |
Column Detail - LH_F_SEPSIS_CCPS_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. |
BILLING_DX | VARCHAR(200) | Y | The Name of the Billing Diagnosis. |
BILLING_DX_CODE | VARCHAR(20) | Y | The Code of the Billing Diagnosis. |
CE_EVENT_END_DT_TM | DATETIME | Y | The Date/Time of the Clinical Event. |
CE_EVENT_END_UTC_DT_TM | DATETIME | Y | The Date/Time of the Clinical Event Normalized to GMT. |
CE_EVENT_ID | DOUBLE | N | The Clinical Event ID of the Alert. |
CE_EVENT_TYPE | VARCHAR(150) | Y | the Event Type of the Clinical Event. |
CE_RESULT_COMMENT | VARCHAR(4000) | Y | The Resulu_Comment of the Alert Containing the Vital Signs that contribute to the Alert. |
COMM_MRN_TXT | VARCHAR(50) | Y | Identifies the community medical record number of the patient. |
DISCHARGE_DT_TM | DATETIME | Y | The date/time on which the patient was discharged. |
DISCHARGE_DX | VARCHAR(200) | Y | The Name of the Discharge Diagnosis. |
DISCHARGE_DX_CODE | VARCHAR(20) | Y | The Code of the Discharge Diagnosis. |
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_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 | Identifies the discharge disposition of the encounter |
D_ENCNTR_TYPE_ID | DOUBLE | N | Categorizes the encounter into a logical group or type. |
D_FINANCIAL_CLASS_ID | DOUBLE | N | Identifies the financial class of the encounter during registration |
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_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. |
EXTRACT_DT_TM | DATETIME | Y | The date/time that the record was extracted from the source system. |
FINAL_DX | VARCHAR(200) | Y | The Name of the Final Diagnosis. |
FINAL_DX_CODE | VARCHAR(20) | Y | The Code of the Final Diagnosis. |
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_F_SEPSIS_CCPS_METRICS_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_F_SEPSIS_CCPS_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. |
MED_SERVICE | VARCHAR(50) | Y | The Medical Service at the Time of the Alert |
NURSE_UNIT | VARCHAR(50) | Y | The Nurse Unit at the Time of the Alert |
ORG_MRN_TXT | VARCHAR(50) | Y | Identifies the medical record number of the patient. |
POPULATION_IND | DOUBLE | Y | Identifies if the encounter is qualified initial population for Sepsis CCPS Audit Report |
SEPSIS_BAND_MANUAL | DOUBLE | N | Value of the Band Manual Vital Sign |
SEPSIS_BAND_MANUAL_UNIT | VARCHAR(20) | Y | The Unit of the Band Manual Vital Sign |
SEPSIS_BILI | DOUBLE | N | Value of the Bilirubin Vital Sign |
SEPSIS_BILI_UNIT | VARCHAR(20) | Y | The Unit of the Bilirubin Vital Sign |
SEPSIS_BODY_TEMP | DOUBLE | N | Value of the Body Temperature Vital Sign |
SEPSIS_BODY_TEMP_UNIT | VARCHAR(20) | Y | The Unit of the Body Temperature Vital Sign |
SEPSIS_CORE_TEMP | DOUBLE | N | Value of the Core Temperature Vital Sign |
SEPSIS_CORE_TEMP_UNIT | VARCHAR(20) | Y | The Unit of the Core Temperature Vital Sign |
SEPSIS_CREATININE | DOUBLE | N | Value of the Creatinine Vital Sign |
SEPSIS_CREATININE_UNIT | VARCHAR(20) | Y | The Unit of the Creatinine Vital Sign |
SEPSIS_GLUCOSE | DOUBLE | N | Value of the Gulcose Vital Sign |
SEPSIS_GLUCOSE_UNIT | VARCHAR(20) | Y | The Unit of the Gulcose Vital Sign |
SEPSIS_HR | DOUBLE | N | Value of the Heart Rate Vital Sign |
SEPSIS_HR_UNIT | VARCHAR(20) | Y | The Unit of the Heart Rate Vital Sign |
SEPSIS_LACTIC_ACID | DOUBLE | N | Value of the Lactic Acid Vital Sign |
SEPSIS_LACTIC_ACID_UNIT | VARCHAR(20) | Y | The Unit of the Lactic Acid Vital Sign |
SEPSIS_MAP | DOUBLE | N | Value of the Mean Aerital Pressure Vital Sign |
SEPSIS_MAP_UNIT | VARCHAR(20) | Y | The Unit of the Mean Aerital Pressure Vital Sign |
SEPSIS_PERIPH_PR | DOUBLE | N | Value of the Peripheral Pulse Rate Vital Sign |
SEPSIS_PERIPH_PR_UNIT | VARCHAR(20) | Y | The Unit of the Peripheral Pulse Rate Vital Sign |
SEPSIS_PERIPH_TEMP | DOUBLE | N | Value of the Peripheral Temperature Vital Sign |
SEPSIS_PERIPH_TEMP_UNIT | VARCHAR(20) | Y | The Unit of the Peripheral Temperature Vital Sign |
SEPSIS_RR | DOUBLE | N | Value of the Respiratory Rate Vital Sign |
SEPSIS_RR_UNIT | VARCHAR(20) | Y | The Unit of the Respiratory Rate Vital Sign |
SEPSIS_SBP | DOUBLE | N | Value of the Systolic Blood Pressure Vital Sign |
SEPSIS_SBP_UNIT | VARCHAR(20) | Y | The Unit of the Systolic Blood Pressure Vital Sign |
SEPSIS_TEMP | DOUBLE | N | Value of the Temperature Vital Sign |
SEPSIS_TEMP_UNIT | VARCHAR(20) | Y | The Unit of the Temperature Vital Sign |
SEPSIS_WBC | DOUBLE | N | Value of the WBC Vital Sign |
SEPSIS_WBC_UNIT | VARCHAR(20) | Y | The Unit of the WBC Vital Sign |
SEVERE_DX | VARCHAR(255) | Y | The Name of the Most Severe Diagnosis. |
SEVERE_DX_CODE | VARCHAR(50) | Y | The Code of the Most Severe Diagnosis. |
SEVERE_DX_TYPE | VARCHAR(40) | Y | The Type of the Most Severe Diagnosis. |
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. |