This page (revision-18) was last changed on 26-Nov-2021 10:22 by ihowie

This page was created on 26-Nov-2021 10:22 by rforbes

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
18 26-Nov-2021 10:22 3 KB ihowie to previous
17 26-Nov-2021 10:22 3 KB ihowie to previous | to last
16 26-Nov-2021 10:22 3 KB khiggs to previous | to last
15 26-Nov-2021 10:22 3 KB rforbes to previous | to last
14 26-Nov-2021 10:22 3 KB rforbes to previous | to last
13 26-Nov-2021 10:22 3 KB rforbes to previous | to last
12 26-Nov-2021 10:22 3 KB rforbes to previous | to last
11 26-Nov-2021 10:22 3 KB rforbes to previous | to last
10 26-Nov-2021 10:22 3 KB rforbes to previous | to last
9 26-Nov-2021 10:22 3 KB rforbes to previous | to last
8 26-Nov-2021 10:22 3 KB rforbes to previous | to last
7 26-Nov-2021 10:22 2 KB rforbes to previous | to last
6 26-Nov-2021 10:22 2 KB rforbes to previous | to last
5 26-Nov-2021 10:22 2 KB rforbes to previous | to last
4 26-Nov-2021 10:22 2 KB rforbes to previous | to last
3 26-Nov-2021 10:22 2 KB rforbes to previous | to last
2 26-Nov-2021 10:22 2 KB rforbes to previous | to last
1 26-Nov-2021 10:22 2 KB rforbes to last

Page References

Incoming links Outgoing links
P 2 K_PU.BEN
P2K_PU.BEN

Version management

Difference between version and

At line 4 changed one line
This function retrieves information as seen on IBEN, for an employee's benefit enrollment.
This function retrieves information as seen on [IBEN], for an employee's benefit enrollment.
At line 10 changed 3 lines
|WHAT | Identifies which element of the IBEN display you want to access. This must be one of the following:\\COVERAGE_CODE, COVERAGE_STEP_CODE, PLAN_REG_NUMBER, ENROLLMENT_STATUS, ELIGIBILITY_START_DATE, ELIGIBILITY_END_DATE, PREMIUM_START_DATE, PREMIUM_END_DATE\\You can also access Benefit Component values by specifying __BC-B''nnnn''__ where ''nnnn'' is the benefit component code
|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 | 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.
At line 14 added 10 lines
!WHAT Parameter Values
* Any field name from [P2K_BE_ENROLLMENT_DETAILS]
* {{__COVERAGE_CODE__}} - This will return the actual coverage code that the employee is enrolled in
* {{__BCG.''xxxxx''__}} - Any field name (the ''xxxxx'') from [P2K_BE_COVERAGES] for the coverage that the employee is enrolled in
* {{__BC-B''nnnn''__}} - This will return the [AMOUNT] or [AMOUNT_OVERRIDE] for the component value where ''nnnn'' is the benefit component code
* {{__RECIPIENT_COUNT__}} - Will Return the number of recipients by plan from IBRA/IBRP
* {{__RECIPIENT_COUNT_18__}} - Will Return the number of recipients by plan from IBRA/IBRP that are less than 18 years old
* {{__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.
At line 19 changed 6 lines
* 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.
* 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.
* If you are requesting ON_SCHEDULE, and there is an issue retrieving the employee assignment information {{NO ASSIGNMENT INFO}} is returned
* If you are requesting ON_SCHEDULE, and there is an issue retrieving the benefit schedule information {{*BAD SCHEDULE}} is returned
At line 37 changed one line
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 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.
At line 39 changed one line
If you want to retrieve records even if the employee is no longer enrolled in the plan, then set the FLAGS parameter to "N"
* If you want to retrieve records even if the employee is no longer enrolled in the plan, then set the FLAGS parameter to "N"
At line 53 added 12 lines
* Eligibility (for ON_SCHEDULE) is determined by:
** Plan is Not scheduled (on IBPN)
** Employee is specifically scheduled for this plan (IBSC)
** Employee’s Entity-Unit-Group (as of the AS_OF date) are scheduled for this plan (IBSC)
** Employee’s Entity-Unit (as of the AS_OF date) are scheduled for this plan (IBSC)
** Employee’s Entity (as of the AS_OF date) are scheduled for this plan (IBSC)
** All employees are scheduled for this plan (IBSC)
----
![Notes|Edit:Internal.P2K_PU.BEN]
[{InsertPage page='Internal.P2K_PU.BEN' default='Click to create a new notes page'}]
This page (revision-18) was last changed on 26-Nov-2021 10:22 by ihowieTop