System Admin

The Data Dictionary Explained

132 views June 21, 2018 June 28, 2018 Leandi Kolver 2

The Data Dictionary is the first step in setting up a Client’s Kurtosys Instance.

It’s where you build the framework or home for the data you will be loading into Kurtosys. Without the Data Dictionary Properties, your data cannot be accepted as the system will not know where to put it. Each of the data values loaded onto Kurtosys will need to be assigned to a Property.

 

 

The Data Dictionary is found under System Administration.

Each Property that is added needs to be assigned to a system Entity. For Fund related data entities include FUND (Fund assets), CLSS (Share classes) and BMRK (Benchmarks). For Investment related data the entity is ACCT (Accounts).

There are a number of Property Categories within the Data Dictionary:

Properties – General Fund related properties like ISIN, Bloomberg code, Country, Launch date etc.

Allocations – The categories into which financial assets are divided e.g. Geographical regions, Industry sector.

Statistics – Any statistical metrics and comparisons such as a fund performance or risk related statistics that are updated periodically.

Timeseries – Any data that is collected over a period of time and needs to be recorded and reported to show progress and change.

Commentaries – Paragraphs of information specific to a Fund or Fund type e.g. Portfolio overviews and performance summaries.

Disclaimers – statements types that intend to specify or delimit the rights and obligations that are exercised and enforced by the financial institutions.

Cultures – Different languages you will be targeting and providing content in e.g. en-GB, de-DE.

DocumentMeta – Types of tags you may want to attach to documents for easy search or reference e.g. isin, document type.

 

Was this helpful?