Workday contractor to employee conversion with same empID

[musthak_ahamad]

Hi All,

We have the below use case for contractor to employee conversion and vice versa

Use Case: 

1. our workday connector is connected with RAAS report and the user base is 14k.
2. the contractor is converted as employee in workday and vice versa.
3. When the contractor becomes an employee the workday is sending both terminated record of contractor and active record of employee.
4. but since the employee ID of these 2 records are same the savint keep overwrighting the record.
5. is there a way to get only primary or active record from workday in this conversion case so that saviynt will receive only the single record and it will be come an update operation.
6. we checked this with workday team but they are out of options to give us only the primary record in RAAS report.

[rushikeshvartak]

You need to ask workday team to provide flag on conversation E2C or c2E and then use preprocessor to process either or record

[Amit_Malik]

@musthak_ahamad , we had the same use case. We are using SOAP for import and have asked workday team to provide an integration field e2c or c2e. If flag is set, then delete that entry in preprocessor 

[Amit_Malik · Accepted solution]

@musthak_ahamad ,

mappings and query 

1) CCW Import

Mapping : "CUSTOMPROPERTY12": "Worker_Data.Integration_Field_Override_Data(Field_Reference->ID=='EEtoCCW').Value"

Preprocessort

"DELETE FROM NEWUSERDATA where customproperty12='Y'",

2) Employee Import

"CUSTOMPROPERTY12": "Worker_Data.Integration_Field_Override_Data(Field_Reference->ID=='CCWtoEE').Value",

"DELETE FROM NEWUSERDATA where customproperty12='Y'",

In your case , you can ask workday team to have a flag in RaaS report that will give any conversion. Attribute name could be "WorkerConversion" (for example) and values could be "EE2CCW" or "CCWtoEE" on the old record. On new record , this flag/attribute will be null.

In preprocessor, you can use

"DELETE FROM NEWUSERDATA where customproperty12 in ('EE2CCW','CCW2EE'),

This query will stop updating the old / transferred record going forward