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

TABLE: IGS.IGS_CA_DA_PAIR

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


IGS_CA_DA_PAIR describes combination of date aliases into pairs.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_CA_DA_PAIR_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnDT_ALIAS
ColumnRELATED_DT_ALIAS
IGS_CA_DA_PAIR_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRELATED_DT_ALIAS
Columns
Name Datatype Length Mandatory Comments
DT_ALIAS VARCHAR2 (10) Yes Name of an event, not an actual date value. Each date alias is assigned a date alias category and can be assigned a calendar category.
RELATED_DT_ALIAS VARCHAR2 (10) Yes Name of the date alias that is paired with the context date alias. The pairing of two date aliases enables the definition of a period of time inclusive of the two date aliases. For example, the pairing of the two date aliases START SEMESTER BREAK and END SEMESTER BREAK. An institutional break is defined when instances of these two date aliases are created in a HOLIDAY calendar. 'Institutional Break' is one of the available date alias offset constraint types.
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 DT_ALIAS
,      RELATED_DT_ALIAS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_CA_DA_PAIR;

Dependencies

[top of page]

IGS.IGS_CA_DA_PAIR does not reference any database object

IGS.IGS_CA_DA_PAIR is referenced by following:

SchemaAPPS
SynonymIGS_CA_DA_PAIR