Standard AQ - ACA Companion Census AQ

Report Description

This Report (Advanced Query) gives the details of Employee's Measurement, Eligibility and Offered Dates.

Parameters

Parameter Name	Options	Description
Start Date
End Date
Date Type	WorkPeriod, MeasurementPeriod, StabilityPeriod, WeekWorked, CheckDate
Employer
SSN end with
Show All Measurements	Yes or No
Exclude Non-W2 Employees	Yes or No

Report Fields

Field Name	Description
EmployeeID	Employee ID from Employee
BoldTalentID	Employee's ID in AvionteBOLD
SSN	Employee's Social Security Number
FirstName	Employee's First Name
MiddleName	Employee's Middle Name
LastName	Employee's Last Name
Branch	Employee's Branch
ACAEligibility
EmployeeStatus	Employee's Status
OnAssignment
LastCheckDate
DateOfBirth	Employee’s Date of Birth
Gender	Employee’s Gender
Phone	Employee’s Phone Number
Email	Employee’s Email
AddressStreet	Street 1 from Employee’s Primary Address
AddressCity	City from Employee’s Primary Address
AddressStateorProvinceCode	State from Employee’s Primary Address
AddressCountryCode	Country from Employee’s Primary Address
AddressPostalCode	Zip code from Employee’s Primary Address
EmployerName
EmployerIdentificationNumber
FirstWorkedDate
TerminatedDate
MeasurementType
MeasurementPeriodStartDate
MeasurementPeriodEndDate
MeasurementPeriodTotalHours
MeasurementEligibility
StabilityPeriodStartDate
StabilityPeriodEndDate
MostRecentEligibilityStatusDeclaration
MostRecentOffferedDate
MostRecentOfferedBenefitPackage
MostRecentOfferedStatus
Electronic1095C	Classic/Back Office: the Config Choice system name is Electronic1095C and the choice code is Electronic 1095-C for  Category, EmployeeInterview.  Integrated/BOLD: There are new fields on the Employee record in BOLD on the Tax tab.  The data will go there and then flow into back office in the employee interview question.  Electronic 1095-c