COG220 Access Data Model Latest Update 2024- 2025 Actual Exam from Credible Sources with 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