FFS_ACTIVITY
Contains all activities except shift/mass/repeating ones.
Details
-
Schema: FUSION
-
Object owner: FFS
-
Object type: TABLE
-
Tablespace: DATA
Primary Key
| Name | Columns |
|---|---|
|
FFS_ACTIVITY_PK |
ACTIVITY_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ARCH_DATE | DATE | Yes | DB record partitioning date. Set automatically by DB Optimization job. | ||
| ACTIVITY_ID | NUMBER | 10 | Yes | Unique identifier of the activity in Oracle Field Service. | |
| ROUTE_ID | NUMBER | 10 | Yes | Identifier of the route this activity belongs to. | |
| MASTER_ACTIVITY_ID | NUMBER | 10 | Identifier of a segmentable activity. It is available for activities that are segments of a segmentable activity which has the recordType=multiday_activity_segment. This field is not set for regular activities. | ||
| TEMPLATE_ID | NUMBER | 8 | Identifier of the repeating/mass/shift activity this record belongs to. | ||
| TEAM_RESOURCE_ID | NUMBER | 8 | Activity Team holder resource reference. Used for teamwork activities. | ||
| VISIT_ID | NUMBER | 10 | Activity Reference to Visit. Used when activites are combined to visits. | ||
| ACTIVITY_NUMBER | VARCHAR2 | 160 | Identifier of the activity in the origin system. The value can be empty. | ||
| RECORD_TYPE | VARCHAR2 | 25 | Activity type . The following values are allowed: 'regular', 'reopened', 'prework', 'multiday_activity', 'multiday_activity_segment'. | ||
| TYPE_ID | NUMBER | 5 | Reference to Activity Work Type List. | ||
| WORK_ZONE_ID | NUMBER | 8 | Yes | Activity work zone reference . It is a read-only field that is automatically assigned to an activity, based on the company setting 'work zone key' and the activity properties. | |
| STATUS | VARCHAR2 | 9 | Activity Status. As a technician works through the activity, the status changes. The actions that are available for an activity are based on this status. Allowed Values: 'cancelled', 'completed', 'suspended', 'started', 'enroute', 'pending', 'notdone'. | ||
| DURATION | NUMBER | 6 | Estimated activity duration in minutes. Fills with actual duration after activity start. | ||
| ETA | TIMESTAMP | Predicted or the actual activity start time. The time is displayed in the time zone of the resource to which the activity is assigned, ETA Time. Can be empty for regular and reopen appointments if status is pending or suspended. For started and ended - time when appointment is started. For cancelled can be empty or set, If set - it is time when provider started appointment before it was. | |||
| TIME_DELIVERED_START | TIMESTAMP | Start time of the technician's arrival interval as communicated to the customer. The value is used by routing optimization engine to reduce changes to arrival time, so it is important to keep the value actual. | |||
| TIME_DELIVERED_END | TIMESTAMP | End time of the technician's arrival interval as communicated to the customer. The value is used by routing optimization engine to reduce changes to arrival time, so it is important to keep the value actual. | |||
| TIME_SLOT_ID | NUMBER | 5 | Reference To The time slot during which the activity is completed. The time slot also indicates the service window for the activity. This time is displayed in the time zone of the resource to which the activity is assigned. | ||
| SERVICE_WINDOW_START | NUMBER | 5 | Activity Service window start time. Service window is returned in the time zone of the resource to which the activity is currently assigned. | ||
| SERVICE_WINDOW_END | NUMBER | 5 | Activity Service window end time. Service window is returned in the time zone of the resource to which the activity is currently assigned. | ||
| DELIVERY_WINDOW_START | NUMBER | 5 | Activity delivery window start time. The time is displayed in the time zone of the resource to which the activity is assigned. | ||
| DELIVERY_WINDOW_END | NUMBER | 5 | Activity delivery window end time. The time is displayed in the time zone of the resource to which the activity is assigned. | ||
| TRAVEL_TIME | NUMBER | 5 | Estimated time taken to travel to this activity. For activities that were started (status is 'started', 'completed', 'notdone') this parameter indicates reported travelling time, which is calculated based on the actual times. | ||
| TRAVEL_ESTIMATION_METHOD | NUMBER | 3 | Yes | Travel estimation method. It is a read-only field. The following values are returned: Airline Distance , Airline Distance and Statistics, External Adjustment,Manual Adjustment,Not Estimated,Point to Point,Same Location,Statistics,Street Level Routing,Travel key based Airline Distance,Using Defaults. | |
| TRAVEL_FROM_ACTIVITY_ID | NUMBER | 10 | Previous Activity identifier. Used only for travel adjustment process. | ||
| CONTINUOUS_TRAVELING_TIME | NUMBER | 5 | Time of travel between activities/locations with addresses/coordinates. | ||
| CUSTOMER_NAME | VARCHAR2 | 1680 | Activity Name of the customer. Maximum field length is 420. Encrypted. | ||
| CUSTOMER_NUMBER | VARCHAR2 | 160 | Activity account number of the customer. This field is used by integrations as a placeholder for the external identifier of the Account ID in the application. This parameter has no business significance in Oracle Field Service and can be left empty. Maximum field length is 40. | ||
| CUSTOMER_PHONE | VARCHAR2 | 960 | Activity regular (land) phone number of the customer. Encrypted. | ||
| CUSTOMER_EMAIL | VARCHAR2 | 1280 | Activity email address of the customer. Maximum field length is 320.Encrypted. | ||
| CUSTOMER_CELL | VARCHAR2 | 960 | Activity cell phone number of the customer. Encrypted. | ||
| LOCATION_ID | NUMBER | 8 | Deprecated. Will be removed soon. | ||
| STREET_ADDRESS | VARCHAR2 | 960 | Activity street address of the customer. This field is used for geocoding and must contain a valid address. Maximum field length is 240. Encrypted. | ||
| CITY | VARCHAR2 | 240 | Activity city of the customer where the activity is scheduled. Maximum field length is 60. | ||
| POSTAL_CODE | VARCHAR2 | 240 | Activity ZIP code of the customer where the activity is scheduled. | ||
| STATE_PROVINCE | VARCHAR2 | 240 | Activity state of the customer where the activity is scheduled. Maximum field length is 60. | ||
| LANGUAGE_ID | NUMBER | 3 | Activity language. Reference to Language.Lid. | ||
| REMINDER_TIME | NUMBER | 5 | Number of minutes before the activity start time the customer must be notified of the activity. | ||
| TIME_ZONE_ID | NUMBER | 3 | Activity Time Zone. Reference to Time_Zone.Zid. | ||
| DIFF | NUMBER | 5 | Activity Time Zone Difference. Filled automatically based on selected time_zone_id. | ||
| UPDATE_FLAGS | NUMBER | 18 | Activity Type features. Filled automatically after Activity Type selection. | ||
| COORD_STATUS | VARCHAR2 | 9 | Activity coordinates found staues: 'Is Found', 'Not_Found'. | ||
| COORD_ACCURACY | NUMBER | 3 | Yes | Activity accuracy Level Of Geocoding Coordinates Not Valid - -1 Undefined - 0 Country - 1 State - 2 County - 3 City - 4 Zip - 5 Route - 6 Street - 7 Intersection - 8 Address - 9. | |
| COORD_X | NUMBER | 8 | Geographic coordinates that specify the location of the activity. | ||
| COORD_Y | NUMBER | 8 | Geographic coordinates that specify the location of the activity. | ||
| SLA_START | TIMESTAMP | Time when the service level agreement (SLA) window starts. SLA window is returned in the time zone of the resource to which the activity is currently assigned. | |||
| SLA_END | TIMESTAMP | Time when the service level agreement (SLA) window ends. The time is displayed in 'YYYY-MM-DD HH:MM:SS' format. SLA window is returned in the time zone of the resource to which the activity is currently assigned. | |||
| FEATURES | NUMBER | 10 | It is a bitmask field that defines active features for this activity. This value is copied from a selected activity type on create/update actions. | ||
| POINTS | NUMBER | 5 | The cost of the activity in 'points'. This field is intended for use by the Routing module. | ||
| COMPLIANCE | NUMBER | 10 | Yes | Bit-Mask that represents Activity compliance parameters (Compliance_* Constants). | |
| TIME_OF_BOOKING | TIMESTAMP | Time when the customer booked the activity. The time is displayed in the time zone of the customer. | |||
| TIME_OF_ASSIGNMENT | TIMESTAMP | Time when the activity is assigned to the technician. This time is displayed in the time zone of the resource to which the activity is assigned. | |||
| AUTO_ROUTED_TO_RESOURCE_ID | NUMBER | 8 | Resource This Activity Was Assigned To During The Latest Routing Run. | ||
| AUTO_ROUTED_TO_DATE | DATE | Date This Activity Was Scheduled For During The Latest Routing Run. | |||
| FIRST_MANUAL_OPER | NUMBER | 3 | Name Of The First Manual Reschedule/Move/Reorder Operation Performed After An Automatic One. | ||
| FIRST_MANUAL_OPER_USER_ID | NUMBER | 18 | Identifier Of user who performed the first manual reschedule/Move/Reorder operation after an automatic one. | ||
| FIRST_MANUAL_OPER_INTERFACE | NUMBER | 3 | Interface The First Manual Reschedule/Move/Reorder Operation Was Performed From After An Automatic One. | ||
| ACCESS_HOURS | VARCHAR2 | 1020 | Activity access hours.It is generally not possible to work beyond the access hours. | ||
| ACCESS_SCHEDULE | VARCHAR2 | 1020 | The schedule (that is, the set of time intervals or access hours, two intervals per week day) when the asset or the activity location is accessible. Work must start and complete during this interval. It is generally not possible to work beyond the access hours. Maximum field length is 1020. | ||
| ACTIVITY_FLOW_ID | NUMBER | 10 | Reference to identifier of a flow that will be used to guide activity processing. | ||
| SVC_WO_ID | NUMBER | 18 | Identifier Of Fusion Service Work Order the Activity is linked to. Optional Field. Reference To Svc_Work_Orders.Wo_Id In Fusion. | ||
| WIE_WO_ID | NUMBER | 18 | Identifier Of Maintenance Work Order the activity Is linked to. Optional Field. Reference to Wie_Work_Orders_B.Work_Order_Id In Fusion. | ||
| WIE_WO_OPERATION_ID | NUMBER | 18 | Identifier Of Maintenance Work Order Operation the activity is linked to. Optional Field. Reference to Wie_Wo_Operations_B.Wo_Operation_Id In Fusion. | ||
| IB_ASSET_ID | NUMBER | 18 | Identifier Of installed based asset the activity is linked to. Optional Field. Reference To Cse_Assets_B.Asset_Id In Fusion. | ||
| PJF_PROJECT_ID | NUMBER | 18 | Identifier Of project the Activity is linked to. Optional Field. Reference to Pjf_Projects_All_B.Project_Id In Fusion. | ||
| PJF_PROJ_ELEMENT_ID | NUMBER | 18 | Identifier of project task the activity is linked to. Optional Field. Reference To Pjf_Proj_Elements_B.Proj_Element_Id In Fusion. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| WMT_TOKEN | VARCHAR2 | 12 | Generated unique 8-symbol base62 string (ShUT), unique key to activity for the end customer. | ||
| WMT_THEME_ID | NUMBER | 10 | WMT theme (by id) which displays the activity to an end customer. | ||
| WMT_LINK_CREATED_DATE | TIMESTAMP | Date/time when the WMT_TOKEN has been generated. | |||
| WMT_LINK_OPENED_DATE | TIMESTAMP | Date/time when the WMT_TOKEN has been opened for the first time by the customer. | |||
| WMT_SERVICE_RATING | NUMBER | 2 | Numeric feedback (1-5) from the end customer, null by default. | ||
| WMT_SERVICE_COMMENT | VARCHAR2 | 4000 | Feedback text from the end customer, null by default. | ||
| WMT_FEEDBACK_DATE | TIMESTAMP | Date/time when a WMT_SERVICE_RATING and/or WMT_SERVICE_RATING were provided by the end customer. | |||
| COORD_VIEWPORT_RADIUS | NUMBER | 6 | Radius of activity location viewport returned by geoprovider in meters. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FFS_ACTIVITY_N1 | Non Unique | DATA | MASTER_ACTIVITY_ID |
| FFS_ACTIVITY_N2 | Non Unique | DATA | TEAM_RESOURCE_ID |
| FFS_ACTIVITY_N3 | Non Unique | DATA | VISIT_ID |
| FFS_ACTIVITY_N4 | Non Unique | DATA | ROUTE_ID |
| FFS_ACTIVITY_PK | Unique | DATA | ACTIVITY_ID |