balm_aggr_nm_2

1. Description

Balm_aggr_nm program reads a cf file which is in metadata format and aggregates the principal amount and amount with interest rate grouped by llg,currency and cashflowtype for the non maturity products like current account, saving account, etc.

2. Program location

<installation_path>/balm_aggr_nm_2

3.Screen Configuration

3.1 Process Config Fields

Here enter the base input file and additional inputs required for the setup.

3.1.1 Additional Input files 🔗

#	File	Type	Description	Required	Example
1	AGGR_Rule	Function call	Calls getrules function which downloads the file to the provided path. The function takes four parameters: fileid, rule_type, connection_string to database, path to download the rule file.	true	getrules(1000,AGGR,{G_BALM_CONN_STRING},{E_2_SH_RESOURCES}/BALM_DOMESTIC/PC_ID.json)
2	Exchange_Rate	File_path	Provide the path to the exchange rate file.	true	{M_IN002}

3.2 Process Derivations

Here select the aggregator in the first field. The dropdown will show either maturity_aggr or nonmat_aggr depending on the type of source. Map all the values accordingly to the requirements.Concat,Princial Amount, Currency, Country and Account Number has to be filled mandatorily.

3.2.1 Derivations desc

#	Parameters	Description	Example
1	concat	any non empty string	branch_cd
2	prin_amt	principal amount	net_bal
3	curr	currency	curr
4	country	country	""
5	acc_no	account number	gl_cd
6	int_rt	interest rate	""
7	npa	npa field	""

3.3 Process Arguments

Here enter the process arguments to be passed to the program. The mandatory and non-mandatory fields are given below in the input section.

3.3.1 Mandatory Parameters

#	Parameters	Description	Example
1	src_local_ccy	Source local currency. 🔗	INR
2	display_local_ccy	Display local currency. 🔗	RUP
3	consol_ccy	Consolidated currency. 🔗	INR
4	default_llg_code	if no rules are satisfied, then this llg code will be used	08888

3.3.2 Non Mandatory Parameters

#	Parameters	Description	Default value	Example
1	is_consolidated	Is consolidated flag is used to define the currency type of given amount in input field. If is_consolidated flag is set, then the amount given is of consolidated type else it is in the curr input type.🔗	false	true or false
2	is_amt_abs	The flag that decides whether amount should be taken as absolute or not.	true	true or false
3	is_aggr_amt_abs	The flag that decides whether aggregated amount should be taken as absolute or not.	false	true or false
4	log_level	Level of diagnostics written to the log file.	info	error/warn/info/debug/trace/none
5	is_perf_diagnostics_enabled	The flag that decides whether performance diagnostics will be written to the diagnostics log file.	false	true or false
6	npa-values	NPA values separated by comma. If any of the value is found for the given npa field(passed in required field), then rate is taken as 0 for that account.	""	A123,B123
7	interest_decimal_precision	The value which decides the interest rate round off precision.	4	4
8	amount_decimal_precision	The value which decides the amount value round off precision.	2	2

Click ⬇️ to download the sample data.

4. Output

4.1 Output file-1 : Aggregated Output

It will be uploaded in tblProductTotals table.

#	Field	Description	Columns	Example
1	llg.category	LLG code as per the rule satisfied or default value. 🔗	SubType_ID	8888
2	as_on_date	Date of operation as passed through input	As_On	26-09-2023
3	llg.currency	Currency type for the amount displayed in the subsequent columns.	Currency_ID	INR
4	ALL	hardcoded	SLRorIRS	ALL
5	MASTER	hardcoded	SchemeID	MASTER
6	llg.cf_type	Outflow or Inflow. 🔗	CashflowType	O or I
7	tot_prin_amt	Total principal amount. 🔗	Amount	61114535307.96
8	rt_prin_amt_weighted	Rate principal amount weighted.🔗	InterestRate	0.0000

4.2 Output file-2 : Health report

The health check report gives summary about the processed accounts such as success counts, failed counts, etc.🔗

Output derivation logic:

• tot_prin_amt :

  Aggregated on the basis of LLGkey generated, which consists of llg.currency, llg.category and llg.cf_type
  
  tot_prin_amt = Σ prin_amt
  
  Note: If is_amt_abs is set, then before summation take absolute value of principal amount.
  Also if is_aggr_amt_abs is set, then before writing to output take absolute value of total principal amount.
    

• rt_prin_amt_weighted :

  Aggregated on the basis of LLGkey generated, which consists of llg.currency, llg.category and llg.cf_type
  
  rt_prin_amt_weighted = Σ prin_amt * int_rt / tot_prin_amt
  
  Note: If is_amt_abs is set, then before summation take absolute value of principal amount and interest rate. Also if is_aggr_amt_abs is set, then before writing to output take absolute value of rate principal amount weighted.