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

Product:	IGS - Student System (Obsolete)
Description:	The view selects all the columns related to Timeslot Preferences.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT ETP.ROWID ROW_ID
, ETP.IGS_EN_TIMESLOT_PREF_ID IGS_EN_TIMESLOT_PREF_ID
, ETP.IGS_EN_TIMESLOT_PRTY_ID IGS_EN_TIMESLOT_PRTY_ID
, ETP.PREFERENCE_ORDER PREFERENCE_ORDER
, ETP.PREFERENCE_CODE PREFERENCE_CODE
, ETP.PREFERENCE_VERSION PREFERENCE_VERSION
, ETP.SEQUENCE_NUMBER SEQUENCE_NUMBER
, PT.DESCRIPTION DESCRIPTION
, ETP.CREATED_BY CREATED_BY
, ETP.CREATION_DATE CREATION_DATE
, ETP.LAST_UPDATED_BY LAST_UPDATED_BY
, ETP.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ETP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_EN_TIMESLOT_PREF ETP
, IGS_EN_TIMESLOT_PRTY ETPY
, IGS_PS_TYPE PT
WHERE ETP.IGS_EN_TIMESLOT_PRTY_ID = ETPY.IGS_EN_TIMESLOT_PRTY_ID
AND ETPY.PRIORITY_VALUE = 'PROG_TYPE'
AND PT.COURSE_TYPE = ETP.PREFERENCE_CODE UNION SELECT ETP.ROWID ROW_ID
, ETP.IGS_EN_TIMESLOT_PREF_ID IGS_EN_TIMESLOT_PREF_ID
, ETP.IGS_EN_TIMESLOT_PRTY_ID IGS_EN_TIMESLOT_PRTY_ID
, ETP.PREFERENCE_ORDER PREFERENCE_ORDER
, ETP.PREFERENCE_CODE PREFERENCE_CODE
, ETP.PREFERENCE_VERSION PREFERENCE_VERSION
, ETP.SEQUENCE_NUMBER SEQUENCE_NUMBER
, OU.DESCRIPTION DESCRIPTION
, ETP.CREATED_BY CREATED_BY
, ETP.CREATION_DATE CREATION_DATE
, ETP.LAST_UPDATED_BY LAST_UPDATED_BY
, ETP.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ETP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_EN_TIMESLOT_PREF ETP
, IGS_EN_TIMESLOT_PRTY ETPY
, IGS_OR_UNIT OU
WHERE ETP.IGS_EN_TIMESLOT_PRTY_ID = ETPY.IGS_EN_TIMESLOT_PRTY_ID
AND ETPY.PRIORITY_VALUE = 'ORG_UNIT'
AND OU.ORG_UNIT_CD = ETP.PREFERENCE_CODE UNION SELECT ETP.ROWID ROW_ID
, ETP.IGS_EN_TIMESLOT_PREF_ID IGS_EN_TIMESLOT_PREF_ID
, ETP.IGS_EN_TIMESLOT_PRTY_ID IGS_EN_TIMESLOT_PRTY_ID
, ETP.PREFERENCE_ORDER PREFERENCE_ORDER
, ETP.PREFERENCE_CODE PREFERENCE_CODE
, ETP.PREFERENCE_VERSION PREFERENCE_VERSION
, ETP.SEQUENCE_NUMBER SEQUENCE_NUMBER
, PV.TITLE DESCRIPTION
, ETP.CREATED_BY CREATED_BY
, ETP.CREATION_DATE CREATION_DATE
, ETP.LAST_UPDATED_BY LAST_UPDATED_BY
, ETP.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ETP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_EN_TIMESLOT_PREF ETP
, IGS_EN_TIMESLOT_PRTY ETPY
, IGS_PS_VER PV
WHERE ETP.IGS_EN_TIMESLOT_PRTY_ID = ETPY.IGS_EN_TIMESLOT_PRTY_ID
AND ETPY.PRIORITY_VALUE = 'PROGRAM'
AND PV.COURSE_CD = ETP.PREFERENCE_CODE
AND PV.VERSION_NUMBER = ETP.PREFERENCE_VERSION UNION SELECT ETP.ROWID ROW_ID
, ETP.IGS_EN_TIMESLOT_PREF_ID IGS_EN_TIMESLOT_PREF_ID
, ETP.IGS_EN_TIMESLOT_PRTY_ID IGS_EN_TIMESLOT_PRTY_ID
, ETP.PREFERENCE_ORDER PREFERENCE_ORDER
, ETP.PREFERENCE_CODE PREFERENCE_CODE
, ETP.PREFERENCE_VERSION PREFERENCE_VERSION
, ETP.SEQUENCE_NUMBER SEQUENCE_NUMBER
, PPG.DESCRIPTION DESCRIPTION
, ETP.CREATED_BY CREATED_BY
, ETP.CREATION_DATE CREATION_DATE
, ETP.LAST_UPDATED_BY LAST_UPDATED_BY
, ETP.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ETP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_EN_TIMESLOT_PREF ETP
, IGS_EN_TIMESLOT_PRTY ETPY
, IGS_PE_PERSID_GROUP PPG
WHERE ETP.IGS_EN_TIMESLOT_PRTY_ID = ETPY.IGS_EN_TIMESLOT_PRTY_ID
AND ETPY.PRIORITY_VALUE = 'PERSON_GRP'
AND PPG.GROUP_CD = ETP.PREFERENCE_CODE UNION SELECT ETP.ROWID ROW_ID
, ETP.IGS_EN_TIMESLOT_PREF_ID IGS_EN_TIMESLOT_PREF_ID
, ETP.IGS_EN_TIMESLOT_PRTY_ID IGS_EN_TIMESLOT_PRTY_ID
, ETP.PREFERENCE_ORDER PREFERENCE_ORDER
, ETP.PREFERENCE_CODE PREFERENCE_CODE
, ETP.PREFERENCE_VERSION PREFERENCE_VERSION
, ETP.SEQUENCE_NUMBER SEQUENCE_NUMBER
, PST.DESCRIPTION DESCRIPTION
, ETP.CREATED_BY CREATED_BY
, ETP.CREATION_DATE CREATION_DATE
, ETP.LAST_UPDATED_BY LAST_UPDATED_BY
, ETP.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ETP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_EN_TIMESLOT_PREF ETP
, IGS_EN_TIMESLOT_PRTY ETPY
, IGS_PS_STAGE_TYPE PST
WHERE ETP.IGS_EN_TIMESLOT_PRTY_ID = ETPY.IGS_EN_TIMESLOT_PRTY_ID
AND ETPY.PRIORITY_VALUE = 'PROG_STAGE'
AND PST.COURSE_STAGE_TYPE = ETP.PREFERENCE_CODE UNION SELECT ETP.ROWID ROW_ID
, ETP.IGS_EN_TIMESLOT_PREF_ID IGS_EN_TIMESLOT_PREF_ID
, ETP.IGS_EN_TIMESLOT_PRTY_ID IGS_EN_TIMESLOT_PRTY_ID
, ETP.PREFERENCE_ORDER PREFERENCE_ORDER
, ETP.PREFERENCE_CODE PREFERENCE_CODE
, ETP.PREFERENCE_VERSION PREFERENCE_VERSION
, ETP.SEQUENCE_NUMBER SEQUENCE_NUMBER
, LKUP.MEANING DESCRIPTION
, ETP.CREATED_BY CREATED_BY
, ETP.CREATION_DATE CREATION_DATE
, ETP.LAST_UPDATED_BY LAST_UPDATED_BY
, ETP.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ETP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_EN_TIMESLOT_PREF ETP
, IGS_EN_TIMESLOT_PRTY ETPY
, IGS_LOOKUPS_VIEW LKUP
WHERE ETP.IGS_EN_TIMESLOT_PRTY_ID = ETPY.IGS_EN_TIMESLOT_PRTY_ID
AND ETPY.PRIORITY_VALUE IN ('TOTAL_CP'
, 'GPA')
AND LKUP.LOOKUP_CODE = ETP.PREFERENCE_CODE
AND LKUP.LOOKUP_TYPE = 'ASC_DESC' UNION SELECT ETP.ROWID ROW_ID
, ETP.IGS_EN_TIMESLOT_PREF_ID IGS_EN_TIMESLOT_PREF_ID
, ETP.IGS_EN_TIMESLOT_PRTY_ID IGS_EN_TIMESLOT_PRTY_ID
, ETP.PREFERENCE_ORDER PREFERENCE_ORDER
, ETP.PREFERENCE_CODE PREFERENCE_CODE
, ETP.PREFERENCE_VERSION PREFERENCE_VERSION
, ETP.SEQUENCE_NUMBER SEQUENCE_NUMBER
, CT.DESCRIPTION DESCRIPTION
, ETP.CREATED_BY CREATED_BY
, ETP.CREATION_DATE CREATION_DATE
, ETP.LAST_UPDATED_BY LAST_UPDATED_BY
, ETP.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ETP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_EN_TIMESLOT_PREF ETP
, IGS_EN_TIMESLOT_PRTY ETPY
, IGS_CA_INST CI
, IGS_CA_TYPE CT
WHERE ETP.IGS_EN_TIMESLOT_PRTY_ID = ETPY.IGS_EN_TIMESLOT_PRTY_ID
AND ETPY.PRIORITY_VALUE IN ('ENRCP_ASC'
, 'ENRCP_DESC')
AND CI.CAL_TYPE = ETP.PREFERENCE_CODE
AND CI.SEQUENCE_NUMBER = ETP.SEQUENCE_NUMBER
AND CI.CAL_TYPE = CT.CAL_TYPE

Columns

Name
ROW_ID
IGS_EN_TIMESLOT_PREF_ID
IGS_EN_TIMESLOT_PRTY_ID
PREFERENCE_ORDER
PREFERENCE_CODE
PREFERENCE_VERSION
SEQUENCE_NUMBER
DESCRIPTION
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN