Skip to content
  • There are no suggestions because the search field is empty.

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
S = Senior
2 = II
3 = III
4 = IV
5 = V
6 = VI
7 = VII
8 = VIII
9 = IX

 

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)

TIP: You may enter multiple e-mail addresses by separating each with a semi-colon. When sending documents via e-mail (such as statements), The Mortgage Office® will generate a separate e-mail with the appropriate attachment to each e-mail address in the field.

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)

 

Copyright © Applied Business Software, Inc. All Rights Reserved.