Life Event Reason Timeliness

Contexts

The following contexts are available to formulas of this type:

BUSINESS_GROUP_ID ( ENTERPRISE_ID)
EFFECTIVE_DATE
HR_ASSIGNMENT_ID
PERSON_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 not available to formulas of this type.

Return Variables

Use predefined names for return variables. The following return variables are available to formulas of this type.

Return variables table

Return Value	Data Type	Required	Description
L_LIFEEVENT_VOIDED	Char	Y	Returns Y or N

Errors

If any other output value is returned then the participation process errors with BEN_91329_FORMULA_RETURN.

Sample Formula 1:

FORMULA NAME: BEN_LF_EVT_TMLNS

FORMULA TYPE: Life Event Timeliness

DESCRIPTION: The formula voids specific events where notified date is more than 30 days after event occurred date.

DEFAULT for BEN_LER_NAME is 'xyz '
DEFAULT for BEN_PIL_LF_EVT_OCRD_DT is '01-JAN-1951' (date)
DEFAULT for BEN_PIL_NTFN_DT is '01-JAN-1951' (date)
l_event_name = BEN_LER_NAME
L_LIFEEVENT_VOIDED = ‘N’
if ( l_event_name = 'Age Changed' or l_event_name = 'Address Changed' ) and ( add_days(BEN_PIL_LF_EVT_OCRD_DT,30) < BEN_PIL_NTFN_DT ) then
(L_LIFEEVENT_VOIDED = 'Y' )
return L_LIFEEVENT_VOIDED

Sample Formula 2:

FORMULA NAME: BEN_LF_EVT_TMLNS2

FORMULA TYPE: Life Event Timeliness

DESCRIPTION: The formula voids all events where notified date is more than 90 days after event occurred date. This is to avoid back out of future dated processed events.

DEFAULT for BEN_PPL_LF_EVT_OCRD_DT is '1951/01/01 00:00:00'(date)
DEFAULT for BEN_PPL_NTFN_DT is '1951/01/01 00:00:00'(date)
L_LIFEEVENT_VOIDED = 'N'
if ( add_days(BEN_PPL_LF_EVT_OCRD_DT,90) < BEN_PPL_NTFN_DT )
then
(L_LIFEEVENT_VOIDED = 'Y' )
return L_LIFEEVENT_VOIDED