You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Mass Mailing Address Update using HDL

edited Jun 30, 2020 2:07PM in Human Capital Management 15 comments

Summary

Existing mailing address not end-dated and still displays on the screen

Content

I am trying to update the mailing address using HDL. I created a report to pull out the PersonID

METADATA|PersonAddress|PersonAddrUsageId|EffectiveStartDate|EffectiveEndDate|AddressType|PersonId|PersonNumber|AddressId|AddressLine1|AddressLine2|AddressLine3|AddressLine4|TownOrCity|Region3|Country|PostalCode|PrimaryFlag|SourceSystemOwner|SourceSystemId|GUID

MERGE|PersonAddress||2020/06/23|4712/12/31|HOME|300000010554722|913571||13349 16th Avenue||||Blairmore|AB|CA|T0K 0E0|Y|HRC_SQLLOADER|ADD_HOME_913571|

I can successfully import and load the file into the system but when I check in the system, the old address is still displayed along with the new one

Have I missed something on the HDL file?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!