I'd like to create a report that will display the missing and rejected users after my IDCs run. You can see this information, by manually going to each IDC, clicking on Raw Data, and then selecting the Missing or Rejected tabs. I can solve for existing users who get rejected or go missing by querying the pv_users view. However, I want to also report on identities where the identity record was never created because of an issue with the source file. Is there any public view or table that allows me to query what the Raw Data view displays?
select * from pv_users
where deletion_date >= to_date ('08/15/2016', 'MM/DD/YYYY')