The following is an example of a more complex Open Enrollment approval process that involves multiple steps. 

The first step is defined for situations where approvals are required for coverages that require evidence to be submitted. This step involves a where clause to check if any coverage within the employee’s open enrollment have the Evidence Required toggle checked ON.

The second step is defined for situations where approvals are required for changes made to an enrollment. This step involves a where clause to filter open enrollments that include the “Elected, With Changes” elected decisions. 
The third step is the final approval and involves a where clause to filter the open enrollments for any plans that require approval. 

!Step 1: Approval for Evidence
[{Image src='OE EVIDENCE APPOVAL.JPG' width='575' link='attach/OE EVIDENCE APPOVAL.JPG'}]

[{Image src='OE EVID REQ WC.JPG' width='500' link='attach/OE EVID REQ WC.JPG'}]


The first line in the where clause above uses a derived column, DRV_APPROVAL_REQUIRED, to capture the plans (if any) within the open enrollment have the Approval Required lexicon in [IBPN] set to Approval Required. 

The second line in the above where clause uses the derived column, DRV_EVIDENCE_REQUIRED, to capture the coverages (if any) within the Open Enrollment have the Evidence Required toggle checked ON in [IBPN].

If one plan within the employee’s open enrollment meets the criteria of the where clause above, then the system will prompt the specified user with this approval step. 

If no plans in the employee’s open enrollment meet the criteria outlined above, then the approval process will call the next step. 

!Step 2: Approval with Changes Only

[{Image src='OE CHANGES ONLY APPROVAL.JPG' width='575' link='attach/OE CHANGES ONLY APPROVAL.JPG'}]

[{Image src='OE APR CHGS WC.JPG' width='500' link='attach/OE APR CHGS WC.JPG'}]

The first line in the where clause above uses a derived column, DRV_APPROVAL_REQUIRED, to capture if plans (if any) within the open enrollment have the Approval Required lexicon in [IBPN] set to Approval Required. 

The second line in the above where clause uses the derived column, DRV_ELECTED_WITH_CHANGES, to capture the benefit elections (if any) in the employee’s open enrollment have the “Elected, With Changes” election decision. This would mean that the employee has selected different plans and/or coverages in the open enrollment than what they are currently enrolled in.

If one election within the employee’s open enrollment meets the criteria of the where clause above, then the system will prompt the specified user with this approval step. 

If no elections in the employee’s open enrollment meet the criteria outlined above, then the approval process will call the next step. 

!Step 3: Final Approval

[{Image src='OE FINAL APPROVAL.JPG' width='575' link='attach/OE FINAL APPROVAL.JPG'}]

[{Image src='OE APR CHGS WC.JPG' width='500' link='attach/OE APR CHGS WC.JPG'}]