Record Viewer is an Epic Tool that lets you see pretty much anything in the database… if you know where/how to look. Here are some tips for figuring out how to find stuff.
Users don’t have access to Record Viewer by default. You need to request access. Usually a simple IS Service Desk ticket is enough.
An “INI” is the equivalent to a database table. Often, the hardest part of using Record Viewer is knowing which INI to look in. Below is a table with some INIs I’ve used in Record Viewer.
Every Record in Epic has a “Contact” which is basically the version of the item. Sometimes that version history is easy to understand, and you’d only ever really want the latest (like see below for the Contacts of my Employee record). For a patient (EPT), the Contacts (aka versions of their record) are all of their appointments - the way to think of this is that the chart is a series of photocopies of their medical record as of each appointment. So some of the data in the EPT is their demographic data, but some of it is the appointment data and both are really intermingled within the EPT record.
An Item (within an INI) is equivalent to a column within a database table. (Except that a database field always has one value, and an item can be an array or the like.)
The Clarity data dictionary (https://datahandbook.epic.com/ClarityDictionary ) lets you search for Clarity tables containing a specific INI/item. Like, I saw in Record Viewer that empoyee email address is in EMP item 150, so I can search for that in Data Dictionary and see that CLARITY_EMP_DEMO has a column
EMAILcorresponding to EMP 150. Obviously you can also use this the opposite direction - if you’re looking at a table in Clarity Data Dictionary that column tells which you INI/item to look at in Record Viewer if you want to see it live.
Category | INI (and official epic name) | Description | Example |
|---|---|---|---|
EPT (Generic Patient Database) | (search with any MRN. See note above about Contacts) | ||
EMP (Employee Master) | KOPINSKY, MICHAEL Y [KOPINSKM] | ||
Flowsheet | FSH (Flowsheet Database) | This is what a provider selects in Review Flowsheets to see a set of fields | UPHS AMB WTH BLOOD PRESSURE [347] This flowsheet 347 contains 3 fields:  |
FLT | This is one of the IDs we send in the AddFlowsheetValue webservice | T UPHS AMB WTH BP [21000111] This also has 3 components:  | |
FLO (Flowsheet Groups/Rows) | This is one of the IDs we send in the AddFlowsheetValue webservice |
| |
Embed | FDI (Desktop Integration) | embed | WAY TO HEALTH LINK [100018] |
E0E (External Clients) | App listed in App Orchard | Penn - CHF WayToHealth [100009] | |
E2N (Activity) | button within a menu | UPHS_WAY_TO_HEALTH_LINK [3040000104] | |
Smart Data Elements | HLX (Clinical Concepts Lexicon) | Smart Data Element (SDE) |
|
HLV (Clinical Concepts Value) | SDE Value | To look up a patient’s SDE value:
 The first value in item 50 is the length (which for the SDEs we write to, is always 1). The 2nd is the actual value. | |
Inbasket | HIS (Message Type Definitions) | Inbasket message type | UPHS COVID-19 WATCH [304999902] STAFF MESSAGE [4] |
HIP (Message Pool) | Inbasket pool | HUP ED SMS FAILED TEXT RESULTS [1600080046] | |
LQL | order question | ||
HL7 Results | EAP (Procedure Master) | procedure | WAY TO HEALTH - WEIGHT MONITOR MESSAGING [PROC7437] Used for HL7 inbound results for EMPOWER study |
LRR (Components) | WAY TO HEALTH:MESSAGE [36842] Used for HL7 inbound results for EMPOWER study | ||
LLB (Resulting Agencies) | WAYTOHEALTH [238] |
