[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | Obsolete |
| Implementation/DBA Data: | Not implemented in this database |
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