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_TASK_ACTIVITY_F

Object Details

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

This table stores data for Field Service Task Activity. It is based on rows in JTF_TASKS_B/ JTF_TASK_AUDITS_B for task creations and JTF_TASK_AUDITS_B for task updates. There is a row in this table when each Task (for Service Request) when it is created, when it closed (moves from a Task Status with CLOSED_FLAG = "N" to a Task Status with CLOSED_FLAG = "Y") and when it is reopened (moves from a Task Status with CLOSED_FLAG = "Y" to a Task Status with CLOSED_FLAG = "N").

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ISC_FS_TASK_ACTIVITY_F_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	ACTIVITY_DATE
ISC_FS_TASK_ACTIVITY_F_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	TASK_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TASK_ID	NUMBER		Yes	Task identifier
INVENTORY_ITEM_ID	NUMBER			Inventory Item identifier
INV_ORGANIZATION_ID	NUMBER			Inventory Organization identifier
CUSTOMER_ID	NUMBER			Customer Identifier
SOURCE_OBJECT_TYPE_CODE	VARCHAR2	(60)		Source Object Type identifier - typically "SR"
TASK_TYPE_ID	NUMBER			Task Type identifier
TASK_TYPE_RULE	VARCHAR2	(30)		Rule associated with Task Type - typically "DISPATCH"
DELETED_FLAG	VARCHAR2	(1)		Indicates if Task has been logically deleted
ACT_BAC_ASSIGNEE_ID	NUMBER			Assignee Resource identifier for Activity/Backlog reporting
ACT_BAC_DISTRICT_ID	NUMBER			Assignee District identifier for Activity/Backlog reporting
TASK_AUDIT_ID	NUMBER		Yes	Task Audit identifier
ACTIVITY_DATE	DATE		Yes	Activity Date
FIRST_OPENED	NUMBER			"1" if first opened activity occured
REOPENED	NUMBER			"1" if reopened activity occured
CLOSED	NUMBER			"1" if closed activity occured
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
PROGRAM_ID	NUMBER			Standard who column
PROGRAM_LOGIN_ID	NUMBER			Standard who column
PROGRAM_APPLICATION_ID	NUMBER			Standard who column
REQUEST_ID	NUMBER			Standard who column
ACT_BAC_ASSIGNEE_TYPE	VARCHAR2	(8)		Assignee Resource type: RESOURCE or GROUP or TEAM

Query Text

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


SELECT TASK_ID
,      INVENTORY_ITEM_ID
,      INV_ORGANIZATION_ID
,      CUSTOMER_ID
,      SOURCE_OBJECT_TYPE_CODE
,      TASK_TYPE_ID
,      TASK_TYPE_RULE
,      DELETED_FLAG
,      ACT_BAC_ASSIGNEE_ID
,      ACT_BAC_DISTRICT_ID
,      TASK_AUDIT_ID
,      ACTIVITY_DATE
,      FIRST_OPENED
,      REOPENED
,      CLOSED
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
,      ACT_BAC_ASSIGNEE_TYPE
FROM ISC.ISC_FS_TASK_ACTIVITY_F;

Dependencies

[top of page]

ISC.ISC_FS_TASK_ACTIVITY_F does not reference any database object

ISC.ISC_FS_TASK_ACTIVITY_F is referenced by following:

APPS: ISC_FS_003_MV; ISC_FS_TASK_ACTIVITY_F