# Oracle Fusion Field Service schema ERD

Table and field reference for the Fivetran Oracle Fusion Field Service connector.

## Table & Field Reference

### enumeration_list_translation

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| enumeration_list_id | Unknown | PK, FK |
| enumeration_list_property_label_id | Unknown | PK, FK |
| language_iso | Unknown |  |
| languages | Unknown |  |
| name | Unknown |  |

### enumeration_list

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| property_label_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |

### work_zone_shape

| Column | Type | Keys |
| --- | --- | --- |
| shape_id | Unknown | PK |
| _fivetran_id | Unknown | PK, FK |

### 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| label | Unknown | FK |
| start_date | Unknown |  |

### capacity_category_translation

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| _fivetran_id | Unknown | PK, FK |
| language_iso | Unknown |  |
| languages | Unknown |  |
| name | Unknown |  |

### capacity_category_time_slot

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| _fivetran_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| schedule_item_id | Unknown | PK, FK |
| recur_every | Unknown |  |
| recurrence_type | Unknown |  |

### resource_descendant_work_skill

| Column | Type | Keys |
| --- | --- | --- |
| resource_descendant_internal_id | Unknown | PK, FK |
| work_skill | Unknown | PK, FK |

### resource_descendant_work_zone

| Column | Type | Keys |
| --- | --- | --- |
| resource_descendant_internal_id | Unknown | PK, FK |
| work_zone_item_id | Unknown | PK, FK |

### resource_descendant_inventory

| Column | Type | Keys |
| --- | --- | --- |
| inventory_id | Unknown | PK, FK |
| resource_descendant_internal_id | Unknown | PK, FK |

### 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 | PK, FK |
| language_iso | Unknown |  |
| languages | Unknown |  |
| name | Unknown |  |

### activity_type_time_slot

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| activity_type_id | Unknown | PK, FK |
| 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 | PK, FK |
| id | Unknown | PK, FK |

### activity_type_group_translation

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| _fivetran_id | Unknown | PK, FK |
| 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 | PK, FK |
| label | Unknown | FK |
| ratio | Unknown |  |

### work_skill_group_translation

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| _fivetran_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 |  |

## Relationships

- enumeration_list_translation(enumeration_list_id) → enumeration_list(id)
- enumeration_list_translation(enumeration_list_property_label_id) → enumeration_list(property_label_id)
- enumeration_list(property_label_id) → property(id)
- capacity_area(parent_label) → capacity_area(_fivetran_id)
- property_translation(property_id) → property(id)
- key_work_zone(_fivetran_id) → work_zone(_fivetran_id)
- work_zone_shape(_fivetran_id) → work_zone(_fivetran_id)
- non_working_reason_translation(non_working_reason_id) → non_working_reason(id)
- capacity_category_work_skill(label) → work_skill(_fivetran_id)
- capacity_category_work_skill(_fivetran_id) → capacity_category(_fivetran_id)
- capacity_category_work_skill_group(label) → work_skill_group(_fivetran_id)
- capacity_category_work_skill_group(_fivetran_id) → capacity_category(_fivetran_id)
- capacity_category_translation(_fivetran_id) → capacity_category(_fivetran_id)
- capacity_category_time_slot(_fivetran_id) → capacity_category(_fivetran_id)
- resource_type_translation(resource_type_id) → resource_type(id)
- route(activity_id) → activity(activity_id)
- route(resource_id) → resource_descendant(resource_internal_id)
- inventory_type_translation(_fivetran_id) → inventory_type(_fivetran_id)
- inventory(resource_id) → resource_descendant(resource_internal_id)
- inventory(from_activity_id) → activity(activity_id)
- inventory(to_activity_id) → activity(activity_id)
- work_skill_translation(_fivetran_id) → work_skill(_fivetran_id)
- resource_descendant_work_schedule(schedule_item_id) → work_schedule(schedule_item_id)
- resource_descendant_work_schedule(resource_descendant_internal_id) → resource_descendant(resource_internal_id)
- resource_descendant_work_skill(work_skill) → resource_work_skill(_fivetran_id)
- resource_descendant_work_skill(resource_descendant_internal_id) → resource_descendant(resource_internal_id)
- resource_descendant_work_zone(work_zone_item_id) → resource_work_zone(work_zone_item_id)
- resource_descendant_work_zone(resource_descendant_internal_id) → resource_descendant(resource_internal_id)
- resource_descendant_inventory(inventory_id) → inventory(inventory_id)
- resource_descendant_inventory(resource_descendant_internal_id) → resource_descendant(resource_internal_id)
- activity_type_translation(activity_type_id) → activity_type(id)
- activity_type_time_slot(activity_type_id) → activity_type(id)
- activity_group_type(id) → activity_type(id)
- activity_group_type(_fivetran_id) → activity_type_group(_fivetran_id)
- activity_type_group_translation(_fivetran_id) → activity_type_group(_fivetran_id)
- group_work_skill_data(label) → work_skill(_fivetran_id)
- group_work_skill_data(_fivetran_id) → work_skill_group(_fivetran_id)
- work_skill_group_translation(_fivetran_id) → work_skill_group(_fivetran_id)
- organization_translation(_fivetran_id) → organization(_fivetran_id)
- form_translation(_fivetran_id) → forms(_fivetran_id)
- resource_preference(resource_id) → resource_descendant(resource_internal_id)
- activity(team_resource_id) → resource_descendant(resource_internal_id)
- activity(activity_type_label) → activity_type(id)
- activity(resource_id) → resource_descendant(resource_internal_id)
- linked_activity(from_activity_id) → activity(activity_id)
- linked_activity(to_activity_id) → activity(activity_id)