This is version 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 . It is not the current version, and thus it cannot be edited.

Back to current versionRestore this version

Benefit Enrollment Information#

Functionality:#

This function retrieves information as seen on IBEN, for an employee's benefit enrollment.

Parameters:#

EEM_ID	The actual ID for the employment record of the employee you are getting data for
PLAN_CODE	The plan code you are retrieving
WHAT	Identifies which element of the IBEN display you want to access. This must be one of the values as noted below.
AS_OF	This optional parameter provides a date frame to retrieve the data. If it is not provided, the current system date will be used.
FLAGS	This optional parameter controls aspects of the data retrieval. See below.

WHAT Parameter#

COVERAGE_CODE
COVERAGE_STEP_CODE
PLAN_REG_NUMBER
ENROLLMENT_STATUS
ELIGIBILITY_START_DATE

ELIGIBILITY_END_DATE

PREMIUM_START_DATE

PREMIUM_END_DATE

BC-Bnnnn

where nnnn is the benefit component code

Returns: #

Varchar2 (regardless of the type of data being requested)

Errors: #

• If the employee is not enrolled as of the date specified, and the FLAGS parameter is set to "Y" (default) then NULL is returned
• If an invalid PLAN_CODE parameter is passed, then NO SUCH PLAN is returned
• If no Enrollment record is found for that employee/plan combination, then NO ENROLLMENT is returned
• If no enrollment detail information is found as of the date specified (corrupt data), then NO BEN DETAIL is returned
• If a bad benefit component code is provided, then BAD BC CODE is returned
• If the BC Code provided does not appear in the enrollment record (plan definition), then NO BC CODE is returned
• If an invalid WHAT parameter is provided, then BAD WHAT is returned.

Example: #

P2K_PU.BEN(~,'VISION','ELIGIBILITY_START_DATE')

Will return the ELIGIBILITY_START_DATE for the employee's VISION plan enrollment record.

P2K_PU.BEN(~,'MED KAISER FLEX','BC-B1040')

Will return the deduction amount BC-B1040 for the employee's MED KAISER FLEX

Notes#

If a Benefit Component value is requested, the AMOUNT_OVERRIDE will be returned. If this field is zero or NULL, then the AMOUNT field will be returned.

If you want to retrieve records even if the employee is no longer enrolled in the plan, then set the FLAGS parameter to "N"