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.IGSBV_SPECIAL_PERMISSIONS

Object Details

Object Name:	IGSBV_SPECIAL_PERMISSIONS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGSBV_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
INSTRUCTOR_PERSON_IDENTIFIER	NUMBER	(15)	Yes	Person ID of the Instructor who has to approve the Special permission request
UNIT_SECTION_ID	NUMBER	(6)	Yes	Unit section ID, which the student is attempting
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
,      INSTRUCTOR_PERSON_IDENTIFIER
,      UNIT_SECTION_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSBV_SPECIAL_PERMISSIONS;

Dependencies

[top of page]

APPS.IGSBV_SPECIAL_PERMISSIONS references the following:

APPS: IGS_EN_SPL_PERM

APPS.IGSBV_SPECIAL_PERMISSIONS is not referenced by any database object