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

Object Details

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

IGS_CA_DA describes available date alias types.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_CA_DA_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	DT_ALIAS
IGS_CA_DA_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DT_CAT

Columns

Name	Datatype	Length	Mandatory	Comments
DT_ALIAS	VARCHAR2	(10)	Yes	Name of an event, that is not an actual date value. Each date alias is assigned a date alias category and may be assigned a calendar category. For example, Date aliases are CENSUS and END-LECT.
DESCRIPTION	VARCHAR2	(60)	Yes	Description of an event, that is not an actual date value. Each date alias is assigned a date alias category and may be assigned a calendarcategory. For example Date alias are GOVERNMENT CENSUS DATE, LAST DAY OF LECTURES IN TEACHING PERIOD, and LAST DAY TO WITHDRAW FROM UNIT WITHOUT FAILING.
DT_CAT	VARCHAR2	(10)	Yes	Name of a date alias category. A date alias category is a classification of date aliases for the purpose of grouping common date or event types. Each date alias is assigned a date alias category.For example, FEE DATES, UNIT WITHDRAWAL DATES, and TEACHING DATES.
ABBREVIATION	VARCHAR2	(30)		Abbreviated descrition of an event, 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 DATE, END LECTURES, and CUTOFF DATE.
S_CAL_CAT	VARCHAR2	(30)		System-defined categorization of calendar types. Each calendar typeis assigned a calendar category. The optional linking of a date aliasto a calendar category has the effect of restricting the creation ofinstances of that date alias to instances of calendars of thespecified calendar category. For example, the date alias WITHDRAWNWITHOUT PENALTY might be linked to the calendar category TEACHING.The effect of this would be to restrict the creation of instances ofthis date alias to TEACHING calendar instances.
CLOSED_IND	VARCHAR2	(1)	Yes	Specifies if the date alias is open or closed. Setting the checkbox to 'closed' prevents use of the date alias in new date alias instance records.
NOTES	VARCHAR2	(2000)		Enters additional information or details about the date alias. This is a text-based facility.
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
,      DESCRIPTION
,      DT_CAT
,      ABBREVIATION
,      S_CAL_CAT
,      CLOSED_IND
,      NOTES
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_CA_DA;

Dependencies

[top of page]

IGS.IGS_CA_DA does not reference any database object

IGS.IGS_CA_DA is referenced by following:

APPS: IGS_CA_DA