What is PIDM and PERSON_UID?

The Banner system uses the field PIDM as the record key field. The ODS uses both PIDM and PERSON_UID as the record key field, and they are interchangeable. When running a query, specifying the PIDM/PERSON_UID value will often improve speed/performance. If you are using a query that uses 2 or more views, they should be joined together with the PIDM/PERSON_UID. INT_REF_ID_ARIES is another synonym for PIDM and PERSON_UID.