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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.IGSFV_SPECIAL_PERMISSIONS

Object Details

Object Name:	IGSFV_SPECIAL_PERMISSIONS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGSFV_SPECIAL_PERMISSIONS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

This entity contains the data about transactions on special permission request submitted by students.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
SPECIAL_PERM_REQUEST_ID	NUMBER	(15)	Yes	System generated number to uniquely identify the Special permission request transaction
SUBMISSION_DATE	DATE		Yes	Date of the last transaction, i.e. last date of update of this record
AUDIT_THE_UNIT_FLAG	VARCHAR2	(10)	Yes	Audit this unit, possible values are Y/N, default value is N
_LA:AUDIT_THE_UNIT_DESC	CHAR	(53)		Description of Audit Unit Indicator
APPROVAL_STATUS	VARCHAR2	(10)	Yes	Approval status of the transaction, possible values is M (Need more Information), D (Deny) or A (Approved).
REASON_FOR_REQUEST	VARCHAR2	(4000)	Yes	Reason for the request of the Special permission
INSTRUCTOR_MORE_INFO	VARCHAR2	(4000)		More information needed by instructor on Special permission request
INSTRUCTOR_DENY_INFO	VARCHAR2	(4000)		Instructor reason for deny
STUDENT_MORE_INFO	VARCHAR2	(4000)		More information submitted by the student
TRANSACTION_TYPE	VARCHAR2	(30)		Type of the transaction, stores lookup code corresponding to the transaction.
_LA:TRANSACTION_TYPE_DESC	CHAR	(71)		Description of the Transaction Type
REQUEST_TYPE	VARCHAR2	(10)		Indicates whether the request is for Special permission or for Audit.
STUDENT_PERSON_IDENTIFIER	NUMBER	(15)	Yes	Person ID of the Student
STUDENT_PERSON_NUMBER	VARCHAR2	(30)	Yes	Describes the person number for the Student person id
STUDENT_FULL_NAME	VARCHAR2	(360)	Yes	Full Name of the Student
INSTRUCTOR_PERSON_IDENTIFIER	NUMBER	(15)	Yes	Person ID of the Instructor who has to approve the Special permission request
INSTRUCTOR_PERSON_NUMBER	VARCHAR2	(30)	Yes	Describes the person number for the instructor person id
INSTRUCTOR_FULL_NAME	VARCHAR2	(360)	Yes	Full Name of the Instructor
UNIT_SECTION_ID	NUMBER	(6)	Yes	Unit section ID, which the student is attempting
UNIT_CODE	VARCHAR2	(10)	Yes	Unit code for which the actual enrollment against reservation is created.
VERSION_NUMBER	NUMBER	(3)	Yes	Version number of the unit being offered. Students are normally enrolled in the current version of a unit. Prior versions of the unit are end-dated
CALENDAR_TYPE	VARCHAR2	(10)	Yes	Calendar type in that the unit is offered
CAL_INST_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Unique identifier for the calendar instance
LOCATION_CODE	VARCHAR2	(10)	Yes	Institution-defined location code, typically of a campus, at which a unit offering option is offered.
UNIT_CLASS	VARCHAR2	(10)	Yes	Institution-defined code that identifies a unit class
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SPECIAL_PERM_REQUEST_ID
,      SUBMISSION_DATE
,      AUDIT_THE_UNIT_FLAG
,      _LA:AUDIT_THE_UNIT_DESC
,      APPROVAL_STATUS
,      REASON_FOR_REQUEST
,      INSTRUCTOR_MORE_INFO
,      INSTRUCTOR_DENY_INFO
,      STUDENT_MORE_INFO
,      TRANSACTION_TYPE
,      _LA:TRANSACTION_TYPE_DESC
,      REQUEST_TYPE
,      STUDENT_PERSON_IDENTIFIER
,      STUDENT_PERSON_NUMBER
,      STUDENT_FULL_NAME
,      INSTRUCTOR_PERSON_IDENTIFIER
,      INSTRUCTOR_PERSON_NUMBER
,      INSTRUCTOR_FULL_NAME
,      UNIT_SECTION_ID
,      UNIT_CODE
,      VERSION_NUMBER
,      CALENDAR_TYPE
,      CAL_INST_SEQUENCE_NUMBER
,      LOCATION_CODE
,      UNIT_CLASS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSFV_SPECIAL_PERMISSIONS;

Dependencies

[top of page]

APPS.IGSFV_SPECIAL_PERMISSIONS references the following:

APPS: HZ_PARTIES; IGS_EN_SPL_PERM; IGS_PS_UNIT_OFR_OPT_ALL

APPS.IGSFV_SPECIAL_PERMISSIONS is not referenced by any database object