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_INSTANCE_ALL

Object Details

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

IGS_AS_EXAM_INSTANCE_ALL describes the relationship between examination session instance and venue

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_AS_EXAM_INSTANCE_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ASS_ID EXAM_CAL_TYPE EXAM_CI_SEQUENCE_NUMBER DT_ALIAS DAI_SEQUENCE_NUMBER START_TIME END_TIME VENUE_CD
IGS_AS_EXAM_INSTANCE_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EXAM_CAL_TYPE EXAM_CI_SEQUENCE_NUMBER DT_ALIAS DAI_SEQUENCE_NUMBER START_TIME END_TIME
IGS_AS_EXAM_INSTANCE_ALL_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VENUE_CD
IGS_AS_EXAM_INSTANCE_ALL_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COLLECT_PERSON_ID
IGS_AS_EXAM_INSTANCE_ALL_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ESE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
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
ASS_ID	NUMBER	(10)	Yes	The day of the examination period on which the examination is being held. Eg EXAM-DAY1.
EXAM_CAL_TYPE	VARCHAR2	(10)	Yes	The name of the examination period or calendar type in which the assessment item is being examined. For example, EXAM-S1 - semester 1 examination period-.
EXAM_CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	The examination calendar sequence number
DT_ALIAS	VARCHAR2	(10)	Yes	The date alias instance on which the examination is being held
DAI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	The date alias instance sequence number
START_TIME	DATE		Yes	The start time of the examination
END_TIME	DATE		Yes	The end time of the examination
ESE_ID	NUMBER	(6)	Yes	The examination session ID
VENUE_CD	VARCHAR2	(10)	Yes	The of the venue at which the examination is being held
COLLECT_PERSON_ID	NUMBER	(15)		The ID of the person responsible for collecting or receiving the completed examination papers.
SPECIAL_SESSION_IND	VARCHAR2	(1)	Yes	An indicator which specifies if or not the session is a 'special' examination session. When the indicator is set -ticked- the session is deemed to be a special session. Special sessions are not advertised. They are typically created for students who have concurrently scheduled examinations and are therefore required to sit one of the examinations at a time that is different from other students.
OVERRIDE_START_TIME	DATE			The override start time for the examination at this venue. Normally the examination start time is a standard scheduled time for all instances of an examination. However, in some cases it is necessary to vary the start time. For example, the examination may be held at a location in a significantly different time zone, requiring the start time to be modified for students sitting the exam at that location.
OVERRIDE_END_TIME	DATE			The override end time for the examination at this venue. Normally the examination end time is a standard scheduled time for all instances of an examination. However, in some cases it is necessary to vary the end time. For example, the exam can be held at a location in a significantly different time zone, requiring the end time to be modified for students sitting the exam at that location.
SPECIAL_ANNOUNCEMENTS	VARCHAR2	(2000)		Any special announcements to be made to students for this instance of the examination
SPECIAL_INSTRUCTIONS	VARCHAR2	(2000)		Any special instructions which are to be issued to candidates for thisinstance of the examination
WORKED_SCRIPT_INSTRUCTIONS	VARCHAR2	(2000)		Any special instructions for supervisors about the handling of worked scripts
COMMENTS	VARCHAR2	(2000)		Any additional comments associated with the examination instance
ORG_ID	NUMBER	(15)		Operating unit identifier

Query Text

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


SELECT CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ASS_ID
,      EXAM_CAL_TYPE
,      EXAM_CI_SEQUENCE_NUMBER
,      DT_ALIAS
,      DAI_SEQUENCE_NUMBER
,      START_TIME
,      END_TIME
,      ESE_ID
,      VENUE_CD
,      COLLECT_PERSON_ID
,      SPECIAL_SESSION_IND
,      OVERRIDE_START_TIME
,      OVERRIDE_END_TIME
,      SPECIAL_ANNOUNCEMENTS
,      SPECIAL_INSTRUCTIONS
,      WORKED_SCRIPT_INSTRUCTIONS
,      COMMENTS
,      ORG_ID
FROM IGS.IGS_AS_EXAM_INSTANCE_ALL;

Dependencies

[top of page]

IGS.IGS_AS_EXAM_INSTANCE_ALL does not reference any database object

IGS.IGS_AS_EXAM_INSTANCE_ALL is referenced by following:

APPS: IGS_AS_EXAM_INSTANCE_ALL