Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This is the full view for the entity Calendar Periods that describes an instance of a calendar type. |
Implementation/DBA Data: | Not implemented in this database |
SELECT IN1.CAL_TYPE
, IN1.SEQUENCE_NUMBER
, IN1.START_DT
, IN1.END_DT
, IN1.CAL_STATUS
, IN1.ALTERNATE_CODE
, IN1.SS_DISPLAYED
, IN1.IVR_DISPLAY_IND
, IN1.SUP_CAL_STATUS_DIFFER_IND
, IN1.DESCRIPTION
, IN1.PRIOR_CI_SEQUENCE_NUMBER
, IN2.ALTERNATE_CODE
, IN2.START_DT
, IN2.END_DT
, TY3.DESCRIPTION
, ST4.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
, IGS_CA_STAT ST4
WHERE IN1.CAL_TYPE = TY3.CAL_TYPE
AND IN1.CAL_STATUS = ST4.CAL_STATUS
AND IN1.CAL_TYPE = IN2.CAL_TYPE (+)
AND IN1.PRIOR_CI_SEQUENCE_NUMBER = IN2.SEQUENCE_NUMBER (+) WITH READ ONLY