Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Admission Periods which are associated with Admission Categories |
Implementation/DBA Data: | Not implemented in this database |
SELECT APAC.ROWID ROW_ID
, APAC.ADM_CAL_TYPE
, APAC.ADM_CI_SEQUENCE_NUMBER
, APAC.ADMISSION_CAT
, APAC.CI_START_DT
, APAC.CI_END_DT
, APAC.CREATED_BY
, APAC.CREATION_DATE
, APAC.LAST_UPDATED_BY
, APAC.LAST_UPDATE_DATE
, APAC.LAST_UPDATE_LOGIN
, APAC.REQUEST_ID
, APAC.PROGRAM_APPLICATION_ID
, APAC.PROGRAM_ID
, APAC.PROGRAM_UPDATE_DATE
, CT.DESCRIPTION
, CI.CAL_STATUS
, AC.DESCRIPTION ADMISSION_CAT_DESC
FROM IGS_AD_PERD_AD_CAT APAC
, IGS_CA_INST CI
, IGS_CA_TYPE CT
, IGS_AD_CAT AC
WHERE ( CT.CAL_TYPE = APAC.ADM_CAL_TYPE OR ( CT.CAL_TYPE IS NULL
AND APAC.ADM_CAL_TYPE IS NULL))
AND CI.CAL_TYPE = CT.CAL_TYPE
AND CI.SEQUENCE_NUMBER = APAC.ADM_CI_SEQUENCE_NUMBER
AND AC.ADMISSION_CAT = APAC.ADMISSION_CAT