src_gl_recon_data

1. Description

src_gl_recon_data program reads the cf file, llg recon outputs and one master file and aggregates the amount grouped by src_field_cd, gl_type, src_gl_cd, gl_desc and src_ccy.

2. Program location

<installation_path>/src_gl_recon_data

3. Input

Click ⬇️ to download the sample data.

3.1 Mandatory Parameters

#	Parameters	Description	Example
1	as_on_date	The date for which the program has to run	26-09-2023
2	input-file	Path to the input file	test-bed/out.cf
3	account-metadata-file	Path to the metadata file	test-bed/om.json
4	llg-recon-file	Path to the llg-recon-file directory where the outputs from llg_gl_recon_aggr are placed	test-bed/loans_llg_gl_recon.txt
5	req-fields-file	Path to the required-field file	test-bed/req.json
6	output-file	Path to the output file	test-bed/op/loans
7	log-file	Path to write logs	test-bed/op/log.txt
8	diagnostics-log-file	Path to write diag-logs	test-bed/op/diag.txt
9	exchange-rate-file	Path to the exchange-rate file	test-bed/ex.txt
10	src_local_ccy	Source local currency. 🔗	INR
11	db-name	Database name where output to be loaded	ORACLE/MSSQL
12	schema-name	Schema name in the database where output to be loaded	dbo
13	connection-string	Connection credentials to connect to the database	Oracle (Username|Password|IP:PORT/Servicename) and Mssql (Server|Database|UserName|Password)

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	log-level	file where logs are written	info	error/warn/info/debug/trace/none
3	diagnostic-flag	set to write diagnostics or not	true	true/false
4	default-gl-code	if no rules are satisfied, then this gl code will be used	8000	8888
5	master-file	path to master file. This master file contains glcode, tblglcode and almdesc separated by pipe.	NA	test-bed/master.txt
6	option	Additional parameters to be used for sqlcmd,sqlldr & sqlplus.The option parameters should be pipe seperated,containing the identification key and its value.	""	m,2|l,10

Required field file

#	Parameters	Description	Example
1	gl_amount	amount	amount
2	gl_cd	gl_code	gl_cd
3	ccy	currency	curr

4. Output

4.1 Output file-1 : Aggregated Output

It will be uploaded in SrcGLReconData table.

#	Field	Description	Columns	Example
1	formatted_as_on_date	Date of operation as passed through input	AsOnDate	26-09-2023
2	src_field_cd	Input File name	SrcFileCd	loans
3	gl_type	hardcoded in the code	GLType	empty_string
4	src_gl_cd	It takes gl_code from input-file using gl_cd field of required-field as key, if not found then takes the default llg code passed as input parameter.Then checks if masterfile path has been passed as input parameter, then take gl_code value from gl_master_map using previously generated gl_code as key.	SrcGLCd	1111
5	gl_desc	gl description from alm file with gl_code as key	GLDesc	Borrowings -Loans
6	src_ccy	currency type initialized in input	SrcCCY	INR
7	gl_amt	if is_consolidated, then converted aggregated amount else aggregated amount	SrcGLAmtLCY	750000
8	conv_data_gl_amt	if is_consolidated, then aggregated amount else converted aggregated amount	SrcGLAmtCCY	15000

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:

• gl_amt :

    Aggregated on the basis of AggregatorKeys generated, which consists of src_field_cd, gl_type, src_gl_cd, gl_desc and src_ccy
  
    gl_amt+ = amount

• converted gl_amt :

     If is_consolidated is set to true, it converts the gl_amt to base_currency type and store it,
     else if is_consolidated is set to false, converted gl_amt is same as gl_amt.

5. Process configuration in streamdef table:

  .........
    {
      "processName": "SRC GL RECON",
      "processId": "1",
      "processBinary": "{SH_PROGRAMS}/src_gl_recon_data",
      "processArguments": [
          "--input-file",
          "{SH_CFDATA}/IND/{ddmmyyyy}/gl.cf",
          "--llg-recon-file",
          "{SH_SUMMARYDATA}/IND/BALM/{ddmmyyyy}/llg-gl-recon",
          "--output-file",
          "{SH_SUMMARYDATA}/IND/BALM/{ddmmyyyy}/summary-src-gl-recon.txt",
          "--as-on-date",
          "{AsOnDate}",
          "--log-file",
          "{SH_LOGS}/IND/BALM/{ddmmyyyy}/summary-src-gl-recon-log.txt",
          "--diagnostics-log-file",
          "{SH_LOGS}/IND/BALM/{ddmmyyyy}/summary-src-gl-recon-diaglog.txt",
          "--is-consolidated",
          "false",
          "--default-gl-code",
          "8000",
          "--exchange-rate-file",
          "{SH_RESOURCES}/IND/{ddmmyyyy}/exchangeRate.txt",
          "--master-file",
          "{SH_RESOURCES}/IND/OPERATIONAL-FILES/alm-master-file.txt",
          "--src-local-ccy",
          "INR",
          "--req-fields-file",
          "{SH_RESOURCES}/IND/OPERATIONAL-FILES/BALM-REQ-FIELD-FILES/balm_src_gl_req_fields.json",
          "--account-metadata-file",
          "{SH_RESOURCES}/IND/OPERATIONAL-FILES/CF-METADATA-FILES/gl_metadata.json",
          "--db-name",
          "{DB}",
          "--schema-name",
          "{BALM_SCHEMA}",
          "--connection-string",
          "{BALM_CONN_STR}"
      ],
      "processDependencies": [
      ],
      "processReport": "{SH_SUMMARYDATA}/IND/BALM/{ddmmyyyy}/summary-src-gl-recon-health-check-report.json",
      "processType": "",
      "infoLog": "{SH_LOGS}/IND/BALM/{ddmmyyyy}/summary-src-gl-recon-log.txt",
      "errorLog": ""
    }
  .........