Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Dictionaries represent the grouping structure of the performance data created by Eagle Performance. They control the way in which Eagle Performance groups and sorts the information that is displayed in reports. The terms dictionary, rollup model, and performance model are used interchangeably.

For information about viewing and editing performance models, see Work with Performance Models (Dictionaries).

Info

If you plan to use the Performance Analysis report to generate results in languages in addition to English, you may also need to load multi-lingual data for Code Values that describe performance model nodes. For more information, see the Performance Analysis and Reporting User Guide.


On this page

Table of Contents
maxLevel3
indent2 px



Dictionary information is stored in the RULES database which contains the following tables: DICTIONARY, DICTIONARY_FORMAT, DICTIONARY_DETAIL, and BUSINESS_CALENDAR.

Anchor
_Toc521324088
_Toc521324088
DICTIONARIES Table

This table stores the segment definition of the performance model. It contains biographic information, such as the name, owner, source, and type. Performance models all have a type of "P." The following table lists the fields that are used for performance calculations.

Column

Description

DICTIONARY_ID

Stores a unique segment model ID used in the PERF_SUMMARY table.

DICTIONARY_NAME

Stores the name of the segment model.

DICTIONARY_TYPE

Stores the dictionary type. Values include "P," which represents a performance segment model. Otherwise, it is NULL.

Caption name


The following figure shows the DICTIONARIES table.

Dictionaries Table Image Modified

Anchor
RTF390037003700370035003a00
RTF390037003700370035003a00
Anchor
_Toc337537607
_Toc337537607
Anchor
_Toc361231196
_Toc361231196

When the system creates an entry for a performance model in the DICTIONARIES table, it sets the DICTIONARY_OWNER column and the DICTIONARY_OWNER_ID column to a lower case value of either pace_masterdbo (if you use Oracle) or a value of sa (if you use SQL). It assigns these values when it generates a new performance model through running a Performance Calculation report or using the generic Performance data uploader.

The following specific dictionary data tables are used in performance calculations.

Anchor
_Toc521324089
_Toc521324089
DICTIONARY_FORMAT Table

This table stores the performance model segment levels, for example fund, country, sector. The following table lists the key fields that are used in performance calculations.

Column

Description

DICTIONARY_ID

Stores the performance model ID, which joins to the DICTIONARIES table.

DICTIONARY_LEVEL

Stores the dictionary level. Level ID 1 represents the Total Fund level for a performance model. Each row defines the next level of the performance model.

DICTIONARY_LEVEL_DESC

Stores the level description.

The following figure shows the DICTIONARY_FORMAT table.

Dictionary Format Table Image Modified

Anchor
RTF370037003300380038003a00
RTF370037003300380038003a00
Anchor
_Toc337537608
_Toc337537608
Anchor
_Toc361231197
_Toc361231197

Anchor
_Toc521324090
_Toc521324090
DICTIONARY_DETAIL Table

This table provides the detail for each node in the performance model. The following table lists the key fields that are used in performance calculations.

Column

Description

DICTIONARY_ID

Stores the dictionary ID, which links to the PERF_SUMMARY table.

DICT_L1_CODE_VALUE–DICT_L8_CODE_VALUE

Defines each layer of the model.

DICTIONARY_DETAIL_ID

Stores the dictionary detail ID, which is a unique instance.

The following figure shows the DICTIONARY_DETAIL table.

Dictionary Detail Table Image Modified

Anchor
RTF310039003500320033003a00
RTF310039003500320033003a00
Anchor
_Toc337537609
_Toc337537609
Anchor
_Toc361231198
_Toc361231198
 

Anchor
_Toc521324091
_Toc521324091
BUSINESS_CALENDAR Table

This table defines the business days, month, quarter and year-end. The following table lists data for this table.

Column

Description

BUSINESS_DATE

Stores the calendar date.

DAILY_FLAG

Stores the daily flag. Values include:
1 – If the date is business day.
0 – If the date is not.

MONTH_END_FLAG

Stores the month end flag. Values include:
1 – If the date is a month-end.
0 – If the date is not.

QTR_END_FLAG

Stores the quarter end flag. Values include:
1 – If the date is a quarter-end.
0 – If the date is not.

YEAR_END_FLAG

Stores the year end flag. Values include:
1 – If the date is a year-end.
0 – If the date is not.