How to prevent imported initialized Leave balances from adding up ? — Cloud Customer Connect
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

How to prevent imported initialized Leave balances from adding up ?

edited Dec 20, 2018 12:10AM in Workforce Management 4 comments

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 ?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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