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_AD_TER_ED_UNI_AT_V

Product:	IGS - Student System (Obsolete)
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT ATEUA.ROWID ROW_ID
, ATEUA.PERSON_ID PERSON_ID
, ATEUA.TE_SEQUENCE_NUMBER TE_SEQUENCE_NUMBER
, ATEUA.SEQUENCE_NUMBER SEQUENCE_NUMBER
, ATEUA.ENROLLED_YR ENROLLED_YR
, ATEUA.UNIT_CD UNIT_CD
, ATEUA.TITLE TITLE
, ATEUA.CREDIT_POINTS CREDIT_POINTS
, ATEUA.GRADE GRADE
, ATEUA.RESULT_TYPE RESULT_TYPE
, LKUPV.MEANING MEANING
, ATEUA.DISCIPLINE_GROUP_CD DISCIPLINE_GROUP_CD
, DI.DESCRIPTION DESCRIPTION
, DI.CLOSED_IND CLOSED_IND
, ATEUA.CREATED_BY CREATED_BY
, ATEUA.CREATION_DATE CREATION_DATE
, ATEUA.LAST_UPDATED_BY LAST_UPDATED_BY
, ATEUA.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ATEUA.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_AD_TER_ED_UNI_AT ATEUA
, IGS_PS_DSCP DI
, IGS_LOOKUPS_VIEW LKUPV
WHERE LKUPV.LOOKUP_CODE = ATEUA.RESULT_TYPE AND LKUPV.LOOKUP_TYPE = 'RESULT_TYPE'
AND ATEUA.DISCIPLINE_GROUP_CD = DI.DISCIPLINE_GROUP_CD

Columns

Name
ROW_ID
PERSON_ID
TE_SEQUENCE_NUMBER
SEQUENCE_NUMBER
ENROLLED_YR
UNIT_CD
TITLE
CREDIT_POINTS
GRADE
RESULT_TYPE
MEANING
DISCIPLINE_GROUP_CD
DESCRIPTION
CLOSED_IND
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN