mis_cat_dep

1.Description

Tis program reads input file, cust_master_file, rbi_cat_def_file, rbi_cat_map_file and aggregates the data based on ca,sa,td,depth,order,aggr_key.

2. Input

2.1 Mandatory Parameters

#	Parameters	Description	Example
1	as_on_date	The date for which the program has to run	26-09-2023
2	process-config	Path to process config file that needs to be processed	configs/process.json
3	connection-string	Connection credentials to connect to the database	Oracle (Username|Password|IP:PORT/Servicename)
4	display-currency	The display currency	USD
5	log-file	Path to write logs	logs/application.log
6	diagnostics-log-file	Path to write diagnostics logs	logs/diagnostics.log

2.2 Non Mandatory Parameters

#	Parameters	Description	Default value	Example
1	log-level	Level of diagnostics written to the log file	info	debug
2	diagnostics-flag	Flag to enable/disable performance diagnostics in the diagnostics log file	false	true

3. Output

The output for each account in each file is of the format

output_file|as_on_date|disp_ccy|aggr_key|rbi_cat_name|ca_amt|sa_amt|td_amt|depth|order|is_highlight|

3.1 Output Derivation Logic

For each account:
>the aggr_key is fetched from the master_file based on cust_id.
>if rbi_cat_depth_order has rbi_cat_id then
    -rbi_cat_name value is stamped 
    -depth is value stamped
    -order is value stamped
    -is_highlight is value stamped 
>else 
    -rbi_cat_name value is stamped as empty
    -depth is value stamped as 0
    -order is value stamped as 0
    -is_highlight is value stamped as empty

4. Process configuration in streamdef table:

{
    "processName": "mis_cat_dep_2",
    "processId": "1",
    "processBinary": "{SH_PROGRAMS}/mis_cat_dep_2_data",
    "processArguments": [
        "--process-config",
        "${PROCESS_CONFIG}",
        "--log-file",
        "${LOG_FILE}",
        "--diagnostics-log-file",
        "${DIAGNOSTICS_FILE}",
        "--display-ccy",
        "RUP",
        "--as-on-date",
        "31-03-2020",
        "--log-level",
        "info",
        "--diagnostics-flag",
        "false",
        "--connection-string",
        "{CONN_STR}"
        ],
    "processDependencies": [],
    "processReport": "{SH_SUMMARYDATA}/IND/BALM/{ddmmyyyy}/summary-mis-cat-dep-report.json",
    "processType": "",
    "infoLog": "{SH_LOGS}/IND/BALM/{ddmmyyyy}/summary-mis-cat-dep-log.txt",
    "errorLog": ""
}