Follow

How to investigate PMR issues

How the following issues were investigated.  

The issues:

No.

Issue

Comment

Examples

1

Missing accounts as of June 30, 2015

        i.          Stanbic FTP files for June 30, 2015 was uploaded to bureau

       ii.          Bureau data matches FTP file uploaded

      iii.          PMR is missing accounts that were expected to be monitored.   

·        See attached spreadsheet with missing accounts that should be monitored based on data uploaded to bureau. see example In the Sheet Named “Missing Accounts in Q2 2015”

 

2.

Missing accounts as of September 30, 2015

i.      Stanbic FTP files for September 30, 2015 was uploaded to bureau

ii.     Bureau data matches FTP file uploaded

iii.    PMR is missing accounts that were expected to be monitored.   

·        See attached spreadsheet with missing accounts that should be monitored based on data uploaded to bureau. see examples in the Sheet Named “Missing Accounts in Q3 2015”

 

3

Mixed up accounts and CIFs

i.      0003556990      (Customer ID on PMR 000051409)

ii.     9200500379

iii.    9200514343   (Customer ID Uploaded 000014258)

iv.    9202483724

·        See Attached Spreadsheet with mixed up customer IDs and account numbers. Examples in the Sheet “MixedUp Accounts in Q2 2015 PMR” and “MixedUp Accounts in Q3 2015 PMR”

4.

Currency Code

i.      This ought to be provided monthly and the last dump was in February 2016

ii.     Stanbic will provide the currency codes month by month basis

·        Samples will be made available when Stanbic has done the uploads

5.

Customers monitored in PMR But not in Stanbic Upload for June 2015

        i.          Stanbic FTP files for June 30, 2015 was uploaded to bureau

iii.    PMR monitored Customers Not Uploaded in the FTP file

 

·        See Attached Spreadsheet with Customer IDs and account numbers over monitored. Examples in the sheet “Not Active But in PMR Q2 Stanbi”

6.

Customers monitored in PMR But not in Stanbic Upload for September 2015

        i.          Stanbic FTP files for September 30, 2015 was uploaded to bureau

       ii.          PMR monitored Customers Not Uploaded in the FTP file

 

·        See Attached Spreadsheet with Customer IDs and account numbers over monitored. Examples in the sheet “Not Active But in PMR Q3 Stanbi”

 

The investigation:

For items #1 and #2, the claim has been made that “PMR is missing accounts that were expected to be monitored”.

 

The question is – was it reasonable for PMR to exclude those accounts?

 

Assume here that there were no constraints whatsoever – that the subscriber did not:

  • request accounts with:
    • minimum credit limits
    • specific account types
    • specific account numbers
    • either only persons or only business account owners
  • request that accounts with zero credit limits be excluded

 

Also assuming that the subscriber did not request a maximum number of customers in the PMR.

 

Well, some sample accounts have been provided, so let’s take a look at the first account in the list – 0003556990. 

First of all, we need to find out if the accounts were closed as of Q2 2015.

In order to see the status of the first account (0003556990) as of end of Q2 2015, we run this query:

 

SELECT TOP 5 [Account History Balance Date], [Account History Balance],

            [Account History Status Date], [Account History Status ID]

FROM PSG_vwCustomerAccountHistoryData

WHERE [Account No] = '0003556990' -- account number in question

AND [Creditor Registry ID] = 731669726010353080 -- registry id of subscriber

AND [Account History Balance Date] <= '2015-06-30' -- last date for Q2 2015

ORDER BY [Account History Balance Date] DESC

 

This gives us back the following:

Account History Balance Date

Account History Balance

Account History Status Date

Account History Status ID

2015-06-30 00:00:00.000

-204010095.19

2015-06-30 00:00:00.000

0

2015-06-18 00:00:00.000

-180902442.12

2015-06-30 00:00:00.000

0

2015-06-16 00:00:00.000

-190001338.12

2015-06-30 00:00:00.000

0

2015-06-09 00:00:00.000

-179719833.12

2015-06-30 00:00:00.000

0

2015-06-08 00:00:00.000

-186963267.12

2015-06-30 00:00:00.000

0

 

The first row tells us that as of balance date 2015-06-30 (we use balance date),  the account had a status of 0, so it was performing. Thus, on this criteria, it is not disqualified for inclusion in the PMR.

 

The next step is to look at is whether the account is a non-liability account (only Keystone wants to monitor these, so if the subscriber is Keystone, skip this step).

Non-liability accounts are one of the following:

  • CA00
  • CA01
  • CA04
  • CA03
  • CA02
  • PA00
  • PA01
  • PA02
  • PA03
  • PA04

 

To find this out, run the following query:

 

SELECT [Account Type], [Credit Limit]

FROM PSG_vwCustomerAccountData

WHERE [Account No] = '0003556990' -- account number in question

AND [Creditor Registry ID] = 731669726010353080 -- registry id of subscriber

 

This gives us back the following:

Account Type

Credit Limit

CL00

205000000.00

CL00

205000000.00

CL00

205000000.00

 

So again, the account type is not a non-liability account, and again, on this criteria, it isn’t disqualified for inclusion into the PMR.

 

At this point, we should reurn the PMR to see if indeed the expected accounts have indeed been excluded as the account is expected to be in the PMR. 

 

On rerunning the PMR, I see the following (note the bolded):

 

Account No

Account Owner Registry ID

Customer Nos

Account Performance Code

Account Status

Account Type

Account Type Code

Balance Date

Balance

Collateral Value

Credit Limit

Creditor Name

Creditor Registry ID

Customer Initial

Customer Name

Customer Type

Date Last Reported

Date Opened

Group Type

Legal Status

Non-Performing Balance

Performing Balance

Performance Code

Term

First Account Number

First Account Type

Credit Score

Include In Report

0003556990

736037727652817097

000051409

P

Performing

Overdraft

CL00

2015-06-18 00:00:00.000

180902442.12

0.00

205000000.00

NULL

NULL

N

NIKOY NIGERIA LIMITED 736037727652817097

Business

2016-05-18 19:24:41.000

2012-12-10 00:00:00.000

Internal

None

0.00

180902442.12

PP

 

0003556990

Overdraft

549

1

 

If account is in bureau but not in the PMR, perhaps the reason is that some data was recently uploaded to make it appear. So a rerun of the PMR may resolve this issue.

PSG/Sales should conduct similar investigations on other accounts that are reported not to be present in the PMR, even though they are expected. It would be helpful to rerun the PMR and use that as the basis for the investigation.

 

For item #3, the claim has been made that “there are mixed up account numbers and CIFs”.

I have updated the customer numbers with the customer numbers in the third column, as seems appropriate.

I do not know how this mixup occurred; however, I have mentioned in the past that there seems to be inconsistency in the data reported by Stanbic, especially pertaining to multiple accounts.

 

For item #4, currency codes are to be provided by the subscriber for each account. The CBN official exchange rates are to be provided at the end of each quarter before generating PMRs. 

 

For items #5 and #6, the claim has been made that “Customers monitored in PMR But not in Stanbic Upload”. 

This complaint seems to be saying that only customers that were in the Stanbic upload should be monitored.

For clients that want a specific set of customers to be monitored, then provide that list of account numbers, and pass that list to the PMR query, as described here.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk