BIM Tables (103)
BIM - Marketing Intelligence(Obsolete) — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.
| Table | Columns | Description |
|---|---|---|
BIM_CMPGN_PERF_SUMM |
30 | Summarized data by user-defined period and is populated by the BIM_CMPGN_PERF_SUMM_PKG concurrent program. |
BIM_CMPGN_RESP_SUMM |
22 | Summarized data by user-defined period and is populated by BIM_CMPGN_RESP_SUMM_PKG concurrent program. |
BIM_CMPGN_REVCOST_SUMM |
21 | Summarized data by user-defined period and is populated by BIM_CMPGN_RVCST_SUMM_PKG concurrent program. |
BIM_CUSTOMER_REV_SUMM |
28 | Summarized data by user-defined period and is populated by BIM_CUSTOMER_REV_PKG concurrent program. |
BIM_EDW_CMPFRCST_F |
57 | Campaign Forecast fact table . |
BIM_EDW_CMPFRCST_INC |
3 | |
BIM_EDW_EVTFRCST_F |
63 | Event forecast fact table . |
BIM_EDW_EVTFRCST_INC |
3 | |
BIM_EDW_INTRCTNS_F |
54 | Interaction fact table . |
BIM_EDW_INTRCTNS_F_ILOG |
1 | |
BIM_EDW_INTRCTNS_INC |
3 | |
BIM_EDW_LEADS_F |
56 | Lead fact table . |
BIM_EDW_LEADS_INC |
3 | |
BIM_EDW_OPRNTIES_F |
56 | Opportunity fact table . |
BIM_EDW_OPRNTIES_INC |
3 | |
BIM_EDW_RVCT_DLY_F |
113 | Daily derived fact table . |
BIM_EDW_RVCT_MTH_F |
113 | Monthly summarized fact table . |
BIM_EVENT_PERF_SUMM |
25 | Summarized data by user-defined period and is populated by BIM_EVENT_PERF_SUMM_PKG concurrent program. |
BIM_EVENT_RESP_SUMM |
21 | Summarized data by user-defined period and is populated by BIM_EVENT_RESP_SUMM_PKG concurrent program. |
BIM_EVENT_REVCOST_SUMM |
21 | Summarized data by user-defined period and is populated by BIM_EVNT_REVCST_SUMM_PKG concurrent program. |
BIM_GEOGRAPHY |
17 | Dimension values for geographic locations and is populated by BIM_GEO_PKG concurrent program. |
BIM_LEAD_CONV_SUMM |
24 | Summarized data by user-defined period and is populated by BIM_LEAD_CONV_SUMM_PKG concurrent program. |
BIM_OPPR_CYCLE_SUMM |
20 | Summarized data by user-defined period and is populated by BIM_OPPR_CYCLE_SUMM_PKG concurrent program. |
BIM_SALES_CATEGORY_HIER |
14 | Relationship between user-defined sales interest types, primary interest codes and secondary interest codes and is populated by BIM_SALES_CA |
BIM_SALES_CYCLE_SUMM |
21 | Summarized data by user-defined period and is populated by BIM_SALES_CYCLE_SUMM_PKG concurrent program. |
BIM_SLIST_PROFIT_SUMM |
16 | Summarized data by user-defined period and is populated by BIM_SRCLIST_PROFIT_PKG concurrent program. |
BIM_SOURCE_CODE_DETAILS |
20 | All the marketing source codes and is populated by BIM_SRC_CODE_DETAILS_PKG concurrent program. |
BIM_TARGET_SEGMENTS_DENORM |
17 | Target segment hierarchy information in a denormalized fashion and is populated by BIM_TRGT_SGMT_DENORM_PKG concurrent program. |
BIM_TRGT_SGMT_PERF_SUMM |
24 | Summarized data by user-defined period and is populated by BIM_TRGT_SGMT_PERF_PKG concurrent program. |
EDW_BIM_CAMP_CMPGNS_L1_LTC |
29 | Campaign Level 1 Table |
EDW_BIM_CAMP_CMPGNS_L2_LTC |
29 | Campaign Level 2 Table |
EDW_BIM_CAMP_CMPGNS_L3_LTC |
29 | Campaign Level 3 Table |
EDW_BIM_CAMP_CMPGNS_L4_LTC |
29 | Campaign Level 4 Table |
EDW_BIM_CAMP_CMPGNS_L5_LTC |
29 | Campaign Level 5 Table |
EDW_BIM_CAMP_CMPGNS_L6_LTC |
29 | Campaign Level 6 Table |
EDW_BIM_CAMP_CMPGNS_L7_LTC |
29 | Campaign Level 7 Table |
EDW_BIM_CAMP_CMPGNS_L8_LTC |
29 | Campaign Level 8 Table |
EDW_BIM_CAMP_CMPGNS_LTC |
29 | Campaign Level Table |
EDW_BIM_CAMP_SCHEDULES_LTC |
26 | Cammpaign Schedule Level Table |
EDW_BIM_CMPGNS_A_LTC |
6 | Top (All) Level for Campaign Dimension |
EDW_BIM_CMPGNS_DENORM |
19 | Campaign Denormalised table |
EDW_BIM_CMPGNS_M |
245 | Campaign dimension table . |
EDW_BIM_CMPSTATS_A_LTC |
6 | Top Level of the Campaign Status Dimension |
EDW_BIM_CMPSTATS_M |
28 | Campaign Status dimension star table . |
EDW_BIM_CSTA_CMPSTATS_LTC |
25 | Campaign Status Level Table |
EDW_BIM_EVENTS_A_LTC |
6 | Top Level for Event Dimension |
EDW_BIM_EVENTS_M |
130 | Event Dimension table . |
EDW_BIM_EVNT_EVENTS_LTC |
55 | Event level table . |
EDW_BIM_EVNT_EVTOFFERS_LTC |
78 | Event Offering Level Table of Event Dimension . |
EDW_BIM_IHMD_IH_MEDIA_LTC |
19 | Interaction Media Level Table . |
EDW_BIM_IHOT_IH_OUTCOME_LTC |
19 | Interaction Outcome Level Table. |
EDW_BIM_IHRN_IH_REASON_LTC |
18 | Interection Reason Level Table . |
EDW_BIM_IHRS_IH_RESULT_LTC |
19 | Level Table for Interection result . |
EDW_BIM_IH_MEDIA_A_LTC |
6 | All Level table . |
EDW_BIM_IH_MEDIA_M |
22 | Interaction Media Dimension Table . |
EDW_BIM_IH_OUTCM_A_LTC |
6 | All Level table . |
EDW_BIM_IH_OUTCM_M |
22 | Interaction Outcome Dimension . |
EDW_BIM_IH_REASN_A_LTC |
6 | All Level table . |
EDW_BIM_IH_REASN_M |
21 | Interaction Reason Dimension table . |
EDW_BIM_IH_RESLT_A_LTC |
6 | All Level table . |
EDW_BIM_IH_RESLT_M |
22 | Interaction Result Dimension table . |
EDW_BIM_LEADS_A_LTC |
6 | All Level Table . |
EDW_BIM_LEADS_M |
55 | Lead Dimension Table . |
EDW_BIM_LEAD_LEADLINES_LTC |
16 | Lead Line Level Table |
EDW_BIM_LEAD_LEADS_LTC |
41 | Lead Level Table . |
EDW_BIM_LEAD_STATUS_A_LTC |
6 | All Level Table . |
EDW_BIM_LEAD_STATUS_M |
21 | Lead Status Dimension . |
EDW_BIM_LIST_SRCLSTS_LTC |
34 | Source List Level Table . |
EDW_BIM_LSTA_LEADSTATUS_LTC |
18 | Lead Status Level Table . |
EDW_BIM_MDCHN_A_LTC |
6 | All Level Table . |
EDW_BIM_MDCHN_M |
76 | Media Channel Dimension table . |
EDW_BIM_MDCH_CHANNELS_LTC |
28 | Channel Level Table . |
EDW_BIM_MDCH_MDCHN_LTC |
21 | Media Channel Level Table . |
EDW_BIM_MDCH_MDTYPES_LTC |
21 | Media Type Level table . |
EDW_BIM_MDCH_MEDIA_LTC |
20 | Media Level table . |
EDW_BIM_MKSG_MKTSGMTS_LTC |
20 | Market Segment Level Table . |
EDW_BIM_MKTSGMTS_A_LTC |
6 | All Level Table . |
EDW_BIM_MKTSGMTS_M |
23 | Market Segment dimension table . |
EDW_BIM_OFFERS_A_LTC |
6 | All Level Table . |
EDW_BIM_OFFERS_M |
25 | Offer dimension table . |
EDW_BIM_OFFR_OFFERS_LTC |
22 | Offer Level Table . |
EDW_BIM_OPPORTUNITIES_A_LTC |
6 | All Level Table . |
EDW_BIM_OPPORTUNITIES_M |
70 | Opportunity Dimension table . |
EDW_BIM_OPPR_OPPLINES_LTC |
27 | Opportunity Line Level Table . |
EDW_BIM_OPPR_OPRNTIES_LTC |
45 | Opportunity Level Table . |
EDW_BIM_OPP_STATUS_A_LTC |
6 | All Level Table . |
EDW_BIM_OPP_STATUS_M |
24 | Opportunity Status Dimension Table . |
EDW_BIM_OSTA_OPPSTATUS_LTC |
21 | Opportunity Status Level Table . |
EDW_BIM_SOURCE_CODE_DETAILS |
23 | |
EDW_BIM_SRCLSTS_A_LTC |
6 | All Level Table . |
EDW_BIM_SRCLSTS_M |
37 | Source List Dimension Table . |
EDW_BIM_TGSMT_A_LTC |
6 | All Level Table . |
EDW_BIM_TGSMT_DENORM |
19 | Target Segment denormalised table . |
EDW_BIM_TGSMT_M |
161 | Target Segment dimension table . |
EDW_BIM_TGST_TGSMT_L1_LTC |
22 | Target segment level 1 table . |
EDW_BIM_TGST_TGSMT_L2_LTC |
22 | Target segment level 2 table . |
EDW_BIM_TGST_TGSMT_L3_LTC |
22 | Target segment level 3 table . |
EDW_BIM_TGST_TGSMT_L4_LTC |
22 | Target segment level 4 table . |
EDW_BIM_TGST_TGSMT_L5_LTC |
22 | Target segment level 5 table . |
EDW_BIM_TGST_TGSMT_L6_LTC |
22 | Target segment level 6 table . |
EDW_BIM_TGST_TGSMT_L7_LTC |
22 | Target segment level 7 table . |
EDW_BIM_TGST_TGSMT_L8_LTC |
22 | Target segment level 8 table . |
EDW_BIM_TGST_TGSMT_LTC |
22 | Target segment level table . |