Understanding effective_end_date and enrt_cvg_thru_dt in BEN_PRTT_ENRT_RSLT_F
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.