VerifyCurrentCOBRACovF08920

Verify Current COBRA Coverage (F08920)

Minor Business Rule

Object Name: N0800382

Parent DLL: CHRM

Location: Client/Server

Language: NER

Functional Description

Purpose

The purpose of this business function is to search the F08920 with an address book and a qualified
event date. The function uses four criteria to determine whether the employee is already in a COBRA
plan and hence does or does not need to be written into the file.

Setup Notes and Prerequisites

Must pass in an an address book number and a qualified event date and the function
will return a status code of 1 (Write) or 0 (Do not write).

Special Logic

Searches - F08920 - uses 4 criteria search based on waive date, terminate date, COBRA plan ternminate
date, and date of election term.

Technical Specification

Data Item Data Structure DescriptionI/ORequiredNotes
AN8mnAddressNumberIYCOBRA Participant name
QD1jdQualifyingEventDate1IYThe date that qualifying event took place
EV01cReturnCodeON
QE1szQualifyingEvent1ONEvent that qualified a participant for
COBRA coverage
CVPmnCoveragePeriodONThe number of months that the qualified
beneficiary is entitled to COBRA coverage.
QD1jdQualifyingEventDate1_2ONSubsequent Qualifying Event

Related Tables
Table Table Description F08920COBRA Coverage
2.3Related Business Functions
NONE

2.4Processing

1.0Fetch F08920 to see if the QE exists, if so bring back dates for conditionals.
2.0If the QE does exist, set cReturnCode to 1 - i.e write record.
3.0If the fetch is success - do the following

3.1First Criteria - new QED is in the election period of another QE  - Do not write a record

3.1.1Check to see if the new Qualifying Event Date is greater than or equal to the old Qualifying event date

3.1.1.1Check to see if COBRA Termination date is equal to null date

3.1.1.1.1Check to see if COBRA waived date is equal to null date

3.1.1.1.2 Check to see if COBRA elected date is equal to null date
3.1.1.1.3 Check to see if the old QED is less than the date election  terminated. If so - set cReturnCode to 0 - i.e do
not write record.

3.2Second Criteria - New QED not in election period of another QED - no waive or terminte dates conflict  - Write record

3.2.1Check to see if the new QED is greater than or equal to old QED

3.2.1.1Check to see if the COBRA plan termination date or the date COBRA waived is greater that the old QED

3.2.1.1.1Check to see if the COBRA plan termination date or date COBRA waived is greater than the
elected date. If so write a record.

3.3Third Criteria - New QED is outside election period all waive/term/elect dates are null -- Write a record

3.3.1Check to see if the new QED is greater than the old QED

3.3.1.1Check to see if the COBRA plan termination date, Waived date and the election date is equal to null date

3.3.1.1.1Check to see if the new QED is greater than the election terminated date. If so write the recod

3.4Fourth Criteria - New QED greater than election date  but in the effective end date - Do not write a record

3.4.1Check to see if the new QED is greater than the old QED

3.4.1.1Check to see if the new QED is in the effective end date

3.4.1.1.1Check to see if the plan termination date and waived date is equal to null date. If so do not write a
record.

4.0Fetch the next QE and loop through.

Data Structure

D0800382 - Verify Current COBRA Coverage (F08920)

DataItem DescriptionI/ORequiredNotes
AN8mnAddressNumberIYCOBRA Participant name
QD1jdQualifyingEventDate1IYThe date that qualifying event took place
EV01cReturnCodeON
QE1szQualifyingEvent1ONEvent that qualified a participant for COBRA
coverage
CVPmnCoveragePeriodONThe number of months that the qualified
beneficiary is entitled to COBRA coverage.
QD1jdQualifyingEventDate1_2 ON        Subsequent Qualifying Event

Parameter Name Data Item Data Type Req/Opt I/O/Both

mnAddressNumber AN8 MATH_NUMERIC REQ INPUT

DataItem ab Descriptionababab I/Oab Requiredab Notes
AN8abab mnAddressNumberabab Iab YababCOBRA Participant name

jdQualifyingEventDate1 QD1 JDEDATE REQ INPUT

DataItem ab Descriptionababab I/Oab Requiredab Notes
QD1abab jdQualifyingEventDate1ab Iab YababThe date that qualifying event took place

cReturnCode EV01 char OPT OUTPUT

DataItem ab Descriptionababab I/Oab Requiredab Notes

szQualifyingEvent1 QE1 char OPT OUTPUT

DataItem ab Descriptionababab I/Oab Requiredab Notes
QE1abab szQualifyingEvent1ab Oab NababEvent that qualified a participant for COBRA coverage

mnCoveragePeriod CVP MATH_NUMERIC OPT OUTPUT

DataItem ab Descriptionababab I/Oab Requiredab Notes
CVPabab mnCoveragePeriodabab Oab Nabab The number of months that the qualified beneficiary is
entitled to COBRA coverage.

jdQualifyingEventDate1_2 QD1 JDEDATE OPT OUTPUT

DataItem ab Descriptionababab I/Oab Requiredab Notes
QD1abab jdQualifyingEventDate1_2 Oab N        Subsequent Qualifying Event

Related Functions

None

Related Tables

None