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_BACKLOG_F

Object Details

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

This table stores data for Field Service Task Backlog movement. It stores one row for each Task (for Service Request) in the backlog (task status CLOSED_FLAG = "N") for a consecutive range of days that is has the same Backlog Status Code, Actual Effort, Actual Start and End Dates. The backlog status code is based in the attributes of task status (multiple task statuses can be represented by the same backlog status code).

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ISC_FS_TASK_BACKLOG_F_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	BACKLOG_DATE_TO
ISC_FS_TASK_BACKLOG_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
PLANNED_START_DATE	DATE			Planned Start Date (and time)
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
BACKLOG_DATE_FROM	DATE		Yes	Backlog Date From
BACKLOG_DATE_TO	DATE		Yes	Backlog Date To (or 12/31/4712 if current status has CLOSED_FLAG = "N")
BACKLOG_STATUS_CODE	NUMBER		Yes	Backlog Status Code: 1 - IN PLANNING, 2 - ASSIGNED, 3 - WORKING, 4 - COMPLETED, 5 - OTHER
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
,      PLANNED_START_DATE
,      SOURCE_OBJECT_TYPE_CODE
,      TASK_TYPE_ID
,      TASK_TYPE_RULE
,      DELETED_FLAG
,      ACT_BAC_ASSIGNEE_ID
,      ACT_BAC_DISTRICT_ID
,      TASK_AUDIT_ID
,      BACKLOG_DATE_FROM
,      BACKLOG_DATE_TO
,      BACKLOG_STATUS_CODE
,      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_BACKLOG_F;

Dependencies

[top of page]

ISC.ISC_FS_TASK_BACKLOG_F does not reference any database object

ISC.ISC_FS_TASK_BACKLOG_F is referenced by following:

APPS: ISC_FS_005_MV; ISC_FS_007_MV; ISC_FS_TASK_BACKLOG_F