Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This entity contains information about the person's academic history. |
Implementation/DBA Data: | Not implemented in this database |
SELECT HP.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
, 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 HP
WHERE ACH.EDUCATION_ID=HZE.EDUCATION_ID
AND HZE.SCHOOL_PARTY_ID = HP.PARTY_ID (+) WITH READ ONLY