eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGS_AV_ACAD_HISTORY_V

Product:	IGS - Student System (Obsolete)
Description:	This view contains the Academic History of the student.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT HE.ROWID ROW_ID
, HE.PARTY_ID PERSON_ID
, HE.EDUCATION_ID
, DECODE (HE.SCHOOL_PARTY_ID
, NULL
, NULL
, (SELECT PHP.OSS_ORG_UNIT_CD
FROM IGS_PE_HZ_PARTIES PHP
WHERE HE.SCHOOL_PARTY_ID = PHP.PARTY_ID) ) INSTITUTION_CODE
, T.TRANSCRIPT_ID
, D.TERM_DETAILS_ID
, LK.MEANING "TERM_TYPE_MEANING"
, D.TERM
, E.UNIT_DETAILS_ID
, E.UNIT
, E.UNIT_NAME
, E.GRADE
, E.CP_EARNED
, HE.CREATED_BY
, HE.CREATION_DATE
, HE.LAST_UPDATED_BY
, HE.LAST_UPDATE_DATE
, HE.LAST_UPDATE_LOGIN
, T.DATE_OF_ISSUE
, HE.STATUS
FROM HZ_EDUCATION HE
, HZ_PARTIES P
, IGS_AD_TRANSCRIPT T
, IGS_AD_TERM_DETAILS D
, IGS_LOOKUPS_VIEW LK
, IGS_AD_TERM_UNITDTLS E
WHERE HE.EDUCATION_ID = T.EDUCATION_ID
AND T.TRANSCRIPT_ID = D.TRANSCRIPT_ID
AND T.TERM_TYPE = LK.LOOKUP_CODE
AND LK.LOOKUP_TYPE = 'TERM_TYPE'
AND D.TERM_DETAILS_ID = E.TERM_DETAILS_ID
AND P.PARTY_ID = HE.SCHOOL_PARTY_ID

Columns

Name
ROW_ID
PERSON_ID
EDUCATION_ID
INSTITUTION_CODE
TRANSCRIPT_ID
TERM_DETAILS_ID
TERM_TYPE_MEANING
TERM
UNIT_DETAILS_ID
UNIT
UNIT_NAME
GRADE
CP_EARNED
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
DATE_OF_ISSUE
STATUS