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 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