CheckCOBRAEligible

Check COBRA Eligible

Minor Business Rule

Object Name: N0800064

Parent DLL: CHRM

Location: Client/Server

Language: NER

Functional Description

Purpose
This named ER will check to see if an employee is COBRA-eligible.  Returns "1" if it is a US Employee
enrolled in a COBRA plan as of the Termination Date.  Returns a "0" if the employee is not a US
employee, and/or if the employee is not enrolled in a COBRA plan as of the Termination Date

Setup Notes and Prerequisites

Source Data Structure

Data Item Data Structure DescriptionI/OReqNotes
AN8mnAddressNumberIyThe address book number of the employee.
DTjdDateTerminatedIyThe date that the employee was terminated.
EV01cReturnStatusOyThe flag that indicates if it is a US Employee enrolled in a COBRA plan as of
the Termination Date. (1= US Employee Enrolled in COBRA Plan, 0= Not a US Employee and/or the employee not enrolled in COBRA Plan).
DATE01jdCOBRADateON

Related Tables
Table Table Description F060116Employee Master Information F069106Union Benefits Master F069116Payroll Transaction Constants F08320Benefits
Plan Master F08330Employee Enrollment F08336Dep/Ben to Employee Plan X-Ref
Related Business Functions
N0800094     -  Create COBRA Letter

Special Logic

Technical Specification

1.0Move "0" to cReturnStatus.

1.1Fetch from F08336 to see if the address number passed is an dependent and retrieve
PlanId, Enrollment effective date, and enrollment end date.
1.2While the fetch is success

1.2.1Check to see if the enrollment was effective on the COBRA event date.

1.2.1.1If dependent is in a COBRA plan, check the related employee's enrollment

1.2.1.2Fetch from F060116 and retrieve the country code.
1.2.1.3If the country code is US, Fetch from F08330 and Select the enrollment
records for the employee
1.2.1.4While the fetch is success, Check to see if the enrollment was
effective on the COBRA Event date.
1.2.1.5Check to see if it was an active Enrollment
1.2.1.6If the enrollment is effective on the Termination Date and the plan is
flagged as a COBRA plan, then change the returned value to "1" (True).
1.2.1.7Get the End Date to pass back.

1.3Fetch from F08336 and retrieve the next plan.

1.4If the individual was not found as a dependent, search him as an employee.

1.4.1Fetch from F060116 and retrieve the country code.

1.4.2If the Country code is US, Fetch from F08330 and select the enrollment records for
the employee
1.4.3While the fetch is success, check to see if the enrollment was effective on the
COBRA event date.
1.4.4Check to see if it was an active enrollment
1.4.5If the enrollment is effective on the termination date and the plan is flagged as a
COBRA Plan, then change the retuned value to 1 (True).
1.4.6Get the end date to pass back.

1.5Fetch from F08330 to retrieve the next plan.

1.6Check for Group (Union) plans if a COBRA plan has not been found

1.6.1Select from F069106 - Union, Home BU, Job Type, Job Step

1.6.2

Data Structure

DN0800064 - Check COBRA Eligible

Data Item Data Structure DescriptionI/OReqNotes
AN8mnAddressNumberIyThe address book number of the employee.
DTjdDateTerminatedIyThe date that the employee was terminated.
EV01cReturnStatusOyThe flag that indicates if it is a US Employee enrolled in a COBRA plan as of the
Termination Date. (1= US Employee Enrolled in COBRA Plan, 0= Not a US Employee and/or the employee not enrolled in COBRA Plan).
DATE01jdCOBRADateON

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.

jdDateTerminated DT JDEDATE REQ INPUT

Data Item ab Data Structure Descriptionab I/Oab Reqab Notes
DTabab jdDateTerminatedabab Iab yabThe date that the employee was terminated.

cReturnStatus EV01 char REQ OUTPUT

Data Item ab Data Structure Descriptionab I/Oab Reqab Notes
EV01abab cReturnStatusabab Oab yabThe flag that indicates if it is a US Employee enrolled in a COBRA plan as of the Termination Date. (1= US
Employee Enrolled in COBRA Plan, 0= Not a US Employee and/or the employee not enrolled in COBRA Plan).

jdCOBRADate DATE01 JDEDATE OPT OUTPUT

Data Item ab Data Structure Descriptionab I/Oab Reqab Notes

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.
jdDateTerminated	DT	JDEDATE	REQ	INPUT
Data Item ab Data Structure Descriptionab I/Oab Reqab Notes DTabab jdDateTerminatedabab Iab yabThe date that the employee was terminated.
cReturnStatus	EV01	char	REQ	OUTPUT
Data Item ab Data Structure Descriptionab I/Oab Reqab Notes EV01abab cReturnStatusabab Oab yabThe flag that indicates if it is a US Employee enrolled in a COBRA plan as of the Termination Date. (1= US Employee Enrolled in COBRA Plan, 0= Not a US Employee and/or the employee not enrolled in COBRA Plan).
jdCOBRADate	DATE01	JDEDATE	OPT	OUTPUT
Data Item ab Data Structure Descriptionab I/Oab Reqab Notes