EPIC COG230 Revenue Data Model
TEST STUDY GUIDE 2026/2027
COMPLETE QUESTIONS WITH
CORRECT DETAILED ANSWERS ||
100% GUARANTEED PASS
<LATEST VERSION>
1. Accounts Receivable - ANSWER ✔ Outstanding money we expect to
receive in the future
2. Three Transaction Types: - ANSWER ✔ Charges
Payments
Adjustments
3. Charges occur as a result of: - ANSWER ✔ Performing services
4. Payments are a result of: - ANSWER ✔ Receiving money
5. What are adjustments? - ANSWER ✔ Anything that changes AR (Credit
Adjustments or Debit Adjustments)
6. An example of a credit adjustment is: - ANSWER ✔ Contractual write-offs
7. An example of a debit adjustment is: - ANSWER ✔ A refund
,8. A report requires you to display the financial class and primary payer on
hospital accounts as of the day a HAR is closed. Which table would allow
you to find this subset of HARs and foreign keys
to the required information?
A. HSP_HAR_SNAPSHOT
B. HSP_ACCOUNT
C. HSP_ACCOUNT and ACCOUNT
D. none of these - ANSWER ✔ A. HSP_HAR_SNAPSHOT
9. You want to report on all hospital accounts which are currently
discharged/not billed. Which field would you filter on?
A. HSP_ACCOUNT.DISCH_DATE_TIME
B. HSP_ACCOUNT.ACCT_BILLED_DATE
C. HSP_ACCOUNT.PATIENT_STATUS_C
D. HSP_BUCKET.BKT_STS_HA_C
E. HSP_ACCOUNT.ACCT_BILLSTS_HA_C - ANSWER ✔ E.
HSP_ACCOUNT.ACCT_BILLSTS_HA_C
10.When an insurance company sends a payment, the payer may reimburse
services rendered or _____ _______. - ANSWER ✔ Deny Payment
11.True/False. there are several SlicerDicer data models available, as well as an
OLAP Cube and a Clarity‐based spreadsheet that contain denial information
for each billing system - ANSWER ✔ True
12.What is an EOB? - ANSWER ✔ Explanation of benefits. Every time a payer
responds to a claim, they send an EOB explaining what they are paying ﴾or
not paying﴿ and why.
,13.What is the term used to describe the reason provided by a payer for why
they are not paying a claim/invoice? - ANSWER ✔ Remittance Codes
14.Denial, remark, correspondence, underpayment, and overpayment records
are stored in which masterfile? - ANSWER ✔ DBC. Billing Denial
Correspondence.
15.True/False. One BDC record is created per denial remittance code. -
ANSWER ✔ True
16.True/False. A claim can only have on denial remittance code. - ANSWER ✔
False. A claim can have more than one denial remittance code if there are
several reasons for the denials. For example, one claim can have a
registration denial and a coding denial, which results in two BDC records.
17.True/False. Professional Billing only uses BDC for tracking denials, and
does not create other types of BDC records. - ANSWER ✔ True
18.True/False. The granularity in PB for denials reporting is one BDC record
for every payment/charge/reason code combination. - ANSWER ✔ True
19.True/False. The granularity in HB for denials reporting is one BDC record
for every payment/charge/reason code combination. - ANSWER ✔ False.
The granularity of HB BDCs can be summarized as one BDC for every
remittance code on a claim since BDC records are tracked at the bucket
level. Because buckets store payer‐specific information for a hospital
account, we can track the denials sent by payers and their reasons.
, 20.What's the purpose of Single Billing Office? - ANSWER ✔ To send one
statement to guarantors with their portion for both PB and HB charges
21.What database objects that store guarantors? - ANSWER ✔ Account &
GuarantorDim
22.You are writing a query about transactions in August 2021. You would like
the result set to be the same whether you run it in September 2021 or March
2022. - ANSWER ✔ Postdate
23.A guarantor account has tracked $100 in PB charges and $300 in HB
charges. Using Account table, what column(s) do you need to display the
total balance for this guarantor? - ANSWER ✔
ACCOUNT.TOTAL_BALANCE + ACCOUNT.HB_BALANCE
24.What transaction type does a refund have? - ANSWER ✔ Debit Adjustment/
Debit Increases AR
25.Shlomo sees their PCP for a physical. Shlomo's father Yosef is the owner of
the insurance policy that pays for most of the visit. He also receives the
balance due after insurance has paid, and he is
ultimately responsible for paying that balance. In which of the following
roles is Yosef acting? - ANSWER ✔ Subscriber & Guarantor
26.A PB charge with an ID of 56789 is posted and sent on a claim. The
organization waits for a while & then resends the charge on another claim.
27.How many rows in CLARITY_TDL_TRAN with TX_ID= 56789 will be
created as a result? - ANSWER ✔ 3 Rows. The original posting is a row of
detail type 1. Each time the charge is sent on a claim is a new row of detail
type 50.
TEST STUDY GUIDE 2026/2027
COMPLETE QUESTIONS WITH
CORRECT DETAILED ANSWERS ||
100% GUARANTEED PASS
<LATEST VERSION>
1. Accounts Receivable - ANSWER ✔ Outstanding money we expect to
receive in the future
2. Three Transaction Types: - ANSWER ✔ Charges
Payments
Adjustments
3. Charges occur as a result of: - ANSWER ✔ Performing services
4. Payments are a result of: - ANSWER ✔ Receiving money
5. What are adjustments? - ANSWER ✔ Anything that changes AR (Credit
Adjustments or Debit Adjustments)
6. An example of a credit adjustment is: - ANSWER ✔ Contractual write-offs
7. An example of a debit adjustment is: - ANSWER ✔ A refund
,8. A report requires you to display the financial class and primary payer on
hospital accounts as of the day a HAR is closed. Which table would allow
you to find this subset of HARs and foreign keys
to the required information?
A. HSP_HAR_SNAPSHOT
B. HSP_ACCOUNT
C. HSP_ACCOUNT and ACCOUNT
D. none of these - ANSWER ✔ A. HSP_HAR_SNAPSHOT
9. You want to report on all hospital accounts which are currently
discharged/not billed. Which field would you filter on?
A. HSP_ACCOUNT.DISCH_DATE_TIME
B. HSP_ACCOUNT.ACCT_BILLED_DATE
C. HSP_ACCOUNT.PATIENT_STATUS_C
D. HSP_BUCKET.BKT_STS_HA_C
E. HSP_ACCOUNT.ACCT_BILLSTS_HA_C - ANSWER ✔ E.
HSP_ACCOUNT.ACCT_BILLSTS_HA_C
10.When an insurance company sends a payment, the payer may reimburse
services rendered or _____ _______. - ANSWER ✔ Deny Payment
11.True/False. there are several SlicerDicer data models available, as well as an
OLAP Cube and a Clarity‐based spreadsheet that contain denial information
for each billing system - ANSWER ✔ True
12.What is an EOB? - ANSWER ✔ Explanation of benefits. Every time a payer
responds to a claim, they send an EOB explaining what they are paying ﴾or
not paying﴿ and why.
,13.What is the term used to describe the reason provided by a payer for why
they are not paying a claim/invoice? - ANSWER ✔ Remittance Codes
14.Denial, remark, correspondence, underpayment, and overpayment records
are stored in which masterfile? - ANSWER ✔ DBC. Billing Denial
Correspondence.
15.True/False. One BDC record is created per denial remittance code. -
ANSWER ✔ True
16.True/False. A claim can only have on denial remittance code. - ANSWER ✔
False. A claim can have more than one denial remittance code if there are
several reasons for the denials. For example, one claim can have a
registration denial and a coding denial, which results in two BDC records.
17.True/False. Professional Billing only uses BDC for tracking denials, and
does not create other types of BDC records. - ANSWER ✔ True
18.True/False. The granularity in PB for denials reporting is one BDC record
for every payment/charge/reason code combination. - ANSWER ✔ True
19.True/False. The granularity in HB for denials reporting is one BDC record
for every payment/charge/reason code combination. - ANSWER ✔ False.
The granularity of HB BDCs can be summarized as one BDC for every
remittance code on a claim since BDC records are tracked at the bucket
level. Because buckets store payer‐specific information for a hospital
account, we can track the denials sent by payers and their reasons.
, 20.What's the purpose of Single Billing Office? - ANSWER ✔ To send one
statement to guarantors with their portion for both PB and HB charges
21.What database objects that store guarantors? - ANSWER ✔ Account &
GuarantorDim
22.You are writing a query about transactions in August 2021. You would like
the result set to be the same whether you run it in September 2021 or March
2022. - ANSWER ✔ Postdate
23.A guarantor account has tracked $100 in PB charges and $300 in HB
charges. Using Account table, what column(s) do you need to display the
total balance for this guarantor? - ANSWER ✔
ACCOUNT.TOTAL_BALANCE + ACCOUNT.HB_BALANCE
24.What transaction type does a refund have? - ANSWER ✔ Debit Adjustment/
Debit Increases AR
25.Shlomo sees their PCP for a physical. Shlomo's father Yosef is the owner of
the insurance policy that pays for most of the visit. He also receives the
balance due after insurance has paid, and he is
ultimately responsible for paying that balance. In which of the following
roles is Yosef acting? - ANSWER ✔ Subscriber & Guarantor
26.A PB charge with an ID of 56789 is posted and sent on a claim. The
organization waits for a while & then resends the charge on another claim.
27.How many rows in CLARITY_TDL_TRAN with TX_ID= 56789 will be
created as a result? - ANSWER ✔ 3 Rows. The original posting is a row of
detail type 1. Each time the charge is sent on a claim is a new row of detail
type 50.
