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_SL_SCHOOL_CODES_V

Product:	IGF - Financial Aid (Obsolete)
Description:	View that retrieves all active Financial Aid Offices in the system.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT DISTINCT OLI.ORG_ALTERNATE_ID ALTERNATE_IDENTIFIER
, OLT.SYSTEM_ID_TYPE
FROM HZ_PARTIES HZ
, IGS_OR_ORG_ALT_IDS OLI
, IGS_OR_ORG_ALT_IDTYP OLT
WHERE OLI.ORG_STRUCTURE_ID = HZ.PARTY_NUMBER
AND OLI.ORG_ALTERNATE_ID_TYPE = OLT.ORG_ALTERNATE_ID_TYPE
AND SYSDATE BETWEEN OLI.START_DATE
AND NVL (END_DATE
, SYSDATE)
AND HZ.STATUS = 'A'

Columns

Name
ALTERNATE_IDENTIFIER
SYSTEM_ID_TYPE