Standard AQ - ACA Companion Insurance Offers AQ

Report Description

This Report (Advanced Query) gives the details of ACA status and dates for Employees.  See which employees have been offered, accepted or declined coverage.  The Report will show the Enrollment, Declined and Start/End dates for their coverage.

Parameters

Parameter Name	Options	Description
Start Date
End Date
Date Type	OfferedDate, EnrollmentDate, DeclinationDate	Filter for Offered, Enrollment or Declination Dates
Employer		Filter for a specific Supplier or all of them
SSN end with
Show Dependents	Yes or No

Report Fields

Field Name	Description
EmployeeIDs	Employee's ID
BoldTalentIDs	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
AddressStreet	Street 1 from Employee’s Primary Address
AddressCity	City from Employee’s Primary Address
AddressStateOrProvinceCode	State from Employee’s Primary Address
AddressCountryCode	Country code from Employee’s Primary Address
AddressPostalCode	Zip code from Employee’s Primary Address
OnAssignment	Is currently on Assignment
LastCheckDate	Employee's last Check Date
MostRecentEligibilityStatusDeclaration
BenefitPackageName
OfferedByEmployerName	The name of the Supplier that offered ACA
OfferedByEmployerIdentificationNumber	FEIN of the Supplier that offered ACA
OfferedDate	The Date the ACA offer was made
HealthInsurancePlanName
HealthInsurancePlanProviderName
AcaOfferOfCoverageCode	ACA Offer Code
SafeHarborCode
IsSelfInsured
IncludesSpouse
IncludesDependents
IsMinimumEssentialCoverage
IsMinimumValue
EnrollmentDate	Date employee enrolled in coverage
CoverageStartDate	Date when coverage starts
CoverageEndDate	Date when coverage ends
DeclinationStartDate	Date employee declined coverage
DeclinationEndDate	Date when Decline Coverage ends
DeclinationReason	The reason listed for declining coverage