Skip to main content

Portfolio Type

Data Dictionary - Entity Table: Portfolio_Type#

Lookup table with the Portfolio types. This is user defined field that can be used to classify differnet portfolios based on internal business rules. Example: Actual, External, Simulated.

Primary Key ('id').ENGINE = InnoDB..
Column NameData Type1PK Primary Key, NN-Not Null, NullExample
idBIGINT(12)PK, NNPrimaryKey-ID,(auto creates)
NameVARCHAR(45)NULLRealExample: four types of portfolios: Real, Simulated, Actual, External