This page (revision-5) was last changed on 26-Nov-2021 10:22 by jmyers

This page was created on 26-Nov-2021 10:22 by jmyers

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
5 26-Nov-2021 10:22 4 KB jmyers to previous
4 26-Nov-2021 10:22 4 KB jmyers to previous | to last
3 26-Nov-2021 10:22 4 KB jmyers to previous | to last
2 26-Nov-2021 10:22 4 KB jmyers to previous | to last
1 26-Nov-2021 10:22 255 bytes jmyers to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 9 changed one line
The where clause above uses a derived column, DRV_APPROVAL_REQUIRED, to capture the plans (if any) within the open enrollment have the [IBPN] Approval Required lexicon set to Approval Required.
The where clause above uses a derived column, DRV_APPROVAL_REQUIRED, to capture the plans (if any) within the open enrollment that have the [IBPN] Approval Required lexicon set to 'Approval Required'.
At line 12 added one line
At line 29 changed one line
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 [IBPN] Approval Required lexicon set to 'Approval Required'.
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 that have the [IBPN] Approval Required lexicon set to 'Approval Required'.
At line 31 changed one line
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 [IBPN] Evidence Required toggle checked ON.
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 that have the [IBPN] Evidence Required toggle checked ON.
At line 39 changed one line
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 first line in the where clause above uses a derived column, DRV_APPROVAL_REQUIRED, to capture if plans (if any) within the open enrollment that have the [IBPN] Approval Required lexicon set to 'Approval Required'.
At line 52 changed one line
The where clause above uses a derived column, DRV_APPROVAL_REQUIRED, to capture plans (if any) within the open enrollment have the [IBPN] Approval Required lexicon set to 'Approval Required'.
The where clause above uses a derived column, DRV_APPROVAL_REQUIRED, to capture plans (if any) within the open enrollment that have the [IBPN] Approval Required lexicon set to 'Approval Required'.