Transactions: Professional Billing (DBO, Columns)

Question 1

There are two Clarity tables used to track PB transactions. What are they and what do they do?

Answer 1

1. ARPB_TRANSACTIONS - Displays the current state of the PB transaction
2. CLARITY_TDL_TRAN - Tracks transactions over time

(Aug. 2021, 3.3)

Question 2

Name that table:
• Has one row per PB transaction (ETR)
• All data in this table is current
• Rows are updated when aspects of the transaction change

Answer 2

ARPB_TRANSACTIONS

Aug. 2021, 3.4

Question 3

What Clarity table is primarily used for getting a look at an organization’s current PB AR and for displaying various characteristics of transactions?

Answer 3

ARPB_TRANSACTIONS

Aug. 2021, 3.4

Question 4

What is the granularity of CLARITY_TDL_TRAN?

Answer 4

One row for every PB transaction and events that happen to those transactions: their details.

(Aug. 2021, 3.7)

Question 5

When does CLARITY_TDL_TRAN get a new row?

Answer 5

Each time an action occurs on a PB transaction.

Aug. 2021, 3.7

Question 6

What is CLARITY_TDL_TRAN designed to do?

Answer 6

To make adding the active AR amounts simple.

Aug. 2021, 3.12