8. Reports

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:

8.1 OBIEE Repository

This section contains the following topics:

8.1.1 Creating OBIEE Repository

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”

8.1.2 Loans under Collection Process

You can generate a report with all the loans that are under collection process with the following details:

8.2 Activity Report

This section contains the following topics:

8.2.1 Generating Activity Report

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.

8.2.2 Contents of 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 Num­ber

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

8.3 Delinquency Analysis by Overdue Days

This section contains the following topics:

8.3.1 Generating Delinquency Analysis by Overdue Days

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.

8.3.2 Contents of 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.

8.4 Account Level Activity

This section contains the following topics:

8.4.1 Generating Account Level Activity

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.

8.4.2 Contents of 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 sched­uled to initiate

Queue Id

Name of the queue to which the collection belong to

Media of Communica­tion

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.

8.5 Delinquency and Activity by each Collection Agent

This section contains the following topics:

8.5.1 Generating Delinquency and Activity by each Collection Agent

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.

8.5.2 Contents of 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 sched­uled to initiate

8.6 Cash Receipts by Collector, Daily and Month to Date

This section contains the following topics:

8.6.1 Generating Cash Receipts by Collector, Daily and Month to Date

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.

8.6.2 Contents of 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 Num­ber

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.

8.7 Customer Aging Report by Collector (Agent)

This section contains the following topics:

8.7.1 Generating Customer Aging Report by Collector (Agent)

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.

8.7.2 Contents of 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.

8.8 Contacts Results and tickles by Collector (Agent) Summery

This section contains the following topics:

8.8.1 Generating Contacts Results Summary Report

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.

8.8.2 Contents of 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 Num­ber

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.

8.9 Contacts Results and tickles by Collector (Agent) De­tailed Report

This section contains the following topics:

8.9.1 Generating Contacts Result Detailed Report

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.

8.9.2 Contents of 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

Interaction Ref No

Reference number to identify the interaction

Asset Reference Num­ber

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 sched­uled to initiate

PTP Amount

Amount promised to pay

 

Note

This report is generated manually.

8.10 Fee Liquidated to Collection Agent

This section contains the following topics:

8.10.1 Generating Fee Liquidated to Collection Agent Report

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.

8.10.2 Contents of 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 Num­ber

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.

8.11 Collection Interaction Details

This section contains the following topics:

8.11.1 Generating Collection Interaction Report

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.

8.11.2 Contents of 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

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 Num­ber

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