Compensation and Benefits - EBS (MOSC)

MOSC Banner

Understanding effective_end_date and enrt_cvg_thru_dt in BEN_PRTT_ENRT_RSLT_F

edited Sep 4, 2017 5:03AM in Compensation and Benefits - EBS (MOSC) 2 commentsAnswered

We are using Standard Benefits. We end dated the enrollment of an employee in a plan as of 31-Dec-2017 as the plan will no more be offered in 2018.

When I look into the enrollments table (BEN_PRTT_ENRT_RSLT_F), I find 2 rows with the following data -

PRTT_ENRT_RSLT_ID EFFECTIVE_START_DATE EFFECTIVE_END_DATE ENRT_CVG_STRT_DT ENRT_CVG_THRU_DT   PER_IN_LER_ID

------------------------------  ------------------------------------     -------------------------------    ------------------------------  -------------------------------    --------------------------

2395238                          01-JAN-17                             31-DEC-17                          01-JAN-17                    31-DEC-12                       3338

2395238                          01-JAN-18                             31-DEC-12                          01-JAN-17                    31-DEC-17

Can someone help me understand how I should interpret this data?

Employee was enrolled in the plan from 01-Jan-2017 to 31-Dec-2017 and is no more enrolled in the plan from 01-Jan-2018 onwards.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center