Look through reporting at the detail level is supported by the Position Look Thru Details model and the Position Look Thru Details table (POSITION_LOOK_THRU_DETAILS). Valid field type are listed in the following table:
Field Class | PACE Field Class |
|---|---|
Position Detail | Holding |
Detail Calculation | |
Inference | |
Rollup | |
Rollup Calculation | |
Rollup Inference | |
Security | Rollup |
Special | Special |
Detail Calculations | |
Inference |
The POSITION_LOOK_THRU_DETAILS table contains the following columns:
Column | Type | Description |
|---|---|---|
DMART_FUND_ID | NUMBER(38) | Instance of fund, effective date, and snapshot. |
POSITION_DETAIL_ID | NUMBER(38) | If member of securitized fund, this is the position detail ID in that fund. |
DMART_CURRENCY | VARCHAR2(50) | |
SECURITY_ALIAS | NUMBER(38) | |
LOOK_THRU_ID | CHAR(8) | Entity ID of the securitized fund that directly holds the look-through position of the row. There is no value if the row shows a regular security (not a securitized fund) held by the fund. |
LOOK_THRU_LEVEL | VARCHAR2(10) | 1 for direct fund holding, 2 for indirect holding revealed after one look through, and so on. |
UPD_USER | VARCHAR2(255) | |
UPD_DATETIME | DATE |
Select the Create Mapping for Details option on the Filters/Mapping tab as shown in Create Mapping for Details Option. This option is only available when position fields are selected for the model. The Add Filter link appears when working with Performance fields.
...