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:
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.Complete the options on the PACE Dictionaries Table Query panel.
You must specify a Source Name of EAGLE PACE.Under Result Options, in the Format area, click Grid or Advanced Report for the report view you want.
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.
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 |
---|---|
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. |
Â