In the organization users are terminated by deleting from HRMS, not setting an 'is_terminated' flag. In this scenario, deleted users and their accesses can be determined from the users page and it is clear that the users are deleted. But they are not indicated as is_deleted or is_terminated in the users or pv_users tables. How can I get the current accesses of these users in a report?
I would like to confirm my understanding.
So terminated users do not come in through the next collection. After that collection, you are able to see the 'is_deleted' and 'is_terminated' flag set to 'yes' on the user's 'General' tab but this status is not reflected in the tables?