Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This entity contains the data about transactions on special permission request submitted by students. |
Implementation/DBA Data: | Not implemented in this database |
SELECT ENSP.SPL_PERM_REQUEST_ID
, ENSP.DATE_SUBMISSION
, ENSP.AUDIT_THE_COURSE
, '_LA:AUDIT_THE_COURSE:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, ENSP.APPROVAL_STATUS
, ENSP.REASON_FOR_REQUEST
, ENSP.INSTRUCTOR_MORE_INFO
, ENSP.INSTRUCTOR_DENY_INFO
, ENSP.STUDENT_MORE_INFO
, ENSP.TRANSACTION_TYPE
, '_LA:TRANSACTION_TYPE:IGS_LOOKUP_VALUES:SPL_PERM_TRANSCTION_TYPE:MEANING'
, ENSP.REQUEST_TYPE
, ENSP.STUDENT_PERSON_ID
, ENSP.INSTRUCTOR_PERSON_ID
, ENSP.UOO_ID
, ENSP.CREATED_BY
, ENSP.CREATION_DATE
, ENSP.LAST_UPDATED_BY
, ENSP.LAST_UPDATE_DATE
FROM IGS_EN_SPL_PERM ENSP WITH READ ONLY