Creation Date is getting updated with Last Update date for Enrollement details

User_ARFO6

Hi,

We are using a custom BIP alert notification to trigger the notification. This is a conditional formatting report to trigger the notification to the benefits administrator.

Example: An employee (A) has enrolled himself earlier in the health plan. (A) has enrolled his dependent1 (B) and depenedent2 (C) as of today.

So, the issue is that (A)'s creation_date is getting changed to today's date along with (B)'s and (C)'s creation_date after enrolling (B) and (C).

The required output is (B)'s and (C)'s last_update date should change and creation_date shouldn't change.

Also, there shouldn't be any date changes to (A).

The table we are using is BEN_PRTT_ENRT_RSLT, the creation_date and last_update are changing in this particular table.