View: IGS_AD_KEY_ACAD_IND_V

View Text

SELECT PAI.ROW_ID ROW_ID
, PAI.PERSON_ID PERSON_ID
, PAI.ADMISSION_APPL_NUMBER ADMISSION_APPL_NUMBER
, PAI.NOMINATED_COURSE_CD NOMINATED_COURSE_CD
, PAI.SEQUENCE_NUMBER SEQUENCE_NUMBER
, PAI.COURSE_CD PROGRAM_ADMITTED
, PV.TITLE PROGRAM_TITLE
, PAI.UNIT_SET_CD UNIT_SET_ADMITTED
, PAI.PREDICTED_GPA
, PAI.ACADEMIC_INDEX ACADEMIC_INDEX
, PAI.ADM_OUTCOME_STATUS ADM_OUTCOME_STATUS
, APPL.ADM_APPL_STATUS ADM_APPL_STATUS
, ACAD.INSTITUTION_CODE INSTITUTION_CODE
, INST.NAME INSTITUTION_NAME
, ACAD.RECALC_INST_GPA INST_GRADE_POINT_AVERAGE
, TR.RANK_IN_CLASS RANK_IN_CLASS
, TR.ENTERED_GPA GRADE_POINT_AVERAGE
, US.UNIT_SET_CD FIRST_CHOICE_UNIT_SET
, PAI.CREATED_BY CREATED_BY
, PAI.CREATION_DATE CREATION_DATE
, PAI.LAST_UPDATED_BY LAST_UPDATED_BY
, PAI.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PAI.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PAI.REQUEST_ID REQUEST_ID
, PAI.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PAI.PROGRAM_ID PROGRAM_ID
, PAI.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, TR. CORE_CURRICULUM_VALUE CORE_CURRICULUM_VALUE
FROM IGS_AD_PS_APPL_INST PAI
, IGS_AD_APPL APPL
, IGS_AD_ACAD_HISTORY_V ACAD
, IGS_OR_INSTITUTION INST
, IGS_AD_TRANSCRIPT TR
, IGS_AD_UNIT_SETS US
, IGS_PS_VER PV
WHERE PAI.COURSE_CD = PV.COURSE_CD
AND PAI.CRV_VERSION_NUMBER = PV.VERSION_NUMBER
AND PAI.PERSON_ID = APPL.PERSON_ID
AND PAI.ADMISSION_APPL_NUMBER = APPL.ADMISSION_APPL_NUMBER
AND PAI.PERSON_ID = ACAD.PERSON_ID (+)
AND ACAD.INSTITUTION_CODE = INST.INSTITUTION_CD (+)
AND ACAD.EDUCATION_ID = TR.EDUCATION_ID (+)
AND NVL(ACAD.CURRENT_INST (+)
, 'N') = 'Y'
AND PAI.PERSON_ID = US.PERSON_ID (+)
AND PAI.ADMISSION_APPL_NUMBER = US.ADMISSION_APPL_NUMBER (+)
AND PAI.NOMINATED_COURSE_CD = US.NOMINATED_COURSE_CD (+)
AND PAI.SEQUENCE_NUMBER = US.SEQUENCE_NUMBER (+)
AND US.RANK (+)=1

Columns