Practice Questions Flashcards
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
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!
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.
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.
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
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.
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
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.
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
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.
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
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
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”
B. How this medication order is to be routed through the Epic system, e.g. “normal” or “historical”
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
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).
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
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
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.
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
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’)
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
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
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.
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
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.
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.
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.
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
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.
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
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.
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: ___________________________________
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)
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
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).
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’
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.
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
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.
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
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.
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
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.
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
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.
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
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.
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
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
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
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.
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
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
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)
A. One-to-One
Each administration has one documented action. Examples include “Give” or “Canceled”
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
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
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’
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 <context> AttributeValueDim depending on their context in Caboodle and SMARTDTA_ELEM_VALUE in Clarity</context>
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
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
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
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.
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
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
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
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
Admission Provider: inpatient or outpatient
inpatient
All visit providers: inpatient or outpatient
outpatient
Attending Provider: Inpatient or outpatient
inpatient
Care Team: Inpatient or Outpatient Services
Outpatient
Current General PCP: Inpatient or Outpatient
Outpatient
Discharge Provider: Inpatient or Outpatient
Inpatient
First Visit Provider: Inpatient or Outpatient
Outpatient
Provider Identifier: Inpatient or Outpatient
Outpatient
Treatment Team: Inpatient or Outpatient
Inpatient
Master File for Providers
SER
Master File for Users
EMP
Master File for Patients
EPT
True or False: when someone is discharged from the facility their “most recent department” is their discharged department
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.
What table extracts both HSB and HBD data?
EpisodeFact
A specific instance of interaction with a patient, stored in the EPT master file in Epic.
Contact
A slice in time representing an interaction with a patient, documented as a contact in the EPT master file.
Encounter
The classification of an encounter based on the nature of the interaction (e.g., office visit, telephone encounter, hospital admission).
Encounter Type
An individual who provides care to patients, represented by a record in the SER master file.
Provider
An individual or entity that can log in to the Epic system, represented by a record in the EMP master file.
User
A specific area within a healthcare facility where patient care is provided, represented by a record in the DEP master file.
Department
A collection of encounters grouped together to address the same persistent condition, stored in the HSB master file.
Episode
What is included within the “hospital” encounter type:
1.inpatient stays
2.emergency department visits
3.hospital outpatient visits
4.observations
5.pre-admission workflows.
What determines which encounters are included in which encounter tables
Encounters are included in specific tables based on their type and setting (e.g., inpatient admissions in HospitalAdmissionFact, ED visits in EdVisitFact).
Difference between various provider associations (PCP vs. Visit Provider vs. Attending Provider)
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.
who/what has a provider record and who/what has a user record
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.
The difference in “when” reporting between outpatient and inpatient encounters
Outpatient encounters typically occur within a single day, while inpatient encounters span multiple days and involve multiple key events (e.g., admission, discharge).
The relationship between episodes and encounters
Episodes group together multiple encounters related to the same condition. Encounters can be automatically or manually attached to episodes.
Fact table are generally what? Static or Dynamic
Dynamic
Dim tables are generally what? Static or Dynmaic
Static
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.
True
If you want to know what chief complaints were documented do you use ChiefComplaintBridge or EventFact?
ChiefComplaintBridge
If you want to know more specific information about an event, do you use a Bridge table or Fact?
Fact
For any table that list DiagnosisEventFact, by implication that table must be filtered on…..
Type = “Hospital Problem” or Type = “Problem List”.
If you wanted to know the problems for an inpatient encounter, what table would you use?
HospitalAdmissionFact
ProblemListFact
HospitalAdmissionFact
Stored on the encounter (e.g., outpatient visits)
Point-in-Time Diagnoses
Stored on the problem list (e.g., chronic conditions)
Persistent Diagnoses
The patient’s motivation for seeking medical care, often described in informal language (e.g., “my arm hurts”). Stored in the HRV master file.
Reason for Visit
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.
Diagnosis
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.
Problem List
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
Hospital Problem
Return the Visit Diagnoses for an Encounter
Use the DiagnosisEventFact table in Caboodle or the PAT_ENC_DX table in Clarity, filtering for encounter diagnoses.
Return the Chief Complaints for an Encounter
Use the ChiefComplaintEventFact table in Caboodle or the PAT_ENC_RSN_VISIT table in Clarity
Return the Hospital Problems for an Admission
Use the DiagnosisEventFact table in Caboodle, filtering for hospital problems, or the PAT_ENC_HOSP_PROB table in Clarity
Return the Entries on a Patient’s Problem List
Use the ProblemListFact table in Caboodle or the PROBLEM_LIST table in Clarity
Identify the Primary Diagnosis for an Encounter
Use the DiagnosisEventFact.IsPrimary column in Caboodle or the PAT_ENC_DX.PRIMARY_DX_YN column in Clarity.
Identify the Principal Problem for an Admission
Use the HospitalAdmissionFact.PrincipalProblemKey in Caboodle or the PAT_ENC_HOSP_PROB.PRINCIPAL_PROB_YN column in Clarity.
Filter a Patient’s Problem List by Status, Noted Date, or Resolved Date
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
The patient’s reason for visit, described informally
Chief Complaint
The clinician’s diagnosis for a specific encounter, documented formally
Encounter Diagnosis
Problems associated with an inpatient admission, including conditions present on admission or acquired during the stay
Hospital Problem
A list of persistent conditions that span time and are not limited to a single encounter.
Overall Problem List
A record in the __master file represents a __defined in your system.
ERX, Medication
A record in the __master file represents a __defined in your system, which could be____.
Examples of procedures include___
EAP, Procedure
lab work, imaging, supplies, referrals, actual procedures, and charges
A record in the __master file represents an__placed in your system, which is a__for either a__or a__.
ORD, order, request, medication, procedure
Order___categorizes the thing being requested by the order.
Type
Order____is used to determine to where an order is routed after it is placed.
Class
Order___is a property of the order used to capture the setting the order should be completed.
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”.
a request for something to happen in the system now.
normal order
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.
Future
A ____ order is designed to make a request for something to happen in the system multiple times
Standing
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
A. parent (or normal) orders
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
C. link parent and child orders
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
B. child (or normal) orders
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?
We see the future and standing orders but not the normal order, because normal orders don’t produce child orders.
a __ may contain information about the patient’s progress, about a plan for treatment, or about clinical observations before surgery.
note
After the addendum is signed, it becomes a new ___ on the existing note record.
contact
True or False: Events are highly customizable
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.
Events “entity”: ___
The encounter/patient
Events “attribute”: ___
Event Type
Events “value”: ___
The time at which the event happened
If a patient or encounter qualifies for more than one registry how many RDT records will they have?
1
if Riley is a member of the Asthma registry for one year, how many rows will they have in the table DM_ASTHMA?
One row.
How many rows will they have in the table DM_ASTHMA_HX?
12
A substance used for medical treatment, especially a medicine or drug.
Medication
A medical test or operation.
Procedure
A request for a medication or procedure to be performed.
Order
Determines where an order is routed after being placed.
Order Class
Indicates the setting in which the order should be completed (e.g., inpatient, outpatient).
order Mode
Categorizes the thing being requested by the order (e.g., medication, lab test).
order type
An order that authorizes the future release of child orders.
parent order
An order that performs the action desired by the requestor.
child order
A request for something to happen immediately.
normal order
A request for a single action to occur at a later time.
future order
A request for repeated actions, either on a regular schedule or ad hoc.
standing order
A part of a procedure order result, such as a specific test result.
component
A record of medication administrations.
MAR (Medication Administration Record)
the act of giving a medication to a patient.
administration
The specific action taken during medication administration (e.g., Given, Deferred).
action
ERX Master File
Medications
EAP Master File
Procedures
ORD Master File
Orders
A record of pertinent information about a patient, written during an encounter.
Note
A revision to a signed note, creating a new contact on the original note record.
Addendum
Discrete questions used to record patient information in a reportable manner
SmartData Element (SDE)
The setting or situation in which an SDE is used (e.g., Patient, Encounter, Order).
Context
The unique identifier for an SDE
SmartData Identifier (SDI)
The subject or thing being described in the EAV data model (e.g., a patient)
Entity
A characteristic or property of the entity in the EAV data model (e.g., temperature, blood pressure).
Attribute
The actual data for the attribute in the EAV data model (e.g., 98.6°F, 120/80 mmHg).
value
A tool used to document a wide range of patient data over time.
flowsheet
Defines the groups and rows that can appear on a Flowsheet.
flowsheet template
A collection of rows in a Flowsheet, used to organize patient information.
flowsheet group
Documents specific pieces of patient data over time
flowsheet row
Independent entities attached to or within a patient, documented in Flowsheets.
LDA (Lines, Drains, Airways)
A discrete moment or action within a patient encounter, tracked using the IEV master file.
Event
What a record and a contact in the HNO master file represent
A record represents a note, while a contact represents a version or snapshot of the note over time.
Why reporting on notes is undesirable
Free text is unstructured, making it difficult to standardize and report on.
The impact of context on SmartData Elements:
Context determines how and where SDE data is stored and how it should be joined in reports.
Why the data type of the value column in any EAV data model must be String:
to accommodate various data types (e.g., numeric, datetime) within a single column
The important considerations for working with the EAV data model
Filtering for specific attributes, pivoting data, identifying absence of data, and handling data types
What it takes to uniquely identify LDA Flowsheet data
Use the LINE in IP_FLOWSHEET_ROWS to distinguish between occurrences and join to IP_FLWSHT_MEAS
The difference between measurement time and documented time
Measurement time is when the data was collected, while documented time is when it was entered into the system.
How INP records relate to other Flowsheet master files
INP records connect encounters to FSD records, linking Flowsheet data to patient encounters
A collection of records that define a specific population of study, such as patients with a particular condition, based on predefined criteria.
Registry
The criteria that determine whether an entity (e.g., patient, encounter) qualifies for membership in a registry.
Inclusion Rule
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.
Metric
A collection of tables designed to simplify reporting on registry data, breaking down and reassembling data from RDT records
Registry Data Mart
Advantages of Using Registries:
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.
An automatic notification in the Epic system that informs providers when certain conditions are met, helping them make informed decisions.
Alert
Formerly known as BestPractice Advisories (BPA), these are customizable alerts configured to fire for specific situations, providing guidance and reminders to providers.
OurPractice Advisory (OPA)
The Difference Between an ALT Record and an ALT Contact
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.
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
B) To store information about patient interactions
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]
C) Walk-in [2]
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
C) PAT_ENC
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]
B) Hospital Encounter [3]
True or False: The VisitFact table in Caboodle includes only inpatient encounters.
False
True or False: The encounter identifier is stored in I EPT 8.
True
True or False: The CodedHospitalAdmissionFact table in Caboodle is relevant for regulatory, readmission, and mortality reporting.
True
Where is patient data stored in Epic?
A) SER master file
B) EMP master file
C) EPT master file
D) PAT master file
C) EPT master file
Which column in Caboodle is used to identify the patient primary MRN?
A) PatientDim.DurableKey
B) PatientDim.PrimaryMrn
C) PatientKey
D) PatientDurableKey
B) PatientDim.PrimaryMrn
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
C) Current General PCP
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
B) PAT_ENC_HSP
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
A) PAT_ID
True or False: In Caboodle, linking encounters to patients involves using foreign keys like PatientKey and PatientDurableKey.
True
