We've updated the ServiceNow Community Code of Conduct, adding guidelines around AI usage, professionalism, and content violations. Read more

cost center data is coming from AD and populating in sys_user table but how it is getting updated in Cost center table

swarnargha
Kilo Contributor

Is there is any business rule for this?

find_real_file.png

7 REPLIES 7

Hi Swarnarghya,



What is the coalese value for the transform map? The create action will create a record on the table that holds the value of that field. If the cost center field is a reference field, then a record will be created with the value that is coming back. Is the field a string field or a reference field?


In this example there is only one cost center that many users can be part of. Similar to many users being in the same location. It's a one to many relationship which is the expected behavior.


sachin_namjoshi
Kilo Patron

You may have scheduled transform laods for cost center import.


In our instance, we have transform map for loading cost center data before user import.



Regards,


Sachin