Rate Start Date

This formula type is used to derive the rate start date for the enrollment into the selected compensation object.

Contexts

The following contexts are available:

• BUSINESS_GROUP_ID ( ENTERPRISE_ID)
• EFFECTIVE_DATE
• HR_ASSIGNMENT_ID
• PGM_ID
• PL_ID
• PER_IN_LER_ID
• PERSON_ID
• LER_ID
• BENEFIT_RELATION_ID
• ELIG_PER_ELCTBL_CHC_ID

Database Items

Use only the following database items that are available to formulas of this type:

• 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

The following return variables are available to formulas of this type. Any name can be used for the return variable.

Return variables table

Out Variable Name	Data Type	Remarks
L_OUTPUT	Date	Calculated rate start date

Sample Formula 1:

FORMULA TYPE: Rate Start Date

DESCRIPTION: For (New Hire) rate starts first-of-month after the enrollment end.

DEFAULT for PER_ASG_REL_ORIGINAL_DATE_OF_HIRE is '1951/01/01 00:00:00'(date)
l_enrt_perd_end = '1951/01/01 00:00:00'(date)
l_rt_strt_dt = '1951/01/01 00:00:00'(date)
l_hire_dt=PER_ASG_REL_ORIGINAL_DATE_OF_HIRE
l_enrt_perd_end = LAST_DAY(ADD_MONTHS(l_hire_dt,1))
l_rt_strt_dt = ADD_DAYS(l_enrt_perd_end,1)
return l_rt_strt_dt

Sample Formula 2:

FORMULA TYPE: Rate Start Date

DEFAULT for PER_ASG_REL_ACTUAL_TERMINATION_DATE is '1951/01/01 00:00:00' (date)
l_strt_dt = '1951/01/01 00:00:00'(date)
l_fc_dt = '1951/01/01 00:00:00'(date)
l_term_dt = PER_ASG_REL_ACTUAL_TERMINATION_DATE
l_fc_dt = ADD_DAYS(LAST_DAY(ADD_MONTHS(l_term_dt,1)),1)
RETURN l_fc_dt