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: ISC.ISC_FS_EVENTS

Object Details

Object Name:	ISC_FS_EVENTS
Object Type:	TABLE
Owner:	ISC
Subobject Name:
Status:	VALID

This table stores data for Business Events that have occurred on Service Request and Departure/Arrival Tasks, and Task Assignments.
It is truncated by the initial load of ISC_FS_TASKS_F, ISC_FS_TASK_ASSIGNMNTS_F and ISC_FS_CAPACITY_F.
Whenever a Task or Task Assignment is created, updated or deleted a subscribed business event is processed on the Work Flow deferred queue. If the Task/Assignment is for Service Request or for a �Departure/Arrival� task as row is inserted into this table.
Whenever a Service Request with Tasks is updated and the product is changed a subscribed business event will also insert a row for each task. This allows changes in product to be updated to ISC_FS_TASKS_F.
The incremental load for ISC_FS_TASKS_F, ISC_FS_TASK_ASSIGNMNTS_F and ISC_FS_CAPACITY_F is driven off the data in this table.
Rows are deleted from this table after they have been processed by the incremental load.
We do not attempt to truncate this table as that requires acquiring a table lock which is expensive as this table is populated independently of the incremental load amy may have open transactions. Also the high water mark for the table should represent a �normal� number of rows accumulated between incremental refreshes.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
SEND_DATE	DATE		Yes	Send Date (and time) of Event. Informational purposed only.
SOURCE_OBJECT_TYPE_CODE	VARCHAR2	(60)	Yes	Source Object Type identifier - typically "SR" or "TASK"
SOURCE_OBJECT_ID	NUMBER		Yes	Source Object identifier
TASK_ID	NUMBER			Task identifier
TASK_AUDIT_ID	NUMBER			Task audit identifier if Task Updated or Deleted. Informational purposed only
TASK_ASSIGNMENT_ID	NUMBER			Task Assignment identifier if Task Assignment Created, Updated or Deleted
EVENT_NAME	VARCHAR2	(240)		Event identifier, indicates if Task Creates, Updated or Deleted or Task Assignment Created, Updated or Deleted or Service Request Updated. Informational purposes only
CREATED_BY	NUMBER		Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER		Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER			Standard who column

Query Text

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


SELECT SEND_DATE
,      SOURCE_OBJECT_TYPE_CODE
,      SOURCE_OBJECT_ID
,      TASK_ID
,      TASK_AUDIT_ID
,      TASK_ASSIGNMENT_ID
,      EVENT_NAME
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM ISC.ISC_FS_EVENTS;

Dependencies

[top of page]

ISC.ISC_FS_EVENTS does not reference any database object

ISC.ISC_FS_EVENTS is referenced by following:

APPS: ISC_FS_EVENTS