COG220 ACCESS DATA MODEL EXAM
WITH Q & A
How do you determine whether Time Relase of Blocks acted on a block in
AVAIL_BLOCK? Which column represents the released block? Which columns
represents the active block? - CORRECT ANSWER REL_BLOCK_C - released block
BLOCK_C - active block
ADT Event Update vs Patient Update ADT record - CORRECT ANSWER ADT Event
Update - a change in patient's bed or the encounter's billing drivers (shows subtypes to
represent original, canceled, updated)
Patient Update ADT - a change to admission that isn't associated with a transfer (patient
class)
How are I ADT 30, I ADT 80, and I ADT 81 different? - CORRECT ANSWER I ADT 30
represents the event type, I ADT 80 stores the out-event type, and I ADT 81 stores the
in-event type. If you are viewing the event for the first time, I ADT 81 would have a value
of admission
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
Which of the following do the results of an accessibility configuration's search
represent? - CORRECT ANSWER How many days between a scheduling attempt and
an appointment for a hypothetical patient
Accessibility Configurations - CORRECT ANSWER search schedules for the Nth
opening, where N is the occurrence defined in accessibility configurations (Nth = 3rd
appointment). The accessibility configuration returns the number of days between the
day on which the search was performed and the day on which the Nth opening appears
One accessibility configuration search runs twice. Another accessibility configuration
search runs three times. How are they represented in Chronicles as records and
contacts? - CORRECT ANSWER Two SNR records (one for each accessibility
configuration) and five SNR contacts (one for each search run)
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 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
Which of the following always is represented by exactly two ADT event records? -
CORRECT ANSWER A transfer
What ADT Events are considered valid? What are not? What would store a delete time?
- CORRECT ANSWER Any event that has a subtype of 2 (Canceled) is invalid and will
always store a delete time. Original and Update subtypes are valid.
What describes the behavior of I ADT 1100? - CORRECT ANSWER It is only stored on
Transfer Out events, and it stores the ID of the following Transfer In event
What could you determine with PAT_ENC_STAT_HX? - CORRECT ANSWER The
most recently-extracted ADT status and admission status of every hospital encounter,
the first ADT status and admission status of every hospital encounter.
PAT_ENC_STAT_HX - CORRECT ANSWER This table is a history table describing the
ADT status and admission status of a hospital encounter. It has a row everytime either
changes. So, it stores the first statusues, the last (most current) statuses, and all
statuses in between.
Which of the following would return the number of referrals that have been leaked? -
CORRECT ANSWER SUM ( ReferralFact.IsLeaked )
(reason: COUNT will return the number of rows, so if they asked for the number of rows,
you can use COUNT)
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'.
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? - CORRECT
ANSWER 2 - a row for every coverage associated with an auth/cert
OUT_DTTM vs. PAT_OUT_DTTM - CORRECT ANSWER OUT_DTTM
Always returns a value. If still admitted at ETL, returns CURRENT_TIMESTAMP
PAT_OUT_DTTM
Only returns a value for concluded bed stays. If still admitted at ETL, returns NULL
, The moment when the patient first entered an inpatient bed with an inpatient reporting
base class - CORRECT ANSWER all you need is I ADT 84
The moment when the patient first had an inpatient reporting base class - CORRECT
ANSWER I ADT 80-83 (have to determine the best fit)
I ADT 80 - what kind of exit
I ADT 82 - which class is preceded
I ADT 81 - what kind of entry
I ADT 83 - which class resulted
Registration - CORRECT ANSWER Focuses on the patient, guarantor, and coverage(s)
used on an encounter
HAR - CORRECT ANSWER Consolidates registration information active for an
encounter (patient, guarantor, coverage(s)).
Registration information for an encounter that is billed in Resolute HB - CORRECT
ANSWER HSP_ACCOUNT
Registration information for an encounter that id billed in Resolute PB and uses SBO -
CORRECT ANSWER HSP_ACCOUNT
Registration information for an encounter that is billed in Resolute PB and organization
does not use SBO - CORRECT ANSWER ARPV_VISITS
BillingAccountFact - CORRECT ANSWER One row per HAR, regardless of how it is
generated
HSP_ACCOUNT - CORRECT ANSWER One row per HAR, not including VFO HARs
ARPV_VISITS - CORRECT ANSWER One row per PB Visit HAR
EncounterFact - CORRECT ANSWER One row per patient encounter
PAT_ENC - CORRECT ANSWER One row per patient encounter
Linking registration data to guarantors and coverages - CORRECT ANSWER
PAT_ENC only stores primary coverage, it is best use to identify the hospital encounter
for a patient encounter to find its registration data (one of the HSP tables depending on
how the encounter was billed).
BillingAccountEncounterMappingFact - CORRECT ANSWER Links encounters
(EncounterFact) with HARs (BillingAccountFact)
WITH Q & A
How do you determine whether Time Relase of Blocks acted on a block in
AVAIL_BLOCK? Which column represents the released block? Which columns
represents the active block? - CORRECT ANSWER REL_BLOCK_C - released block
BLOCK_C - active block
ADT Event Update vs Patient Update ADT record - CORRECT ANSWER ADT Event
Update - a change in patient's bed or the encounter's billing drivers (shows subtypes to
represent original, canceled, updated)
Patient Update ADT - a change to admission that isn't associated with a transfer (patient
class)
How are I ADT 30, I ADT 80, and I ADT 81 different? - CORRECT ANSWER I ADT 30
represents the event type, I ADT 80 stores the out-event type, and I ADT 81 stores the
in-event type. If you are viewing the event for the first time, I ADT 81 would have a value
of admission
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
Which of the following do the results of an accessibility configuration's search
represent? - CORRECT ANSWER How many days between a scheduling attempt and
an appointment for a hypothetical patient
Accessibility Configurations - CORRECT ANSWER search schedules for the Nth
opening, where N is the occurrence defined in accessibility configurations (Nth = 3rd
appointment). The accessibility configuration returns the number of days between the
day on which the search was performed and the day on which the Nth opening appears
One accessibility configuration search runs twice. Another accessibility configuration
search runs three times. How are they represented in Chronicles as records and
contacts? - CORRECT ANSWER Two SNR records (one for each accessibility
configuration) and five SNR contacts (one for each search run)
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 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
Which of the following always is represented by exactly two ADT event records? -
CORRECT ANSWER A transfer
What ADT Events are considered valid? What are not? What would store a delete time?
- CORRECT ANSWER Any event that has a subtype of 2 (Canceled) is invalid and will
always store a delete time. Original and Update subtypes are valid.
What describes the behavior of I ADT 1100? - CORRECT ANSWER It is only stored on
Transfer Out events, and it stores the ID of the following Transfer In event
What could you determine with PAT_ENC_STAT_HX? - CORRECT ANSWER The
most recently-extracted ADT status and admission status of every hospital encounter,
the first ADT status and admission status of every hospital encounter.
PAT_ENC_STAT_HX - CORRECT ANSWER This table is a history table describing the
ADT status and admission status of a hospital encounter. It has a row everytime either
changes. So, it stores the first statusues, the last (most current) statuses, and all
statuses in between.
Which of the following would return the number of referrals that have been leaked? -
CORRECT ANSWER SUM ( ReferralFact.IsLeaked )
(reason: COUNT will return the number of rows, so if they asked for the number of rows,
you can use COUNT)
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'.
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? - CORRECT
ANSWER 2 - a row for every coverage associated with an auth/cert
OUT_DTTM vs. PAT_OUT_DTTM - CORRECT ANSWER OUT_DTTM
Always returns a value. If still admitted at ETL, returns CURRENT_TIMESTAMP
PAT_OUT_DTTM
Only returns a value for concluded bed stays. If still admitted at ETL, returns NULL
, The moment when the patient first entered an inpatient bed with an inpatient reporting
base class - CORRECT ANSWER all you need is I ADT 84
The moment when the patient first had an inpatient reporting base class - CORRECT
ANSWER I ADT 80-83 (have to determine the best fit)
I ADT 80 - what kind of exit
I ADT 82 - which class is preceded
I ADT 81 - what kind of entry
I ADT 83 - which class resulted
Registration - CORRECT ANSWER Focuses on the patient, guarantor, and coverage(s)
used on an encounter
HAR - CORRECT ANSWER Consolidates registration information active for an
encounter (patient, guarantor, coverage(s)).
Registration information for an encounter that is billed in Resolute HB - CORRECT
ANSWER HSP_ACCOUNT
Registration information for an encounter that id billed in Resolute PB and uses SBO -
CORRECT ANSWER HSP_ACCOUNT
Registration information for an encounter that is billed in Resolute PB and organization
does not use SBO - CORRECT ANSWER ARPV_VISITS
BillingAccountFact - CORRECT ANSWER One row per HAR, regardless of how it is
generated
HSP_ACCOUNT - CORRECT ANSWER One row per HAR, not including VFO HARs
ARPV_VISITS - CORRECT ANSWER One row per PB Visit HAR
EncounterFact - CORRECT ANSWER One row per patient encounter
PAT_ENC - CORRECT ANSWER One row per patient encounter
Linking registration data to guarantors and coverages - CORRECT ANSWER
PAT_ENC only stores primary coverage, it is best use to identify the hospital encounter
for a patient encounter to find its registration data (one of the HSP tables depending on
how the encounter was billed).
BillingAccountEncounterMappingFact - CORRECT ANSWER Links encounters
(EncounterFact) with HARs (BillingAccountFact)
