Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This view fetches the enrollment deadline dates information for the person and program code |
Implementation/DBA Data: | Not implemented in this database |
SELECT TSRSV.ROWID ROW_ID
, TSRSV.PERSON_ID
, TSPRV.TIMESLOT_CALENDAR
, TSRSV.START_DT_TIME
, TSRSV.END_DT_TIME
, TSPRV.CAL_TYPE
, TSPRV.SEQUENCE_NUMBER
, TSPRV.PROGRAM_TYPE_GROUP_CD
, TSRSV. CREATED_BY
, TSRSV.CREATION_DATE
, TSRSV.LAST_UPDATED_BY
, TSRSV.LAST_UPDATE_DATE
, TSRSV.LAST_UPDATE_LOGIN
, TSRSV.REQUEST_ID
, TSRSV.PROGRAM_APPLICATION_ID
, TSRSV.PROGRAM_ID
, TSRSV.PROGRAM_UPDATE_DATE
FROM IGS_EN_TIMESLOT_RSLT TSRSV
, IGS_EN_TIMESLOT_PARA TSPRV
WHERE TSRSV.IGS_EN_TIMESLOT_PARA_ID = TSPRV.IGS_EN_TIMESLOT_PARA_ID