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_OFCNT

Object Details

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

IGS_CA_DA_INST_OFCNT describes the set of constraints to be applied when applying an offset to generate a date alias instance value from another date alias instance.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_CA_DA_INST_OFCNT_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 S_DT_OFFSET_CONSTRAINT_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
DT_ALIAS	VARCHAR2	(10)	Yes	Date Alias is a short form of the Description of an event's short form is Date Alias. For example, CENSUS DATE, END LECTURES, and CUTOFF DATE.
DAI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	A system-generated number that is used to identify the date alias instance.
CAL_TYPE	VARCHAR2	(10)	Yes	Calendar Type is the institution defined name of a type of calendar used within the organization. Note: Calendar type does not refer to a particular occurrence of a calendar but rather to all like calendars. Each calendar type must be assigned a calendar category that is used to provide system functionality.
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. For example, CENSUS.
OFFSET_DAI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	System-generated number that is used to identify the offset date alias instance.
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 calendar for that the offset date alias instance occurs.
S_DT_OFFSET_CONSTRAINT_TYPE	VARCHAR2	(30)	Yes	The constraint type, in conjunction with a condition, defines the constraint.. Constraint types are system defined. For exampl,, MONDA,,WEEK DAY, and HOLIDAY..
CONSTRAINT_CONDITION	VARCHAR2	(10)	Yes	Operator which acts on the constraint type. The available conditions are MUST and MUST NOT.
CONSTRAINT_RESOLUTION	NUMBER	(1)	Yes	Offset value, in number of days, for the purpose of resolving failed date alias instance offset constraints. Positive or negative values can be specified and are used to adjust derived date aliasinstance values when a constraint fails. For example, an offset constraint specifies that the derived date must not fall during an institutional break. If it does, the system moves the date forward one day at a time until the derived date does not fall within an institutional break. In this case, the one-day increment is the resolution days value.
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
,      DAI_SEQUENCE_NUMBER
,      CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      OFFSET_DT_ALIAS
,      OFFSET_DAI_SEQUENCE_NUMBER
,      OFFSET_CAL_TYPE
,      OFFSET_CI_SEQUENCE_NUMBER
,      S_DT_OFFSET_CONSTRAINT_TYPE
,      CONSTRAINT_CONDITION
,      CONSTRAINT_RESOLUTION
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_CA_DA_INST_OFCNT;

Dependencies

[top of page]

IGS.IGS_CA_DA_INST_OFCNT does not reference any database object

IGS.IGS_CA_DA_INST_OFCNT is referenced by following:

APPS: IGS_CA_DA_INST_OFCNT