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

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#

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"


Notes#

Click to create a new notes page