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_TR_TYPE_ALL

Object Details

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

IGS_TR_TYPE describes the user-defined tracking types that exist
within the system. They are mapped back to the system defined tracking
types that are recognized by the system functionality.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_TR_TYPE_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TRACKING_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
TRACKING_TYPE	VARCHAR2	(10)	Yes	The institution-defined name of a tracking type. Tracking types are used to identify like tracking items. Each tracking type is mapped to a system tracking type either explicit or undefined to enable specific functionality. For example, special consideration application, advanced standing application, review of outcome application.
DESCRIPTION	VARCHAR2	(60)	Yes	Description of the tracking type. Tracking types are used to identify like tracking items. Each tracking type is mapped to a system tracking type -either explicit or undefined- to enable specificfunctionality. Examples are special consideration application, advanced standing application, review of outcome application.
S_TRACKING_TYPE	VARCHAR2	(30)	Yes	Name of a system defined tracking type. Each tracking type is mapped to an explicit or undefined system tracking type.
TARGET_DAYS	NUMBER	(4)	Yes	The maximum number of days after the start date that a tracking item of this type should take to complete all steps. This value is used by the system to calculate the completion required by date for tracking items of this type. Originator can over-ride this value.
SEQUENCE_IND	VARCHAR2	(1)	Yes	Specifies if the tracking steps associated with tracking items of this type must be completed in sequence. Selecting the checkbox ticked applies the sequential restriction. The value of this indicator is inherited by tracking items allocated this tracking type, but can be overridden.
BUSINESS_DAYS_IND	VARCHAR2	(1)	Yes	Specifies if or not the derivation of the tracking item required completion date and tracking step action dates is restricted to business days. Selecting the checkbox -ticked- applies the business days restriction. The value of this indicator is inherited by tracking items of this type, but can be overridden.
CLOSED_IND	VARCHAR2	(1)	Yes	Specifies if the tracking type is open or closed. Selecting the checkbox to 'closed' -ticked- prevents use of the tracking type in new tracking item records.
PUBLISH_IND	VARCHAR2	(1)		Decides to display the Tracking Steps for the Items on the self service screen
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
ORG_ID	NUMBER	(15)		Operating Unit Identifier

Query Text

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


SELECT TRACKING_TYPE
,      DESCRIPTION
,      S_TRACKING_TYPE
,      TARGET_DAYS
,      SEQUENCE_IND
,      BUSINESS_DAYS_IND
,      CLOSED_IND
,      PUBLISH_IND
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORG_ID
FROM IGS.IGS_TR_TYPE_ALL;

Dependencies

[top of page]

IGS.IGS_TR_TYPE_ALL does not reference any database object

IGS.IGS_TR_TYPE_ALL is referenced by following:

APPS: IGS_TR_TYPE_ALL