GIPS Toolkit: Generic Interfaces
- Pamela Totas (Deactivated)
- Jacob Mathews (Deactivated)
Generic Entity Interface
The GIPS Toolkit requires each entity to be set up. If you are loading portfolio performance and not using the Calculation Toolkit, you need to set up entities for your portfolios. If you are loading benchmarks, refer to Index Toolkit.
Interface Details
The generic Entity interface is a generic stream available in Message Center in the CSV or STAR formats:
Eagle_Default_In_Csv_Entity
Eagle_Default_In_Star_Entity
See the Supported Generic Interfaces V17 Wiki for more details.
In this section
- 1 Generic Entity Interface
- 1.1 Interface Details
- 1.2 Columns Used
- 2 Generic Benchmark Assignment Interface
- 2.1 Interface Details
- 2.2 Columns Used
- 3 Generic ACOM Membership Interface
- 3.1 Interface Details
- 3.2 Columns Used
- 4 Generic GIPS Disclosure Interface
- 4.1 Interface Details
- 4.2 Columns Used
- 5 Generic Performance Interface
- 5.1 Interface Details
- 5.2 Columns Used
- 6 Generic FX Rates Interface
- 6.1 Interface Details
- 6.2 Columns Used
Columns Used
The following table shows columns used by the GIPS Toolkit.
Database Column | Table | Tag | Required? | Purpose |
|---|---|---|---|---|
ENTITY_TYPE | ENTITY | 1105 | Y | Type of entity |
ENTITY_NAME | ENTITY | 1164 | Y | Name of entity |
BASE_CURRENCY | ENTITY | 86 | Y | Base currency of entity |
INCEPTION_DATE | ENTITY | 1138 | Y | Inception date of entity |
TERMINATION_DATE | ENTITY | 1161 | N | Termination date of entity |
DISCRETIONARY_FLAG | ENTITY_EXTENSION | 2508 | N | Constituent inclusion characteristic |
DOMICILE | ENTITY_EXTENSION | 2509 | N | Constituent inclusion characteristic |
FEE_FLAG | ENTITY_EXTENSION | 2510 | N | Constituent inclusion characteristic |
INDUSTRY | ENTITY_EXTENSION | 2511 | N | Constituent inclusion characteristic |
MINIMUM_CASH_PCT | ENTITY_EXTENSION | 2512 | N | Constituent inclusion characteristic |
MINIMUM_MV | ENTITY_EXTENSION | 2513 | N | Constituent inclusion characteristic |
STRATEGY | ENTITY_EXTENSION | 2514 | N | Constituent inclusion characteristic |
SUB_STRATEGY | ENTITY_EXTENSION | 2515 | N | Constituent inclusion characteristic |
Generic Benchmark Assignment Interface
GIPS performance reporting requires each composite to have a comparative benchmark assigned. If you are loading portfolio performance and not using the Calculation Toolkit, you need to set the primary benchmark assignment for your portfolios. If you are loading benchmarks, refer to Chapter 3: Index Toolkit.
Interface Details
The generic Benchmark Assignment interface is a generic stream available in Message Center in the CSV or STAR formats:
Eagle_Default_In_Csv_Benchmark_Assignment
Eagle_Default_In_Star_Benchmark_Assignment
See the Supported Generic Interfaces V17 Wiki for more details.
Columns Used
The following table shows columns used by the GIPS Toolkit.
Database Column | Table | Tag | Required? | Purpose |
|---|---|---|---|---|
ENTITY_DETAIL_ID | ENTITY_DETAIL | 2539 | Y | Unique identifier for benchmark entity |
ENTITY_TYPE | ENTITY_DETAIL | Not Needed | Y | Type of assignment, should always be INDX |
LIST_ORDER | ENTITY_DETAIL | 2540 | Y | Benchmark definition number, should be 1 for primary benchmark |
PROCESS_ACROSS_CHANGES | ENTITY_DETAIL | 2541 | N | Enable Process Across Changes for the assignment |
Generic ACOM Membership Interface
The GIPS Toolkit calculations require constituent membership data for each composite entity. If you need to load membership from another system, the generic ACOM Membership interface provides this capability.
Interface Details
The generic ACOM Membership interface is a generic stream available in Message Center in the CSV or STAR formats:
eagle_default_in_csv_gips_composite_membership
eagle_default_in_star_gips_composite_membership
See the Supported Generic Interfaces V17 Wiki for more details.
Columns Used
The following table shows columns used by the GIPS Toolkit.
Database Column | Table | Tag | Required? | Purpose |
|---|---|---|---|---|
COMPOSITE_ID | ENTITY | 1153 | Y | Composite Id |
ACCOUNT | ENTITY | 5 | Y | Constituent Id |
REPORT_START_DATE | ENTITY_RANGE_DETAILS | 220 | Y | Constituent Inclusion Date |
REPORT_END_DATE | ENTITY_RANGE_DETAILS | 221 | Y | Constituent Exclusion Date |
COMMENTS | ENTITY_RANGE_DETAILS | 12075 | Y | Constituent Inclusion Comment |
END_COMMENTS | ENTITY_RANGE_DETAILS | 2520 | Y | Constituent Exclusion Comment |
Generic GIPS Disclosure Interface
GIPS reporting require disclosures for composite reporting.
Interface Details
The generic GIPS Disclosure interface is a generic stream available in Message Center in the CSV or STAR formats:
eagle_default_in_csv_gips_disclosures
eagle_default_in_star_gips_disclosures
See the Supported Generic Interfaces V17 Wiki for more details.
Columns Used
The following table shows columns used by the GIPS Toolkit.
Database Column | Table | Tag | Required? | Purpose |
|---|---|---|---|---|
REPORT_END_DATE | DISCLOSURE | 221 | Y | Effective Date of Disclosure |
DISCLOSURE_NAME | DISCLOSURE | 2521 | Y | Name of Disclosure |
DISCLOSURE_TYPE | DISCLOSURE | 2522 | Y | Type of Disclosure |
GIPS_DESCRIPTION | DISCLOSURE_DETAIL | 2523 | Y | Description of Disclosure |
GIPS_DESCRIPTION_FIELD1 | DISCLOSURE_DETAIL | 2524 | N | Dynamic Text Attribute |
GIPS_DESCRIPTION_FIELD2 | DISCLOSURE_DETAIL | 2525 | N | Dynamic Text Attribute |
GIPS_DESCRIPTION_FIELD3 | DISCLOSURE_DETAIL | 2526 | N | Dynamic Text Attribute |
GIPS_DESCRIPTION_FIELD4 | DISCLOSURE_DETAIL | 2527 | N | Dynamic Text Attribute |
GIPS_DESCRIPTION_FIELD5 | DISCLOSURE_DETAIL | 2528 | N | Dynamic Text Attribute |
GIPS_DESCRIPTION_FIELD6 | DISCLOSURE_DETAIL | 2529 | N | Dynamic Text Attribute |
GIPS_DESCRIPTION_FIELD7 | DISCLOSURE_DETAIL | 2530 | N | Dynamic Text Attribute |
GIPS_DESCRIPTION_FIELD8 | DISCLOSURE_DETAIL | 2531 | N | Dynamic Text Attribute |
GIPS_DESCRIPTION_FIELD9 | DISCLOSURE_DETAIL | 2532 | N | Dynamic Text Attribute |
GIPS_DESCRIPTION_FIELD10 | DISCLOSURE_DETAIL | 2533 | N | Dynamic Text Attribute |
GIPS_DESCRIPTION_FIELD11 | DISCLOSURE_DETAIL | 2534 | N | Dynamic Text Attribute |
GIPS_DESCRIPTION_FIELD12 | DISCLOSURE_DETAIL | 2535 | N | Dynamic Text Attribute |
GIPS_DESCRIPTION_FIELD13 | DISCLOSURE_DETAIL | 2536 | N | Dynamic Text Attribute |
GIPS_DESCRIPTION_FIELD14 | DISCLOSURE_DETAIL | 2537 | N | Dynamic Text Attribute |
GIPS_DESCRIPTION_FIELD15 | DISCLOSURE_DETAIL | 2538 | N | Dynamic Text Attribute |
Generic Performance Interface
The GIPS Toolkit requires performance data for each constituent portfolio entity. If you are not using the Calculation Toolkit, this interface is used for loading portfolio and/or composites. If you are loading benchmarks, refer to Index Toolkit.
Interface Details
The generic Performance interface is a generic uploader available in the PIPE format under:
Eagle Generic Interfaces (EGLGENERIC) > Performance (PRF)
See the Supported Generic Interfaces V17 Wiki for more details.
Columns Used
The following table shows columns used by the GIPS Toolkit.
Database Column | Table | Required? | Purpose |
|---|---|---|---|
PSR_USER_FLOAT7 | PERF_SEC_RETURNS | Y | Gross investment base |
PSR_USER_FLOAT8 | PERF_SEC_RETURNS | Y | Gross return |
PSR_USER_FLOAT50 | PERF_SEC_RETURNS | Y | Net Return |
ABAL | PERF_SEC_RETURNS | Y | Gross Asset Balance |
PSR_USER_FLOAT1 | PERF_SEC_RETURNS | Y | Gross Beginning Market Value |
PSR_USER_FLOAT2 | PERF_SEC_RETURNS | Y | Gross Ending Market Value |
PSR_USER_FLOAT5 | PERF_SEC_RETURNS | Y | Gross Total Flows |
Generic FX Rates Interface
On the Fly Performance reporting in an alternative currency requires FX rates to be loaded.
Interface Details
The generic FX Rates interface is a generic stream available in Message Center in the CSV or STAR formats:
Eagle_Default_In_Csv_Fxrate
Eagle_Default_In_Star_Fxrate
See the Supported Generic Interfaces V17 Wiki for more details.
Columns Used
The following table shows columns used by the GIPS Toolkit.
Database Column | Table | Tag | Required? | Purpose |
|---|---|---|---|---|
SPOT_RATE | FX_RATES | 96 | Y | FX rate |