ACCEPT_OUTCOME_IND |
DOUBLE |
Y |
Identifies plan of care outcome event indicative of Acceptable Pain Intensity |
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. |
ADVERSE_INTERVENTION_IND |
DOUBLE |
Y |
indicates intervention(s) performed due to opioid adverse effects |
AGE_CRITERIA_FLAG |
DOUBLE |
Y |
Age categorized as 1 -Adult, 2-Pediatric, 3-Neonate, 4-Preterm Neonate |
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. |
ASMT24H_ARRIVAL_CNT |
DOUBLE |
Y |
Number of pain assessments documented within 24 hours of patient admission |
ASMT_BTWN_EPISODE_IND |
DOUBLE |
Y |
Identifies if pain present assessments are documented within recommended time interval of pain episode |
BEHAVIOR_REDUCED_IND |
DOUBLE |
Y |
Identifies plan of care outcome event indicative of Pain Associated Behaviors Reduced |
CAREGIVER_MED_IND |
DOUBLE |
Y |
Identifies plan of care outcome indicative of Caregiver Verbalizes Accurate Medication Admin Routine |
COMM_MRN_TXT |
VARCHAR(50) |
Y |
Identifies the community medical record number of the patient. |
COMP24H_ASMT_CNT |
DOUBLE |
Y |
Number of comprehensive pain assessments documented by same personnel within 24 hours of patient admission for those who are able to self report pain |
COMP_ASMT_DAYS_CNT |
DOUBLE |
Y |
Number of days all comprehensive pain assessments are documented by same personnel for full calendar days when pain is present |
DAILY_ASMT_IND |
DOUBLE |
Y |
Identifies if patient was given recommended frequency of pain assessments for full calendar days |
DAILY_PAIN_ASMT_NUM |
DOUBLE |
Y |
The recommended frequency of pain assessment for full calendar day based on age of patient |
DEF_COMP_FILTERS_CNT |
DOUBLE |
Y |
Number of distinct bedrock filters defined for comprehensive pain assessment |
DENOMINATOR_10_IND |
DOUBLE |
Y |
Identifies if the encounter is in the Denominator for metric of patients with actual or suspected pain on opioid therapy who developed an adverse effect |
DENOMINATOR_11_IND |
DOUBLE |
Y |
Identifies if the encounter is in the Denominator for metric of patients with actual or suspected pain on opioid therapy who developed an adverse effect requiring intervention |
DENOMINATOR_12_IND |
DOUBLE |
Y |
Identifies if the encounter is in the Denominator for metric of patients with actual or suspected pain who were on a pain management plan within X hours of pain-present |
DENOMINATOR_13_IND |
DOUBLE |
Y |
Identifies if the encounter is in the Denominator for metric of patients with actual or suspected pain who received pharmacologic and non-pharmacologic therapy per hospital protocol |
DENOMINATOR_14_IND |
DOUBLE |
Y |
Identifies if the encounter is in the Denominator for metric of patients on pain plan of care who received pain management education |
DENOMINATOR_15_IND |
DOUBLE |
Y |
Identifies if the encounter is in the Denominator for metric of patients on pain plan of care who received pain medication education |
DENOMINATOR_16_IND |
DOUBLE |
Y |
Identifies if the encounter is in the Denominator for metric of patients on pain plan of care who self-report pain with acceptable pain intensity |
DENOMINATOR_17_IND |
DOUBLE |
Y |
Identifies if the encounter is in the Denominator for metric of patients on pain plan of care who were unable to self report pain with reduction in pain associated behaviors |
DENOMINATOR_18_IND |
DOUBLE |
Y |
Identifies if the encounter is in the Denominator for metric of patients on pain plan of care who were unable to self report pain whose caregiver understood discharge medication administration routine |
DENOMINATOR_1_IND |
DOUBLE |
Y |
Identifies if the encounter is in the Denominator for metric of patients with actual or suspected pain |
DENOMINATOR_2_IND |
DOUBLE |
Y |
Identifies if the encounter is in the Denominator for metric of patients who received a pain assessment X times per day |
DENOMINATOR_3_IND |
DOUBLE |
Y |
Identifies if the encounter is in the Denominator for metric of patients with actual or suspected pain who received a daily comprehensive pain assessment |
DENOMINATOR_4_IND |
DOUBLE |
Y |
Identifies if the encounter is in the Denominator for metric of patients with actual or suspected pain who were reassessed for pain per hospital protocol |
DENOMINATOR_5_IND |
DOUBLE |
Y |
Identifies if the encounter is in the Denominator for metric of non-pharmacological interventions where pain was reassessed per hospital protocol |
DENOMINATOR_6_IND |
DOUBLE |
Y |
Identifies if the encounter is in the Denominator for metric of opioid administrations where pain was reassessed per hospital protocol |
DENOMINATOR_7_IND |
DOUBLE |
Y |
Identifies if the encounter is in the Denominator for metric of opioid administrations where pain was reassessed per hospital protocol and had effective pharmacological response |
DENOMINATOR_8_IND |
DOUBLE |
Y |
Identifies if the encounter is in the Denominator for metric of patients on opioid therapy identified at high risk of opioid induced respiratory depression prior to over sedation |
DENOMINATOR_9_IND |
DOUBLE |
Y |
Identifies if the encounter is in the Denominator for metric of patients on opioid therapy identified at high risk of opioid induced respiratory depression who had a sedation and respiratory assessment every 1 hour for the first 12 hours and every 2 hours for the second 12 hours |
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 |
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_CLASS_FILTER |
VARCHAR(20) |
Y |
Identifies if the patient is classified within the category of 'INPATIENT', 'OBSERVATION' and 'EMERGENCY' |
ENCNTR_ID |
DOUBLE |
N |
Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table. |
END_CAL_DT_TM |
DATETIME |
Y |
the date/time of End of the full calendar day (day before discharge or current date) |
EXCLUDE_10_IND |
DOUBLE |
Y |
Identifies if the encounter is in the Exclude for metric of patients with actual or suspected pain on opioid therapy who developed an adverse effect |
EXCLUDE_11_IND |
DOUBLE |
Y |
Identifies if the encounter is in the Exclude for metric of patients with actual or suspected pain on opioid therapy who developed an adverse effect requiring intervention |
EXCLUDE_12_IND |
DOUBLE |
Y |
Identifies if the encounter is in the Exclude for metric of patients with actual or suspected pain who were on a pain management plan within X hours of pain-present |
EXCLUDE_13_IND |
DOUBLE |
Y |
Identifies if the encounter is in the Exclude for metric of patients with actual or suspected pain who received pharmacologic and non-pharmacologic therapy per hospital protocol |
EXCLUDE_14_IND |
DOUBLE |
Y |
Identifies if the encounter is in the Exclude for metric of patients on pain plan of care who received pain management education |
EXCLUDE_15_IND |
DOUBLE |
Y |
Identifies if the encounter is in the Exclude for metric of patients on pain plan of care who received pain medication education |
EXCLUDE_16_IND |
DOUBLE |
Y |
Identifies if the encounter is in the Exclude for metric of patients on pain plan of care who self-report pain with acceptable pain intensity |
EXCLUDE_17_IND |
DOUBLE |
Y |
Identifies if the encounter is in the Exclude for metric of patients on pain plan of care who were unable to self report pain with reduction in pain associated behaviors |
EXCLUDE_18_IND |
DOUBLE |
Y |
Identifies if the encounter is in the Denominator for metric of patients on pain plan of care who were unable to self report pain whose caregiver understood discharge medication administration routine |
EXCLUDE_3_IND |
DOUBLE |
Y |
Identifies if the encounter is in the Exclude for metric of patients with actual or suspected pain who received a daily comprehensive pain assessment |
EXCLUDE_4_IND |
DOUBLE |
Y |
Identifies if the encounter is in the Exclude for metric of patients with actual or suspected pain who were reassessed for pain per hospital protocol |
EXCLUDE_5_IND |
DOUBLE |
Y |
Identifies if the encounter is in the Exclude for metric of non-pharmacological interventions where pain was reassessed per hospital protocol |
EXCLUDE_6_IND |
DOUBLE |
Y |
Identifies if the encounter is in the Exclude for metric of opioid administrations where pain was reassessed per hospital protocol |
EXCLUDE_7_IND |
DOUBLE |
Y |
Identifies if the encounter is in the Exclude for metric of opioid administrations where pain was reassessed per hospital protocol and had effective pharmacological response |
EXCLUDE_8_IND |
DOUBLE |
Y |
Identifies if the encounter is in the Exclude for metric of patients on opioid therapy identified at high risk of opioid induced respiratory depression prior to over sedation |
EXCLUDE_9_IND |
DOUBLE |
Y |
Identifies if the encounter is in the Exclude for metric of patients on opioid therapy identified at high risk of opioid induced respiratory depression who had a sedation and respiratory assessment every 1 hour for the first 12 hours and every 2 hours for the second 12 hours |
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. |
FULL_CAL_DAYS |
DOUBLE |
Y |
Number of full calendar Days (greater than 2 days) patient stayed in hospital (excluding admit, discharge or current date) |
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. |
IPOC_INITIATED_DT_TM |
DATETIME |
Y |
The date/time pain plan of care was initiated for patient |
IPOC_INITIATED_UTC_DT_TM |
DATETIME |
Y |
The date/time pain plan of care was initiated for patient normalized to GMT |
LAST_PROCESS_DT_TM |
DATETIME |
Y |
The date/time that the last ETL process started that updated this record. |
LAST_SELF_RPT_DT_TM |
DATETIME |
Y |
the date/time last able to self report pain response documented for patient |
LAST_SELF_RPT_UTC_DT_TM |
DATETIME |
Y |
the date/time last able to self report pain response documented for patient normalized to GMT |
LAST_UNABLE_RPT_DT_TM |
DATETIME |
Y |
the date/time last unable to self report pain response documented for patient |
LAST_UNABLE_RPT_UTC_DT_TM |
DATETIME |
Y |
the date/time last unable to self report pain response documented for patient normalized to GMT |
LH_F_ACUTE_PAIN_METRICS_ID |
DOUBLE |
N |
Unique generated number that identifies a single row on the LH_F_ACUTE_PAIN_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_EFFECTIVE_IND |
DOUBLE |
Y |
Identifies if any medication effective response is documented |
MED_EFFECT_IM_FLAG |
DOUBLE |
Y |
Identifies if medication effective response is documented after opioid medication is administered via intramuscular route. 1-any response 2-yes response |
MED_EFFECT_IV_FLAG |
DOUBLE |
Y |
Identifies if medication effective response is documented after opioid medication is administered via intraveinal route. 1-response is 'NO', 2-response is 'YES' |
MED_EFFECT_PO_FLAG |
DOUBLE |
Y |
Identifies if medication effective response is documented after opioid medication is administered via oral route. 1-any response 2-yes response |
MED_EFFECT_RESPONSE_IND |
DOUBLE |
Y |
Identifies if documented medication effective response was yes |
NON_PHARM_COMFORT_CNT |
DOUBLE |
Y |
Number of times non pharmacological therapy and comfort measures were documented |
NON_PHARM_COMFORT_IND |
DOUBLE |
Y |
identifies if non pharmacological therapy or comfort measures are documented |
NUMERATOR_10_IND |
DOUBLE |
Y |
Identifies if the encounter is in the Numerator for metric of patients with actual or suspected pain on opioid therapy who developed an adverse effect |
NUMERATOR_11_IND |
DOUBLE |
Y |
Identifies if the encounter is in the Numerator for metric of patients with actual or suspected pain on opioid therapy who developed an adverse effect requiring intervention |
NUMERATOR_12_IND |
DOUBLE |
Y |
Identifies if the encounter is in the Numerator for metric of patients with actual or suspected pain who were on a pain management plan within X hours of pain-present |
NUMERATOR_13_IND |
DOUBLE |
Y |
Identifies if the encounter is in the Numerator for metric of patients with actual or suspected pain who received pharmacologic and non-pharmacologic therapy per hospital protocol |
NUMERATOR_14_IND |
DOUBLE |
Y |
Identifies if the encounter is in the Numerator for metric of patients on pain plan of care who received pain management education |
NUMERATOR_15_IND |
DOUBLE |
Y |
Identifies if the encounter is in the Numerator for metric of patients on pain plan of care who received pain medication education |
NUMERATOR_16_IND |
DOUBLE |
Y |
Identifies if the encounter is in the Numerator for metric of patients on pain plan of care who self-report pain with acceptable pain intensity |
NUMERATOR_17_IND |
DOUBLE |
Y |
Identifies if the encounter is in the Numerator for metric of patients on pain plan of care who were unable to self report pain with reduction in pain associated behaviors |
NUMERATOR_18_IND |
DOUBLE |
Y |
Identifies if the encounter is in the Numerator for metric of patients on pain plan of care who were unable to self report pain whose caregiver understood discharge medication administration routine |
NUMERATOR_1_IND |
DOUBLE |
Y |
Identifies if the encounter is in the Numerator for metric of patients with actual or suspected pain |
NUMERATOR_2_IND |
DOUBLE |
Y |
Identifies if the encounter is in the Numerator for metric of patients who received a pain assessment X times per day |
NUMERATOR_3_IND |
DOUBLE |
Y |
Identifies if the encounter is in the Numerator for metric of patients with actual or suspected pain who received a daily comprehensive pain assessment |
NUMERATOR_4_IND |
DOUBLE |
Y |
Identifies if the encounter is in the Numerator for metric of patients with actual or suspected pain who were reassessed for pain per hospital protocol |
NUMERATOR_5_IND |
DOUBLE |
Y |
Identifies if the encounter is in the Numerator for metric of non-pharmacological interventions where pain was reassessed per hospital protocol |
NUMERATOR_6_IND |
DOUBLE |
Y |
Identifies if the encounter is in the Numerator for metric of opioid administrations where pain was reassessed per hospital protocol |
NUMERATOR_7_IND |
DOUBLE |
Y |
Identifies if the encounter is in the Numerator for metric of opioid administrations where pain was reassessed per hospital protocol and had effective pharmacological response |
NUMERATOR_8_IND |
DOUBLE |
Y |
Identifies if the encounter is in the Numerator for metric of patients on opioid therapy identified at high risk of opioid induced respiratory depression prior to over sedation |
NUMERATOR_9_IND |
DOUBLE |
Y |
Identifies if the encounter is in the Numerator for metric of patients on opioid therapy identified at high risk of opioid induced respiratory depression who had a sedation and respiratory assessment every 1 hour for the first 12 hours and every 2 hours for the second 12 hours |
OPIOID_ADMIN_DT_TM |
DATETIME |
Y |
The date/time of initial opioid administration to a patient |
OPIOID_ADMIN_UTC_DT_TM |
DATETIME |
Y |
The date/time of initial opioid administration to a patient normalized to GMT |
OPIOID_ADVERSE_IND |
DOUBLE |
Y |
Identifies if patient developed adverse effects post opioid administration |
OPIOID_IM_ROUTE_IND |
DOUBLE |
Y |
Identifies intramuscular route of opioid medication administration to a patient |
OPIOID_IV_ROUTE_IND |
DOUBLE |
Y |
Identifies Intraveinal route of opioid medication administration to a patient |
OPIOID_PO_ROUTE_IND |
DOUBLE |
Y |
Identifies oral route of opioid medication administration to a patient |
OPIOID_RESP_RISK_CNT |
DOUBLE |
Y |
Number of times the event identifying risk for opioid induced respiratory depression occurred before opioid medication administration |
ORG_MRN_TXT |
VARCHAR(50) |
Y |
Identifies the medical record number of the patient. |
OVERSEDATION_CNT |
DOUBLE |
Y |
Identifies the number of times the patient was over-sedated during the visit. |
OVER_SED_DT_TM |
DATETIME |
Y |
The date/time of initial event which indicates over sedation for patient on opioid therapy |
OVER_SED_UTC_DT_TM |
DATETIME |
Y |
The date/time of initial event which indicates over sedation for patient on opioid therapy normalized to GMT |
PAIN_ASMT_INTERVAL |
DOUBLE |
Y |
Time interval in hours that is recommended for a pain to be reassessed for patient per pain episode |
PAIN_DAYS_CNT |
DOUBLE |
Y |
Number of days Pain present assessments documented daily for full calendar days |
PAIN_EPISODE_CNT |
DOUBLE |
Y |
Number of pain episodes in an ecounter.Pain episode is the time interval between pain is present date/time and pain not present date/time |
PAIN_MED_EDU_IND |
DOUBLE |
Y |
Indicates if the patient, family, or caregiver received pain medication education |
PAIN_MGMT_EDU_IND |
DOUBLE |
Y |
Indicates if the patient, family, or caregiver received pain management education |
PAIN_MGMT_ORDER_DT_TM |
DATETIME |
Y |
The date/time pain management order was documented for patient |
PAIN_MGMT_ORDER_UTC_DT_TM |
DATETIME |
Y |
The date/time pain management order was documented normalized to GMT |
PAIN_NOT_PRESENT_IND |
DOUBLE |
Y |
Identifies if the patient has no actual or suspected pain. |
PAIN_PRESENT_DT_TM |
DATETIME |
Y |
The initial date/time on which the patient had actual or suspected pain. |
PAIN_PRESENT_IND |
DOUBLE |
Y |
Identifies if the patient has actual or suspected pain. |
PAIN_PRESENT_UTC_DT_TM |
DATETIME |
Y |
The initial date/time on which the patient had actual or suspected pain normalized to GMT |
PAIN_PRIOR_NON_PHARM_IND |
DOUBLE |
Y |
Pain present assessment documented prior to non pharmacological therapy or comfort measures |
PAIN_PRIOR_OPIOID_IM_IND |
DOUBLE |
Y |
Pain present assessment documented prior to intramuscular route of opioid administration |
PAIN_PRIOR_OPIOID_IV_IND |
DOUBLE |
Y |
Pain present assessment documented prior to Intraveinal route of opioid administration |
PAIN_PRIOR_OPIOID_PO_IND |
DOUBLE |
Y |
Pain present assessment documented prior to oral route of opioid administration |
PHARM_THERAPY_CNT |
DOUBLE |
Y |
Number of times pharmacological therapy were documented |
PHARM_THERAPY_IND |
DOUBLE |
Y |
identifies if pharmacological therapy is documented |
PHARM_WTH_NON_PHARM_IND |
DOUBLE |
Y |
Identifies if non pharmacological therapy or comfort measures are documented within a recommended timeframe after each pharmacological therapy |
POPULATION_IND |
DOUBLE |
Y |
Identifies if the encounter is qualified initial population for Acute Pain Management |
POSTMENSTRUAL_AGE |
VARCHAR(255) |
Y |
The postmenstrual age of preterm neonate patient |
POWER_PLAN_TMFRM |
DOUBLE |
Y |
Timeframe in minutes recommended for pain management plan to be initiated once pain present is documented |
REASMT_NON_PHARM_IND |
DOUBLE |
Y |
Pain reassessed within recommended timeframe after non pharmacological therapy or comfort measures are given to patient |
REASMT_NON_PHARM_TMFRM |
DOUBLE |
Y |
Timeframe in minutes recommended for pain reassessment after non pharmacological therapy or comfort measures are given to patient |
RESP_RISK_DT_TM |
DATETIME |
Y |
The date/time of initial event which identifies patient is at high risk of opioid induced respiratory depression |
RESP_RISK_UTC_DT_TM |
DATETIME |
Y |
The date/time of initial event which identifies patient is at high risk of opioid induced respiratory depression normalized to GMT |
SEDATION_DAYS_CNT |
DOUBLE |
Y |
Identifies the number of sedation days during the visit. |
SED_RESP_ASMT12H_CNT |
DOUBLE |
Y |
Number of times recommended sedation and respiratory assessments were documented every 1 hour for the first 12hours after opioid administration |
SED_RESP_ASMT24H_CNT |
DOUBLE |
Y |
Number of times recommended sedation and respiratory assessments were documented every 2 hour from 12th to 24th hour after opioid administration |
START_CAL_DT_TM |
DATETIME |
Y |
the date/time of Start of the full calendar day (day after admission date) |
UNABLE_RPT_PAIN24H_IND |
DOUBLE |
Y |
Pain documented within 24 hours of patient admission for those who are unable to self report |
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) |
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. |