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_USEC_SESSNS

Object Details

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

New table to store Unit Section Session details

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_AS_USEC_SESSNS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	UOO_ID SESSION_NAME
IGS_AS_USEC_SESSNS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	UNIT_SECTION_OCCURRENCE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
UOO_ID	NUMBER	(7)	Yes	Unit Section Id which is a FK to unit sections table.
SESSION_NAME	VARCHAR2	(90)	Yes	A user enterable session name for entering the attendance.
SESSION_DESCRIPTION	VARCHAR2	(240)		An optional description about this session.
UNIT_SECTION_OCCURRENCE_ID	NUMBER	(10)		Relates this session to a specific unit section occurrence.
SESSION_START_DATE_TIME	DATE		Yes	A date time field indicating the start of this session.
SESSION_END_DATE_TIME	DATE			A date time field indicating the end of this session.
SESSION_LOCATION_DESC	VARCHAR2	(240)		The location where this session is being held.
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 UOO_ID
,      SESSION_NAME
,      SESSION_DESCRIPTION
,      UNIT_SECTION_OCCURRENCE_ID
,      SESSION_START_DATE_TIME
,      SESSION_END_DATE_TIME
,      SESSION_LOCATION_DESC
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_AS_USEC_SESSNS;

Dependencies

[top of page]

IGS.IGS_AS_USEC_SESSNS does not reference any database object

IGS.IGS_AS_USEC_SESSNS is referenced by following:

APPS: IGS_AS_USEC_SESSNS