Default field mapping between Sage People and PlanSource
Most of the data mapping between fields in Sage People and PlanSource is managed automatically. The following tables include the complete mapping between the systems, including custom mapping options to enable tailored configuration.
Fields are listed in alphabetical order by Sage People field name.
Team Member fields | |
---|---|
Sage People field |
PlanSource API field |
fHCM2__Birth_Date__c | birthdate |
fHCM2__Email__c | |
fHCM2__First_Name__c | first_name |
fHCM2__Gender__c | gender |
fHCM2__Home_Address_1__c | address_1 |
fHCM2__Home_Address_2__c | address_2 |
fHCM2__Home_Address_City__c | city |
fHCM2__Home_Address_Postal_Code__c | zip_code |
fHCM2__Home_Phone__c | home_phone |
fHCM2__Marital_Status__c | marital_status |
fHCM2__Social_Security_Number__c | ssn |
fHCM2__Surname__c | last__name |
fHCM2__User__c | subscriber_code |
Employment Record fields | |
---|---|
Sage People field |
PlanSource API field |
fHCM2__Annual_Salary__c | current_salary |
fHCM2__Basis__c | employment_level |
fHCM2__Salary_Start_Date__c | current_salary_effective_on |
fHCM2__Start_Date__c | hire_date |
SgPpl__PlanSource_Payroll_Schedule__c | org_payroll_id |
Custom mapped fields | |
---|---|
Sage People field |
PlanSource API field |
division | division |
location | location |
orgClass | org_class |
unionCode | union_code |
usStateCode | state |
udef1 | udef_1 |
udef2 | udef_2 |
udef3 | udef_3 |
udef4 | udef_4 |
udef5 | udef_5 |
udef6 | udef_6 |
udef7 | udef_7 |
udef8 | udef_8 |
udef9 | udef_9 |
udef10 | udef_10 |
Termination fields (Employment Record) | |
---|---|
Sage People field |
PlanSource API field |
fHCM2__End_Date__c | termination_date |
SgPpl__US_Benefit_Termination_Reason__c | termination_reason |
Rehire fields (Employment Record) | |
---|---|
Sage People field |
PlanSource API field |
fHCM2__Start_Date__c | rehire_date |
Deduction pull fields (data returned to Sage People from PlanSource) | |
---|---|
Sage People field |
PlanSource API field |
fHCM2__Active__c (Employment Record object) | current |
fHCM2__Deduction_Code__c (Benefit object) | plan_payroll_mapping_code |
fHCM2__Employee__c (Benefit object) | subscriber_premium |
fHCM2__Employer_Contribution_Code__c (Benefit object) | plan_partner_code_1 |
fHCM2__Employer_Cost__c (Benefit object) | org_premium |
fHCM2__End_Date__c (Employment Record object) | termination_date |
fHCM2__Life_Cover__c (Benefit object) | volume |
fHCM2__Plan__c (Benefit object) | plan_name |
fHCM2__Policy_Coverage__c (Benefit object) | coverage_level |
fHCM2__Start_Date__c (Benefit object) | change_effective_date |
SgPpl__PlanSource_Imputed_Income__c (Benefit object) | imputed_income |
SgPpl__PlanSource_Org_Imputed_Income__c (Benefit object) | dp_org_imputed_income |
SgPpl__PlanSource_Subscriber_Imputed_Income__c (Benefit object) | dp_sub_imputed_income |
RecordTypeId (Benefit object) | plan_partner_code_2 |