Search     Invoicing Servicer

Import Process Report

Use this report to review a listing of import process statistics, including those loans that were not imported into the system.

To access the Import Process Report, users need to be configured to the Loan Data File Import Error Notification permission group. Contact your company's system administrator for more details.

To review the import process report:

1. On the toolbar, point to Reports and click Import Process Report.

   The Import Process Report search fields appear.

2. In the Date Range fields, type or select the appropriate date range.
3. Click Search.

   The Import Process Report appears.

   The following information appears:

   • Processed File Name - The full name of the service request import file processed.
   • File Type - Type of file imported.
   • New Records - Number of new records within the import file that were inserted into the application.
   • Existing Records - Number of records that already exist in the application that were updated in the table.
   • Error Records - Number of records that contain errors within the import file and did not import successfully. Depending upon your company configuration and permissions, for certain file types, the value in this column appears as a link that displays error information. The error information varies depending on the import file type:
     • Claim # - The claim number associated to the loan.
     • Error Code - The error code.
     • Error Message - The error description.
     • Failed Line - The line of raw data from the loan data file that encountered an error due to a formatting issue where it was not possible to associate the failed line to a loan number.
     • Import Status - The import status of the record.
     • Investor Code - The code that identifies the investor.
     • Investor Loan # - The loan number assigned by the investor.
     • Line # - The record number from the file that encountered an error.
     • Loan Number - The loan number from the loan file that failed to be inserted or updated during the import process due to an issue other than formatting.
     • Record ID - The ID associated to the record in the file.
     • Servicer Code - The code that identifies the servicer.
     • Servicer Loan # - The loan number assigned by the servicer.
   • Duplicate Records - Number count of duplicate records in the DEFT file.
   • Total Records - Total number of records within the import file. The value is the sum of the values in the New Records, Existing Records, Duplicate Records, and Error Records column. Note: The total records count will reconcile against the DEFT file.
   • Date - Date and time the import file was received.
   • Total Minutes - Total amount of import processing time, rounded to the highest minute.

Top of Page

Confidential, Proprietary and/or Trade Secret
TM SM Registered Trademark(s) of Intercontinental Exchange, Inc. or a subsidiary or affiliate
Copyright 2024 Intercontinental Exchange, Inc. All Rights Reserved
ICE | Privacy Notice

Confidential, Proprietary and/or Trade Secret
TM SM Registered Trademark(s) of Intercontinental Exchange, Inc. or a subsidiary or affiliate
Copyright 2024 Intercontinental Exchange, Inc. All Rights Reserved
ICE | Privacy Notice