View PACE Dictionaries

The PACE Dictionaries Table Query allows you to research information related to PACE dictionaries based on data stored in the DICTIONARIES, DICTIONARY_FORMAL, and DICTIONARY_DETAIL tables in the RULES database in the Eagle data warehouse.

To view PACE dictionary information:

  1. In Accounting Center, in the left navigation pane, click Reports > System Queries > STAR to PACE Direct > PACE Dictionaries Table Query.
    You see the PACE Dictionaries Table Query panel.

  2. Complete the options on the PACE Dictionaries Table Query panel.
    You must specify a Source Name of EAGLE PACE.

  3. Under Result Options, in the Format area, click Grid or Advanced Report for the report view you want.

  4. In the Location area, click Show results after submit. Or, you can click Send results to Scheduler for optimum performance when submitting ad hoc reports that involve a significant amount of data.

  5. Click Submit.
    The report appears on your desktop for the view selected. You can email the results, save them to a file in several formats, or print report results using the Form tab options.

PACE Dictionaries Table Query Panel Options

The following table lists the fields and field descriptions for the PACE Dictionaries Table Query panel.

Option

Description

Option

Description

List Dictionaries

 

Source Name

Specifies the source. You must specify EAGLE PACE.

Dictionary ID

Specifies the dictionary identifier.

Dictionary Name

Specifies the dictionary name.

Dictionary Owner

Specifies the dictionary owner.

Dictionary Owner ID

Specifies the dictionary owner identifier.

Dictionary Type

Specifies the type of dictionary.

Event Type

Displays the event type value QRY_DICTIONARY.

Partition Number

Specifies the database partition for the position.

Â