Follow

How data in the Portfolio Monitoring Report is processed and displayed

Balances and Account Statuses used in stored procedure

When the Portfolio Monitoring Report procedure (aka PMR procedure) is run, it generates historical data that it puts in a historical data table.

The PMR procedure generates this historical data from the account and account history tables.

Once this historical data has been generated, the PMR procedure uses this data to get the balances and account statuses of the accounts operated by the Subscriber (i.e. the institution that ordered the report).

The PMR procedure gets the balances and account status that were current on the ReportDate that the report is being ordered for, and uses these account statuses and balances in the report.

In addition, the balance of an account that is used in the report is converted from being negative to positive if the account's type is a credit card account (i.e. either CL01 or PL01).

 

Filtering PMR data using Balance

The balance obtained from the historical data tables is actively used in filtering out accounts and customers, especially when the MinimumBalance and NumberOfPersons criteria are specified.

For example, let's say that an account ACCT001 has the following history for the Subscriber:

Account Status

Account Status Date

Balance

Balance Date

30

1 Mar 2015

-20000

1 Mar 2015

60

1 Apr 2015

-40000

1 Apr 2015

90

1 May 2015

-50000

1 May 2015

90

1 Jun 2015

-60000

1 Jun 2015

60

1 Jul 2015

-40000

1 Jul 2015

30

1 Aug 2015

-30000

1 Aug 2015

 

Let's also say that this account is owned by Joseph Okoro, and this is the only account he owns.

And lastly, let's say that the account type of the account is PL01.

 

Then if a report is requested for the Subscriber as of 17 Jul 2015, then the procedure will look for the latest history record just before 17 Jul 2015, namely:

60

1 Jul 2015

-40000

1 Jul 2015

 

Since the account type is PL01, then the balance will be converted from -40,000 to 40,000, and it is this value of 40,000 that will be used as the balance (as well as the value of 60 being used as the account status) in the report

 

So for a report that is requested with a ReportDate of 17 Jul 2015 and a MinimumBalance parameter value of 30,000, Joseph Okoro will be included in the report, because ACCT001's balance as of 17 Jul 2015 is 40,000 - more than the 30,000 minimum.

But for a report where again, the ReportDate is 17 Jul 2015 but the NumberOfCustomers parameter is 5, then if the total balances of the Subscriber’s top 5 customers order by total balance is as follows:

  • 100,000
  • 85,000
  • 80,000
  • 75,000
  • 70,000

then Joseph Okoro will be excluded from the report, because his total balance is not in the top 5 total balances.

 

Filtering using other criteria

Other criteria used to exclude customers from the report are as follows:

If

  • All of the customer's accounts have both:
    • an account status of closed (999)
    • a balance of 0 (as obtained from the historical data and account type)

Or

  • All of the customer's accounts have an account type is one of the following:
    • CA00
    • CA01
    • CA04
    • CA03
    • CA02
    • PA00
    • PA01
    • PA02
    • PA03
    • PA04

Then the customer will be excluded from the PMR.

 

Subscriber-specific criteria

There are also customer specific criteria:

  • First Bank excludes accounts which:
    • Have total balance (as obtained from the historical data and account type) greater than 1
    • Have their sort codes being any of the following:
      • 141
      • 999
      • 319
  • Aso Savings excludes accounts which:
    • Have their account numbers with the following:
    • SOFGH
    • NPA
    • NERC
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

3 Comments

  • 0
    Avatar
    Akin Akinsoto

    Currently, the report hides the names and registry IDs of creditors for an account in the detail report, unless
    - the account was not performing
    - the account was external (i.e. not operated by the subscriber requesting the PMR).

    According to Jameelah, this is because 

    "...if a customer complained about a decision the bank makes because of PMR, the bank wants to be able to tell the customer which lender reported negative information. Hence the name of the bank would only show is account was non performing.

    We do not show the name for performing external accounts for poaching reasons of course."

  • 0
    Avatar
    Akin Akinsoto

    There are six total figures that are (amongst others) used in the summary part of the PMR:

    - Total Number of Customers - this is the total number of the Subscriber's customers with liability accounts (i.e. accounts whose type is none of the following: CA00, CA01, CA02, CA03, CA04, PA00, PA01, PA02, PA03, PA04). The exception to this is Keystone Bank, for whom non-liability accounts (i.e. CA00-04 and PA00-04) are included

    - Total Number of Accounts - this is the total number of liability accounts operated by the Subscriber. The exception to this is Keystone Bank, for whom non-liability accounts are included.

    - Total Number of Monitorable Customers - this is the total number of the Subscriber's customers with open liability accounts that also have a non-zero balance. It is made up of the number of customers in the report plus the number of unmonitored customers (these are customers with open accounts that have non-zero balances that have excluded from the report due to specific criteria  applied by the subscriber). Again, the Keystone Bank exception applies.

    - Total Number of Monitorable Accounts - this is the total number of the open liability accounts operated by the Subscriber that also have a non-zero balance. It is made up of the number of accounts in the report plus the number of unmonitored accounts (i.e. open accounts with non-zero balances that are excluded from the report due to specific criteria). The Keystone exception applies.

    - Total Number of Monitored Customers - this is the total number of customers in the report.

    - Total Number of Monitored Accounts - this is the total number of customers in the report.

    Edited by Akin Akinsoto
  • 0
    Avatar
    Akin Akinsoto

    This comment is regarding an account - 0000726107 - that was excluded from a Q3 Stanbic PMR.

     

    The PMR query was correct to exclude the 0000726107 account.

     

    The short version:

    The account was reported to be closed as of 30 Jun.

     

    The long version:

    The PMR query attempts to get the latest state of an account as of the date that the PMR is generated for.

     

    This means that if a report is requested for 30 Sep 2015 (Q3), the PMR query will ask “What is the most recent history that I have for this account that is before 30 Sep 2015?” (The PMR query uses the balance date to determine how recent an account history is.)

     

    To get this history, the PMR query needs to generate a ton of historical data (this is what is generated when the refresh parameter is set to 1; this usually takes a long time, so the recommendation is not to set this to 1 unless a subscriber has uploaded some new data that might affect the PMR.)

     

    Once the PMR query has generated this historical data and obtained the history for the account, the PMR query will use the status of the account to determine whether it should be included/excluded from the PMR.

     

    I looked at the historical data that had been generated for the 0000726107, and I saw the following records:

     

    Report Date

    Account No

    Balance

    Balance Date

    Account Status

    Account Status Date

    2016-02-11

    0000726107

    -13.21

    2015-12-31

    90

    2015-12-31

    2015-12-31

    0000726107

    -12.66

    2015-11-30

    90

    2015-11-30

    2015-09-30

    0000726107

    0.00

    2015-06-30

    999

    2015-06-30

    2015-07-01

    0000726107

    0.00

    2015-05-31

    0

    2015-05-31

    2015-06-30

    0000726107

    0.00

    2015-05-31

    0

    2015-05-31

     

    Note the row for 2015-09-30; this is the history of the account that was retrieved prior to generating the PMR for 30 September.

     

    We can see from this that the most recent history that was found that was before 30 September was the history of the account on 30 June, and this history shows that the account was closed. (Perhaps additional information on that account has been sent to the bureau since then, but for this additional information to show up, the Q3 PMR would need to be refreshed.)

     

    Because this account was closed, it was excluded from the PMR.

     

    It will be difficult to do these kinds of investigations automatically; what I would recommend is that you do the following:

    • get PSG to pick several affected accounts

     

    • for each account with account number AccountNo, run the following query to determine what the status of the account was as of 30 June:

     

    select top 1 * from PSG_vwCustomerAccountHistoryData

    where [Account No] = 'AccountNo'

    and [Account History Balance Date] <= '30 Jun 2015'

    order by [Account History Balance Date] desc

     

    • If the status history shows that the account was closed as of any of those dates, then that explains why the account was excluded.
    Edited by Akin Akinsoto
Please sign in to leave a comment.
Powered by Zendesk