DBA Data[Home] [Help] [Dependency Information]

TABLE: IGS.IGS_AD_CAT_ATTR

Object Details
Object Name: IGS_AD_CAT_ATTR
Object Type: TABLE
Owner: IGS
FND Design Data: TableIGS.IGS_AD_CAT_ATTR
Subobject Name:
Status: VALID


IGS_AD_CAT_ATTR holds a set of applicants whose applications are processed through a common set of admission procedure steps. - Obsolete as per bug 2422183


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_AD_CAT_ATTR_U1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCAT_ATTR_ID
Columns
Name Datatype Length Mandatory Comments
CAT_ATTR_ID NUMBER (15) Yes Category unit identifier
SRC_CAT_ID NUMBER (15) Yes Identifier for the category
ATTR_NAME VARCHAR2 (30) Yes Attribute name for different categories
INCLUDE_IND VARCHAR2 (1) Yes Indicator to know whether a certain attribute has to be included in the category
MANDATORY_IND VARCHAR2 (1) Yes These attributes are mandatory if checked
SYS_MANDATORY_IND VARCHAR2 (1) Yes These are the system mandatory indicator
DISPLAY_SEQUENCE NUMBER (5) Yes Stores sequence number for the attributes
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER (15)
Standard Who column
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER (15)
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 CAT_ATTR_ID
,      SRC_CAT_ID
,      ATTR_NAME
,      INCLUDE_IND
,      MANDATORY_IND
,      SYS_MANDATORY_IND
,      DISPLAY_SEQUENCE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_AD_CAT_ATTR;

Dependencies

[top of page]

IGS.IGS_AD_CAT_ATTR does not reference any database object

IGS.IGS_AD_CAT_ATTR is referenced by following:

SchemaAPPS
SynonymIGS_AD_CAT_ATTR