HDL Dat file required to update the absence plan end date

Hi Folks,

Accidentally Vacation plan has been ended for more than 100 employees with the wrong end date which causes the plan to end and went to the inactive status now. As per business requirements, that plan shouldn't be ended and should be active till the employee is terminated.

We would like to update the plan end date for more than 100 employees using HDL. So can anyone share us the dat file and related SQL query to update the plan end?

Thanks in advance!!

Cheers,

Mahendra.