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

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

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
2 26-Nov-2021 10:22 1 KB khiggs to previous
1 26-Nov-2021 10:22 1 KB khiggs to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 4 changed one line
The purpose of this function is to capture the [BBR_ID] from the [P2K_BE_RECIPIENTS] table. Given a specific benefit [PLAN_CODE] and an as of date determine if an contact is set up as a recipient in the specified plan.
The purpose of this function is to capture the [BBR_ID] from the [P2K_BE_BENEFIT_RECIPIENTS] table. Given a specific benefit [PLAN_CODE] and an as of date determine if an contact is set up as a recipient in the specified plan.
At line 6 changed one line
If they are then return the ID from the [P2K_BE_RECIPIENTS] table. If they are not, then null will be returned.
If they are then return the ID from the [P2K_BE_BENEFIT_RECIPIENTS] table. If they are not, then null will be returned.
At line 10 changed 3 lines
|LEAVE_TYPE |''Required''. Leave type code from [IAPT]
|AC_CODE |''Required''. AC_CODE as defined on [IAAC] (ie, A050, A700, A900, etc.)
|WHEN |''Optional''. The as of date to be used (DD-MON-YYYY). Only the 'MON' portion of the date will be used. This date will be converted to the last day of the month for the query (The month from the Sysdate will be used if left blank).
|PLAN_CODE |''Required''. Plan Code from [IBPN]
|AS_OF_DATE |''Optional''. The as of date to be used (DD-MON-YYYY) to qualify the record on the [P2K_BE_BENEFIT_RECIPIENTS] table. The Sysdate will be used if left blank.
At line 19 changed 4 lines
* When No Data is found than 0 will be returned
* When the provided [LEAVE_TYPE_CODE] is not found -99996 will be returned
* When the provided [AC_CODE] is not found -99997 will be returned
* When there is an un-trapped exception than -99999 will be returned
* If the recipient is not found then 0 is returned
* The contact ID cannot be found -1 is returned
* The plan cannot be found -2 is returned
* If too many recipient records are found then -3 is returned
* If no enrollments are found then -4 is returned
At line 26 changed one line
FUNCTION ALA_LAST(~,'VACATION','A700','01-Jan-2017')
FUNCTION GET_BBR(~,'MEDICAL','01-Jan-2017')
At line 28 changed one line
Using the EEM_ID as the ~ parameter, this will return the value from the last leave line to be processed in the month of January, linked to the leave type 'VACATION' and the AC_CODE A700.
Using the [ECT_ID] as the ~ parameter, this will return the [BBR_ID] associated to the contact if there is a record found on the [P2K_BE_BENEFIT_RECIPIENTS] table as of the date provided.
At line 30 removed one line
At line 32 removed 3 lines
* The [EEM_ID] will be used to check leave lines details for the value of the specified AC code for the leave type as of the listed date.
* Only leave lines without [TIME_CODE] will be picked up
* Only Leave lines with an [ACCRUAL_STATUS] not in 3-In Payroll, 1-Requested or 2-Requested Processed will be picked up