Which Table(s) would you use to look at current information about transaction values?
Which Table would you use to look at historical detailed information about transactions?
CLARITY_TDL_TRAN or CLARITY_TDL_AGE
Which table includes charges, payments, adjustments, distribution/matching, actions, claims, and bills?
Which table would you use to get current transaction info without needing to sum multiple detail types?
ARPB_* tables mainly the ARPB_TRANSACTIONS
Which table would you need to look at current actions performed on PB transactions?
Which table would you use to look for past financial information or reports needing matching information when the ARPB tables do not contain all the info needed?
What table would you use to look at transactions with a detail type of 60 & 61 only?
Which tables would you use for a Rollforward Report and how would you join then?
CLARITY_TDL_AGE to CLARITY_TDL_TRAN by TDL_ID
What table would you use if you wanted to view basic information about the procedure and it’s charge review history?
PRE_AR_CHG (Contains one row for each line of each TAR record)
What table contains the current status of the TAR record and in what column would you find this status?
What table would you use to find the basic information about the history of a TAR record?
Which table would you use for charge review activity auditing
Which table contains specific values changed in the TAR including what the old value was and what the new value is?
What table would you use if you wanted information on what rules a charge session violated?
What table contains 1 row for each workqueue a TAR record is in as of the last extract?
Where are charges stored in the charge router?
UNIVERSAL CHARGE LINE (UCL)
Where is the information about grouped charges stored?
UNIVERSAL CHARGE SESSION (UCS)
Where are the messages stored for changes in charge sources and destinations in the Charge Router?
UNIVERSAL CHARGE MESSAGE (UCM)
Which table contains basic information for a workqueues universal charge sessions?
Which table contains universal charge sessions that are in review workqueues?
Which table contains general administrative information on PB claim edit workqueues?
Which table contains a list of authorized users for Claim Edit Workqueues?
What table gives a daily snapshot of how much was contained in a workqueue and how its size has changed over time?
Which table contains 1 row for each claim that is or has been in the claim error pool and updates records of claims that are still in the pool but leaves the records relating to claims that are no longer in the error pool?
What table contains information about errors on a claim that have already been corrected as well as current errors?
Which table contains 1 row for each workqueue a claim is in for each day and contains information about the workqueues and shows the workqueue was previously in as well as currently in?
Which table hold info about the claim edit workqueue history for both PB and HB and contains 1 row for every error a claim has when a claim is worked per user/workqueue/day combination?
Which table holds the information collected for claim edit workqueue productivity?
What table includes information about account workqueue settings?
Which tables contains information about the activities performed in a workqueue, the user that performed the activities and when the activities were performed?
Which table contains information about the amounts in various pools of the workqueue on a day to day basis?