Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Describes a user defined admission category for an admission process, for example undergraduate - HECS for course admission, postgraduate - HECS for short admission. |
Implementation/DBA Data: | Not implemented in this database |
SELECT APC.ROW_ID ROW_ID
, APC.ADMISSION_CAT ADMISSION_CAT
, AC.DESCRIPTION
, APC.S_ADMISSION_PROCESS_TYPE S_ADMISSION_PROCESS_TYPE
, L.MEANING MEANING
, APC.OFFER_RESPONSE_OFFSET OFFER_RESPONSE_OFFSET
, NULL
, NULL
, APC.CREATED_BY CREATED_BY
, APC.CREATION_DATE CREATION_DATE
, APC.LAST_UPDATED_BY LAST_UPDATED_BY
, APC.LAST_UPDATE_DATE LAST_UPDATE_DATE
, APC.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, APC.CLOSED_IND
FROM IGS_AD_PRCS_CAT APC
, IGS_LOOKUPS_VIEW L
, IGS_AD_CAT AC
WHERE L.LOOKUP_TYPE = 'ADMISSION_PROCESS_TYPE'
AND AC.ADMISSION_CAT = APC.ADMISSION_CAT
AND L.LOOKUP_CODE = APC.S_ADMISSION_PROCESS_TYPE