Loading
Insurance
. Vlocity Object to Group Benefits Standard Object Model Mapping

Vlocity Object to Group Benefits Standard Object Model Mapping

Learn how fields in the Vlocity Group Benefits object model correspond to fields in the Salesforce object model. Use these field mappings when you create scripts that move Group Benefits data from one model to the other.

Harmonized Objects

Group Benefits Standard Object

Vlocity Object

GroupCensus

GroupCensus__c

GroupCensusMember

GroupCensusMember__c

GroupClass

GroupClass__c

GroupClassContribution

GroupClassContribution__c

InsuranceContract

This object is an extension of the existing Contract object, which is introduced to have insurance-specific fields.

Contract

ContractGroupPlan

ContractLineItem__c (Plan)

GroupCensusMemberPlan

GroupCensusMemberPlan__c

QuoteLineItemGroupClass

QuoteLineItemGroupClass__c

GroupCensus Field Mapping

Group Benefits Standard Field Name

Group Benefits Standard Field Label

Vlocity Group Benefit Field Name

Vlocity Group Benefit Field Label

Data Type

Name

Name

Name

Name

Text

ExternalIdentifier

External Identifier

Not Available

Not Available

Text(ExternalId)

SourceSystemType

Source System Type

CensusSource__c

Source

Static Enum

Status

Status

CensusStatus__c

Status

Static Enum

Type

Type

CensusType__c

Type

Static Enum

MemberOptOutCount

Member Opt Out Count

CountOfDeclined__c

No. Declined

Number (,)

MbrWithoutDependentCount

Member Without Dependent Count

CountOfEmployeeOnly__c

No. Employee Only

Number (,)

MemberWithOneChildCount

Member With One Child Count

CountOfEmployeePlusChild__c

No. Employee + Child

Number (,)

MbrWithMoreThan1ChldCount

Member With More Than One Child Count

CountOfEmployeePlusChildren__c

No. Employee + Children

Number (,)

MbrWithMoreThan2ChldCount

Member With More Than Two Children Count

Not Available

Not Available

Number (,)

MemberWithDependentCount

Member With Dependent Count

CountOfEmployeePlusFamily__c

No. Employee + Family

Number (,)

MemberWithSpouseCount

Member With Spouse Count

CountOfEmployeePlusSpouse__c

No. Employee + Spouse

Number (,)

TotalMemberPlusDependent

Total Members Plus Dependents

CountOfEmployeesPlusDependents__c

Total Employees + Dependents

Number (,)

TotalDependents

Total Dependents

NumberOfDependents__c

Dependents

Number (,)

TotalMembers

Total Members

NumberOfMembers__c

Members

Number (,)

FullTimeMemberCount

Full Time Member Count

CountOfFullTime__c

No. Full Time

Number (,)

PartTimeMemberCount

Part Time Member Count

CountOfPartTime__c

No. Part Time

Number (,)

EffectiveEndDate

Effective End Date

EffectiveEndDate__c

End Date

Date

EffectiveStartDate

Effective Start Date

EffectiveStartDate__c

Effective Date

Date

Account

Account

GroupId__c

Group

Foreignkey Lookup ()

SourceSystemName

Source System Name

Not Available

Not Available

Text

UsageType

UsageType

Not Available

Not Available

Static Enum

Lead

Lead

Not Available

Not Available

Foreignkey Lookup ()

Group Benefits Standard Field Name

Group Benefits Standard Field Label

Vlocity Group Benefit Field Name

Vlocity Group Benefit Label

Data Type

AttributesSelectedValues__c

AttributesSelectedValues

AttributesSelectedValues__c

Attribute Selected Values

Text

SpecProduct2Id__c

Product

SpecProduct2Id__c

Product

Foreignkey Lookup ()

GroupCensusMember Field Mapping

Group Benefits Standard Field Name

Group Benefits Standard Field Label

Vlocity Group Benefit Field Name

Vlocity Group Benefit Field Label

Data Type

Birthdate

Birthdate

Birthdate__c

Birthdate

Date

GroupCensus

Group Census

CensusId__c

Census

Parent/Child

Address

Address

Not Available

Not Available

Address

Contact

Contact

ContactId__c

Contact

Foreignkey Lookup ()

Email

Email

Email__c

Email

Email

FullTimeEquivalent

Full Time Equivalent

FTE__c

FTE

Number (,)

FirstName

First Name

FirstName__c

First Name

Text

LastName

Last Name

LastName__c

Last Name

Text

Gender

Gender

Gender__c

Gender

Dynamic Enum

GroupClass

Group Class

-GroupClassId__c

Group Class

Foreignkey Lookup ()

JoinDate

Join Date

HireDate__c

Hire Date

Date

IsOptOutAllPlans

Is Opt-out All Plans

IsOptOut__c

Opt-out

Boolean

IsPortalUser

Is Portal User

IsPortalUser__c

Is Portal User

Boolean

SourceSystemIdentifier

Source System Identifier

MemberIdentifier__c

Member Identifier

Text

MemberType

Member Type

MemberType__c

Type

Dynamic Enum

DependentCount

Dependent Count

NumberOfDependents__c

No. Dependents

Number (,)

AnnualEligibleSalary

Annual Eligible Salary

Not Available

Not Available

Currency

PrimaryMemberSource

Primary Member Source

PrimaryMemberIdentifier__c

Primary Member Identifier

Text

PrimaryGroupCensusMember

Primary Group Census Member

RelatedCensusMemberId__c

Primary Census Member

Foreignkey Lookup ()

OptOutPlanTypes

Opt-out Plan Types

Opt-out Types

OptOutPlanTypes

Dynamic Enum

Account

Account

Not Available

Not Available

Foreignkey Lookup ()

RelationshipToPrimaryMember

Relationship to Primary Member

Not Available

Not Available

Dynamic Enum

PrimaryMemberCategory

Primary Member Category

Not Available

Not Available

Dynamic Enum

PhoneNumber

Phone Number

Not Available

Not Available

Phone

SmokerStatus

Smoker Status

Not Available

Not Available

Dynamic Enum

Status

Status

Not Available

Not Available

Static Enum

MemberKey

Member Key

Not Available

Not Available

Text

Group Benefits Standard Field Name

Group Benefits Standard Field Label

Vlocity Group Benefit Field Name

Vlocity Group Benefit Label

Data Type

AttributesSelectedValues__c

AttributesSelectedValues

AttributesSelectedValues__c

Attribute Selected Values

Text

SpecProduct2Id__c

Product

SpecProduct2Id__c

Product

Foreignkey Lookup ()

GroupClass Field Mapping

Group Benefits Standard Field Name

Group Benefits Standard Field Label

Vlocity Group Benefit Field Name

Vlocity Group Benefit Field Label

Data Type

Name

Name

Not Available

Not Available

Text

Code

Code

ClassCode__c

Class Code

Text

Description

Description

Description__c

Description

Text

EffectiveEndDate

Effective End Date

EffectiveEndDate__c

Effective End Date

Date

EffectiveStartDate

Effective Start Date

EffectiveStartDate__c

Effective Start Date

Date

Account

Account

GroupId__c

Group

Parent/Child

ParentGroupClass

Parent Group Class

ParentGroupClassId__c

Parent Group Class

Foreignkey Lookup ()

Category

Category

Type__c

Type

Dynamic Enum

UsageType

UsageType

Not Available

Not Available

Static Enum

GroupClassContribution Field Mapping

Group Benefits Standard Field Name

Group Benefits Standard Field Label

Vlocity Group Benefit Field Name

Vlocity Group Benefit Field Label

Data Type

Name

Name

GroupClassContributionName

Name

Text

Amount

Amount

ContributionAmount__c

Contribution Amount

Currency

Percentage

Percentage

ContributionPercent__c

Contribution Percent

Percent

Type

Type

ContributionType__c

Contribution Type

Static Enum

EffectiveEndDate

Effective End Date

EffectiveEndDate__c

Effective End Date

Date

EffectiveStartDate

Effective Start Date

EffectiveStartDate__c

Effective Start Date

Date

GroupClass

GroupClass

GroupClassId__c

Group Class

Parent/Child

MemberType

MemberType

MemberType__c

Member Type

Static Enum

GroupBenefitProductCategory

Group Benefit Product Category

ProductCategory__c

Product Category

Dynamic Enum

ContractGroupPlan

Contract Group Plan

Not Available

Not Available

Foreignkey Lookup ()

InsuranceContract Field Mapping

Group Benefits Standard Field Name

Group Benefits Standard Field Label

Vlocity Group Benefit Field Name

Vlocity Group Benefit Field Label

Data Type

BusinessLicense

Business License

AgencyLicenseId__c

Channel Partner License

Foreignkey Lookup ()

EnrollmentEndDate

Enrollment End Date

EnrollmentEndDate__c

Enrollment End Date

Date

EnrollmentStartDate

Enrollment Start Date

EnrollmentStartDate__c

Enrollment Start Date

Date

EnrollmentWaitingPeriod

Enrollment Waiting Period

EnrollmentWaitingPeriod__c

Enrollment Waiting Period

Number (,)

Producer

Producer

ProducerId__c

Producer

Foreignkey Lookup ()

BrokerageAgency

Brokerage Agency

AgencyBrokerageId__c

Agency/Brokerage

Foreignkey Lookup ()

Underwriter

Underwriter

UnderwriterId__c

Underwriter

Foreignkey Lookup ()

Enrollment Census

EnrollmentCensus

EnrollmentCensusId__c

Enrollment Census

Foreignkey Lookup ()

Contract

Contract

Not Available

Not Available

Parent/Child

ContractGroupPlan Field Mapping

Group Benefits Standard Field Name

Group Benefits Standard Field Label

Vlocity Group Benefit Field Name

Vlocity Group Benefit Field Label

Data Type

Name

Name

Name

Name

Text

Account

Account

AccountId__c

Account

Foreignkey Lookup ()

Contract

Contract

ContractId__c

Contract

Parent/Child

EligibilityCriteria

Eligibility Criteria

EligibilityCriteria__c

Eligibility Criteria

Text

EnrollmentStartDate

Enrollment Start Date

EnrollmentStartDate__c

Enrollment Start Date

Date

EnrollmentEndDate

Enrollment End Date

EnrollmentEndDate__c

Enrollment End Date

Date

EnrollmentRatingType

Enrollment Rating Type

EnrollmentRatingType__c

Enrollment Rating Type

Static Enum

EnrollmentWaitingPeriod

Enrollment Waiting Period

EnrollmentWaitingPeriod__c

Enrollment Waiting Period

Number (,)

GroupClass

Group Class

GroupClassId__c

Group Class

Foreignkey Lookup ()

OriginalContractPlan

Original Contract Plan

Not Available

Not Available

Foreignkey Lookup ()

ContractGroupParentPlan

Contract Group Parent Plan

ParentItemId__c

Parent Item Id

Foreignkey Lookup ()

ProductNumber

Product Number

ProductNumber__c

Product Number

Number (,)

QuoteLineItem

Quote Line Item

QuoteLineItemId__c

Quote Line Item Id

Foreignkey Lookup ()

GroupNumber

Group Number

GroupNumber__c

Group Number

Text

UnitPrice

Unit Price

UnitPrice__c

Unit Price

Currency

EffectiveEndDate

Effective End Date

EffectiveEndDate__c

Effective End Date

DateTime

EffectiveStartDate

Effective Start Date

EffectiveStartDate__c

Effective Start Date

DateTime

Status

Status

LineStatus__c

Status

Static Enum

PricingStructure

Pricing Structure

Not Available

Not Available

String+clob

UsageType

UsageType

Not Available

Not Available

Static Enum

Group Benefits Standard Field Name

Group Benefits Standard Field Label

Vlocity Group Benefit Field Name

Vlocity Group Benefit Label

Data Type

AttributesSelectedValues__c

AttributesSelectedValues

AttributesSelectedValues__c

Attribute Selected Values

Text

Attribute__c

Attribute

Attribute__c

Attribute

Text

AttributeData__c

Attribute Data

AttributeData__c

Attribute Data

Text

Product2Id_c

Product

Product2Id_c

Product

Foreignkey Lookup ()

ProductChildItem__c

Product Child Item

ProductChildItem__c

Product Child Item

Foreignkey Lookup ()

GroupCensusMemberPlan Field Mapping

Group Benefits Standard Field Name

Group Benefits Standard Field Label

Vlocity Group Benefit Field Name

Vlocity Group Benefit Field Label

Data Type

Name

Name

GroupCensusMemberPlanName

Name

Text

ContractGroupPlan

Contract Group Plan

ContractLineId__c

Plan

Foreignkey Lookup ()

GroupCensusMember

Group Census Member

GroupCensusMemberId__c

Census Member

Foreignkey Lookup ()

QuoteLineItemGroupClass Field Mapping

Group Benefits Standard Field Name

Group Benefits Standard Field Label

Vlocity Group Benefit Field Name

Vlocity Group Benefit Field Label

Data Type

Name

Name

QuoteLineItemGroupClassName

Name

Text

GroupClass

Group Class

GroupClassId__c

Group Class

Foreignkey Lookup ()

Quote

Quote

QuoteId__c

Quote

Parent/Child

QuoteLineItem

Quote Line Item

QuoteLineItemId__c

Quote Line Item

Foreignkey Lookup ()

.
 
Loading
Salesforce Help | Article