Global Multichannel Cycle Plans
Provides a conformed table with multichannel cycle plan infomration sourced from CRM. Mappings are delivered disabled by default.
To enable source to push data to global ODS, set the mapping table value on the enabled: attribute to 'true.' MCCP tables are loaded into Nitro from Align using the CRM Intelligent Sync Connector. The CRM Load Global ODS job pushes MCCP data into the Global ODS.
Only active records are pushed. Users are provided only with current data, not historical. Percentages are calculated by MyInsights, not Nitro.
| Field | Type | Source Table |
|---|---|---|
| composite_key__v | varchar(250) | mc_cycle_vod__v |
| source_system_id__v | varchar(18) | Extracted from Internal Admin Console (Source ID) |
| native_id__v | varchar(250) | mc_cycle_vod__v |
| source_connector_name__v | varchar(100) | Extracted from Internal Admin Console (Connector Name) |
| source_table_name__v | varchar(100) | MCCP |
| mc_cycle_id__v | varchar(18) | mc_cycle_vod__v |
| mc_cycle_name__v | varchar(240) | mc_cycle_vod__v |
| mc_cycle_start_date__v | date | mc_cycle_vod__v |
| mc_cycle_end_date__v | date | mc_cycle_vod__v |
| mc_cycle_status__v | varchar(765) | mc_cycle_vod__v |
| mccp_id__v | varchar(18) | mc_cycle_plan_vod__v |
| mccp_territory_stamp__v | varhar(300) | mc_cycle_plan_vod__v |
| mccp_owner__v | varchar(18) | mc_cycle_plan_vod__v |
| mccp_user_name__v | varhar(363) | user__v |
| mccp_target_id__v | varchar(18) | mc_cycle_plan_target_vod__v |
| mccp_target_channel_attainment__v | numeric(9) | mc_cycle_plan_target_vod__v |
| mccp_target_channel_interactions_actual__v | numeric(11,2) | mc_cycle_plan_target_vod__v |
| mccp_target_channel_interactions_earned__v | numeric(11,2) | mc_cycle_plan_target_vod__v |
| mccp_target_channel_interactions_goal__v | numeric(11,2) | mc_cycle_plan_target_vod__v |
| mccp_target_channel_interactions_max__v | numeric(11,2) | mc_cycle_plan_target_vod__v |
| mccp_target_channel_interactions_remaining__v | numeric(11,2) | mc_cycle_plan_target_vod__v |
| mccp_target_channel_status__v | varchar(765) | mc_cycle_plan_target_vod__v |
| mccp_target_product_attainment__v | numeric(9) | mc_cycle_plan_target_vod__v |
| mccp_target_product_interactions_earned__v | numeric(11,2) | mc_cycle_plan_target_vod__v |
| mccp_target_product_interactions_goal__v | numeric(11,2) | mc_cycle_plan_target_vod__v |
| mccp_target_team_channel_attainment__v | numeric(9) | mc_cycle_plan_target_vod__v |
| mccp_target_team_channel_interactions_actual__v | numeric(11,2) | mc_cycle_plan_target_vod__v |
| mccp_target_team_channel_interactions_earned__v | numeric(11,2) | mc_cycle_plan_target_vod__v |
| mccp_target_team_channel_interactions_goal__v | numeric(11,2) | mc_cycle_plan_target_vod__v |
| mccp_target_team_channel_interactions_max__v | numeric(11,2) | mc_cycle_plan_target_vod__v |
| mccp_target_team_channel_interactions_remaining__v | numeric(11,2) | mc_cycle_plan_target_vod__v |
| mccp_target_team_channel_status__v | varchar(765) | mc_cycle_plan_target_vod__v |
| mccp_target_team_product_attainment__v | numeric(9) | mc_cycle_plan_target_vod__v |
| mccp_target_team_product_interactions_earned__v | numeric(11,2) | mc_cycle_plan_target_vod__v |
| mccp_target_team_product_interactions_goal__v | numeric(11,2) | mc_cycle_plan_target_vod__v |
| mccp_target_team_product_status__v | varchar(765) | mc_cycle_plan_target_vod__v |
| mccp_target_product_status__v | varchar(765) | mc_cycle_plan_target_vod__v |
| mccp_target_status__v | varchar(765) | mc_cycle_plan_target_vod__v |
| mccp_target_account__v | varchar(18) | mc_cycle_plan_target_vod__v |
| mccp_target_account_name__v | varchar(765) | account__v |
| mccp_target_account_record_type__v | varchar(400) | account__v |
| mccp_channel_id__v | varchar(18) | mc_cycle_plan_channel_vod__v |
| mccp_channel_channel_status__v | varchar(765) | mc_cycle_plan_channel_vod__v |
| mccp_channel_channel__v | varchar(3900) | mc_cycle_plan_channel_vod__v |
| mccp_channel_attainment__v | numeric(3) | mc_cycle_plan_channel_vod__v |
| mccp_channel_interactions_actual__v | numeric(11,2) | mc_cycle_plan_channel_vod__v |
| mccp_channel_interactions_earned__v | numeric(11,2) | mc_cycle_plan_channel_vod__v |
| mccp_channel_interactions_goal__v | numeric(11,2) | mc_cycle_plan_channel_vod__v |
| mccp_channel_record_type__V | varchar(400) | mc_cycle_plan_channel_vod__v |
| mc_cycle_product_id__v | varchar(18) | mc_cycle_product_vod__v |
| mc_cycle_product_product_id__v | varchar(18) | mc_cycle_product_vod__v |
| mc_cycle_product_channel_label__v | varchar(3900) | mc_cycle_product_vod__v |
| mc_cycle_product_weight__v | numeric(5,2) | mc_cycle_product_vod__v |
| mc_cycle_product_name__v | varchar(240) | product_vod__v |
| mccp_product_id__v | varchar(18) | mc_cycle_plan_product_vod__v |
| mccp_product_name__v | varchar(3900) | mc_cycle_plan_product_vod__v |
| mccp_product_status__v | varchar(765) | mc_cycle_plan_product_vod__v |
| mc_cycle_channel_id__v | varchar(18) | mc_cycle_channel_vod__v |
| mc_cycle_channel_object__v | varchar(765) | mc_cycle_channel_vod__v |
| mc_cycle_channel_label__v | varchar(300) | mc_cycle_channel_vod__v |
| mc_cycle_channel_weight__v | numeric(5,2) | mc_cycle_channel_vod__v |
| mc_cycle_channel_record_type__v | varchar(400) | mc_cycle_channel_vod__v |
| territory_id__v | varchar(18) | user_territory__v |
| territory_name__v | varchar(320) | territory__v |
