Standard AQ - ACA Census

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	Employee’s Effective Insurance Date (If any)
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	Employee’s Primary Contact Method (For e.g., Phone, Fax, Email etc.)
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	Employee’s Deduction Amount
BenefitAmount	Employee’s Benefit Amount
IsACAEligible	Display if employee is aca eligible or not?
CurrentStabilityPeriodEndDate	End date of Current Stability Period
MeasurementStartDate	Start Date of the employee’s ACA Measurement
MeasurementEndDate	End Date of the employee’s ACA Measurement
MeasuredType	Employee Measurement Type (Initial or Standard)
MeasurementTotalHours	Employee’s ACA Measured Hours
MeasuredEligibility	Show whether the employee is full time or non-full time
ReasonForDeactivation	Reason for deactivation
OnAssignment	Shows if the employee is currently on an active assignment.