[Home] [Help] [Dependency Information]
Object Name: | ISC_FS_TASK_ASSIGNMNTS_F |
---|---|
Object Type: | TABLE |
Owner: | ISC |
Subobject Name: | |
Status: | VALID |
This table stores data for Field Service Task Assignments relating to Dispatch Tasks. Normally this table stores details from JTF_TASK_ASSIGNMENTS 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". A join should always be made to ISC_FS_TASKS_F to ensure the associated Task has the correct Rule before including in reports. Rows can be physically deleted from JTF_TASK_ASSIGNMENTS, in such a case, the row will remain in this table with DELETED_FLAG set to "Y".
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ISC_FS_TASK_ASSIGNMNTS_F_U1 | NORMAL | UNIQUE | APPS_TS_SUMMARY | TASK_ASSIGNMENT_ID |
ISC_FS_TASK_ASSIGNMNTS_F_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | TASK_ID |
ISC_FS_TASK_ASSIGNMNTS_F_N2 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | REPORT_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TASK_ASSIGNMENT_ID | NUMBER | Yes | Task Assignment identifier | |
TASK_ID | NUMBER | Yes | Task identifier | |
DELETED_FLAG | VARCHAR2 | (1) | Yes | Indicates if Task Assignment has been physically deleted |
CANCELLED_FLAG | VARCHAR2 | (1) | Yes | Indicates if Task Assignment Status is cancelled |
ASSIGNMENT_CREATION_DATE | DATE | Creation Date (and time) of Task Assignment | ||
RESOURCE_ID | NUMBER | Assignee Resource identifier | ||
DISTRICT_ID | NUMBER | Assignee District identifier | ||
ACTUAL_EFFORT_HRS | NUMBER | Actual Effort converted to UOM HR | ||
SCHED_TRAVEL_DISTANCE_KM | NUMBER | Scheduled Travel Distance in Kilometers | ||
SCHED_TRAVEL_DURATION_MIN | NUMBER | Scheduled Travel Time converted to UOM MIN | ||
ACTUAL_TRAVEL_DISTANCE_KM | NUMBER | Actual Travel Distance in Kilometers | ||
ACTUAL_TRAVEL_DURATION_MIN | NUMBER | Actual Travel Time converted to UOM MIN | ||
ACTUAL_START_DATE | DATE | Actual Start Date (and time) | ||
ACTUAL_END_DATE | DATE | Actual End Date (and time) | ||
REPORT_DATE | DATE | Trncated Actual End Date for non-deleted task assigments with actual end date on or after global start date | ||
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 | ||
RESOURCE_TYPE | VARCHAR2 | (8) | Resource type: RESOURCE or GROUP or TEAM |
Cut, paste (and edit) the following text to query this object:
SELECT TASK_ASSIGNMENT_ID
, TASK_ID
, DELETED_FLAG
, CANCELLED_FLAG
, ASSIGNMENT_CREATION_DATE
, RESOURCE_ID
, DISTRICT_ID
, ACTUAL_EFFORT_HRS
, SCHED_TRAVEL_DISTANCE_KM
, SCHED_TRAVEL_DURATION_MIN
, ACTUAL_TRAVEL_DISTANCE_KM
, ACTUAL_TRAVEL_DURATION_MIN
, ACTUAL_START_DATE
, ACTUAL_END_DATE
, REPORT_DATE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, PROGRAM_ID
, PROGRAM_LOGIN_ID
, PROGRAM_APPLICATION_ID
, REQUEST_ID
, RESOURCE_TYPE
FROM ISC.ISC_FS_TASK_ASSIGNMNTS_F;
ISC.ISC_FS_TASK_ASSIGNMNTS_F does not reference any database object
ISC.ISC_FS_TASK_ASSIGNMNTS_F is referenced by following:
|
|
|