Retrieves the distinct award year and record type details from the list of ISIR or Profile records which have partial matching information with person record in the system
Implementation/DBA Data:
Not implemented in this database
View Text
SELECT DISTINCT PM.CI_SEQUENCE_NUMBER , PM.CI_CAL_TYPE , PM.RECORD_TYPE FROM IGF_AP_PERSON_MATCH PM