eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGF_AP_REVIEW_DET_V

Product:	IGF - Financial Aid (Obsolete)
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT SI.CURRENT_SSN SSN
, SI.SI_ID
, PM.APM_ID
, SI.LAST_NAME||'
, '||SI.FIRST_NAME STUDENT_NAME
, PM.DATE_RUN
, PM.CI_SEQUENCE_NUMBER
, PM.CI_CAL_TYPE
, PM.RECORD_TYPE
FROM IGF_AP_PERSON_MATCH PM
, IGF_AP_ISIR_INTRFACE SI
WHERE PM.SI_ID = SI.SI_ID
AND PM.RECORD_STATUS = 'REVIEW'
AND PM.RECORD_TYPE = 'ISIR' UNION SELECT CI.SOCIAL_SECURITY_NUMBER SSN
, CI.CSS_ID SI_ID
, PM.APM_ID
, CI.LAST_NAME||'
, '||CI.FIRST_NAME STUDENT_NAME
, PM.DATE_RUN
, PM.CI_SEQUENCE_NUMBER
, PM.CI_CAL_TYPE
, PM.RECORD_TYPE
FROM IGF_AP_PERSON_MATCH PM
, IGF_AP_CSS_INTERFACE CI
WHERE PM.CSS_ID = CI.CSS_ID
AND PM.RECORD_STATUS = 'REVIEW'
AND PM.RECORD_TYPE = 'PROFILE'

Columns

Name
SSN
SI_ID
APM_ID
STUDENT_NAME
DATE_RUN
CI_SEQUENCE_NUMBER
CI_CAL_TYPE
RECORD_TYPE