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_TASKS_F

Object Details

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

This table stores data for Field Service Dispatch Tasks. Normally this table stores details from JTF_TASKS_B for Tasks associated to Service Requests that have Task Type with the Rule "DISPATCH". It is possible to change the Task Type of a Task so that it is no longer Rule "DISPATCH". In that case the row will remain in this table but should be ignored for all reporting purposes. As well as data directly from JTF_TASKS_B, this table also stores details from JTF_TASK_ASSIGNMENTS that represents the "last assigned" or "last worked" task assignment.
Product and Incident Date from the related Service Request are denormalized into this table to support Activity and Backlog MVs and reports. Flags to rate a specific Task per Service Request for inclusion in Mean Time to Resolve and First Time Fix.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ISC_FS_TASKS_F_U1	NORMAL	UNIQUE	APPS_TS_SUMMARY	TASK_ID
ISC_FS_TASKS_F_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	CUSTOMER_ID
ISC_FS_TASKS_F_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	ADDRESS_ID
ISC_FS_TASKS_F_N3	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	LAST_UPDATE_DATE
ISC_FS_TASKS_F_N4	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	SOURCE_OBJECT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TASK_ID	NUMBER		Yes	Task identifier
TASK_NUMBER	VARCHAR2	(30)	Yes	Task Number
TASK_TYPE_ID	NUMBER		Yes	Task Type identifier
TASK_TYPE_RULE	VARCHAR2	(30)		Rule associated with Task Type - typically "DISPATCH"
BREAK_FIX_FLAG	VARCHAR2	(1)	Yes	Indicates if Task Type is considered to be Break/Fix for MTTR and FTF
TASK_STATUS_ID	NUMBER		Yes	Task Status identifier
OWNER_ID	NUMBER		Yes	Task Owner Resource identifier
OWNER_DISTRICT_ID	NUMBER		Yes	Task Owner District identified
CUSTOMER_ID	NUMBER		Yes	Customer identifier
ADDRESS_ID	NUMBER			Address identifier
PLANNED_START_DATE	DATE			Planned Start Date (and time)
PLANNED_END_DATE	DATE			Planned End Date (and time)
SCHEDULED_START_DATE	DATE			Scheduled Start Date (and Time)
SCHEDULED_END_DATE	DATE			Scheduled End Date (and Time)
ACTUAL_START_DATE	DATE			Actual Start Date (and time)
ACTUAL_END_DATE	DATE			Actual End Date (and time)
SOURCE_OBJECT_TYPE_CODE	VARCHAR2	(60)		Source Object Type identifier - typically "SR"
SOURCE_OBJECT_ID	NUMBER			Source Object identifier
SOURCE_OBJECT_NAME	VARCHAR2	(80)		Source Object Display Name - typically Service Request Number
PLANNED_EFFORT_HRS	NUMBER			Planned Effort converted to UOM HR
ACTUAL_EFFORT_HRS	NUMBER			Actual Effort converted to UOM HR
CANCELLED_FLAG	VARCHAR2	(1)	Yes	Indicates if Task has been cancelled
COMPLETED_FLAG	VARCHAR2	(1)	Yes	Indicates if Task has been completed
CLOSED_FLAG	VARCHAR2	(1)	Yes	Indicates if Task has been closed
DELETED_FLAG	VARCHAR2	(1)	Yes	Indicates if Task has been logically deleted
TASK_CREATION_DATE	DATE		Yes	Creation Date (and time) of Task
FIRST_ASGN_CREATION_DATE	DATE			Creation Date (and time) of the earliest non-cancelled Assignment for this Task
ACT_BAC_ASSIGNEE_ID	NUMBER			Assignee Resource identifier for Activity/Backlog reporting
ACT_BAC_DISTRICT_ID	NUMBER			Assignee District identifier for Activity/Backlog reporting
FTF_ASSIGNEE_ID	NUMBER			Assignee Resource identifer for First Time Fix reporting
FTF_DISTRICT_ID	NUMBER			Assignee District identifier for First Time Fix reporting
TTR_ASSIGNEE_ID	NUMBER			Assignee Resource identifer for Time to Resolve reporting
TTR_DISTRICT_ID	NUMBER			Assignee District identifier for Time to Resolve reporting
FTF_TTR_DISTRICT_RULE	VARCHAR2	(1)	Yes	Rule used to derive district for Time to Resolve and First Time Fix reporting, denormalized from profile for materialized view. All rows will have the same value.
INCLUDE_TASK_IN_TTR_FLAG	VARCHAR2	(1)		Indicates if this Task should be included in Time to Resolve measure. Only one Task per Service Request can be set to "Y"
INCLUDE_TASK_IN_FTF_FLAG	VARCHAR2	(1)		Indicates if this Task should be included in Non First Time Fix detail (if SR is Non First Time Fix). Multiple Tasks per SR can have be set to "Y"
FTF_FLAG	VARCHAR2	(1)		Indicates if Task is considered First Time Fixed. Only one Task per Service Request can be set to "Y" or "N". All others will be set to "-"
INCIDENT_DATE	DATE			Incident Date (and time)
INVENTORY_ITEM_ID	NUMBER			Inventory Item identifier
INV_ORGANIZATION_ID	NUMBER			Inventory Organization identifier
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
PARENT_TASK_ID	NUMBER			Indicates if Task has been split NULL - normal task M - parent task (master) D - child task (detail)
TASK_SPLIT_FLAG	VARCHAR2	(1)		Parent Task identifier if this is a child task
OWNER_TYPE	VARCHAR2	(8)		Task Owner Resource type: RESOURCE or GROUP or TEAM
LOCATION_ID	NUMBER			Location Identifier
ACT_BAC_ASSIGNEE_TYPE	VARCHAR2	(8)		Assignee Resource type: RESOURCE or GROUP or TEAM
FTF_ASSIGNEE_TYPE	VARCHAR2	(8)		Assignee Resource type for First Time Fix reporting: RESOURCE or GROUP or TEAM
TTR_ASSIGNEE_TYPE	VARCHAR2	(8)		Assignee Resource type identifier for Time to Resolve reporting: RESOURCE or GROUP or TEAM

Query Text

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


SELECT TASK_ID
,      TASK_NUMBER
,      TASK_TYPE_ID
,      TASK_TYPE_RULE
,      BREAK_FIX_FLAG
,      TASK_STATUS_ID
,      OWNER_ID
,      OWNER_DISTRICT_ID
,      CUSTOMER_ID
,      ADDRESS_ID
,      PLANNED_START_DATE
,      PLANNED_END_DATE
,      SCHEDULED_START_DATE
,      SCHEDULED_END_DATE
,      ACTUAL_START_DATE
,      ACTUAL_END_DATE
,      SOURCE_OBJECT_TYPE_CODE
,      SOURCE_OBJECT_ID
,      SOURCE_OBJECT_NAME
,      PLANNED_EFFORT_HRS
,      ACTUAL_EFFORT_HRS
,      CANCELLED_FLAG
,      COMPLETED_FLAG
,      CLOSED_FLAG
,      DELETED_FLAG
,      TASK_CREATION_DATE
,      FIRST_ASGN_CREATION_DATE
,      ACT_BAC_ASSIGNEE_ID
,      ACT_BAC_DISTRICT_ID
,      FTF_ASSIGNEE_ID
,      FTF_DISTRICT_ID
,      TTR_ASSIGNEE_ID
,      TTR_DISTRICT_ID
,      FTF_TTR_DISTRICT_RULE
,      INCLUDE_TASK_IN_TTR_FLAG
,      INCLUDE_TASK_IN_FTF_FLAG
,      FTF_FLAG
,      INCIDENT_DATE
,      INVENTORY_ITEM_ID
,      INV_ORGANIZATION_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
,      PARENT_TASK_ID
,      TASK_SPLIT_FLAG
,      OWNER_TYPE
,      LOCATION_ID
,      ACT_BAC_ASSIGNEE_TYPE
,      FTF_ASSIGNEE_TYPE
,      TTR_ASSIGNEE_TYPE
FROM ISC.ISC_FS_TASKS_F;

Dependencies

[top of page]

ISC.ISC_FS_TASKS_F does not reference any database object

ISC.ISC_FS_TASKS_F is referenced by following:

APPS: ISC_FS_009_MV; ISC_FS_011_MV; ISC_FS_013_MV; ISC_FS_017_MV; ISC_FS_018_MV; ISC_FS_019_MV; ISC_FS_020_MV; ISC_FS_TASKS_F