Product: | IGS - Student System (Obsolete) |
---|---|
Description: | UCAS Application Choice details |
Implementation/DBA Data: | Not implemented in this database |
SELECT APPCH.ROWID
, APPCH.APP_CHOICE_ID
, APPCH.APP_ID
, APPCH.APP_NO
, APPCH.CHOICE_NO
, APPCH.SYSTEM_CODE
, APPCH.UCAS_CYCLE
, PE.PERSON_NUMBER
, PE.FULL_NAME
, PE.LAST_NAME
, APP.OSS_PERSON_ID
, APP.APPLICATION_DATE
, APP.SENT_TO_OSS
, APPCH.LAST_CHANGE
, APPCH.INSTITUTE_CODE
, APPCH.UCAS_PROGRAM_CODE
, APPCH.CAMPUS
, APPCH.OSS_PROGRAM_CODE
, APPCH.OSS_PROGRAM_VERSION
, APPCH.OSS_ATTENDANCE_TYPE
, APPCH.OSS_ATTENDANCE_MODE
, APPCH.OSS_LOCATION
, APPCH.ENTRY_YEAR
, APPCH.ENTRY_MONTH
, APPCH.POINT_OF_ENTRY
, APPCH.DECISION
, APPCH.REPLY
, APPCH.EXPORT_TO_OSS_STATUS
, APPCH.CREATED_BY
, APPCH.CREATION_DATE
, APPCH.LAST_UPDATED_BY
, APPCH.LAST_UPDATE_DATE
, APPCH.LAST_UPDATE_LOGIN
FROM IGS_UC_APP_CHOICES APPCH
, IGS_UC_APPLICANTS APP
, IGS_PE_PERSON_BASE_V PE
WHERE APPCH.APP_ID = APP.APP_ID
AND APP.OSS_PERSON_ID = PE.PERSON_ID (+)