Thursday 23 February 2023

FTE update HDL

The SET command is required to update the FTE in work measures table when changing the working hours of an employee. IF you change it without the SET command the hours get updated but not the FTE.


SET CALCULATE_FTE Y
METADATA|WorkTerms|AssignmentNumber|PersonNumber|LegalEmployerName|DateStart|WorkerType|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|ActionCode|NormalHours
MERGE|WorkTerms|ET29611|29611|LE_NAME|2009/01/19|E|2022/08/01||1|Y|ASG_CHANGE|20
METADATA|Assignment|WorkTermsNumber|PersonNumber|AssignmentNumber|LegalEmployerName|DateStart|WorkerType|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|ActionCode|EffectiveLatestChange|NormalHours
MERGE|Assignment|ET29611|29611|E29611|LE_NAME|2009/01/19|E|2022/08/01||1|ASG_CHANGE|Y|20

No comments:

Post a Comment