Delete a future dated record using HDL:

To delete we have to use SET PURGE FUTURE CHANGES Y and update the end date for the prior record

For example for employee with person number Test001, there is future date change from 2018/12/01 like below

METADATA|WorkTerms|AssignmentNumber|PersonNumber|LegalEmployerName|DateStart|EffectiveStartDate|EffectiveSequence|EffectiveLatestChange|EffectiveEndDate|ActionCode|PersonTypeCode|JobCode|WorkerType|BusinessUnitShortCode|SystemPersonType|AssignmentName|AssignmentType|AssignmentStatusTypeCode
MERGE|WorkTerms|ETTest001|Test001|ZZ LEGAL ENTITY 2|2018/01/01|2018/01/01|1|Y|2018/05/31|HIRE|Employee||E|ZZBUS002|EMP|Work_terms_Assign_name|ET|ACTIVE_PROCESS 
MERGE|WorkTerms|ETTest001|Test001|ZZ LEGAL ENTITY 2|2018/01/01|2018/06/01|1|Y|2018/11/30|ASG_CHANGE|Employee||E|ZZBUS002|EMP|Work_terms_Assign_name|ET|ACTIVE_PROCESS 
MERGE|WorkTerms|ETTest001|Test001|ZZ LEGAL ENTITY 2|2018/01/01|2018/12/01|1|Y||ASG_CHANGE|Employee||E|ZZBUS002|EMP|Work_terms_Assign_name|ET|ACTIVE_PROCESS

METADATA|Assignment|AssignmentNumber|WorkTermsNumber|PersonNumber|LegalEmployerName|DateStart|EffectiveStartDate|EffectiveSequence|EffectiveLatestChange|EffectiveEndDate|ActionCode|PersonTypeCode|JobCode|BusinessUnitShortCode|WorkerType|SystemPersonType|AssignmentName|AssignmentType|AssignmentStatusTypeCode
MERGE|Assignment|ETest001|ETTest001|Test001|ZZ LEGAL ENTITY 2|2018/01/01|2018/01/01|1|Y|2018/05/31|HIRE|Employee||ZZBUS002|E|EMP|assignment_name|E|ACTIVE_PROCESS
MERGE|Assignment|ETest001|ETTest001|Test001|ZZ LEGAL ENTITY 2|2018/01/01|2018/06/01|1|Y|2018/11/30|ASG_CHANGE|Employee||ZZBUS002|E|EMP|assignment_name|E|ACTIVE_PROCESS
MERGE|Assignment|ETest001|ETTest001|Test001|ZZ LEGAL ENTITY 2|2018/01/01|2018/12/01|1|Y||ASG_CHANGE|Employee||ZZBUS002|E|EMP|assignment_name|E|ACTIVE_PROCESS


To delete the future dated change, include SET PURGE FUTURE CHANGES Y

SET PURGE FUTURE CHANGES Y
METADATA|WorkTerms|AssignmentNumber|PersonNumber|LegalEmployerName|DateStart|EffectiveStartDate|EffectiveSequence|EffectiveLatestChange|EffectiveEndDate|ActionCode|PersonTypeCode|JobCode|WorkerType|BusinessUnitShortCode|SystemPersonType|AssignmentName|AssignmentType|AssignmentStatusTypeCode
MERGE|WorkTerms|ETTest001|Test001|ZZ LEGAL ENTITY 2|2018/01/01|2018/01/01|1|Y|2018/05/31|HIRE|Employee||E|ZZBUS002|EMP|Work_terms_Assign_name|ET|ACTIVE_PROCESS 
MERGE|WorkTerms|ETTest001|Test001|ZZ LEGAL ENTITY 2|2018/01/01|2018/06/01|1|Y||ASG_CHANGE|Employee||E|ZZBUS002|EMP|Work_terms_Assign_name|ET|ACTIVE_PROCESS 


METADATA|Assignment|AssignmentNumber|WorkTermsNumber|PersonNumber|LegalEmployerName|DateStart|EffectiveStartDate|EffectiveSequence|EffectiveLatestChange|EffectiveEndDate|ActionCode|PersonTypeCode|JobCode|BusinessUnitShortCode|WorkerType|SystemPersonType|AssignmentName|AssignmentType|AssignmentStatusTypeCode
MERGE|Assignment|ETest001|ETTest001|Test001|ZZ LEGAL ENTITY 2|2018/01/01|2018/01/01|1|Y|2018/05/31|HIRE|Employee||ZZBUS002|E|EMP|assignment_name|E|ACTIVE_PROCESS
MERGE|Assignment|ETest001|ETTest001|Test001|ZZ LEGAL ENTITY 2|2018/01/01|2018/06/01|1|Y||ASG_CHANGE|Employee||ZZBUS002|E|EMP|assignment_name|E|ACTIVE_PROCESS

It may helpful for you. please visit blog for more information and share your ideas.Thanks,Sainath