Performing Query Functions › Budget Query Specifications Panel › Budget Query Specifications Entry Field Options

Budget Query Specifications Entry Field Options

CA PMA Chargeback supports standard SQL queries. The format of the SQL query is:

SELECT fieldname FROM tablename WHERE (condition) {ORDER BY fields}

The following sections discuss how to use the various entry fields with processing options to generate SQL queries.

SELECT (fieldname).....

You can select fields for viewing from the BUDTAB table in one of two ways:

• Detail report
• Summary-with-breaks report

If you select a detail report, the Summarize and Break option are both set to N. This displays all fields of the records from the BUDTAB table meeting any selection criteria.

If you select a summary-with-breaks report, the Summarize and Break options are both set to Y. CA PMA Chargeback groups results based on the fields you select in the Brk column. To select the fields you want results grouped by, enter Y in the appropriate row in the Brk column.

Note: Make sure the Break field is set to Y, otherwise CA PMA Chargeback ignores the values entered in the Brk column.

The Break option cannot be selected without also selecting the Summarize option.

from (tablename).....

The Budget Query Specifications panel allows access to information contained in the BUDTAB. This is the default value and cannot be changed.

WHERE (condition).....

If you wish to select only those records that meet specific criteria, you can add a conditional test next to any of the panel fields. This test can be a previously defined user name, or a number. The Period Number field accepts numeric values. All other entry fields accept only predefined user names.

Note: You can specify query criteria, regardless of the result format you select.