[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT A.ROW_ID ROW_ID
, P.PERSON_NUMBER PERSON_NUMBER
, A.PERSON_ID PERSON_ID
, A.ADMISSION_APPL_NUMBER ADMISSION_APPL_NUMBER
, A.APPL_DT APPL_DT
, A.ACAD_CAL_TYPE ACAD_CAL_TYPE
, A.ACAD_CI_SEQUENCE_NUMBER ACAD_CI_SEQUENCE_NUMBER
, A.ADMISSION_CAT ADMISSION_CAT
, A.S_ADMISSION_PROCESS_TYPE S_ADMISSION_PROCESS_TYPE
, A.ADM_APPL_STATUS ADM_APPL_STATUS
, A.ADM_FEE_STATUS ADM_FEE_STATUS
, A.TAC_APPL_IND TAC_APPL_IND
, A.COMMON_APP COMMON_APP
, CC1.NAME SPCL_GRP_1
, CC1.DESCRIPTION SPCL_GRP_1_DESC
, CC2.NAME SPCL_GRP_2
, CC2.DESCRIPTION SPCL_GRP_2_DESC
, A.CREATED_BY CREATED_BY
, A.CREATION_DATE CREATION_DATE
, A.LAST_UPDATED_BY LAST_UPDATED_BY
, A.LAST_UPDATE_DATE LAST_UPDATE_DATE
, A.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, A.REQUEST_ID REQUEST_ID
, A.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, A.PROGRAM_ID PROGRAM_ID
, A.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, A .APPLICATION_TYPE APPLICATION_TYPE
, A.CHOICE_NUMBER CHOICE_NUMBER
, A.ROUTEB_PREF ROUTEB_PREF
, A.APPLICATION_ID APPLICATION_ID
, A.ALT_APPL_ID ALT_APPL_ID
, A.APPL_FEE_AMT APPL_FEE_AMT
FROM IGS_AD_APPL A
, IGS_PE_PERSON_BASE_V P
, IGS_AD_CODE_CLASSES CC1
, IGS_AD_CODE_CLASSES CC2
WHERE A.PERSON_ID = P.PERSON_ID
AND A.SPCL_GRP_1 = CC1.CODE_ID(+)
AND CC1.CLASS(+) = 'SPECIAL_GROUP1'
AND A.SPCL_GRP_2 = CC2.CODE_ID(+)
AND CC2.CLASS(+) = 'SPECIAL_GROUP2'