Skip to main content

Asset Classification Structure

Data Dictionary- Table: Asset_Classification_Structure#

Asset Classification represents groups of instruments with similar financial characteristics, similar behavior in the markets or placed under similar regulations. Best practice for portfolio management relies on Strategic Asset Allocation and Tactical Asset Allocation to maintain a diversified portfolio with balanced risk and reward (as defined by MPT). In Glue, the Asset Classification tables permit the creation of arbitrary asset groups, e.g based on financial instrument, region, industry sector, etc, which can be hierarchicly structured. The Asset_Classification_Structure table defines the hierarchy between different asset classification nodes (Asset_Classification_Node table).

Primary Key ('id').ENGINE = InnoDB..
Column NameData TypePK Primary Key, NN-Not Null, NullExampleComment
idBIGINT(12)PK, NN1PrimaryKey-ID, Not Null (auto creates)
ParentBIGINT(12)NULL1Id for the top node of hierarchy (parent) of asset classification (from Asset_Classification_Node). Recommended is to store only the direct relationships between parent node and child node, not the indirect relationships (in case the depth > 2)
ChildBIGINT(12)NULL2Id for the underlying node in the hierarchy (child) of asset classification (from Asset_Classification_Node). More than one child node can be associated with parent node.
LevelINTNULL2Layer of asset classification depth e.g:2
ACParent(Parent)Asset_Classification_Node (id)NO ACTIONNO ACTION
ACChild(Child)Asset_Classification_Node (id)NO ACTIONNO ACTION
Node_idxAsset_Classification_Structure(Parent ASC)VISIBLE.
Child_idxAsset_Classification_Structure(Child ASC)VISIBLE.