HSP_ACCT_PAT_CAN - 225 Questions and Verified Correct Answers Gold...

COG220 Access Data Model Latest Update -

225 Questions and Verified Correct Answers Golden Ticket to Guaranteed A+ Verified by Professor

[Clarity] Connect a HAR and its encounters - CORRECT ANSWER: Start from an

encounter and join to its HAR with PAT_ENC_4 or PAT_ENC_HSP. Also, you cab use

HSP_ACCT_PAT_CAN

[SQL] Canceled appts that were not rescheduled - CORRECT ANSWER: SELECT

DepartmentDim.DepartmentName "Department", ProviderDim.Name "Provider", DateDim.DisplayString "Appointment Date", VisitFact.ReasonAppointmentCanceled "Cancel Reason", VisitFact.IsSameDayCancel_YesNo "Same Day Cancel?" FROM VisitFact INNER JOIN DepartmentDim ON VisitFact.DepartmentKey = DepartmentDim.DepartmentKey INNER JOIN ProviderDim ON VisitFact.PrimaryVisitProviderDurableKey = ProviderDim.DurableKey AND ProviderDim.IsCurrent = 1 INNER JOIN DateDim ON VisitFact.AppointmentDateKey = DateDim.DateKey WHERE VisitFact.RescheduledVisitKey = -1 AND VisitFact.AppointmentStatus = 'Canceled' AND VisitFact.CancellationInitiator = 'Patient'

• / 3

A clinic manager needs to see the percent of regular available time a provider is actually caring for patients. What Epic-released metric would be most appropriate? - CORRECT

ANSWER: ES Provider Utilization (With Exclusion)

A clinic manager needs to see what percent of a provider's schedule is filled by schedulers. Which Epic-released metric would be most appropriate? - CORRECT

ANSWER: ES Schedule Utilization (With Exclusion)

A Community Connect site refers a patient to the host. What would this referral's class

be? - CORRECT ANSWER: Internal

A discharge ADT event stores a value of 2 - Canceled in I ADT 35. What must be true? -

CORRECT ANSWER: Its info is not considered valid

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

CORRECT ANSWER: Payer, Plan, Subscriber

A patient update event is edited for the first time. How many rows in CLARITY_ADT have ever represented this patient update? - CORRECT ANSWER: 2 - the original and the edit

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? - CORRECT ANSWER: 3 - one line for each

address

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? - CORRECT ANSWER: 1 - one for the one edit

A referral has three coverages, and each coverage provides one authorization number for the referral. How many rows in AuthorizationFact describe this RFL record? -

CORRECT ANSWER: 3 - one for each authorization number

• / 3

A referral has two coverages. Each coverage provides authorization numbers for specific procedures. What TypeOfAuthorization value appears for the relevant rows in

AuthorizationFact? - CORRECT ANSWER: Service Level.

Since authorization numbers exist for specific procedures, the payers provided information at the SLA level, which is represented by a TypeOfAuthorization value of 'Service Level'.

A report filters to I ADT 80 = 2 (Discharge) Which of the following best describes the result set? - CORRECT ANSWER: 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? - CORRECT ANSWER: Each row is an ADT event where the preceding

reporting base class was observation

A row of AVAIL_BLOCK stores a non-null value in both BLOCK_C and REL_BLOCK_C.

What must be true about this row? - CORRECT ANSWER: The block represented by

BLOCK_C replaced the block represented by REL_BLOCK_C

A row of AVAIL_BLOCK stores a non-null value in REL_BLOCK_C. What must be true

about this row? - CORRECT ANSWER: The relevant slot currently uses the block

represented by REL_BLOCK_C

A row of AVAIL_BLOCK stores a value in BLOCK_C and stores a null value in

REL_BLOCK_C. What must be true about this row? - CORRECT ANSWER: The block

represented by BLOCK_C was originally present in the slot and has not been replaced by Time Release of Blocks

A user changed the status of a VRX record about a guarantor. That was not the final change to the VRX record's status. What would VERIFICATION store? - CORRECT ANSWER: The ID of the guarantor who was verified. (Note: if it is looking for historical info, an HX table would suffice)

ACCESS_CONFIG - CORRECT ANSWER: one row per accessibility configuration

(SNR record)

• / 3