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 |
Comments
0 commentsPlease sign in to leave a comment.