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_AS_EXAM_SESSION_ALL

Object Details

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

IGS_AS_EXAM_SESSION_ALL describes the available sessions when examinations might be conducted. The session is linked to a date alias instance within the nominated examination calendar instance. Optionally, a sequential exam session number might be entered as an identifier of the session. This note is stored as a primary identifier.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_AS_EXAM_SESSION_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	EXAM_CAL_TYPE EXAM_CI_SEQUENCE_NUMBER DT_ALIAS DAI_SEQUENCE_NUMBER START_TIME END_TIME

Columns

Name	Datatype	Length	Mandatory	Comments
EXAM_CAL_TYPE	VARCHAR2	(10)	Yes	The examination calendar type in which the session is being held
EXAM_CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	The examination calendar sequence number
DT_ALIAS	VARCHAR2	(10)	Yes	The date alias on which the examination session is being held. This date must always exist within the related examination calendar instance.
DAI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	The date alias sequence number of the session date
CI_START_DT	DATE		Yes	The examination calendar start date
CI_END_DT	DATE		Yes	The examination calendar end date
START_TIME	DATE		Yes	The time the examination session is to commence
END_TIME	DATE		Yes	The time the examination session is to conclude
ESE_ID	NUMBER	(6)	Yes	The examination session ID. This is an internally generated number that uniquely identifies an examination session and is used internally to the system as a quick-reference between timetabling details and the session.
EXAM_SESSION_NUMBER	NUMBER	(2)	Yes	A number that identifies the session within the selected calendar
COMMENTS	VARCHAR2	(2000)		Any additional comments about the examination session
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
ORG_ID	NUMBER	(15)		Operating unit identifier

Query Text

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


SELECT EXAM_CAL_TYPE
,      EXAM_CI_SEQUENCE_NUMBER
,      DT_ALIAS
,      DAI_SEQUENCE_NUMBER
,      CI_START_DT
,      CI_END_DT
,      START_TIME
,      END_TIME
,      ESE_ID
,      EXAM_SESSION_NUMBER
,      COMMENTS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORG_ID
FROM IGS.IGS_AS_EXAM_SESSION_ALL;

Dependencies

[top of page]

IGS.IGS_AS_EXAM_SESSION_ALL does not reference any database object

IGS.IGS_AS_EXAM_SESSION_ALL is referenced by following:

APPS: IGS_AS_EXAM_SESSION_ALL