Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This view contains the preferences for a given priority for reserved seating at Unit Offering Pattern Level. Case and Seed document: PS201_Enhancments_Nov03_PS_3045069_CS_DP2.doc - Obsolete |
Implementation/DBA Data: | Not implemented in this database |
SELECT RUPF.ROWID
, RUPF.RSV_UOP_PRF_ID
, RUPF.RSV_UOP_PRI_ID
, RUPF.PREFERENCE_ORDER
, RUPF.PREFERENCE_CODE
, RUPF.PREFERENCE_VERSION
, OU.PARTY_NAME DESCRIPTION
, RUPF.PERCENTAGE_RESERVED
, RUPF.GROUP_ID
, RUPF.CREATED_BY
, RUPF.CREATION_DATE
, RUPF.LAST_UPDATED_BY
, RUPF.LAST_UPDATE_DATE
, RUPF.LAST_UPDATE_LOGIN FROM IGS_PS_RSV_UOP_PRF RUPF
, IGS_OR_INST_ORG_BASE_V OU
, IGS_PS_RSV_UOP_PRI RUPR
WHERE OU.PARTY_NUMBER = RUPF.PREFERENCE_CODE
AND RUPF.RSV_UOP_PRI_ID = RUPR.RSV_UOP_PRI_ID
AND RUPR.PRIORITY_VALUE = 'ORG_UNIT' UNION SELECT RUPF.ROWID
, RUPF.RSV_UOP_PRF_ID
, RUPF.RSV_UOP_PRI_ID
, RUPF.PREFERENCE_ORDER
, RUPF.PREFERENCE_CODE
, RUPF.PREFERENCE_VERSION
, PV.TITLE
, RUPF.PERCENTAGE_RESERVED
, RUPF.GROUP_ID
, RUPF.CREATED_BY
, RUPF.CREATION_DATE
, RUPF.LAST_UPDATED_BY
, RUPF.LAST_UPDATE_DATE
, RUPF.LAST_UPDATE_LOGIN FROM IGS_PS_RSV_UOP_PRF RUPF
, IGS_PS_VER PV
, IGS_PS_RSV_UOP_PRI RUPR
WHERE PV.COURSE_CD = RUPF.PREFERENCE_CODE
AND PV.VERSION_NUMBER = RUPF.PREFERENCE_VERSION
AND RUPF.RSV_UOP_PRI_ID = RUPR.RSV_UOP_PRI_ID
AND RUPR.PRIORITY_VALUE = 'PROGRAM' UNION SELECT RUPF.ROWID
, RUPF.RSV_UOP_PRF_ID
, RUPF.RSV_UOP_PRI_ID
, RUPF.PREFERENCE_ORDER
, RUPF.PREFERENCE_CODE
, RUPF.PREFERENCE_VERSION
, PST.DESCRIPTION
, RUPF.PERCENTAGE_RESERVED
, RUPF.GROUP_ID
, RUPF.CREATED_BY
, RUPF.CREATION_DATE
, RUPF.LAST_UPDATED_BY
, RUPF.LAST_UPDATE_DATE
, RUPF.LAST_UPDATE_LOGIN FROM IGS_PS_RSV_UOP_PRF RUPF
, IGS_PS_STAGE_TYPE PST
, IGS_PS_RSV_UOP_PRI RUPR
WHERE PST.COURSE_STAGE_TYPE = RUPF.PREFERENCE_CODE
AND RUPF.RSV_UOP_PRI_ID = RUPR.RSV_UOP_PRI_ID
AND RUPR.PRIORITY_VALUE = 'PROGRAM_STAGE' UNION SELECT RUPF.ROWID
, RUPF.RSV_UOP_PRF_ID
, RUPF.RSV_UOP_PRI_ID
, RUPF.PREFERENCE_ORDER
, RUPF.PREFERENCE_CODE
, RUPF.PREFERENCE_VERSION
, EUS.TITLE
, RUPF.PERCENTAGE_RESERVED
, RUPF.GROUP_ID
, RUPF.CREATED_BY
, RUPF.CREATION_DATE
, RUPF.LAST_UPDATED_BY
, RUPF.LAST_UPDATE_DATE
, RUPF.LAST_UPDATE_LOGIN FROM IGS_PS_RSV_UOP_PRF RUPF
, IGS_EN_UNIT_SET EUS
, IGS_PS_RSV_UOP_PRI RUPR
WHERE EUS.UNIT_SET_CD= RUPF.PREFERENCE_CODE
AND EUS.VERSION_NUMBER = RUPF.PREFERENCE_VERSION
AND RUPF.RSV_UOP_PRI_ID = RUPR.RSV_UOP_PRI_ID
AND RUPR.PRIORITY_VALUE = 'UNIT_SET' UNION SELECT RUPF.ROWID
, RUPF.RSV_UOP_PRF_ID
, RUPF.RSV_UOP_PRI_ID
, RUPF.PREFERENCE_ORDER
, RUPF.PREFERENCE_CODE
, RUPF.PREFERENCE_VERSION
, PPG.DESCRIPTION
, RUPF.PERCENTAGE_RESERVED
, RUPF.GROUP_ID
, RUPF.CREATED_BY
, RUPF.CREATION_DATE
, RUPF.LAST_UPDATED_BY
, RUPF.LAST_UPDATE_DATE
, RUPF.LAST_UPDATE_LOGIN FROM IGS_PS_RSV_UOP_PRF RUPF
, IGS_PE_PERSID_GROUP PPG
, IGS_PS_RSV_UOP_PRI RUPR
WHERE PPG.GROUP_ID = RUPF.GROUP_ID
AND RUPF.RSV_UOP_PRI_ID = RUPR.RSV_UOP_PRI_ID
AND RUPR.PRIORITY_VALUE = 'PERSON_GRP'