[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | This view is used to capture all the details regarding a Timeslot Setup. |
| Implementation/DBA Data: | Not implemented in this database |
SELECT ETS.ROWID ROW_ID
, ETS.ORG_ID ORG_ID
, ETS.IGS_EN_TIMESLOT_STUP_ID IGS_EN_TIMESLOT_STUP_ID
, ETS.PROGRAM_TYPE_GROUP_CD PROGRAM_TYPE_GROUP_CD
, PTG.DESCRIPTION PROGRAM_TYPE_GROUP
, ETS.CAL_TYPE CAL_TYPE
, CT.DESCRIPTION CAL_TYPE_DESC
, ETS.SEQUENCE_NUMBER SEQUENCE_NUMBER
, CI.ALTERNATE_CODE ALTERNATE_CD
, CI.START_DT START_DT
, CI.END_DT END_DT
, ETS.STUDENT_TYPE STUDENT_TYPE
, LKUP.MEANING STUDENT_TYPE_MEANING
, ETS.SURNAME_ALPHABET SURNAME_ALPHABET
, ETS.ASSIGN_RANDOMLY ASSIGN_RANDOMLY
, ETS.CREATED_BY CREATED_BY
, ETS.CREATION_DATE CREATION_DATE
, ETS.LAST_UPDATED_BY LAST_UPDATED_BY
, ETS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ETS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_CA_TYPE CT
, IGS_CA_INST CI
, IGS_PS_TYPE_GRP PTG
, IGS_LOOKUPS_VIEW LKUP
, IGS_EN_TIMESLOT_STUP ETS
WHERE ETS.CAL_TYPE = CI.CAL_TYPE
AND ETS.SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND ETS.PROGRAM_TYPE_GROUP_CD = PTG.COURSE_TYPE_GROUP_CD
AND (LKUP.LOOKUP_TYPE = 'TIMESLOT_STUDENT_TYPE'
AND ETS.STUDENT_TYPE = LKUP.LOOKUP_CODE)
AND CT.CAL_TYPE = CI.CAL_TYPE
AND CI.CAL_STATUS IN ('ACTIVE'
, 'PLANNED')
AND CT.S_CAL_CAT IN ( 'TEACHING'
, 'LOAD')
AND NVL (ETS.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)