1. Administering Fast Formulas
  2. Enrollment Coverage Start Date

Enrollment Coverage Start Date

This formula type is used to derive the enrollment coverage start date.

Contexts

The following contexts are available:

  • BUSINESS_GROUP_ID ( ENTERPRISE_ID)
  • EFFECTIVE_DATE
  • HR_ASSIGNMENT_ID
  • PGM_ID
  • PL_ID
  • PL_TYP_ID
  • OPT_ID
  • PER_IN_LER_ID
  • PERSON_ID
  • LER_ID
  • BENEFIT_RELATION_ID
  • ELIG_PER_ELCTBL_CHC_ID
  • ORGANIZATION_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 enrollment coverage start date

Sample Formula 1:

Formula Type: Enrollment Coverage Start Date

DESCRIPTION: For (New Hire) hired between 1 and 15 of the month, coverage starts (FONM), and those between 15 and 30/31 coverage starts First of the month following next month

l_eff_date =GET_CONTEXT(EFFECTIVE_DATE, to_date('1951/01/01 00:00:00'))
l_rt_start_dt='1951/12/31 00:00:00'(date)
l_day = to_num(to_char(l_eff_date,'DD'))
If l_day >=1 and l_day <=15 THEN
(
l_rt_start_dt = ADD_DAYS(LAST_DAY(l_eff_date),1)
)
ELSE
(
l_rt_start_dt = ADD_MONTHS(ADD_DAYS(LAST_DAY(l_eff_date),1),1)
)
Return l_rt_start_dt

Sample Formula 2:

FORMULA TYPE: Enrollment Coverage Start Date

DESCRIPTION: Coverage starts (life date + 1) in a (Death of Dependent) life event.

DEFAULT FOR BEN_LER_NAME IS 'NA'
DEFAULT FOR BEN_PIL_LF_DT is '1951/01/01 00:00:00'(date)
l_ler_name = BEN_LER_NAME
l_lf_dt = BEN_PIL_LF_DT
l_cvg_strt_dt = '1951/01/01 00:00:00'(date)
IF l_ler_name = 'Death of Dependent'
THEN
(
l_cvg_strt_dt = ADD_DAYS(l_lf_dt,1)
)
RETURN l_cvg_strt_dt