How to prevent imported initialized Leave balances from adding up ?
Content
We are integrating with a third party system to import leave balances daily and use HDL for the same.
E.g.
METADATA|PersonAccrualDetail|PersonNumber|WorkTermsNumber|PlanName|AccrualType|ProcdDate|Value
MERGE|PersonAccrualDetail|1234|ET1234|Annual Leave|INIT|2018/08/28|14
The HDL works fine and the balance is also imported as expected.
However when we run the same HDL for the following day (as below)
METADATA|PersonAccrualDetail|PersonNumber|WorkTermsNumber|PlanName|AccrualType|ProcdDate|Value
MERGE|PersonAccrualDetail|1234|ET1234|Annual Leave|INIT|2018/08/29|14.5
--
We expect the system to consider 14.5 as the value for 2018/08/29. However the system ends shows 28.5 (14 + 14.5) .
How can we avoid this ? Is it possible to interface daily new values without getting them added up ?