Performing Query Functions

The CA PMA Chargeback Query option enables you to request information about the data in the:

CCCTAB (Consolidated Calculated Charges Table)
CCCMOD (Consolidated Calculated Charges Modified Table)
BUDTAB (Budget Table)
DBCRTAB (Debit and Credit Table)

CA PMA Chargeback, using the information you provide, generates the appropriate SQL (Structured Query Language) commands to retrieve the requested data. The Query functions allow you to save, update, and reexecute those queries you use most frequently.

The Query option discussed in this chapter is executed when you select Query from the CA PMA Chargeback Primary Panel's action bar. The Query pull-down, shown below, then appears. Make other selections by placing your cursor next to the function you want to perform and pressing the Enter key. You can also make selections by entering the mnemonic (either the first letter or the number) of the function in the fast path area of the Query pull-down.

  USERID                     CA PMA Chargeback                MM/DD/YY HH:MM:SS
  __    Acctdefs   Cbdefs   Query   Data   Period   Options   Exit   Help
                 --------------------
                 |       Query       |
                 |                   |
                 | _ 1. Charge       |
                 |   2. Budget       |
                 |   3. Debit/Credit |
                 |                   |
                 |___________________|
                 |                   |
                 | F12=Cancel        |
                 |___________________|
 
 
 
 
 
 
 
 
 
 Command ===> ____________________________________________________________
 F1=Help  F3=Exit  F4=Prompt  F9=Command  F10=Action Bar  F12=Cancel  PA1=Susp

The Query pull-down enables you to perform the following queries:

1. Charge

Used to display data from the:

CCCTAB: Consists of fields such as ORD Type, Charge Element, and Qualifier
CCCMOD: Similar to the CCCTAB table in structure but generated by the batch forecast process
BUDTAB: Consists of budget information, such as Budget Amount and description
DBCRTAB: Consists of debit and credit information

Charge query also allows you to save favorite queries for reuse.

Note: It is important to remember that the CCCTAB is a summary table of detail records. The results of query execution are, therefore, also summary data.

2. Budget

Use this function to query only the contents of the BUDTAB.

3. Debit/Credit

Use this function to query only the contents of the DBCRTAB table.

Note: To see a complete listing of all the fields in the CCCTAB, CCCMOD, BUDTAB, and DBCRTAB tables, refer to Appendix A.

The remainder of this chapter describes each of these functions.