Forum Stats

  • 3,733,849 Users
  • 2,246,830 Discussions
  • 7,856,894 Comments

Discussions

Required HDL to update attributes of all terminated employees

Nilesh Athawale
Nilesh Athawale Member Posts: 1 Green Ribbon

Hi Experts

Do we have HDL to update the attribute like email,fullname,salary org_name,email,jobname ,POSITION_NAME Passport_number,VISA_PERMIT_NUMBER DOB,SEARCH_PHONE_NUMBER,TOWN_OR_CITY,HOME_ADDRESS, NATIONAL_IDENTIFIER_NUMBER of ex-employees/terminated records

I tried to update the name using the below HD but it's not working.

METADATA|PersonName|SourceSystemOwner|SourceSystemId|PersonId|EffectiveStartDate|EffectiveEndDate|LegislationCode|NameType|FirstName|MiddleNames|LastName|Title

MERGE|PersonName|XXX|XX021_WR01|300000002239495|2001/02/15|2001/02/16||GLOBAL|Test|Nameupdate|fivemarch|MR.


Please help on the same.

Regards,

Nilesh

Sign In or Register to comment.