# Oracle Fusion Cloud Applications - CRM schema ERD Table and field reference for the Fivetran Oracle Fusion Cloud Applications - CRM connector. ## Table & Field Reference ### earning_history_extract_pvo | Column | Type | Keys | | --- | --- | --- | | earning_history_id | Long | PK | | additional_data_ | String | | ### opportunity_time_based_snapshot_extract_pvo | Column | Type | Keys | | --- | --- | --- | | opportunity_time_based_snapshot_id | Long | PK | | additional_data_ | String | | ### srp_form_metric_extract_pvo | Column | Type | Keys | | --- | --- | --- | | srp_form_metric_id | Long | PK | | additional_data_ | String | | ### pay_group_translation_extract_pvo | Column | Type | Keys | | --- | --- | --- | | additional_data_ | String | | | pay_group_translation_id | Long | | ### comp_plan_translation_extract_pvo | Column | Type | Keys | | --- | --- | --- | | additional_data_ | String | | | comp_plan_translation_id | Long | | ### plan_component_formula_extract_pvo | Column | Type | Keys | | --- | --- | --- | | plan_component_formula_id | Long | PK | | additional_data_ | String | | ### web_activity_extract_pvo | Column | Type | Keys | | --- | --- | --- | | web_activity_id | Long | PK | | additional_data_ | String | | ### formula_translation_extract_pvo | Column | Type | Keys | | --- | --- | --- | | additional_data_ | String | | | formula_translation_id | Long | | ### comp_role_translation_extract_pvo | Column | Type | Keys | | --- | --- | --- | | additional_data_ | String | | | comp_role_translation_id | Long | | ### sales_account_territory_extract_pvo | Column | Type | Keys | | --- | --- | --- | | sales_account_territory_id | Long | PK | | additional_data_ | String | | ### opportunity_competitor_extract_pvo | Column | Type | Keys | | --- | --- | --- | | opty_competitor_id | Long | PK | | additional_data_ | String | | | cmpt_party_id | Long | | | opty_id | Long | | ### lead_tc_member_extract_pvo | Column | Type | Keys | | --- | --- | --- | | lead_tc_member_id | Long | PK | | additional_data_ | String | | ### participant_role_extract_pvo | Column | Type | Keys | | --- | --- | --- | | participant_role_id | Long | PK | | additional_data_ | String | | ### payment_plan_extract_pvo | Column | Type | Keys | | --- | --- | --- | | payment_plan_id | Long | PK | | additional_data_ | String | | ### revenue_territory_extract_pvo | Column | Type | Keys | | --- | --- | --- | | revenue_territory_id | Long | PK | | additional_data_ | String | | ### lead_item_assoc_extract_pvo | Column | Type | Keys | | --- | --- | --- | | lead_item_assoc_id | Long | PK | | additional_data_ | String | | ### participant_detail_extract_pvo | Column | Type | Keys | | --- | --- | --- | | participant_detail_id | Long | PK | | additional_data_ | String | | ### paysheet_extract_pvo | Column | Type | Keys | | --- | --- | --- | | paysheet_id | Long | PK | | additional_data_ | String | | ### sales_stage_extract_pvo | Column | Type | Keys | | --- | --- | --- | | stg_id | Long | PK | | additional_data_ | String | | | sales_method_id | Long | | | sales_stage_trnsltn_stg_id | Long | | ### credit_history_extract_pvo | Column | Type | Keys | | --- | --- | --- | | credit_history_id | Long | PK | | additional_data_ | String | | ### opportunity_resource_extract_pvo | Column | Type | Keys | | --- | --- | --- | | opty_resource_id | Long | PK | | additional_data_ | String | | | asgn_territory_version_id | Long | | | opty_id | Long | | | partner_org_id | Long | | | resource_id | Long | | ### channel_via_extract_pvo | Column | Type | Keys | | --- | --- | --- | | channel_via_id | Long | PK | | additional_data_ | String | | ### revenue_time_based_snapshot_extract_pvo | Column | Type | Keys | | --- | --- | --- | | revenue_time_based_snapshot_id | Long | PK | | additional_data_ | String | | ### opportunity_extract_pvo | Column | Type | Keys | | --- | --- | --- | | opty_id | Long | PK | | additional_data_ | String | | | asset_id | Long | | | bu_org_id | Long | | | curr_stg_id | Long | | | cust_account_id | Long | | | cust_party_id | Long | | | deal_horizon_code_set_id | Long | | | decision_lvl_code_set_id | Long | | | group_space_id | Long | | | ibasset_id | Long | | | opty_party_site_id | Long | | | owner_resource_id | Long | | | par_opty_id | Long | | | pr_cmpt_party_id | Long | | | pr_con_party_id | Long | | | pr_con_relationship_id | Long | | | primary_campaign_id | Long | | | primary_partner_id | Long | | | reason_won_lost_cd_set_id | Long | | | risk_lvl_code_set_id | Long | | | sales_account_id | Long | | | sales_method_id | Long | | | status_cd_set_id | Long | | | strategic_value_code_set_id | Long | | | sum_revn_id | Long | | ### participant_extract_pvo | Column | Type | Keys | | --- | --- | --- | | participant_id | Long | PK | | additional_data_ | String | | ### pay_run_extract_pvo | Column | Type | Keys | | --- | --- | --- | | pay_run_id | Long | PK | | additional_data_ | String | | ### interval_type_extract_pvo | Column | Type | Keys | | --- | --- | --- | | interval_type_id | Long | PK | | additional_data_ | String | | ### sales_method_extract_pvo | Column | Type | Keys | | --- | --- | --- | | sales_method_id | Long | PK | | additional_data_ | String | | ### snapshot_extract_pvo | Column | Type | Keys | | --- | --- | --- | | snapshot_id | Long | PK | | additional_data_ | String | | ### territory_extract_pvo | Column | Type | Keys | | --- | --- | --- | | territory_id | Long | PK | | additional_data_ | String | | ### measure_result_extract_pvo | Column | Type | Keys | | --- | --- | --- | | measure_result_id | Long | PK | | additional_data_ | String | | ### formula_extract_pvo | Column | Type | Keys | | --- | --- | --- | | formula_id | Long | PK | | additional_data_ | String | | ### channel_translation_extract_pvo | Column | Type | Keys | | --- | --- | --- | | additional_data_ | String | | | channel_translation_id | Long | | ### participant_comp_plan_extract_pvo | Column | Type | Keys | | --- | --- | --- | | participant_comp_plan_id | Long | PK | | additional_data_ | String | | ### revenue_extract_pvo | Column | Type | Keys | | --- | --- | --- | | revn_id | Long | PK | | additional_data_ | String | | | bu_org_id | Long | | | close_reason_code_set_id | Long | | | cr_rcpt_part_org_party_id | Long | | | cust_account_id | Long | | | cust_party_id | Long | | | inventory_item_id | Long | | | inventory_org_id | Long | | | opty_id | Long | | | opty_lead_id | Long | | | owner_resource_id | Long | | | parent_revn_id | Long | | | pr_cmpt_party_id | Long | | | pr_cmpt_product_id | Long | | | pr_part_org_party_id | Long | | | pr_territory_updated_by_id | Long | | | pr_territory_version_id | Long | | | prod_group_id | Long | | | recur_parent_revn_id | Long | | | sales_account_id | Long | | | split_parent_revn_id | Long | | | status_code_set_id | Long | | | type_code_set_id | Long | | ### credit_extract_pvo | Column | Type | Keys | | --- | --- | --- | | credit_id | Long | PK | | additional_data_ | String | | ### srp_period_goal_extract_pvo | Column | Type | Keys | | --- | --- | --- | | srp_period_goal_id | Long | PK | | additional_data_ | String | | ### lead_resource_extract_pvo | Column | Type | Keys | | --- | --- | --- | | lead_resource_id | Long | PK | | additional_data_ | String | | ### campaign_member_extract_pvo | Column | Type | Keys | | --- | --- | --- | | campaign_member_id | Long | PK | | additional_data_ | String | | ### sales_stage_translation_extract_pvo | Column | Type | Keys | | --- | --- | --- | | additional_data_ | String | | | sales_stage_translation_id | Long | | ### transaction_history_extract_pvo | Column | Type | Keys | | --- | --- | --- | | transaction_history_id | Long | PK | | additional_data_ | String | | ### lead_territory_assoc_extract_pvo | Column | Type | Keys | | --- | --- | --- | | lead_territory_assoc_id | Long | PK | | additional_data_ | String | | ### srp_interval_goal_extract_pvo | Column | Type | Keys | | --- | --- | --- | | srp_interval_goal_id | Long | PK | | additional_data_ | String | | ### transaction_extract_pvo | Column | Type | Keys | | --- | --- | --- | | transaction_id | Long | PK | | additional_data_ | String | | ### territory_coverage_extract_pvo | Column | Type | Keys | | --- | --- | --- | | territory_coverage_id | Long | PK | | additional_data_ | String | | ### participant_subledger_extract_pvo | Column | Type | Keys | | --- | --- | --- | | participant_subledger_id | Long | PK | | additional_data_ | String | | ### channel_extract_pvo | Column | Type | Keys | | --- | --- | --- | | additional_data_ | String | | ### territory_hierarchy_column_flatten_extract_pvo | Column | Type | Keys | | --- | --- | --- | | territory_hierarchy_column_flatten_id | Long | PK | | additional_data_ | String | | ### participant_plan_component_extract_pvo | Column | Type | Keys | | --- | --- | --- | | participant_plan_component_id | Long | PK | | additional_data_ | String | | ### category_hierarchy_flatten_extract_pvo | Column | Type | Keys | | --- | --- | --- | | category_hierarchy_flatten_id | Long | PK | | additional_data_ | String | | ### opty_stg_snapshot_extract_pvo | Column | Type | Keys | | --- | --- | --- | | opty_stg_snapshot_id | Long | PK | | additional_data_ | String | | ### category_extract_pvo | Column | Type | Keys | | --- | --- | --- | | category_id | Long | PK | | additional_data_ | String | | ### opportunity_contact_extract_pvo | Column | Type | Keys | | --- | --- | --- | | opty_con_id | Long | PK | | additional_data_ | String | | | opty_id | Long | | | per_party_id | Long | | | relationship_id | Long | | ### lead_extract_pvo | Column | Type | Keys | | --- | --- | --- | | lead_id | Long | PK | | additional_data_ | String | | ### sales_method_translation_extract_pvo | Column | Type | Keys | | --- | --- | --- | | additional_data_ | String | | | sales_method_translation_id | Long | | ### comp_role_extract_pvo | Column | Type | Keys | | --- | --- | --- | | comp_role_id | Long | PK | | additional_data_ | String | | ### sales_account_extract_pvo | Column | Type | Keys | | --- | --- | --- | | sales_account_id | Long | PK | | account_director_id | Long | | | additional_data_ | String | | | location_id | Long | | | party_id | Long | | | pr_con_party_id | Long | | | sell_to_party_site_id | Long | | ### interaction_ref_extract_pvo | Column | Type | Keys | | --- | --- | --- | | interaction_ref_id | Long | PK | | additional_data_ | String | | ### sales_account_resource_extract_pvo | Column | Type | Keys | | --- | --- | --- | | sales_account_resource_id | Long | PK | | additional_data_ | String | | ### srp_goal_extract_pvo | Column | Type | Keys | | --- | --- | --- | | srp_goal_id | Long | PK | | additional_data_ | String | | ### interval_type_translation_extract_pvo | Column | Type | Keys | | --- | --- | --- | | additional_data_ | String | | | interval_type_translation_id | Long | | ### access_group_member_extract_pvo | Column | Type | Keys | | --- | --- | --- | | access_group_member_id | Long | PK | | additional_data_ | String | | ### service_request_extract_pvo | Column | Type | Keys | | --- | --- | --- | | service_request_id | Long | PK | | additional_data_ | String | | ### category_translation_extract_pvo | Column | Type | Keys | | --- | --- | --- | | additional_data_ | String | | | category_translation_id | Long | | ### interaction_extract_pvo | Column | Type | Keys | | --- | --- | --- | | interaction_id | Long | PK | | additional_data_ | String | | ### participant_pay_extract_pvo | Column | Type | Keys | | --- | --- | --- | | participant_pay_id | Long | PK | | additional_data_ | String | | ### earning_extract_pvo | Column | Type | Keys | | --- | --- | --- | | earning_id | Long | PK | | additional_data_ | String | | ### comp_plan_extract_pvo | Column | Type | Keys | | --- | --- | --- | | comp_plan_id | Long | PK | | additional_data_ | String | | ### pay_group_extract_pvo | Column | Type | Keys | | --- | --- | --- | | pay_group_id | Long | PK | | additional_data_ | String | | ### queue_extract_pvo | Column | Type | Keys | | --- | --- | --- | | queue_id | Long | PK | | additional_data_ | String | | ### interaction_wrapup_extract_pvo | Column | Type | Keys | | --- | --- | --- | | interaction_wrapup_id | Long | PK | | additional_data_ | String | | ### period_dim_extract_pvo | Column | Type | Keys | | --- | --- | --- | | period_dim_id | Long | PK | | additional_data_ | String | | ### srp_period_form_metric_extract_pvo | Column | Type | Keys | | --- | --- | --- | | srp_period_form_metric_id | Long | PK | | additional_data_ | String | | ### opportunity_lead_extract_pvo | Column | Type | Keys | | --- | --- | --- | | opty_lead_id | Long | PK | | additional_data_ | String | | | deal_part_program_id | Long | | | opty_id | Long | | | pr_deal_part_org_party_id | Long | | | pr_deal_part_res_party_id | Long | | ### opportunity_campaign_extract_pvo | Column | Type | Keys | | --- | --- | --- | | opportunity_campaign_id | Long | PK | | additional_data_ | String | | ### account_access_extract_pvo | Column | Type | Keys | | --- | --- | --- | | account_access_id | Long | PK | | additional_data_ | String | | ### campaign_extract_pvo | Column | Type | Keys | | --- | --- | --- | | campaign_id | Long | PK | | additional_data_ | String | | ### payment_plan_translation_extract_pvo | Column | Type | Keys | | --- | --- | --- | | additional_data_ | String | | | payment_plan_translation_id | Long | | ### interaction_agg_extract_pvo | Column | Type | Keys | | --- | --- | --- | | interaction_agg_id | Long | PK | | additional_data_ | String | | ### territory_resource_extract_pvo | Column | Type | Keys | | --- | --- | --- | | territory_resource_id | Long | PK | | additional_data_ | String | | ### object_share_extract_pvo | Column | Type | Keys | | --- | --- | --- | | object_share_id | Long | PK | | additional_data_ | String | |