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

Product:	IGS - Student System (Obsolete)
Description:	This is the full view for the entity Calendar Period Types which describes available calendar types.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT CA.CAL_TYPE
, CA.DESCRIPTION
, '_LA:CA.S_CAL_CAT:IGS_LOOKUP_VALUES:CAL_CAT:MEANING'
, CA.ABBREVIATION
, CA.ARTS_TEACHING_CAL_TYPE_CD
, CA.CLOSED_IND
, CA.NOTES
, AR1.DESCRIPTION
, CA.CREATED_BY
, CA.CREATION_DATE
, CA.LAST_UPDATED_BY
, CA.LAST_UPDATE_DATE
FROM IGS_CA_TYPE CA
, IGS_CA_ARTS_TC_CA_CD AR1
WHERE AR1.ARTS_TEACHING_CAL_TYPE_CD(+) = CA.ARTS_TEACHING_CAL_TYPE_CD WITH READ ONLY

Columns

Name
CALENDAR_TYPE
DESCRIPTION
"_LA:S_CALENDAR_CATEGORY"
ABBREVIATION
ARTS_TEACHING_CAL_TYPE_CD
CLOSED_INDICATOR
NOTES
ARTS_TEACHING_CAL_TYPE_DESC
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE