Need Scheduled import for sys_user table with external HR app data

[rajibosss11]

When an HR person marks an employee as terminated in the HR app, it should be reflected in the ServiceNow User table via a scheduled daily import.

I have created Schedule Import ,Data source , transform MAP

I have added the Active field and marked users as Inactive based on the imported data. Please review the script and procedure to ensure everything is correct. If any changes are needed, kindly suggest where the script or steps should be updated.

please share any example for this 

[Periyasamy P]

Didn't see any screen or attachment to review. Please add

[rajibosss11]

@Periyasamy P  attached

[Periyasamy P · Accepted solution]

As per field map.jpg, column "sys_import_state"  is not part of your staging table "imp_user". Please use right column in your field map.