Processing Due Diligence/Scrub Files

NDC Allows National Creditors to process Due Diligence or Scrub files against our national database of case and claims data. 

To get started with Scrub/Diligence files, there are a couple of prerequisites before running a file through the NDC Files processing system

1) The Authorization file must be completed and available in PDF form. Please see this article for information about filling out the form.

2) The scrub/diligence file must be available in the correct format. Please see this article for details on the file format and notes on how the file is processed

3) (Update 5/2020) You must have Manager permission to use the Files tab. If you don't please see your internal NDC.org administrator/manager to change your permission.

If both of these are ready, here is how to process a scrub/diligence file using the NDC portal

 

Go to the Files tab and press the Import New option

mceclip1.png

 

Click Select File to select a file to use. Remember the file must be in the correct format (see xxx)

Next Add a description of this file that will be processed and scrubbed.

Use the Select Authorization File dropdown to select a previously loaded Authorization file (see xxx)

 

mceclip0.png

Press the Preview File button to make sure your file fits the column layout.

mceclip2.png

If the layout looks as expected, press the Process File button. If not, you must correct the file and use Select File to begin the steps again

Once you've pressed Process File your browser will return to the Data Files grid, which will refresh every 10 seconds with the status of the processing.

mceclip3.png

If you select Summary you will be taken to a page that shows the progress of the processing

mceclip4.png

Hit the Back button on your brows to return to the Data Files page.

When the processing is finished you will see the View Report link available in the grid

mceclip5.png

Click View Report to bring up the NDC Reporting environment where you will be able to setup the output for this scrub.

 The report will contain the following columns

CASE_NUMBERNDC Case Data
ORIGINAL_ACCT_LOAN_IDFrom Scrub/Diligence File
TRUSTEE_NAMENDC Case Data
DEBTOR_1NDC Case Data
DEBTOR_2NDC Case Data
DEBTOR_ADDRESSNDC Case Data
ATTORNEY_NAMENDC Case Data
ATTORNEY_ADDRESSNDC Case Data
TOTAL_PAID_BOTH_DEBTOERS_FREQUENCYNDC Case Data
PLAN_MONTHSNDC Case Data
MONTHS_INTO_CASENDC Case Data
UNSECURED_PCTNDC Case Data
Filed_DTNDC Case Data
Bar_DTNDC Case Data
TRUSTEE_CASE_STATUSNDC Case Data
COURTNDC Case Data
NDC_CASE_STATUSNDC Case Data
LAST_RECEIPT_DATENDC Case Data
LAST_PAYMENT_DATENDC Case Data
PLAN_CONFIRMED_DATENDC Case Data
MONTHLY_PAYMENT_AMTNDC Case Data
INTEREST_RATENDC Case Data
CLAIM_CREDITOR_NAMENDC Claim Data
CLAIM_ADDRESSNDC Claim Data
CLAIM_TYPENDC Claim Data
CLAIM_NUMNDC Claim Data
CLAIM_AMTNDC Claim Data
CLAIM_ACCOUNTNDC Claim Data
PRINCIPAL_PTDNDC Claim Data
PRINCIPAL_OWEDNDC Claim Data
INTEREST_PAIDNDC Claim Data
CLAIM_COMMENTNDC Claim Data
PAYMENT_CREDITORNDC Payment History
PAYMENT_CREDITOR_ADDRESSNDC Payment History
PAYMENT_DATENDC Payment History
CHECK_NUMBERNDC Payment History
PAYMENT_DESCRIPTIONNDC Payment History
PAYMENT_AMOUNTNDC Payment History
DATA_RUNReport Info

On the Reporting tab you'll see a screen similar to this. 

Select the File that was just processed and the Payment History detail you'd like to see.

mceclip6.png

The Payment History settings are

No Payment History: will not generate any payment history per each claim

3 Months: Will generate the last three months of payment history (if present) per claim

6 Months: Will generate the last six months of payment history (if present) per claim

ALL: Will generate all payment history per claim

NOTE: the output will be much smaller and execute faster if you select No Payment History. Most Diligence/Scrub analysis do not need the payment history and it will be much easier to analyze the data without the additional history details.

mceclip7.png

Press View Report

You may experience some delay as the reporting system converts the processed file into the report. It is not uncommon for this delay to exceed several minutes, thus you may see the message Waiting for ndc.org... in the bottom of your browser

mceclip8.png

Here is the report, however it's very long and we inserted graphical cuts in the image for readability.

2020-05-07_16-48-39.jpg

Notice there's a lot of white space. There is detail however it's hidden by the scrolling system. To see the entire report scroll to the bottom of your browser and then use the scroll bar within the blue-box region to scroll to the right.

 

mceclip1.png

Most people want to analyze this data outside of the online report so download the report by scrolling the web page to the top and select the floppy-drive icon. Then select CSV

mceclip2.png

Again you will see the Waiting for ndc.org at the bottom of most browsers, indicating that the reporting system is converting the online report to a csv file

mceclip3.png

Finally the report will begin to transmit to your browser as a csv file

mceclip4.png

 

You may click on the file to open it up, for example within Excel

mceclip5.png

 

We suggest you format the file for readability, and then apply the Filter function

mceclip6.png

This will allow you to view only those claims which are relevant to your Scrub/Diligence needs. We suggest filtering on column W for the Creditor Name

mceclip7.png

mceclip8.png

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.