You are browsing the archive for BIM.

Oracle Marketing Intelligence Tables

Oracle Marketing Intelligence module database table information:

  • BIM_CAMPAIGNS_DENORM
  • BIM_CMPGN_PERF_SUMM
  • BIM_CMPGN_RESP_SUMM
  • BIM_CMPGN_REVCOST_SUMM
  • BIM_CUSTOMER_REV_SUMM
  • BIM_EDW_CMPFRCST_F
  • BIM_EDW_CMPFRCST_FSTG
  • BIM_EDW_CMPFRCST_F_DLOG
  • BIM_EDW_CMPFRCST_INC
  • BIM_EDW_EVTFRCST_F
  • BIM_EDW_EVTFRCST_FSTG
  • BIM_EDW_EVTFRCST_F_DLOG
  • BIM_EDW_EVTFRCST_INC
  • BIM_EDW_INTRCTNS_F
  • BIM_EDW_INTRCTNS_FSTG
  • BIM_EDW_INTRCTNS_F_DLOG
  • BIM_EDW_INTRCTNS_F_ILOG
  • BIM_EDW_INTRCTNS_INC
  • BIM_EDW_LEADS_F
  • BIM_EDW_LEADS_FSTG
  • BIM_EDW_LEADS_F_DLOG
  • BIM_EDW_LEADS_INC
  • BIM_EDW_OPRNTIES_F
  • BIM_EDW_OPRNTIES_FSTG
  • BIM_EDW_OPRNTIES_F_DLOG
  • BIM_EDW_OPRNTIES_INC
  • BIM_EDW_RVCT_DLY_F
  • BIM_EDW_RVCT_MTH_F
  • BIM_EVENT_PERF_SUMM
  • BIM_EVENT_RESP_SUMM
  • BIM_EVENT_REVCOST_SUMM
  • BIM_GEOGRAPHY
  • BIM_LEAD_CONV_SUMM
  • BIM_OPPR_CYCLE_SUMM
  • BIM_SALES_CATEGORY_HIER
  • BIM_SALES_CYCLE_SUMM
  • BIM_SLIST_PROFIT_SUMM
  • BIM_SOURCE_CODE_DETAILS
  • BIM_TARGET_SEGMENTS_DENORM
  • BIM_TRGT_SGMT_PERF_SUMM
  • EDW_BIM_CAMP_CMPGNS_L1_LSTG
  • EDW_BIM_CAMP_CMPGNS_L1_LTC
  • EDW_BIM_CAMP_CMPGNS_L2_LSTG
  • EDW_BIM_CAMP_CMPGNS_L2_LTC
  • EDW_BIM_CAMP_CMPGNS_L3_LSTG
  • EDW_BIM_CAMP_CMPGNS_L3_LTC
  • EDW_BIM_CAMP_CMPGNS_L4_LSTG
  • EDW_BIM_CAMP_CMPGNS_L4_LTC
  • EDW_BIM_CAMP_CMPGNS_L5_LSTG
  • EDW_BIM_CAMP_CMPGNS_L5_LTC
  • EDW_BIM_CAMP_CMPGNS_L6_LSTG
  • EDW_BIM_CAMP_CMPGNS_L6_LTC
  • EDW_BIM_CAMP_CMPGNS_L7_LSTG
  • EDW_BIM_CAMP_CMPGNS_L7_LTC
  • EDW_BIM_CAMP_CMPGNS_L8_LSTG
  • EDW_BIM_CAMP_CMPGNS_L8_LTC
  • EDW_BIM_CAMP_CMPGNS_LSTG
  • EDW_BIM_CAMP_CMPGNS_LTC
  • EDW_BIM_CAMP_SCHEDULES_LSTG
  • EDW_BIM_CAMP_SCHEDULES_LTC
  • EDW_BIM_CMPGNS_A_LTC
  • EDW_BIM_CMPGNS_DENORM
  • EDW_BIM_CMPGNS_M
  • EDW_BIM_CMPSTATS_A_LTC
  • EDW_BIM_CMPSTATS_M
  • EDW_BIM_CSTA_CMPSTATS_LSTG
  • EDW_BIM_CSTA_CMPSTATS_LTC
  • EDW_BIM_EVENTS_A_LTC
  • EDW_BIM_EVENTS_M
  • EDW_BIM_EVNT_EVENTS_LSTG
  • EDW_BIM_EVNT_EVENTS_LTC
  • EDW_BIM_EVNT_EVTOFFERS_LSTG
  • EDW_BIM_EVNT_EVTOFFERS_LTC
  • EDW_BIM_IHMD_IH_MEDIA_LSTG
  • EDW_BIM_IHMD_IH_MEDIA_LTC
  • EDW_BIM_IHOT_IH_OUTCOME_LSTG
  • EDW_BIM_IHOT_IH_OUTCOME_LTC
  • EDW_BIM_IHRN_IH_REASON_LSTG
  • EDW_BIM_IHRN_IH_REASON_LTC
  • EDW_BIM_IHRS_IH_RESULT_LSTG
  • EDW_BIM_IHRS_IH_RESULT_LTC
  • EDW_BIM_IH_MEDIA_A_LTC
  • EDW_BIM_IH_MEDIA_M
  • EDW_BIM_IH_OUTCM_A_LTC
  • EDW_BIM_IH_OUTCM_M
  • EDW_BIM_IH_REASN_A_LTC
  • EDW_BIM_IH_REASN_M
  • EDW_BIM_IH_RESLT_A_LTC
  • EDW_BIM_IH_RESLT_M
  • EDW_BIM_LEADS_A_LTC
  • EDW_BIM_LEADS_M
  • EDW_BIM_LEAD_LEADLINES_LSTG
  • EDW_BIM_LEAD_LEADLINES_LTC
  • EDW_BIM_LEAD_LEADS_LSTG
  • EDW_BIM_LEAD_LEADS_LTC
  • EDW_BIM_LEAD_STATUS_A_LTC
  • EDW_BIM_LEAD_STATUS_M
  • EDW_BIM_LIST_SRCLSTS_LSTG
  • EDW_BIM_LIST_SRCLSTS_LTC
  • EDW_BIM_LSTA_LEADSTATUS_LSTG
  • EDW_BIM_LSTA_LEADSTATUS_LTC
  • EDW_BIM_MDCHN_A_LTC
  • EDW_BIM_MDCHN_M
  • EDW_BIM_MDCH_CHANNELS_LSTG
  • EDW_BIM_MDCH_CHANNELS_LTC
  • EDW_BIM_MDCH_MDCHN_LSTG
  • EDW_BIM_MDCH_MDCHN_LTC
  • EDW_BIM_MDCH_MDTYPES_LSTG
  • EDW_BIM_MDCH_MDTYPES_LTC
  • EDW_BIM_MDCH_MEDIA_LSTG
  • EDW_BIM_MDCH_MEDIA_LTC
  • EDW_BIM_MKSG_MKTSGMTS_LSTG
  • EDW_BIM_MKSG_MKTSGMTS_LTC
  • EDW_BIM_MKTSGMTS_A_LTC
  • EDW_BIM_MKTSGMTS_M
  • EDW_BIM_OFFERS_A_LTC
  • EDW_BIM_OFFERS_M
  • EDW_BIM_OFFR_OFFERS_LSTG
  • EDW_BIM_OFFR_OFFERS_LTC
  • EDW_BIM_OPPORTUNITIES_A_LTC
  • EDW_BIM_OPPORTUNITIES_M
  • EDW_BIM_OPPR_OPPLINES_LSTG
  • EDW_BIM_OPPR_OPPLINES_LTC
  • EDW_BIM_OPPR_OPRNTIES_LSTG
  • EDW_BIM_OPPR_OPRNTIES_LTC
  • EDW_BIM_OPP_STATUS_A_LTC
  • EDW_BIM_OPP_STATUS_M
  • EDW_BIM_OSTA_OPPSTATUS_LSTG
  • EDW_BIM_OSTA_OPPSTATUS_LTC
  • EDW_BIM_SOURCE_CODE_DETAILS
  • EDW_BIM_SRCLSTS_A_LTC
  • EDW_BIM_SRCLSTS_M
  • EDW_BIM_TGSMT_A_LTC
  • EDW_BIM_TGSMT_DENORM
  • EDW_BIM_TGSMT_M
  • EDW_BIM_TGST_TGSMT_L1_LSTG
  • EDW_BIM_TGST_TGSMT_L1_LTC
  • EDW_BIM_TGST_TGSMT_L2_LSTG
  • EDW_BIM_TGST_TGSMT_L2_LTC
  • EDW_BIM_TGST_TGSMT_L3_LSTG
  • EDW_BIM_TGST_TGSMT_L3_LTC
  • EDW_BIM_TGST_TGSMT_L4_LSTG
  • EDW_BIM_TGST_TGSMT_L4_LTC
  • EDW_BIM_TGST_TGSMT_L5_LSTG
  • EDW_BIM_TGST_TGSMT_L5_LTC
  • EDW_BIM_TGST_TGSMT_L6_LSTG
  • EDW_BIM_TGST_TGSMT_L6_LTC
  • EDW_BIM_TGST_TGSMT_L7_LSTG
  • EDW_BIM_TGST_TGSMT_L7_LTC
  • EDW_BIM_TGST_TGSMT_L8_LSTG
  • EDW_BIM_TGST_TGSMT_L8_LTC
  • EDW_BIM_TGST_TGSMT_LSTG
  • EDW_BIM_TGST_TGSMT_LTC

Marketing Intelligence Profile Options

Oracle Marketing Intelligence Profile Options:

PROFILE OPTION SHORT CODE PROFILE OPTION NAME
BIM_MKT_CHANNEL BIM: Marketing Channel
BIM_VIEW_PROGRAM BIM : View Program
BIM_PROG_COST BIM:Program Cost
BIM_COST_PER_LEAD BIM : Cost Per Lead
BIM_IO_QUARTER BIM : Quarter Period Type
BIM_CSCH_OA_JTF BIM:Schedule Type
BIM_IO_MONTH BIM : Month Period Type
BIM_IO_YEAR BIM : Year Period Type
BIM_REVENUE BIM : Revenue Type

Views in Marketing Intelligence Module

Views in Oracle Marketing Intelligence Module

BIM_BUDGET_CATEGORY_V
BIM_BUDGET_NAME_V
BIM_DIMV_CAMPAIGNS
BIM_DIMV_CHANNELS
BIM_DIMV_EVENT_HEADERS
BIM_DIMV_EVENT_HIER
BIM_DIMV_EVENT_OFFERS
BIM_DIMV_EVENT_TYPES
BIM_DIMV_GEOGRAPHY
BIM_DIMV_INTEREST_CODES
BIM_DIMV_INTEREST_TYPES
BIM_DIMV_MARKET_SGMTS
BIM_DIMV_MEDIA
BIM_DIMV_MEDIA_CHANNELS
BIM_DIMV_OFFERS
BIM_DIMV_PROD_HIER
BIM_DIMV_PROD_LOV
BIM_DIMV_SALES_CHANNELS
BIM_DIMV_SOURCE_CODES_V
BIM_DIMV_SOURCE_LISTS
BIM_DIMV_TARGET_SGMTS
BIM_DIMV_TOT_EVENT_OFRS
BIM_DIMV_TOT_TGT_SGMTS
BIM_DIMV_TOTAL_CAMPAIGNS
BIM_DIMV_TOTAL_CHANNELS
BIM_DIMV_TOTAL_EVENTS
BIM_DIMV_TOTAL_MEDIA
BIM_DIMV_TOTAL_OFFERS
BIM_DIMV_USER_STATUSES
BIM_FCTV_LEADLINES
BIM_FCTV_LEADS
BIM_FCTV_OPPLINES
BIM_FCTV_OPPORTUNITIES
BIM_FCTV_OPPR_CYCLE
BIM_FCTV_ORDER_OFFERS
BIM_FCTV_RESPONSES
BIM_FCTV_SALES_CYCLE
BIM_FCTV_TARGETS
BIM_SUMV_CAMP_COST
BIM_SUMV_CAMP_MARGIN
BIM_SUMV_CAMP_PERF
BIM_SUMV_CAMP_RESP
BIM_SUMV_EVENT_PERF
BIM_SUMV_EVENT_REV
BIM_SUMV_EVENT_RSLTS
BIM_SUMV_LEAD_CONV
BIM_SUMV_SALES_CYCLE
BIM_SUMV_SLIST_PERF
BIM_SUMV_SLIST_PROFIT