Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Access Data Model BI Developer Self Assessments > Self Assessment Review > Flashcards

Self Assessment Review Flashcards

1
Q

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?

A

2

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

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?

A

3

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What are the “In” ADT events?

A

1(admission), 3(transfer in), 9 (leave of absence return)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

For which of the following bed stays would V_PAT_ADT_LOCATION_HX.PAT_OUT_DTTM return a value?

A

A bed stay where the patient has departed the bed

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

With regard to the Access Data Model, What is a patient?

A

A person who receives the services an organization provides

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

How are Clinic Visits defined in Epic?

A

A type of appointment and are the encounters that occur in outpatient locations

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

How many patient encounters may be associated with a guarantor record?

A

A unlimited number of encounters

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Which of the following scenarios would create a HAR?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What was the Grand Central application once known as?

A

ADT was the former name of this application

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What is “Welcome” as it pertains to Epic applications?

A

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Which of the following is a joint appointment?

A

Any appointment that involves multiple SER records

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

How many patient encounters may be associated with a guarantor record?

A

Any number of encounters, including zero

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

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?

A

authorized by phone

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Which of the following join conditions would connect each hospital account to its guarantor’s current information and exclude historical information?

A

BillingAccountFact.GuarantorDurableKey = GuarantorDim.DurableKey and Guarantordim.IsCurrent = 1

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What is the unit used for the value returned by ReferralFact.AuthorizationToScheduledDate?

A

Business Days

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What ways can appointments be scheduled?

A

By human scheduler, through My Chart, via interface from another scheduler, automatically generated from a clinical order

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

For which of the following would F_SCHED_APPT_STATS be appropriate?

A

Calculating the number of no shows in a given department

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

What are the Epic reporting base classes

A

Direct, Emergency, Inpatient, Observation, Outpatient.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

A report filters to I ADT 80 = 2 (Discharge). Which of the following best describes the result set?

A

Each row is an ADT event that was the last event in its encounter to have its reporting base class

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

A report filters to I ADT 82 = 4 (Observation). Which of the following best describes the result set?

A

Each row is an ADT event where the preceding reporting base class was observation

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

What are the three Gran Central event sub-types?

A

Event sub-type (1 - Original, 2 - Canceled, 3 - Update)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

True of False: Caboodle maintains links between rescheduled appointments?

A

False - No links are maintained

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

What are HOV’s

A

Hospital Out Visits; created to track outpatient visits to hospitals (i.e. physical therapy on an outpatient basis)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

An accessibility configuration record completes its search once. Which of the following is required to calculate how many rows it creates in ACCESS_DEP?

A

How many departments the search evaluates.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

Define wait time

A

How much time a patient is waiting for something or somebody (i.e. the doctor)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

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?

A

ID of the guarantor who was verified

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

A given Coverage represents this unique combination of Epic elements.

A

In Epic, it is the unique combination of a payer, plan and subscriber

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q

What is an EAR record

A

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)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
29
Q

What are appointments with multiple providers and/or resources referred to as?

A

Joint appointments (the times selected must be the same, overlap or touch for all providers/resources involved)

30
Q

Which of the following best describes what VisitFact.RoomedTimeOfDayKey will store?

A

More information is necessary to make that determination.

31
Q

An ADT event record stores its own ID in CLARITY_ADT.ORIGINAL_EVENT_ID. What must be true about this ADT event?

A

None of the above

32
Q

In which database object would you find every time an HOV was marked as Completed?

A

PAT_ENC_STAT_HX

33
Q

A given coverage record represents the unique combination of which of the following?

A

Payer, Plan, Subscriber

34
Q

R ADT 12345 stores a value of 12346 in I ADT 1100. Which of the following must be true?

A

R ADT 12345 is a transfer out event, R ADT 12346 is the following Transfer In event

35
Q

What are the Epic workflows that can be used to track patients.

A

Removal from an arrival list, direct room assignment, roomed time

36
Q

What is accessibility as defined by Epic?

A

The ability to seek and receive care at an organization

37
Q

Define appointment cycle time.

A

The amount of time a patient spends in the various appointment stages

38
Q

How can you tell which rows in the V_AVAILABILITY view are for slots and which are for appointments

A

the Appt_number column will store greater than 0 for appointments and 0 for slots

39
Q

All Resolute Professional Billing transactions , regardless of VFO and SBO status appear in what Epic object table.

A

The ARPB_FILING_ORDER table in Clarity

40
Q

What Caboodle table establishes the relationship between encounters and HARs

A

The BillingAccountEncounterMapping Fact

41
Q

What are the Caboodle and Clarity Data Base Objects (DBO) used to report on Guarantor data?

A

The Caboodle GuarantorDim table and the Clarity Account table

42
Q

What are the Caboodle and Clarity Data Base Objects (DBO) used to report on patient-level data?

A

The caboodle patientdim table and the clarity patient table

43
Q

In which database object would you find the member-level effective dates for coverage?

A

The coverage_member_list in clarity and the eligibilityeventfact table in caboodle

44
Q

What does VERIFICATION.VERIF_STATUS_C represent?

A

the current status of verification record

45
Q

In what database can “Welcome” data be found.

A

The data can be found in the Clarity database and not in the Caboodle database

46
Q

If there are multiple overages for a patient which is the primary coverage for that patient.

A

The first coverage received is designated as the primary coverage.

47
Q

What is a HAR record

A

The Hospital Accounts Records that are the center of Resolute Hospital Billing and are also used in Resolute Professional Billing

48
Q

With regard to the Access Data Model, What is a payor

A

The insurance company to whom an insurance claim will be sent

49
Q

What is the difference between Internal and external Identifiers?

A

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.

50
Q

What options does Epic provide to patients to maintain their own registration data also referred to a eCheck-In?

A

The My Chart and Welcome patient on-line Epic applications

51
Q

List the criteria the Cadence Administrator can use for setting up accessibility batch jobs.

A

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

52
Q

What are the main database objects that will have one row for each patient encounter?

A

The PAT_ENC and EncounterFact tables

53
Q

Subscriber

A

The person under whose name the insurance is issued. Each insurance coverage has only one.

54
Q

Member

A

The person who is covered by insurance. Patients who will use the coverage (i.e children on the health insurance policy)

55
Q

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?

A

The report will not work correctly because the columns in the join are incorrect

56
Q

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?

A

The row in adt_interpretation with the earliest start_dttm value that stores the events id in Event_id

57
Q

What is the SNR master file?

A

The Scheduled Accessibility Configuration master file.

58
Q

Plan

A

The set of benefits that the insurance company offers

59
Q

What is the difference between subscriber and a member?

A

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

60
Q

Which Clarity database object greatly simplifies coverage reports.

A

The v_covearge_payor_plan database object

61
Q

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?

A

The value would equal 100%

62
Q

What is the industry standard for calculating the wait average when scheduling patient appointments.

A

To report the third next available appointment (sometimes abbreviated 3NA)

63
Q

True or False: An Appointment Serial Number (ASN) does not change when an appointment has been rescheduled?

A

True - It does not change

64
Q

Which of the following database objects have prebuilt columns that calculate how long a patient spends in a waiting room for a clinic visit?

A

VisitFact and V_sched_appt

65
Q

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?

A

VistFact.AppointmentLengthInMinutes

66
Q

True or False: A patient’s MRN is guaranteed to be unique across all patients on the same instance of Epic.

A

False

67
Q

True of False: Most organizations are more concerned with the member effective dates on a coverage than the coverage effective dates.

A

True

68
Q

True or False: A single accessibility configuration can be used to populate ACCESS_PROV, ACCESS_DEP, and ACCESS_ALL_DEPS.

A

True

69
Q

True or False: ReferralFact excludes rows about auth/certs.

A

True

70
Q

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.

A

True

Access Data Model BI Developer Self Assessments (1 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions