LKC Sage People to Payflow to Timberline Field Mapping : Keeley Companies

LKC New Hire Portal Payroll Sage People to Timberline Field Mapping

Purpose: The purpose of this document is to give the Payroll team the field mappings of what fields in Sage People populate in Timberline using Payflow.

About LKC New Hire Portal: This website is created for Keeley new hires and Managers to easily walk through and complete the onboarding forms within the LKC New Hire Portal. Once completed, the information will be sent into our HR System, Sage People and then will transfer into our Accounting System, Sage 300 CRE.

Who is this for: LKC Payroll

Object API	SP Field - B/I = Required	Entered By	Verified By	Notes	Timberline Table	Timberline Field
fhcm2_Team_Member__c	Name	Team Member	Payroll	Required to Create Timberline Record, ALL CAPS	PRM MASTER EMPLOYEE	Employee_Name
fhcm2_Team_Member__c	SSN	Team Member	Payroll	Required to Create Timberline Record	PRM MASTER EMPLOYEE	Social_Security_Number
fhcm2_Team_Member__c	Birth Date	Team Member	Payroll	Required to Create Timberline Record	PRM MASTER EMPLOYEE	Birth_Date
fhcm2_Team_Member__c	Employee ID	Payroll	Payroll	Autopopulated based upon next number	PRM MASTER EMPLOYEE	Employee
	Payroll Mapping	Defaulted		Defaulted to LKC Field
fHCM2__Employment__c	Filing Status	Team Member	Payroll	Required to Create Timberline Record	PRM MASTER EMPLOYEE	Filing_Status
fHCM2__Employment__c	Work Location	Payroll		Required to Create Timberline Record	PRM MASTER EMPLOYEE	Work_State
fhcm2_Team_Member__c	Address 1	Team Member	Payroll	ALL CAPS	PRM MASTER EMPLOYEE	Address 1
fhcm2_Team_Member__c	Address 2	Team Member	Payroll	ALL CAPS	PRM MASTER EMPLOYEE	Address 2
fhcm2_Team_Member__c	Home State	Team Member	Payroll	ALL CAPS	PRM MASTER EMPLOYEE	State
fhcm2_Team_Member__c	Home Zip	Team Member	Payroll	ALL CAPS	PRM MASTER EMPLOYEE	Zip
fhcm2_Team_Member__c	Home Country	Team Member	Payroll	ALL CAPS - UNITED STATES	PRM MASTER EMPLOYEE	Country
fHCM2__Employment__c	Bank Account Type	Team Member	Payroll	NET DD is deduction code	PRM MASTER EMPLOYEE DEDUCT	Account_Type
fHCM2__Employment__c	Account No.	Team Member	Payroll		PRM MASTER EMPLOYEE DEDUCT	Bank_Account
fHCM2__Employment__c	Routing No.	Team Member	Payroll		PRM MASTER EMPLOYEE DEDUCT	Bank_ID
fHCM2__Employment__c	Bank Account Type 2	Team Member	Payroll	Optional - DD PARTIAL is deduction code	PRM MASTER EMPLOYEE DEDUCT	Account_Type
fHCM2__Employment__c	Account No. 2	Team Member	Payroll	Optional	PRM MASTER EMPLOYEE DEDUCT	Bank_Account
fHCM2__Employment__c	Routing No. 2	Team Member	Payroll	Optional	PRM MASTER EMPLOYEE DEDUCT	Bank_ID
fHCM2__Employment__c	Bank Account Type 3	Team Member	Payroll	Optional - DD SAVINGS is deduction code	PRM MASTER EMPLOYEE DEDUCT	Account_Type
fHCM2__Employment__c	Account No. 3	Team Member	Payroll	Optional	PRM MASTER EMPLOYEE DEDUCT	Bank_Account
fHCM2__Employment__c	Routing No. 3	Team Member	Payroll	Optional	PRM MASTER EMPLOYEE DEDUCT	Bank_ID
fHCM2__Employment__c	Bank Account Type 4	Team Member	Payroll	Optional - DD-PARTIAL is deduction code	PRM MASTER EMPLOYEE DEDUCT	Account_Type
fHCM2__Employment__c	Account No. 4	Team Member	Payroll	Optional	PRM MASTER EMPLOYEE DEDUCT	Bank_Account
fHCM2__Employment__c	Routing No. 4	Team Member	Payroll	Optional	PRM MASTER EMPLOYEE DEDUCT	Bank_ID
fhcm2_Team_Member__c	CRE Ethnic	Team Member	Payroll	Formula field that pulls in Ethnic field and adds some logic to make it work in Timberline	PRM Master Employee	Ethnic Group
fhcm2_Team_Member__c	New Hire Portal Authorized Manager Last	Authorized Manager		From LKC NH Portal
fhcm2_Team_Member__c	Authorized Manager First	Authorized Manager		From LKC NH Portal
fHCM2__Employment__c	CRE Group	Payroll		pulls from Uppercase(Group)	PRM Master Employee	Title
fHCM2__Employment__c	CRE Union Craft + Home Union Local #	Payroll		This is a formula field that if the TM is Union it will pull the Union Craft + Home Union Local. If the TM is Non-Union it will pull in the Job Title (Upper Case)	PRM Master Employee	Occupation
fHCM2__Employment__c	UDF_Union_Current_Skill_Level__c	Team Member			PRM Master Employee	Skill Level
fHCM2__Salary__c	UDF_LKC_Payflow_Salary__c	HR		Union-Pay Amount will be zero for PAY ID 1; Non-Union Pay Amount will be entered rate by HR for PAY ID 1	PRM Master Employee Pay	Amount
fhcm2_Team_Member__c	Original Hire Date		Payroll		PRM Master Employee	Hire_Date
fhcm2_Team_Member__c	Rehire Date		Payroll		PRM Master Employee	Rehire_Date
fhcm2_Team_Member__c	CRE Email Addresses	Team Member	Payroll		PRM Master Employee	Email_address
fhcm2_Team_Member__c	CRE Phone Number	Team Member	Payroll	Formula field that passes the personal Mobile to mobile phone in timberline. If Personal mobile is blank it pulls Home Phone and passes to Timberline	PRM Master Employee	Mobile_Phone
fhcm2_Team_Member__c	Phone	Team Member	Payroll		PRM Master Employee	Phone_Number
fHCM2__Employment__c	Union ID	Payroll			PRM Master Employee	Union_ID
fHCM2__Employment__c	Union Class	Payroll			PRM Master Employee	Union_Class
fHCM2__Employment__c	Union Local	Payroll			PRM Master Employee	Union_Local

Payflow Field Mapping Visual Mapping: Yellow Highlights denotes Sage People field

Employee General Tab

Employee Entry Info Tab

c. Employee Bank Account Info

Employee Setup – Pays

Misc

Keeley Companies

LKC Sage People to Payflow to Timberline Field Mapping

Modified on: Wed, Apr 7, 2021 11:14 AM

Related Articles