Product: | IGS - Student System (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT OI.ROWID ROW_ID
, OI.OTHER_INST_ID OTHER_INST_ID
, OI.PERSON_ID PERSON_ID
, OI.ADMISSION_APPL_NUMBER ADMISSION_APPL_NUMBER
, OI.NOMINATED_COURSE_CD NOMINATED_COURSE_CD
, OI.SEQUENCE_NUMBER SEQUENCE_NUMBER
, OI.INSTITUTION_CODE INSTITUTION_CODE
, I.NAME NAME
, OI.CREATED_BY CREATED_BY
, OI.CREATION_DATE CREATION_DATE
, OI.LAST_UPDATED_BY LAST_UPDATED_BY
, OI.LAST_UPDATE_DATE LAST_UPDATE_DATE
, OI.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OI.NEW_INSTITUTION FROM IGS_AD_OTHER_INST OI
, IGS_OR_INSTITUTION I
WHERE I.INSTITUTION_CD = OI.INSTITUTION_CODE