[Home] [Help] [Dependency Information]
Object Name: | ISC_FS_CAPACITY_F |
---|---|
Object Type: | TABLE |
Owner: | ISC |
Subobject Name: | |
Status: | VALID |
This table stores data for Field Service Trip Tasks.
It maps to JTF_TASKS_F, JTF_TASK_ASSIGNMENTS and CAC_SR_OBJECT_CAPACITY.
It has one row for each shift (or trip) generated per resource per date.
It is driven off the departure task (task_type_id = 20).
Both departure and arrival tasks have a join to the same CAC_SR_OBJECT_CAPACITY row through JTF_TASK_ASSIGNMENTS.The trip date (CAPACITY_DATE) is taken as TRUNC(CAC_SR_OBJECT_CAPACITY.END_DATE_TIME).
The trip hours (CAPACITY_HOURS) is taken as (CAC_SR_OBJECT_CAPACITY.END_DATE_TIME - CAC_SR_OBJECT_CAPACITY.START_DATE_TIME).
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ISC_FS_CAPACITY_F_U1 | NORMAL | UNIQUE | APPS_TS_SUMMARY | TASK_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TASK_ID | NUMBER | Yes | Task identifier | |
OWNER_ID | NUMBER | Yes | Task Owner Resource identifier | |
OWNER_TYPE | VARCHAR2 | (8) | Yes | Task Owner Resource type: RESOURCE or GROUP or TEAM |
DISTRICT_ID | NUMBER | Yes | Task Owner District identifier | |
OBJECT_CAPACITY_ID | NUMBER | Capacity identifier | ||
CAPACITY_DATE | DATE | Trip Date | ||
CAPACITY_HOURS | NUMBER | Trip Hours | ||
BLOCKED_TRIP_FLAG | VARCHAR2 | (1) | Indicates if Trip is Blocked | |
DELETED_FLAG | VARCHAR2 | (1) | Indicates if Departure Task has been logically deleted. | |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT TASK_ID
, OWNER_ID
, OWNER_TYPE
, DISTRICT_ID
, OBJECT_CAPACITY_ID
, CAPACITY_DATE
, CAPACITY_HOURS
, BLOCKED_TRIP_FLAG
, DELETED_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, PROGRAM_ID
, PROGRAM_LOGIN_ID
, PROGRAM_APPLICATION_ID
, REQUEST_ID
FROM ISC.ISC_FS_CAPACITY_F;
ISC.ISC_FS_CAPACITY_F does not reference any database object
ISC.ISC_FS_CAPACITY_F is referenced by following:
|
|
|