Oracle Fusion Field Service

Explore the interactive ERD

Table & Field Reference

enumeration_list_translation

Column	Type	Keys
`index`	Unknown	PK
`enumeration_list_id`	Unknown	PKFK
`enumeration_list_property_label_id`	Unknown	PKFK
`language_iso`	Unknown
`languages`	Unknown
`name`	Unknown

enumeration_list

Column	Type	Keys
`id`	Unknown	PK
`property_label_id`	Unknown	PKFK
`active`	Unknown

capacity

Column	Type	Keys
`_fivetran_id`	String	PK
`calendar`	Json
`categories`	Json
`date`	Unknown
`label`	Unknown

capacity_area

Column	Type	Keys
`_fivetran_id`	String	PK
`parent_label`	Unknown	FK
`label`	Unknown
`name`	Unknown
`parent_name`	Unknown
`status`	Unknown
`type`	Unknown

property_translation

Column	Type	Keys
`index`	Unknown	PK
`property_id`	Unknown	PKFK
`hint`	Unknown
`language_iso`	Unknown
`languages`	Unknown
`name`	Unknown

property

Column	Type	Keys
`id`	Unknown	PK
`entity`	Unknown
`gui`	Unknown
`hint`	Unknown
`name`	Unknown
`type`	Unknown

key_work_zone

Column	Type	Keys
`key_id`	Unknown	PK
`_fivetran_id`	Unknown	PKFK

work_zone_shape

Column	Type	Keys
`shape_id`	Unknown	PK
`_fivetran_id`	Unknown	PKFK

work_zone

Column	Type	Keys
`_fivetran_id`	String	PK
`status`	Unknown
`travel_area`	Unknown
`work_zone_label`	Unknown
`work_zone_name`	Unknown

time_slot

Column	Type	Keys
`id`	Unknown	PK
`active`	Unknown
`is_all_day`	Unknown
`name`	Unknown
`time_end`	Unknown
`time_start`	Unknown

quota

Column	Type	Keys
`_fivetran_id`	String	PK
`booked_activity`	Unknown
`date`	Unknown
`label`	Unknown
`max_available`	Unknown
`min_quota`	Unknown
`name`	Unknown
`other_activity`	Unknown
`quota`	Unknown
`quota_is_auto_closed`	Unknown
`quota_is_closed`	Unknown
`quota_percent`	Unknown
`used`	Unknown
`used_quota_percent`	Unknown

non_working_reason_translation

Column	Type	Keys
`index`	Unknown	PK
`non_working_reason_id`	Unknown	PKFK
`language_iso`	Unknown
`languages`	Unknown
`name`	Unknown

non_working_reason

Column	Type	Keys
`id`	Unknown	PK
`active`	Unknown
`name`	Unknown

capacity_category_work_skill

Column	Type	Keys
`index`	Unknown	PK
`_fivetran_id`	Unknown	PKFK
`label`	Unknown	FK
`end_date`	Unknown
`ratio`	Unknown
`start_date`	Unknown

capacity_category_work_skill_group

Column	Type	Keys
`index`	Unknown	PK
`_fivetran_id`	Unknown	PKFK
`label`	Unknown	FK
`start_date`	Unknown

capacity_category_translation

Column	Type	Keys
`index`	Unknown	PK
`_fivetran_id`	Unknown	PKFK
`language_iso`	Unknown
`languages`	Unknown
`name`	Unknown

capacity_category_time_slot

Column	Type	Keys
`index`	Unknown	PK
`_fivetran_id`	Unknown	PKFK
`label`	Unknown

capacity_category

Column	Type	Keys
`_fivetran_id`	String	PK
`active`	Unknown
`label`	Unknown
`name`	Unknown

resource_type_translation

Column	Type	Keys
`index`	Unknown	PK
`resource_type_id`	Unknown	PKFK
`language_iso`	Unknown
`languages`	Unknown
`name`	Unknown

resource_type

Column	Type	Keys
`id`	Unknown	PK
`active`	Unknown
`name`	Unknown
`role`	Unknown

route

Column	Type	Keys
`activity_id`	Unknown	PKFK
`resource_id`	Unknown	FK
`appt_number`	Unknown
`city`	Unknown
`resource_internal_id`	Unknown

inventory_type_translation

Column	Type	Keys
`index`	Unknown	PK
`_fivetran_id`	Unknown	PKFK
`language_iso`	Unknown
`languages`	Unknown
`name`	Unknown
`unit_of_measurement`	Unknown

inventory_type

Column	Type	Keys
`_fivetran_id`	String	PK
`active`	Unknown
`label`	Unknown
`model_property`	Unknown
`name`	Unknown
`non_serialized`	Unknown
`unit_of_measurement`	Unknown

work_schedule

Column	Type	Keys
`schedule_item_id`	Unknown	PK
`end_date`	Unknown
`is_working`	Unknown
`record_type`	Unknown
`recur_every`	Unknown
`recurrence_type`	Unknown
`shift_type`	Unknown
`start_date`	Unknown
`work_time_end`	Unknown
`work_time_start`	Unknown

work_zone_key

Column	Type	Keys
`_fivetran_id`	String	PK
`api_parameter_name`	Unknown
`function`	Unknown
`label`	Unknown
`length`	Unknown
`orders`	Unknown

inventory

Column	Type	Keys
`inventory_id`	Unknown	PK
`from_activity_id`	Unknown	FK
`resource_id`	Unknown	FK
`to_activity_id`	Unknown	FK
`inventory_type`	Unknown
`quantity`	Unknown
`serial_number`	Unknown
`status`	Unknown

work_skill_translation

Column	Type	Keys
`index`	Unknown	PK
`_fivetran_id`	Unknown	PKFK
`language_iso`	Unknown
`languages`	Unknown
`name`	Unknown

work_skill

Column	Type	Keys
`_fivetran_id`	String	PK
`active`	Unknown
`label`	Unknown
`name`	Unknown
`sharing`	Unknown

resource_descendant_work_schedule

Column	Type	Keys
`resource_descendant_internal_id`	Unknown	PKFK
`schedule_item_id`	Unknown	PKFK
`recur_every`	Unknown
`recurrence_type`	Unknown

resource_descendant_work_skill

Column	Type	Keys
`resource_descendant_internal_id`	Unknown	PKFK
`work_skill`	Unknown	PKFK

resource_descendant_work_zone

Column	Type	Keys
`resource_descendant_internal_id`	Unknown	PKFK
`work_zone_item_id`	Unknown	PKFK

resource_descendant_inventory

Column	Type	Keys
`inventory_id`	Unknown	PKFK
`resource_descendant_internal_id`	Unknown	PKFK

resource_descendant

Column	Type	Keys
`resource_internal_id`	Unknown	PK
`date_format`	Unknown
`duration_statistics_initial_period`	Unknown
`duration_statistics_initial_ratio`	Unknown
`email`	Unknown
`language_iso`	Unknown
`languages`	Unknown
`name`	Unknown
`organization_label`	Unknown
`parent_resource_id`	Unknown
`parent_resource_internal_id`	Unknown
`phone`	Unknown
`resource_id`	Unknown
`resource_type`	Unknown
`status`	Json
`time_format`	Unknown
`time_zone`	Unknown
`time_zone_diff`	Unknown
`time_zone_i_a_n_a`	Unknown
`xa_tech_alias`	Unknown
`xp_bulked`	Unknown
`xp_notification`	Unknown
`xp_truck_nmbr`	Unknown

activity_type_translation

Column	Type	Keys
`index`	Unknown	PK
`activity_type_id`	Unknown	PKFK
`language_iso`	Unknown
`languages`	Unknown
`name`	Unknown

activity_type_time_slot

Column	Type	Keys
`index`	Unknown	PK
`activity_type_id`	Unknown	PKFK
`label`	Unknown

activity_type

Column	Type	Keys
`id`	Unknown	PK
`active`	Unknown
`color_cancelled`	Unknown
`color_completed`	Unknown
`color_enroute`	Unknown
`color_not_done`	Unknown
`color_not_ordered`	Unknown
`color_pending`	Unknown
`color_started`	Unknown
`color_suspended`	Unknown
`color_warning`	Unknown
`default_duration`	Unknown
`features_allow_creation_in_bucket`	Unknown
`features_allow_mass_activity`	Unknown
`features_allow_move_between_resource`	Unknown
`features_allow_non_scheduled`	Unknown
`features_allow_repeating_activity`	Unknown
`features_allow_reschedule`	Unknown
`features_allow_to_create_from_incoming_interface`	Unknown
`features_allow_to_search`	Unknown
`features_calculate_activity_duration_using_statistics`	Unknown
`features_calculate_delivery_window`	Unknown
`features_calculate_travel`	Unknown
`features_disable_location_tracking`	Unknown
`features_enable_day_before_trigger`	Unknown
`features_enable_not_started_trigger`	Unknown
`features_enable_reminder_and_change_trigger`	Unknown
`features_enable_sw_warning_trigger`	Unknown
`features_is_segmenting_enabled`	Unknown
`features_is_team_work_available`	Unknown
`features_sla_and_service_window_use_customer_timezone`	Unknown
`features_support_of_inventory`	Unknown
`features_support_of_link`	Unknown
`features_support_of_not_ordered_activity`	Unknown
`features_support_of_preferred_resource`	Unknown
`features_support_of_required_inventory`	Unknown
`features_support_of_timeslot`	Unknown
`features_support_of_work_skill`	Unknown
`features_support_of_work_zone`	Unknown
`group_label`	Unknown
`name`	Unknown

activity_group_type

Column	Type	Keys
`_fivetran_id`	Unknown	PKFK
`id`	Unknown	PKFK

activity_type_group_translation

Column	Type	Keys
`index`	Unknown	PK
`_fivetran_id`	Unknown	PKFK
`language_iso`	Unknown
`languages`	Unknown
`name`	Unknown

activity_type_group

Column	Type	Keys
`_fivetran_id`	String	PK
`label`	Unknown
`name`	Unknown

group_work_skill_data

Column	Type	Keys
`index`	Unknown	PK
`_fivetran_id`	Unknown	PKFK
`label`	Unknown	FK
`ratio`	Unknown

work_skill_group_translation

Column	Type	Keys
`index`	Unknown	PK
`_fivetran_id`	Unknown	PKFK
`language_iso`	Unknown
`languages`	Unknown
`name`	Unknown

work_skill_group

Column	Type	Keys
`_fivetran_id`	String	PK
`active`	Unknown
`add_to_capacity_category`	Unknown
`assign_to_resource`	Unknown
`label`	Unknown
`name`	Unknown

routing_profile

Column	Type	Keys
`_fivetran_id`	String	PK
`profile_label`	Unknown

organization_translation

Column	Type	Keys
`index`	Unknown	PK
`_fivetran_id`	Unknown	PKFK
`language_iso`	Unknown
`languages`	Unknown
`name`	Unknown

organization

Column	Type	Keys
`_fivetran_id`	String	PK
`label`	Unknown
`name`	Unknown
`type`	Unknown

location

Column	Type	Keys
`location_id`	Unknown	PK
`address`	Unknown
`city`	Unknown
`country`	Unknown
`label`	Unknown
`latitude`	Unknown
`longitude`	Unknown
`postal_code`	Unknown
`state`	Unknown

form_translation

Column	Type	Keys
`index`	Unknown	PK
`_fivetran_id`	Unknown	PKFK
`language_iso`	Unknown
`languages`	Unknown
`name`	Unknown

forms

Column	Type	Keys
`_fivetran_id`	String	PK
`label`	Unknown
`name`	Unknown

resource_work_zone

Column	Type	Keys
`work_zone_item_id`	Unknown	PK
`ratio`	Unknown
`recur_every`	Unknown
`recurrence`	Unknown
`start_date`	Unknown
`type`	Unknown
`work_zone`	Unknown
`work_zone_status`	Unknown

resource_work_skill

Column	Type	Keys
`_fivetran_id`	String	PK
`end_date`	Unknown
`ratio`	Unknown
`start_date`	Unknown
`work_skill`	Unknown

resource_preference

Column	Type	Keys
`resource_id`	Unknown	PKFK
`preference_type`	Json

activity

Column	Type	Keys
`activity_id`	Unknown	PK
`activity_type_label`	Unknown	FK
`resource_id`	Unknown	FK
`team_resource_id`	Unknown	FK
`access_schedule`	Unknown
`activity_flow`	Unknown
`appt_number`	Unknown
`auto_routed_to_date`	Unknown
`auto_routed_to_resource`	Unknown
`city`	Unknown
`coordinate_accuracy`	Unknown
`country_code`	Unknown
`customer_cell`	Unknown
`customer_email`	Unknown
`customer_name`	Unknown
`customer_number`	Unknown
`customer_phone`	Unknown
`date`	Unknown
`delivery_window_end`	Unknown
`delivery_window_start`	Unknown
`duration`	Unknown
`end_time`	Unknown
`first_manual_operation`	Unknown
`first_manual_operation_user`	Unknown
`ib_asset_id`	Unknown
`language_iso`	Unknown
`languages`	Unknown
`latitude`	Unknown
`longitude`	Unknown
`master_activity_id`	Unknown
`pjf_project_element_id`	Unknown
`pjf_project_id`	Unknown
`point`	Unknown
`position_in_route`	Unknown
`postal_code`	Unknown
`record_type`	Unknown
`reminder_time`	Unknown
`resource_time_zone`	Unknown
`resource_time_zone_diff`	Unknown
`resource_time_zone_iana`	Unknown
`service_window_end`	Unknown
`service_window_start`	Unknown
`sla_window_end`	Unknown
`sla_window_start`	Unknown
`start_time`	Unknown
`state_province`	Unknown
`status`	Unknown
`street_address`	Unknown
`svc_work_order_id`	Unknown
`time_delivered_end`	Unknown
`time_delivered_start`	Unknown
`time_of_assignment`	Unknown
`time_of_booking`	Unknown
`time_slot`	Unknown
`time_zone`	Unknown
`time_zone_iana`	Unknown
`travel_estimation_method`	Unknown
`travel_time`	Unknown
`wie_work_order_id`	Unknown
`wie_work_order_operation_id`	Unknown
`work_zone`	Unknown
`custom_`

required_inventory

Column	Type	Keys
`_fivetran_id`	String	PK
`inventory_type`	Unknown
`model`	Unknown
`quantity`	Unknown

linked_activity

Column	Type	Keys
`_fivetran_id`	String	PK
`from_activity_id`	Unknown	FK
`to_activity_id`	Unknown	FK
`alert`	Unknown
`link_type`	Unknown
`max_interval_value`	Unknown