IAM Extract Process

1) Extract Person data from IAM
2) Remove duplicate UUID occurences (UUID maps to KIM principal id)
3) Remoce duplicate USERID occurences (USERID maps to KIM principal name)
4) Write the results to a file to be processed later.

On KIM, both the principal id and principal name have a 'unique' requirement on the database so there can NEVER be more than one occurence of either.

Also, the Entity Id (MothraId) must be unique.

This is the extract that is run on IAM:

select p.IAMID, p.MOTHRAID, p.PPSID, p.STUDENTID, p.BANNER_PIDM, p.O_FNAME, p.O_MNAME, p.O_LNAME, p.O_FULLNAME,
c.EMAIL, c.HS_EMAIL, c.CAMPUS_EMAIL, c.ADDR_STREET, c.ADDR_CITY, c.ADDR_STATE, c.ADDR_ZIP, c.WORK_PHONE, 
a.USERID, a.UUID, p.IS_FACULTY, p.IS_STUDENT, p.IS_STAFF, p.IS_EXTERNAL, o.DEPT_CODE 
 from "PR_SERVICES"."CV_PEOPLE" p, "PR_SERVICES"."PPL_CONTACT" c, "PR_SERVICES"."PPL_PRI_KERB_ACCOUNTS" a,
"PR_SERVICES"."PPL_PPS_ASSOCIATIONS" o 
where p.IAMID=c.IAMID (+) and p.IAMID=a.IAMID (+) and p.IAMID=o.IAMID (+) and o.assoc_rank (+) = 1