Product: | IGS - Student System (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT CI.DESCRIPTION
, PPC.ADM_CAL_TYPE
, PPC.ADM_CI_SEQUENCE_NUMBER
, PPC.ADMISSION_CAT
, AC.DESCRIPTION
, '_LA:PPC.S_ADMISSION_PROCESS_TYPE:IGS_LOOKUP_VALUES:ADMISSION_PROCESS_TYPE:MEANING'
, '_LA:PPC.CLOSED_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, PPC.CREATED_BY
, PPC.CREATION_DATE
, PPC.LAST_UPDATED_BY
, PPC.LAST_UPDATE_DATE
FROM IGS_AD_PRD_AD_PRC_CA PPC
, IGS_CA_INST_ALL CI
, IGS_AD_CAT_ALL AC
WHERE CI.CAL_TYPE = PPC.ADM_CAL_TYPE
AND CI.SEQUENCE_NUMBER = PPC.ADM_CI_SEQUENCE_NUMBER
AND AC.ADMISSION_CAT = PPC.ADMISSION_CAT WITH READ ONLY