[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | View of IGS_AD_APPL_ALL table. Incorporates alternate codes and calendar instance start and end dates for both the Academic and Admission calendars. |
| Implementation/DBA Data: | Not implemented in this database |
SELECT AA.ROWID ROW_ID
, AA.PERSON_ID PERSON_ID
, P.PARTY_NUMBER PERSON_NUMBER
, P.PERSON_LAST_NAME || '
, ' || P.PERSON_TITLE || ' ' || NVL (P.KNOWN_AS
, P.PERSON_FIRST_NAME) DSP_CONTEXT_BLOCK_NAME
, AA.ADMISSION_APPL_NUMBER ADMISSION_APPL_NUMBER
, AA.APPL_DT APPL_DT
, AA.ACAD_CAL_TYPE ACAD_CAL_TYPE
, AA.ACAD_CI_SEQUENCE_NUMBER ACAD_CI_SEQUENCE_NUMBER
, CI1.ALTERNATE_CODE ACAD_ALTERNATE_CODE
, CI1.START_DT ACAD_CI_START_DT
, CI1.END_DT ACAD_CI_END_DT
, AA.ADM_CAL_TYPE ADM_CAL_TYPE
, AA.ADM_CI_SEQUENCE_NUMBER ADM_CI_SEQUENCE_NUMBER
, CI2.ALTERNATE_CODE ADM_ALTERNATE_CODE
, CI2.START_DT ADM_CI_START_DT
, CI2.END_DT ADM_CI_END_DT
, AA.ADMISSION_CAT ADMISSION_CAT
, AA.S_ADMISSION_PROCESS_TYPE S_ADMISSION_PROCESS_TYPE
, LKUP.MEANING ADM_PRC_TYPE_DESC
, AA.ADM_APPL_STATUS ADM_APPL_STATUS
, AA.ADM_FEE_STATUS ADM_FEE_STATUS
, AA.TAC_APPL_IND TAC_APPL_IND
, CI1.ALTERNATE_CODE || '/' || CI2.ALTERNATE_CODE COMMENCEMENT_PERIOD
, AA.ADMISSION_CAT || '/' || LKUP.MEANING ADMISSION_PROCESS_CAT
, AA.ADM_APPL_STATUS ADM_APPL_STATUS_DISPLAY
, AA.ADM_FEE_STATUS ADM_FEE_STATUS_DISPLAY
, AA.COMMON_APP
, AA.SPCL_GRP_1
, DECODE(AA.SPCL_GRP_1
, NULL
, NULL
, (SELECT CC1.NAME
FROM IGS_AD_CODE_CLASSES CC1
WHERE AA.SPCL_GRP_1 = CC1.CODE_ID
AND CC1.CLASS = 'SPECIAL_GROUP1' )) SPCL_GRP_1_NAME
, DECODE (AA.SPCL_GRP_1
, NULL
, NULL
, (SELECT CC1.DESCRIPTION
FROM IGS_AD_CODE_CLASSES CC1
WHERE AA.SPCL_GRP_1 = CC1.CODE_ID
AND CC1.CLASS = 'SPECIAL_GROUP1' )) SPCL_GRP_1_DESC
, AA.SPCL_GRP_2
, DECODE(AA.SPCL_GRP_2
, NULL
, NULL
, (SELECT CC2.NAME
FROM IGS_AD_CODE_CLASSES CC2
WHERE AA.SPCL_GRP_2 = CC2.CODE_ID
AND CC2.CLASS = 'SPECIAL_GROUP2' )) SPCL_GRP_2_NAME
, DECODE(AA.SPCL_GRP_2
, NULL
, NULL
, (SELECT CC2.DESCRIPTION
FROM IGS_AD_CODE_CLASSES CC2
WHERE AA.SPCL_GRP_2 = CC2.CODE_ID
AND CC2.CLASS = 'SPECIAL_GROUP2' )) SPCL_GRP_2_DESC
, AA.CREATED_BY
, AA.CREATION_DATE
, AA.LAST_UPDATED_BY
, AA.LAST_UPDATE_DATE
, AA.LAST_UPDATE_LOGIN
, AA.APPLICATION_TYPE
, AA.CHOICE_NUMBER CHOICE_NUMBER
, AA.ROUTEB_PREF ROUTEB_PREF
, AA.APPLICATION_ID APPLICATION_ID
, AA.ALT_APPL_ID ALT_APPL_ID
, AA.APPL_FEE_AMT APPL_FEE_AMT
FROM IGS_AD_APPL AA
, IGS_CA_INST CI1
, IGS_CA_INST CI2
, HZ_PARTIES P
, IGS_LOOKUP_VALUES LKUP
WHERE P.PARTY_ID = AA.PERSON_ID
AND CI1.CAL_TYPE = AA.ACAD_CAL_TYPE
AND CI1.SEQUENCE_NUMBER = AA.ACAD_CI_SEQUENCE_NUMBER
AND CI2.CAL_TYPE = AA.ADM_CAL_TYPE
AND CI2.SEQUENCE_NUMBER = AA.ADM_CI_SEQUENCE_NUMBER
AND LKUP.LOOKUP_TYPE = 'ADMISSION_PROCESS_TYPE'
AND AA.S_ADMISSION_PROCESS_TYPE = LKUP.LOOKUP_CODE