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_TR_TYPE_V

Product:	IGS - Student System (Obsolete)
Description:	This is the form view for a tracking types table
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT TT.ROWID ROW_ID
, TT.ORG_ID
, TT.TRACKING_TYPE
, TT.DESCRIPTION
, TT.S_TRACKING_TYPE
, LKUP.MEANING S_TRACKING_TYPE_DESC
, TT.TARGET_DAYS
, TT.SEQUENCE_IND
, TT.BUSINESS_DAYS_IND
, TT.CLOSED_IND
, TT.PUBLISH_IND
, NULL
, NULL
, TT.CREATED_BY
, TT.CREATION_DATE
, TT.LAST_UPDATED_BY
, TT.LAST_UPDATE_DATE
, TT.LAST_UPDATE_LOGIN
FROM IGS_TR_TYPE TT
, IGS_LOOKUP_VALUES LKUP
WHERE LKUP.LOOKUP_TYPE = 'TRACKING_TYPE'
AND TT.S_TRACKING_TYPE = LKUP.LOOKUP_CODE

Columns

Name
ROW_ID
ORG_ID
TRACKING_TYPE
DESCRIPTION
S_TRACKING_TYPE
S_TRACKING_TYPE_DESC
TARGET_DAYS
SEQUENCE_IND
BUSINESS_DAYS_IND
CLOSED_IND
PUBLISH_IND
S_TRACKING_USED_BY
DESC_USED_BY
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN