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_CODE_CLASSES

Object Details

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

IGS_AD_CODE_CLASSES holds details about admission setup data.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_AD_CODE_CLASSES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	CODE_ID
IGS_AD_CODE_CLASSES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	NAME CLASS CLASS_TYPE_CODE
IGS_AD_CODE_CLASSES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CLASS

Columns

Name	Datatype	Length	Mandatory	Comments
CODE_ID	NUMBER		Yes	Unique identifier for each code
NAME	VARCHAR2	(10)	Yes	Name of the code
DESCRIPTION	VARCHAR2	(30)	Yes	Description of the code
CLASS	VARCHAR2	(30)	Yes	Class that this code belongs to
CLOSED_IND	VARCHAR2	(1)	Yes	Closed indicator
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
SYSTEM_STATUS	VARCHAR2	(30)		This column is used to indicated the system status with which the user defined status is associated
SYSTEM_DEFAULT	VARCHAR2	(1)		This column is used to indicate if a particular code is the system default. Valid values can be 'Y' and 'N'
CLASS_TYPE_CODE	VARCHAR2	(30)	Yes	The qualifying type defined for the class

Query Text

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


SELECT CODE_ID
,      NAME
,      DESCRIPTION
,      CLASS
,      CLOSED_IND
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SYSTEM_STATUS
,      SYSTEM_DEFAULT
,      CLASS_TYPE_CODE
FROM IGS.IGS_AD_CODE_CLASSES;

Dependencies

[top of page]

IGS.IGS_AD_CODE_CLASSES does not reference any database object

IGS.IGS_AD_CODE_CLASSES is referenced by following:

APPS: IGS_AD_CODE_CLASSES