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

Product:	IGS - Student System (Obsolete)
Description:	This is the base view for the entity Calendar Periods that describes an instance of a calendar type.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT IN1.CAL_TYPE
, IN1.SEQUENCE_NUMBER
, IN1.START_DT
, IN1.END_DT
, IN1.CAL_STATUS
, IN1.ALTERNATE_CODE
, IN1.DESCRIPTION
, IN1.SS_DISPLAYED
, IN1.IVR_DISPLAY_IND
, IN1.PRIOR_CI_SEQUENCE_NUMBER
, IN1.SUP_CAL_STATUS_DIFFER_IND
, IN2.ALTERNATE_CODE
, IN2.START_DT
, IN2.END_DT
, TY3.DESCRIPTION
, IN1.CREATED_BY
, IN1.CREATION_DATE
, IN1.LAST_UPDATED_BY
, IN1.LAST_UPDATE_DATE
FROM IGS_CA_INST_ALL IN1
, IGS_CA_INST_ALL IN2
, IGS_CA_TYPE TY3
WHERE IN1.CAL_TYPE = TY3.CAL_TYPE
AND IN1.CAL_TYPE = IN2.CAL_TYPE(+)
AND IN1.PRIOR_CI_SEQUENCE_NUMBER = IN2.SEQUENCE_NUMBER (+) WITH READ ONLY

Columns

Name
CALENDAR_TYPE
SEQUENCE_NUMBER
START_DATE
END_DATE
CALENDAR_STATUS
ALTERNATE_CODE
DESCRIPTION
SELF_SERVICE_DISPLAYED
IVR_ENABLED
PRIOR_CAL_INST_SEQ_NUM
SUPERIOR_CAL_STAT_DIFF_INDICAT
PRIOR_ALTERNATE_CODE
PRIOR_START_DATE
PRIOR_END_DATE
CALENDAR_DESCRIPTION
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE