Standard AQ - Employee Benefit

Report Description

Displays details of benefits enrollment for each employee.

Parameters

Parameter Name	Options	Description
Branch (Employee)	All available branches	Branch of Employee
Date Type	Accounting Period Date, Check Date	Paycheck’s date
Start Date	Date Entered
End Date	Date Entered
Deduction / Benefit List	All available deduction list like Mileage, 401k etc.

Report Fields

Field Name	Description
EmployeeBranch	Employee’s Branch
EmployeeID	Employee’s ID
BoldTalentID	Employee’s ID from front office (BOLD)
FirstName	Employee’s First name
MiddleName	Employee’s Middle Name
LastName	Employee’s Last Name
SSN	Employee’s SSN
EmployeeStatus	Employee’s Status value like Active, Applicant etc.
BirthDate	Employee’s date of birth
OriginalHireDate	Employee’s original hire date. The date value is receives from the employee first assignment date
RecentHireDate	Employee’s Recent hire date. The date value is receives from the employee latest assignment date
FirstCheckDate	Employee’s First Check Date. The date value is receives from the employee first check date
Street1	Employee’s Primary Address Street 1
Street2	Employee’s Primary Address Street 2
City	Employee’s Primary Address City
State	Employee’s Primary Address State
Zipcode	Employee’s Primary Address Zip Code
Country	Employee’s Primary Address Country Code
Gender	Employee’s Gender
TotalHours	Total pay hours employee worked. Calculated by sum of total pay hours plus  multiplication of pay unit and multiplication factor (sum total pay hours + pay unit* multiplication factor)
TotalWages	Total gross wages for the employee
DeductionAmount	Total payment check deduction amount for the list of deduction. The deduction list is selected from the parameter Deduction / Benefit List
YTDDeductionAmount	Total payment check deduction amount for the list of deduction for the checks of check date year selected on parameter EndDate and check date less than parameter EndDate. The deduction list is selected from the parameter Deduction / Benefit List
LTDDeductionAmount	Total payment check deduction amount for the list of deduction for the checks of check date less than parameter EndDate. The deduction list is selected from the parameter Deduction / Benefit List
IsACAEligible	Employee’s ACA Eligibility. Possible values are Yes/No/ Undetermined
CurrentStabilityPeriodEndDate	Employee’s ACA Stability End Date value
BenefitPlanName	Employee’s Benefit Plan Name value
BenefitPlanType	Employee’s Benefit Plan Type