DB/CR Query Specifications Panel

Performing Query Functions › DB/CR Query Specifications Panel

DB/CR Query Specifications Panel

The DB/CR Query Specifications panel allows you to query the contents of the DBCRTAB. Using the prompts provided, you can:

Create an SQL query by simply filling a panel
Execute and receive the results of the query

You specify query criteria and the manner in which you want results displayed. The following processing options, located on the DB/CR Query Specifications panel, determine result format.

Summarize
Break

These two options work together to display the following results. A complete discussion on these options with sample Results panels is in DB/CR Query Specifications Processing Options through DB/CR Query Specifications Processing Options.

Summarize	Break	Results
N	N	Detail report of the records that meet any criteria specified in the DB/CR Query Specifications panel. CA PMA Chargeback displays each record separately. For each record, CA PMA Chargeback provides values for the additional fields Debit Amt, Credit Amt, and Desc.
Y	N	Summary report of those records that meet any criteria specified in the DB/CR Query Specifications panel. Result fields Debit Amt, Credit Amt, and Count appear on the DB/CR Query Specifications panel. Fields Debit Amt, Credit Amt, and Count hold summary information.
Y	Y	Summary report of those records that meet any criteria specified in the DB/CR Query Specifications panel. Result records are broken into groups based on the Brk fields you select. CA PMA Chargeback displays each group separately. For each group of records, CA PMA Chargeback provides values for the additional fields Debit Amt, Credit Amt, and Count.

The following panel shows the DB/CR Query Specifications panel on entry of Debit/Credit Query. The values shown are the default ones.

  USERID                     CA PMA Chargeback                MM/DD/YY HH:MM:SS
  __    Acctdefs   Cbdefs   Query   Data   Period   Options   Exit   Help
 
 +-- CBQCRDS -------------- DB/CR Query Specifications ------------------+
 |      Panel   Exit   Help                                              |
 | --------------------------------------------------------------------- |
 | Type information for debit/credit query. Then Execute.                |
 |                                                                       |
 | A. Summarize N  Break N              C.    Version : PROD PROD        |
 |                                     Brk                  B.           |
 | ORD Type . . . . .                   N                                |
 | Charge Element . .                   N                                |
 | Qualifier  . . . .         B.        N                                |
 | Period Number  . .       thru        N                                |
 | DIVISION . . . . .                   N                                |
 | DEPARTMENT . . . .                   N                                |
 |                                                                       |
 |                                                                       |
 |                                                                       |
 |                                                                       |
 |   F2=Exec                                                             |
 +-----------------------------------------------------------------------+
  Command ===> ____________________________________________________________
  F1=Help  F3=Exit  F4=Prompt  F9=Command  F10=Action Bar  F12=Cancel  PA1=Susp

The Version field specifies the version of the CA PMA Chargeback application being used. Only the last four characters of the Version field are available for entry. The default is the Version specified using CA PMA Chargeback's Option function. All other fields are available for entry.

Access

The DB/CR Query Specifications panel appears when one of these events occur:

You type QD in the fast path area of the Primary Panel's action bar.
You select Debit/Credit on the Query pull-down.

You return from one of the DB/CR Query Result panels.

----------------
|     Query    |__________
|  Pull-Down   |         |
|>DB/CR Query  |         v
----------------  ----------------
                  | DB/CR Query  |
                  |Specifications|
                  |     Panel    |
                  ----------------
                         ▲
                         |
                 -----------------
                 | DB/CR Query   |
                 | Result Panels |
                 |>F3            |
                 -----------------

Input:

The following DB/CR Query Specification panel fields are available for input. These input fields refer to the sample panel on page DB/CR Query Specifications Panel.

A.

Display Options

Summarize A one-character field that works with the Break option, to determine the format of results. Valid entries for this field are N and Y. The default value is N and appears when you first select the panel.

When you set the Summarize option to Y, results display in summary form, or in summary-with-breaks form (see DB/CR Query Specifications Processing Options through DB/CR Query Specifications Processing Options).

Break A one-character field that works with the Summarize field to determine result format. Valid entries for this field are N and Y. The default value is N and appears when you first select the panel.

When the Break option is Y, the Brk column is active (see C).

Note: At least one field in the Brk column must be set to Y when you select the Break option. Otherwise, CA PMA Chargeback returns an error message.

CA PMA Chargeback ignores any values entered in the Brk column, if Break is N.

The Break field is valid only with the Summarize option.

B.: Selection Criteria

Note: You can use the SQL wildcard character % alone or with any alphanumeric character string as selection criteria for these fields.

Version The last four characters of this field are available for data entry. Specify the version of CA PMA Chargeback you want to query.

ORD Type The three-character name of the output record identifier used for selection criteria. CA PMA Chargeback processes only those records with the ORD Type you specify.

Charge Element The name (up to 16 alphanumeric characters) of the Charge Element used for selection criteria. Only those records with the Charge Element you specify display.

Qualifier The name (up to 16 alphanumeric characters) of the conditional test, applied to the charge unit, used for selection criteria. CA PMA Chargeback selects only those records for which the qualifier applies.

Period Number The start of the range of accounting periods or the accounting period from which CA PMA Chargeback selects records.

thru The end of the range of accounting periods from which CA PMA Chargeback selects records.

The following entry fields indicate the accounting structures you want to query.

Note: CA PMA Chargeback displays only defined accounting structures. The examples displayed in this chapter show an accounting structure with two levels. The accounting structures you define can be different.

Division Department Enter the name of a defined accounting level whose debit and credit information you want to query.

Action

F2=Exec: Executes the query with the selections you have made.