Self Assessment Review Flashcards
An auth/cert has two associated coverages. Each coverage approved three bed days. How many rows appear for this auth/cert in REFERRAL_CVG_BED?
2
A patient’s address had two lines, and a user edited the address to instead have three lines. Assuming this is captured in Registration History, how many rows represent this edit in REG_HX_ADDR_CHNG_NEW?
3
What are the “In” ADT events?
1(admission), 3(transfer in), 9 (leave of absence return)
For which of the following bed stays would V_PAT_ADT_LOCATION_HX.PAT_OUT_DTTM return a value?
A bed stay where the patient has departed the bed
With regard to the Access Data Model, What is a patient?
A person who receives the services an organization provides
How are Clinic Visits defined in Epic?
A type of appointment and are the encounters that occur in outpatient locations
How many patient encounters may be associated with a guarantor record?
A unlimited number of encounters
Which of the following scenarios would create a HAR?
A visit in a service area with SBO (and not VFO) that is billed through Resolute Hospital
Billing or Resolute Professional Billing. A visit in a service area with VFO (and not SBO) that is billed through Resolute Hospital Billing or Resolute Professional Billing. A visit in a service area with both SBO and VFO that is billed through Resolute Hospital Billing or Resolute Professional Billing. A visit in a service area with neither SBO nor VFO that is billed through Resolute Hospital Billing
What was the Grand Central application once known as?
ADT was the former name of this application
What is “Welcome” as it pertains to Epic applications?
Allows patients to check themselves in for an appointment. It is an application that focuses on self service kiosks or tablets a patient can use to check in.
Which of the following is a joint appointment?
Any appointment that involves multiple SER records
How many patient encounters may be associated with a guarantor record?
Any number of encounters, including zero
A referral has a status of “Authorized by Phone.” This status was custom-built at your organization. What will ReferralFact.Status store for this referral?
authorized by phone
Which of the following join conditions would connect each hospital account to its guarantor’s current information and exclude historical information?
BillingAccountFact.GuarantorDurableKey = GuarantorDim.DurableKey and Guarantordim.IsCurrent = 1
What is the unit used for the value returned by ReferralFact.AuthorizationToScheduledDate?
Business Days
What ways can appointments be scheduled?
By human scheduler, through My Chart, via interface from another scheduler, automatically generated from a clinical order
For which of the following would F_SCHED_APPT_STATS be appropriate?
Calculating the number of no shows in a given department
What are the Epic reporting base classes
Direct, Emergency, Inpatient, Observation, Outpatient.
A report filters to I ADT 80 = 2 (Discharge). Which of the following best describes the result set?
Each row is an ADT event that was the last event in its encounter to have its reporting base class
A report filters to I ADT 82 = 4 (Observation). Which of the following best describes the result set?
Each row is an ADT event where the preceding reporting base class was observation
What are the three Gran Central event sub-types?
Event sub-type (1 - Original, 2 - Canceled, 3 - Update)
True of False: Caboodle maintains links between rescheduled appointments?
False - No links are maintained
What are HOV’s
Hospital Out Visits; created to track outpatient visits to hospitals (i.e. physical therapy on an outpatient basis)
An accessibility configuration record completes its search once. Which of the following is required to calculate how many rows it creates in ACCESS_DEP?
How many departments the search evaluates.
Define wait time
How much time a patient is waiting for something or somebody (i.e. the doctor)
A user changed the status of a VRX record about a guarantor. That was not the final change to the VRX record’s status. Which of the following would VERIFICATION store?
ID of the guarantor who was verified
A given Coverage represents this unique combination of Epic elements.
In Epic, it is the unique combination of a payer, plan and subscriber
What is an EAR record
Information about a guarantor. A guarantor can have more than one of these records (i.e. a personal guarantor account and a workers comp guarantor account)
What are appointments with multiple providers and/or resources referred to as?
Joint appointments (the times selected must be the same, overlap or touch for all providers/resources involved)
Which of the following best describes what VisitFact.RoomedTimeOfDayKey will store?
More information is necessary to make that determination.
An ADT event record stores its own ID in CLARITY_ADT.ORIGINAL_EVENT_ID. What must be true about this ADT event?
None of the above
In which database object would you find every time an HOV was marked as Completed?
PAT_ENC_STAT_HX
A given coverage record represents the unique combination of which of the following?
Payer, Plan, Subscriber
R ADT 12345 stores a value of 12346 in I ADT 1100. Which of the following must be true?
R ADT 12345 is a transfer out event, R ADT 12346 is the following Transfer In event
What are the Epic workflows that can be used to track patients.
Removal from an arrival list, direct room assignment, roomed time
What is accessibility as defined by Epic?
The ability to seek and receive care at an organization
Define appointment cycle time.
The amount of time a patient spends in the various appointment stages
How can you tell which rows in the V_AVAILABILITY view are for slots and which are for appointments
the Appt_number column will store greater than 0 for appointments and 0 for slots
All Resolute Professional Billing transactions , regardless of VFO and SBO status appear in what Epic object table.
The ARPB_FILING_ORDER table in Clarity
What Caboodle table establishes the relationship between encounters and HARs
The BillingAccountEncounterMapping Fact
What are the Caboodle and Clarity Data Base Objects (DBO) used to report on Guarantor data?
The Caboodle GuarantorDim table and the Clarity Account table
What are the Caboodle and Clarity Data Base Objects (DBO) used to report on patient-level data?
The caboodle patientdim table and the clarity patient table
In which database object would you find the member-level effective dates for coverage?
The coverage_member_list in clarity and the eligibilityeventfact table in caboodle
What does VERIFICATION.VERIF_STATUS_C represent?
the current status of verification record
In what database can “Welcome” data be found.
The data can be found in the Clarity database and not in the Caboodle database
If there are multiple overages for a patient which is the primary coverage for that patient.
The first coverage received is designated as the primary coverage.
What is a HAR record
The Hospital Accounts Records that are the center of Resolute Hospital Billing and are also used in Resolute Professional Billing
With regard to the Access Data Model, What is a payor
The insurance company to whom an insurance claim will be sent
What is the difference between Internal and external Identifiers?
The internal identifier will be unique but is not guaranteed to be recognizable by a user; while the external identifiers are recognizable but are not guaranteed to be unique.
What options does Epic provide to patients to maintain their own registration data also referred to a eCheck-In?
The My Chart and Welcome patient on-line Epic applications
List the criteria the Cadence Administrator can use for setting up accessibility batch jobs.
The Nth appointment opening 1st, 3rd and 5th? Next opening for provider, department or facility; What Departments; How long an opening is needed (5 minutes, 15 minutes, etc.) Should weekends and holidays be counted? Uses the ACCESS_CONFIG table in chronicles
What are the main database objects that will have one row for each patient encounter?
The PAT_ENC and EncounterFact tables
Subscriber
The person under whose name the insurance is issued. Each insurance coverage has only one.
Member
The person who is covered by insurance. Patients who will use the coverage (i.e children on the health insurance policy)
You are creating a report on canceled and rescheduled appointments. To do so, you use the following linking diagram. Will the sample report shown below meet this need? If not, why not?
The report will not work correctly because the columns in the join are incorrect
A patient update event was initially considered the inpatient admission. Its interpretation changed multiple times, and it is now ultimately considered an inpatient transfer in. Which of the following represents the span of time when the event was originally considered the inpatient admission?
The row in adt_interpretation with the earliest start_dttm value that stores the events id in Event_id
What is the SNR master file?
The Scheduled Accessibility Configuration master file.
Plan
The set of benefits that the insurance company offers
What is the difference between subscriber and a member?
the subscriber is the name of the person the insurance is issued to; while a member is the person who is covered by the insurance
Which Clarity database object greatly simplifies coverage reports.
The v_covearge_payor_plan database object
A provider fills all regular openings and has overbook openings on their schedule. None of the overbook openings are filled. Which of the following would describe the output of Epic’s formula to calculate schedule utilization for this provider?
The value would equal 100%
What is the industry standard for calculating the wait average when scheduling patient appointments.
To report the third next available appointment (sometimes abbreviated 3NA)
True or False: An Appointment Serial Number (ASN) does not change when an appointment has been rescheduled?
True - It does not change
Which of the following database objects have prebuilt columns that calculate how long a patient spends in a waiting room for a clinic visit?
VisitFact and V_sched_appt
You need to calculate the length of time between the point when a patient checked in and the appointment end time for an office visit. Which of the following best represents that length of time?
VistFact.AppointmentLengthInMinutes
True or False: A patient’s MRN is guaranteed to be unique across all patients on the same instance of Epic.
False
True of False: Most organizations are more concerned with the member effective dates on a coverage than the coverage effective dates.
True
True or False: A single accessibility configuration can be used to populate ACCESS_PROV, ACCESS_DEP, and ACCESS_ALL_DEPS.
True
True or False: ReferralFact excludes rows about auth/certs.
True
True or False: You can use an accessibility extract configuration to automatically calculate how many days a patient would need to wait to see a given provider.
True
