...
Column | Description |
|---|---|
ENTITY_ID | Stores a unique identifier for each entity |
ENTITY TYPE | Tells the system how to treat a particular entity in return calculations and reports, such as portfolio or composite. For example, a return calculation for a composite entity type combines the holdings and cash flows across portfolios into a single aggregate. |
BASE_CURRENCY | Stores the base currency. Used in reports that do currency conversions to determine the from currency. |
INCEPTION_DATE | Stores the earliest date from which you link returns in this column. Used to calculate inception-to-date returns. |
TERMINATION_DATE | Stores the termination date. Used to calculate multi-period returns. |
...
Because June 30 is the date you need to use to count the dayssincedays since-inception for annualization purposes, you need to store this data in the INCEPTION_DATE column.
...