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

mceclip0.png

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
mceclip2.png

 

 

Fields

mceclip1.pngmceclip6.png
mceclip7.png

 

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. 

 

Articles in this section

Was this article helpful?
0 out of 0 found this helpful
Share