Source Product Master Extract Data Block

The Source Product Master Extract (Source_ProductMasterExtract) Data Block must be edited by end user to conform with the data source.

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.

General Info #

Field	Value
Name	Source_ProductMasterExtract
Block Category	Interface
Block Type	Snowflake Database Call
Data Category	None
Output Type	Data Table

Dependencies #

Data Block Name	Description
DemoCertificate	The Snowflake Demo Certificate (DemoCertificate) 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. [Link]
DEMO_SnowFlakeSettingBlock	The Demo Snowflake Setting (DEMO_SnowFlakeSettingBlock) Data Block is used to facilitate access the Assette Demo Snowflake Data Warehouse This Data Block must be edited or removed as dictated by the client’s data needs. [Link]

Columns #

Field	Data Type	Description
ASSETCLASS*	VARCHAR	Product asset class (e.g., “Equity”, “Fixed Income”)
ISMARKETED*	BIT	Indicates whether the product is marketed or not (e.g., 0 for FALSE or 1 for TRUE)
PARENTPRODUCTCODE	VARCHAR	Code of parent product, if applicable (e.g., “PRDK01”)
PRODUCTCODE*	VARCHAR	Unique code of the product (e.g., “PRDK02”)
PRODUCTNAME*	VARCHAR	Product’s name (e.g., “Emerging Markets Equity”)
PERFORMANCEACCOUNT*	VARCHAR	Account code from which performance and performance-based characteristics are derived (i.e., a Composite Account) (e.g., “ASTGVECOMP”)
REPRESENTATIVEACCOUNT*	VARCHAR	The code of the Representative Account for the product (e.g., “lwdlcvmodel”)
SHARECLASS	VARCHAR	Share class of the product (e.g., “Institutional”)
STRATEGY*	VARCHAR	Code of the product’s strategy (e.g., “DLCV”)
VEHICLECATEGORY*1	VARCHAR	Vehicle category for the product (e.g., “Segregated”, “Pooled”)
VEHICLETYPE*	VARCHAR	Vehicle type of the product (e.g., “Seperate Account”, “Commingled Fund”)

Example Request #

{}

Example Response #

{
    "data": [
        {
            "PRODUCTCODE": "PRDK01",
            "PRODUCTNAME": "Diversified Large Cap Value",
            "STRATEGY": "DLCV",
            "VEHICLECATEGORY": "Segregated",
            "VEHICLETYPE": "Separate Account",
            "ASSETCLASS": "Equity",
            "SHARECLASS": "",
            "PERFORMANCEACCOUNT": "2900",
            "REPRESENTATIVEACCOUNT": "1135",
            "ISMARKETED": true,
            "PARENTPRODUCTCODE": ""
        },
        {
            "PRODUCTCODE": "PRDK02",
            "PRODUCTNAME": "Emerging Markets Equity",
            "STRATEGY": "EEME",
            "VEHICLECATEGORY": "Pooled",
            "VEHICLETYPE": "Commingled Fund",
            "ASSETCLASS": "Equity",
            "SHARECLASS": null,
            "PERFORMANCEACCOUNT": "ASTGVECOMP",
            "REPRESENTATIVEACCOUNT": "lwdlcvmodel",
            "ISMARKETED": true,
            "PARENTPRODUCTCODE": null
        }
    ],
    "errors": [],
    "success": true,
    "logs": []
}