Assette designed to streamline reporting and data management for investment firms. To effectively leverage Assette’s capabilities, it’s crucial to set up specific Data Blocks that serve as the foundation for data synchronization and system functionality. This article outlines the required Data Blocks needed to get started with Assette, including their technical specifications and the necessary columns for each.
Master Data: Required Source Blocks #
Master Data is essential for ensuring that Assette has accurate and up-to-date information about accounts, products, attributes, and more. The following Source Blocks are required for this purpose:
Source_ExtractAccountsDetails #
This Data Block extracts detailed information about accounts. It’s crucial for populating Assette with account-related data.
- Required Columns:
portfoliocode(Varchar(50), Not NULL): The unique code identifying each portfolio or account.portfoliocategory(Varchar(50), Not NULL): Categorizes the portfolio. Must match Assette’s local value list. Accepted values:- Individual Account
- Consolidated
- Group
- Composite
productcode(Varchar(50), NULL): The code representing the associated product.
Note: Ensure that portfoliocategory values align with Assette’s predefined categories for proper integration.
Source_ListofAttributeTypeValues #
This Data Block provides a list of attribute types and their corresponding values, which are used to classify accounts and products within Assette.
- Required Columns:
attributetype(Varchar(150), Not NULL): The name of the attribute type (e.g., Strategy, Region).attributetypecode(Varchar(50), Not NULL): A code representing the attribute type.attributetypevalue(Varchar(200), Not NULL): The specific value of the attribute type.
Source_AccountAttributesValues #
This Data Block links accounts to their respective attributes, enabling detailed classification and filtering within Assette.
- Required Columns:
portfoliocode(Varchar(50), Not NULL): The account’s unique code.attributetype(Varchar(150), Not NULL): The attribute type name (e.g., Strategy).attributetypecode(Varchar(50), Not NULL): The code representing the attribute type (e.g., USCE).attributetypevalue(Varchar(200), Not NULL): The value of the attribute (e.g., US Small Cap Equity).
Source_ProductMasterExtract #
This Data Block contains detailed information about the products offered, which is essential for associating accounts with the correct products.
- Required Columns:
productcode(Varchar(50), Not NULL): Unique code identifying each product.productname(Varchar(150), Not NULL): The name of the product.strategy(Varchar(50), Not NULL): The strategy associated with the product.assetclass(Varchar(50), Not NULL): The asset class category.vehiclecategory(Varchar(50), Not NULL): The vehicle category. Must match Assette’s local value list. Accepted values:- Segregated
- Pooled
vehicletype(Varchar(50), Not NULL): The type of investment vehicle.performanceaccount(Varchar(50), Not NULL): The account code used for performance tracking.representativeaccount(Varchar(50), Not NULL): The account code representing the product.ismarketed(Bit): Indicates whether the product is currently marketed.
Source_CountryList #
This Data Block provides a list of countries, which is necessary for geographic classifications and compliance considerations.
- Required Columns:
code(Varchar(20), Not NULL): The country code (e.g., “us” for the United States).name(Varchar(200), Not NULL): The full country name (e.g., “United States”).
Source_ProductOfferCountries #
This Data Block specifies which products are offered in which countries, aiding in compliance and marketing efforts.
- Required Columns:
productcode(Varchar(50), Not NULL): The code of the product.countrycode(Varchar(20), Not NULL): The code of the country where the product is offered.
System Functionality: Required Source Blocks #
The following Source Blocks are necessary for Assette’s system operations, including account grouping, currency management, and country mappings.
Source_GetGroupAccountCode #
This Data Block retrieves group account codes and their associated member accounts, essential for managing consolidated or group portfolios.
- Required Columns:
portfoliocode(Varchar(50), Not NULL): The group portfolio code.memberportfoliocode(Varchar(50), Not NULL): The member account code within the group.
AccountCountryMapping #
This Data Block maps accounts to their respective countries, which is important for regional reporting and compliance.
- Required Columns:
accountcode(Varchar(50), Not NULL): The account’s unique code.country(Varchar(20), Not NULL): The country code associated with the account.
Source_SubAccountsRelationship #
This Data Block defines relationships between main accounts and their sub-accounts, enabling hierarchical account management.
- Required Columns:
code(Varchar(50), Not NULL): The code of the sub-account.groupaccountcode(Varchar(50), Not NULL): The code of the main account or group account.
CurrencyCodes #
This Data Block provides a list of currency codes and their descriptions, necessary for multi-currency reporting and analysis.
- Required Columns:
currency(Varchar(100), Not NULL): The currency code (e.g., “USD”).description(Varchar(200), Not NULL): The full description of the currency (e.g., “United States Dollar”).
Next Steps #
- Data Preparation:
- Gather all necessary data from your source systems.
- Format the data according to the specifications outlined above.
- Data Block Configuration:
- The above Data Blocks should already be availble, but require further configuration. Set up each Data Block within Assette, ensuring that the data mappings are correct.
- Validate the Data Blocks to check for errors or missing information.
- Data Synchronization:
- Initiate the data synchronization process to import the data into Assette.
- Testing:
- Verify that the data appears correctly within Assette.
- Run sample reports to ensure that the data is being utilized properly.