Evaluate Life Event
This formula type can be used to determine whether a life event should be evaluated or not. You could also alter the occurred date based on your use case using this formula.
Contexts
The following contexts are available to formulas of this type:
- BUSINESS_GROUP_ID ( ENTERPRISE_ID)
- EFFECTIVE_DATE
- HR_ASSIGNMENT_ID
- PERSON_ID
- ORGANIZATION_ID
- LER_ID
Database Items
Use only the following database items that are available to formulas of this type:
- All columns except attribute columns from tables: ben_ler_f
- Database items based on person’s assignment – HR_ASSIGNMENT_ID AND PERSON_ID
Input Variables
Input variables are available to formulas of this type.
Input | Data Type | Required | Description |
---|---|---|---|
BEN_PPL_IV_LF_EVT_OCRD_DT | Date |
Life event Occurred Date passed in format YYYY/MM/DD HH24:MI:SS |
|
BEN_PPL_IV_PTNL_LER_FOR_PER_STAT_CD | Char |
Potential Life event Status Code |
|
BEN_PPL_IV_NTFN_DT | Date |
Notified Date in format YYYY/MM/DD HH24:MI:SS |
|
BEN_PPL_IV_DTCTD_DT | Date |
Detected Date in format YYYY/MM/DD HH24:MI:SS |
Return Variables
Use predefined names for return variables. The following return variables are available to formulas of this type.
Return Value | Data Type | Required | Description |
---|---|---|---|
LIFE_EVENT_OCCURRED_DATE | Date | N | Replaces the original life event occurred date. Format of return value YYYY/MM/DD HH24:MIS:SS |
LIFE_EVENT_HAPPENED | Char | Y | Y or N. If any other value is assigned to this variable, the process raises an error BEN_92143_LIFE_EVENT_HAPPENED |
LIFE_EVENT_NOTIFICATION_DATE | Date | N | Notification date |
LIFE_EVENT_VOIDED_DATE | Date | N | Voided date |
LIFE_EVENT_MANUAL_DATE | Date | N | Manual date |
LIFE_EVENT_STATUS_CODE | Char | N | Status of the life event |
LIFE_EVENT_DETECTED_DATE | Date | N | Detected date |
Errors
If any other output value is returned then the participation process errors with BEN_91329_FORMULA_RETURN.
Sample Formula 1:
FORMULA NAME: BEN_EVAL_EVENT
FORMULA TYPE: Evaluate Life Event
DESCRIPTION: If a life event is notified after 30 days ignore this potential life event.
Inputs are BEN_PPL_IV_LF_EVT_OCRD_DT (TEXT),BEN_PPL_IV_PTNL_LER_FOR_STAT_CD (TEXT),BEN_PPL_IV_NTFN_DT (TEXT)
default for BEN_PPL_IV_PTNL_LER_FOR_STAT_CD is 'aaa' default for BEN_PPL_IV_NTFN_DT is '1951/01/01 00:00:00'
default for BEN_PPL_IV_LF_EVT_OCRD_DT is '1951/01/01 00:00:00'
life_event_happened = 'Y'
l_lf_evt_dt = to_date(BEN_PPL_IV_LF_EVT_OCRD_DT, 'YYYY/MM/DD HH24:MI:SS') l_ntfd_dt = to_date(BEN_PPL_IV_NTFN_DT, 'YYYY/MM/DD HH24:MI:SS') l_stat_cd = BEN_PPL_IV_PTNL_LER_FOR_STAT_CD l_lf_evt_dt_30 = add_days(l_lf_evt_dt, 30)
if ((l_ntfd_dt > l_lf_evt_dt_30) and l_stat_cd = 'DTCTD' )
then life_event_happened = 'N'
return life_event_happened
Sample Formula 2:
FORMULA NAME: BEN_EVAL_EVENT2
FORMULA TYPE: Evaluate Life Event
DESCRIPTION: If a life event is notified after 90 days for a set of people, ignore them.
Inputs are BEN_PPL_IV_LF_EVT_OCRD_DT (TEXT),
BEN_PPL_IV_PTNL_LER_FOR_PER_STAT_CD (TEXT),
BEN_PPL_IV_NTFN_DT (TEXT)
default for BEN_PPL_IV_PTNL_LER_FOR_PER_STAT_CD is 'AA
‘ default for BEN_PPL_IV_NTFN_DT is '01-JAN-1951' default for
PER_ASG_BARGAINING_UNIT_CODE is ‘XYZ’
l_lf_evt_dt = to_date(BEN_PPL_IV_LF_EVT_OCRD_DT, 'YYYY/MM/DD HH24:MI:SS') l_ntfd_dt = to_date(BEN_PPL_IV_NTFN_DT, 'YYYY/MM/DD HH24:MI:SS') l_stat_cd = BEN_PPL_IV_PTNL_LER_FOR_PER_STAT_CD l_bar_unit = PER_ASG_BARGAINING_UNIT_CODE
l_lf_evt_dt_90 = add_days(l_lf_evt_dt, 90)
if ((l_ntfd_dt > l_lf_evt_dt_90) and l_stat_cd = ‘DTCTD’
and ( l_bar_unit = ‘Sales Unit’ or l_bar_unit = ‘Support Unit’ )) then
(life_event_happened = 'N')
else
(life_event_happened = 'Y')
return life_event_happened
Sample Formula 3:
FORMULA TYPE : Evaluate Life Event
DESCRIPTION: Trigger a different life event when processing length of service.
LIFE_EVENT_REASON_ID=0
LIFE_EVENT_HAPPENED='Y'
l_new_ler_id = 100010026711792
LIFE_EVENT_REASON_ID=l_new_ler_id
/* Return Six Months Complete Life Event instead */
return LIFE_EVENT_REASON_ID,LIFE_EVENT_HAPPENED