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_CA_DA_INST_OFST

Object Details

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

IGS_CA_DA_INST_OFST describes the relationship between one date alias instance and another. It holds offset values that can be used to derive the date alias instance date from the related date alias instance value.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_CA_DA_INST_OFST_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	DT_ALIAS DAI_SEQUENCE_NUMBER CAL_TYPE CI_SEQUENCE_NUMBER OFFSET_DT_ALIAS OFFSET_DAI_SEQUENCE_NUMBER OFFSET_CAL_TYPE OFFSET_CI_SEQUENCE_NUMBER
IGS_CA_DA_INST_OFST_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OFFSET_DT_ALIAS OFFSET_DAI_SEQUENCE_NUMBER OFFSET_CAL_TYPE OFFSET_CI_SEQUENCE_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
DT_ALIAS	VARCHAR2	(10)	Yes	Name of the context date alias instance. A date alias is an institution-defined name of an event, not an actual date value .
DAI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	System-generated number that is used to identify the datealias instance for that an offset is being defined.
CAL_TYPE	VARCHAR2	(10)	Yes	Calendar type of the calendar instance for that the context date alias instance occurs. A calendar type is an institution-defined name of a 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.
OFFSET_DT_ALIAS	VARCHAR2	(10)	Yes	Name of the offset date alias instance. A date alias is the name of an event, not an actual date value.
OFFSET_DAI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	System-generated number that is used to identify the offset date.
OFFSET_CAL_TYPE	VARCHAR2	(10)	Yes	Calendar type of the calendar instance for that the offset date alias instance occurs. A calendar type is the name of a type of calendar used within the institution.
OFFSET_CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	System-generated number that is used to identify the calendarfor that the offset date alias instance occurs.
DAY_OFFSET	NUMBER	(3)		Number of days for that the context date alias instance is offset from the related date alias instance. Values may be positive or negative. It can be used in conjunction with WEEK, MONTH, YEAR offset values. For example, date alias instance A may be offset from date alias instance B by 3 weeks and 2 days.
WEEK_OFFSET	NUMBER	(2)		Number of weeks for that the context date alias instanceis offset from the related date alias instance. Values may bepositive or negative. It can be used in conjunction with DAY, MONTH, YEAR offset values. For example, date alias instance A may beoffset from date alias instance B by 3 months and 1 week.
MONTH_OFFSET	NUMBER	(2)		Number of months for that the context date alias instanceis offset from the related date alias instance. Values may be positiveor negative. It can be used in conjunction with DAY, WEEK, YEARoffset values. For example, date alias instance A may be offset fromdate alias instance B by 3 months and 2 days.
YEAR_OFFSET	NUMBER	(1)		Number of years for that the context date alias instanceis offset from the related date alias instance. Values may beor negative. It can be used in conjunction with DAY, WEEK, MONTH offset values. For example, date alias instance A may be offsetfrom date alias instance B by 1 year and 2 months.
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
OFST_OVERRIDE	VARCHAR2	(1)	Yes	Flag to indicate if the offset is to be overridden.

Query Text

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


SELECT DT_ALIAS
,      DAI_SEQUENCE_NUMBER
,      CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      OFFSET_DT_ALIAS
,      OFFSET_DAI_SEQUENCE_NUMBER
,      OFFSET_CAL_TYPE
,      OFFSET_CI_SEQUENCE_NUMBER
,      DAY_OFFSET
,      WEEK_OFFSET
,      MONTH_OFFSET
,      YEAR_OFFSET
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      OFST_OVERRIDE
FROM IGS.IGS_CA_DA_INST_OFST;

Dependencies

[top of page]

IGS.IGS_CA_DA_INST_OFST does not reference any database object

IGS.IGS_CA_DA_INST_OFST is referenced by following:

APPS: IGS_CA_DA_INST_OFST