When an attestation is generated and the attester unassign's an account, these sets of unassigned accounts will be stored within an unassigned bucket. I wish to exclude these sets of unassigned accounts from attestation when the next cycle of attestation is generated. Is their a way for me to do so via a form of coverage file of some sort which i can maybe upload prior to the generation of attestation which would exclude these accounts ?
Hi,
No the accounts will not be Orphaned by the reviewers, they will just be unassigned and removed from their attestation such that the attester is able to complete their attestation. We have a set configuration for our attestation where we basically only generate attestation for ' All active Accounts'. But here what i am looking to do is prior to attestation being generated for all active accounts i wish to exclude accounts which were unassigned in the previous cycle. I did check to see the status of these accounts which were unassigned previously and the status of it remains ' Active' i do no think they become orphan.
ah, got it. Yes, they stay associated with their identities then.
To your original question: yes, that can be done. I don't have the details handy, however.
The unassigned action is reflected in the review results. that is then your base to exclude those accounts in the review definition filter. In that definition your filter would a SQL. I have done that before by excluding accounts that previously have been included in a review using the same review definition.
In that SQL you need to:
So the above SQL will be part of the review component filter in your review definition e.g.
accounts.id not in (<the sql bit from above>)
Hope this help
Frank
This might just work. Let me give it a shot and see if it works. The only thing is though that this process of removing account would be a standardized process and i would have to modify the SQL every time to update the Review ID for it to exclude sets of account. But i am still going to give it a shot. Thank You Frank.
actually, that would be included if you get the ID of the latest completed review result of the review definition you are after (see bullet point number one). that way you don't have to adjust the query every time.
Hi,
do you mean that those accounts will be orphaned by the reviewers?
You could in the next cycle simply exclude all orphans then.
Frank