--- title: What are the co-borrower field mappings? description: Below is a detailed explanation of the available Co-Borrower Field Mappings and their respective acceptable values. --- [Skip to content](https://help.themortgageoffice.com/knowledge/co-borrower-field-mappings#main-content) [![TMO-LO~1](https://help.themortgageoffice.com/hs-fs/hubfs/TMO-LO~1.png?width=200&height=65&name=TMO-LO~1.png)](https://www.themortgageoffice.com/) - [Platform](https://www.themortgageoffice.com/products/) Show submenu for Platform - [Loan Servicing](https://www.themortgageoffice.com/products/loan-servicing-software/) - [Loan Origination](https://www.themortgageoffice.com/products/loan-origination-software/) - [Fund Management](https://www.themortgageoffice.com/products/fund-management-software/) - [Knowledge Hub](https://www.themortgageoffice.com/knowledge-hub/) Show submenu for Knowledge Hub - [Blog](https://www.themortgageoffice.com/blog/) - [Resources](https://www.themortgageoffice.com/resources/) - [Webinars](https://www.themortgageoffice.com/resources/?_resource_types=on-demand-webinars) - [Seminars](https://www.themortgageoffice.com/seminars/) - [FAQs](https://www.themortgageoffice.com/frequently-asked-questions/) - [Release Notes](https://help.themortgageoffice.com/knowledge/release-notes) Open main navigation Close main navigation - [Platform](https://www.themortgageoffice.com/products/) Show submenu for Platform - [Loan Servicing](https://www.themortgageoffice.com/products/loan-servicing-software/) - [Loan Origination](https://www.themortgageoffice.com/products/loan-origination-software/) - [Fund Management](https://www.themortgageoffice.com/products/fund-management-software/) - [Knowledge Hub](https://www.themortgageoffice.com/knowledge-hub/) Show submenu for Knowledge Hub - [Blog](https://www.themortgageoffice.com/blog/) - [Resources](https://www.themortgageoffice.com/resources/) - [Webinars](https://www.themortgageoffice.com/resources/?_resource_types=on-demand-webinars) - [Seminars](https://www.themortgageoffice.com/seminars/) - [FAQs](https://www.themortgageoffice.com/frequently-asked-questions/) - [Release Notes](https://help.themortgageoffice.com/knowledge/release-notes) - [Contact Support](https://help.themortgageoffice.com/knowledge/kb-tickets/new) [Contact Support](https://help.themortgageoffice.com/knowledge/kb-tickets/new?hsLang=en) How can we help you? - There are no suggestions because the search field is empty. 1. [Knowledge Base](https://help.themortgageoffice.com/knowledge?hsLang=en) 2. [Importing](https://help.themortgageoffice.com/knowledge/importing?hsLang=en) 3. [Field Mappings](https://help.themortgageoffice.com/knowledge/importing?hsLang=en#field-mappings) October 9, 2026 # 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](https://help.themortgageoffice.com/knowledge/importing-co-borrowers-into-servicing-from-an-excel-generated-file?hsLang=en) 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) |   - [Getting Started](https://help.themortgageoffice.com/knowledge/getting-started?hsLang=en#main-content) - [General](https://help.themortgageoffice.com/knowledge/getting-started?hsLang=en#general) - [Basic Information](https://help.themortgageoffice.com/knowledge/getting-started?hsLang=en#basic-information) - [New Company Setup](https://help.themortgageoffice.com/knowledge/getting-started?hsLang=en#new-company-setup) - [User & Group Security](https://help.themortgageoffice.com/knowledge/user-group-security?hsLang=en#main-content) - [General](https://help.themortgageoffice.com/knowledge/user-group-security?hsLang=en#general) - [Users](https://help.themortgageoffice.com/knowledge/user-group-security?hsLang=en#users) - [Groups](https://help.themortgageoffice.com/knowledge/user-group-security?hsLang=en#groups) - [Single Sign-On (SSO)](https://help.themortgageoffice.com/knowledge/user-group-security?hsLang=en#single-sign-on-sso) - [Loan Origination](https://help.themortgageoffice.com/knowledge/loan-origination?hsLang=en#main-content) - [Loan Files](https://help.themortgageoffice.com/knowledge/loan-origination?hsLang=en#loan-files) - [SmartViews](https://help.themortgageoffice.com/knowledge/loan-origination?hsLang=en#smartviews) - [System Administration](https://help.themortgageoffice.com/knowledge/loan-origination?hsLang=en#system-administration) - [Lenders](https://help.themortgageoffice.com/knowledge/loan-origination?hsLang=en#lenders) - [Lightning Docs](https://help.themortgageoffice.com/knowledge/loan-origination?hsLang=en#lightning-docs) - [Integrations](https://help.themortgageoffice.com/knowledge/loan-origination?hsLang=en#integrations) - [Borrowers](https://help.themortgageoffice.com/knowledge/loan-origination?hsLang=en#borrowers) - [DossDocs](https://help.themortgageoffice.com/knowledge/loan-origination?hsLang=en#dossdocs) - [Loan Servicing](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#main-content) - [General](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#general) - [Loan Files](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#loan-files) - [Borrowers](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#borrowers) - [Terms](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#terms) - [Funding](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#funding) - [Properties](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#properties) - [History](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#history) - [Attachments](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#attachments) - [Lenders](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#lenders) - [Vendors](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#vendors) - [Tasks & Reports](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#tasks-reports) - [Loan Charges](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#loan-charges) - [Commercial Loans](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#commercial-loans) - [Lines of Credit/HELOC](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#lines-of-credit-heloc) - [Construction Loans](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#construction-loans) - [Adjustable Rate Mortgages (ARM)](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#adjustable-rate-mortgages-arm) - [Graduated Terms Mortgages (GTM)](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#graduated-terms-mortgages-gtm) - [Escrow Administration](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#escrow-administration) - [SmartViews](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#smartviews) - [Accounting System Integration](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#accounting-system-integration) - [Custom Letters and Notices](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#custom-letters-and-notices) - [Loan Templates](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#loan-templates) - [Data Exports](https://help.themortgageoffice.com/knowledge/loan-servicing?hsLang=en#data-exports) - [Trust Accounting](https://help.themortgageoffice.com/knowledge/trust-accounting?hsLang=en#main-content) - [Trust Accounts](https://help.themortgageoffice.com/knowledge/trust-accounting?hsLang=en#trust-accounts) - [Register](https://help.themortgageoffice.com/knowledge/trust-accounting?hsLang=en#register) - [Clients](https://help.themortgageoffice.com/knowledge/trust-accounting?hsLang=en#clients) - [Payees](https://help.themortgageoffice.com/knowledge/trust-accounting?hsLang=en#payees) - [Payers](https://help.themortgageoffice.com/knowledge/trust-accounting?hsLang=en#payers) - [Tasks & Reports](https://help.themortgageoffice.com/knowledge/trust-accounting?hsLang=en#tasks-reports) - [Collateralized Mortgage Obligations](https://help.themortgageoffice.com/knowledge/collateralized-mortgage-obligations?hsLang=en#main-content) - [Holders](https://help.themortgageoffice.com/knowledge/collateralized-mortgage-obligations?hsLang=en#holders) - [Mortgage Pool Servicing](https://help.themortgageoffice.com/knowledge/mortgage-pool-servicing?hsLang=en#main-content) - [Mortgage Pools](https://help.themortgageoffice.com/knowledge/mortgage-pool-servicing?hsLang=en#mortgage-pools) - [Partners](https://help.themortgageoffice.com/knowledge/mortgage-pool-servicing?hsLang=en#partners) - [Tasks & Reports](https://help.themortgageoffice.com/knowledge/mortgage-pool-servicing?hsLang=en#tasks-reports) - [SmartViews](https://help.themortgageoffice.com/knowledge/mortgage-pool-servicing?hsLang=en#smartviews) - [ACH Express](https://help.themortgageoffice.com/knowledge/ach-express?hsLang=en#main-content) - [General](https://help.themortgageoffice.com/knowledge/ach-express?hsLang=en#general) - [Online Portals](https://help.themortgageoffice.com/knowledge/online-portals?hsLang=en#main-content) - [General](https://help.themortgageoffice.com/knowledge/online-portals?hsLang=en#general) - [Online Payments](https://help.themortgageoffice.com/knowledge/online-portals?hsLang=en#online-payments) - [Borrowers](https://help.themortgageoffice.com/knowledge/online-portals?hsLang=en#borrowers) - [Lenders](https://help.themortgageoffice.com/knowledge/online-portals?hsLang=en#lenders) - [Partners](https://help.themortgageoffice.com/knowledge/online-portals?hsLang=en#partners) - [Investment Offerings](https://help.themortgageoffice.com/knowledge/online-portals?hsLang=en#investment-offerings) - [Messages](https://help.themortgageoffice.com/knowledge/online-portals?hsLang=en#messages) - [Tax Forms Management & Printing](https://help.themortgageoffice.com/knowledge/tax-forms-management-printing?hsLang=en#main-content) - [General](https://help.themortgageoffice.com/knowledge/tax-forms-management-printing?hsLang=en#general) - [Tax Forms](https://help.themortgageoffice.com/knowledge/tax-forms-management-printing?hsLang=en#tax-forms) - [Consumer Credit Reporting (Metro-2)](https://help.themortgageoffice.com/knowledge/consumer-credit-reporting-metro-2?hsLang=en#main-content) - [Metro-2 Fundamentals](https://help.themortgageoffice.com/knowledge/consumer-credit-reporting-metro-2?hsLang=en#metro-2-fundamentals) - [Custom Letters, Notices and Mailing Labels](https://help.themortgageoffice.com/knowledge/custom-letters-notices-and-mailing-labels?hsLang=en#main-content) - [Custom Letters](https://help.themortgageoffice.com/knowledge/custom-letters-notices-and-mailing-labels?hsLang=en#custom-letters) - [Custom Notices](https://help.themortgageoffice.com/knowledge/custom-letters-notices-and-mailing-labels?hsLang=en#custom-notices) - [Custom (User Defined) Fields](https://help.themortgageoffice.com/knowledge/custom-user-defined-fields?hsLang=en#main-content) - [General](https://help.themortgageoffice.com/knowledge/custom-user-defined-fields?hsLang=en#general) - [Options](https://help.themortgageoffice.com/knowledge/options?hsLang=en#main-content) - [General](https://help.themortgageoffice.com/knowledge/options?hsLang=en#general) - [User Preferences Options](https://help.themortgageoffice.com/knowledge/options?hsLang=en#user-preferences-options) - [Loan Servicing Options](https://help.themortgageoffice.com/knowledge/options?hsLang=en#loan-servicing-options) - [Importing](https://help.themortgageoffice.com/knowledge/importing?hsLang=en#main-content) - [To Loan Servicing](https://help.themortgageoffice.com/knowledge/importing?hsLang=en#to-loan-servicing) - [From an Excel file](https://help.themortgageoffice.com/knowledge/importing?hsLang=en#from-an-excel-file) - [Field Mappings](https://help.themortgageoffice.com/knowledge/importing?hsLang=en#field-mappings) - [Online](https://help.themortgageoffice.com/knowledge/online?hsLang=en#main-content) - [General](https://help.themortgageoffice.com/knowledge/online?hsLang=en#general) - [Text Messages](https://help.themortgageoffice.com/knowledge/text-messages?hsLang=en#main-content) - [General](https://help.themortgageoffice.com/knowledge/text-messages?hsLang=en#general) - [Pulse](https://help.themortgageoffice.com/knowledge/pulse?hsLang=en#main-content) - [General](https://help.themortgageoffice.com/knowledge/pulse?hsLang=en#general) - [Insurance Tracking](https://help.themortgageoffice.com/knowledge/insurance-tracking?hsLang=en#main-content) - [General](https://help.themortgageoffice.com/knowledge/insurance-tracking?hsLang=en#general) - [API Docs](https://help.themortgageoffice.com/knowledge/api-docs?hsLang=en) - [Release Notes](https://help.themortgageoffice.com/knowledge/release-notes?hsLang=en) - [Desktop](https://help.themortgageoffice.com/knowledge/desktop?hsLang=en) - [Onboarding](https://help.themortgageoffice.com/knowledge/onboarding?hsLang=en#main-content) - [Loan Origination](https://help.themortgageoffice.com/knowledge/onboarding?hsLang=en#loan-origination) [![Chill listening crop-3](https://help.themortgageoffice.com/hs-fs/hubfs/TMO-LO~1.jpg?width=125&height=55&name=TMO-LO~1.jpg "Chill listening crop-3")](https://www.themortgageoffice.com/) 7755 Center Ave, Suite 800 Huntington Beach, CA 92647 [mailto:support@themortgagoffice.com](mailto:support@themortgagoffice.com) Copyright © 2025, The Mortgage Office®