Legend
🔑 = primary key
➤ = foreign key relation
⇱ = external link
CRM_EXTRACT_MKL_BICC_EXTRACT
CRM_EXTRACT_MKT_BICC_EXTRACT
CRM_EXTRACT_MOT_BICC_EXTRACT
CRM_EXTRACT_MOO_BICC_EXTRACT
CRM_EXTRACT_ZCA_BICC_EXTRACT
LEAD_TC_MEMBER_EXTRACT_PVO ⇱
LEAD_RESOURCE_EXTRACT_PVO ⇱
OPPORTUNITY_EXTRACT_PVO ⇱
OPPORTUNITY_COMPETITOR_EXTRACT_PVO ⇱
OPPORTUNITY_LEAD_EXTRACT_PVO ⇱
OPPORTUNITY_CONTACT_EXTRACT_PVO ⇱
OPPORTUNITY_RESOURCE_EXTRACT_PVO ⇱
TERRITORY_HIERARCHY_COLUMN_FLATTEN_EXTRACT_PVO ⇱
TERRITORY_RESOURCE_EXTRACT_PVO ⇱
TERRITORY_EXTRACT_PVO ⇱
TERRITORY_COVERAGE_EXTRACT_PVO ⇱
OPPORTUNITY_TIME_BASED_SNAPSHOT_EXTRACT_PVO ⇱
REVENUE_TIME_BASED_SNAPSHOT_EXTRACT_PVO ⇱
REVENUE_TERRITORY_EXTRACT_PVO ⇱
REVENUE_EXTRACT_PVO ⇱
SALES_METHOD_TRANSLATION_EXTRACT_PVO ⇱
SALES_METHOD_EXTRACT_PVO ⇱
SALES_STAGE_TRANSLATION_EXTRACT_PVO ⇱
SALES_STAGE_EXTRACT_PVO ⇱
SNAPSHOT_EXTRACT_PVO ⇱
LEAD_ITEM_ASSOC_EXTRACT_PVO ⇱
LEAD_TERRITORY_ASSOC_EXTRACT_PVO ⇱
LEAD_EXTRACT_PVO ⇱
ACCOUNT_ACCESS_EXTRACT_PVO ⇱
OBJECT_SHARE_EXTRACT_PVO ⇱
SALES_ACCOUNT_RESOURCE_EXTRACT_PVO ⇱
ACCESS_GROUP_MEMBER_EXTRACT_PVO ⇱
SALES_ACCOUNT_TERRITORY_EXTRACT_PVO ⇱
SALES_ACCOUNT_EXTRACT_PVO ⇱
WEB_ACTIVITY_EXTRACT_PVO ⇱
OPTY_STG_SNAPSHOT_EXTRACT_PVO ⇱
CAMPAIGN_MEMBER_EXTRACT_PVO ⇱
CAMPAIGN_EXTRACT_PVO ⇱
OPPORTUNITY_CAMPAIGN_EXTRACT_PVO ⇱
SERVICE_EXTRACT_SVC_MGMT_BICC_EXTRACT
CATEGORY_EXTRACT_PVO ⇱
CATEGORY_HIERARCHY_FLATTEN_EXTRACT_PVO ⇱
CHANNEL_TRANSLATION_EXTRACT_PVO ⇱
CATEGORY_TRANSLATION_EXTRACT_PVO ⇱
CHANNEL_VIA_EXTRACT_PVO ⇱
INTERACTION_AGG_EXTRACT_PVO ⇱
INTERACTION_REF_EXTRACT_PVO ⇱
INTERACTION_WRAPUP_EXTRACT_PVO ⇱
INTERACTION_EXTRACT_PVO ⇱
QUEUE_EXTRACT_PVO ⇱
SERVICE_REQUEST_EXTRACT_PVO ⇱
CHANNEL_EXTRACT_PVO ⇱
LEAD MANAGEMENT
MARKETING
TERRITORY MANAGEMENT
SERVICE MANAGEMENT
COMMON CRM
OPPORTUNITY MANAGEMENT
NOTE: This is NOT a complete Entity Relationship Diagram.
The schemas in Yellow are representative of schemas containing the table for the Extract Datastores from Oracle BICC.
Fivetran uses shortened names for the Oracle DataStore Public View Objects for simplicity and ease of querying.
Legend
🔑 = primary key
➤ = foreign key relation
⇱ = external link
CN_EXTRACT_COMP_PLAN_SETUP_EXTRACT
CN_EXTRACT_PARTICIPANT_SETUP_EXTRACT
CN_EXTRACT_TRANSACTION_EXTRACT
CN_EXTRACT_PAYMENT_EXTRACT
COMP_PLAN_EXTRACT_PVO
FORMULA_EXTRACT_PVO
PARTICIPANT_PAY_EXTRACT_PVO
PAY_GROUP_EXTRACT_PVO
PAYMENT_PLAN_EXTRACT_PVO
PAY_GROUP_TRANSLATION_EXTRACT_PVO
PAYMENT_PLAN_TRANSLATION_EXTRACT_PVO
EARNING_EXTRACT_PVO
EARNING_HISTORY_EXTRACT_PVO
CREDIT_EXTRACT_PVO
CREDIT_HISTORY_EXTRACT_PVO
PAYSHEET_EXTRACT_PVO
COMP_PLAN_TRANSLATION_EXTRACT_PVO
FORMULA_TRANSLATION_EXTRACT_PVO
PLAN_COMPONENT_FORMULA_EXTRACT_PVO
PAY_RUN_EXTRACT_PVO
COMP_ROLE_EXTRACT_PVO
COMP_ROLE_TRANSLATION_EXTRACT_PVO
PARTICIPANT_COMP_PLAN_EXTRACT_PVO
CN_EXTRACT_SETUP_EXTRACT
INTERVAL_TYPE_EXTRACT_PVO
INTERVAL_TYPE_TRANSLATION_EXTRACT_PVO
PERIOD_DIM_EXTRACT_PVO
PARTICIPANT_DETAIL_EXTRACT_PVO
PARTICIPANT_SUBLEDGER_EXTRACT_PVO
PARTICIPANT_ROLE_EXTRACT_PVO
PARTICIPANT_PLAN_COMPONENT_EXTRACT_PVO
PARTICIPANT_EXTRACT_PVO
SRP_INTERVAL_GOAL_EXTRACT_PVO
SRP_GOAL_EXTRACT_PVO
SRP_FORM_METRIC_EXTRACT_PVO
SRP_PERIOD_FORM_METRIC_EXTRACT_PVO
SRP_PERIOD_GOAL_EXTRACT_PVO
TRANSACTION_HISTORY_EXTRACT_PVO
TRANSACTION_EXTRACT_PVO
MEASURE_RESULT_EXTRACT_PVO
NOTE: This is NOT a complete Entity Relationship Diagram.
The schemas in Yellow are representative of schemas containing the table for the Extract Datastores from Oracle BICC.
Fivetran uses shortened names for the Oracle DataStore Public View Objects for simplicity and ease of querying.