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]

TABLE: IGS.IGS_EN_SPL_PERM_H

Object Details

Object Name:	IGS_EN_SPL_PERM_H
Object Type:	TABLE
Owner:	IGS
FND Design Data:	IGS.IGS_EN_SPL_PERM_H
Subobject Name:
Status:	VALID

This table maintains the history of special permission request transactions.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_EN_SPL_PERM_H_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SPL_PERM_REQUEST_H_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SPL_PERM_REQUEST_H_ID	NUMBER	(15)	Yes	System generated number to uniquely identify the Special permission request history.
SPL_PERM_REQUEST_ID	NUMBER	(15)		Foreign Key to IGS_EN_SPL_PERM_ALL
DATE_SUBMISSION	DATE			Date of the last transaction happened, i.e. last date of update of this record
AUDIT_THE_COURSE	VARCHAR2	(10)		Audit this course
APPROVAL_STATUS	VARCHAR2	(10)		Approval status of the transaction, it can be Need more Information required , Deny or Approved.
REASON_FOR_REQUEST	VARCHAR2	(4000)		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 like request from user, approve from instructor etc.
HIST_START_DT	DATE		Yes	Start date of the history record
HIST_END_DT	DATE		Yes	End date of the history record
HIST_WHO	NUMBER	(15)	Yes	Person ID of who performed the transaction
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
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Column

Query Text

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


SELECT SPL_PERM_REQUEST_H_ID
,      SPL_PERM_REQUEST_ID
,      DATE_SUBMISSION
,      AUDIT_THE_COURSE
,      APPROVAL_STATUS
,      REASON_FOR_REQUEST
,      INSTRUCTOR_MORE_INFO
,      INSTRUCTOR_DENY_INFO
,      STUDENT_MORE_INFO
,      TRANSACTION_TYPE
,      HIST_START_DT
,      HIST_END_DT
,      HIST_WHO
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_EN_SPL_PERM_H;

Dependencies

[top of page]

IGS.IGS_EN_SPL_PERM_H does not reference any database object

IGS.IGS_EN_SPL_PERM_H is referenced by following:

APPS: IGS_EN_SPL_PERM_H