4.1.2 AccountProfitAndLoss Datamap

Follow these steps to run the AccountProfitAndLoss Datamaps.

  1. Stg_Account_Balances cannot have Multiple Legal Entity entries and not supported by the current version of the product.
  2. You must populate the data for the following metadata tables:
    • DIM_BALANCE_TYPE
    • STG_BALANCE_TYPE_MASTER
  3. Insert Scripts for metadata tables:
    insert into Stg_Balance_Type_Master (FIC_MIS_DATE, V_BALANCE_TYPE, V_BALANCE_TYPE_DESC, V_BALANCE_TYPE_NAME, V_DATA_ORIGIN)
values (<to be provided by client>, 'TOTAL_PL_BASE_AM', 'Change in the total market value of all security positions held by the account expressed in base currency.', 'Total Profit Loss - Base', <client to populate source system name>)
/
insert into Stg_Balance_Type_Master (FIC_MIS_DATE, V_BALANCE_TYPE, V_BALANCE_TYPE_DESC, V_BALANCE_TYPE_NAME, V_DATA_ORIGIN)
values (<to be provided by client>, 'OPTION_PL_BASE_AM', 'Change in the total market value of all option security positions held by the account expressed in base currency.', 'Option Profit Loss - Base', <client to populate source system name>)
/
insert into Dim_Balance_Type (N_BALANCE_TYPE_CD, V_BALANCE_TYPE, V_DESCRIPTION, V_CREATED_BY, V_LAST_MODIFIED_BY, D_LAST_MODIFIED_DATE, D_CREATED_DATE, FIC_MIS_DATE, F_LATEST_RECORD_INDICATOR, D_RECORD_START_DATE, D_RECORD_END_DATE, V_BALANCE_TYPE_NAME, V_DATA_ORIGIN)
values (1, 'TOTAL_PL_BASE_AM', 'Change in the total market value of all security positions held by the account expressed in base currency.', null, null, null, null, null, null, null, null, 'Total Profit Loss - Base', <client to populate source system name>)
/
insert into Dim_Balance_Type (N_BALANCE_TYPE_CD, V_BALANCE_TYPE, V_DESCRIPTION, V_CREATED_BY, V_LAST_MODIFIED_BY, D_LAST_MODIFIED_DATE, D_CREATED_DATE, FIC_MIS_DATE, F_LATEST_RECORD_INDICATOR, D_RECORD_START_DATE, D_RECORD_END_DATE, V_BALANCE_TYPE_NAME, V_DATA_ORIGIN)
values (2, 'OPTION_PL_BASE_AM', 'Change in the total market value of all option security positions held by the account expressed in base currency.', null, null, null, null, null, null, null, null, 'Option Profit Loss - Base', <client to populate source system name>)
/