The Source Account Attributes Values (Source_AccountAttributesValues) Data Block expected to be edited by developers to meet the needs of the source data. The following has been set up as an example and uses Snowflake as its data source.
The Source Account Attributes Values (Source_AccountAttributesValues) 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.
General Info #
| Name | Source_AccountAttributesValues |
| Block Category | Interface |
| Block Type | Snowflake Database Call |
| Data Category | None |
| Output Type | Data Table |
Dependencies #
| Data Block Name | Description |
|---|---|
| DemoCertificate | Certificate used to access Assette’s Snowflake instance [Link] |
| DEMO_SnowFlakeSettingBlock | Specifies values for the Snowflake user, schema among other items [Link] |
Required Fields #
The following fields are required for the proper functioning of upstream dependencies, specifically, the Account Master Sync (AccountMasterSync) Data Block.
| Field Name | Description |
|---|---|
| PORTFOLIOCODE | Unique code used to identify the portfolio (e.g., “ABC123”) |
| ATTRIBUTETYPE | Attribute type (e.g., “Strategy”) |
| ATTRIBUTETYPECODE | Unique code which corresponds with the Attribute Type Value (e.g., “USCE”) |
| ATTRIBUTETYPEVALUE | Attribute value (e.g., “US Small Cap Equity”) |
Available Columns #
| Field Name | Description |
|---|---|
| PORTFOLIOCODE | Unique code used to identify the portfolio (e.g., “ABC123”) |
| ATTRIBUTETYPE | Attribute type (e.g., “Strategy”) |
| ATTRIBUTETYPECODE | Unique code which corresponds with the Attribute Type Value (e.g., “USCE”) |
| ATTRIBUTETYPEVALUE | Attribute value (e.g., “US Small Cap Equity”) |
Example Definition #
{
"type": "data",
"sql": "SELECT PORTFOLIOCODE,ATTRIBUTETYPE,ATTRIBUTETYPECODE,ATTRIBUTETYPEVALUE FROM DEMO_DB.DBO.PORTFOLIOATTRIBUTES",
"parameters": [ ]
}Example Request #
{}Example Response #
{
"data": [
{
"PORTFOLIOCODE": "2900",
"ATTRIBUTETYPE": "Strategy",
"ATTRIBUTETYPECODE": "DLCV",
"ATTRIBUTETYPEVALUE": "Diversified Large Cap Value"
},
{
"PORTFOLIOCODE": "lwdlcvmodel",
"ATTRIBUTETYPE": "Strategy",
"ATTRIBUTETYPECODE": "DLCV",
"ATTRIBUTETYPEVALUE": "Diversified Large Cap Value"
},
{
"PORTFOLIOCODE": "lwdlcvxmodel",
"ATTRIBUTETYPE": "Strategy",
"ATTRIBUTETYPECODE": "DLCV",
"ATTRIBUTETYPEVALUE": "Diversified Large Cap Value"
},
{
"PORTFOLIOCODE": "lwdlcvbill",
"ATTRIBUTETYPE": "Strategy",
"ATTRIBUTETYPECODE": "DLCV",
"ATTRIBUTETYPEVALUE": "Diversified Large Cap Value"
},
{
"PORTFOLIOCODE": "lwdlcvxbill",
"ATTRIBUTETYPE": "Strategy",
"ATTRIBUTETYPECODE": "DLCV",
"ATTRIBUTETYPEVALUE": "Diversified Large Cap Value"
},
{
"PORTFOLIOCODE": "lwdlcvbill",
"ATTRIBUTETYPE": "ClientType",
"ATTRIBUTETYPECODE": "Other",
"ATTRIBUTETYPEVALUE": "Other"
},
{
"PORTFOLIOCODE": "lwdlcvxbill",
"ATTRIBUTETYPE": "ClientType",
"ATTRIBUTETYPECODE": "Other",
"ATTRIBUTETYPEVALUE": "Other"
},
{
"PORTFOLIOCODE": "2900",
"ATTRIBUTETYPE": "Vehicle",
"ATTRIBUTETYPECODE": "Separate Account",
"ATTRIBUTETYPEVALUE": "Separate Account"
},
{
"PORTFOLIOCODE": "1143",
"ATTRIBUTETYPE": "ClientType",
"ATTRIBUTETYPECODE": "Sub-Advisory/Mutual Fund",
"ATTRIBUTETYPEVALUE": "Sub-Advisory/Mutual Fund"
},
{
"PORTFOLIOCODE": "1143",
"ATTRIBUTETYPE": "Strategy",
"ATTRIBUTETYPECODE": "DLCV",
"ATTRIBUTETYPEVALUE": "Diversified Large Cap Value"
},
{
"PORTFOLIOCODE": "bbdlcvmodel",
"ATTRIBUTETYPE": "Strategy",
"ATTRIBUTETYPECODE": "DLCV",
"ATTRIBUTETYPEVALUE": "Diversified Large Cap Value"
},
{
"PORTFOLIOCODE": "1119",
"ATTRIBUTETYPE": "Strategy",
"ATTRIBUTETYPECODE": "DLCV",
"ATTRIBUTETYPEVALUE": "Diversified Large Cap Value"
},
{
"PORTFOLIOCODE": "1120",
"ATTRIBUTETYPE": "Strategy",
"ATTRIBUTETYPECODE": "DLCV",
"ATTRIBUTETYPEVALUE": "Diversified Large Cap Value"
},
{
"PORTFOLIOCODE": "1128",
"ATTRIBUTETYPE": "Strategy",
"ATTRIBUTETYPECODE": "DLCV",
"ATTRIBUTETYPEVALUE": "Diversified Large Cap Value"
},
{
"PORTFOLIOCODE": "1119",
"ATTRIBUTETYPE": "ClientType",
"ATTRIBUTETYPECODE": "Taft-Hartley",
"ATTRIBUTETYPEVALUE": "Taft-Hartley"
},
{
"PORTFOLIOCODE": "1120",
"ATTRIBUTETYPE": "ClientType",
"ATTRIBUTETYPECODE": "Endowment/Foundation",
"ATTRIBUTETYPEVALUE": "Endowment/Foundation"
},
{
"PORTFOLIOCODE": "1128",
"ATTRIBUTETYPE": "ClientType",
"ATTRIBUTETYPECODE": "Taft-Hartley",
"ATTRIBUTETYPEVALUE": "Taft-Hartley"
},
{
"PORTFOLIOCODE": "1144bill",
"ATTRIBUTETYPE": "ClientType",
"ATTRIBUTETYPECODE": "Other",
"ATTRIBUTETYPEVALUE": "Other"
},
{
"PORTFOLIOCODE": "1144bill",
"ATTRIBUTETYPE": "Strategy",
"ATTRIBUTETYPECODE": "DLCV",
"ATTRIBUTETYPEVALUE": "Diversified Large Cap Value"
},
{
"PORTFOLIOCODE": "1119",
"ATTRIBUTETYPE": "AssetClass",
"ATTRIBUTETYPECODE": "Equities",
"ATTRIBUTETYPEVALUE": "Equities"
},
{
"PORTFOLIOCODE": "1120",
"ATTRIBUTETYPE": "AssetClass",
"ATTRIBUTETYPECODE": "Equities",
"ATTRIBUTETYPEVALUE": "Equities"
},
{
"PORTFOLIOCODE": "1128",
"ATTRIBUTETYPE": "AssetClass",
"ATTRIBUTETYPECODE": "Equities",
"ATTRIBUTETYPEVALUE": "Equities"
},
{
"PORTFOLIOCODE": "lwdlcvbill",
"ATTRIBUTETYPE": "AssetClass",
"ATTRIBUTETYPECODE": "Equities",
"ATTRIBUTETYPEVALUE": "Equities"
},
{
"PORTFOLIOCODE": "lwdlcvxbill",
"ATTRIBUTETYPE": "AssetClass",
"ATTRIBUTETYPECODE": "Equities",
"ATTRIBUTETYPEVALUE": "Equities"
},
{
"PORTFOLIOCODE": "1143",
"ATTRIBUTETYPE": "AssetClass",
"ATTRIBUTETYPECODE": "Equities",
"ATTRIBUTETYPEVALUE": "Equities"
},
{
"PORTFOLIOCODE": "bbdlcvmodel",
"ATTRIBUTETYPE": "AssetClass",
"ATTRIBUTETYPECODE": "Equities",
"ATTRIBUTETYPEVALUE": "Equities"
},
{
"PORTFOLIOCODE": "1144bill",
"ATTRIBUTETYPE": "AssetClass",
"ATTRIBUTETYPECODE": "Equities",
"ATTRIBUTETYPEVALUE": "Equities"
},
{
"PORTFOLIOCODE": "bbdlcvmodel",
"ATTRIBUTETYPE": "ClientOrganization",
"ATTRIBUTETYPECODE": "Edward D. Jones & Co.",
"ATTRIBUTETYPEVALUE": "Edward D. Jones & Co."
},
{
"PORTFOLIOCODE": "1144bill",
"ATTRIBUTETYPE": "ClientOrganization",
"ATTRIBUTETYPECODE": "Edward D. Jones & Co.",
"ATTRIBUTETYPEVALUE": "Edward D. Jones & Co."
},
{
"PORTFOLIOCODE": "1119",
"ATTRIBUTETYPE": "ClientOrganization",
"ATTRIBUTETYPECODE": "Excavators Union Local 731 Pension Fund",
"ATTRIBUTETYPEVALUE": "Excavators Union Local 731 Pension Fund"
},
{
"PORTFOLIOCODE": "1128",
"ATTRIBUTETYPE": "ClientOrganization",
"ATTRIBUTETYPECODE": "Excavators Union Local 731 Pension Fund",
"ATTRIBUTETYPEVALUE": "Excavators Union Local 731 Pension Fund"
},
{
"PORTFOLIOCODE": "lwdlcvbill",
"ATTRIBUTETYPE": "ClientOrganization",
"ATTRIBUTETYPECODE": "Leith Wheeler",
"ATTRIBUTETYPEVALUE": "Leith Wheeler"
},
{
"PORTFOLIOCODE": "lwdlcvxbill",
"ATTRIBUTETYPE": "ClientOrganization",
"ATTRIBUTETYPECODE": "Leith Wheeler",
"ATTRIBUTETYPEVALUE": "Leith Wheeler"
},
{
"PORTFOLIOCODE": "1143",
"ATTRIBUTETYPE": "ClientOrganization",
"ATTRIBUTETYPECODE": "Perpetual US Services, LLC",
"ATTRIBUTETYPEVALUE": "Perpetual US Services, LLC"
},
{
"PORTFOLIOCODE": "1120",
"ATTRIBUTETYPE": "ClientOrganization",
"ATTRIBUTETYPECODE": "University of South Florida Foundation, Inc.",
"ATTRIBUTETYPEVALUE": "University of South Florida Foundation, Inc."
},
{
"PORTFOLIOCODE": "1106",
"ATTRIBUTETYPE": "Strategy",
"ATTRIBUTETYPECODE": "DLCV",
"ATTRIBUTETYPEVALUE": "Diversified Large Cap Value"
},
{
"PORTFOLIOCODE": "1106",
"ATTRIBUTETYPE": "ClientOrganization",
"ATTRIBUTETYPECODE": "Equitable Investment Management Group, LLC",
"ATTRIBUTETYPEVALUE": "Equitable Investment Management Group, LLC"
},
{
"PORTFOLIOCODE": "1106",
"ATTRIBUTETYPE": "AssetClass",
"ATTRIBUTETYPECODE": "Equities",
"ATTRIBUTETYPEVALUE": "Equities"
},
{
"PORTFOLIOCODE": "1107",
"ATTRIBUTETYPE": "Strategy",
"ATTRIBUTETYPECODE": "DLCV",
"ATTRIBUTETYPEVALUE": "Diversified Large Cap Value"
},
{
"PORTFOLIOCODE": "1107",
"ATTRIBUTETYPE": "ClientOrganization",
"ATTRIBUTETYPECODE": "Equitable Investment Management Group, LLC",
"ATTRIBUTETYPEVALUE": "Equitable Investment Management Group, LLC"
},
{
"PORTFOLIOCODE": "1107",
"ATTRIBUTETYPE": "AssetClass",
"ATTRIBUTETYPECODE": "Equities",
"ATTRIBUTETYPEVALUE": "Equities"
},
{
"PORTFOLIOCODE": "1108",
"ATTRIBUTETYPE": "Strategy",
"ATTRIBUTETYPECODE": "DLCV",
"ATTRIBUTETYPEVALUE": "Diversified Large Cap Value"
},
{
"PORTFOLIOCODE": "1108",
"ATTRIBUTETYPE": "ClientOrganization",
"ATTRIBUTETYPECODE": "Equitable Investment Management Group, LLC",
"ATTRIBUTETYPEVALUE": "Equitable Investment Management Group, LLC"
},
{
"PORTFOLIOCODE": "1108",
"ATTRIBUTETYPE": "AssetClass",
"ATTRIBUTETYPECODE": "Equities",
"ATTRIBUTETYPEVALUE": "Equities"
},
{
"PORTFOLIOCODE": "1109",
"ATTRIBUTETYPE": "Strategy",
"ATTRIBUTETYPECODE": "DLCV",
"ATTRIBUTETYPEVALUE": "Diversified Large Cap Value"
},
{
"PORTFOLIOCODE": "1109",
"ATTRIBUTETYPE": "ClientOrganization",
"ATTRIBUTETYPECODE": "The Methodist Hospital",
"ATTRIBUTETYPEVALUE": "The Methodist Hospital"
},
{
"PORTFOLIOCODE": "1109",
"ATTRIBUTETYPE": "AssetClass",
"ATTRIBUTETYPECODE": "Equities",
"ATTRIBUTETYPEVALUE": "Equities"
},
{
"PORTFOLIOCODE": "1114",
"ATTRIBUTETYPE": "ClientOrganization",
"ATTRIBUTETYPECODE": "Wichita Retirement Systems",
"ATTRIBUTETYPEVALUE": "Wichita Retirement Systems"
},
{
"PORTFOLIOCODE": "1114",
"ATTRIBUTETYPE": "AssetClass",
"ATTRIBUTETYPECODE": "Equities",
"ATTRIBUTETYPEVALUE": "Equities"
},
{
"PORTFOLIOCODE": "1114",
"ATTRIBUTETYPE": "Strategy",
"ATTRIBUTETYPECODE": "EEME",
"ATTRIBUTETYPEVALUE": "Emerging Markets"
},
{
"PORTFOLIOCODE": "1115",
"ATTRIBUTETYPE": "Strategy",
"ATTRIBUTETYPECODE": "EEME",
"ATTRIBUTETYPEVALUE": "Emerging Markets"
},
{
"PORTFOLIOCODE": "1115",
"ATTRIBUTETYPE": "ClientOrganization",
"ATTRIBUTETYPECODE": "CVS Health Corporation",
"ATTRIBUTETYPEVALUE": "CVS Health Corporation"
},
{
"PORTFOLIOCODE": "1115",
"ATTRIBUTETYPE": "AssetClass",
"ATTRIBUTETYPECODE": "Equities",
"ATTRIBUTETYPEVALUE": "Equities"
},
{
"PORTFOLIOCODE": "1135",
"ATTRIBUTETYPE": "Strategy",
"ATTRIBUTETYPECODE": "DLCV",
"ATTRIBUTETYPEVALUE": "Diversified Large Cap Value"
},
{
"PORTFOLIOCODE": "1135",
"ATTRIBUTETYPE": "ClientOrganization",
"ATTRIBUTETYPECODE": "Edward D. Jones & Co.",
"ATTRIBUTETYPEVALUE": "Edward D. Jones & Co."
},
{
"PORTFOLIOCODE": "1135",
"ATTRIBUTETYPE": "AssetClass",
"ATTRIBUTETYPECODE": "Equities",
"ATTRIBUTETYPEVALUE": "Equities"
},
{
"PORTFOLIOCODE": "1138",
"ATTRIBUTETYPE": "Strategy",
"ATTRIBUTETYPECODE": "DLCV",
"ATTRIBUTETYPEVALUE": "Diversified Large Cap Value"
},
{
"PORTFOLIOCODE": "1138",
"ATTRIBUTETYPE": "ClientOrganization",
"ATTRIBUTETYPECODE": "MML Investment Advisors, LLC",
"ATTRIBUTETYPEVALUE": "MML Investment Advisors, LLC"
},
{
"PORTFOLIOCODE": "1138",
"ATTRIBUTETYPE": "AssetClass",
"ATTRIBUTETYPECODE": "Equities",
"ATTRIBUTETYPEVALUE": "Equities"
},
{
"PORTFOLIOCODE": "1139",
"ATTRIBUTETYPE": "Strategy",
"ATTRIBUTETYPECODE": "DLCV",
"ATTRIBUTETYPEVALUE": "Diversified Large Cap Value"
},
{
"PORTFOLIOCODE": "1139",
"ATTRIBUTETYPE": "ClientOrganization",
"ATTRIBUTETYPECODE": "MML Investment Advisors, LLC",
"ATTRIBUTETYPEVALUE": "MML Investment Advisors, LLC"
},
{
"PORTFOLIOCODE": "1139",
"ATTRIBUTETYPE": "AssetClass",
"ATTRIBUTETYPECODE": "Equities",
"ATTRIBUTETYPEVALUE": "Equities"
},
{
"PORTFOLIOCODE": "1139",
"ATTRIBUTETYPE": "PortfolioManagerPrimary",
"ATTRIBUTETYPECODE": "1000",
"ATTRIBUTETYPEVALUE": "Roopan,Thivya"
},
{
"PORTFOLIOCODE": "1138",
"ATTRIBUTETYPE": "FiscalYear",
"ATTRIBUTETYPECODE": "Apr",
"ATTRIBUTETYPEVALUE": "04-30"
}
],
"errors": [],
"success": true,
"logs": []
}