Performing Query Functions › Charge Query Panels › Charge Query Specifications Entry Field Options › Example 1: Using the Srt Option

Example 1: Using the Srt Option

To display the contents of the CCCTAB by Period Number:

• Set the Summarize and Break fields to N (see A. below)
• Specify Y in the Srt column next to Period Number (see B. below)

  USERID                      CA PMA Chargeback               MM/DD/YY HH:MM:SS
  __    Acctdefs   Cbdefs   Query   Data   Period   Options   Exit   Help
 
 
 +-- CBQQRYS ------------- Charge Query Specifications ------------------------+
 |      Panel   Exit   Help                                                    |
 | --------------------------------------------------------------------------- |
 | Type information for Query CPUCOST   Desc CPU COST FOR PER.1-3    Table TAB |
 |             A.                                                              |
 | Summarize N  Break N  Bud/DBCR N           Version : PROD PROD              |
 |                                   Brk Srt                            Op Sum |
 | ORD Type . . . .                   N      Rec Count                   > SUM |
 | Charge Element .                   N      Units  . .                  > SUM |
 | Qualifier  . . .                   N   B. Rate . . .                  > AVG |
 | Period Number  .       thru        N   Y  Charge . .                  > SUM |
 | DIVISION . . . .                   N                                        |
 | DEPARTMENT . . .                   N                                        |
 |                                                                             |
 |                                                                             |
 |                                                                             |
 |   F2=Exec   F5=Save   F6=Delete   F11=Refresh                               |
 +-----------------------------------------------------------------------------+
  Command ===> ____________________________________________________________
  F1=Help  F3=Exit  F4=Prompt  F9=Command  F10=Action Bar  F12=Cancel  PA1=Susp

The next panel shows the results of specifying a Y in the Srt column for the Period Number field. Note the following:

• CA PMA Chargeback displays the entire contents of the CCCTAB (see A. below) since there is no query criteria.
• The panel below shows the fields contained in one record of the CCCTAB table.
• CA PMA Chargeback sorts all records by Period Number. The row shown below is the first record in the CCCTAB that falls within Period 1 (see B. below).

  USERID                   CA PMA Chargeback                  MM/DD/YY HH:MM:SS
  __    Acctdefs   Cbdefs   Query   Data   Period   Options   Exit   Help
 
 
 +-- CBQQRYD ----------------- Charge Query Results ---------------------------+
 |       Panel   Exit   Help                                                   |
 | ------------------------------------------------------------------------A.- |
 |  Table  . . . . . : TAB                  More: + - 1     Row: 0001 of 0021  |
 |  Version  . . . . : PROD PROD                                               |
 |  ORD Type . . . . : MBJ               Record Count :                1       |
 |  Charge Element . : CPU-CHARGE        Units  . . . :          1.00000       |
 |  Qualifier  . . . : SHIFT1            Rate . . . . :           .50000       |
 |  Period Number  . : 1    B.           Charge . . . :           .50000       |
 |  Modifier . . . . : WEEKEND           Debit Amt  . :                        |
 |  Split/Modified . : NY                Credit Amt . :                        |
 |  DIVISION . . . . : RESTON            Adjust Charge:                        |
 |  DEPARTMENT . . . : TECHWRIT          Budget . . . :                        |
 |                                       % of Budget  :                        |
 |                                                                             |
 |                                                                             |
 |   F7=Bkwd   F8=Fwd                                                          |
 +-----------------------------------------------------------------------------+
  Command ===> ____________________________________________________________
  F1=Help  F3=Exit  F4=Prompt  F9=Command  F10=Action Bar  F12=Cancel  PA1=Susp