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_SPL_PERM_V

Product:	IGS - Student System (Obsolete)
Description:	This View contains the latest transaction of special permission request.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT SP.ROWID
, SP.SPL_PERM_REQUEST_ID
, SP.STUDENT_PERSON_ID
, UOO.UNIT_CD
, UOO.VERSION_NUMBER
, UOO.UNIT_CLASS
, UOO.CALL_NUMBER
, UV.TITLE
, SP.UOO_ID
, SP.DATE_SUBMISSION
, SP.AUDIT_THE_COURSE
, SP.INSTRUCTOR_PERSON_ID
, SP.APPROVAL_STATUS
, SP.REASON_FOR_REQUEST
, SP.INSTRUCTOR_MORE_INFO
, SP.INSTRUCTOR_DENY_INFO
, SP.STUDENT_MORE_INFO
, SP.TRANSACTION_TYPE
, LKV.MEANING
, SP.CREATED_BY
, SP.CREATION_DATE
, SP.LAST_UPDATED_BY
, SP.LAST_UPDATE_DATE
, SP.LAST_UPDATE_LOGIN
, UOO.CAL_TYPE
, UOO.CI_SEQUENCE_NUMBER
, CI.DESCRIPTION
, UOO.LOCATION_CD
, SP.REQUEST_TYPE
FROM IGS_EN_SPL_PERM SP
, IGS_PS_UNIT_OFR_OPT UOO
, IGS_PS_UNIT_VER UV
, IGS_LOOKUP_VALUES LKV
, IGS_CA_INST CI
WHERE UV.UNIT_CD = UOO.UNIT_CD
AND UV.VERSION_NUMBER = UOO.VERSION_NUMBER
AND SP.UOO_ID = UOO.UOO_ID
AND SP.TRANSACTION_TYPE (+) = LKV.LOOKUP_CODE
AND LKV.LOOKUP_TYPE = 'SPL_PERM_TRANSCTION_TYPE'
AND CI.CAL_TYPE = UOO.CAL_TYPE
AND CI.SEQUENCE_NUMBER = UOO.CI_SEQUENCE_NUMBER

Columns

Name
ROW_ID
SPL_PERM_REQUEST_ID
STUDENT_PERSON_ID
UNIT_CD
VERSION_NUMBER
UNIT_CLASS
CALL_NUMBER
TITLE
UOO_ID
DATE_SUBMISSION
AUDIT_THE_COURSE
INSTRUCTOR_PERSON_ID
APPROVAL_STATUS
REASON_FOR_REQUEST
INSTRUCTOR_MORE_INFO
INSTRUCTOR_DENY_INFO
STUDENT_MORE_INFO
TRANSACTION_TYPE
TRANSACTION_TYPE_MEANING
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
CAL_TYPE
CI_SEQUENCE_NUMBER
CI_DESCRIPTION
LOCATION_CD
REQUEST_TYPE