PAT_VB_CARE_GAP_ACTION
Description:
This table contains data about actions taken by providers on care gap alerts for a patient.

Primary Key
Column Name Ordinal Position
PAT_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 PAT_ID VARCHAR No
The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
2 LINE INTEGER No
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 CM_PHY_OWNER_ID VARCHAR No
The Community ID (CID) of the instance that owns this record or line. This is only populated if you use IntraConnect.
4 VB_HM_CARE_GAP_TYPE_C_NAME VARCHAR No
This item stores the care gap type for the value-based care gap that was acted on.
May contain organization-specific values: No
Category Entries:
Lipid Panel
Hemogram
ALT Measurement
Creatinine Measurement
Thyroid Stimulating Hormone (TSH) Measurement
Hemoglobin A1C Measurement
Lead Screening
Urine Protein Screening
HIV Screening
Hepatitis C Screening
Chlamydia Screening
Osteoporosis Screening
Breast MRI
Eye Exam
Abdominal Aortic Aneurysm (AAA) Screening
Diabetic Foot Exam
Lung Cancer Screening
Mammography
Cervical Cancer Screening
Colorectal Cancer Screening
Prostate Specific Antigen (PSA) Screening
COVID-19 Immunization
Diphtheria, Tetanus, and Pertussis Immunization
Cholera Immunization
Hepatitis A Immunization
Hepatitis B Immunization
Hib Immunization
HPV Immunization
Influenza Immunization
Japanese Encephalitis Immunization
Meningococcal ACWY Immunization
Meningococcal B Immunization
Measles, Mumps, and Rubella Immunization
Pneumococcal Immunization
Polio Immunization
Rabies Immunization
Typhoid Immunization
Yellow Fever Immunization
Zoster Immunization
Varicella Immunization
Rotavirus Immunization
Wellness Visit
BMI Screening
Nutrition Counseling
Exercise Counseling
Antipsychotic Adherence
Rheumatoid Arthritis Treatment
Nephropathy Screening
Statin Therapy
Statin Adherence
Advance Care Planning
Functional Status Assessment
Medication Review
Pain Assessment
Blood Glucose Screening
Ebola Immunization
Blood Pressure Screening
Diabetes All Class Adherence
Beta-Blocker Adherence
Antiretroviral Adherence
RAS Antagonist Adherence
Depression Screening
Calcium Channel Blocker Adherence
Direct-Acting Oral Anticoagulants Adherence
COPD Medication Adherence
Rheumatoid Arthritis Medication Adherence
Multiple Sclerosis Medication Adherence
Composite Medication Adherence
Hepatitis C Completion of Therapy
Basal Insulin Persistence
Orthopoxvirus Immunization
RSV Immunization
Dengue Fever Immunization
5 VB_CARE_GAP_ACTION_C_NAME VARCHAR No
This item stores the action taken on a value-based care gap.
May contain organization-specific values: No
Category Entries:
Progress Made
Already Done
Does Not Apply
Patient Refused
Deferred
Activated
6 VB_CARE_GAP_ACTION_INST_DTTM DATETIME (UTC) No
This item stores the instant that a user acted on a value-based care gap.
7 VB_CARE_GAP_END_INST_DTTM DATETIME (UTC) No
This item stores the instant a value-based care gap action expires.
8 VB_CARE_GAP_USER_ID VARCHAR No
This item stores the user who acted on the value-based care gap.
9 VB_CARE_GAP_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
10 VB_CARE_GAP_ALERT_CSN_ID NUMERIC No
This item stores the ALT CSN associated with the value-based care gap action.