Overview
Updated 07/16/2021
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
Report 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 |
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 |
Comments
0 comments
Please sign in to leave a comment.