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 |
...