REVDATA COG230 EXAM QUESTIONS
AND ANSWERS 2026
What's the purpose of Single Billing Office? - ANSWERSTo send one statement to
guarantors with their portion for both PB and HB charges
What database objects that store guarantors? - ANSWERSAccount & GuarantorDim
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. -
ANSWERSPostdate
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? - ANSWERSACCOUNT.TOTAL_BALANCE + ACCOUNT.HB_BALANCE
What transaction type does a refund have? - ANSWERSDebit Adjustment/ Debit
Increases AR
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? - ANSWERSSubscriber & Guarantor
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.
How many rows in CLARITY_TDL_TRAN with TX_ID= 56789 will be created as a
result? - ANSWERS3 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.
What is the purpose of matching detail types in CLARITY_TDL_TRAN? - ANSWERSTo
attribute payments to the correct dept, provider, etc.
In CLARITY_TDL_TRAN, which values are inherited from the original transaction for
subsequent detail rows? - ANSWERSTX_ID,
PROC_ID,
DEPT_ID
ORIG_SERVICE_DATE
ORIG_POST_DATE
ORIGINAL_PAYOR_ID
What values are properties of a transaction detail in CLARITY_TDL_TRAN?
, All of the other values are inherited properties of original transaction. -
ANSWERSPOST_DATE & DETAIL_TYPE
When initially posted, a PB charge is usually a debit and an adjustment is either a debit
or a credit. T/F - ANSWERST
An HB charge for $220 is initially posted as $200. When the user fixes the error, they
accidentally fix it for $2220. Seeing this mistake, the user fixes the transaction one more
time for $220. After all the fixes and reposts, ...
HOW many transactions have been added to HSP_TRANSACTIONS, and how many
are active? - ANSWERS5, and 1 is active
A hospital account has had one billing indicator and one DNB check attached. The
billing indicator has since been resolved and removed. No other billing indicators, stop
bills, or DNB checks have been
attached to the HAR. How many rows appear in HSP_ACCT_DNB_SB_HX? -
ANSWERS2 Rows
What's the granularity of HSP_ACCT_DNB_SB_HX? - ANSWERSone row per stop bill,
DNB check, or billing indicator.
A PB claim with 6 service lines is denied with one reason code. How many rows will be
added to BillingDenialFact and BillingDenialLineFact? - ANSWERS6 Rows, 6 Rows
What creates BDC record per remittance code per denied service line on a claim? -
ANSWERSPB
What stores one row per remit code per denied service line on a claim? -
ANSWERSBillingDenialLineFac
An insurance company pays for part of the balance on an HB hospital account, and the
remaining balance is moved to the next liable party ﴾liability bucket﴿. How are the
balances moved? - ANSWERSSystem adjustments
A charge is posted to an HB hospital account, then a payment is posted to the same
hospital account. Afterward, two system adjustments are posted in order to move
liability between payers.
How many lines in HSP_TRANSACTIONS will this generate? - ANSWERS4 Rows
Details are everything that happens to a transaction in either HB or PB. T/F -
ANSWERSF
A posted payment with an ID: 84884, then modified over time.
Which of the following "detail types" would have the TX_ID of the payment? -
ANSWERS2- new pymt,
32-Match Pymt >Chg,
33-Match Pymt Debit
AND ANSWERS 2026
What's the purpose of Single Billing Office? - ANSWERSTo send one statement to
guarantors with their portion for both PB and HB charges
What database objects that store guarantors? - ANSWERSAccount & GuarantorDim
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. -
ANSWERSPostdate
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? - ANSWERSACCOUNT.TOTAL_BALANCE + ACCOUNT.HB_BALANCE
What transaction type does a refund have? - ANSWERSDebit Adjustment/ Debit
Increases AR
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? - ANSWERSSubscriber & Guarantor
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.
How many rows in CLARITY_TDL_TRAN with TX_ID= 56789 will be created as a
result? - ANSWERS3 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.
What is the purpose of matching detail types in CLARITY_TDL_TRAN? - ANSWERSTo
attribute payments to the correct dept, provider, etc.
In CLARITY_TDL_TRAN, which values are inherited from the original transaction for
subsequent detail rows? - ANSWERSTX_ID,
PROC_ID,
DEPT_ID
ORIG_SERVICE_DATE
ORIG_POST_DATE
ORIGINAL_PAYOR_ID
What values are properties of a transaction detail in CLARITY_TDL_TRAN?
, All of the other values are inherited properties of original transaction. -
ANSWERSPOST_DATE & DETAIL_TYPE
When initially posted, a PB charge is usually a debit and an adjustment is either a debit
or a credit. T/F - ANSWERST
An HB charge for $220 is initially posted as $200. When the user fixes the error, they
accidentally fix it for $2220. Seeing this mistake, the user fixes the transaction one more
time for $220. After all the fixes and reposts, ...
HOW many transactions have been added to HSP_TRANSACTIONS, and how many
are active? - ANSWERS5, and 1 is active
A hospital account has had one billing indicator and one DNB check attached. The
billing indicator has since been resolved and removed. No other billing indicators, stop
bills, or DNB checks have been
attached to the HAR. How many rows appear in HSP_ACCT_DNB_SB_HX? -
ANSWERS2 Rows
What's the granularity of HSP_ACCT_DNB_SB_HX? - ANSWERSone row per stop bill,
DNB check, or billing indicator.
A PB claim with 6 service lines is denied with one reason code. How many rows will be
added to BillingDenialFact and BillingDenialLineFact? - ANSWERS6 Rows, 6 Rows
What creates BDC record per remittance code per denied service line on a claim? -
ANSWERSPB
What stores one row per remit code per denied service line on a claim? -
ANSWERSBillingDenialLineFac
An insurance company pays for part of the balance on an HB hospital account, and the
remaining balance is moved to the next liable party ﴾liability bucket﴿. How are the
balances moved? - ANSWERSSystem adjustments
A charge is posted to an HB hospital account, then a payment is posted to the same
hospital account. Afterward, two system adjustments are posted in order to move
liability between payers.
How many lines in HSP_TRANSACTIONS will this generate? - ANSWERS4 Rows
Details are everything that happens to a transaction in either HB or PB. T/F -
ANSWERSF
A posted payment with an ID: 84884, then modified over time.
Which of the following "detail types" would have the TX_ID of the payment? -
ANSWERS2- new pymt,
32-Match Pymt >Chg,
33-Match Pymt Debit
