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_ITEM_ALL

Object Details

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

IGS_TR_ITEM_ALL describes each occurrence of a tracking process for a
particular student.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_TR_ITEM_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TRACKING_ID
IGS_TR_ITEM_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOURCE_PERSON_ID
IGS_TR_ITEM_ALL_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRACKING_TYPE
IGS_TR_ITEM_ALL_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRACKING_STATUS
IGS_TR_ITEM_ALL_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORIGINATOR_PERSON_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TRACKING_ID	NUMBER	(9)	Yes	System generated identification number used to uniquely identify a tracking item
TRACKING_STATUS	VARCHAR2	(10)	Yes	An institution-defined tracking status used to define the current state of a tracking item. Institution-defined tracking statuses map onto system defined tracking statuses that are recognized by system functionality.
TRACKING_TYPE	VARCHAR2	(10)	Yes	The name of an institution-defined tracking type, used to assist in identifying items being tracked. 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.
SOURCE_PERSON_ID	NUMBER	(15)		The identification of the person who is the subject of the tracking item. Typically, a student is the tracking item subject. For example, if a special consideration application is being tracked, the student who submitted the application is the subject.
START_DT	DATE		Yes	Date the tracking item was initiated. This date is set by the system and cannot be overridden.
TARGET_DAYS	NUMBER	(4)	Yes	Maximum number of days from the start date that all tracking item steps should take to complete. This value is inherited from the target days value of the tracking type.
SEQUENCE_IND	VARCHAR2	(1)	Yes	Specifies if the tracking steps associated with the tracking item must be completed in sequence. Setting the checkbox ticked applies the sequential restriction.
BUSINESS_DAYS_IND	VARCHAR2	(1)	Yes	Specifies if 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.
ORIGINATOR_PERSON_ID	NUMBER	(15)	Yes	Indentification of the person who created the tracking item
S_CREATED_IND	VARCHAR2	(1)	Yes	Indicates that the system has created the tracking item. User cannot delete steps of a system created tracking item.
OVERRIDE_OFFSET_CLC_IND	VARCHAR2	(1)		Override offset calculation
COMPLETION_DUE_DT	DATE			Completion due date
PUBLISH_IND	VARCHAR2	(1)		Publish indicator
ORG_ID	NUMBER	(15)		Operating unit identifier
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_UPDATE_DATE	DATE			Last update date of this record by a concurrent program
PROGRAM_ID	NUMBER	(15)		Program identifier of last concurrent program to update this record
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 TRACKING_ID
,      TRACKING_STATUS
,      TRACKING_TYPE
,      SOURCE_PERSON_ID
,      START_DT
,      TARGET_DAYS
,      SEQUENCE_IND
,      BUSINESS_DAYS_IND
,      ORIGINATOR_PERSON_ID
,      S_CREATED_IND
,      OVERRIDE_OFFSET_CLC_IND
,      COMPLETION_DUE_DT
,      PUBLISH_IND
,      ORG_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      PROGRAM_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_TR_ITEM_ALL;

Dependencies

[top of page]

IGS.IGS_TR_ITEM_ALL does not reference any database object

IGS.IGS_TR_ITEM_ALL is referenced by following:

APPS: IGS_TR_ITEM_ALL