You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Rate Periodization FF fetching incorrect value for DBI - BEN_PEN_ORGNL_ENRT_DT_DN during HDL load

Received Response
edited Dec 15, 2020 7:24AM in Benefits 1 comment


I'm facing an issue in our Benefits Rate Periodization formula for Health Care & Dependent Care FSA during conversion.
Conversion life event is added on 10/31/2020 and evaluated with ‘Apply Defaults’ field as No.
Then the participant enrolment data file is loaded, passing the original enrolment date as 5/1/2020.
The rate periodization formula is being executed as the last sub-process during the HDL load.

The DBI ‘BEN_PEN_ORGNL_ENRT_DT_DN’ used in the formula is not fetching the 5/1/2020 date.
Instead its fetching 10/31/2020, which is resulting in incorrect calculation.

Please let me know if you’ve come across this before.

Edit: I've tried using the function ben_fn_get_char_value, changed contexts, used alternate single-row & multi-row DBIs of enrolment results, etc. but nothing worked.


Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!