Position Look Through Details Model

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

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

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.

Create Mapping for Details Option