...
The following table lists the key fields in the POSITION DETAIL table that are used in performance calculations.
Column | Description |
---|---|
POSITION_ID | Stores the position identifier, which joins to the POSITION table. |
POSITION_DETAIL_ID | Stores the unique value. |
SECURITY_ALIAS | Stores the security alias, which joins to the security. |
MARKET_VALUE | Stores the market value that is used to calculate the returns, excluding income. |
MARKET_VALUE_INCOME | Stores the market value income that is used to calculate the returns, including income. |
An effective date column exists in the POSITION_DETAIL table in the HOLDING database. The Position Data Maintenance module populates the position detail effective date column.
Anchor | ||||
---|---|---|---|---|
|