[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
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;
IGS.IGS_TR_ITEM_ALL does not reference any database object
IGS.IGS_TR_ITEM_ALL is referenced by following:
|
|
|