| AccountAttributeMappingLocalDB | https://learn.assette.com/docs/accountattributemappinglocaldb/ | The Account Attribute Mapping Local Database (AccountAttributeMappingLocalDB) Data Block is used map account attributes to Assette. This Data Block should not be edited. | Interface | LOCAL DATABASE | None | VALUES | FALSE |
| AccountMaster | https://learn.assette.com/docs/account-master-data-block/ | The Account Master (AccountMaster) Data Block is an Assette System Data Block which houses account attribute data such as asset class, share class, whether the account is open or not, etc. The Account Master (AccountMaster) Data Block is a System Data Block and is not usually edited by end users, though the dependency GetAccountMetaDataForSystemBlock Data Block is expected to be edited. | Interface | NONE | None | Data Table | TRUE |
| Aprimo_api_order_status | https://learn.assette.com/docs/aprimo-api-order-status/ | The Aprimo API Order Status Data Block is used to make a GET request to the Aprimo API. The Data Block fetches information about a specific order by appending the order ID ({{id}}) to the path. | Interface | API CALL | None | Data Table | TRUE |
| Aprimo_api_post_order | https://learn.assette.com/docs/aprimo-api-post-order-data-block/ | The Aprimo API Post Order Data Block is an API forwarder and describes how to sends a request to an the Aprimo API and creates a request to download the latest version of a file without sending any notifications. The Aprimo API Post Order Data Block is not edited. | Interface | API CALL | None | Data Table | TRUE |
| Aprimo_api_records | https://learn.assette.com/docs/aprimo-api-records-data-block/ | The Aprimo API Records Data Block functions as an API key forwarder for the Assette-Aprimo integration. This block is set up by Assette after the client has provided a valid public API key from Aprimo. This Data Block is not edited. | Interface | API CALL | None | Data Table | TRUE |
| Aprimo_api_single_record | https://learn.assette.com/docs/aprimo-api-single-record-data-block/ | The Aprimo API Single Record (Aprimo_api_single_record) Data Block gets the thumbnail URL parameter for a single thumbnail. | Interface | API CALL | None | Data Table | TRUE |
| AsofDates | https://learn.assette.com/docs/as-of-dates-system-data-block/ | The As of Date (AsofDates) Data Block is an Assette System Data Block that will return the previous 24 month ends, if a client wants to derive the As of Dates from an external data source, they will need to make the necessary changes to the Data Block, otherwise no changes to the As of Date (AsofDates) System Data Block or any dependencies. | Transform | PYTHON | None | Data Table | TRUE |
| AssetClassesLocal | https://learn.assette.com/docs/asset-classes-local-data-block/ | The AssetClasses (AssetClasses) Data Block retrieves all data from the AssetClasses table without applying any filters. It fetches all columns and rows from the table and returns the results in a structured format. This Data Block cannot be edited. | Interface | LOCAL DATABASE | None | Data Table | FALSE |
| AssetClassSync | https://learn.assette.com/docs/asset-class-sync/ | Retrieves all asset class code and value pairs from Source List of Attribute Type Values Data Block (Source_ListofAttributeTypeValues) and returns the value as Data Table. This Data Block is not normally edited by end users. To update the available asset classes, see Source List of Attribute Type Values Data Block instead. | Transform | PYTHON | None | Data Table | TRUE |
| ast_fn_GetBeginEndDates | https://learn.assette.com/docs/assette-period-date-calculation-data-block/ | The Assette Period Date Calculation (ast_fn_GetBeginEndDates) Data Block is a Demo Data Block which processes different period codes, such as MTD, QTD, YTD, etc., and calculates the appropriate begin_date and end_date for each code. It reads the period universe data and uses various date patterns and logic to determine the start and end dates for a given period code. After calculating the dates, the Assette Period Date Calculation (ast_fn_GetBeginEndDates) Data Block formats them and returns the result. As an open-source demo Data Block, this Data Block may be edited as needed. | Transform | PYTHON | None | Data Table | TRUE |
| ast_fn_GetValidPeriods | https://learn.assette.com/docs/assette-get-valid-periods-data-block/ | The Assette Get Valid Periods (ast_fn_GetValidPeriods) Data Block processes a list of periods (e.g., MTD, QTD, YTD, etc.) based on parameters such as the reference date (AsofDate), fiscal year-end, and inception date. It retrieves the begin_date and end_date for each period and allows for optional filtering of not-applicable and duplicate periods. The Assette Get Valid Periods (ast_fn_GetValidPeriods) Data Block then organizes and returns the calculated date ranges in a structured format. This Data Block is open-source and may be edited as desired. | Transform | PYTHON ENVIRONMENT | None | Data Table | TRUE |
| ast_period_code_map | https://learn.assette.com/docs/assette-period-code-map-data-block/ | The Assette Period Code Map (ast_period_code_map) Data Block maps period codes (e.g., “QTD” for “Quarter to Date”) to their display name. These codes represent different time periods or financial reporting intervals such as months, quarters, years, and fiscal years. Some of the codes are for cumulative or annualized data over different periods, like the past 1, 5, or 10 years, while others are for specific quarters or fiscal years. | Interface | CONSTANT | None | VALUES | TRUE |
| AttributeTypesLocal | https://learn.assette.com/docs/attribute-types-local-data-block/ | The Attribute Types Local (AttributeTypesLocal) Data Block is used to get the list of asset classes from Assette. This Data Block cannot be edite. | Interface | LOCAL DATABASE | None | Data Table | FALSE |
| AttributeTypeValuesSync | https://learn.assette.com/docs/attribute-type-values-sync-data-block/ | The Attribute Type Values Sync (AttributeTypeValuesSync) Data Block aggregates the list of distinct strategies and vehicles and synchronizes them with Assette. The following information outlines the minimum quorum of data required for the basic functionality of Assette.
| Transform | PYTHON | None | Data Table | TRUE |
| Calculation_Python_Env | https://learn.assette.com/docs/calculation-python-environment-data-block/ | The Imports (Imports) Data Block defines the required Python libraries to be imported for the script. Each library is imported with or without an alias, depending on its usage within the code. This Data Block ensures that the necessary libraries are available for handling data manipulation, date operations, JSON parsing, and other tasks. This Data Block is not edited.
| Configuration | PYTHON ENVIRONMENT | None | SETTINGS | TRUE |
| CalculationEnv | https://learn.assette.com/docs/calculation-env-data-block/ | Used to import Python modules and libraries (e.g., “import numpy as np”) | | PYTHON ENVIRONMENT, PYTHON | None | None | FALSE |
| Countries | https://learn.assette.com/docs/countries-data-block/ | The Countries Data Block surfaces the country codes and names. By default, this list is retrieved from Assette’s internal database. If a client desires to maintain their own countries list, the Data Block CountriesLocaldb must be modified. | Transform | PYTHON | None | Data Table | FALSE |
| CountryListSync | https://learn.assette.com/docs/country-list-sync-data-block/ | The Country List Sync Data Block is used to synchronize the list of available countries and insert into Assette’s database. The Country List Sync Data Block is not normally edited by end users. To update the available countries, see Source_CountryList Data Block instead. | Transform | PYTHON | None | Data Table | TRUE |
| CurrencyCodes | https://learn.assette.com/docs/currency-codes-data-blocks/ | The Currency Codes (CurrencyCodes) Data Block retrieves the values for all currency codes including the ID, Symbol, description, isDeleted, and short code from the Source List of Currency Codes Data Block— a Constant Data Block. The The Currency Codes (CurrencyCodes) Data Block is not normally edited by end user, to update Currency Code, see Source List of Currency Codes Data Block instead.
| Transform | PYTHON | None | Data Table | FALSE |
| DEMO_SnowFlakeSettingBlock | https://learn.assette.com/docs/demo-snowflake-setting-data-block/ | The Demo Snowflake Setting (DEMO_SnowFlakeSettingBlock) Data Block is used to facilitate access the Assette Demo Snowflake Data Warehouse by providing value for ‘user’, ‘account’, ‘warehouse’, etc. This Data Block must be edited or removed as dictated by the client’s data needs. | Configuration | SETTINGS | None | VALUES | TRUE |
| DemoCertificate | https://learn.assette.com/docs/snowflake-demo-certificate-data-block/ | The Snowflake Demo Certificate Data Block is a constant Data Block which contains the private key for the Snowflake Tutorial. It is expected that this Data Block either be changed or removed to conform to the needs of the specific implementation. | Configuration | NONE | None | SETTINGS | TRUE |
| ImageContent | https://learn.assette.com/docs/image-content-data-block/ | The Image Content Data Block is used to retrieve the image from Aprimo API. Once the image is ready and available, the Data Block downloads the image and captures its content and format. If successful, the image data and its type are returned as a response. This Data Block is not edited. | Interface | PYTHON | None | BINARY | TRUE |
| ImageLibrary | https://learn.assette.com/docs/image-library-data-block/ | The Aprimo Image Library Data Block is used to list of images according to given filter parameters within the Assette application. | Transform | PYTHON | None | Data Table | TRUE |
| ImageLibrary_Api_Thumbnail_Aprimo | https://learn.assette.com/docs/aprimo-thumbnail-image-library-api-data-block/ | The Aprimo Image Library API Data Block passes the URL which was received from the Aprimo API Order Status Data Block and sets the action to “Download”. | Interface | API CALL | None | BINARY | TRUE |
| ImageThumbnail | https://learn.assette.com/docs/aprimo-image-thumbnail-data-block/ | The Aprimo Image Thumbnail Data Block is used to retrieve a thumbnail image from Aprimo. This Data Block should not be edited. | Transform | PYTHON | None | BINARY | TRUE |
| ProductMaster | https://learn.assette.com/docs/product-master-system-data-block/ | The ProductMaster Data Block pulls product-related information from a database based on user-provided filters like ID, strategy, or country. It then refines the data using additional filters, if provided. After retrieving the product details, the function ensures all necessary fields are included, and if some data fields are missing (like country), it tries to fill in the gaps by looking up related information. Lastly, it checks the product’s country data and filters out any products that don’t match the given country filter, if one is provided.
| Interface | PYTHON | None | Data Table | TRUE |
| ProductMasterLocalDB | https://learn.assette.com/docs/product-master-local-data-base-data-block/ | | Interface | LOCAL DATABASE | None | VALUES | FALSE |
| PythonDataCalculationModules | https://learn.assette.com/docs/python-data-calculation-modules-data-block/ | The Python Data Calculation Modules (PythonDataCalculationModules) Data Block defines a set of Python libraries to be imported into a script. It includes common libraries like pandas, numpy, json, datetime, and calendar, each with their respective aliases. The Python Data Calculation Modules (PythonDataCalculationModules) Data Block ensures these libraries are available for use in the script under their specified aliases. This Data Block is not edited. If additional Python libraries or modules need to be imported create a new Data Block instead. | Configuration | PYTHON ENVIRONMENT | None | None | TRUE |
| PythonEnvForDateCalculation | https://learn.assette.com/docs/python-environment-for-date-calculation-data-block/ | The Python Environment for Date Calculation Data Block is used to import Python libraries and modules for date calculations. This Data Block should not be edited. | Configuration | PYTHON ENVIRONMENT | None | VALUES | TRUE |
| Sectors | https://learn.assette.com/docs/sectors-data-block/ | The Sectors Data Block retrieves sector-related data from Assette. The Data Block accepts optional input parameters AsOfDate, UseSectorMapTable, Category, and Language, with default values set if not provided. The Sectors Data Block is not edited. | Transform | PYTHON | None | Data Table | FALSE |
| SectorSchemes | https://learn.assette.com/docs/sector-schemes-data-blocks/ | The Sector Schemes (SectorSchemes) Data Block retrieves sector scheme data from the local database. It checks if any data is available, and if so, it processes each row by extracting the Key and Value for each sector scheme. The Sector Schemes (SectorSchemes) Data Block then organizes this information into a list and sends it back as the response. This Data Block is not edited. | Interface | PYTHON | None | Data Table | TRUE |
| Source_AccountAttributesValues | https://learn.assette.com/docs/source-account-attributes-values-data-block/ | The Source Account Attributes Values Data Block is used to interface with a client’s data source (e.g., Snowflake) and must be edited by the end user during implementation. | Interface | SNOWFLAKE DATABASE CALL | None | Data Table | TRUE |
| Source_ExtractAccountsDetails | https://learn.assette.com/docs/extract-accounts-details-interface-data-block/ | Source Extract Accounts Details is a Transform Data Block used to extract data related to the account master from client’s source data (e.g., Snowflake). This Data Block is expected to be edited by the client and therefore the name and output is subject to change. | Interface | SNOWFLAKE DATABASE CALL | None | Data Table | TRUE |
| Source_ListofAttributeTypeValues | https://learn.assette.com/docs/source-list-of-attribute-type-values-data-block/ | In this block, Assette compile the list of distinct strategies and vehicles and insert them into Assette local database. The dependency block (e.g.: Source_ListofAttributeTypeValues) which referring client data source data should be populated with all strategies , Vehicles and AssetClass list along with associated attribute type values. | Interface | LOCAL DATABASE | None | VALUES | TRUE |
| Source_ProductMasterExtract | https://learn.assette.com/docs/source-product-master-extract-data-block/ | The Source Product Master Extract (Source_ProductMasterExtract) Data Block retrieves data related to the Product Master from a client’s data source (e.g., Snowflake). The Source Product Master Extract Data Block has been configured to retrieve data from Assette’s Demo Snowflake instance. The Source Product Master Extract Data Block must be updated and edited to retrieve data from the client’s data source. It is important to note that changing the Output Type (Data Type) will break this Data Block.
| Interface | SNOWFLAKE DATABASE CALL | None | Data Table | TRUE |
| Source_SubAccountsRelationship | https://learn.assette.com/docs/source-sub-accounts-relationship-data-block/ | The Source Sub-Accounts Relationship Data Block (Source_SubAccountsRelationship) Data Block retrieves portfolio group associations from the DEMO_DB database. It returns the MEMBERPORTFOLIOCODE as Code and the PortfolioCode as GroupAccountCode based on a specified AccountCode. The Source Sub-Accounts Relationship Data Block (Source_SubAccountsRelationship) Data Block filters the data using the provided AccountCode and returns the associated portfolio details. This Data Block is expected to be edited. | Interface | SNOWFLAKE DATABASE CALL | None | Data Table | TRUE |
| Strategies | https://learn.assette.com/docs/strategies-data-block/ | The Strategies Data Block retrieves a list of strategies from Assette. It checks if any data is returned, and if so, it processes each row by extracting the Key, whether the strategy is active (IsActive), and the Value. The Strategies (Strategies) Data Block then organizes this information into a list and sends it back as the response. This Data Block is not edited. | Interface | PYTHON | None | Data Table | FALSE |
| SubAccounts | https://learn.assette.com/docs/subaccounts-system-data-block/ | The SubAccounts (SubAccounts) Data Block retrieves subaccount information from Assette or client database, based on the specified interface method (Local or BYOD). This Data Block is not edited. | Transform | PYTHON | None | Data Table | TRUE |
| SubAccountsClientDB | https://learn.assette.com/docs/sub-accounts-client-database-data-block/ | The Sub Accounts Client Database (SubAccountsClientDB) Data Block retrieves subaccount data along with associated attributes like strategy and vehicle from Assette’s Demo Snowflake instance. It first fetches subaccount relationships, then merges them with account details and attribute values to generate a comprehensive view of each subaccount. The Sub Accounts Client Database (SubAccountsClientDB) Data Block processes the data, fills in missing fields, and organizes the output by adding strategy and vehicle details for each subaccount. Finally, it returns the structured subaccount information in the response. This Data Block is expected to be edited in order to retrieve data from the client’s source. | Transform | PYTHON | None | Data Table | TRUE |
| SubAccountsLocalDB | https://learn.assette.com/docs/subaccounts-system-data-block/ | The Sub Accounts Local Database (SubAccountsLocalDB) Data Block retrieves subaccount information from Assette. This Data Block is not edited. | Interface | LOCAL DATABASE | None | VALUES | FALSE |
| sys_period_information | https://learn.assette.com/docs/system-period-information-data-block/ | The System Period Information (sys_period_information) Data Block defines a set of periods using period codes and their respective details, such as the display name, number of years, months, and quarters for each period. Each period is categorized based on its duration, such as month-to-date, quarter-to-date, year-to-date, prior years, or prior quarters. This Data Block is used to manage the calculation and display of time periods for various financial or reporting purposes. This Data Block is open-source and may be edited as needed. | Transform | CONSTANT | None | Data Table | TRUE |
| VehiclesLocaldb | https://learn.assette.com/docs/vehicles-local-database-data-block/ | The Vehicles Local Database (VehiclesLocalDB) Data Block retrieves a list of vehicles from Assette by selecting vehicle-related attribute values. It joins the AttributeTypeValues and AttributeTypes tables to filter out attributes where the name is ‘Vehicle’. The Vehicles Local Database (VehiclesLocalDB) Data Block returns this data as a structured list of key-value pairs. This Data Block is not edited. | Interface | LOCAL DATABASE | None | VALUES | TRUE |
