Practice Questions

Question 1

A SQL report currently displays the name of the admitting provider for a hospital stay, and you have been asked to change it to instead display the name of the discharging provider for that stay. Which of the following best describes how you should modify your report?
A. Change a table in the FROM clause
B. Change a column in the SELECT clause
C. Change a foreign key in the FROM clause
D. Change a condition in the WHERE clause

Answer 1

C. If we want to see who was the discharge provider for the encounter we’d use the DischargingProviderDurableKey column in HospitalAdmissionFact in Caboodle, or DISCHARGE_PROV_ID in PAT_ENC_HSP in Clarity. There’s no need to change the SELECT clause because we still want to see the name of the provider, but just a different provider!

Question 2

Which of the following best describes the relationship between the “Admission Date” and “Inpatient Admission Date”
A. Every encounter that has an Admission date must also have an Inpatient Admission date.
B. They will always be different for a given encounter.
C. They will always be the same for a given encounter.
D. For some encounters they will be the same and for other encounters they differ.

Answer 2

D. They would be the same for a direct admission to the hospital but otherwise they could be different. For example, encounters like Hospital Outpatient Visits and ED visits will have an admission date/time but are not guaranteed to have an inpatient admission date/time. Also, ED visits that result in inpatient admissions would have different values for Admission vs. Inpatient Admission.

Question 3

Which of the following best describes the master files used to document episodes?
A. There is one HSB record per episode and one HBD record per episode type
B. There is one HSB record per episode and its type is captured in a category list.
C. There is one HBD record per episode and its type is captured in a category list.
D. There is one HBD record per episode and one HSB record per episode type

Answer 3

A. An HSB record is created whenever a patient’s episode is created. Organizations can customize what sort of episode types are in their system as well as automatic association. Every episode type
configured in your system is an HBD record.

Question 4

Which of the following account for the difference between encounter diagnoses and hospital problems?
A. Associated with patient record vs. patient contact
B. Inpatient encounter vs. outpatient encounter
C. ICD‐10 code vs. flexible terminology
D. One per encounter vs. many per encounter

Answer 4

B. Encounter diagnoses and hospital problems both use formal terminology and are both contact level, but are used in different settings. Encounter Diagnoses are best used in the Outpatient/ED settings, while Hospital Problems are best for inpatient admissions.

Question 5

You are writing a report in Caboodle on patients with diabetes. Working with your application team, you have decided to use the grouper EDG ICD‐10 JCCM DIABETES [1139905]. Which of the
following might appear in your FROM clause?
A. ON DiagnosisBridge.DiagnosisKey = DiagnosisSetDim.DiagnosisKey
B. ON DiagnosisBridge.DiagnosisKey = DiagnosisSetDim.DiagnosisSetKey
C. ON DiagnosisBridge.DiagnosisKey = DiagnosisSetDim.ValueSetEpicId
D. ON DiagnosisBridge.DiagnosisKey = DiagnosisSetDim.Type

Answer 5

A. In Caboodle, all joins should be done on a ‐Key column, and to join to DiagnosisSetDim you should always using DiagnosisKey. This allows you to check if the diagnoses you are working with
are in the grouper you want to use.

Question 6

You are writing a report on outpatient encounters and want to include the primary diagnosis for each encounter. Which of the following code segments would be correct to include in your query?
(Circle all that apply.)
A. PAT_ENC_DX.PRIMARY_DX_YN = ‘Y’
B. PAT_ENC_HOSP_PROB.PRINCIPAL_PROB_YN = ‘Y’
C. VisitFact.PrimaryDiagnosisKey = DiagnosisDim.DiagnosisKey
D. HospitalAdmissionFact.PrincipalProblemKey = DiagnosisDim.DiagnosisKey

Answer 6

A and C. The important aspect of this prompt is “outpatient encounters”. In Clarity, all encounter diagnoses are stored in PAT_ENC_DX, so you are required to filter that to just the one marked as primary. In Caboodle, you have direct foreign key options, but VisitFact is the one that has outpatient

Question 7

Which of the following best describes the information stored in the Clarity column MedicationOrderFact.Class?
A. The chemical family of the medication that has been ordered, e.g. “penicillins” or “phenothiazines”
B. How this medication order is to be routed through the Epic system, e.g. “normal” or “historical”
C. In what setting this medication should be administered, e.g. “inpatient” or “outpatient”
D. The intended purpose of the medication that has been ordered, e.g. “anti‐infective” or “antipsychotic”

Answer 7

B. How this medication order is to be routed through the Epic system, e.g. “normal” or “historical”

Question 8

Which of the following best describes the relationship between orders and diagnoses?
A. There is no relationship
B. One‐to‐One
C. Many‐to‐Many

Answer 8

C. Many‐to‐Many
Providers can associate more than one diagnosis with an order! Additionally, they can associate the same diagnosis with multiple orders. This is captured using the AssociatedDiagnosisComboKey column in Caboodle in both order tables, and ORDER_DX_PROC/ORDER_DX_MED in Clarity (they’re each one row per diagnosis associated).

Question 9

Which of the following values in the ORD_VALUE column would result in 9999999 in the ORD_NUM_VALUE column in the table ORDER_RESULTS
A. 65 mg
B. Positive
C. 6.9
D. NULL

Answer 9

A. 65 mg
B. Positive
A value of 9999999 in the column ORDER_NUM_VALUE means the table ORDER_RESULTS could not cast the value in the column ORD_VALUE as a numeric. So in the values listed above ‘Positive’ cannot be made into a number and ‘65 mg’ cannot be made into a number because of the additional ‘mg’ characters

Question 10

Which of the following could create a new record in the HLV master file?
A. An analyst builds a new SmartData Element by defining its metadata.
B. An analyst adds a SmartData Element to a SmartForm using the SmartForm Designer.
C. A physician enters a value into a SmartData Element.
D. A physician types up a note following their visit with a patient.

Answer 10

C. A physician enters a value into a SmartData Element.
The HLV master file captures the values entered into SmartData Elements, also one HLV can hold more than one value. Options A and B are related to the HLX master file, the actual build of the
SmartData Elements (static). Option D is captured in notes, HNO records

Question 11

You want to report on flowsheet values entered into the rows ‘Heart Rate [8]’ and ‘Respiratory Rate [9]’ using Caboodle. Which of the following should appear in your query to only return values entered into those flowsheet rows?
A. FlowsheetRowDim.FlowsheetRowEpicId IN (‘8’, ‘9’)
B. FlowsheetValueFact.FlowsheetValueKey IN (8, 9)
C. FlowsheetValueFact.FlowsheetRowKey IN (8, 9)
D. FlowsheetRowDim.RowType IN (‘8’, ‘9’)

Answer 11

A. FlowsheetRowDim.FlowsheetRowEpicId IN (‘8’, ‘9’)

In order to return specific values you need to filter on what row the value was entered in using the FLO record ID. Any column that ends in ‐Key is a surrogate key that does not store the Epic ID, so it should never be used as a filter. RowType can be used to figure out if the FLO record is a group or row, it doesn’t store the ID of the FLO record

Question 12

Which of the following best describes the data stored in a single IEV record?
A. An episode
B. The definition of a type of event
C. A single event
D. A collection of events

Answer 12

D. A collection of events
An IEV record gathers together multiple events, so one IEV record has many events within it. Every event within the IEV record has a corresponding LEV record, which is the event type definition.

Question 13

If a patient qualifies for the diabetes registry for one year, how many corresponding rows will be in the DM_DIABETES table in Clarity?
A. Exactly 1
B. Approximately 12 (one per month)
C. Approximately 52 (one per week)
D. Approximately 365 (one per day)
E. It depends on how often the DM_DIABETES table is extracted

Answer 13

A. Exactly 1
DM_* tables store all the current information for registry members, and they are one row per member. So a diabetic patient has one row in DM_DIABETES that is updated nightly.

Question 14

A patient belongs to the asthma registry for one year. They have 7 of their metrics change throughout the year. How many rows would be added to AsthmaRegistryDataMartX for this patient
after the year?
A. No new rows will be created.
B. 7 rows will be created
C. 12 rows will be created
D. It’s impossible to tell.

Answer 14

B. 7 rows will be created
The RegistryDataMartX tables in Caboodle behave a lot like snapshot! When a metric changes, the member gets a new row in the table recording the date of the change. Therefore, if 7 metrics
change then we get 7 new rows in the table. They still have the “IsMostRecent” column that identifies their current row in the table.

Question 15

In Caboodle, you want to find out who has triggered the most alerts in the last month. Which of the following tables would you need to find all alert interactions in the last month and display the name of who triggered it? ﴾Circle all that apply﴿
A. ProviderDim
B. EmployeeDim
C. BpaFact
D. BpaActionTakenFact

Answer 15

B. EmployeeDim
C. BpaFact

BpaFact is one row per alert trigger/interaction. So you need that table to find all alerts that were triggered in the last month. Then, to see who triggered it, you’d need to join to EmployeeDim using BpaFact.EmployeeDurableKey.

Question 16

Andre goes to the clinic to receive their yearly Flu Vaccine. Which of the following tables would you expect to find a row for Andre’s encounter? Choose all that apply.
A. EncounterFact
B. VisitFact
C. HospitalAdmissionFact
D. EdVisitFact

Answer 16

A. EncounterFact
B. VisitFact
All patient encounters get extracted to EncoutnerFact. VisitFact is all “outpatient face‐to‐face” encounters, and every organization has control over what they consider outpatient face‐to‐face. However,
based on Epic released definitions, you can assume that encounter types like “Office Visit” and “Immunization” would be included in that list.

Question 17

Classify the following providers by whether they are associated with a specific encounter or the
patient as a whole:
A. Visit Provider: ___________________________________
B. Primary Care Provider: ___________________________________
C. Treatment Team: ___________________________________
D. Care Team: ___________________________________
E. Attending Provider: ___________________________________

Answer 17

A. Visit Provider: encounter level (OP)
B. Primary Care Provider: patient level
C. Treatment Team: encounter level (IP)
D. Care Team: patient level
E. Attending Provider: encounter level (IP)

Question 18

Which of the following concepts are captured using LPL records? Choose all the apply.
A. Reasons for Visit
B. Encounter Diagnosis
C. Hospital Problems
D. The Problem List

Answer 18

C. Hospital Problems
D. The Problem List

LPL records are used to track a patient’s diagnosis overtime. The major reporting use cases for that are for chronic or long term conditions (the patient’s problem list) or the diagnoses addressed during an inpatient stay (hospital problems).

Question 19

You need to use the ‘QM‐CANCER [109341]’ Diagnosis grouper in a report. Which of the following conditions should show up in your WHERE clause after joining to GROUPER_COMPILED_REC_LIST?
Choose ONE of the following.
A. GROUPER_COMPILED_REC_LIST.BASE_GROUPER_ID = 109341
B.GROUPER_COMPILED_REC_LIST.GROUPER_RECORDS_VARCHAR_ID = ‘109341’
C.GROUPER_COMPILED_REC_LIST.GROUPER_RECORDS_NUMERIC_ID = 109341
D. GROUPER_COMPILED_REC_LIST.COMPILED_CONTEXT = ‘109341’

Answer 19

A. GROUPER_COMPILED_REC_LIST.BASE_GROUPER_ID = ‘109341’

Tables that extract groupers allow you to evaluate what records belong to a specific grouper. To do so, you’ll filter the table using the record ID of the grouper. In GROUPER_COMPILED_REC_LIST, the column that extracts the ID of the grouper that made the list is BASE_GROUPER_ID.

Question 20

Which order characteristic would allow you to find only medications that should be taken at home (prescriptions)? Choose ONE of the following.
A. Type
B. Class
C. Mode

Answer 20

C. Mode

When orders are placed, mode is a property that indicates the setting the order should be completed in. For medication orders, a mode of “outpatient” indicates it should be taken at home and is
used to report on prescriptions.

Question 21

Which of the following values stored in LabComponentResultFact.Value would be NULL in
LabComponentResultFact.NumericValue? Choose ALL that apply.
A. Positive
B. 24
C. >10
D. 7.84

Answer 21

A. Positive
C. >10
The NumericValue column is derived by attempting to CAST() whatever value is stored in the Value column as a numeric. If the Value cannot be cast as number, then the NumericValue column will store a NULL. Both ‘Positive’ and ‘>10’ cannot be stored in the Numeric data type, so instead there will be a NULL in the column.

Question 22

You discover that a data point you need in a report is captured in a SmartData Element with the context of “order”. Which column in SMRTDTA_ELEM_DATA would you join with ORDER_PROC.ORDER_PROC_ID to use the values captured? Choose ONE of the following.
A. RECORD_ID_VARCHAR
B. RECORD_ID_NUMERIC
C. CONTACT_SERIAL_NUM

Answer 22

B. RECORD_ID_NUMERIC
To connect an order to all HLV records created for it, you would have to join ORDER_PROC to SMRTDTA_ELEM_DATA. Because every order is an ORD record, the column ORDER_PROC_ID extracts the
ORD .1 and is a numeric data type. Therefore, you’d join on ORDER_PROC_ID = RECORD_ID_NUMERIC.

Question 23

You want to find all values entered in the flowsheet row “Seizure Duration” over the past month. Which ID should you use to limit your results to only Seizure Duration values? Choose ONE of the
following.
A. FSD ID
B. FLO ID
C. FLT ID

Answer 23

B. FLO ID
All flowsheet values are stored in FSD records, but to identify specific values like Blood Pressure or Seizure Duration you need to assess what row the value was entered into. Flowsheet rows are FLO
records, and they function as the “Attribute” in the EAV data model.

Question 24

In Caboodle, one alert interaction (ALT contact) could generate multiple rows in the table BpaActionTakenFact. What about an alert would create multiple rows in this table?
A. Alerts can be triggered more than once within a single patient encounter
B. The same alert can fire for more than one patient encounter
C. Alerts can appear to users throughout their clinical workflows
D. Users can take more than one action upon an alert

Answer 24

D. Users can take more than one action upon an alert

BpaActionTakenFact is one row per action taken per alert. So one user could take 3 actions on one alert, and each action would get its own row in the table. BpaFact is one row per encounter, so it would only have 1 row in this scenario.

Question 25

Consider the Clarity table DM_IP_READMISSION. Members of the Inpatient Readmission registry are encounters. A qualifying encounter's data changes on one metric. What happens? A. The table creates a new, additional row for the encounter within 24 hours B. The table creates a new, additional row for the encounter at the end of the month C. The table updates the existing row describing the encounter at the end of the month D. The table updates the existing row describing the encounter within 24 hours

Answer 25

D. The table updates the existing row describing the encounter within 24 hours DM* tables in Clarity are updated nightly, but only store the most current values for each metric

Question 26

Which of the following best describes the HRV master file? A. The HRV master file stores both reasons for visit and chief complaints B. The HRV master file stores chief complaints but not reasons for visit C. The HRV master file stores neither reasons for visit nor chief complaint D. The HRV master file stores for visit but not chief complaints

Answer 26

A. The HRV master file stores both reasons for visit and chief complaints Reason for visit and chief complaint are completely synonymous terms. HRV is the static master file for this concept.

Question 27

Which of the following might you see as a value in the Caboodle column ProcedureOrderFact.Type? Choose all that apply: A. Lab B. Imaging C. Referral D. Medications

Answer 27

A. Lab B. Imaging C. Referral All medications orders have the type medications so it would be impossible for a row in ProcedureOrderFact to have the type medications

Question 28

Which of the following best describes the relationship between administration and actions on the MAR? A. One-to-One B. No Relationship C. Many-to-Many D. One (admin) -to- many (actions)

Answer 28

A. One-to-One Each administration has one documented action. Examples include "Give" or "Canceled"

Question 29

Which of the following Caboodle tables must be included to display the diagnoses documented for a specfic inpatient encounter? Choose all that apply: A. ChiefComplaintDim B. DiagnosisDim C. DiagnoisisEventFact D. CheifComplaintEventFact

Answer 29

B. DiagnosisDim C. DiagnoisisEventFact Inpatient admission means the hospital problems, which use formal diagnoses, so DiagnosisDim will be involved. DiagnosisEventFact will need to connect the inpatient admissions to all Hospital Problems addressed. You also need to filter it using type=hospital problem

Question 30

While a physician writes a note, the value 'yes' is filled for SDI EPIC#PECN0001. This SmartData Element has the context "Note". What changes occur in Caboodle and Clarity? Choose all that apply: A. A new row is created in AttributeDim storing 'yes' B. A new row is created in ClinicalNoteAttributeValueDim storing 'yes' C. A new row is created in SMRTDTA_ELEM_VALUE storing 'yes' D. A new row is created in CLARITY_CONCEPT storing 'yes'

Answer 30

B. A new row is created in CLinicalNoteAttributeValueDim storing 'yes' C. A new row is created in SMRTDTA_ELEM_VALUE storing 'yes' All SmartData Elements that exisit in your system (HLX records) are rows in AttributeDim and CLARITY_CONCEPT. All values entered go to AttributeValueDim depending on their context in Caboodle and SMARTDTA_ELEM_VALUE in Clarity

Question 31

Which of the following best describes how to join provider and user foreign keys in Clarity? A. Foreign keys ending in PROV_ID should be joined to the primary key CLARITY_SER while foreign keys ending in USER_ID should be joined to the primary key of CALRITY_EMP B. Foreign keys ending in USER_ID should be joined to the primary key CLARITY_SER while foreign keys ending in PROV_ID should be joined to the primary key of CALRITY_EMP C. Both foreign keys ending in PROV_ID and foreign keys ending in USER_ID should be joined to the primary key of CLARITY_SER D. You can join foreign keys ending in USER_ID and PROV_ID to the primary key of either CLARITY_SER or CLARITY_EMP, either way it accomplishes the same thing E. Both foreign keys ending in PROV_ID and forign keys ending in USER_ID should be joined to the primary key of CALRITY_EMP

Answer 31

A. Foreign keys ending in PROV_ID should be joined to the primary key CLARITY_SER while foreign keys ending in USER_ID should be joined to the primary key of CALRITY_EMP SER and EMP are distinct master files whose .1 values may not be the same for the same person. In Clarity, PROV_ID is the naming convention for SER keys, while USER_ID is used for the EMP keys

Question 32

Which of the following best describe what a row is in the FlowsheetValueFact? A. A value entered into a flowsheet B. A FSD record C. A Flowsheet group D. The definition of a flowsheet row

Answer 32

A. A value entered into a flowsheet Flowsheet data is stored in the FSD in Chronicles and all of the values entered end up in FlowsheetValueFact. Each row in the table is a filled cell in a flowsheet, aka an individual value.

Question 33

Which of the following associations make sense? Choose all that apply A. An EDG record associated with an EPT record B. An HRV record associated with an EPT record C. An HRV record associated with an EPT contact D. An EDG record associated with an EPT contact

Answer 33

A. An EDG record associated with an EPT record C. An HRV record associated with an EPT contact D. An EDG record associated with an EPT contact

Question 34

You have been asked to write a report that lists patients who have had an office visit in the last year with an encounter diagnosis of Low Back Pain. Display the patient's name, primary mrn, current gen pcp, and the department the encounter occurred in. Which of the following table o you need to satisfy the request? choose all that apply: A. PROBLEM_LIST B. PAT_ENC C. CLARITY_DEP D. PAT_ENC_DX E. PAT_ENC_RSN_VISIT F. PATIENT G. CLARITY_EMP H. CLARITY_SER Your report requester would also like to add the provider that treated the patient during the encounter. Which of the following actions should you take? A. Include another join to CALRITY_SER using the column PROV_ID in HSP_TRTMT_TEAM B. Do nothing, PCP already capture this C. Include a join to CALRITY_EMP using column VISIT_PROV_ID in PAT_ENC D. Include another join to CALRITY_SER using column VISIT_PROV_ID in PAT_ENC

Answer 34

B. PAT_ENC C. CLARITY_DEP D. PAT_ENC_DX F. PATIENT H. CLARITY_SER you need PATIENT to figure out the patient's MRN, name, and who their PCP is. LAstly, CLARITY_SER nad CLARITY_DEP are needed to display the names of the provider and department   D. Include another join to CALRITY_SER using column VISIT_PROV_ID in PAT_ENC

Question 35

Admission Provider: inpatient or outpatient

Answer 35

inpatient

Question 36

All visit providers: inpatient or outpatient

Answer 36

outpatient

Question 37

Attending Provider: Inpatient or outpatient

Answer 37

inpatient

Question 38

Care Team: Inpatient or Outpatient Services

Answer 38

Outpatient

Question 39

Current General PCP: Inpatient or Outpatient

Answer 39

Outpatient

Question 40

Discharge Provider: Inpatient or Outpatient

Answer 40

Inpatient

Question 41

First Visit Provider: Inpatient or Outpatient

Answer 41

Outpatient

Question 42

Provider Identifier: Inpatient or Outpatient

Answer 42

Outpatient

Question 43

Treatment Team: Inpatient or Outpatient

Answer 43

Inpatient

Question 44

Master File for Providers

Answer 44

SER

Question 45

Master File for Users

Answer 45

EMP

Question 46

Master File for Patients

Answer 46

EPT

Question 47

True or False: when someone is discharged from the facility their "most recent department" is their discharged department

Answer 47

True Items like I EPT 18880 represent the "most current" value in Chronicles, but they can only hold the "most current" value as of the most recent extract in Clarity and Caboodle.

Question 48

What table extracts both HSB and HBD data?

Answer 48

EpisodeFact

Question 49

A specific instance of interaction with a patient, stored in the EPT master file in Epic.

Answer 49

Contact

Question 50

A slice in time representing an interaction with a patient, documented as a contact in the EPT master file.

Answer 50

Encounter

Question 51

The classification of an encounter based on the nature of the interaction (e.g., office visit, telephone encounter, hospital admission).

Answer 51

Encounter Type

Question 52

An individual who provides care to patients, represented by a record in the SER master file.

Answer 52

Provider

Question 53

An individual or entity that can log in to the Epic system, represented by a record in the EMP master file.

Answer 53

User

Question 54

A specific area within a healthcare facility where patient care is provided, represented by a record in the DEP master file.

Answer 54

Department

Question 55

A collection of encounters grouped together to address the same persistent condition, stored in the HSB master file.

Answer 55

Episode

Question 56

What is included within the "hospital" encounter type:

Answer 56

1.inpatient stays 2.emergency department visits 3.hospital outpatient visits 4.observations 5.pre-admission workflows.

Question 57

What determines which encounters are included in which encounter tables

Answer 57

Encounters are included in specific tables based on their type and setting (e.g., inpatient admissions in HospitalAdmissionFact, ED visits in EdVisitFact).

Question 58

Difference between various provider associations (PCP vs. Visit Provider vs. Attending Provider)

Answer 58

PCP (Primary Care Provider): Oversees the patient's overall care. Visit Provider: Responsible for the specific encounter. Attending Provider: Primary medic during an ED visit or hospital admission.

Question 59

who/what has a provider record and who/what has a user record

Answer 59

Providers have SER records, while users have EMP records. A single person can have both if they provide care and log in to the system.

Question 60

The difference in "when" reporting between outpatient and inpatient encounters

Answer 60

Outpatient encounters typically occur within a single day, while inpatient encounters span multiple days and involve multiple key events (e.g., admission, discharge).

Question 61

The relationship between episodes and encounters

Answer 61

Episodes group together multiple encounters related to the same condition. Encounters can be automatically or manually attached to episodes.

Question 62

Fact table are generally what? Static or Dynamic

Answer 62

Dynamic

Question 63

Dim tables are generally what? Static or Dynmaic

Answer 63

Static

Question 64

True or False: It is best practice to begin your query with tables extracting from dynamic master files, then join to tables extracting from static master files as needed.

Answer 64

True

Question 65

If you want to know what chief complaints were documented do you use ChiefComplaintBridge or EventFact?

Answer 65

ChiefComplaintBridge

Question 66

If you want to know more specific information about an event, do you use a Bridge table or Fact?

Answer 66

Fact

Question 67

For any table that list DiagnosisEventFact, by implication that table must be filtered on.....

Answer 67

Type = "Hospital Problem" or Type = "Problem List".

Question 68

If you wanted to know the problems for an inpatient encounter, what table would you use? HospitalAdmissionFact ProblemListFact

Answer 68

HospitalAdmissionFact

Question 69

Stored on the encounter (e.g., outpatient visits)

Answer 69

Point-in-Time Diagnoses

Question 70

Stored on the problem list (e.g., chronic conditions)

Answer 70

Persistent Diagnoses

Question 71

The patient's motivation for seeking medical care, often described in informal language (e.g., "my arm hurts"). Stored in the HRV master file.

Answer 71

Reason for Visit

Question 72

The clinician's determination of the patient's condition, described in formal language and often coded (e.g., ICD-10). Stored in the EDG master file.

Answer 72

Diagnosis

Question 73

A list of persistent conditions that a patient has, which spans time and is not limited to a single encounter (e.g., chronic conditions like diabetes). Stored in the LPL master file.

Answer 73

Problem List

Question 74

Problems associated with a specific inpatient admission, which can include conditions present on admission or acquired during the hospital stay. Stored in the LPL master file and linked to the encounter

Answer 74

Hospital Problem

Question 75

Return the Visit Diagnoses for an Encounter

Answer 75

Use the DiagnosisEventFact table in Caboodle or the PAT_ENC_DX table in Clarity, filtering for encounter diagnoses.

Question 76

Return the Chief Complaints for an Encounter

Answer 76

Use the ChiefComplaintEventFact table in Caboodle or the PAT_ENC_RSN_VISIT table in Clarity

Question 77

Return the Hospital Problems for an Admission

Answer 77

Use the DiagnosisEventFact table in Caboodle, filtering for hospital problems, or the PAT_ENC_HOSP_PROB table in Clarity

Question 78

Return the Entries on a Patient's Problem List

Answer 78

Use the ProblemListFact table in Caboodle or the PROBLEM_LIST table in Clarity

Question 79

Identify the Primary Diagnosis for an Encounter

Answer 79

Use the DiagnosisEventFact.IsPrimary column in Caboodle or the PAT_ENC_DX.PRIMARY_DX_YN column in Clarity.

Question 80

Identify the Principal Problem for an Admission

Answer 80

Use the HospitalAdmissionFact.PrincipalProblemKey in Caboodle or the PAT_ENC_HOSP_PROB.PRINCIPAL_PROB_YN column in Clarity.

Question 81

Filter a Patient's Problem List by Status, Noted Date, or Resolved Date

Answer 81

Use the ProblemListFact.Status, ProblemListFact.StartDateKey, and ProblemListFact.EndDateKey columns in Caboodle, or the PROBLEM_LIST.PROBLEM_STATUS_C, PROBLEM_LIST.NOTED_DATE, and PROBLEM_LIST.RESOLVED_DATE columns in Clarity

Question 82

The patient's reason for visit, described informally

Answer 82

Chief Complaint

Question 83

The clinician's diagnosis for a specific encounter, documented formally

Answer 83

Encounter Diagnosis

Question 84

Problems associated with an inpatient admission, including conditions present on admission or acquired during the stay

Answer 84

Hospital Problem

Question 85

A list of persistent conditions that span time and are not limited to a single encounter.

Answer 85

Overall Problem List

Question 86

A record in the __master file represents a __defined in your system.

Answer 86

ERX, Medication

Question 87

A record in the __master file represents a __defined in your system, which could be____. Examples of procedures include___

Answer 87

EAP, Procedure lab work, imaging, supplies, referrals, actual procedures, and charges

Question 88

A record in the __master file represents an__placed in your system, which is a__for either a__or a__.

Answer 88

ORD, order, request, medication, procedure

Question 89

Order___categorizes the thing being requested by the order.

Answer 89

Type

Question 90

Order____is used to determine to where an order is routed after it is placed.

Answer 90

Class

Question 91

Order___is a property of the order used to capture the setting the order should be completed.

Answer 91

Mode For example, a medication intended to be administered during a hospital admission would have a mode of "inpatient", while a medication intended to be taken at home after discharge would have a mode of "outpatient".

Question 92

a request for something to happen in the system now.

Answer 92

normal order

Question 93

a __ order only makes a single request for its specified action to occur. However, that single request is delayed until a later, to-be-determined time.

Answer 93

Future

Question 94

A ____ order is designed to make a request for something to happen in the system multiple times

Answer 94

Standing

Question 95

If you want to report on orders and the encounters in which they were placed A. parent (or normal) orders B. child (or normal) orders C. link parent and child orders

Answer 95

A. parent (or normal) orders

Question 96

if you want to report on orders and both the encounters in which they were placed and the results of the lab tests performed because of them A. parent (or normal) orders B. child (or normal) orders C. link parent and child orders

Answer 96

C. link parent and child orders

Question 97

if you want to report on orders and the results of the lab tests performed because of them A. parent (or normal) orders B. child (or normal) orders C. link parent and child orders

Answer 97

B. child (or normal) orders

Question 98

You placed three orders: one normal, one future, and one standing. How many do you see listed in Order Review? Which orders do you see and not see, and why?

Answer 98

We see the future and standing orders but not the normal order, because normal orders don't produce child orders.

Question 99

a __ may contain information about the patient's progress, about a plan for treatment, or about clinical observations before surgery.

Answer 99

note

Question 100

After the addendum is signed, it becomes a new ___ on the existing note record.

Answer 100

contact

Question 101

True or False: Events are highly customizable

Answer 101

true if there is a timestamp that you need to track that exists outside of standard items, your organization could create an event to capture it.

Question 102

Events "entity": ___

Answer 102

The encounter/patient

Question 103

Events "attribute": ___

Answer 103

Event Type

Question 104

Events "value": ___

Answer 104

The time at which the event happened

Question 105

If a patient or encounter qualifies for more than one registry how many RDT records will they have?

Answer 105

1

Question 106

if Riley is a member of the Asthma registry for one year, how many rows will they have in the table DM_ASTHMA?

Answer 106

One row.

Question 107

How many rows will they have in the table DM_ASTHMA_HX?

Answer 107

12

Question 108

A substance used for medical treatment, especially a medicine or drug.

Answer 108

Medication

Question 109

A medical test or operation.

Answer 109

Procedure

Question 110

A request for a medication or procedure to be performed.

Answer 110

Order

Question 111

Determines where an order is routed after being placed.

Answer 111

Order Class

Question 112

Indicates the setting in which the order should be completed (e.g., inpatient, outpatient).

Answer 112

order Mode

Question 113

Categorizes the thing being requested by the order (e.g., medication, lab test).

Answer 113

order type

Question 114

An order that authorizes the future release of child orders.

Answer 114

parent order

Question 115

An order that performs the action desired by the requestor.

Answer 115

child order

Question 116

A request for something to happen immediately.

Answer 116

normal order

Question 117

A request for a single action to occur at a later time.

Answer 117

future order

Question 118

A request for repeated actions, either on a regular schedule or ad hoc.

Answer 118

standing order

Question 119

A part of a procedure order result, such as a specific test result.

Answer 119

component

Question 120

A record of medication administrations.

Answer 120

MAR (Medication Administration Record)

Question 121

the act of giving a medication to a patient.

Answer 121

administration

Question 122

The specific action taken during medication administration (e.g., Given, Deferred).

Answer 122

action

Question 123

ERX Master File

Answer 123

Medications

Question 124

EAP Master File

Answer 124

Procedures

Question 125

ORD Master File

Answer 125

Orders

Question 126

A record of pertinent information about a patient, written during an encounter.

Answer 126

Note

Question 127

A revision to a signed note, creating a new contact on the original note record.

Answer 127

Addendum

Question 128

Discrete questions used to record patient information in a reportable manner

Answer 128

SmartData Element (SDE)

Question 129

The setting or situation in which an SDE is used (e.g., Patient, Encounter, Order).

Answer 129

Context

Question 130

The unique identifier for an SDE

Answer 130

SmartData Identifier (SDI)

Question 131

The subject or thing being described in the EAV data model (e.g., a patient)

Answer 131

Entity

Question 132

A characteristic or property of the entity in the EAV data model (e.g., temperature, blood pressure).

Answer 132

Attribute

Question 133

The actual data for the attribute in the EAV data model (e.g., 98.6°F, 120/80 mmHg).

Answer 133

value

Question 134

A tool used to document a wide range of patient data over time.

Answer 134

flowsheet

Question 135

Defines the groups and rows that can appear on a Flowsheet.

Answer 135

flowsheet template

Question 136

A collection of rows in a Flowsheet, used to organize patient information.

Answer 136

flowsheet group

Question 137

Documents specific pieces of patient data over time

Answer 137

flowsheet row

Question 138

Independent entities attached to or within a patient, documented in Flowsheets.

Answer 138

LDA (Lines, Drains, Airways)

Question 139

A discrete moment or action within a patient encounter, tracked using the IEV master file.

Answer 139

Event

Question 140

What a record and a contact in the HNO master file represent

Answer 140

A record represents a note, while a contact represents a version or snapshot of the note over time.

Question 141

Why reporting on notes is undesirable

Answer 141

Free text is unstructured, making it difficult to standardize and report on.

Question 142

The impact of context on SmartData Elements:

Answer 142

Context determines how and where SDE data is stored and how it should be joined in reports.

Question 143

Why the data type of the value column in any EAV data model must be String:

Answer 143

to accommodate various data types (e.g., numeric, datetime) within a single column

Question 144

The important considerations for working with the EAV data model

Answer 144

Filtering for specific attributes, pivoting data, identifying absence of data, and handling data types

Question 145

What it takes to uniquely identify LDA Flowsheet data

Answer 145

Use the LINE in IP_FLOWSHEET_ROWS to distinguish between occurrences and join to IP_FLWSHT_MEAS

Question 146

The difference between measurement time and documented time

Answer 146

Measurement time is when the data was collected, while documented time is when it was entered into the system.

Question 147

How INP records relate to other Flowsheet master files

Answer 147

INP records connect encounters to FSD records, linking Flowsheet data to patient encounters

Question 148

A collection of records that define a specific population of study, such as patients with a particular condition, based on predefined criteria.

Answer 148

Registry

Question 149

The criteria that determine whether an entity (e.g., patient, encounter) qualifies for membership in a registry.

Answer 149

Inclusion Rule

Question 150

A specific piece of data tracked for all members of a registry, such as the most recent Hemoglobin A1c test result in a diabetes registry.

Answer 150

Metric

Question 151

A collection of tables designed to simplify reporting on registry data, breaking down and reassembling data from RDT records

Answer 151

Registry Data Mart

Question 152

Advantages of Using Registries:

Answer 152

Consistency: Ensures a single, agreed-upon definition of a population, allowing for consistent and comparable reports across the organization. Efficiency: Reduces the effort required to define and track populations, as the work is done once and shared across the organization. Accuracy: Provides a reliable framework for tracking metrics, ensuring that all relevant data is captured and reported accurately.

Question 153

An automatic notification in the Epic system that informs providers when certain conditions are met, helping them make informed decisions.

Answer 153

Alert

Question 154

Formerly known as BestPractice Advisories (BPA), these are customizable alerts configured to fire for specific situations, providing guidance and reminders to providers.

Answer 154

OurPractice Advisory (OPA)

Question 155

The Difference Between an ALT Record and an ALT Contact

Answer 155

ALT Record: Created for each alert definition that a patient encounter qualifies for. It represents the alert itself. ALT Contact: Created when a user interacts with the patient contact associated with the alert. It represents the user interaction with the alert.

Question 156

What is the primary purpose of documenting encounters in Epic? A) To schedule appointments B) To store information about patient interactions C) To generate billing codes D) To manage staff schedules

Answer 156

B) To store information about patient interactions

Question 157

Which encounter type is used for a patient arriving without a prior appointment? A) Appointment [50] B) Office Visit [101] C) Walk-in [2] D) Telephone [70]

Answer 157

C) Walk-in [2]

Question 158

Which table in Clarity is used for reporting on all encounters? A) PAT_ENC_HSP B) F_ED_ENCOUNTERS C) PAT_ENC D) HH_PAT_ENC

Answer 158

C) PAT_ENC

Question 159

Which encounter type is used for inpatient stays, including ED visits and hospital outpatient visits? A) Home Care Visit [91] B) Hospital Encounter [3] C) Abstract [150] D) History [109]

Answer 159

B) Hospital Encounter [3]

Question 160

True or False: The VisitFact table in Caboodle includes only inpatient encounters.

Answer 160

False

Question 161

True or False: The encounter identifier is stored in I EPT 8.

Answer 161

True

Question 162

True or False: The CodedHospitalAdmissionFact table in Caboodle is relevant for regulatory, readmission, and mortality reporting.

Answer 162

True

Question 163

Where is patient data stored in Epic? A) SER master file B) EMP master file C) EPT master file D) PAT master file

Answer 163

C) EPT master file

Question 164

Which column in Caboodle is used to identify the patient primary MRN? A) PatientDim.DurableKey B) PatientDim.PrimaryMrn C) PatientKey D) PatientDurableKey

Answer 164

B) PatientDim.PrimaryMrn

Question 165

Which provider association is responsible for overseeing the patient's overall care? A) Visit Provider B) Admission Provider C) Current General PCP D) Discharge Provider

Answer 165

C) Current General PCP

Question 166

Which table in Clarity includes encounters with a type of "Hospital Encounter"? A) PAT_ENC B) PAT_ENC_HSP C) HH_PAT_ENC D) F_ED_ENCOUNTERS

Answer 166

B) PAT_ENC_HSP

Question 167

What is the foreign key typically named in Clarity to look up the patient associated with an encounter? A) PAT_ID B) PAT_MRN_ID C) PROV_ID D) USER_ID

Answer 167

A) PAT_ID

Question 168

True or False: In Caboodle, linking encounters to patients involves using foreign keys like PatientKey and PatientDurableKey.

Answer 168

True