[Home] [Help]
View: IGS_AD_ACAD_INTEREST_V
| Product: | IGS - Student System (Obsolete) |
|---|
| Description: | |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT AI.ROWID ROW_ID
, AI.ACAD_INTEREST_ID ACAD_INTEREST_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.FIELD_OF_STUDY FIELD_OF_STUDY
, FOS.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 FROM IGS_AD_ACAD_INTEREST AI
, IGS_PS_FLD_OF_STUDY FOS
WHERE AI.FIELD_OF_STUDY = FOS.FIELD_OF_STUDY
Columns
| Name |
| ROW_ID |
| ACAD_INTEREST_ID |
| PERSON_ID |
| ADMISSION_APPL_NUMBER |
| NOMINATED_COURSE_CD |
| SEQUENCE_NUMBER |
| FIELD_OF_STUDY |
| DESCRIPTION |
| CREATED_BY |
| CREATION_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_DATE |
| LAST_UPDATE_LOGIN |