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'
,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
, 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)
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'
,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
, 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)
