The Product Master Local Data Base (ProductMasterLocalDB) Data Block is a core component of Assette’s standard configuration. It is used to retrieve product-related information from the Assette Product Master repository. This block is not directly visible or editable by users and functions exclusively as a dependency for the Product Master data block.
It executes a stored procedure in the Assette database to fetch detailed information about investment products, using various input filters such as client segment, strategy, and asset class. The data returned is structured for downstream use in content generation, reporting, and data transformation processes.
General Info #
Field | Value |
---|---|
Name | ProductMasterLocalDB |
Block Category | Interface |
Block Type | Local Database |
Output Type | Values |
Public | True |
Editable | False |
Depenedencies #
None
Parameters #
Parameter | Type | Description |
---|---|---|
ClientSegment | String | Specifies the client segment for product filtering. |
Strategy | String | Investment strategy used to filter products. |
Country | String | Geographic country filter. |
Shareclass | String | Share class code or designation. |
Code | String | Specific product code. |
Assetclass | String | Asset class category (e.g., equities, fixed income). |
GeographicScope | String | Scope of the product’s regional exposure. |
If no values are provided, the block may return all available products.
Example Request #
{
"ID": "",
"ClientSegment": "",
"Strategy": "",
"Country": "",
"Shareclass": "",
"Code": "",
"Assetclass": "",
"GeographicScope": ""
}
Example Response #
{
"data": [
{
"ProductID": 1,
"ProductName": "U.S. Large Cap Value",
"ProductCode": "PRDK01",
"RepAccountID": 123,
"CompositeID": 456,
"RepAccountCode": "987",
"CompositeAccountCode": "4567",
"StrategyID": 112,
"VehicleTypeID": 2,
"StrategyName": "U.S. Large Cap Value",
"Strategy": 852,
"VehicleTypeName": null,
"ParentID": null,
"Type": "product",
"Product": 1,
"VehicleType": null
}
],
"errors": [],
"success": true,
"logs": []
}
Output Fields #
Field | Description |
---|---|
ProductID | Unique identifier for the product. |
ProductName | Display name of the product. |
ProductCode | Internal product code. |
RepAccountID | ID of the representative account. |
CompositeID | ID of the associated composite. |
RepAccountCode | Code for the representative account. |
CompositeAccountCode | Code for the composite account. |
StrategyID | ID of the strategy associated with the product. |
VehicleTypeID | ID of the vehicle type, if applicable. |
StrategyName | Name of the investment strategy. |
Strategy | Alternate identifier for the strategy. |
VehicleTypeName | Display name of the vehicle type. |
ParentID | ID of the parent product or entity (if hierarchical). |
Type | Entity type, generally set as "product" . |
Product | Product identifier (duplicate of ProductID for internal mapping). |
VehicleType | ID or reference for the vehicle type (nullable). |
Notes #
- This block supports flexible querying by accepting multiple filters, though all are optional.
- It is a hidden system block and cannot be directly used or modified by end users.
- Used internally by Assette’s Product Master Data Block to construct consistent product views across reports and applications.