VIEW: APPS.IGSFV_PERSON_EDUCATION_EXTS

Source

View Text - Preformatted

SELECT HAH.CURRENT_INST CURRENT_INSTITUTION, HAH.PROGRAM_TYPE_ATTEMPTED, HAH.COMMENTS NOTES, HAH.PLANNED_COMPLETION_DATE, HAH.RECALC_TOTAL_CP_ATTEMPTED, HAH.RECALC_TOTAL_CP_EARNED, HAH.RECALC_TOTAL_UNIT_GP RECALC_TOTAL_UNIT_GRADE_POINT, HAH.RECALC_TOT_GPA_UTS_ATTEMPTED, HAH.RECALC_INST_GPA RECALC_INSTITUTION_GPA, HAH.SELFREP_TOTAL_CP_ATTEMPTED, HAH.SELFREP_TOTAL_CP_EARNED, HAH.SELFREP_TOTAL_UNIT_GP SELFREP_TOTAL_UNIT_GRADE_POINT, HAH.SELFREP_TOT_GPA_UTS_ATTEMP SELFREP_TOT_GPA_UTS_ATTEMPTED, HAH.SELFREP_INST_GPA SELFREP_INSTITUTION_GPA, HAH.SELFREP_WEIGHTED_GPA SELFREP_WEIGHTED_GPA_INDICATOR, HAH.SELFREP_RANK_IN_CLASS, HAH.SELFREP_WEIGHED_RANK SELFREP_WEIGHED_RANK_INDICATOR, HAH.SELFREP_CLASS_SIZE, HAH.TRANSCRIPT_REQUIRED TRANSCRIPT_REQUIRED_INDICATOR, '_DF:IGS:IGS_AD_ACAD_HISTORY_FLEX:HAH', HP1.PARTY_NUMBER PERSON_NUMBER, HP2.PARTY_NAME INSTITUTION_NAME, CC1.NAME RECALC_GRAD_SCALE_TYPE, CC1.DESCRIPTION RECALC_GRAD_SCALE_TYPE_DESC, CC2.NAME SELFREP_GRAD_SCALE_TYPE, CC2.DESCRIPTION SELFREP_GRAD_SCALE_TYPE_DESC, HAH.HZ_ACAD_HIST_ID, HAH.EDUCATION_ID, HAH.RECALC_GRADING_SCALE_ID, HAH.SELFREP_GRADING_SCALE_ID, HAH.CREATED_BY, HAH.CREATION_DATE, HAH.LAST_UPDATED_BY, HAH.LAST_UPDATE_DATE FROM IGS_AD_HZ_ACAD_HIST HAH, HZ_EDUCATION HE, HZ_PARTIES HP1, HZ_PARTIES HP2, IGS_AD_CODE_CLASSES CC1, IGS_AD_CODE_CLASSES CC2 WHERE HAH.EDUCATION_ID = HE.EDUCATION_ID AND HE.PARTY_ID = HP1.PARTY_ID AND HE.SCHOOL_PARTY_ID = HP2.PARTY_ID AND HAH.RECALC_GRADING_SCALE_ID = CC1.CODE_ID(+) AND HAH.SELFREP_GRADING_SCALE_ID = CC2.CODE_ID(+) WITH READ ONLY

View Text - HTML Formatted

SELECT HAH.CURRENT_INST CURRENT_INSTITUTION
, HAH.PROGRAM_TYPE_ATTEMPTED
, HAH.COMMENTS NOTES
, HAH.PLANNED_COMPLETION_DATE
, HAH.RECALC_TOTAL_CP_ATTEMPTED
, HAH.RECALC_TOTAL_CP_EARNED
, HAH.RECALC_TOTAL_UNIT_GP RECALC_TOTAL_UNIT_GRADE_POINT
, HAH.RECALC_TOT_GPA_UTS_ATTEMPTED
, HAH.RECALC_INST_GPA RECALC_INSTITUTION_GPA
, HAH.SELFREP_TOTAL_CP_ATTEMPTED
, HAH.SELFREP_TOTAL_CP_EARNED
, HAH.SELFREP_TOTAL_UNIT_GP SELFREP_TOTAL_UNIT_GRADE_POINT
, HAH.SELFREP_TOT_GPA_UTS_ATTEMP SELFREP_TOT_GPA_UTS_ATTEMPTED
, HAH.SELFREP_INST_GPA SELFREP_INSTITUTION_GPA
, HAH.SELFREP_WEIGHTED_GPA SELFREP_WEIGHTED_GPA_INDICATOR
, HAH.SELFREP_RANK_IN_CLASS
, HAH.SELFREP_WEIGHED_RANK SELFREP_WEIGHED_RANK_INDICATOR
, HAH.SELFREP_CLASS_SIZE
, HAH.TRANSCRIPT_REQUIRED TRANSCRIPT_REQUIRED_INDICATOR
, '_DF:IGS:IGS_AD_ACAD_HISTORY_FLEX:HAH'
, HP1.PARTY_NUMBER PERSON_NUMBER
, HP2.PARTY_NAME INSTITUTION_NAME
, CC1.NAME RECALC_GRAD_SCALE_TYPE
, CC1.DESCRIPTION RECALC_GRAD_SCALE_TYPE_DESC
, CC2.NAME SELFREP_GRAD_SCALE_TYPE
, CC2.DESCRIPTION SELFREP_GRAD_SCALE_TYPE_DESC
, HAH.HZ_ACAD_HIST_ID
, HAH.EDUCATION_ID
, HAH.RECALC_GRADING_SCALE_ID
, HAH.SELFREP_GRADING_SCALE_ID
, HAH.CREATED_BY
, HAH.CREATION_DATE
, HAH.LAST_UPDATED_BY
, HAH.LAST_UPDATE_DATE
FROM IGS_AD_HZ_ACAD_HIST HAH
, HZ_EDUCATION HE
, HZ_PARTIES HP1
, HZ_PARTIES HP2
, IGS_AD_CODE_CLASSES CC1
, IGS_AD_CODE_CLASSES CC2
WHERE HAH.EDUCATION_ID = HE.EDUCATION_ID
AND HE.PARTY_ID = HP1.PARTY_ID
AND HE.SCHOOL_PARTY_ID = HP2.PARTY_ID
AND HAH.RECALC_GRADING_SCALE_ID = CC1.CODE_ID(+)
AND HAH.SELFREP_GRADING_SCALE_ID = CC2.CODE_ID(+) WITH READ ONLY