VIEW: APPS.IGSFV_ACADEMIC_HISTORIES

Source

View Text - Preformatted

SELECT HZP1.PARTY_NAME SCHOOL_ATTENDED_NAME, HZE.TYPE_OF_SCHOOL, HZE.COURSE_MAJOR, NULL, HZE.DEGREE_RECEIVED, HZE.START_DATE_ATTENDED, HZE.LAST_DATE_ATTENDED, ACH.CURRENT_INST, NULL, ACH.DEGREE_ATTEMPTED, ACH.COMMENTS, ACH.PLANNED_COMPLETION_DATE, ACH.RECALC_TOTAL_CP_ATTEMPTED, ACH.RECALC_TOTAL_CP_EARNED, ACH.RECALC_TOTAL_UNIT_GP, ACH.RECALC_TOT_GPA_UTS_ATTEMPTED, ACH.RECALC_INST_GPA, ACH.SELFREP_TOTAL_CP_ATTEMPTED, ACH.SELFREP_TOTAL_CP_EARNED, ACH.SELFREP_TOTAL_UNIT_GP, ACH.SELFREP_TOT_GPA_UTS_ATTEMP, ACH.SELFREP_INST_GPA, ACH.SELFREP_WEIGHTED_GPA, ACH.SELFREP_RANK_IN_CLASS, ACH.SELFREP_WEIGHED_RANK, ACH.SELFREP_CLASS_SIZE, ACH.TRANSCRIPT_REQUIRED, '_DF:IGS:IGS_AD_ACAD_HISTORY_FLEX:ACH', HZP.PARTY_NUMBER, CC1.NAME, CC2.NAME, ACH.HZ_ACAD_HIST_ID, ACH.EDUCATION_ID, ACH.RECALC_GRADING_SCALE_ID, ACH.SELFREP_GRADING_SCALE_ID, HZE.PARTY_ID, ACH.CREATED_BY, ACH.CREATION_DATE, ACH.LAST_UPDATED_BY, ACH.LAST_UPDATE_DATE FROM IGS_AD_HZ_ACAD_HIST ACH, HZ_EDUCATION HZE, HZ_PARTIES HZP, IGS_AD_CODE_CLASSES CC1, IGS_AD_CODE_CLASSES CC2, HZ_PARTIES HZP1 WHERE ACH.EDUCATION_ID=HZE.EDUCATION_ID AND HZE.PARTY_ID=HZP.PARTY_ID AND HZE.SCHOOL_PARTY_ID = HZP1.PARTY_ID (+) AND ACH.RECALC_GRADING_SCALE_ID = CC1.CODE_ID (+) AND ACH.SELFREP_GRADING_SCALE_ID = CC2.CODE_ID (+) WITH READ ONLY

View Text - HTML Formatted

SELECT HZP1.PARTY_NAME SCHOOL_ATTENDED_NAME
, HZE.TYPE_OF_SCHOOL
, HZE.COURSE_MAJOR
, NULL
, HZE.DEGREE_RECEIVED
, HZE.START_DATE_ATTENDED
, HZE.LAST_DATE_ATTENDED
, ACH.CURRENT_INST
, NULL
, ACH.DEGREE_ATTEMPTED
, ACH.COMMENTS
, ACH.PLANNED_COMPLETION_DATE
, ACH.RECALC_TOTAL_CP_ATTEMPTED
, ACH.RECALC_TOTAL_CP_EARNED
, ACH.RECALC_TOTAL_UNIT_GP
, ACH.RECALC_TOT_GPA_UTS_ATTEMPTED
, ACH.RECALC_INST_GPA
, ACH.SELFREP_TOTAL_CP_ATTEMPTED
, ACH.SELFREP_TOTAL_CP_EARNED
, ACH.SELFREP_TOTAL_UNIT_GP
, ACH.SELFREP_TOT_GPA_UTS_ATTEMP
, ACH.SELFREP_INST_GPA
, ACH.SELFREP_WEIGHTED_GPA
, ACH.SELFREP_RANK_IN_CLASS
, ACH.SELFREP_WEIGHED_RANK
, ACH.SELFREP_CLASS_SIZE
, ACH.TRANSCRIPT_REQUIRED
, '_DF:IGS:IGS_AD_ACAD_HISTORY_FLEX:ACH'
, HZP.PARTY_NUMBER
, CC1.NAME
, CC2.NAME
, ACH.HZ_ACAD_HIST_ID
, ACH.EDUCATION_ID
, ACH.RECALC_GRADING_SCALE_ID
, ACH.SELFREP_GRADING_SCALE_ID
, HZE.PARTY_ID
, ACH.CREATED_BY
, ACH.CREATION_DATE
, ACH.LAST_UPDATED_BY
, ACH.LAST_UPDATE_DATE
FROM IGS_AD_HZ_ACAD_HIST ACH
, HZ_EDUCATION HZE
, HZ_PARTIES HZP
, IGS_AD_CODE_CLASSES CC1
, IGS_AD_CODE_CLASSES CC2
, HZ_PARTIES HZP1
WHERE ACH.EDUCATION_ID=HZE.EDUCATION_ID
AND HZE.PARTY_ID=HZP.PARTY_ID
AND HZE.SCHOOL_PARTY_ID = HZP1.PARTY_ID (+)
AND ACH.RECALC_GRADING_SCALE_ID = CC1.CODE_ID (+)
AND ACH.SELFREP_GRADING_SCALE_ID = CC2.CODE_ID (+) WITH READ ONLY