[Home] [Help] [Dependency Information]
Object Name: | IGS_CA_DA_INST |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_CA_DA_INST |
Subobject Name: | |
Status: | VALID |
IGS_CA_DA_INST describes an instance of a date alias in a calendar instance.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_CA_DA_INST_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
DT_ALIAS
SEQUENCE_NUMBER CAL_TYPE CI_SEQUENCE_NUMBER |
IGS_CA_DA_INST_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
CAL_TYPE
CI_SEQUENCE_NUMBER |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DT_ALIAS | VARCHAR2 | (10) | Yes | Event name, that is not an actual date value. Each date alias is assigned a date alias category and may be assigned a calendar category. Date alias examples are CENSUS, END-LECT, and CUTOFF. |
SEQUENCE_NUMBER | NUMBER | (6) | Yes | System generated number that is used to identify the date alias instance. |
CAL_TYPE | VARCHAR2 | (10) | Yes | Type of calendar used within the organization. |
CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | System generated number that is used to identify the calendar instance, for that the date alias instance occurs. |
ABSOLUTE_VAL | DATE | The real date value allocated to an instance of a date alias. | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT DT_ALIAS
, SEQUENCE_NUMBER
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, ABSOLUTE_VAL
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
FROM IGS.IGS_CA_DA_INST;
IGS.IGS_CA_DA_INST does not reference any database object
IGS.IGS_CA_DA_INST is referenced by following:
|
|
|