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_STEP

Object Details

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

IGS_TR_STEP describes a particular step of a tracking item. The steps can be the default steps that have been setup for each tracking type or they can be additional or alternate steps defined by a user.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_TR_STEP_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TRACKING_ID TRACKING_STEP_ID
IGS_TR_STEP_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RECIPIENT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TRACKING_ID	NUMBER	(9)	Yes	System generated tracking item identification
TRACKING_STEP_ID	NUMBER	(2)	Yes	System generated tracking step identification
TRACKING_STEP_NUMBER	NUMBER	(2)	Yes	Sequence number of the tracking step, that is used to identify each stage of tracking. A step can be re-sequenced, if it, together with subsequent steps, has not been completed.
DESCRIPTION	VARCHAR2	(60)	Yes	Tracking step description, that typically describes the required action.
S_TRACKING_STEP_TYPE	VARCHAR2	(30)		Describes the system defined tracking step types. These are not able to be altered by users as they are recognized by system functionality.
COMPLETION_DT	DATE			Date that action was taken for the tracking step. The current date is inserted by the system when the step complete indicator is selected and saved, but it can be overridden.
ACTION_DAYS	NUMBER	(4)	Yes	Number of days the step recipient has to complete the step. This value is inherited from the tracking type step action days, and is used by the system to calculate the date by that the tracking item step should be completed, that is, the 'action date'. The field is not displayed in the tracking item window.
STEP_COMPLETION_IND	VARCHAR2	(1)	Yes	Specifies if or not the tracking step has been completed. Selecting the indicator and saving the change causes the system to complete the step by automatically inserting the current date as the completion date. This date can be overridden.
BY_PASS_IND	VARCHAR2	(1)	Yes	Specifies if or not the tracking step is to be by passed. Selecting the checkbox by-passes the step and causes the system to recalculate the action dates of subsequent steps. Only non-completed steps can be by-passed.
RECIPIENT_ID	NUMBER	(15)		Indentification of the tracking step recipient, or the person to whom the tracking item is sent. The recipient is typically a member of staff of the institution.
STEP_GROUP_ID	NUMBER	(10)		Stores the Step Group Id of the Tracking Item Step
PUBLISH_IND	VARCHAR2	(1)		Publish indicator
STEP_CATALOG_CD	VARCHAR2	(30)		Stores the Step Catalog Code of the Tacking Item Step
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
REQUEST_ID	NUMBER	(15)		Request identifier of last concurrent program to update this record
PROGRAM_APPLICATION_ID	NUMBER	(15)		Application identifier of last concurrent program to update this record
PROGRAM_ID	NUMBER	(15)		Program identifier of last concurrent program to update this record
PROGRAM_UPDATE_DATE	DATE			Last update date of this record by a concurrent program

Query Text

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


SELECT TRACKING_ID
,      TRACKING_STEP_ID
,      TRACKING_STEP_NUMBER
,      DESCRIPTION
,      S_TRACKING_STEP_TYPE
,      COMPLETION_DT
,      ACTION_DAYS
,      STEP_COMPLETION_IND
,      BY_PASS_IND
,      RECIPIENT_ID
,      STEP_GROUP_ID
,      PUBLISH_IND
,      STEP_CATALOG_CD
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM IGS.IGS_TR_STEP;

Dependencies

[top of page]

IGS.IGS_TR_STEP does not reference any database object

IGS.IGS_TR_STEP is referenced by following:

APPS: IGS_TR_STEP