This table lists fields you'll commonly use in formulas and as merge fields to return values. You'll use them widely in Sage People in things like Action Events and in PDF files.
We list fields in alphabetical order within the object. What to enter shows the complete syntax to enter when using each field from the given object.
-
If you're using the field reference outside a formula, use What to enter exactly as we show
-
If you're using the field reference in a formula:
-
Remove the opening and closing curly braces
-
Remove the exclamation mark
-
Accessing fields from the Employment Record
| Field | What to enter |
|---|---|
| Basis | {!fHCM__Basis__c} |
| Continuous Service Date | {!fHCM2__Continuous_Service_Date__c} |
| Contract End Date | {!fHCM2__Contract_End_Date__c} |
| Current Salary | {!fHCM2__Current_Salary__r.fHCM2__Amount__c} |
| Employment End | {!fHCM2__End_Date__c} |
| Employment Last Working Date | {!fHCM2__Last_Working_Date__c} |
| Employment Start Date | {!fHCM2__Start_Date__c} |
| First Name | {!fHCM2__Team_Member__r.fHCM2__First_Name__c} |
| Hire Date | {!fHCM2__Team_Member__r.fHCM2__Hire_Date__c} |
| Home Address 1 | {!fHCM2__Team_Member__r.fHCM2__Home_Address_1__c} |
| Home Address 2 | {!fHCM2__Team_Member__r.fHCM2__Home_Address_2__c} |
| Home Address 3 | {!fHCM2__Team_Member__r.fHCM2__Home_Address_3__c} |
| Home Address City | {!fHCM2__Team_Member__r.fHCM2__Home_Address_City__c} |
| Home Address Country | {!fHCM2__Team_Member__r.fHCM2__Home_Address_Country__c} |
| Home Address Zipcode/Postal Code | {!fHCM2__Team_Member__r.fHCM2__Home_Address_Postal_Code_c} |
| Job Title | {!fHCM2__Team_Member__r.fHCM2__Job_Title__c} |
| Manager | {!fHCM2__Team_Member__r.fHCM2__Manager__c} |
| Salary Period | {!fHCM2__Current_Salary__r.fHCM2__Period__c} |
| Salary Start Date | {!fHCM2__Current_Salary__r.fHCM2__Start_Date__c} |
| Surname/Family Name | {!fHCM2__Team_Member__r.fHCM2__Surname__c} |
| Team | {!fHCM2__Team_Member__r.fHCM2__Team__c} |
Accessing fields from the Team Member record
| Field | What to enter |
|---|---|
| Basis | {!fHCM2__Current_Employment__r.fHCM__Basis__c} |
| Continuous Service Date | {!fHCM2__Current_Employment__r.fHCM2__Continuous_Service_Date__c} |
| Contract End Date | {!fHCM2__Current_Employment__r.fHCM2__Contract_End_Date__c} |
| Current Salary | {!fHCM2__Current_Employment__r.fHCM2__Current_Salary__r.fHCM2__Amount__c} |
| Employment End | {!fHCM2__Current_Employment__r.fHCM2__End_Date__c} |
| Employment Last Working Date | {!fHCM2__Current_Employment__r.fHCM2__Last_Working_Date__c} |
| Employment Start Date | {!fHCM2__Current_Employment__r.fHCM2__Start_Date__c} |
| First Name | {!fHCM2__First_Name__c} |
| Hire Date | {!fHCM2__Hire_Date__c} |
| Home Address 1 | {!fHCM2__Home_Address_1__c} |
| Home Address 2 | {!fHCM2__Home_Address_2__c} |
| Home Address 3 | {!fHCM2__Home_Address_3__c} |
| Home Address City | {!fHCM2__Home_Address_City__c |
| Home Address Country | {!fHCM2__Home_Address_Country__c} |
| Home Address Zipcode/Postal Code | {!fHCM2__Home_Address_Postal_Code_c} |
| Job Title | {!fHCM2__Job_Title__c} |
| Manager | {!fHCM2__Manager__c} |
| Salary Period | {!fHCM2__Current_Employment__r.fHCM2__Current_Salary__r.fHCM2__Period__c} |
| Salary Start Date | {!fHCM2__Current_Employment__r.fHCM2__Current_Salary__r.fHCM2__Start_Date__c} |
| Surname/Family Name | {!fHCM2__Surname__c} |
| Team | {!fHCM2__Team__c} |
This table includes a small proportion of all available fields. For a complete list of objects and fields, with API Names and other details:
-
Go to Setup , and select the object. Then select Fields & Relationships to display the fields for that object.