7.3.6.2 Average Balance Calculation for Multiple Attributes

The Average Balance Computation calculates the average value of account balances over a specified period. The calculation supports End of Period (EOP) balances as well as other balance-related financial attributes.

This feature allows users to compute averages for multiple balance attributes within a single execution by using the same calculation logic. As a result, multiple attributes can be processed together without requiring separate executions.

Each attribute is processed independently, and the system generates a separate average value for each attribute.

To support multiple calculations, the input JSON must include an array of objects where each object represents a Source Business Term and Target Business Term mapping. The parameter ABC_INPUT_FIELD contains this array of mappings.

Example Input JSON

{
  "FIC_MIS_DATE": "2026-01-07",
  "DATA_SOURCE": "OTH",
  "PRODUCT_PROCESSOR": "LOANCONTRACTS,BORROWINGS",
  "ABC_INPUT_FIELD": [
    {
      "PRODUCT_PROCESSOR": "LOANCONTRACTS",
      "SOURCE_BUSINESS_TERM": "End of Period Balance",
      "TARGET_BUSINESS_TERM": "Average Balance Month Till Date"
    },
    {
      "PRODUCT_PROCESSOR": "LOANCONTRACTS",
      "SOURCE_BUSINESS_TERM": "End Of Period Book Balance",
      "TARGET_BUSINESS_TERM": "Average End Of Period Book Balance Month Till Date"
    },
    {
      "PRODUCT_PROCESSOR": "BORROWINGS",
      "SOURCE_BUSINESS_TERM": "End Of Period Principal Balance",
      "TARGET_BUSINESS_TERM": "Average End Of Period Principal Balance Month Till Date"
    }
  ]
}

Backward Compatibility

The Average Balance Computation process remains backward compatible.

If the ABC_INPUT_FIELD parameter is not provided, the system automatically uses the default source and target business term mapping for the specified Product Processor.

Example Input JSON Without ABC_INPUT_FIELD

{
  "FIC_MIS_DATE": "2024-03-31",
  "DATA_SOURCE": "SRC_4",
  "PRODUCT_PROCESSOR": "CARDS"
}

Default Mapping

Source Business Term	Target Business Term
End Of Period Balance	Average Balance Month Till Date