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_TIMESLOT_PARA

Object Details

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

To capture the Timeslot Parameters of running the process.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_EN_TIMESLOT_PARA_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	IGS_EN_TIMESLOT_PARA_ID

Columns

Name	Datatype	Length	Mandatory	Comments
IGS_EN_TIMESLOT_PARA_ID	NUMBER	(15)	Yes	This is Primary Key column.
PROGRAM_TYPE_GROUP_CD	VARCHAR2	(10)	Yes	This column stores Program Type Group Code.
CAL_TYPE	VARCHAR2	(10)	Yes	This column indicates Calendar Type.
SEQUENCE_NUMBER	NUMBER	(6)	Yes	This column indicates Sequence Number.
STUDENT_TYPE	VARCHAR2	(10)	Yes	This column displays the type of student.
TIMESLOT_CALENDAR	VARCHAR2	(30)	Yes	This column contains Timeslot calendar.
TIMESLOT_ST_TIME	DATE		Yes	The actual start time of the timeslot.
TIMESLOT_END_TIME	DATE		Yes	The actual end time of the timeslot
TS_MODE	VARCHAR2	(1)	Yes	Mode of the process - Trial or Final. Can have only two values T or F.
MAX_HEAD_COUNT	NUMBER	(15)	Yes	The maximum headcount for one timeslot session.
LENGTH_OF_TIME	NUMBER	(15)	Yes	The length of each timeslot 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
REQUEST_ID	NUMBER	(15)		Request identifier of the last concurrent program
PROGRAM_APPLICATION_ID	NUMBER	(15)		Program application identifier of the last concurrent program
PROGRAM_ID	NUMBER	(15)		Program identifier of the last concurrent program
PROGRAM_UPDATE_DATE	DATE			Last update date of the concurrent program
ORG_ID	NUMBER	(15)		Operating unit identifier.

Query Text

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


SELECT IGS_EN_TIMESLOT_PARA_ID
,      PROGRAM_TYPE_GROUP_CD
,      CAL_TYPE
,      SEQUENCE_NUMBER
,      STUDENT_TYPE
,      TIMESLOT_CALENDAR
,      TIMESLOT_ST_TIME
,      TIMESLOT_END_TIME
,      TS_MODE
,      MAX_HEAD_COUNT
,      LENGTH_OF_TIME
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ORG_ID
FROM IGS.IGS_EN_TIMESLOT_PARA;

Dependencies

[top of page]

IGS.IGS_EN_TIMESLOT_PARA does not reference any database object

IGS.IGS_EN_TIMESLOT_PARA is referenced by following:

APPS: IGS_EN_TIMESLOT_PARA