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_AD_PESTAT_GROUP

Object Details

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

Admission Personal Statements Group

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_AD_PESTAT_GROUP_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	GROUP_NUMBER ADMISSION_APPLICATION_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
GROUP_NUMBER	NUMBER	(15)	Yes	Group Number for Personal Statements
ADMISSION_APPLICATION_TYPE	VARCHAR2	(30)	Yes	Admission Application Type
GROUP_MIN	NUMBER	(15)		Group Minimum number for Personal Statements
SELF_MESSAGE	VARCHAR2	(60)		Self Service Message for Personal Statements
CREATED_BY	NUMBER	(15)	Yes	WHO column
CREATION_DATE	DATE		Yes	WHO column
LAST_UPDATED_BY	NUMBER	(15)	Yes	WHO column
LAST_UPDATE_DATE	DATE		Yes	WHO column
LAST_UPDATE_LOGIN	NUMBER	(15)		WHO column
GROUP_NAME	VARCHAR2	(60)		Group Name
GROUP_REQUIRED_FLAG	VARCHAR2	(1)		Group Required

Query Text

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


SELECT GROUP_NUMBER
,      ADMISSION_APPLICATION_TYPE
,      GROUP_MIN
,      SELF_MESSAGE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      GROUP_NAME
,      GROUP_REQUIRED_FLAG
FROM IGS.IGS_AD_PESTAT_GROUP;

Dependencies

[top of page]

IGS.IGS_AD_PESTAT_GROUP does not reference any database object

IGS.IGS_AD_PESTAT_GROUP is referenced by following:

APPS: IGS_AD_PESTAT_GROUP