VIEW: APPS.IGS_AD_KEY_ACAD_IND_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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