The report programs available under the Collections (CN) module are explained in this chapter. All activities that are performed by the CN module are recorded. The inputs you have made at different stages of the contract are pieced together and can be extracted in the form of meaningful reports as and when you may require them.
The reports that can be generated for the CN Module are as follows:
Note
Note that for some of the reports you do not have to make any specifications. For such reports, there is no Report Options screen.
This chapter contains the following sections:
This section contains the following topics:
An OBIEE repository is created for the customer collection interaction details. In addition to the CN module data stores some core data stores like the customer, currency, branch is also provided.
Note
This can be used where the source of an Asset is “FLEXCUBE”
You can generate a report with all the loans that are under collection process with the following details:
This section contains the following topics:
The ‘Activity Report’ provides the list of the actionable items for the day for the agent. You can invoke this report screen by typing ‘CNRAGTAC’ in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button.
You can specify the following preferences for generating the report:
Agent ID
Specify the agent Id from the adjoining option list for whom you want to generate the report.
Agent Name
Based on the agent ID selected, the system displays the name of the agent.
Agent Group Code
Based on the agent ID selected, the system displays the group code to which the agent belongs.
Date
Specify the date till which you want to generate the report for the pending activities for the agent.
Collection Contract Status
Specify the status of the collection contract from the adjoining option list.
Report Format
Select the report format from the adjoining drop-down list in which you want to generate the report. You can select one of the following:
Report Output
Select the mode of output from the adjoining drop-down list. You can select one of the following:
Printer At
Select the printer location from the adjoining drop-down list. You can select one of the following:
Printer
Specify the path of the printer if you want to print the report.
The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the report is as follows:
Header
The Header carries the title of the Report, information on the branch code, the branch date, the user id, the module name, the date and time at which the report was generated and the page number of the report.
Body of the Report
Sr. No. |
Field Name |
Field Description |
1 |
Asset Reference Number |
Reference number of the asset |
2 |
Collection Reference Number |
Reference number of the collection contract |
3 |
Collection Contract Status |
Status of the collection contract |
4 |
Counterparty |
Name of the asset holder |
5 |
Counterparty ID |
Counterparty identification number |
6 |
Currency |
Currency of the asset |
7 |
Status |
Collection contract status |
8 |
Current Action |
Action performed |
9 |
Next Action |
Next action after the result |
10 |
Next Action Date |
Date on which the next action has been scheduled to initiate |
11 |
Asset Amount |
The total asset amount |
This section contains the following topics:
This report displays the list of assets that are overdue in the current branch. You can invoke this report screen by typing ‘CNRDLQOD’ in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button.
You can specify the following preferences for generating the report:
Branch Code
Specify the unique code for the branch from the adjoining option list.
Delinquency Component
Specify the delinquency for collection from the adjoining option list.
Minimum Delinquency Days
Specify the minimum days of delinquency.
Report Format
Select the report format from the adjoining drop-down list in which you want to generate the report. You can select one of the following:
Report Output
Select the mode of output from the adjoining drop-down list. You can select one of the following:
Printer At
Select the printer location from the adjoining drop-down list. You can select one of the following:
Printer
Specify the path of the printer if you want to print the report.
The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the report is as follows:
Header
The Header carries the title of the report, information on the branch code, the branch date, the user id, the module name, the date and time at which the report was generated and the page number of the report.
Body of the Report
Sr. No. |
Field Name |
Field Description |
1 |
Asset Reference Number |
Reference number of the asset |
2 |
Customer Number |
Customer identification number |
3 |
Customer Name |
The name of the customer |
4 |
Component Name |
Defaulted component name |
5 |
Schedule Due Date |
Due date for the payment |
6 |
Currency |
Currency in which the amount is displayed |
7 |
Amount Due |
Total due to be paid. |
8 |
Amount Settled |
Amount paid |
9 |
Delinquency Days |
Days when the payment is not made from the schedule due date. |
Note
This report is generated manually.
This section contains the following topics:
This report displays the list of actions and payments for an asset reference. You can invoke this report screen by typing ‘CNRASACT’ in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button.
You can specify the following preferences for generating the report:
Asset Reference Number
Specify the asset reference number from the adjoining option list for which you want to generate the report.
Branch Code
Specify the unique code for the branch from the adjoining option list.
From Date
Specify the date from when the report needs to be generated.
To Date
Specify the date until when the report needs to be generated.
Report Format
Select the report format from the adjoining drop-down list in which you want to generate the report. You can select one of the following:
Report Output
Select the mode of output from the adjoining drop-down list. You can select one of the following:
Printer At
Select the printer location from the adjoining drop-down list. You can select one of the following:
Printer
Specify the path of the printer if you want to print the report.
The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the report is as follows:
Header
The Header carries the title of the report, information on the branch code, the branch date, the user id, the module name, the date and time at which the report was generated and the page number of the report.
Body of the Report
Field Name |
Field Description |
Customer No |
Customer identification number |
Collection Reference Number |
Reference number of the collection contract |
Interaction Reference Number |
Reference number to identify the interaction |
Agent Code |
Agent identification number |
Agent Name |
The name of the agent |
Action Code |
Code of the action performed |
Action Result |
Result of the action initiated |
Action Date |
Date on which the action was initiated |
Next Action |
Next action after the result |
Next Action Date |
Date on which the next action has been scheduled to initiate |
Queue Id |
Name of the queue to which the collection belong to |
Media of Communication |
Mode of communication |
Currency |
The currency in which the amount is displayed |
Payment Amount |
Total due to be paid. |
Payment Date |
Date on which payment was made |
Note
This report is generated manually.
This section contains the following topics:
This report displays the list of delinquency and activities for the agent. You can invoke this report screen by typing ‘CNRDLQAG’ in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button.
You can specify the following preferences for generating the report:
Agent Id
Specify the agent Id from the adjoining option list for whom you want to generate the report.
Report Format
Select the report format from the adjoining drop-down list in which you want to generate the report. You can select one of the following:
Report Output
Select the mode of output from the adjoining drop-down list. You can select one of the following:
Printer At
Select the printer location from the adjoining drop-down list. You can select one of the following:
Printer
Specify the path of the printer if you want to print the report.
The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the report is as follows:
Header
The Header carries the title of the report, information on the branch code, the branch date, the user id, the module name, the date and time at which the report was generated and the page number of the report.
Body of the Report
Sr. No. |
Field Name |
Field Description |
1 |
Agent Id |
Agent identification number |
2 |
Branch Code |
Code of the branch |
3 |
Collection Reference No |
Reference number of the collection contract |
4 |
Asset Reference No |
Reference number of the asset |
5 |
Component Name |
Defaulted component name |
6 |
Schedule Due Date |
Due date scheduled for the payment |
7 |
Amount Due |
Total due to be paid. |
8 |
Amount Settled |
Amount paid |
9 |
Delinquency Days |
Days when the payment is not made from the schedule due date |
10 |
Action Code |
Code of the action performed |
11 |
Action Result |
Result of the action initiated |
12 |
Next Action |
Next action after the result |
13 |
Next Action Date |
Date on which the next action has been scheduled to initiate |
This section contains the following topics:
This report displays the payment mode for all the assets which has been handled by the agent between the ‘From’ and ‘To’ date. You can invoke this report screen by typing ‘CNRCASRT’ in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button.
You can specify the following preferences for generating the report:
Agent Id
Specify the agent Id from the adjoining option list for whom you want to generate the report.
From Date
Specify the date from when the report needs to be generated.
To Date
Specify the date until when the report needs to be generated.
Report Format
Select the report format from the adjoining drop-down list in which you want to generate the report. You can select one of the following:
Report Output
Select the mode of output from the adjoining drop-down list. You can select one of the following:
Printer At
Select the printer location from the adjoining drop-down list. You can select one of the following:
Printer
Specify the path of the printer if you want to print the report.
The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the report is as follows:
Header
The Header carries the title of the Report, information on the branch code, the branch date, the user id, the module name, the date and time at which the report was generated and the page number of the report.
Body of the Report
Sr. No. |
Field Name |
Field Description |
1 |
Collection Reference Number |
Reference number of the collection contract |
2 |
Asset Reference Number |
Reference number of the asset |
3 |
Branch Code |
Code of the branch |
4 |
Value Date |
Amount paid date |
5 |
Payment Amount |
Total amount paid. |
6 |
Currency of Payment |
Payment currency |
Note
This report is generated manually.
This section contains the following topics:
This report displays the list of customers and their asset details which are under selected agent. You can invoke this report screen by typing ‘CNRCUSRP’ in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button.
You can specify the following preferences for generating the report:
Agent Name
Specify the agent name from the adjoining option list for whom you want to generate the report.
From Date
Specify the date from when the report needs to be generated.
Number of Days
Specify the number of days for which you want to generate the report.
Report Format
Select the report format from the adjoining drop-down list in which you want to generate the report. You can select one of the following:
Report Output
Select the mode of output from the adjoining drop-down list. You can select one of the following:
Printer At
Select the printer location from the adjoining drop-down list. You can select one of the following:
Printer
Specify the path of the printer if you want to print the report.
The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the report is as follows:
Header
The Header carries the title of the report, information on the branch code, the branch date, the user id, the module name, the date and time at which the report was generated and the page number of the report.
Body of the Report
Sr. No. |
Field Name |
Field Description |
1 |
Customer Id |
Customer identification number |
2 |
Collection Ref Number |
Reference number of the collection contract |
3 |
Collection Initiated Date |
Date on which the collection was initiated |
4 |
Asset Reference No |
Reference number of the asset |
5 |
Asset Related Details |
Product code of the asset |
6 |
Number of Days |
Number of overdue days for the payment |
Note
This report is generated manually.
This section contains the following topics:
This report displays the list of interactions which are initiated by the agent. You can invoke this report screen by typing ‘CNRINTSM’ in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button.
You can specify the following preferences for generating the report:
Agent Name
Select the name of the agent from the option list.
From Date
Specify the date from when the report needs to be generated.
To Date
Specify the date until when the report needs to be generated.
Report Format
Select the report format from the adjoining drop-down list in which you want to generate the report. You can select one of the following:
Report Output
Select the mode of output from the adjoining drop-down list. You can select one of the following:
Printer At
Select the printer location from the adjoining drop-down list. You can select one of the following:
Printer
Specify the path of the printer if you want to print the report.
The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the report is as follows:
Header
The Header carries the title of the Report, information on the branch code, the branch date, the user id, the module name, the date and time at which the report was generated and the page number of the report.
Body of the Report
Sr. No. |
Field Name |
Field Description |
1 |
Branch Code |
Code of the branch |
2 |
Interaction Reference Number |
Reference number to identify the interaction |
3 |
Asset Reference Number |
Reference number of the asset |
4 |
Customer Id |
Customer Identification number |
5 |
Customer Name |
The name of the customer |
6 |
Collection Reference Number |
Reference number of the collection contract |
7 |
Collection Initiated Date |
Date on which the collection was initiated |
8 |
Asset Related Details |
Asset product code |
Note
This report is generated manually.
This section contains the following topics:
This report displays the list of interactions which are initiated by the agent and corresponding result of the interaction. You can invoke this report screen by typing ‘CNRAGIND’ in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button.
You can specify the following preferences for generating the report:
Agent Name
Select the collection agent name from the adjoining option list.
From Date
Specify the start date of the report date range. The system will generate the report covering the details from this date.
To Date
Specify the end date of the report date range. The system will generate the report covering the details until this date.
The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the report is as follows:
Header
The Header carries the title of the Report, information on the branch code, the branch date, the user id, the module name, the date and time at which the report was generated and the page number of the report.
Body of the Report
Field Name |
Field Description |
Interaction Ref No |
Reference number to identify the interaction |
Asset Reference Number |
Reference number of the asset |
Asset Currency |
Currency of the asset |
Asset Amount |
Total asset amount |
Customer Id |
Customer identification number |
Customer Name |
The name of the customer |
Collection Reference Number |
Reference number of the collection contract |
Collection Initiated Date |
Date on which the collection was initiated |
Action Initiated |
Action performed |
Action Initiation Date |
Date on which the action was initiated |
Result of Action |
Result of the action initiated |
Next Action |
Next action after the result |
Next Action Date |
Date on which the next action has been scheduled to initiate |
PTP Amount |
Amount promised to pay |
Note
This report is generated manually.
This section contains the following topics:
This report displays the collection fee liquidation to the agent in a specified internal for the given branch. You can invoke this report screen by typing ‘CNRFEEL’ in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button.
You can specify the following preferences for generating the report:
Branch Code
Specify the Unique code of the branch from the adjoining option list.
From Date
Specify the date from when the report needs to be generated.
To Date
Specify the date until when the report needs to be generated.
Agent ID
Select the agent ID from the option list.
Report Format
Select the report format from the adjoining drop-down list in which you want to generate the report. You can select one of the following:
Report Output
Select the mode of output from the adjoining drop-down list. You can select one of the following:
Printer At
Select the printer location from the adjoining drop-down list. You can select one of the following:
Printer
Specify the path of the printer if you want to print the report.
The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the report is as follows:
Header
The Header carries the title of the Report, information on the branch code, the branch date, the user id, the module name, the date and time at which the report was generated and the page number of the report.
Body of the Report
Sr. No. |
Field Name |
Field Description |
1 |
Branch Code |
Code of the branch |
2 |
Agent Id |
Agent identification number |
3 |
Collection Reference Number |
Reference number of the collection contract |
4 |
Asset Reference Number |
Reference number of the asset |
5 |
Liquidation Ref Number |
Reference number of liquidation of the asset |
6 |
Liquidated Date |
Date on which the asset was liquidated |
7 |
Currency |
Currency of the asset |
8 |
Asset Liq Amount |
The asset liquidation amount |
9 |
Fee Liq Amount |
The fee liquidation amount |
Note
This report is generated manually.
This section contains the following topics:
You can invoke this report screen by typing ‘CNRINTDT’ in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button.
You can specify the following preferences for generating the report:
Collection Agent ID
Select the collection agent id from the following options:
Collection Agent ID
If the collection agent id is selected as Specific, then specify the collection agent id from the adjoining option list.
Loan Reference Number
Select the loan reference number from the following options:
Loan Reference Number
If the loan reference number is selected as specific, then specify the loan reference number from the adjoining option list.
Product
Select the product from the following options:
Product
If the product is selected as specific, then specify the product from the adjoining option list.
Collection Status
Specify the collection status from the adjoining option list.
Customer ID
Specify the customer ID from the adjoining option list.
The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the report is as follows:
Header
Field Name |
Field Description |
Report Name |
Indicates Report Name |
Branch Code / Branch Name |
Indicates Current Branch code and Branch Name |
User ID |
Indicates the Identification of the User |
Module |
Indicates the Module of the Report |
Report Run Date |
Indicates Current Branch Date |
Report Run Time |
Indicates Current Branch Time |
Body of the Report
Field Name |
Field Description |
Interaction Reference Number |
Indicates the interaction reference number |
Collection Reference Number |
Reference number of the collection contract |
Loan Reference Number |
Indicates the loan reference number |
Product |
Indicates the product code |
Customer ID |
Indicates the customer ID |
Customer Name |
Indicates the name of the customer |
Collection Status |
Indicates the status of the collection |
Collection Agent |
Indicates the collection agent |
Currency |
Currency of the asset |
Action Code |
Indicates the action code |
Interaction Date |
Indicates the interaction date |
Next Action |
Indicates the next action |
Next Action Date |
Indicates the date of the next action date |
Result Code |
Indicates the result code |
Result Date |
Indicates the date of the result code |
Amount |
Total due to be paid |
Comments |
Indicates comments, if any |