Sub Accounts Data Block

The SubAccounts (SubAccounts) System Data Block is a System Data Block and is not edited.

The SubAccounts (SubAccounts) Data Block retrieves subaccount information from Assette or client database, based on the specified interface method (Local or BYOD). It first checks for relevant input parameters like Code, AccountCode, and AsOfDate, setting default values if necessary. The SubAccounts (SubAccounts) Data Block then retrieves and processes the subaccount data, ensuring all required fields are present. Finally, it organizes the information into a list of subaccount details and returns it in the response. This Data Block is not edited.

Data Retrieval: The SubAccounts (SubAccounts) Data Block retrieves data based on the interface_method:

• Local: It queries the SubAccountsLocalDB using AccountCode and AsOfDate.
• BYOD: It queries the SubAccountsClientDB using the input params.

General Info #

The following table shows the default fields of the Data Block.

Field	Value
Name	SubAccounts
Block Category	Transform
Block Type	Python
Data Category	None
Output Type	Data Table

Dependencies #

The following table shows the default dependencies of the Data Block.

Data Block Name	Description
CalculationEnv	Used to import Python modules and libraries (e.g., “import numpy as np”) [Link]
SubAccountsLocalDB	The Sub Accounts Local Database (SubAccountsLocalDB) Data Block retrieves subaccount information from Assette. This Data Block is not edited. [Link]
SubAccountsClientDB
GetClientConfigLocalDB	Retrieves the current Assette configurations

Columns #

The following columns are the default columns for the Data Object, all columns are optional unless marked otherwise. Please see footnotes for additional information.

Name	Data Type
AccountID	VARCHAR
Name	VARCHAR
Code	VARCHAR
Code	VARCHAR
Manager	VARCHAR
Strategy	VARCHAR
InceptionDate	VARCHAR
GroupAccountCode	VARCHAR
GroupAccountId	VARCHAR

Example Definition #

AccountCode=""
AsOfDate = ""

if(params.__len__()>0):
    if "Code" in params :
        AccountCode=params["Code"]    
    if "AsOfDate" in params :
        AsOfDate = params["AsOfDate"]
    if "AccountCode" in params : 
        AccountCode=params["AccountCode"]

if params.get("Code") is None or params.get("Code") =="":
    params["Code"] = AccountCode

interface_method = "Local"
interface_df = pd.DataFrame(read("GetClientConfigLocalDB",{"ParamName":"InterfaceMethod"})["data"])

if interface_df.empty:
    interface_method="Local"
else:
    interface_method=interface_df["ParamValue"].values[0]

#interface_method = read("GetClientConfigLocalDB", {"ParamName":"InterfaceMethod"})["data"][0]["ParamValue"]
outputlist=[]
#IsAccountAttribWithDescription=False

#data_df = pd.DataFrame(read("AccountAttributesLocalDB",{"ID":ID,"Code":Code})["data"])
if interface_method == "BYOD":
    data_df = pd.DataFrame(read("SubAccountsClientDB",params)["data"])
else:
    data_df = pd.DataFrame(read("SubAccountsLocalDB",{"AccountCode":AccountCode,"AsOfDate":AsOfDate})["data"])
        

if data_df.shape[0]>0:
    if "AccountID" not in data_df.columns:
        data_df["AccountID"]=""
    if "Code" not in data_df.columns:
        data_df["Code"]=""
    if "Name" not in data_df.columns:
        data_df["Name"]=""
    if "Category" not in data_df.columns:
        data_df["Category"]=""    
    if "Manager" not in data_df.columns:
        data_df["Manager"]=""
    if "Strategy" not in data_df.columns:
        data_df["Strategy"]=""
    if "Vehicle" not in data_df.columns:
        data_df["Vehicle"]=""
    if "InceptionDate" not in data_df.columns:
        data_df["InceptionDate"]=""
    if "GroupAccountId" not in data_df.columns:
        data_df["GroupAccountId"]=0        
    if "GroupAccountCode" not in data_df.columns:
        data_df["GroupAccountCode"]=""       
    
for i in range(0, data_df.shape[0]):
            data_df.loc[i,"ID"]=i
            outputlist.append({ "AccountID":data_df.loc[i,"AccountID"],"Code":data_df.loc[i,"Code"],"Name":data_df.loc[i,"Name"],"Category":data_df.loc[i,"Category"]
                                        ,"Manager":data_df.loc[i,"Manager"],"Strategy":data_df.loc[i,"Strategy"],"Vehicle":data_df.loc[i,"Vehicle"],"InceptionDate":data_df.loc[i,"InceptionDate"],"GroupAccountId":data_df.loc[i,"GroupAccountId"],"GroupAccountCode":AccountCode})
            
response["data"] = outputlist