Report Designer: Employee variables

We moved!

Help articles have been migrated to the new Help and Support. You can find help for your products and accounts, discover FAQs, explore training, and contact us!

The Report Designer Employee variables display information on reports about the setup and activity of employees. The following table lists all of the currently available variables, what they output, and where the information is retrieved from within the application.

See also: Variables overview

Workpapers CS users: This section of variables is visible in the Design Tools frame in the Report Designer, but will not output any information. If any of these variables are inserted, the report or other document may display as "This report contains no data."

Employee

Variable name	Data content/source	Format	Variable syntax
EIN/SSN	The employee EIN or SSN from Setup > Employees	Number	[Employee.EINSSN]
EIN/SSN (last four digits)	The last four digits of the employee EIN or SSN from Setup > Employees	Number	[Employee.EINSSNLastFourDigits]
Verified EIN/SSN	Verified checkbox on Setup > Employees	Yes/no	[Employee.EINSSNVerified]
EIN/SSN Verified Date	The verified date from Setup > Employees	Date	[Employee.EINSSNVerifiedDate]
First Name	The employee first name from Setup > Employees	Text	[Employee.FirstName]
Full Name (first, middle initial, last)	The employee full name (first, middle initial, last) from Setup > Employees	Text	[Employee.FullName.FirstMILast]
Full Name (first, middle initial, last, suffix)	The employee full name (first, middle initial, last, suffix ) from Setup > Employees	Text	[Employee.FullNameFirstMILastSuffix]
Full Name (first, middle, last)	The employee full name (first, middle, last) from Setup > Employees	Text	[Employee.FullNameFirstMiddleLast]
Full Name (first, middle, last, suffix)	The employee full name (first, middle, last, suffix) from Setup > Employees	Text	[Employee.FullNameFirstMiddleLastSuffix]
Full Name (last, first, middle initial)	The employee full name (last, first, middle initial) from Setup > Employees	Text	[Employee.FullNameLastFirstMI]
Full Name (last, first, middle initial, suffix)	The employee full name (last, first, middle initial, suffix) from Setup > Employees	Text	[Employee.FullNameLastFirstMISuffix]
Full Name (last, first, middle)	The employee full name (last, first, middle) from Setup > Employees	Text	[Employee.FullNameLastFirstMiddle]
Full Name (last, first, middle, suffix)	The employee full name (last, first, middle, suffix) from Setup > Employees	Text	[Employee.FullNameLastFirstMiddleSuffix]
Employee ID	The employee ID from Setup > Employees	Text	[Employee.ID]
Last Name	The employee last name from Setup > Employees	Text	[Employee.LastName]
Middle Initial	The employee middle name from Setup > Employees	Text	[Employee.MiddleInitial]
Middle Name	The employee middle name from Setup > Employees	Text	[Employee.MiddleName]
Name Suffix	The employee name suffix from Setup > Employees	Text	[Employee.NameSuffix]
Status	The status of the employee based on the hire date and inactive date fields from Setup > Employees	Text	[Employee.Status]
Type	The employee type (Standard, Household, etc.) from Setup > Employees	Text	[Employee.Type]

Accruable Benefits

Variable name	Data content/source	Format	Variable syntax
Active	Active checkbox on the Accruable Benefits tab of Setup > Employees	Yes/no	[Employee.AccruableBenefits.Active]
Adjustment	The adjustment made to the accruable benefit on Setup > Employees	Number	[Employee.AccruableBenefits.Adjustment]
Allowance	The allowance field from the Accruable Benefits tab on Setup > Employees	Number	[Employee.AccruableBenefits.Allowance]
Annual Limit	The annual limit of the accruable benefit from Setup > Employees	Number	[Employee.AccruableBenefits.AnnualLimit]
Available Limit	The available limit of the accruable benefits from Setup > Employees	Number	[Employee.AccruableBenefits.AvailableLimit]
Beginning Balance	The beginning balance of the accruable benefit from Setup > Employees	Number	[Employee.AccruableBenefits.BeginningBalance]
Carryover Maximum	The carryover maximum of the accruable benefit from Setup > Employees	Number	[Employee.AccruableBenefits.CarryoverMaximum]
Description	The description of the accruable benefit from Setup > Employees	Text	[Employee.AccruableBenefits.Description]
Report Description	The report description of the accruable benefit from Setup > Accruable Benefits	Text	[Employee.AccruableBenefits.ReportDescription]
Accrued Hours	The accrued benefit hours from Setup > Employees	Number	[Employee.AccruableBenefits.Balances.AccruedHours]
Adjustment Hours	The number of hours entered in the adjustment on Setup > Employees	Number	[Employee.AccruableBenefits.Balances.AdjustmentHours]
Available Hours	The number of available hours for the accruable benefit from Setup > Employees	Number	[Employee.AccruableBenefits.Balances.AvailableHours]
Beginning Balance Hours	The beginning balance hours for the accruable benefit from Setup > Employees	Number	[Employee.AccruableBenefits.Balances.BeginningBalanceHours]
Benefit Year Begin Date	The beginning date of the accruable benefit year from Setup > Accruable Benefits	Date	[Employee.AccruableBenefits.Balances.BenefitYearBeginDate]
Benefit Year Date Range	The date range of the accruable benefit year from Setup > Accruable Benefits	Date	[Employee.AccruableBenefits.Balances.BenefitYearDateRange]
Benefit Year End Date	The ending date of the accruable benefit year from Setup > Accruable Benefits	Date	[Employee.AccruableBenefits.Balances.BenefitYearEndDate]
Used Hours	The calculated number of used hours from Setup > Accruable Benefits	Number	[Employee.AccruableBenefits.Balances.UsedHours]

Addresses

Variable name	Data content/source	Format	Variable syntax
Business Address Line 1	The first line of the employee business from Setup > Employees	Text	[Employee.Business.AddressLine1]
Business Address Line 1 and Line 2	The first and second lines of the employee business address from Setup > Employees	Text	[Employee.Business.AddressLine1andAddressLine2]
Business Address Line 2	The second line of the employee business address from Setup > Employees	Text	[Employee.Business.AddressLine2]
Business Address City	The city of the employee business address from Setup > Employees	Text	[Employee.Business.City]
Business Address City, State and Zip	The city, state and zip code of the employee business address from Setup > Employees	Text	[Employee.Business.CityStateandZip]
Complete Business Address	The complete employee business address from Setup > Employees	Text	[Employee.Business.CompleteAddress]
Complete Business Address (single line)	The complete employee business address from Setup > Employees	Text	[Employee.Business.CompleteAddressSingleLine]
Business Address Country	The country of the employee business address from Setup > Employees	Text	[Employee.Business.Country]
Business Address County	The county of the employee business address from Setup > Employees	Text	[Employee.Business.County]
Business Address Municipality Code	The municipality code of the employee business address from Setup > Employees	Number	[Employee.Business.MunicipalityCode]
Business Address Municipality Description	The municipality description of the employee business address from Setup > Employees	Text	[Employee.Business.MunicipalityDescription]
Business Address School District Code	The school district code of the employee business address from Setup > Employees	Number	[Employee.Business.SchoolDistrictCode]
Business Address School District Description	The school district description of the employee business address from Setup > Employees	Text	[Employee.Business.SchoolDistrictDescription]
Business Address State (abbreviation)	The state abbreviation of the employee business address from Setup > Employees	Text	[Employee.Business.State]
Business Address State (full name)	The state name of the employee business address from Setup > Employees	Text	[Employee.Business.StateName]
Business Address Zip Code	The zip code of the employee business address from Setup > Employees	Number	[Employee.Business.Zip]
Home Address Line 1	The first line of the employee home address from Setup > Employees	Text	[Employee.Home.AddressLine1]
Home Address Line 1 and Line 2	The first and second lines of the employee home address from Setup > Employees	Text	[Employee.Home.AddressLine1andAddressLine2]
Home Address Line 2	The second line of the employee home address from Setup > Employees	Text	[Employee.Home.AddressLine2]
Home Address City	The city of the employee home address from Setup > Employees	Text	[Employee.Home.City]
Home Address City, State and Zip	The city, state and zip code of the employee home address from Setup > Employees	Text	[Employee.Home.CityStateandZip]
Complete Home Address	The complete home address for the employee from Setup > Employees	Text	[Employee.Home.CompleteAddress]
Complete Home Address (single line)	The complete home address for the employee from Setup > Employees	Text	[Employee.Home.CompleteAddressSingleLine]
Home Address Country	The country of the employee home address from Setup > Employees	Text	[Employee.Home.Country]
Home Address County	The county of the employee home address from Setup > Employees	Text	[Employee.Home.County]
Home Address Municipality Code	The municipality code of the employee home address from Setup > Employees	Number	[Employee.Home.MunicipalityCode]
Home Address Municipality Description	The municipality description of the employee home address from Setup > Employees	Text	[Employee.Home.MunicipalityDescription]
Home Address School District Code	The school district code of the employee home address from Setup > Employees	Number	[Employee.Home.SchoolDistrictCode]
Home Address School District Description	The school district description of the employee home address from Setup > Employees	Text	[Employee.Home.SchoolDistrictDescription]
Home Address State (abbreviation)	The state abbreviation of the employee home address from Setup > Employees	Text	[Employee.Home.State]
Home Address State (full name)	The state name of the employee home address from Setup > Employees	Text	[Employee.Home.StateName]
Home Address Zip Code	The zip code of the home address from Setup > Employees	Number	[Employee.Home.Zip]
Mailing Address Line 1	The first line of the employee mailing address from Setup > Employees	Text	[Employee.Mailing.AddressLine1]
Mailing Address Line 1 and Line 2	The first and second lines of the employee mailing address from Setup > Employees	Text	[Employee.Mailing.AddressLine1andAddressLine2]
Mailing Address Line 2	The second line of the employee mailing address from Setup > Employees	Text	[Employee.Mailing.AddressLine2]
Mailing Address City	The city of the employee mailing address from Setup > Employees	Text	[Employee.Mailing.City]
Mailing Address City, State and Zip	The city, state and zip code of the employee mailing address from Setup > Employees	Text	[Employee.Mailing.CityStateandZip]
Complete Mailing Address	The complete mailing address for the employee from Setup > Employees	Text	[Employee.Mailing.CompleteAddress]
Complete Mailing Address (single line)	The complete mailing address for the employee from Setup > Employees	Text	[Employee.Mailing.CompleteAddressSingleLine]
Mailing Address Country	The country of the employee mailing address from Setup > Employees	Text	[Employee.Mailing.Country]
Mailing Address County	The county of the employee mailing address from Setup > Employees	Text	[Employee.Mailing.County]
Mailing Address Municipality Code	The municipality code of the employee mailing address from Setup > Employees	Number	[Employee.Mailing.MunicipalityCode]
Mailing Address Municipality Description	The municipality description of the employee mailing address from Setup > Employees	Text	[Employee.Mailing.MunicipalityDescription]
Mailing Address School District Code	The school district code of the employee mailing address from Setup > Employees	Number	[Employee.Mailing.SchoolDistrictCode]
Mailing Address School District Description	The school district description of the employee mailing address from Setup > Employees	Text	[Employee.Mailing.SchoolDistrictDescription]
Mailing Address State (abbreviation)	The state abbreviation of the employee mailing address from Setup > Employees	Text	[Employee.Mailing.State]
Mailing Address State (full name)	The state name of the employee mailing address from Setup > Employees	Text	[Employee.Mailing.StateName]
Mailing Address Zip Code	The zip code of the employee mailing address from Setup > Employees	Number	[Employee.Mailing.Zip]
Other Address Line 1	The first line of the employee other address from Setup > Employees	Text	[Employee.Other.AddressLine1]
Other Address Line 1 and Line 2	The first and second lines of the employee other address from Setup > Employees	Text	[Employee.Other.AddressLine1andAddressLine2]
Other Address Line 2	The second line of the employee other address from Setup > Employees	Text	[Employee.Other.AddressLine2]
Other Address City	The city of the employee other address from Setup > Employees	Text	[Employee.Other.City]
Other Address City, State and Zip	The city, state and zip code of the employee other address from Setup > Employees	Text	[Employee.Other.CityStateandZip]
Complete Other Address	The complete other address for the employee from Setup > Employees	Text	[Employee.Other.CompleteAddress]
Complete Other Address (single line)	The complete other address for the employee on a single line from Setup > Employees	Text	[Employee.Other.CompleteAddressSingleLine]
Other Address Country	The country of the employee other address from Setup > Employees	Text	[Employee.Other.Country]
Other Address County	The county of the employee other address from Setup > Employees	Text	[Employee.Other.County]
Other Address Municipality Code	The municipality code of the employee other address from Setup > Employees	Number	[Employee.Other.MunicipalityCode]
Other Address Municipality Description	The municipality description of the employee other address from Setup > Employees	Text	[Employee.Other.MunicipalityDescription]
Other Address School District Code	The school district code of the employee other address from Setup > Employees	Number	[Employee.Other.SchoolDistrictCode]
Other Address School District Description	The school district description of the employee other address from Setup > Employees	Text	[Employee.Other.SchoolDistrictDescription]
Other Address State (abbreviation)	The state abbreviation of the employee other address from Setup > Employees	Text	[Employee.Other.State]
Other Address State (full name)	The state name of the employee other address from Setup > Employees	Text	[Employee.Other.StateName]
Other Address Zip Code	The zip code of the employee other address from Setup > Employees	Number	[Employee.Other.Zip]
Resident Address Line 1	The first line of the employee resident address from Setup > Employees	Text	[Employee.Resident.AddressLine1]
Resident Address Line 1 and Line 2	The first and second lines of the employee resident address from Setup > Employees	Text	[Employee.Resident.AddressLine1andAddressLine2]
Resident Address Line 2	The second line of the employee resident address from Setup > Employees	Text	[Employee.Resident.AddressLine2]
Resident Address City	The city of the employee resident address from Setup > Employees	Text	[Employee.Resident.City]
Resident Address City, State and Zip	The city, state and zip code of the employee resident address from Setup > Employees	Text	[Employee.Resident.CityStateandZip]
Complete Resident Address	The complete resident address for the employee from Setup > Employees	Text	[Employee.Resident.CompleteAddress]
Complete Resident Address (single line)	The complete resident address for the employee from Setup > Employees	Text	[Employee.Resident.CompleteAddressSingleLine]
Resident Address Country	The country of the employee resident address from Setup > Employees	Text	[Employee.Resident.Country]
Resident Address County	The county of the employee resident address from Setup > Employees	Text	[Employee.Resident.County]
Resident Address Municipality Code	The municipality code of the employee resident address from Setup > Employees	Number	[Employee.Resident.MunicipalityCode]
Resident Address Municipality Description	The municipality description of the employee resident address from Setup > Employees	Text	[Employee.Resident.MunicipalityDescription]
Resident Address School District Code	The school district code of the employee resident address from Setup > Employees	Number	[Employee.Resident.SchoolDistrictCode]
Resident Address School District Description	The school district description of the employee resident address from Setup > Employees	Text	[Employee.Resident.SchoolDistrictDescription]
Resident Address State (abbreviation)	The state abbreviation of the employee resident address from Setup > Employees	Text	[Employee.Resident.State]
Resident Address State (full name)	The state name of the employee resident address from Setup > Employees	Text	[Employee.Resident.StateName]
Resident Address Zip Code	The zip code of the employee resident address from Setup > Employees	Number	[Employee.Resident.Zip]

Affordable Care Act Information

Variable name	Data content/source	Format	Variable syntax
Employment Status	The employment status of the employee for ACA reporting purposes as selected on Setup > Employees	Text	[Employee.AffordableCareActInformation.EmploymentStatus]
Box 14 code (all 12 months)	The Box 14 code selected in the 1095-C Part II: Offer and Coverage dialog on the Personal tab of the Setup > Employees screen.	Text	[Employee.AffordableCareActInformation.1095CPartII.Box14CodeAll12Months]
Box 15 amount (all 12 months)	The Box 15 amount entered in the 1095-C Part II: Offer and Coverage dialog on the Personal tab of the Setup > Employees screen.	Number	[Employee.AffordableCareActInformation.1095CPartII.Box15AmountAll12Months]
Box 16 code (all 12 months)	The Box 16 code selected in the 1095-C Part II: Offer and Coverage dialog on the Personal tab of the Setup > Employees screen.	Text	[Employee.AffordableCareActInformation.1095CPartII.Box16CodeAll12Months]
Year	The year selected in the 1095-C Part II: Offer and Coverage dialog on the Personal tab of the Setup > Employees screen.	Number	[Employee.AffordableCareActInformation.1095CPartII.Year]
Box 14 code: April	The Box 14 code selected for April in the 1095-C Part II Monthly Information dialog on the Personal tab of the Setup > Employees screen.	Text	[Employee.AffordableCareActInformation.1095CPartII.MonthlyInformation.AprilBox14Code]
Box 15 amount: April	The Box 15 amount entered in the 1095-C Part II Monthly Information dialog on the Personal tab of the Setup > Employees screen.	Number	[Employee.AffordableCareActInformation.1095CPartII.MonthlyInformation.AprilBox15Amount]
Box 16 code: April	The Box 16 code selected in the 1095-C Part II Monthly Information dialog on the Personal tab of the Setup > Employees screen.	Text	[Employee.AffordableCareActInformation.1095CPartII.MonthlyInformation.AprilBox16Code]
Box 14 code: August	The Box 14 code selected in the 1095-C Part II Monthly Information dialog on the Personal tab of the Setup > Employees screen.	Text	[Employee.AffordableCareActInformation.1095CPartII.MonthlyInformation.AugustBox14Code]
Box 15 amount: August	The Box 15 amount entered in the 1095-C Part II Monthly Information dialog on the Personal tab of the Setup > Employees screen.	Number	[Employee.AffordableCareActInformation.1095CPartII.MonthlyInformation.AugustBox15Amount]
Box 16 code: August	The Box 16 code selected in the 1095-C Part II Monthly Information dialog on the Personal tab of the Setup > Employees screen.	Text	[Employee.AffordableCareActInformation.1095CPartII.Monthly Information.AugustBox16Code]
Box 14 code: December	The Box 14 code selected in the 1095-C Part II Monthly Information dialog on the Personal tab of the Setup > Employees screen.	Text	[Employee.AffordableCareActInformation.1095CPartII.MonthlyInformation.DecemberBox14Code]
Box 15 amount: December	The Box 15 amount entered in the 1095-C Part II Monthly Information dialog on the Personal tab of the Setup > Employees screen.	Number	[Employee.AffordableCareActInformation.1095CPartII.MonthlyInformation.DecemberBox15Amount]
Box 16 code: December	The Box 16 code selected in the 1095-C Part II Monthly Information dialog on the Personal tab of the Setup > Employees screen.	Text	[Employee.AffordableCareActInformation.1095CPartII.MonthlyInformation.DecemberBox16Code]
Box 14 code: February	The Box 14 code selected in the 1095-C Part II Monthly Information dialog on the Personal tab of the Setup > Employees screen.	Text	[Employee.AffordableCareActInformation.1095CPartII.MonthlyInformation.FebruaryBox14Code]
Box 15 amount: February	The Box 15 amount entered in the 1095-C Part II Monthly Information dialog on the Personal tab of the Setup > Employees screen.	Number	[Employee.AffordableCareActInformation.1095CPartII.MonthlyInformation.FebruaryBox15Amount]
Box 16 code: February	The Box 16 code selected in the 1095-C Part II Monthly Information dialog on the Personal tab of the Setup > Employees screen.	Text	[Employee.AffordableCareActInformation.1095CPartII.MonthlyInformation.FebruaryBox16Code]
Box 14 code: January	The Box 14 code selected in the 1095-C Part II Monthly Information dialog on the personal tab of the Setup > Employees screen.	Text	[Employee.AffordableCareActInformation.1095CPartII.MonthlyInformation.JanuaryBox14Code]
Box 15 amount: January	The Box 15 amount entered in the 1095-C Part II Monthly Information dialog on the Personal tab of Setup > Employees screen.	Number	[Employee.AffordableCareActInformation.1095CPartII.MonthlyInformation.JanuaryBox15Amount]
Box 16 code: January	The Box 16 code selected in the 1095-C Part II Monthly Information dialog on the Personal tab of the Setup > Employees screen.	Text	[Employee.AffordableCareActInformation.1095CPartII.MonthlyInformation.JanuaryBox16Code]
Box 14 code: July	The Box 14 code selected in the 1095-C Part II Monthly Information dialog on the Personal tab of the Setup > Employees screen.	Text	[Employee.AffordableCareActInformation.1095CPartII.MonthlyInformation.JulyBox14Code]
Box 15 amount: July	The Box 15 amount entered in the 1095-C Part II Monthly Information dialog on the Personal tab of the Setup > Employees screen.	Number	[Employee.AffordableCareActInformation.1095CPartII.MonthlyInformation.JulyBox15Amount]
Box 16 code: July	The Box 16 code selected in the 1095-C Part II Monthly Information dialog on the Personal tab of the Setup > Employees screen.	Text	[Employee.AffordableCareActInformation.1095CPartII.MonthlyInformation.JulyBox16Code]
Box 14 code: June	The Box 14 code selected in the 1095-C Part II MonthlyInformation dialog on the Personal tab of the Setup > Employees screen.	Text	[Employee.AffordableCareActInformation.1095CPartII.MonthlyInformation.JuneBox14Code]
Box 15 amount: June	The Box 15 amount entered in the 1095-C Part II Monthly Information dialog on the Personal tab of the Setup > Employees screen.	Number	[Employee.AffordableCareActInformation.1095CPartII.MonthlyInformation.JuneBox15Amount]
Box 16 code: June	The Box 16 code selected in the 1095-C Part II Monthly Information dialog on the Personal tab of the Setup > Employees screen.	Text	[Employee.AffordableCareActInformation.1095CPartII.MonthlyInformation.JuneBox16Code]
Box 14 code: March	The Box 14 code selected in the 1095-C Part II Monthly Information dialog on the Personal tab of the Setup > Employees screen.	Text	[Employee.AffordableCareActInformation.1095CPartII.MonthlyInformation.MarchBox14Code]
Box 15 amount: March	The Box 15 amount entered in the 1095-C Part II Monthly Information dialog on the Personal tab of the Setup > Employees screen.	Number	[Employee.AffordableCareActInformation.1095CPartII.MonthlyInformation.MarchBox15Amount]
Box 16 code: March	The Box 16 code selected in the 1095-C Part II Monthly Information dialog on the Personal tab of the Setup > Employees screen.	Text	[Employee.AffordableCareActInformation.1095CPartII.MonthlyInformation.MarchBox16Code]
Box 14 code: May	The Box 14 code selected in the 1095-C Part II Monthly Information dialog on the Personal tab of the Setup > Employees screen.	Text	[Employee.AffordableCareActInformation.1095CPartII.MonthlyInformation.MayBox14Code]
Box 15 amount: May	The Box 15 amount entered in the 1095-C Part II Monthly Information dialog on the Personal tab of the Setup > Employees screen.	Number	[Employee.AffordableCareActInformation.1095CPartII.MonthlyInformation.MayBox15Amount]
Box 16 code: May	The Box 16 code selected in the 1095-C Part II Monthly Information dialog on the Personal tab of the Setup > Employees screen.	Text	[Employee.AffordableCareActInformation.1095CPartII.MonthlyInformation.MayBox16Code]
Box 14 code: November	The Box 14 code selected in the 1095-C Part II Monthly Information dialog on the Personal tab of the Setup > Employees screen.	Text	[Employee.AffordableCareActInformation.1095CPartII.MonthlyInformation.NovemberBox14Code]
Box 15 amount: November	The Box 15 amount entered in the 1095-C Part II Monthly Information dialog on the Personal tab of the Setup > Employees screen.	Number	[Employee.AffordableCareActInformation.1095CPartII.MonthlyInformation.NovemberBox15Amount]
Box 16 code: November	The Box 16 code selected in the 1095-C Part II Monthly Information dialog on the Personal tab of the Setup > Employees screen.	Text	[Employee.AffordableCareActInformation.1095CPartII.MonthlyInformation.NovemberBox16Code]
Box 14 code: October	The Box 14 code selected in the 1095-C Part II Monthly Information dialog on the Personal tab of the Setup > Employees screen.	Text	[Employee.AffordableCareActInformation.1095CPartII.MonthlyInformation.OctoberBox14Code]
Box 15 amount: October	The Box 15 amount entered in the 1095-C Part II Monthly Information dialog on the Personal tab of the Setup > Employees screen.	Number	[Employee.AffordableCareActInformation.1095CPartII.MonthlyInformation.OctoberBox15Amount]
Box 16 code: October	The Box 16 code selected in the 1095-C Part II Monthly Information dialog on the Personal tab of the Setup > Employees screen.	Text	[Employee.AffordableCareActInformation.1095CPartII.MonthlyInformation.OctoberBox16Code]
All 12 months	All 12 months checkbox on the 1095-C Part III: Self-Insured dialog on the Personal tab of the Setup > Employees screen.	Yes/No	[Employee.AffordableCareActInformation.1095CPartIII.All12Months]
Birthdate	The date entered in the DOB field on the 1095-C Part III: Self-Insured dialog on the Personal tab of the Setup > Employees screen.	Date	[Employee.AffordableCareActInformation.1095CPartIII.BirthDate]
Employee (checkbox)	Employee checkbox in the 1095-C Part III: Self-Insured dialog on the Personal tab of the Setup > Employees screen.	Yes/No	[Employee.AffordableCareActInformation.1095CPartIII.Employee]
First name	The first name entered in the 1095-C Part III: Self-Insured dialog on the Personal tab of the Setup > Employees screen.	Text	[Employee.AffordableCareActInformation.1095CPartIII.FirstName]
Last name	The last name entered in the 1095-C Part III: Self-Insured dialog on the Personal tab of the Setup > Employees screen.	Text	[Employee.AffordableCareActInformation.1095CPartIII.LastName]
SSN	The Social Security Number (SSN) entered in the 1095-C Part III: Self-Insured dialog on the Personal tab of the Setup > Employees screen.	Number	[Employee.AffordableCareActInformation.1095CPartIII.SSN]
Suffix	The suffix entered in the 1095-C Part III: Self-Insured dialog on the Personal tab of the Setup > Employees screen.	Text	[Employee.AffordableCareActInformation.1095CPartIII.Suffix]
Year	The year selected in the 1095-C Part III:Self-Insured dialog on the Personal tab of the Setup > Employees screen.	Number	[Employee.AffordableCareActInformation.1095CPartIII.Year
April (checkbox)	April checkbox on the 1095-C Part III: Self-Insured dialog on the Personal tab of the Setup > Employees screen.	Yes/No	[Employee.AffordableCareActInformation.1095CPartIII.Months.April]
August (checkbox)	August checkbox on the 1095-C Part III: Self-Insured dialog on the Personal tab of the Setup > Employees screen.	Yes/No	[Employee.AffordableCareActInformation.1095CPartIII.Months.August]
December (checkbox)	December checkbox on the 1095-C Part III: Self-Insured dialog on the Personal tab of the Setup > Employees screen.	Yes/No	[Employee.AffordableCareActInformation.1095CPartIII.Months.December]
February (checkbox)	February checkbox on the 1095-C Part III: Self-Insured dialog on the Personal tab of the Setup > Employees screen.	Yes/No	[Employee.AffordableCareActInformation.1095CPartIII.Months.February]
January (checkbox)	January checkbox on the 1095-C Part III: Self-Insured dialog on the Personal tab of the Setup > Employees screen.	Yes/No	[Employee.AffordableCareActInformation.1095CPartIII.Months.January]
July (checkbox)	July checkbox on the 1095-C Part III: Self-Insured dialog on the Personal tab of the Setup > Employees screen.	Yes/No	[Employee.AffordableCareActInformation.1095CPartIII.Months.July]
June (checkbox)	June checkbox on the 1095-C Part III: Self-Insured dialog on the Personal tab of the Setup > Employees screen.	Yes/No	[Employee.AffordableCareActInformation.1095CPartIII.Months.June]
March (checkbox)	March checkbox on the 1095-C Part III: Self-Insured dialog on the Personal tab of the Setup > Employees screen.	Yes/No	[Employee.AffordableCareActInformation.1095CPartIII.Months.March]
May (checkbox)	May checkbox on the 1095-C Part III: Self-Insured dialog on the Personal tab of the Setup > Employees screen.	Yes/No	[Employee.AffordableCareActInformation.1095CPartIII.Months.May]
November (checkbox)	November checkbox on the 1095-C Part III: Self-Insured dialog on the Personal tab of the Setup > Employees screen.	Yes/No	[Employee.AffordableCareActInformation.1095CPartIII.Months.November]
October (checkbox)	October checkbox on the 1095-C Part III: Self-Insured dialog on the Personal tab of the Setup > Employees screen.	Yes/No	[Employee.AffordableCareActInformation.1095CPartIII.Months.October]
September (checkbox)	September checkbox on the 1095-C Part III: Self-Insured dialog on the Personal tab of the Setup > Employees screen.	Yes/No	[Employee.AffordableCareActInformation.1095CPartIII.Months.September]

Change History

Variable name	Data content/source	Format	Variable syntax
Category	The category of the change made to the employee, from the background tables but also visible on Setup > Firm Information > Firm	Text	[Employee.ChangeHistory.Category]
Date/Time	The date and time that the employee record was changed, from the background tables but also visible on Setup > Firm Information > Firm	Date	[Employee.ChangeHistory.DateTime]
Field	The field of the employee record that was changed, from the background tables but also visible on Setup > Firm Information > Firm	Text	[Employee.ChangeHistory.Field]
New Value	The value that the employee record was update to, from Setup > Employees and the background tables, also visible on Setup > Firm Information > Firm	Text	[Employee.ChangeHistory.NewValue]
Old Value	The value that was changed on the employee record, from the background tables but also visible on Setup > Firm Information > Firm	Text	[Employee.ChangeHistory.OldValue]
Staff Full Name (first, middle initial, last)	The full name (first, middle initial, last) of the staff member who made the change to the employee record, from the background tables but also visible on Setup > Firm Information > Firm	Text	[Employee.ChangeHistory.StaffFullNameFirstMiLast]
Staff Full Name (first, middle, last)	The full name (first, middle, last) of the staff member who made the change to the employee record, from the background tables but also visible on Setup > Firm Information > Firm	Text	[Employee.ChangeHistory.StaffFullNameFirstMiddleLast]
Staff Full Name (last, first, middle initial)	The full name (last, first, middle initial) of the staff member who made the change to the employee record, from the background tables but also visible on Setup > Firm Information > Firm	Text	[Employee.ChangeHistory.StaffFullNameLastFirstMi]
Staff Full Name (last, first, middle)	The full name (last, first, middle) of the staff member who made the change to the employee record, from the background tables but also visible on Setup > Firm Information > Firm	Text	[Employee.ChangeHistory.StaffFullNameLastFirstMiddle]
Staff ID	The staff ID of the staff member who made the change to the employee record, from the background tables but also visible on Setup > Firm Information > Firm	Text	[Employee.ChangeHistory.StaffID]

Deduction Items

Variable name	Data content/source	Format	Variable syntax
Active	Active checkbox in the Deduction Items grid on Setup > Employees	Yes/no	[Employee.DeductionItems.Active]
Calculation Type	The calculation type of the deduction item from Setup > Employees	Text	[Employee.DeductionItems.CalculationType]
Description	The description of the deduction items from Setup > Employees	Text	[Employee.DeductionItems.Description]
GL Liability Account Number	The GL liability account number for the deduction item from Setup > Employees	Text	[Employee.DeductionItems.GlLiabilityAccount]
GL Liability Account Description	The GL liability account description for the deduction items from Setup > Employees	Text	[Employee.DeductionItems.GlLiabilityAccountDescription]
Rate	The rate for the deduction items from Setup > Employees	Number	[Employee.DeductionItems.Rate]
Report Description	The report description of the deduction item from Setup > Employees	Text	[Employee.DeductionItems.ReportDescription]
Chapter 13 Bankruptcy Agent ID	The agent ID for the chapter 13 bankruptcy deduction item from Setup > Employees	Text	[Employee.DeductionItems.Details.Chapter13BankruptcyOrders.AgentID]
Chapter 13 Bankruptcy Agent Name	The agent name for the chapter 13 bankruptcy deduction item from Setup > Employees	Text	[Employee.DeductionItems.Details.Chapter13BankruptcyOrders.AgentName]
Chapter 13 Bankruptcy Case Identifier	The case identifier for the chapter 13 bankruptcy deduction item from Setup > Employees	Text	[Employee.DeductionItems.Details.Chapter13BankruptcyOrders.CaseIdentifier]
Chapter 13 Bankruptcy Inactive Date	The inactive date for the chapter 13 bankruptcy deduction item from Setup > Employees	Date	[Employee.DeductionItems.Details.Chapter13BankruptcyOrders.InactiveDate]
Chapter 13 Bankruptcy Order Date	The order date for the chapter 13 bankruptcy deduction item from Setup > Employees	Date	[Employee.DeductionItems.Details.Chapter13BankruptcyOrders.OrderDate]
Chapter 13 Bankruptcy Rate	The chapter 13 bankruptcy deduction item rate from Setup > Employees	Number	[Employee.DeductionItems.Details.Chapter13BankruptcyOrders.Rate]
Chapter 13 Bankruptcy Total Order Amount	The total order amount of the chapter 13 bankruptcy deduction item from Setup > Employees	Amount	[Employee.DeductionItems.Details.Chapter13BankruptcyOrders.TotalOrderAmount]
Child Support Agent ID	The agent ID for the child support deduction item from Setup > Employees	Text	[Employee.DeductionItems.Details.ChildSupportOrders.AgentID]
Child Support Agent Name	The agent name for the child support deduction item from Setup > Employees	Text	[Employee.DeductionItems.Details.ChildSupportOrders.AgentName]
Child Support Case Identifier	The child support deduction item case identifier from Setup > Employees	Text	[Employee.DeductionItems.Details.ChildSupportOrders.CaseIdentifier]
Child Support In Arrears	In Arrears checkbox on the child support deduction item detail dialog on Setup > Employees	Yes/no	[Employee.DeductionItems.Details.ChildSupportOrders.InArrears]
Child Support Inactive Date	The inactive date for the child support deduction item from Setup > Employees	Date	[Employee.DeductionItems.Details.ChildSupportOrders.InactiveDate]
Child Support Order County	The county of the child support deduction item from Setup > Employees	Text	[Employee.DeductionItems.Details.ChildSupportOrders.OrderCounty]
Child Support Order Date	The order date of the child support deduction item from Setup > Employees	Date	[Employee.DeductionItems.Details.ChildSupportOrders.OrderDate]
Child Support Order State (abbreviation)	The state abbreviation of the child support deduction item from Setup > Employees	Text	[Employee.DeductionItems.Details.ChildSupportOrders.OrderState]
Child Support Order State (full name)	The state name of the child support deduction item from Setup > Employees	Text	[Employee.DeductionItems.Details.ChildSupportOrders.OrderStateName]
Child Support Order Rate	The rate of the child support deduction item from Setup > Employees	Number	[Employee.DeductionItems.Details.ChildSupportOrders.Rate]
Child Support Order Status	The status of the child support deduction item from Setup > Employees	Text	[Employee.DeductionItems.Details.ChildSupportOrders.Status]
Child Support Second Family	This employee supports a second family checkbox on the pay item details dialog for the child support deduction item on Setup > Employees	Yes/no	[Employee.DeductionItems.Details.ChildSupportOrders.SupportsSecondFamily]
Child Support Total Order Amount	The total order amount for the child support deduction item from Setup > Employees	Amount	[Employee.DeductionItems.Details.ChildSupportOrders.TotalOrderAmount]
Creditor Garnishment Agent ID	The agent ID for the creditor garnishment deduction item from Setup > Employees	Text	[Employee.DeductionItems.Details.CreditorGarnishmentOrders.AgentID]
Creditor Garnishment Agent Name	The agent name for the creditor garnishment deduction item from Setup > Employees	Text	[Employee.DeductionItems.Details.CreditorGarnishmentOrders.AgentName]
Creditor Garnishment Case Identifier	The case identifier for the creditor garnishment deduction item from Setup > Employees	Text	[Employee.DeductionItems.Details.CreditorGarnishmentOrders.CaseIdentifier]
Creditor Garnishment Inactive Date	The inactive date for the creditor garnishment deduction item from Setup > Employees	Date	[Employee.DeductionItems.Details.CreditorGarnishmentOrders.InactiveDate]
Creditor Garnishment Order Date	The order date for the creditor garnishment deduction item from Setup > Employees	Date	[Employee.DeductionItems.Details.CreditorGarnishmentOrders.OrderDate]
Creditor Garnishment Order State (abbreviation)	The order state abbreviation for the creditor garnishment deduction item from Setup > Employees	Text	[Employee.DeductionItems.Details.CreditorGarnishmentOrders.OrderState]
Creditor Garnishment Order State (full name)	The order state name for the creditor garnishment deduction item from Setup > Employees	Text	[Employee.DeductionItems.Details.CreditorGarnishmentOrders.OrderStateName]
Creditor Garnishment Rate	The rate of the creditor garnishment deduction item from Setup > Employees	Number	[Employee.DeductionItems.Details.CreditorGarnishmentOrders.Rate]
Creditor Garnishment Total Order Amount	The total order amount for the creditor garnishment deduction item from Setup > Employees	Amount	[Employee.DeductionItems.Details.CreditorGarnishmentOrders.TotalOrderAmount]
Defaulted Student Loan Order Agent ID	The agent ID of the defaulted student loan deduction item from Setup > Employees	Text	[Employee.DeductionItems.Details.DefaultedStudentLoanOrders.AgentID]
Defaulted Student Loan Order Agent Name	The agent name of the defaulted student loan deduction item from Setup > Employees	Text	[Employee.DeductionItems.Details.DefaultedStudentLoanOrders.AgentName]
Defaulted Student Loan Case Identifier	The case identifier for the defaulted student loan deduction item from Setup > Employees	Text	[Employee.DeductionItems.Details.DefaultedStudentLoanOrders.CaseIdentifier]
Defaulted Student Loan Inactive Date	The inactive date for the defaulted student loan deduction item from Setup > Employees	Date	[Employee.DeductionItems.Details.DefaultedStudentLoanOrders.InactiveDate]
Defaulted Student Loan Order Date	The order date for the defaulted student loan deduction item from Setup > Employees	Date	[Employee.DeductionItems.Details.DefaultedStudentLoanOrders.OrderDate]
Defaulted Student Loan Order Rate	The rate for the defaulted student loan deduction item from Setup > Employees	Number	[Employee.DeductionItems.Details.DefaultedStudentLoanOrders.Rate]
Defaulted Student Loan Total Order Amount	The total order amount of the defaulted student loan deduction item from Setup > Employees	Amount	[Employee.DeductionItems.Details.DefaultedStudentLoanOrders.TotalOrderAmount]

Note: The following Direct Deposit section of variables will only be visible on the item details dialog on the payroll items tab on Setup > Employees if the following apply:

The item is a deduction item or employer contribution item.
The item is linked to a payroll agent vendor.
The payroll agent vendor has a payment preference of Direct Deposit.

Variable name	Data content/source	Format	Variable syntax
Direct Deposit Bank Account Number	The direct deposit bank account number for the deduction item from the payroll item details dialog on Setup > Employees	Number	[Employee.DeductionItems.Details.DirectDeposit.BankAccountNumber]
Direct Deposit Bank Account Number (last four digits)	The last four digits of the direct deposit bank account number for the deduction item from the payroll item details dialog on Setup > Employees	Number	[Employee.DeductionItems.Details.DirectDeposit.BankAccountNumberLastFourDigits]
Direct Deposit Bank Account Type	The direct deposit bank account type (checking or savings) for the deduction item from the payroll item details dialog on Setup > Employees	Text	[Employee.DeductionItems.Details.DirectDeposit.BankAccountType]
Direct Deposit Bank Name	The direct deposit bank name for the deduction item from the payroll item details dialog on Setup > Employees	Text	[Employee.DeductionItems.Details.DirectDeposit.BankName]
Direct Deposit Bank Routing Number	The direct deposit bank routing number for the deduction item from the payroll item details dialog on Setup > Employees	Number	[Employee.DeductionItems.Details.DirectDeposit.BankRoutingNumber]
Direct Deposit Status	The status of the direct deposit bank account for the deduction item from the payroll item details dialog on Setup > Employees	Text	[Employee.DeductionItems.Details.DirectDeposit.Status]

Variable name	Data content/source	Format	Variable syntax
Federal Levy Additional Deductions	The additional standard deductions of the federal levy deduction item from Setup > Employees	Number	[Employee.DeductionItems.Details.FederalLevyInformation.AdditionalStandardDeductions]
Federal Levy Filing Status	The filing status of the employee for the federal levy deduction item from Setup > Employees	Text	[Employee.DeductionItems.Details.FederalLevyInformation.FilingStatus]
Federal Levy Order Date	The order date of the federal levy deduction item from Setup > Employees	Date	[Employee.DeductionItems.Details.FederalLevyInformation.OrderDate]
Federal Levy Personal Exemptions	The number of personal exemptions for the federal levy deduction item from Setup > Employees	Number	[Employee.DeductionItems.Details.FederalLevyInformation.PersonalExemptions]
Limit Start Date	The limit beginning date for the deduction item from the payroll item details dialog on Setup > Employees	Date	[Employee.DeductionItems.Details.Limit.BeginDate]
Limit Method	The limit method for the deduction item from the payroll item details dialog on Setup > Employees	Text	[Employee.DeductionItems.Details.Limit.Method]
Limit Previously Deducted Amount	The previously deducted amount for the deduction item from the payroll item details dialog on Setup > Employees	Amount	[Employee.DeductionItems.Details.Limit.PreviouslyDeductedAmount]
Limit Rate	The limit rate for the deduction item from the payroll item details dialog on Setup > Employees	Number	[Employee.DeductionItems.Details.Limit.Rate]
Limit Type	The limit type of the deduction item from the payroll item details dialog on Setup > Employees	Text	[Employee.DeductionItems.Details.Limit.Type]
Distribution Department	The distribution department of the deduction item from Setup > Employees	Text	[Employee.DeductionItems.Details.LocationandDepartmentDistributions.Department]
Distribution GL Liability Account Number	The distribution GL liability account number for the deduction item from Setup > Employees	Text	[Employee.DeductionItems.Details.LocationandDepartmentDistributions.GLLiabilityAccount]
Distribution GL Liability Account Description	The distribution GL liability account description for the deduction item from Setup > Employees	Text	[Employee.DeductionItems.Details.LocationandDepartmentDistributions.GLLiabilityAccountDescription]
Distribution Location	The distribution location for the deduction item from Setup > Employees	Text	[Employee.DeductionItems.Details.LocationandDepartmentDistributions.Location]
Distribution Rate	The distribution rate for the deduction item from the payroll item details dialog on Setup > Employees	Number	[Employee.DeductionItems.Details.LocationandDepartmentDistributions.Rate]
Other Garnishment Agent ID	The agent ID of the other garnishment deduction item from Setup > Employees	Text	[Employee.DeductionItems.Details.OtherGarnishmentOrders.AgentID]
Other Garnishment Agent Name	The agent name of the other garnishment deduction item from Setup > Employees	Text	[Employee.DeductionItems.Details.OtherGarnishmentOrders.AgentName]
Other Garnishment Case Identifier	The case identifier for the other garnishment deduction item from Setup > Employees	Text	[Employee.DeductionItems.Details.OtherGarnishmentOrders.CaseIdentifier]
Other Garnishment Inactive Date	The inactive date for the other garnishment deduction item from Setup > Employees	Date	[Employee.DeductionItems.Details.OtherGarnishmentOrders.InactiveDate]
Other Garnishment Order Date	The order date for the other garnishment deduction item from Setup > Employees	Date	[Employee.DeductionItems.Details.OtherGarnishmentOrders.OrderDate]
Other Garnishment Order State (abbreviation)	The state abbreviation of the other garnishment deduction item from Setup > Employees	Text	[Employee.DeductionItems.Details.OtherGarnishmentOrders.OrderState]
Other Garnishment Order State (full name)	The state name of the other garnishment deduction item from Setup > Employees	Text	[Employee.DeductionItems.Details.OtherGarnishmentOrders.OrderStateName]
Other Garnishment Rate	The rate of the other garnishment deduction item from Setup > Employees	Number	[Employee.DeductionItems.Details.OtherGarnishmentOrders.Rate]
Other Garnishment Total Order Amount	The total order amount of the other garnishment deduction item from Setup > Employees	Amount	[Employee.DeductionItems.Details.OtherGarnishmentOrders.TotalOrderAmount]

Direct Deposit

Variable name	Data content/source	Format	Variable syntax
Allocation Amount	The allocation amount of the direct deposit distribution from Setup > Employees	Amount	[Employee.DirectDeposit.AllocationAmount]
Allocation Bank Account Number	The direct deposit allocation bank account number from Setup > Employees	Number	[Employee.DirectDeposit.AllocationBankAccountNumber]
Allocation Bank Account Number (last four digits)	The last four digits of the direct deposit allocation bank account number from Setup > Employees	Number	[Employee.DirectDeposit.AllocationBankAccountNumberLastFourDigits]
Allocation Bank Account Type	The direct deposit allocation bank account type (checking or savings) from Setup > Employees	Text	[Employee.DirectDeposit.AllocationBankAccountType]
Allocation Bank Name	The direct deposit allocation bank name from Setup > Employees	Text	[Employee.DirectDeposit.AllocationBankName]
Allocation Bank Routing Number	The direct deposit allocation bank routing number from Setup > Employees	Number	[Employee.DirectDeposit.AllocationBankRoutingNumber]
Allocation Percent	The direct deposit allocation percent for the bank account from Setup > Employees	Number	[Employee.DirectDeposit.AllocationPercent]
Allocation Percentage Basis	The Base allocation percentage calculations on selection (Total distribution or Remainder of distribution) from Setup > Employees	Text	[Employee.DirectDeposit.AllocationPercentageBasis]
Allocation Status	The direct deposit allocation bank account status from Setup > Employees	Text	[Employee.DirectDeposit.AllocationStatus]
Alternate Allocation	Enable alternate direct deposit allocation checkbox on Setup > Employees	Yes/no	[Employee.DirectDeposit.AlternateAllocation]
Alternate Allocation Amount	The alternate direct deposit allocation amount from Setup > Employees	Amount	[Employee.DirectDeposit.AlternateAllocationAmount]
Alternate Allocation Bank Account Number	The alternate direct deposit allocation bank account number from Setup > Employees	Number	[Employee.DirectDeposit.AlternateAllocationBankAccountNumber]
Alternate Allocation Bank Account Number (last four digits)	The last four digits of the alternate direct deposit allocation bank account number from Setup > Employees	Number	[Employee.DirectDeposit.AlternateAllocationBankAccountNumberLastFourDigits]
Alternate Allocation Bank Account Type	The alternate direct deposit allocation bank account type (checking or savings) from Setup > Employees	Text	[Employee.DirectDeposit.AlternateAllocationBankAccountType]
Alternate Allocation Bank Name	The alternate direct deposit allocation bank name from Setup > Employees	Text	[Employee.DirectDeposit.AlternateAllocationBankName]
Alternate Allocation Bank Routing Number	The alternate direct deposit allocation bank routing number from Setup > Employees	Number	[Employee.DirectDeposit.AlternateAllocationBankRoutingNumber]
Alternate Allocation Percent	The alternate direct deposit allocation percent from Setup > Employees	Number	[Employee.DirectDeposit.AlternateAllocationPercent]
Alternate Allocation Status	The status of the alternate direct deposit allocation bank account from Setup > Employees	Text	[Employee.DirectDeposit.AlternateAllocationStatus]
Paycard Recipient	Paycard recipient checkbox on the Direct Deposit tab on Setup > Employees	Yes/no	[Employee.DirectDeposit.PaycardRecipient]

Direct Deposit Net Pay Distribution

Variable name	Data content/source	Format	Variable syntax
Amount/Percent	The Amount/Percent field on the Direct Deposit tab of Setup > Employees	Number	[Employee.DirectDepositNetPayDistribution.AmountPercent]
Deposit	The Deposit field on the Direct Deposit tab of Setup > Employees	Text	[Employee.DirectDepositNetPayDistribution.Deposit]

Email and Web Addresses

Variable name	Data content/source	Format	Variable syntax
Email	The employee email address from Setup > Employees	Text	[Employee.Email]
Website	The employee website from Setup > Employees	Text	[Employee.Website]

Employer Contributions

Variable name	Data content/source	Format	Variable syntax
Active	Active checkbox for the employer contribution items on the payroll items tab on Setup > Employees	Yes/no	[Employee.EmployerContributions.Active]
Calculation Type	The calculation type of the employer contribution item from Setup > Employees	Text	[Employee.EmployerContributions.CalculationType]
Description	The description of the employer contribution item from Setup > Employees	Text	[Employee.EmployerContributions.Description]
GL Expense Account Number	The GL expense account number for the employer contribution item from Setup > Employees	Text	[Employee.EmployerContributions.GLExpenseAccount]
GL Expense Account Description	The GL expense account description for the employer contribution item from Setup > Employees	Text	[Employee.EmployerContributions.GLExpenseAccountDescription]
GL Liability Account Number	The GL liability account number for the employer contribution item from Setup > Employees	Text	[Employee.EmployerContributions.GLLiabilityAccount]
GL Liability Account Description	The GL liability account description for the employer contribution item from Setup > Employees	Text	[Employee.EmployerContributions.GLLiabilityAccountDescription]
Rate	The rate of the employer contribution items from Setup > Employees	Number	[Employee.EmployerContributions.Rate]
Report Description	The report description of the employer contribution items from Setup > Employees	Text	[Employee.EmployerContributions.ReportDescription]

Note: The following Direct Deposit section of variables will only be visible on the item details dialog on the payroll items tab on Setup > Employees if the following apply:

The item is a deduction item or employer contribution item.
The item is linked to a payroll agent vendor
The payroll agent vendor has a payment preference of Direct Deposit

Variable name	Data content/source	Format	Variable syntax
Direct Deposit Bank Account Number	The direct deposit bank account number for the employer contribution item from the payroll item details dialog on Setup > Employees	Number	[Employee.EmployerContributions.Details.DirectDeposit.BankAccountNumber]
Direct Deposit Bank Account Number (last four digits)	The last four digits of the direct deposit bank account number for the employer contribution item from the payroll item details dialog on Setup > Employees	Number	[Employee.EmployerContributions.Details.DirectDeposit.BankAccountNumberLastFourDigits]
Direct Deposit Bank Account Type	The direct deposit bank account type (checking or savings) of the employer contribution item from the payroll item details dialog on Setup > Employers	Text	[Employee.EmployerContributions.Details.DirectDeposit.BankAccountType]
Direct Deposit Bank Name	The direct deposit bank name of the employer contribution item from the payroll item details dialog on Setup > Employees	Text	[Employee.EmployerContributions.Details.DirectDeposit.BankName]
Direct Deposit Bank Routing Number	The direct deposit bank routing number of the employer contribution item from the payroll item details dialog on Setup > Employees	Number	[Employee.EmployerContributions.Details.DirectDeposit.BankRoutingNumber]
Direct Deposit Status	The status of the direct deposit bank account of the employer contribution item from the payroll item details dialog from Setup > Employees	Text	[Employee.EmployerContributions.Details.DirectDeposit.Status]

Variable name	Data content/source	Format	Variable syntax
Graduated Table Default Rate	The default rate for the employer contribution from Setup > Employees	Number	[Employee.EmployerContributions.Details.GraduatedTable.DefaultRate]
Graduated Table From	The "From" column on the graduated table dialog for the employer contribution item on Setup > Employees	Number	[Employee.EmployerContributions.Details.GraduatedTable.From]
Graduated Table To	The "To" column on the graduated table dialog for the employer contribution item on Setup > Employees	Number	[Employee.EmployerContributions.Details.GraduatedTable.To]
Limit Begin Date	The limit start date for the employer contribution item from the payroll item details dialog on Setup > Employees	Date	[Employee.EmployerContributions.Details.Limit.BeginDate]
Limit Deduction Item	The deduction item that the limit for the employer contribution item is linked to from the payroll item details dialog from Setup > Employees	Text	[Employee.EmployerContributions.Details.Limit.DeductionItem]
Limit Method	The limit method for the employer contribution item from the payroll item details dialog on Setup > Employees	Text	[Employee.EmployerContributions.Details.Limit.Method]
Previously Deducted Amount	The previously deducted amount for the perpetual limit method for the employer contribution item from the payroll item details dialog on Setup > Employees	Amount	[Employee.EmployerContributions.Details.Limit.PreviouslyDeductedAmount]
Limit Rate	The limit rate for the employer contribution item from the payroll item details dialog on Setup > Employees	Number	[Employee.EmployerContributions.Details.Limit.Rate]
Subject to HSA Limit	Subject to Health Savings Account limit checkbox on the payroll item details dialog on Setup > Employees	Yes/no	[Employee.EmployerContributions.Details.Limit.SubjecttoHealthSavingsAccountLimit]
Limit Type	The limit type for the employer contribution item on the payroll item details dialog on Setup > Employees	Text	[Employee.EmployerContributions.Details.Limit.Type]
Distribution Department	The distribution department for the employer contribution items from Setup > Employees	Text	[Employee.EmployerContributions.Details.LocationandDepartmentDistributions.Department]
Distribution GL Expense Account Number	The distribution GL expense account number for the employer contribution item from Setup > Employees	Text	[Employee.EmployerContributions.Details.LocationandDepartmentDistributions.GlExpenseAccount]
Distribution GL Expense Account Description	The distribution GL expense account description for the employer contribution item from Setup > Employees	Text	[Employee.EmployerContributions.Details.LocationandDepartmentDistributions.GlExpenseAccountDescription]
Distribution GL Liability Account Number	The distribution GL liability account number for the employer contribution item from Setup > Employees	Text	[Employee.EmployerContributions.Details.LocationandDepartmentDistributions.GlLiabilityAccount]
Distribution GL Liability Account Description	The distribution GL liability account description for the employer contribution item from Setup > Employees	Text	[Employee.EmployerContributions.Details.LocationandDepartmentDistributions.GlLiabilityAccountDescription]
Distribution Location	The distribution location for the employer contribution item from Setup > Employees	Text	[Employee.EmployerContributions.Details.LocationandDepartmentDistributions.Location]
Distribution Rate	The location/department rate for the employer contribution item from Setup > Employees	Number	[Employee.EmployerContributions.Details.LocationandDepartmentDistributions.Rate]

Employment Information

Variable name	Data content/source	Format	Variable syntax
Current Inactive Date	The inactive date for currently inactive employees from Setup > Employees	Date	[Employee.EmploymentInformation.CurrentInactiveDate]
Employment Info List	The employment information section of the personal tab on Setup > Employees	Text	[Employee.EmploymentInformation.EmploymentInfoList]
Hire Date	The employee hire date from Setup > Employees	Date	[Employee.EmploymentInformation.HireDate]
Inactive Date	The inactive date for the employee from Setup > Employees	Date	[Employee.EmploymentInformation.InactiveDate]
Job Title	The employee job title from Setup > Employees	Text	[Employee.EmploymentInformation.JobTitle]
Last Raise Date	The employee last raise date from Setup > Employees	Date	[Employee.EmploymentInformation.LastRaiseDate]
New Hire Reported	New hire reported checkbox on the Personal tab of Setup > Employees	Yes/no	[Employee.EmploymentInformation.NewHireReported]
New Hire Reported Date	The date the new hire was reported from Actions > Process New Hires	Date	[Employee.EmploymentInformation.NewHireReportedDate]
Original Hire Date	The earliest hire date from Setup > Employees	Date	[Employee.EmploymentInformation.OriginalHireDate]
Original Inactive Date	The earliest inactive date from Setup > Employees	Date	[Employee.EmploymentInformation.OriginalInactiveDate]
History Date	The date column from the Edit Employment History dialog on the personal tab of Setup > Employees	Date	[Employee.EmploymentInformation.History.Date]
History Note	The note column from the Edit Employment History dialog on the personal tab of Setup > Employees	Text	[Employee.EmploymentInformation.History.Note]
History Type	The type column from the Edit Employment History dialog on the personal tab of Setup > Employees	Text	[Employee.EmploymentInformation.History.Type]

Federal Settings

Variable name	Data content/source	Format	Variable syntax
Full FUTA Rate	Full FUTA Rate checkbox on the Payroll Taxes tab on Setup > Employees	Yes/no	[Employee.FederalSettings.FullFUTARate]
New Hire FICA Credit	New Hire FICA Credit checkbox on the Payroll Taxes tab of Setup > Employees	Yes/no	[Employee.FederalSettings.NewHireFICACredit]

Federal Withholding

Variable name	Data content/source	Format	Variable syntax
Additional Amount	The federal additional amount from the Payroll Taxes tab on Setup > Employees	Amount	[Employee.FederalWithholding.AdditionalAmount]
Additional Amount Type	The additional amount type (additional percentage, fixed amount, etc.) from Setup > Employees	Text	[Employee.FederalWithholding.AdditionalAmountType]
Federal Withholding Dependents Claimed	The Claim dependents field in the Federal Withholding section of the Payroll Taxes tab on Setup > Employees	Amount	[Employee.FederalWithholding.ClaimDependents]
Federal Withholding Deductions	The Deductions field in the Federal Withholding section of the Payroll Taxes tab on Setup > Employees	Amount	[Employee.FederalWithholding.Deductions]
Federal Withholding List	The fields in the Federal Withholding section on the Payroll Taxes tab on Setup > Employees	Text	[Employee.FederalWithholding.FedWHList]
Filing Status	The federal filing status from the Payroll Taxes tab on Setup > Employees	Text	[Employee.FederalWithholding.FilingStatus]
Nonresident Alien	Nonresident alien checkbox on the Payroll Taxes tab on Setup > Employees	Yes/no	[Employee.FederalWithholding.NonresidentAlien]
Other income	The Other income field in the Federal Withholding section of the Payroll Taxes tab on Setup > Employees	Amount	[Employee.FederalWithholding.OtherIncome]
Tax Exempt	Federal tax exempt checkbox on the Payroll Taxes tab of Setup > Employees	Yes/no	[Employee.FederalWithholding.TaxExempt]
Total Allowances	The Total allowances field on the Payroll Taxes tab of Setup > Employees	Number	[Employee.FederalWithholding.TotalAllowances]
Employee Holds Two Jobs	The Two jobs total checkbox in the Federal Withholding section of the Payroll Taxes tab on Setup > Employees	Yes/no	[Employee.FederalWithholding.TwoJobsTotal]
Employee Uses Newer W4 form	The Use 2020 (or newer) W-4 checkbox in the Federal Withholding section of the Payroll Taxes tab on Setup > Employees	Yes/no	[Employee.FederalWithholding.Use2020orNewerW4]

Locations and Departments

Variable name	Data content/source	Format	Variable syntax
Allocation Percentage	The percent column of the locations and departments section on the Main tab of Setup > Employees (when the "Enable auto-pay distribution by %" checkbox is marked)	Number	[Employee.LocationsandDepartments.AllocationPercentage]
Department	The department the employee is assigned to from the Main tab of Setup > Employees	Text	[Employee.LocationsandDepartments.Department]
Department Allocation	The distribution department of the allocation from the Main tab of Setup > Employees	Text	[Employee.LocationsandDepartments.DepartmentAllocation]
Location	The location the employee is assigned to from the Main tab of Setup > Employees	Text	[Employee.LocationsandDepartments.Location]
Location Allocation	The distribution location of the allocation from the Main tab of Setup > Employees	Text	[Employee.LocationsandDepartments.LocationAllocation]
Primary	Primary checkbox in the Locations and Departments section on the Main tab of Setup > Employees	Yes/no	[Employee.LocationsandDepartments.Primary]
Primary Allocation Percentage	The percentage in the row marked as primary in the Locations and Departments section on the Main tab of Setup > Employees	Number	[Employee.LocationsandDepartments.PrimaryAllocationPercentage]
Primary Department	The department on the row marked as primary in the Locations and Departments section on the Main tab of Setup > Employees	Text	[Employee.LocationsandDepartments.PrimaryDepartment]
Primary Location	The location on the row marked as primary in the Locations and Departments section on the Main tab of Setup > Employees	Text	[Employee.LocationsandDepartments.PrimaryLocation]
Primary Reporting Unit	Based on the row marked as primary in the Locations and Departments section on the Main tab of Setup > Employees, the reporting unit of the primary location from Setup > Clients	Text	[Employee.LocationsandDepartments.PrimaryReportingUnit]
Reporting Unit	Based on the locations assigned to the employee on the Main tab of Setup > Employees, the reporting unit of the location from Setup > Clients	Text	[Employee.LocationsandDepartments.ReportingUnit]

Other State Settings

Variable name	Data content/source	Format	Variable syntax
Disability Plan	Disability Plan field on the Payroll Taxes tab on Setup > Employees when the state is New Jersey	Text	[Employee.OtherStateSettings.DisabilityPlan]
Exemption Status	Exemption Status field on the Payroll Taxes tab on Setup > Employees when the state is California	Text	[Employee.OtherStateSettings.ExemptionStatus]
Geographic Location	Geographic location field on the Payroll Taxes tab on Setup > Employees when the state is Alaska	Text	[Employee.OtherStateSettings.GeographicLocation]
Occupational Title	Occupational Title field on the Payroll Taxes tab on Setup > Employees when the state is Alaska	Text	[Employee.OtherStateSettings.OccupationalTitle]
SOC Code	Standard Occupational Classification Code (SOC) on the Payroll Taxes tab on Setup > Employees when the state is Indiana	Text	[Employee.OtherStateSettings.SOCCode]
Wage Plan Code	Wage Plan Code field on the Payroll Taxes tab on Setup > Employees when the state is California	Text	[Employee.OtherStateSettings.WagePlanCode]
Wage Plan Description	Wage Plan Description field on the Payroll Taxes tab on Setup > Employees when the state is California	Text	[Employee.OtherStateSettings.WagePlanDescription]
Worker Relationship Code	Worker Relationship field on the Payroll Taxes tab on Setup > Employees when the state is the District of Colombia	Number	[Employee.OtherStateSettings.WorkerRelationshipCode]
Worker Relationship Description	Worker Relationship field on the Payroll Taxes tab on Setup > Employees when the state is the District of Colombia	Text	[Employee.OtherStateSettings.WorkerRelationshipDescription]

Pay Items

Variable name	Data content/source	Format	Variable syntax
Active	Active checkbox on the Payroll Items tab on Setup > Employees	Yes/no	[Employee.PayItems.Active]
Alternate Minimum Wage	The alternate minimum wage entered in the Alternate minimum wage field of the Employee Payroll Item Setup > Payroll Items	Amount	[Employee.PayItems.AlternateMinimumWage]
Calculation Type	The calculation type of the pay item from the Payroll Items tab on Setup > Employees	Text	[Employee.PayItems.CalculationType]
Description	The description of the pay items from the Payroll Items tab on Setup > Employees	Text	[Employee.PayItems.Description]
GL Expense Account Number	The GL expense account number for the pay item from the Payroll Items tab on Setup > Employees	Text	[Employee.PayItems.GLExpenseAccount]
GL Expense Account Description	The GL expense account description for the pay item from the Payroll Items tab on Setup > Employees	Text	[Employee.PayItems.GLExpenseAccountDescription]
Alternate Periodic Rate	For payroll items with a calculation type of Salary or Salary - Hours sensitive, divides the annual salary rate by the number of pay periods in the alternate payroll schedule assigned to the employee on the Setup > Employees screen and outputs the rate. If there is not an alternate payroll schedule assigned, the application assumes weekly and divides the salary by 52.	Number	[Employee.PayItems.PeriodicRateAlternate]
Primary Periodic Rate	For payroll items with a calculation type of Salary or Salary - Hours sensitive, divides the annual salary rate by the number of pay periods in the primary payroll schedule assigned to the employee on the Setup > Employees screen and outputs the rate. If there is not a primary payroll schedule assigned, the application assumes weekly and divides the salary by 52.	Number	[Employee.PayItems.PeriodicRatePrimary]
Rate	The pay item rate from the Payroll Items tab on Setup > Employees	Number	[Employee.PayItems.Rate]
Report Description	The report description of the pay item from Setup > Employees	Text	[Employee.PayItems.ReportDescription]
Auto-pay Amount	Amount checkbox on the Payroll Item details dialog on the Payroll Items tab of Setup > Employees	Yes/no	[Employee.PayItems.Details.AutoPay.Amount]
Auto-pay Standard Hours	Standard hours checkbox on the Payroll Item details dialog on the Payroll Items tab of Setup > Employees	Yes/no	[Employee.PayItems.Details.AutoPay.StandardHours]
Link to Description	The description of the linked payroll item on the Payroll Item details dialog on the Payroll Items tab of Setup > Employees	Text	[Employee.PayItems.Details.LinkTo.Description]
Link to Report Description	The report description of the linked payroll item on the Payroll Item details dialog on the Payroll Items tab of Setup > Employees	Text	[Employee.PayItems.Details.LinkTo.ReportDescription]
Distribution Department	The distribution department from the Payroll Item details dialog on the Payroll Items tab of Setup > Employees	Text	[Employee.PayItems.Details.LocationandDepartmentDistributions.Department]
Distribution GL Expense Account Number	The distribution GL expense account number from the Payroll Item detail dialog from the Payroll Items tab on Setup > Employees	Text	[Employee.PayItems.Details.LocationandDepartmentDistributions.GLExpenseAccount]
Distribution GL Expense Account Description	The distribution GL expense account description from the Payroll Item detail dialog from the Payroll Items tab on Setup > Employees	Text	[Employee.PayItems.Details.LocationandDepartmentDistributions.GLExpenseAccountDescription]
Distribution Location	The distribution location from the Payroll Item details dialog on the Payroll Items tab of Setup > Employees	Text	[Employee.PayItems.Details.LocationandDepartmentDistributions.Location]
Distribution Alternate Periodic Rate	For payroll items with a calculation type of Salary or Salary - Hours sensitive, divides the annual salary rate by the number of pay periods in the alternate payroll schedule assigned to the employee on the Setup > Employees screen and outputs the rate. If there is not an alternate payroll schedule assigned, the application assumes weekly and divides the salary by 52.	Number	[Employee.PayItems.Details.LocationandDepartmentDistributions.PeriodicRateAlternate]
Distribution Primary Periodic Rate	For payroll items with a calculation type of Salary or Salary - Hours sensitive, divides the annual salary rate by the number of pay periods in the primary payroll schedule assigned to the employee on the Setup > Employees screen and outputs the rate. If there is not a primary payroll schedule assigned, the application assumes weekly and divides the salary by 52.	Number	[Employee.PayItems.Details.LocationandDepartmentDistributions.PeriodicRatePrimary]
Distribution Rate	The rate by location/department from the Payroll Item details dialog of the Payroll Item tab on Setup > Employees	Number	[Employee.PayItems.Details.LocationandDepartmentDistributions.Rate]
Double Time Multiplier	The double time multiplier for the pay item from the Payroll Item details dialog on the Payroll Items tab on Setup > Employees	Number	[Employee.PayItems.Details.Multipliers.DoubleTime]
Overtime Multiplier	The overtime multiplier for the pay item from the Payroll Item details dialog on the Payroll Items tab on Setup > Employees	Number	[Employee.PayItems.Details.Multipliers.Overtime]

Payroll Schedules

Variable name	Data content/source	Format	Variable syntax
Alternate	The alternate payroll schedule from the Main tab of Setup > Employees	Text	[Employee.PayrollSchedules.Alternate]
Alternate Next Check Date	The next check date of the payroll schedule selected as the alternate, from Setup > Employees and Setup > Clients	Date	[Employee.PayrollSchedules.AlternateNextCheckDate]
Alternate Next Period Begin Date	The next period begin date of the payroll schedule selected as the alternate, from Setup > Employees and Setup > Clients	Date	[Employee.PayrollSchedules.AlternateNextPeriodBeginDate]
Alternate Next Period End Date	The next period end date of the payroll schedule selected as the alternate, from Setup > Employees and Setup > Clients	Date	[Employee.PayrollSchedules.AlternateNextPeriodEndDate]
Pay Schedule List	The selections made in the Payroll Schedules section on the Main tab of Setup > Employees	Text	[Employee.PayrollSchedules.PayScheduleList]
Primary	The primary payroll schedule from the Main tab of Setup > Employees	Text	[Employee.PayrollSchedules.Primary]
Primary Next Check Date	The next check date of the primary payroll schedule, from Setup > Employees and Setup > Clients	Date	[Employee.PayrollSchedules.PrimaryNextCheckDate]
Primary Next Period Begin Date	The next period beginning date of the primary payroll schedule from Setup > Employees and Setup > Clients	Date	[Employee.PayrollSchedules.PrimaryNextPeriodBeginDate]
Primary Next Period End Date	The next period ending date of the primary payroll schedule from Setup > Employees and Setup > Clients	Date	[Employee.PayrollSchedules.PrimaryNextPeriodEndDate]

Personal Information

Variable name	Data content/source	Format	Variable syntax
Birthday	The birth date from the Personal tab on Setup > Employees	Date	[Employee.PersonalInformation.BirthDate]
Gender	The gender from the Personal tab from Setup > Employees	Text	[Employee.PersonalInformation.Gender]
Marital Status	The marital status from the Personal tab on Setup > Employees	Text	[Employee.PersonalInformation.MaritalStatus]
Personal Info List	The Personal Information section on the Personal tab of Setup > Employees	Text	[Employee.PersonalInformation.PersonalInfoList]
Race	The race from the Personal tab on Setup > Employees	Text	[Employee.PersonalInformation.Race]

Phone and Fax Numbers

Variable name	Data content/source	Format	Variable syntax
Business Extension	The employee business extension from Setup > Employees	Number	[Employee.Business.Extension]
Business Number	The employee business number from Setup > Employees	Number	[Employee.Business.Number]
Business Number and Extension	The employee business number and extension from Setup > Employees	Number	[Employee.Business.NumberandExtension]
Car Extension	The employee car extension from Setup > Employees	Number	[Employee.Car.Extension]
Car Number	The employee car number from Setup > Employees	Number	[Employee.Car.Number]
Car Number and Extension	The employee car number and extension from Setup > Employees	Number	[Employee.Car.NumberandExtension]
Fax Extension	The employee fax extension from Setup > Employees	Number	[Employee.Fax.Extension]
Fax Number	The employee fax number from Setup > Employees	Number	[Employee.Fax.Number]
Fax Number and Extension	The employee fax number and extension from Setup > Employees	Number	[Employee.Fax.NumberandExtension]
Home Extension	The employee home extension from Setup > Employees	Number	[Employee.Home.Extension]
Home Number	The employee home number from Setup > Employees	Number	[Employee.Home.Number]
Home Number and Extension	The employee home number and extension from Setup > Employees	Number	[Employee.Home.NumberandExtension]
Mobile Extension	The employee mobile extension from Setup > Employees	Number	[Employee.Mobile.Extension]
Mobile Number	The employee mobile number from Setup > Employees	Number	[Employee.Mobile.Number]
Mobile Number and Extension	The employee mobile number and extension from Setup > Employees	Number	[Employee.Mobile.NumberandExtension]
Other Extension	The employee other extension from Setup > Employees	Number	[Employee.Other.Extension]
Other Number	The employee other number from Setup > Employees	Number	[Employee.Other.Number]
Other Number and Extension	The employee other number and extension from Setup > Employees	Number	[Employee.Other.NumberandExtension]
Pager Extension	The employee pager extension from Setup > Employees	Number	[Employee.Pager.Extension]
Pager Number	The employee pager number from Setup > Employees	Number	[Employee.Pager.Number]
Pager Number and Extension	The employee pager number and extension from Setup > Employees	Number	[Employee.Pager.NumberandExtension]

Reporting Types

Variable name	Data content/source	Format	Variable syntax
Family of Owner	Family of Owner checkbox on the Personal tab of Setup > Employees	Yes/no	[Employee.ReportingTypes.FamilyofOwner]
Officer	Officer checkbox on the Personal tab of Setup > Employees	Yes/no	[Employee.ReportingTypes.Officer]
Part-Time	Part-time checkbox on the Personal tab of Setup > Employees	Yes/no	[Employee.ReportingTypes.PartTime]
Probationary	Probationary checkbox on the Personal tab of Setup > Employees	Yes/no	[Employee.ReportingTypes.Probationary]
Seasonal	Seasonal checkbox on the Personal tab of Setup > Employees	Yes/no	[Employee.ReportintTypes.Seasonal]
Type List	Outputs a list of the reporting types from the Personal tab of Setup > Employees	Text	[Employee.ReportingTypes.TypeList]
Uninsured for Health Care	Uninsured for health care checkbox on the Personal tab of Setup > Employees	Yes/no	[Employee.ReportingTypes.UninsuredforHealthCare]

State Withholding

Note: Because of the varying tax law from state to state, not all of the below variables will be applicable to you. For example, not all states have the "Basic Allowances" field on the Payroll Taxes tab of Setup > Employees, therefore using that variable on a report may result in the report previewing as "This report contains no data"

Variable name	Data content/source	Format	Variable syntax
Additional Allowances	The additional allowances field on the Payroll Taxes tab of Setup > Employees	Number	[Employee.StateWithholding.AdditionalAllowances]
Additional Amount	The additional withholding amount from the Payroll Taxes tab on Setup > Employees	Amount	[Employee.StateWithholding.AdditionalAmount]
Additional Amount Type	The additional amount type from the Payroll Taxes tab on Setup > Employees	Text	[Employee.StateWithholding.AddtionalAmountType]
Basic Allowances	The basic allowances field from the Payroll Taxes tab on Setup > Employees	Number	[Employee.StateWithholding.BasicAllowances]
Dependent Allowances	The dependent allowances field from the Payroll Taxes tab on Setup > Employees	Number	[Employee.StateWithholding.DependentAllowances]
Dependent Exemptions	The dependent exemptions field from the Payroll Taxes tab on Setup > Employees	Number	[Employee.StateWithholding.DependentExemptions]
Dependents	The number of dependents from the Payroll Taxes tab on Setup > Employees	Number	[Employee.StateWithholding.Dependents]
Filing Status	The state filing status from the Payroll Taxes tab on Setup > Employees	Text	[Employee.StateWithholding.FilingStatus]
Full Time Student	Full time student checkbox on the Payroll Taxes tab of Setup > Employees	Yes/no	[Employee.StateWithholding.FullTimeStudent]
Gross Taxable Wages	The calculated amount of the state gross taxable wages from the Adjust Taxable Wages dialog on the Payroll Taxes tab of Setup > Employees	Amount	[Employee.StateWithholding.GrossTaxableWages]
Head of Household	Head of Household checkbox on the Payroll Taxes tab of Setup > Employees	Yes/no	[Employee.StateWithholding.HeadofHousehold]
Low Income Tax Rates	Low income tax rates checkbox on the Payroll Taxes tab of Setup > Employees	Yes/no	[Employee.StateWithholding.LowIncomeTaxRates]
Nonresident Exemption Certificate	Nonresident Exemption certificate checkbox on the Payroll Taxes tab of Setup > Employees	Yes/no	[Employee.StateWithholding.NonresidentExemptionCertificate]
Personal Allowances	The number of personal allowances from the Payroll Taxes tab on Setup > Employees	Number	[Employee.StateWithholding.PersonalAllowances]
Personal Blindness	Personal blindness checkbox on the Payroll Taxes tab of Setup > Employees	Yes/no	[Employee.StateWithholding.PersonalBlindness]
Personal Exemptions	The number of personal exemptions from the Payroll Taxes tab on Setup > Employees	Number	[Employee.StateWithholding.PersonalExemptions]
Rate Table	The rate table selection for the employee from the Payroll Taxes tab of Setup > Employees (New Jersey only)	Text	[Employee.StateWithholding.RateTable]
Regular Allowances	The number of regular allowances from the Payroll Taxes tab on Setup > Employees	Number	[Employee.StateWithholding.RegularAllowances]
Spouse Blindness	Spouse blindness checkbox on the Payroll Taxes tab of Setup > Employees	Yes/no	[Employee.StateWithholding.SpouseBlindness]
Spouse Employed	Spouse employed checkbox on the Payroll Taxes tab of Setup > Employees	Yes/no	[Employee.StateWithholding.SpouseEmployed]
State (abbreviation)	The state abbreviation of the withholding state from the Payroll Taxes tab on Setup > Employees	Text	[Employee.StateWithholding.State]
State (full name)	The state name of the withholding state from the Payroll Taxes tab on Setup > Employees	Text	[Employee.StateWithholding.StateName]
State Withholding List	Outputs a list of the fields and values in the State Withholding section on the Payroll Taxes tab of Setup > Employees	Text	[Employee.StateWithholding.StateWHList]
Tax Exempt	Tax Exempt checkbox on the Payroll Taxes tab of Setup > Employees	Yes/no	[Employee.StateWithholding.TaxExempt]
Total Allowances	The number of total allowances from the Payroll Taxes tab on Setup > Employees	Number	[Employee.StateWithholding.TotalAllowances]
Total Dependents	The total number of dependents from the Payroll Taxes tab on Setup > Employees	Number	[Employee.StateWithholding.TotalDependents]
Total Exemption Amount	The total exemption amount calculated fro the Payroll Taxes tab of Setup > Employees	Amount	[Employee.StateWithholding.TotalExemptionAmount]
Two Earner Percent	Two Earner Percent checkbox on the Payroll Taxes tab of Setup > Employees	Yes/no	[Employee.StateWithholding.TwoEarnerPercent]
Withholding Code	The state withholding code selection from the Payroll Taxes tab of Setup > Employees	Text	[Employee.StateWithholding.WithholdingCode]

System

Variable name	Data content/source	Format	Variable syntax
Added Date	The date that the employee record was added to the system	Date	[Employee.System.AddedDate]

Taxes

Variable name	Data content/source	Format	Variable syntax
Federal Description	The description of the federal taxes from the grid on the Payroll Taxes tab of Setup > Employees	Text	[Employee.Taxes.Federal.Description]
Federal GL Expense Account Number	The federal tax GL expense account number from the grid on the Payroll Taxes tab of Setup > Employees	Text	[Employee.Taxes.Federal.GLExpenseAccount]
Federal GL Expense Account Description	The federal tax GL expense account description from the grid on the Payroll Taxes tab of Setup > Employees	Text	[Employee.Taxes.Federal.GLExpenseAccountDescription]
Federal GL Liability Account Number	The federal tax GL liability account number from the grid on the Payroll Taxes tab of Setup > Employees	Number	[Employee.Taxes.Federal.GLLiabilityAccount]
Federal GL Liability Account Description	The federal tax GL liability account description from the grid on the Payroll Taxes tab of Setup > Employees	Text	[Employee.Taxes.Federal.GLLiabilityAccountDescription]
Federal Tax Type	The type of federal tax (ER or EE) from the grid on the Payroll Taxes tab of Setup > Employees	Text	[Employee.Taxes.Federal.Type]
Federal Tax Wage Exempt	Wage Exempt checkbox in the taxes grid on the Payroll Taxes tab of Setup > Employees	Yes/no	[Employee.Taxes.Federal.WageExempt]
Federal Tax Distribution Department	The distribution department for the federal taxes on the Tax Item Settings dialog on the Payroll Taxes tab of Setup > Employees	Text	[Employee.Taxes.Federal.Details.LocationandDepartmentDistributions.Department]
Federal Tax Distribution GL Expense Account Number	The distribution GL expense account number from the Tax Item Settings dialog on the Payroll Taxes tab of Setup > Employees	Text	[Employee.Taxes.Federal.Details.LocationandDepartmentDistributions.GLExpenseAccount]
Federal Tax Distribution GL Expense Account Description	The distribution GL expense account description from the Tax Item Settings dialog on the Payroll Taxes tab of Setup > Employees	Text	[Employee.Taxes.Federal.Details.LocationandDepartmentDistributions.GLExpenseAccountDescription]
Federal Tax Distribution GL Liability Account Number	The distribution GL liability account number from the Tax Item Settings dialog on the Payroll Taxes tab of Setup > Employees	Text	[Employee.Taxes.Federal.Details.LocationandDepartmentDistributions.GLLiabilityAccount]
Federal Tax Distribution GL Liability Account Description	The distribution GL liability account description from the Tax Item Settings dialog on the Payroll Taxes tab of Setup > Employees	Text	[Employee.Taxes.Federal.Details.LocationandDepartmentDistributions.GLLiabilityAccountDescription]
Distribution Location	The distribution location from the Tax Item Settings dialog on the Payroll Taxes tab of Setup > Employees	Text	[Employee.Taxes.Federal.Details.LocationandDepartmentDistributions.Location]
State/Local Description	The description of the state and local taxes from the grid on the Payroll Taxes tab of Setup > Employees	Text	[Employee.Taxes.StateandLocal.Description]
State/Local GL Expense Account Number	The GL expense account number for the state/local taxes from the grid on the Payroll Taxes tab of Setup > Employees	Text	[Employee.Taxes.StateandLocal.GLExpenseAccount]
State/Local GL Expense Account Description	The GL expense account description for the state/local taxes from the grid on the Payroll Taxes tab on Setup > Employees	Text	[Employee.Taxes.StateandLocal.GLExpenseAccountDescription]
State/Local GL Liability Account Number	The GL liability account number for the state/local taxes from the grid on the Payroll Taxes tab on Setup > Employees	Number	[Employee.Taxes.StateandLocal.GLLiabilityAccount]
State/Local GL Liability Account Description	The GL liability account description for the state/local taxes from the grid on the Payroll Taxes tab from Setup > Employees	Text	[Employee.Taxes.StateandLocal.GLLiabilityAccountDescription]
State/Local Tax State (abbreviation)	The state abbreviation for the state/local taxes from the grid on the Payroll Taxes tab of Setup > Employees	Text	[Employee.Taxes.StateandLocal.State]
State/Local Tax State (full name)	The state name for the state/local taxes from the grid on the Payroll Taxes tab of Setup > Employees	Text	[Employee.Taxes.StateandLocal.StateName]
State/Local Tax Type	The state or local tax type (ER or EE) from the grid on the Payroll Taxes tab on Setup > Employees	Text	[Employee.Taxes.StateandLocal.Type]
State/Local Tax Wage Exempt	Wage exempt checkbox on the grid on the Payroll Taxes tab of Setup > Employees	Yes/no	[Employee.Taxes.StateandLocal.WageExempt]
State/Local Distribution Department	The distribution department for the state/local taxes from the Tax Item Settings dialog on the Payroll Taxes tab of Setup > Employees	Text	[Employee.Taxes.StateandLocal.Details.LocationandDepartmentDistributions.Department]
State/Local Distribution GL Expense Account Number	The state/local distribution GL expense account number from the Tax Item Settings dialog on the Payroll Taxes tab of Setup > Employees	Text	[Employee.Taxes.StateandLocal.Details.LocationandDepartmentDistributions.GLExpenseAccount]
State/Local Distribution GL Expense Account Description	The state/local distribution GL expense account description from the Tax Item Settings dialog on the Payroll Taxes tab of Setup > Employees	Text	]Employee.Taxes.StateandLocal.Details.LocationandDepartmentDistributions.GLExpenseAccountDescription]
State/Local Distribution GL Liability Account	The state/local distribution GL liability account number from the Tax Item Settings dialog on the Payroll Taxes tab of Setup > Employees	Text	[Employee.Taxes.StateandLocal.Details.LocationandDepartmentDistributions.GLLiabilityAccount]
State/Local Distribution GL Liability Account Description	The state/local distribution GL liability account description from the Tax Item Settings dialog on the Payroll taxes tab of Setup > Employees	Text	[Employee.Taxes.StateandLocal.Details.LocationandDepartmentDistributions.GLLiabilityAccountDescription]
State/Local Distribution Location	The state/local distribution location from the Tax Item Settings dialog on the Payroll Taxes tab of Setup > Employees	Text	[Employee.Taxes.StateandLocal.Details.LocationandDepartmentDistributions.Location]

W-2 Information

Variable name	Data content/source	Format	Variable syntax
Retirement Plan	Retirement plan checkbox on the Personal tab of Setup > Employees	Yes/no	[Employee.W2Information.RetirementPlan]
Statutory	Statutory checkbox on the Personal tab of Setup > Employees	Yes/no	[Employee.W2Information.Statutory]

Workers' Compensation

Variable name	Data content/source	Format	Variable syntax
Code	The workers' compensation code from the Workers' Compensation tab on Setup > Employees	Number	[Employee.WorkersCompensation.Code]
WC Code Description	The workers' compensation code description from the Workers' Compensation tab on Setup > Employees	Text	[Employee.WorkersCompensation.CodeDescription]
WC Exempt	Exempt checkbox on the Workers' Compensation tab of Setup > Employees	Yes/no	[Employee.WorkersCompensation.Exempt]
WC GL Expense Account Number	The workers' compensation GL expense account number from the Workers' Compensation tab on Setup > Employees	Text	[Employee.WorkersCompensation.GLExpenseAccount]
WC GL Expense Account Description	The workers' compensation GL expense account description from the Workers' Compensation tab on Setup > Employees	Text	[Employee.WorkersCompensation.GLExpenseAccountDescription]
WC GL Liability Account Number	The workers' compensation GL liability account number from the Workers' Compensation tab on Setup > Employees	Number	[Employee.WorkersCompensation.GLLiabilityAccount]
WC GL Liability Account Description	The workers' compensation GL liability account description from the Workers' Compensation tab on Setup > Employees	Text	[Employee.WorkersCompensation.GLLiabilityAccountDescription]
WC State (abbreviation)	The workers' compensation state abbreviation from the Workers' Compensation tab on Setup > Employees	Text	[Employee.WorkersCompensation.State]
WC State (full name)	The workers' compensation state name from the Workers' Compensation tab on Setup > Employees	Text	[Employee.WorkersCompensation.StateName]
Distribution Department	The distribution department from the Workers' Compensation Detail dialog on Setup > Employees	Text	[Employee.WorkersCompensation.Details.LocationandDepartmentDistributions.Department]
Distribution GL Expense Account Number	The distribution GL expense account number from the Workers' Compensation Detail dialog on Setup > Employees	Text	[Employee.WorkersCompensation.Details.LocationandDepartmentDistributions.GLExpenseAccount]
Distribution GL Expense Account Description	The distribution GL expense account description from the Workers' Compensation Detail dialog on Setup > Employees	Text	[Employee.WorkersCompensation.Details.LocationandDepartmentDistributions.GLExpenseAccountDescription]
Distribution GL Liability Account Number	The distribution GL liability account number from the Workers' Compensation Detail dialog on Setup > Employees	Text	[Employee.WorkersCompensation.Details.LocationandDepartmentDistributions.GLLiabilityAccount]
Distribution GL Liability Account Description	The distribution GL liability account description from the Workers' Compensation Detail dialog on Setup > Employees	Text	[Employee.WorkersCompensation.Details.LocationandDepartmentDistributions.GLLiabilityAccountDescription]
Distribution Location	The distribution location from the Workers' Compensation Detail dialog on Setup > Employees	Text	[Employee.WorkersCompensation.Details.LocationandDepartmentDistributions.Location]

See also: Report Designer: Procedures

Was this article helpful?

Great! Can you tell us why? (optional)

Answered my question
Easy to find the article
Easy to understand

We're sorry. Can you tell us why? (optional)

Didn't answer my question
Wrong or missing information
Not what I expected
Hard to find the article
I prefer a video

Thank you for the feedback!

Get the most out of your Thomson Reuters Tax & Accounting products. Our continued learning packages will teach you how to better use the tools you already own, while earning CPE credit. Learn more.

Alerts and notices

Chat - Best option for simple questions
Call us at +1 800 968 0600. You might like to see our hours and menu options before calling

Categories

Related brands

Feature

Find the right solution for your unique needs

Categories

Related brands

Feature

Find the right solution for your unique needs

Categories

Related brands

Feature

Find the right solution for your unique needs

Browse by type

Browse by topic

Featured

COVID-19 Resources

Support & training

Community

Tax & accounting community

Shop by practice area

Shop by brand

Featured

Quickfinder bundles

CS Professional Suite®

Help & How-To Center

Report Designer: Employee variables

Tax and accounting regions

Sectors

Categories

Related brands

Feature

Find the right solution for your unique needs

Categories

Related brands

Feature

Find the right solution for your unique needs

Categories

Related brands

Feature

Find the right solution for your unique needs

CS Professional Suite®

Help & How-To Center

Report Designer: Employee variables