Standard AQ - ACA Census

Overview

Updated 12/07/2022

• Click here for information on Advanced Queries
• Click here for information on Standard Reports

Report Description
Parameters
Fields

Report Description

This Report (Advanced Query) gives the details of ACA deductions and eligibility for Employee. The user can view the report at the Employee level.

Parameters

Parameter Name	Options	Description
Branch (Transaction)	All available branches
Start Week Worked
End Week Worked
HealthCare Code*	All options from 'Is Healthcare' being checked on Transaction Type	If a Transaction Type has the checkbox checked ON for 'Is HealthCare'; it will display
Show Summary	True / False

* 'Is Healthcare' checkbox

Fields

Field Name	Description
EmployeeID	Employee ID from Employee
BoldTalentID	Employee's ID in AvionteBOLD
FirstName	Employee's First Name
MiddleName	Employee's Middle Name
LastName	Employee's Last Name
SSN	Employee's Social Security Number
EmployeeStatus	Employee's Status
EmployeeBranch	Employee's Branch
BirthDate	Employee’s Date of Birth
MaritalStatus	Employee's marital status (Single, Married)
OriginalHireDate	First Assignment Start Date for Employee
RecentHireDate	Latest Assignment Start Date for Employee
FirstCheckDate	First paycheck Check Date for Employee
RecentCheckDate	Latest paycheck Check Date for Employee
EffectiveInsuranceDate
AssignmentMaxEndDate
Street1	Street 1 from Employee’s Primary Address
Street2	Street 2 from Employee’s Primary Address
City	City from Employee’s Primary Address
State	State from Employee’s Primary Address
Zipcode	Zip code from Employee’s Primary Address
Country	Country from Employee’s Primary Address
Gender	Employee's Gender
PrimaryContactMethod
EmployeeCellPhone	Employee’s Cell Phone number
EmployeeEmail	Employee’s Email
TotalWages	Total Wages from the Employee’s PayCheck in date range
TotalHours	Total Hours from the Employee’s PayCheck in date range. Salary Hours is included by Multiplying it with Hourly equivalent Multiplier based on the Pay Period.
DeductionAmount	Column header is shown as [Ded – Deduction Pay code - Amount]
BenefitAmount
IsACAEligible
CurrentStabilityPeriodEndDate
MeasurementStartDate
MeasurementEndDate
MeasuredType
MeasurementTotalHours
MeasuredEligibility
ReasonForDeactivation
OnAssignment

Back to Top