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

mceclip0.png

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

mceclip0.png

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

 

 

Articles in this section

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

Comments

0 comments

Please sign in to leave a comment.