[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT APAIAV.PERSON_ID PERSON_ID
, APAIAV.NOMINATED_COURSE_CD NOMINATED_COURSE_CD
, APAIAV.SEQUENCE_NUMBER SEQUENCE_NUMBER
, APAIAV.ADMISSION_APPL_NUMBER ADMISSION_APPL_NUMBER
, APAIAV.ACAD_CAL_TYPE ACAD_CAL_TYPE
, APAIAV.ACAD_CI_SEQUENCE_NUMBER ACAD_CI_SEQUENCE_NUMBER
, APAIAV.ADM_CAL_TYPE ADM_CAL_TYPE
, APAIAV.ADM_CI_SEQUENCE_NUMBER ADM_CI_SEQUENCE_NUMBER
, CIAPV.ACAD_ALTERNATE_CODE ACAD_ALTERNATE_CODE
, CIAPV.ADM_ALTERNATE_CODE ADM_ALTERNATE_CODE
, AA.ADMISSION_CAT ADMISSION_CAT
, AA.S_ADMISSION_PROCESS_TYPE S_ADMISSION_PROCESS_TYPE
, LKUPV.MEANING S_ADM_PRCS_TYPE_DESC
, AA.ADM_APPL_STATUS ADM_APPL_STATUS
, AA.APPL_DT APPL_DT
, AA.ADM_FEE_STATUS ADM_FEE_STATUS
, APAIAV.ADM_DOC_STATUS ADM_DOC_STATUS
, APAIAV.ACADEMIC_INDEX ACADEMIC_INDEX
, APAIAV.ADM_ENTRY_QUAL_STATUS ADM_ENTRY_QUAL_STATUS
, APAIAV.PREDICTED_GPA PREDICTED_GPA
, APAIAV.CRV_VERSION_NUMBER CRV_VERSION_NUMBER
, APAIAV.COURSE_TITLE_DISPLAY COURSE_TITLE_DISPLAY
, APAIAV.LOCATION_CD LOCATION_CD
, APAIAV.ATTENDANCE_MODE ATTENDANCE_MODE
, APAIAV.ATTENDANCE_TYPE ATTENDANCE_TYPE
, APAIAV.UNIT_SET_CD UNIT_SET_CD
, APAIAV.US_VERSION_NUMBER US_VERSION_NUMBER
, APAIAV.EXPECTED_COMPLETION_YR EXPECTED_COMPLETION_YR
, APAIAV.COURSE_RANK_SET COURSE_RANK_SET
, APAIAV.COURSE_RANK_SCHEDULE COURSE_RANK_SCHEDULE
, APAIAV.ADMISSION_CD ADMISSION_CD
, AC.DESCRIPTION ADMISSION_CD_DESC
, APAIAV.BASIS_FOR_ADMISSION_TYPE BASIS_FOR_ADMISSION_TYPE
, ABFA.DESCRIPTION BASIS_FOR_ADMISSION_TYPE_DESC
FROM IGS_AD_PS_APPL_INST_APLINST_V APAIAV
, IGS_CA_INST_ADM_PERD_V CIAPV
, IGS_AD_APPL AA
, IGS_AD_CD AC
, IGS_AD_BASIS_FOR_AD ABFA
, IGS_LOOKUP_VALUES LKUPV
WHERE /* JOINING THE APPLICATION INSTANCE VIEW
AND CALENDAR RELATION VIEW */ APAIAV.ACAD_CAL_TYPE = CIAPV.ACAD_CAL_TYPE
AND APAIAV.ACAD_CI_SEQUENCE_NUMBER = CIAPV.ACAD_CI_SEQUENCE_NUMBER
AND APAIAV.ADM_CAL_TYPE = CIAPV.ADM_CAL_TYPE
AND APAIAV.ADM_CI_SEQUENCE_NUMBER = CIAPV.ADM_CI_SEQUENCE_NUMBER
AND /* JOINING THE APPLICATION INSTANCE VIEW
AND APPLICATION SESSION DETAILS VIEW */ APAIAV.PERSON_ID = AA.PERSON_ID
AND APAIAV.ADMISSION_APPL_NUMBER = AA.ADMISSION_APPL_NUMBER
AND /* JOINING THE APPLICATION INSTANCE VIEW
AND ADMISSION CODE TABLE */ APAIAV.ADMISSION_CD = AC.ADMISSION_CD (+)
AND /* JOINING THE APPLICATION INSTANCE VIEW
AND BASIS FOR ADMISSION TYPE TABLE */ APAIAV.BASIS_FOR_ADMISSION_TYPE = ABFA.BASIS_FOR_ADMISSION_TYPE (+)
AND LKUPV.LOOKUP_CODE (+) = AA.S_ADMISSION_PROCESS_TYPE
AND LKUPV.LOOKUP_TYPE (+) = 'ADMISSION_PROCESS_TYPE'