Product: | IGF - Financial Aid |
---|---|
Description: | Obsolete |
Implementation/DBA Data: | APPS.IGF_AP_ISIR_INFO_V |
SELECT ISIRM.ISIR_ID
, ISIRM.BASE_ID
, ISIRM.SSN_NAME_CHANGE
, ISIRM.ORIGINAL_SSN
, ISIRM.ORIG_NAME_ID
, ISIRM.TRANSACTION_NUM
, ISIRM.ORIGINAL_SSN||ORIG_NAME_ID||TRANSACTION_NUM TRANSACTION_ID
, ISIRM.VERIFICATION_FLAG
, FAR.ISIR_CORR_STATUS
, ISIRM.PRIMARY_EFC
, ISIRM.SECONDARY_EFC
, ISIRM.PAYMENT_ISIR
, ISIRM.CREATED_BY
, ISIRM.CREATION_DATE
, ISIRM.LAST_UPDATED_BY
, ISIRM.LAST_UPDATE_DATE
, ISIRM.LAST_UPDATE_LOGIN
, ISIRM.SYSTEM_RECORD_TYPE
FROM IGF_AP_ISIR_MATCHED ISIRM
, IGF_AP_FA_BASE_REC FAR
WHERE FAR.BASE_ID = ISIRM.BASE_ID