[Home] [Help] [Dependency Information]
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").
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
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;
ISC.ISC_FS_TASK_ACTIVITY_F does not reference any database object
ISC.ISC_FS_TASK_ACTIVITY_F is referenced by following:
|
|
|