/
Partner Bulk Upload Template Fields

Partner Bulk Upload Template Fields

Description

This article provides details about the field values in the Partner Bulk Upload Template.

Field Explanations in Order of the Report Columns

External ContactTypeID is the partner type. If this field is blank, it will default to the referral partner.

 

The values in this column must be entered as a number.

Partner Type

ExternalContactTypeId

Partner Type

ExternalContactTypeId

Real Estate Agent

1

Title Agent

2

Escrow Agent

3

Attorney

4

Financial Planner

5

Insurance Agent

6

Personal

7

Existing Client

8

Builder

9

Mortgage Banker

10

Other

11

  • LiscenseId

    • This field can be used to add a license number associated with your partner.

  • FirstName (Required Field)

    • Enter the partner’s first name.

  • LastName (Required Field)

    • Enter the partner’s last name.

  • Email (Required Field)

    • Enter the partner’s email.

Warning: If you do not enter a parter email in any row, the entire upload will fail.

  • MobilePhone

    • Enter the partner’s mobile phone number.

  • WorkPhone

    • Enter the partner’s work phone number.

  • Ext

    • Enter a work extension number, if applicable.

  • Website

    • Enter the website for the partner.

  • City

    • Enter the city for the partner.

  • State

    • Enter the state for the partner.

  • ExternalIdentifier

  • Branch Association

    • Determines the branches that can see this partner.

    • If blank, it will default to All.

Branch Association

BranchAssociation

Branch Association

BranchAssociation

All

1

{{Org-specific branch}}

Please ask your Insellerate representative.

  • Campaign ID

    • Enter the campaign that the partner should be associated with.

    • If it is not entered or the system does not find an exact match, it will default to the Default Campaign selected on the Partner Bulk Upload screen.

  • AssignToUserID

    • Leave this field blank if using AssignToUserID.

    • This is the assignee associated with the partner.

    • If it is not entered or the system does not find an exact match, it will default to the Default Assignee selected on the Partner Bulk Upload screen.

  • AssignToEmail

    • Leave this field blank if using AssignTo.

    • This is the assignee email address associated with the Partner.

    • If it is not entered or the system does not find an exact match, it will default to the Default Assignee email from the selection on the Partner Bulk Upload screen.

  • Address1

    • Enter the address for the partner.

  • PostalCode

    • Enter the postal code for the partner.

  • UserTitle

    • Enter the professional title for your partner, if applicable.

  • ApprovalStatusID

    • Can be used to define the partner’s status.

Approval Status

ApprovalStatusId

Approval Status

ApprovalStatusId

Application Pending

1

Application Denied

2

Active

3

Inactive

4

Suspended

5

Cancelled

6

Terminated

7

  • EntityID

    • This field can be used to store any value your organization wants to associate with a partner.

    • Contact Insellerate Support to add the field to inFlow in the Record Details Panel.

  • Notes

    • Add any applicable notes for a partner.

  • AvatarUrl

    • Add a URL linking to a picture of a partner.

  • Branch_Name

    • Add a branch name for your partner.

  • Branch_Phone

    • Enter a branch phone number for your partner.

  • Branch_Website

    • Enter a website for the branch of your partner.

  • Branch_City

    • Enter a city for the branch of your partner.

  • Branch_State

    • Enter a state for the branch of your partner.

  • Branch_BranchAssociation

    • Determines the branches that can see this partner.

    • If blank, it will default to All.

Branch Association

BranchAssociation

Branch Association

BranchAssociation

All

1

{{Org-specific branch}}

Please ask your Insellerate representative.

  • Branch_Company_Name

    • Add a company name for your partner.

  • Branch_Company_Website

    • Enter a website for your partner’s company.

  • Branch_Company_ExternalContactCompanyId

    • Enter a company ID for your partner.

    • This is the unique ID (assigned by Insellerate) of a company.

  • Branch_Company_OrgID

    • Enter a company organization ID.

  • Branch_Company_UserId

    • Enter the user ID for your partner at their company.

  • Branch_Company_TpoId

    • Enter the company TPO ID.

  • Branch_Company_CompanyCode

    • Enter the company code for your partner’s company.

  • Branch_Company_OwnerName

    • Enter the owner name for your partner’s company.

  • Branch_Company_Phone

    • Enter the phone number for your partner’s company.

  • Branch_Company_Fax

    • Enter the fax number for your partner’s company.

  • Branch_Company_Email

    • Enter the email for your partner’s company.

  • Branch_Company_WebsiteUrl

    • Enter the company website URL.

  • Branch_Company_NmlsId

    • Enter the company NMLS.

  • Branch_Company_SalesRepresentativeUserId

    • Enter the branch company sales representative user ID for your partner’s company.

  • Branch_Company_City

    • Enter the branch company city for your partner’s company.

  • Branch_Company_StateId

    • Enter the state ID for your partner’s state.

  • Branch_Company_Address1

    • Enter the address for your partner’s company.

  • Branch_Company_PostalCode

    • Enter the postal code for your partner’s company.

  • Branch_Company_BranchAssociation

    • Determines the branches that can see this partner.

    • If blank, it will default to All.

Branch Association

BranchAssociation

Branch Association

BranchAssociation

All

1

{{Org-specific branch}}

Please ask your Insellerate representative.

  • Branch_Company_ExternalContactCompanyLoanProductTypes

    • Enter the Types of Products offered by your partners.

Company Loan Product Type(s)

ExternalContactCompanyLoanProductTypes

Company Loan Product Type(s)

ExternalContactCompanyLoanProductTypes

Conventional

1

FHA

2

VA

3

USDA

4

HELOC

5

Other

6

FirstLien

7

SecondLien

8

  • Branch_Company_ExternalContactCompanyLoanPurposeTypes

    • Enter the Loan Purpose types offered by your partners.

Company Loan Purpose Type(s)

ExternalContactCompanyLoanPurposeTypes

Company Loan Purpose Type(s)

ExternalContactCompanyLoanPurposeTypes

Purchase

1

No cash out refinance

2

Cash out refinance

3

Construction

4

Construction Perm

5

Other

6

  • Branch_Company_ExternalContactCompanyChannelTypes

    • Enter the Channel Type for your partner.

Channel Type(s)

ExternalContactCompanyChannelTypes

Channel Type(s)

ExternalContactCompanyChannelTypes

Broker

1

Correspondent

2

Delegated

3

Non-Delegated

4

  • Branch_Company_ApprovalStatusId

    • Define the company partner’s status.

Approval Status

ApprovalStatusId

Approval Status

ApprovalStatusId

Application Pending

1

Application Denied

2

Active

3

Inactive

4

Suspended

5

Cancelled

6

Terminated

7

  • Other Fields: Other1, Other2, Other3, Other4, Other5, Other6

    • Other fields are optional custom fields that can be used by your organization to store additional applicable data about your partners.

  • Email1

    • This field can be used by your organization to add emails for team members who work with your partner on their leads.

  • Email2

    • This field can be used by your organization to add emails for team members who work with your partner on their leads.

 

Related content