P 2 K_PU.BEN
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 Optional. Provides a date frame to retrieve the data. If it is not provided, the current system date will be used.
FLAGS Optional. If set to "N" will return values for un-enrolled records. Otherwise only Enrolled records are retrieved.

WHAT Parameter Values#

COVERAGE_CODE The actual coverage code that the employee is enrolled in
COVERAGE_STEP_CODE The coverage step code that the employee is enrolled in
PLAN_REG_NUMBER The plan registration number from the employee's enrollment record
ENROLLMENT_STATUS The saved value from the ENROLLMENT_STATUS
ELIGIBILITY_START_DATE The eligibility start date of the employee's enrollment
ELIGIBILITY_END_DATE The eligibility end date of the employee's enrollment
PREMIUM_START_DATE The premium start date of the employee's enrollment
PREMIUM_END_DATE The premium end date of the employee's enrollment
BC-Bnnnn Returns the AMOUNT or AMOUNT_OVERRIDE for the component value where nnnn is the benefit component code
ON_SCHEDULE If the employee indicated is eligible for the plan(according to IBSC schedule only) , you will get back “Y”. Otherwise you will get back “N”. See below for schedule eligibility steps.

Returns: #

Varchar2 (regardless of the type of data being requested)

Errors: #

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#


Notes#

Click to create a new notes page