Product Master Local Data Base Data Block

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.