how to insert rows in middle in employment page using hdl
Summary: Dear expert
I am loading PROMOTIONS of employees effective from 1st April 2025. But for some employees in June, July, August months other transactions like Manager change etc are made in system. how to insert promotions rows in middle in employment page effective from 1st April 2025 using hdl?
I am using this template, This is working fine for employees with No assignment transactions in April,June,July and August months.
METADATA|WorkTerms|FLEX:PER_ASG_DF|externalJobTitle(PER_ASG_DF=Global Data Elements)|ActionCode|AssignmentNumber|AssignmentStatusTypeCode|EffectiveSequence|EffectiveLatestChange|EffectiveStartDate|EffectiveEndDate|GradeCode|BusinessUnitShortCode|PositionCode|PersonId|PeriodOfServiceId|PersonNumber|PositionOverrideFlag|PrimaryWorkTermsFlag|AssignmentId|DateStart