PB Tables

Card Set Information

Author:
ruyguy
ID:
31503
Filename:
PB Tables
Updated:
2010-08-27 16:39:51
Tags:
PB Table Questions
Folders:

Description:
PB Test
Show Answers:

Home > Flashcards > Print Preview

The flashcards below were created by user ruyguy on FreezingBlue Flashcards. What would you like to do?


  1. Which Table(s) would you use to look at current information about transaction values?
    ARPB_*
  2. Which Table would you use to look at historical detailed information about transactions?
    CLARITY_TDL_TRAN or CLARITY_TDL_AGE
  3. Which table includes charges, payments, adjustments, distribution/matching, actions, claims, and bills?
    CLARITY_TDL_TRAN
  4. Which table would you use to get current transaction info without needing to sum multiple detail types?
    ARPB_* tables mainly the ARPB_TRANSACTIONS
  5. Which table would you need to look at current actions performed on PB transactions?
    ARPB_TX_ACTIONS
  6. 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?
    CLARITY_TDL_TRAN
  7. What table would you use to look at transactions with a detail type of 60 & 61 only?
    CLARITY_TDL_AGE
  8. 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
  9. 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)
  10. What table contains the current status of the TAR record and in what column would you find this status?
    PRE_AR_CHG.CHARGE_STATUS_c
  11. What table would you use to find the basic information about the history of a TAR record?
    PRE_AR_CHG_HX
  12. Which table would you use for charge review activity auditing
    CHG_REVIEW_ACT_AUD
  13. Which table contains specific values changed in the TAR including what the old value was and what the new value is?
    CHG_REVIEW_ACT_AUD
  14. What table would you use if you wanted information on what rules a charge session violated?
    CHG_REVIEW_WQRULES
  15. What table contains 1 row for each workqueue a TAR record is in as of the last extract?
    CHG_REVIEW_WORKQUE
  16. Where are charges stored in the charge router?
    UNIVERSAL CHARGE LINE (UCL)
  17. Where is the information about grouped charges stored?
    UNIVERSAL CHARGE SESSION (UCS)
  18. Where are the messages stored for changes in charge sources and destinations in the Charge Router?
    UNIVERSAL CHARGE MESSAGE (UCM)
  19. Which table contains basic information for a workqueues universal charge sessions?
    CHGRTR_REVIEW_WQ
  20. Which table contains universal charge sessions that are in review workqueues?
    CHRGRTR_WQ_ITEMS
  21. Which table contains general administrative information on PB claim edit workqueues?
    CLAIM_EDIT_WQ
  22. Which table contains a list of authorized users for Claim Edit Workqueues?
    CLAIM_EDIT_WQ_USER
  23. What table gives a daily snapshot of how much was contained in a workqueue and how its size has changed over time?
    CLAIM_EDIT_WQ_HX
  24. 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?
    CLM_EDIT_WQ_CLM
  25. What table contains information about errors on a claim that have already been corrected as well as current errors?
    CLM_EDIT_WQ_ERROR
  26. 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?
    CLM_EDIT_WQ_STATUS
  27. 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?
    CE_WQ_PRODUCTIVITY
  28. Which table holds the information collected for claim edit workqueue productivity?
    CE_WQ_PRODUCTIVITY
  29. What table includes information about account workqueue settings?
    ACCT_WQ
  30. Which tables contains information about the activities performed in a workqueue, the user that performed the activities and when the activities were performed?
    ACCT_WQ_ACTVTY
  31. Which table contains information about the amounts in various pools of the workqueue on a day to day basis?
    ACCT_WQ_PRDVTY

What would you like to do?

Home > Flashcards > Print Preview