Merge Fields
From sbv.wiki
Merge fields are used in multiple places throughout the software. A merge field is identified by starting with a < and ending with a >. When used in the software, the merge field is replaced with information specific to the employee. Examples of where merge fields are used are:
- Employee Info Text
- Dynamic paths such as used for payroll file location
- Name formats for staffing sheets
Here is a complete list of merge fields:
Merge Field | Replaced With | Notes |
---|---|---|
<Employee> | The employee's first and last name separated with a space | Employee / Main tab |
<EmployeeID> | The employee's ID | Employee / Main tab |
<FullName> | The employee's full name including any middle name and tag | Employee / Main tab |
<FullNameWithoutTag> | The employee's full name including the middle name but excluding the tag | Employee / Main tab |
<FirstName> | The employee's first name | Employee / Main tab |
<MiddleName> | The employee's middle name | Employee / Main tab |
<LastName> | The employee's last name | Employee / Main tab |
<*IfNotInHouse> | * if the employee is not in a company that is marked as being In House | Configuration / Setup / Labor Levels / Company |
<FirstNameInitial> | The first letter of the employee's first name followed by a period | Employee / Main tab |
<MiddleNameInitial> | The first letter of the employee's middle name preceded by a space and followed by a period | Employee / Main tab |
<LastNameInitial> | The first letter of the employee's last name followed by a period | Employee / Main tab |
<LastDayWorked> | The date of the latest punch made by the employee | Time Cards tab |
<Union> | Displays the word Union if the employee is in the union | Determined in multiple ways based on department, union date and or Not In Union setting
|
<PayRule> | The employee's current pay rule ID. | Employee / Main tab |
<HolidayGroup> | The employee's current holiday group ID. | Employee / Main tab |
<SocialSecurityNumber> | The employee's Social Security Number. | Employee / Employment / General tab |
<HireDate> | The employee's hire date. | Employee / Status tab |
<ShiftCount> | The employee's current shift. | Employee / Work Pattern tab |
<DailyHours> | The employee's current daily hours. | Employee / Work Pattern tab |
<ShiftID> | The ID of the employee's current shift. | Employee / Work Pattern tab |
<Address> | The employee's full address. | Employee / Contact Info tab |
<Address1> | The employee's address 1 field. | Employee / Contact Info tab |
<Address2> | The employee's address 2 field. | Employee / Contact Info tab |
<City> | The employee's city from their address. | Employee / Contact Info tab |
<State> | The employee's state from their address. | Employee / Contact Info tab |
Dynamic Fields
Examples of dynamically named fields are labor levels and the employee custom types.
Merge Field | Replaced With | Notes |
---|---|---|
<LaborLevelX> or <"Labor Level Name"> | The labor level description of the level X (where X = 0 to 9) labor level or the labor level with the name provided, e.g. <Department> will be replaced with the employee's department description. | If using the numerical reference, the level is determined by looking at Configuration / Setup / System / Labor Levels tab. This is a zero based index and the order in which labor levels are displayed is not necessarily the index of the labor level. The second labor level is number 1 so <LaborLevel1ID> would be replaced with the employee's second labor level ID. For example, this might be the ID of the employee's company. The alternative syntax is <Company> |
<LaborLevelXID> | The labor level ID of the level X labor level. | See <LaborLevelX> above for details. If using the labor level name then an example is <CompanyID> |
<LaborLevelXDescription> | The labor level description of the level X labor level. | See <LaborLevelXID> above for details. If using the labor level name then an example is <DepartmentDescription>. |
<LaborLevelXSchedulerID> | The scheduler ID of the level X labor level. | See <LaborLevelXID> above for details. If using the labor level name then an example is <FloorSchedulerID>. |
<LaborLevelXPayrollID> | The payroll ID of the level X labor level. | See <LaborLevelXID> above for details. If using the labor level name then an example is <DepartmentPayrollID>. |
<LaborLevelXTag> | The complete Tag of the level X labor level. | See <LaborLevelXID> above for details. If using the labor level name then an example is <CompanyTag>. |
<LaborLevelXTag1> | The first Tag of the level X labor level. | See <LaborLevelXID> above for details. |
<LaborLevelXTag2> | The second Tag of the level X labor level. | See <LaborLevelXID> above for details. |
<LaborLevelXTag3> | The third Tag of the level X labor level. | See <LaborLevelXID> above for details. |
<LaborLevelXTag4> | The fourth Tag of the level X labor level. | See <LaborLevelXID> above for details. |
<LaborLevelXTag5> | The fifth Tag of the level X labor level. | See <LaborLevelXID> above for details. |