Transactions: Basics (DBO, Columns)

Question 1

BillingTransactionFact contains one row per ____________________________ and ___________________________ .

Answer 1

• Hospital Billing transaction
• Professional Billing detail

(Aug. 2021, 2.15)

Question 2

In BillingTransactionFact, what column should you use to distinguish between hospital and professional rows?

Answer 2

BillingSystemType

Aug. 2021, 2.15

Question 3

Name the Caboodle table.

Each row is either generated from PB or HB, and many columns are applicable to only one or the other.

Answer 3

BillingTransactionFact

Aug. 2021, 2.15

Question 4

What Clarity table would you use to report on RVUs in Professional Billing?

Answer 4

V_ARPB_RVU_DATA

Aug. 2021, 2.20

Question 5

What Clarity table would you use to report on RVUs in Hospital Billing?

Answer 5

HSP_TRANSACTIONS

Aug. 2021, 2.20

Question 6

What Caboodle table holds cost information for each procedure?

Answer 6

BillingTransactionFact
• This table includes direct, indirect, fixed, and variable costs.

(Aug. 2021, 2.20)

Question 7

What Clarity tables provide cost information on the transaction level for PB and HB?

Answer 7

• PB: ARPB_TX_COST
• HB: HSP_TX_COST

These tables include direct, indirect, fixed, and variable cost for charges and include the most recent date the cost was assigned to the charge.

(Aug. 2021, 2.20)