ValidateSubsequentEventsF089101

Validate Subsequent Events(F089101)

Minor Business Rule

Object Name: N0800399

Parent DLL: CHRM

Location: Client/Server

Language: NER

1.Functional Description

1.1Purpose

This function is used to determine whether a subsequent qualified event needs to be written.  The determining factors are whether the employee is in a
valid COBRA plan, and they have an existing and current qualified event written to the F08920 table.  Then, if the coverage period of the new qualified
event exceeds the coverage period of the previous qualified event, a subsequent qualified event would be written to the F089101 table with the additional
coverage period indicated.

1.2Setup Notes and Prerequisites

Source Data Structure

Data Item Data Structure DescriptionI/OReqNotes
ACTNcActionCode2IyThe flag which indicates how the report is run. (
0=Proof mode, 1=Update Mode)
AN8mnAddressNumberIyThe address book number of the employee.
QE1szQualifyingEvent1IYEvent that qualified a participant for COBRA
coverage.
QD1jdQualifyingEventDate1IYThe date that qualifying event took place.
CVPmnCoveragePeriodIyThe number of months of coverage.
QE2szQualifyingEvent2IyThe subsequent qualifyinf Event.
QD2jdQualifyingEventDate2IyThe date of Subsequent qualifying event.
AN82mnRelatedEmployeeIyThe address book number of the dependent.
EV01cReturnCodeOnThe flag which indicates if the person
qualifies for subsequent event and if the F089101 record will be written or not.
(0=Does no Qualify for SE, 1= Qualifies for SE - There is no record in F089101-write record,  2 =
Qualifies for SE,record exists in F089101, Proof mode, do not write record, 3 = Qualifies for SE,record
exist in F089101,new coverage, 4 = Qualifies, no rec. in F089101, Proof mode, no write)

Related Tables
Table Table Description F08920COBRA Coverage F089101COBRA Subsequent Qualifying Event
Related Business Functions
NONE

Special Logic

Technical Specifications

1.0Fetch the employee information. That is fetch for the employee home Company, Cost Center, and Tax area.
2.0Retrieve COBRA constants
3.0Fetch from F08920 and retrieve the date ending effective
4.0Get Audit Information
5.0Determine the new coverage period. If the SendCOBRALetter flag is blank or null, then new coverage period is equal to the dependent
coverage period.

5.1Else if the Handicapped flag is set to y, then new coverage period is equal to the disabled coverage period.

5.2Else new coverage period is equal to the regular coverage period.

6.0Determine if the new coverage period is greater than old coverage period

6.1Fetch from F089101 for the next subsequent qualifying event

6.1.1Determine the difference between new coverage period and the old coverage period.

6.1.2If the difference is greater than zero and action code is update, then write the subsequent qualifying event
6.1.3Move BF cReturn Code to 3. That means Qualifies for SE,record exist in F089101,new coverage.
6.1.4Else move BF cReturnCode to 2. That means Qualifies for SE,record exists in F089101, Proof mode, do not write record.

6.2If this is the only subsequent qualifying event, see if the action code is equal to 1

6.3Write the subsequent  qualifying event.
6.4Move BF cReturnCode to 1 . That means Qualifies for SE - no record in F089101-write record

7.0If the new coverage period is not greater than old coverage period

7.1   Move BF cReturnCode to 0. That means does not qualify for Subsequent event.

Data Structure

D0800399 - Validate Subsequent Events(F089101)

Data Item Data Structure DescriptionI/OReqNotes
ACTNcActionCode2IyThe flag which indicates how the report is run. (
0=Proof mode, 1=Update Mode)
AN8mnAddressNumberIyThe address book number of the employee.
QE1szQualifyingEvent1IYEvent that qualified a participant for COBRA
coverage.
QD1jdQualifyingEventDate1IYThe date that qualifying event took place.
CVPmnCoveragePeriodIyThe number of months of coverage.
QE2szQualifyingEvent2IyThe subsequent qualifyinf Event.
QD2jdQualifyingEventDate2IyThe date of Subsequent qualifying event.
AN82mnRelatedEmployeeIyThe address book number of the dependent.
EV01cReturnCodeOnThe flag which indicates if the person
qualifies for subsequent event and if the F089101 record will be written or not.
(0=Does no Qualify for SE, 1= Qualifies for SE - There is no record in F089101-write record,  2 =
Qualifies for SE,record exists in F089101, Proof mode, do not write record, 3 = Qualifies for SE,record
exist in F089101,new coverage, 4 = Qualifies, no rec. in F089101, Proof mode, no write)

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

mnAddressNumber AN8 MATH_NUMERIC REQ INPUT

Data Item ab Data Structure Descriptionab I/Oab Reqab Notes
AN8abab mnAddressNumberabab Iab yabThe address book number of the employee.

szQualifyingEvent1 QE1 char REQ INPUT

Data Item ab Data Structure Descriptionab I/Oab Reqab Notes
QE1abab szQualifyingEvent1abab Iab YabEvent that qualified a participant for COBRA coverage.

jdQualifyingEventDate1 QD1 JDEDATE REQ INPUT

Data Item ab Data Structure Descriptionab I/Oab Reqab Notes
QD1abab jdQualifyingEventDate1abab Iab YabThe date that qualifying event took place.

szQualifyingEvent2 QE2 char REQ INPUT

Data Item ab Data Structure Descriptionab I/Oab Reqab Notes
QE2abab szQualifyingEvent2ab Iab yabThe subsequent qualifyinf Event.

jdQualifyingEventDate2 QD2 JDEDATE REQ INPUT

Data Item ab Data Structure Descriptionab I/Oab Reqab Notes
QD2abab jdQualifyingEventDate2ab Iab yabThe date of Subsequent qualifying event.

cReturnCode EV01 char OPT OUTPUT

Data Item ab Data Structure Descriptionab I/Oab Reqab Notes
EV01abab cReturnCodeabababab Oab nabThe flag which indicates if the person qualifies for subsequent
event and if the F089101 record will be written or not.
(0=Does no Qualify for SE, 1= Qualifies for SE - There is no record in F089101-write record,  2 =
Qualifies for SE,record exists in F089101, Proof mode, do not write record, 3 = Qualifies for SE,record
exist in F089101,new coverage, 4 = Qualifies, no rec. in F089101, Proof mode, no write)

mnCoveragePeriod CVP MATH_NUMERIC REQ INPUT

Data Item ab Data Structure Descriptionab I/Oab Reqab Notes
CVPabab mnCoveragePeriodababab Iab yabThe number of months of coverage.

cActionCode2 ACTN char REQ INPUT

Data Item ab Data Structure Descriptionab I/Oab Reqab Notes
ACTNabab cActionCode2abab Iab yabThe flag which indicates how the report is run. ( 0=Proof mode,
1=Update Mode)

mnRelatedEmployee AN82 MATH_NUMERIC REQ INPUT

Data Item ab Data Structure Descriptionab I/Oab Reqab Notes
AN82abab mnRelatedEmployeeabab Iab yabThe address book number of the dependent.

Related Functions

None

Related Tables

None

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnAddressNumber	AN8	MATH_NUMERIC	REQ	INPUT
Data Item ab Data Structure Descriptionab I/Oab Reqab Notes AN8abab mnAddressNumberabab Iab yabThe address book number of the employee.
szQualifyingEvent1	QE1	char	REQ	INPUT
Data Item ab Data Structure Descriptionab I/Oab Reqab Notes QE1abab szQualifyingEvent1abab Iab YabEvent that qualified a participant for COBRA coverage.
jdQualifyingEventDate1	QD1	JDEDATE	REQ	INPUT
Data Item ab Data Structure Descriptionab I/Oab Reqab Notes QD1abab jdQualifyingEventDate1abab Iab YabThe date that qualifying event took place.
szQualifyingEvent2	QE2	char	REQ	INPUT
Data Item ab Data Structure Descriptionab I/Oab Reqab Notes QE2abab szQualifyingEvent2ab Iab yabThe subsequent qualifyinf Event.
jdQualifyingEventDate2	QD2	JDEDATE	REQ	INPUT
Data Item ab Data Structure Descriptionab I/Oab Reqab Notes QD2abab jdQualifyingEventDate2ab Iab yabThe date of Subsequent qualifying event.
cReturnCode	EV01	char	OPT	OUTPUT
Data Item ab Data Structure Descriptionab I/Oab Reqab Notes EV01abab cReturnCodeabababab Oab nabThe flag which indicates if the person qualifies for subsequent event and if the F089101 record will be written or not. (0=Does no Qualify for SE, 1= Qualifies for SE - There is no record in F089101-write record, 2 = Qualifies for SE,record exists in F089101, Proof mode, do not write record, 3 = Qualifies for SE,record exist in F089101,new coverage, 4 = Qualifies, no rec. in F089101, Proof mode, no write)
mnCoveragePeriod	CVP	MATH_NUMERIC	REQ	INPUT
Data Item ab Data Structure Descriptionab I/Oab Reqab Notes CVPabab mnCoveragePeriodababab Iab yabThe number of months of coverage.
cActionCode2	ACTN	char	REQ	INPUT
Data Item ab Data Structure Descriptionab I/Oab Reqab Notes ACTNabab cActionCode2abab Iab yabThe flag which indicates how the report is run. ( 0=Proof mode, 1=Update Mode)
mnRelatedEmployee	AN82	MATH_NUMERIC	REQ	INPUT
Data Item ab Data Structure Descriptionab I/Oab Reqab Notes AN82abab mnRelatedEmployeeabab Iab yabThe address book number of the dependent.