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='550' link='attach/OE EVIDENCE APPOVAL.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.