Employee Dependent Verification Information Expired

The Employee Dependent Verification Information Expired report uses the Employee Benefit Elections - As of Date topic to show employees with the Expired dependent verification status.

Fields

Fields included in the report template

Field Name	Group by	Sort Order	Totals
Employee	Yes	A to Z
Dependent Name	Yes	A to Z
Verification Status	Yes	A to Z
Dependent Relationship
Dependent Birth Date
Due Date
Plan Option
Dep Option Effective Start
Dep Option Effective End
Comment
Status Timestamp

Custom Fields

Dependent Name

The Dependent Name field shows the dependent's name. It uses the following expression:

EmployeeDependentBeneficiary.FirstName + ' ' + EmployeeDependentBeneficiary.LastName

Verification Status

The Verification Status field shows the dependent's verification status. It uses the following expression:

case 
when BenDependentVerification.Status = 1 Then 'Pending'
when BenDependentVerification.Status = 2 Then 'Under Review' 
when BenDependentVerification.Status = 3 Then 'Inaccurate/Illegible'
when BenDependentVerification.Status = 4 Then 'Approved'
when BenDependentVerification.Status = 5 Then 'Denied'
when BenDependentVerification.Status = 6 Then 'Expired'
else
'Not Started'
end

Filters

The template includes the following filters: