Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Shows the applicant's intent details |
Implementation/DBA Data: | Not implemented in this database |
SELECT AI.ROWID ROW_ID
, AI.APP_INTENT_ID APP_INTENT_ID
, AI.PERSON_ID PERSON_ID
, AI.ADMISSION_APPL_NUMBER ADMISSION_APPL_NUMBER
, AI.NOMINATED_COURSE_CD NOMINATED_COURSE_CD
, AI.SEQUENCE_NUMBER SEQUENCE_NUMBER
, AI.INTENT_TYPE_ID INTENT_TYPE_ID
, CC.NAME NAME
, CC.DESCRIPTION DESCRIPTION
, AI.CREATED_BY CREATED_BY
, AI.CREATION_DATE CREATION_DATE
, AI.LAST_UPDATED_BY LAST_UPDATED_BY
, AI.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AI.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, AI.REQUEST_ID REQUEST_ID
, AI.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, AI.PROGRAM_ID PROGRAM_ID
, AI.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, AI.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, AI.ATTRIBUTE1 ATTRIBUTE1
, AI.ATTRIBUTE2 ATTRIBUTE2
, AI.ATTRIBUTE3 ATTRIBUTE3
, AI.ATTRIBUTE4 ATTRIBUTE4
, AI.ATTRIBUTE5 ATTRIBUTE5
, AI.ATTRIBUTE6 ATTRIBUTE6
, AI.ATTRIBUTE7 ATTRIBUTE7
, AI.ATTRIBUTE8 ATTRIBUTE8
, AI.ATTRIBUTE9 ATTRIBUTE9
, AI.ATTRIBUTE10 ATTRIBUTE10
, AI.ATTRIBUTE11 ATTRIBUTE11
, AI.ATTRIBUTE12 ATTRIBUTE12
, AI.ATTRIBUTE13 ATTRIBUTE13
, AI.ATTRIBUTE14 ATTRIBUTE14
, AI.ATTRIBUTE15 ATTRIBUTE15
, AI.ATTRIBUTE16 ATTRIBUTE16
, AI.ATTRIBUTE17 ATTRIBUTE17
, AI.ATTRIBUTE18 ATTRIBUTE18
, AI.ATTRIBUTE19 ATTRIBUTE19
, AI.ATTRIBUTE20 ATTRIBUTE20
FROM IGS_AD_APP_INTENT AI
, IGS_AD_CODE_CLASSES CC
WHERE AI.INTENT_TYPE_ID = CC.CODE_ID