Can I add a date-effective update to an existing pending worker record using HCM Data Loader?

No, you can only make corrections to an existing pending worker record.