Available Activity Fields
This section provides the activity fields that you can use while integrating Oracle Field Service with other applications.
Field |
Label |
Data Type |
Mandatory |
Description |
---|---|---|---|---|
Account Number |
appt.customer_number |
VARCHAR2 |
String with name of customer account in external system |
|
Activity ID |
appt.aid |
INTEGER |
true |
Unique numeric identifier of the activity |
Activity Time of Assignment |
appt.atime_of_assignment |
DATE |
Date/Time when the last move/reschedule/assign to resource operation was performed for the activity. |
|
Activity Time of Booking |
appt.atime_of_booking |
DATE |
Date/time when the activity was booked. |
|
Activity Type |
appt.atype |
VARCHAR2 |
Primary type of the activity (prework, reopened, regular...) |
|
Activity Work Type |
appt.aworktype |
VARCHAR2 |
Identifier of the activity type defined for the activity. |
|
Activity Workflow | appt.activity_flow | VARCHAR2 | Activity workflow assigned to the activity | |
Activity Work Zone |
appt.aworkzone |
VARCHAR2 |
Work zone which is defined for the activity |
|
Activity status |
appt.astatus |
VARCHAR2 |
Status of the activity. |
|
City |
appt.ccity |
VARCHAR2 |
City name, part of Customer address |
|
Coordinate X |
appt.acoord_x |
FLOAT |
X coordinate received from geocoding module for the activity |
|
Coordinate Y |
appt.acoord_y |
FLOAT |
Y coordinate received from geocoding module for the activity |
|
Customer Email |
appt.cemail |
VARCHAR2 |
Email of the customer for whom the activity is provided |
|
Customer Language |
appt.clanguage |
VARCHAR2 |
Message language of the customer for whom the activity is provided |
|
Customer Name |
appt.cname |
VARCHAR2 |
Name of the customer for whom the activity is provided. |
|
Customer Phone |
appt.cphone |
VARCHAR2 |
Phone number of the customer for whom the activity is provided. |
|
Customer Time Zone |
appt.c_zid |
VARCHAR2 |
Time Zone ID of the customer for whom the activity is provided. |
|
Delivery Window End |
appt.delivery_window_end |
DATE |
End time for activity Delivery Window |
|
Delivery Window start |
appt.delivery_window_start |
DATE |
Start time for activity Delivery Window |
|
Delivery address |
appt.caddress |
VARCHAR2 |
Customer address (except City, Zip/Postal code, State) |
|
Duration |
appt.length |
INTEGER |
Activity length in minutes. Filled when activity is finished. Value = end time - start time. |
|
Estimated Time of arrival |
appt.ETA |
DATE |
ETA date/time. Can be empty for Regular and Reopen activities if status is Pending or Suspended. For Started and Ended - time when activity is started. For Canceled can be empty or set, if set - it is time when provider started an activity before it was Canceled |
|
First Manual Operation |
appt.first_manual_operation |
VARCHAR2 |
The name of the first manual reschedule/move/reorder operation performed after an automatic one. |
|
First Manual Operation (User ID) |
appt.first_manual_operation_user_id |
VARCHAR2 |
The interface the first manual reschedule/move/reorder operation was performed from after an automatic one. |
|
Master Activity ID |
appt.amaster_aid |
INTEGER |
ID of main activity for prework, reassigned and reopened activities |
|
Mobile Phone |
appt.ccell |
VARCHAR2 |
Mobile phone number of the customer for whom the activity is provided. |
|
Points |
appt.apoints |
INTEGER |
Number of points that represent efforts required to perform the activity. |
|
Postal Code |
appt.czip |
VARCHAR2 |
ZIP/Postal code of customer for whom the activity is provided. |
|
Reminder |
appt.cmessagetime |
INTEGER |
Number of minutes before Delivery Window/ETA when reminder notification is sent. |
|
Reported End Time of Activity Delivery |
appt.time_delivered_end |
DATE |
End date/time of activity which is delivered to the customer. |
|
Reported Start Time of Activity Delivery |
appt.ctime_delivered_start |
DATE |
Start date/time of activity which is delivered to the customer. |
|
Resource External ID |
provider.external_id |
VARCHAR2 |
External system identifier for the resource the activity is assigned to |
|
Resource ID |
provider.pid |
INTEGER |
ID of resource the activity is assigned to. |
|
Route Date |
queue.date |
DATE |
Date of the route the activity is assigned to. |
|
SLA End |
appt.sla_window_end |
DATE |
End date and time of Service Level Agreement |
|
SLA Start |
appt.sla_window_start |
DATE |
Start date and time of Service Level Agreement |
|
Service Window End |
appt.service_window_end |
VARCHAR2 |
End time of Service Window |
|
Service Window Start |
appt.service_window_start |
VARCHAR2 |
Start time of Service Window |
|
State |
appt.cstate |
VARCHAR2 |
State (Geographic area) of the customer for whom the activity is provided. |
|
Teamwork ID |
appt.a_teamid |
VARCHAR2 |
ID of team for teamwork activities |
|
Time Slot ID |
appt.a_tsid |
VARCHAR2 |
Time Slot assigned to the activity |
|
Traveling Time |
appt.travel |
INTEGER |
Time of travel from a previous activity/location. |
|
Work Order |
appt.appt_number |
VARCHAR2 |
Identifier of the activity (string, value of field "Work Order") |
|
* |
Activity Custom Fields |