Charge Query Panels

Performing Query Functions › Charge Query Panels

Charge Query Panels

Charge Query panels allow you to query the contents of the CCCTAB, CCCMOD, BUDTAB, and DBCRTAB tables. Using the prompts provided on each panel, you can:

Create an SQL query by simply filling in a panel
Execute and receive the results of the query
Optionally save the query for later use

The Charge Query panel set consists of the following:

Charge Query Primary panel
Charge Query List panel
Charge Query Expanded List panel
Charge Query Specifications panel

You can create or browse a query by using the Charge Query primary panel. This panel allows you to name and describe the query you want to create or browse. The name and description are important for later retrieval.

The Charge Query List panels allow you to select existing queries for update or reexecution.

You can specify query selection criteria using the Charge Query Specifications panel. This panel accepts entries and generates the outcome on different Results panels. The following processing options, located on the Charge Query Specifications panel (see Charge Query Specifications Panel), determine the format of results.

Summarize
Break
Bud/DBCR

The table that follows shows valid selections and the types of Results panel generated.

The following table shows valid combinations for processing options and descriptions of the reports panels generated. A complete discussion of these options and sample Results panels are in Charge Query Specifications Processing Options.

Summarize	Break	Bud/DBCR	Results
N	N	N	Detail report of those records that meet any criteria specified on the Charge Query Specifications panel. CA PMA Chargeback displays each record separately.
Y	N	N	One page summary report of the records that meet any criteria specified on the Charge Query Specifications panel.
Y	Y	N	Summary report of records that meet any criteria specified on the Charge Query Specifications panel. Result records are broken into groups based on the Brk fields you select. CA PMA Chargeback displays each group of records separately.
N	N	Y	Detail report displaying charge, budget, debit, and credit information.
Y	N	Y	Summary report of charge, budget, debit, and credit information.
Y	Y	Y	Summary-with-breaks report of charge, budget, debit, and credit information. CA PMA Chargeback summarizes results based on the fields selected in the Brk column.