Research Information Analyst Data Request

Research Information Analyst Data Request

Study Name & Number: SAMPLE 2017.244.C

Variables, Criteria and Diagnostic Codes

Demographics / Choices / Display in Table?
Patient Name / Y
Patient MRN
Masked Patient_ID / Note: If you are sharing this information with an external organization you may want to request the “Masked Patient _ID
Age / 50 - 75 years / Y
DOB / Y
Gender/Sex / female / Y
Race / Y
Ethnicity / Y
Phone Number / Preferred # if noted For invitation to participate in research / Y
MYC Status / MyChart/MyOchsner activation status, For invitation to participate in research / Y
Enrollment Status / Consented, Identified, Declined, Withdrawn, or Screen Fail for Epic study ID 2017.244.C) / Y
Appointment Date and Time / Include next scheduled face-to-face appointment date and time in the selected departments / Y
Inclusionary Criterion / Choices / Display
BMI / Last (most recent) BMI between 30 – 45 kg/m2 / Y
BMI Date / Date of most recent BMI measurement / Y
Encounter Department / NOMC INTERNAL MEDICINE
LAPC FAMILY / INTERNAL MEDICINE
Note: Some primary care clinics have both internal and family medicine departments. Be sure to include both if needed. / Y
Provider / Note: List providers’ names as they appear in Epic.(e.g. HRA Lapalco 3, Dr. Lynn Watts) / Y
Contact Date / At least two face to face encounters in the department in the last 12 months / N
Exclusionary Criterion / Diagnostic Codes
Resource:http://www.who.int/classifications/icd/icdonlineversions/en/ / Display
Limit the diagnosis search to codes linked to outpatientencounters for billing
Patient Status / Living / N
Medications
(Current=order date last 6 months) / Qsymia = phentermine + topiramate, Adipex-P or Suprenza = phentermine only / Y
choices: yes/no; most recent order date
Major depression
(Current = encounter diagnosis in last 6 months) / ICD-9: - Depressive Disorder / 311 / For condition criteria please use the most recent diagnosis date, if nothing leave blank.
e.g. 10-OCT-13 (311)
ICD-10: -
Major Depressive Disorder, Single Episode, Unspecified / F329
Stroke or heart attack
(Current = encounter dx in last 12 months) / ICD-9:
Ischemic Heart Disease
Cerebrovascular Disease / 410 – 414
430 - 438
ICD-10:
Ischemic Heart Diseases
Cerebrovascular Diseases / I20 – I25
I60 – I69

Here is an example of the variable list produced by the research information analyst’s SQL query from the above sample request. During the request you should review your data and request any refinements as needed. If you go on to use this query to request best practice advisory alerts or a report workbench in Epic then the IS team members can share the SQL (code) to be efficient.

DEPARTMENT_NAME

PATIENT_MRN

PATIENT_ID

PATIENT_NAME

BMI

BMI_DATE

AGE

DATE_OF_BIRTH

GENDER

RACE

ETHNICITY

PT_HOME_PHONE

PT_WORK_PHONE

MYC_STATUS

PROVIDER_NAME

APPT_DATE_TIME

APPT_STATUS

APPT_TYPE

STUDY_CODE ENROLLMENT_STATUS

PHENTERM_TOPIRAM_RX

PHENTERM_TOPIRAM_ORD_DTE_STS

PHENTERM_TOPIRAM_I9DX PHENTERMINE_RX

PHENTERMINE_ORD_DTE_STS

PHENTERMINE_I9DX

I9_MAJOR_DEPRESSION

I10_MAJOR_DEPRESSION

I9_STROKE_HEARTATTACK

I10_STROKE_HEARTATTACK

Insert information like the request date, Ticket#, your email address