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_NUMBER NDC Case Data
ORIGINAL_ACCT_LOAN_ID From Scrub/Diligence File
TRUSTEE_NAME NDC Case Data
DEBTOR_1 NDC Case Data
DEBTOR_2 NDC Case Data
DEBTOR_ADDRESS NDC Case Data
ATTORNEY_NAME NDC Case Data
ATTORNEY_ADDRESS NDC Case Data
TOTAL_PAID_BOTH_DEBTOERS_FREQUENCY NDC Case Data
PLAN_MONTHS NDC Case Data
MONTHS_INTO_CASE NDC Case Data
UNSECURED_PCT NDC Case Data
Filed_DT NDC Case Data
Bar_DT NDC Case Data
TRUSTEE_CASE_STATUS NDC Case Data
COURT NDC Case Data
NDC_CASE_STATUS NDC Case Data
LAST_RECEIPT_DATE NDC Case Data
LAST_PAYMENT_DATE NDC Case Data
PLAN_CONFIRMED_DATE NDC Case Data
MONTHLY_PAYMENT_AMT NDC Case Data
INTEREST_RATE NDC Case Data
CLAIM_CREDITOR_NAME NDC Claim Data
CLAIM_ADDRESS NDC Claim Data
CLAIM_TYPE NDC Claim Data
CLAIM_NUM NDC Claim Data
CLAIM_AMT NDC Claim Data
CLAIM_ACCOUNT NDC Claim Data
PRINCIPAL_PTD NDC Claim Data
PRINCIPAL_OWED NDC Claim Data
INTEREST_PAID NDC Claim Data
CLAIM_COMMENT NDC Claim Data
PAYMENT_CREDITOR NDC Payment History
PAYMENT_CREDITOR_ADDRESS NDC Payment History
PAYMENT_DATE NDC Payment History
CHECK_NUMBER NDC Payment History
PAYMENT_DESCRIPTION NDC Payment History
PAYMENT_AMOUNT NDC Payment History
DATA_RUN Report 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

 

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