What are the co-borrower field mappings?
Below is a detailed explanation of the available Co-Borrower Field Mappings and their respective acceptable values.
Click here to how to import co-borrowers from Excel using the field mappings below.
Co-borrower field mappings:
Field Name: |
Description: |
|
Account |
Loan Account. (Maximum of 10 alpha-numeric characters including "-" and ".".) |
|
CCR_AddressIndicator |
Address Indicator. Contains one of the following values for the address reported: Y = Known to be address of primary consumer N = Not confirmed address B = Business address, not consumer's residence U = Non-deliverable address/Returned mail D = Data reporter's default address M = Military address S = Secondary Address P = Bill Payer Service, not consumer's residence |
|
CCR_DOB |
Date of Birth. Contains the date of birth of the consumer. Reporting of this information is highly recommended as the date of birth greatly enhances accuracy in matching to the correct consumer. |
|
CCR_GenerationCode |
Generation Code. Used to distinguish Junior, Senior, II, III, IV, etc., when generating the Metro-2 file. If not applicable, blank fill. Values available: J = Junior |
|
CCR_Report |
Enable Credit Reporting. Enter 1 to report credit information to credit bureaus (Metro-2); otherwise enter 0. |
|
CCR_ResidenceCode |
Residence Code. Contains the one-character residence code of the address. Values available: O = Owns R = Rents |
|
City |
City. Enter borrower's city. (Maximum of 50 characters) |
|
DeliveryOptions |
Delivery Options. The available options are: 0 = None 1 = Print 2 = E-mail 3 = Print & E-mail |
|
EmailAddress |
Email Address. Enter borrower's e-mail address. (Maximum of 255 characters)
|
|
EmailFormat |
Email Format. Enter the e-mail delivery format. Available options are 0=Plain Text, 1=HTML. |
|
FirstName |
First Name. Enter borrower's first name. (Maximum of 30 characters) |
|
FullName |
Full Name. Enter the primary borrower's full name. (Maximum of 64 characters) |
|
LastName |
Last Name. Enter borrower's last name. (Maximum of 30 characters) |
|
MI |
Middle Initial. Enter borrower's middle initial. (Maximum of 1 character) |
|
PhoneCell |
Cell Phone Number. Enter borrower's phone number. (Maximum of 20 characters) |
|
PhoneFax |
Fax Phone Number. Enter borrower's phone number. (Maximum of 20 characters) |
|
PhoneHome |
Home Phone Number. Enter borrower's phone number. (Maximum of 20 characters) |
|
PhoneMain |
Primary Phone Number: 0 = Home, 1 = Work, 2 = Cell and 3 = Fax. |
|
PhoneWork |
Work Phone Number. Enter borrower's phone number. (Maximum of 20 characters) |
|
RecType |
Type. Available options are: 0 = Primary 1 = Co-Borrower 2 = Co-Signer 3 = Guarantor 99 = Other |
|
Relation |
Relation to the primary borrower. Available options are 0 = None and 1 = Spouse of Borrower. |
|
Salutation |
Borrower's Salutation. Enter a salutation field. (Maximum of 50 characters) |
|
SendNotices |
Send Notices. Enter 1 to print (or e-mail) notices for this co-borrower that are sent to the primary borrower; otherwise enter 0. |
|
State |
Borrower's State. Enter borrower's state. |
|
Street |
Borrower's Street. Enter borrower's mailing street address. (Maximum of 64 characters) |
|
TIN |
Borrower's TIN. Enter borrower's tax identification number. (Maximum of 11 characters) |
|
ZipCode |
Borrower's Zip Code. Enter borrower's zip code. (Maximum of 10 characters) |