llg_src_gl_recon

1.Description

This program reads a cf file, master file and additional files and aggregates data and gives a summary for LLG_GL and SRC_GL.

2. Input

2.1 Mandatory Parameters

#	Parameters	Description	Example
1	process_config	Path to the process configuration file that needs to be processed	/path/to/process_config.json
2	consol_ccy	The consolidation currency	USD
3	as_on_date	The date for which the program should run	2025-01-01
4	log_file_path	Path to write logs	/path/to/log_file.txt
5	diagnostics_file_path	Path to write diagnostics logs for performance and error tracking	/path/to/diagnostics_file.txt
6	connection_string	Connection credentials in JSON format to connect to the database	Oracle (Username|Password|IP:PORT/Servicename) and Mssql (Server|Database|UserName|Password)

2.2 Non-Mandatory Parameters

#	Parameters	Description	Default Value	Example
1	default_llg_code	The default LLG code to stamp if necessary	99999	12345
2	default_gl_code	The default GL code to stamp if necessary	99999	67890
3	is_consolidated	Flag to decide whether the currency is consolidated	false	true
4	log_level	Level of diagnostics written to the log file	none	error/warn/info/debug/trace
5	is_perf_diagnostics_enabled	Flag to decide if performance diagnostics will be logged	false	true

2.3 Required field file

#	Parameters	Description	Example
1	input_file_id	Id of the input file	M_IN001
2	rules_file_id	Id of the rules file	1000
3	acc_num	Field for account number	18372
4	gl_code	Field for general ledger code	2000
5	currency	Field for currency	ccy
6	gl_amount	Field for general ledger amount	gl_amt

3. Output

Two Files will be generated one for LLG_GL and one more for SRC_GL and health check reports will be generated for each.

3.1 Output file for LLG_GL

It will be uploaded in LLGReconData table.

#	Field	Description	Columns	Example
1	formatted_as_on_date	Date of operation as passed through input	As_On	26-09-2023
2	source_name	Input File name	SourceFileCd	loans
3	keys.llg	llg code generated using rules file	LLGID	8888
4	keys.gl_cd	gl_cd extracted from metadata	GLCode	1111
5	keys.ccy	currency type initialized in input	CcyID	INR
6	values.aggr_amt	if is_consolidated, then converted aggregated amount else aggregated amount	BalLCY	750000
7	conv_data.aggr_amt	if is_consolidated, then aggregated amount else converted aggregated amount	BalCCY	15000

3.2 Output file for SRC_GL

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 Output Derivation Logic

4.1 Derivtion logic for LLG_GL

• aggr_amt :

    Aggregated on the basis of AggregatorKeys generated, which consists of llg_code, gl_code and ccy
  
    aggr_amt += gl_amount 

• converted aggr_amt :

     If is_consolidated is set to true, it converts the aggr_amt to base_currency type amount,
     else if is_consolidated is set to false, converted amount will be same as the original aggregated amount

4.2 Derivation logic for SRC_GL

• 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": "llg_src_gl_recon_aggr_2",
    "processId": "1",
    "processBinary": "{SH_PROGRAMS}/llg_src_gl_recon_aggr_2_data",
    "processArguments": [
        "--process-config",
        "${PROCESS_CONFIG}",
        "--log-file",
        "${LOG_FILE}",
        "--diagnostics-log-file",
        "${DIAGNOSTICS_FILE}",
        "--consol-ccy",
        "RUP",
        "--is-consolidated",
        "false",
        "--default-llg-code",
        "6666",
        "--default-gl-code",
        "5555",
        "--as-on-date",
        "30-06-2024",
        "--log-level",
        "trace",
        "--diagnostics-flag",
        "false",
        "--connection-string",
        "{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": ""
}