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_EN_NOTE_TYPE_V

Product:	IGS - Student System (Obsolete)
Description:	This view maintains all the note types that are associated with each system specific enrolment note type for example academic type of enrolment.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT ENT.ROWID ROW_ID
, ENT.ENR_NOTE_TYPE ENR_NOTE_TYPE
, ENT.DESCRIPTION DESCRIPTION
, ENT.S_ENR_NOTE_TYPE S_ENR_NOTE_TYPE
, LKUPS.MEANING MEANING
, ENT.CREATED_BY CREATED_BY
, ENT.CREATION_DATE CREATION_DATE
, ENT.LAST_UPDATED_BY LAST_UPDATED_BY
, ENT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ENT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_EN_NOTE_TYPE ENT
, IGS_LOOKUPS_VIEW LKUPS
WHERE LKUPS.LOOKUP_CODE = ENT.S_ENR_NOTE_TYPE
AND LKUPS.LOOKUP_TYPE ='ENR_NOTE_TYPE'
AND S_ENR_NOTE_TYPE IS NOT NULL UNION SELECT ENT.ROWID ROW_ID
, ENT.ENR_NOTE_TYPE ENR_NOTE_TYPE
, ENT.DESCRIPTION DESCRIPTION
, ENT.S_ENR_NOTE_TYPE S_ENR_NOTE_TYPE
, NULL MEANING
, ENT.CREATED_BY CREATED_BY
, ENT.CREATION_DATE CREATION_DATE
, ENT.LAST_UPDATED_BY LAST_UPDATED_BY
, ENT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ENT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_EN_NOTE_TYPE ENT
WHERE S_ENR_NOTE_TYPE IS NULL

Columns

Name
ROW_ID
ENR_NOTE_TYPE
DESCRIPTION
S_ENR_NOTE_TYPE
MEANING
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN