Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Describes Admission of Application to Institution |
Implementation/DBA Data: | Not implemented in this database |
SELECT APL.PERSON_ID
, P.PARTY_NUMBER
, PP.PERSON_NAME
, APL.ADMISSION_APPL_NUMBER
, APL.APPL_DT
, APL.ACAD_CAL_TYPE
, APL.ACAD_CI_SEQUENCE_NUMBER
, APL.ADM_CAL_TYPE
, APL.ADM_CI_SEQUENCE_NUMBER
, APL.ADMISSION_CAT
, '_LA:APL.S_ADMISSION_PROCESS_TYPE:IGS_LOOKUP_VALUES:ADMISSION_PROCESS_TYPE:MEANING'
, APL.ADM_APPL_STATUS
, APL.ADM_FEE_STATUS
, '_LA:APL.TAC_APPL_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, APL.SPCL_GRP_1
, APL.SPCL_GRP_2
, '_LA:APL.COMMON_APP:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, APL.APPLICATION_TYPE
, APL.CHOICE_NUMBER
, APL.ROUTEB_PREF
, APL.APPLICATION_ID
, APL.ALT_APPL_ID
, APL.CREATED_BY
, APL.CREATION_DATE
, APL.LAST_UPDATED_BY
, APL.LAST_UPDATE_DATE
FROM IGS_AD_APPL_ALL APL
, HZ_PARTIES P
, HZ_PERSON_PROFILES PP
WHERE APL.PERSON_ID = P.PARTY_ID
AND P.PARTY_ID = PP.PARTY_ID
AND PP.CONTENT_SOURCE_TYPE (+) = 'USER_ENTERED'
AND SYSDATE BETWEEN PP.EFFECTIVE_START_DATE
AND NVL(PP.EFFECTIVE_END_DATE
, SYSDATE) WITH READ ONLY