eCommitONE Import File Format
You may import loans into eCommitONE™ by first creating a comma-
delimited (csv) file to hold one or more loans (up to a maximum of 200)
and then using the Import Loan Data feature of eCommitONE to bring the
loans into the system. The format of the comma-delimited (csv) file is
detailed below. You may wish to create this file in a spreadsheet or
database program and then export it from there to a comma-delimited
format, or you may download and use the eCommitONE Loan Import
Support File, which includes the field names listed below. If you create
your own file, be sure to save it with a csv extension so that
eCommitONE recognizes it for importing.
Note: Once your comma-delimited file is created, see the job aid entitled
“Importing Commitments” for instructions on the actual import process.
Order Field Name Example Notes
Desktop Underwriter (DU)
1 Underwriting Method
Other
DU Casefile ID:
Non-DU Casefile
(for example, 2001515119)
2 Casefile ID IDs will begin with
Non-DU Casefile ID:
an “A.”
(for example, A65665097)
3 Master Contract Number MC05112
Loan number
4 Lender Loan Number assigned by the
lender.
Product name
must match
exactly the product
5 Product Name 30-Yr Fixed Rate names listed in
eCommitONE;
otherwise, the file
will not import.
Up to three digits
6 First Lien Note Rate 4.125
after the decimal.
Up to two digits
7 Loan Amount 160000.00
after the decimal.
Subject Property Number of
8 1–4 only.
Units
Important:
Since the import
Rate Lock Expiration
9 10/09/2008 file is in a .csv
(Borrower)
format, this field
must be
Order Field Name Example Notes
surrounded by
quotation marks
(“mm/dd/yyyy”) in
order to retain any
leading zeros.
Otherwise, the file
may not import.
Important:
Since the import
file is in a .csv
format, this field
must be
Commitment Expiration surrounded by
10 10/09/2008
Date quotation marks
(“mm/dd/yyyy”) in
order to retain any
leading zeros.
Otherwise, the file
may not import.
Best Efforts
11 Execution Type
Mandatory
Actual / Actual
12 Remittance Type
Scheduled / Scheduled
Used only with
13 Servicing Released (Y/N) Y or N servicing released
commitments.
Used only with
14 Allow Cross-Sell Y or N servicing released
commitments.
Used only with
15 Collecting Escrows Y or N servicing released
commitments.
Up to two digits
16 Estimated Escrow Amount 1000.00
after the decimal.
Primary Borrower First
17
Name
Primary Borrower Middle
18
Name
Primary Borrower Last
19
Name
20 Primary Borrower Suffix
21 Primary Borrower SSN
Secondary Borrower First
22
Name
Secondary Borrower Middle
23
Name
24 Secondary Borrower Last
Order Field Name Example Notes
Name
25 Secondary Borrower Suffix
26 Secondary Borrower SSN
Subject Property Street
27
Address
28 City
29 State
30 Zip
Detached
Attached
Condominium
Planned Urban
Development (PUD)
Co-Operative (Co-Op)
31 Property Type
Other
High Rise Condo
Manufactured Housing
Detached Condo
Manufactured Home /
Condominium/PUD/Co-Op
Purchase
Refinance
32 Loan Purpose Construction
Other
Construction to Permanent
Primary Residence
33 Occupancy Type Secondary Residence
Investment Property
Select N/A if credit
820
34 Credit Score score is not
N/A
available.
Up to two digits
35 Subordinate Financing 16000.00
after the decimal.
Purchase Price/Appraised Up to two digits
36 360000.00
Value after the decimal.
37 Self Employed Indicator Y or N Yes or No.