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_STD_EXM_INSTN_ALL

Object Details

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

IGS_AS_STD_EXM_INSTN_ALL describes relationship between student unit attempt and time-tabled examination instance.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_AS_STD_EXM_INSTN_ALL_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	STD_EXM_INSTN_ID
IGS_AS_STD_EXM_INSTN_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASS_ID EXAM_CAL_TYPE EXAM_CI_SEQUENCE_NUMBER VENUE_CD
IGS_AS_STD_EXM_INSTN_ALL_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ESE_ID
IGS_AS_STD_EXM_INSTN_ALL_U1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERSON_ID COURSE_CD UOO_ID ASS_ID CREATION_DT EXAM_CAL_TYPE EXAM_CI_SEQUENCE_NUMBER DT_ALIAS DAI_SEQUENCE_NUMBER END_TIME START_TIME VENUE_CD

Columns

Name	Datatype	Length	Mandatory	Comments
ASS_ID	NUMBER	(10)	Yes	The ID of the assessment item examination.
EXAM_CAL_TYPE	VARCHAR2	(10)	Yes	The examination calendar type in which the examination is timetabled.
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 session is held.
DAI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	The examination session 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 code which describes the venue in which the examination is being held.
PERSON_ID	NUMBER	(15)	Yes	The person ID of the student.
COURSE_CD	VARCHAR2	(6)	Yes	The code of the student's program attempt.
UNIT_CD	VARCHAR2	(10)	Yes	The unit code being examined.
CAL_TYPE	VARCHAR2	(10)	Yes	The teaching calendar type in which the student unit attempt is enrolled.
CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	The teaching calendar sequence number in which the unit being examined is being studied.
CREATION_DT	DATE		Yes	The date the student examination instance was created.
ATTENDANCE_IND	VARCHAR2	(1)	Yes	Indicates and specifies if or not the student attended the examination. When the checkbox is set ticked, the student is flagged as having attended.
TIMESLOT	DATE			The timeslot allocated to the student within the examination session. Timeslots are used when individual appointments are scheduled for students. For example, music performance.
TIMESLOT_DURATION	DATE			The duration of the student's timeslot. Timeslots are used when individual appointments are scheduled for students. For example, music performance.
SEAT_NUMBER	NUMBER	(4)		The seat number allocated to the student for the examination.
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
UOO_ID	NUMBER	(7)	Yes	Unit Section identifier
STD_EXM_INSTN_ID	NUMBER	(7)	Yes	Unique identifier

Query Text

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


SELECT ASS_ID
,      EXAM_CAL_TYPE
,      EXAM_CI_SEQUENCE_NUMBER
,      DT_ALIAS
,      DAI_SEQUENCE_NUMBER
,      START_TIME
,      END_TIME
,      ESE_ID
,      VENUE_CD
,      PERSON_ID
,      COURSE_CD
,      UNIT_CD
,      CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      CREATION_DT
,      ATTENDANCE_IND
,      TIMESLOT
,      TIMESLOT_DURATION
,      SEAT_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORG_ID
,      UOO_ID
,      STD_EXM_INSTN_ID
FROM IGS.IGS_AS_STD_EXM_INSTN_ALL;

Dependencies

[top of page]

IGS.IGS_AS_STD_EXM_INSTN_ALL does not reference any database object

IGS.IGS_AS_STD_EXM_INSTN_ALL is referenced by following:

APPS: IGS_AS_STD_EXM_INSTN_ALL