Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - BIM Tables and Views

TABLE - BIM.BIM_CMPGN_PERF_SUMM
TABLE - BIM.BIM_CMPGN_RESP_SUMM
TABLE - BIM.BIM_CMPGN_REVCOST_SUMM
TABLE - BIM.BIM_CUSTOMER_REV_SUMM
TABLE - BIM.BIM_EDW_CMPFRCST_F
TABLE - BIM.BIM_EDW_CMPFRCST_INC
TABLE - BIM.BIM_EDW_EVTFRCST_F
TABLE - BIM.BIM_EDW_EVTFRCST_INC
TABLE - BIM.BIM_EDW_INTRCTNS_F
TABLE - BIM.BIM_EDW_INTRCTNS_F_ILOG
TABLE - BIM.BIM_EDW_INTRCTNS_INC
TABLE - BIM.BIM_EDW_LEADS_F
TABLE - BIM.BIM_EDW_LEADS_INC
TABLE - BIM.BIM_EDW_OPRNTIES_F
TABLE - BIM.BIM_EDW_OPRNTIES_INC
TABLE - BIM.BIM_EDW_RVCT_DLY_F
TABLE - BIM.BIM_EDW_RVCT_MTH_F
TABLE - BIM.BIM_EVENT_PERF_SUMM
TABLE - BIM.BIM_EVENT_RESP_SUMM
TABLE - BIM.BIM_EVENT_REVCOST_SUMM
TABLE - BIM.BIM_GEOGRAPHY
TABLE - BIM.BIM_LEAD_CONV_SUMM
TABLE - BIM.BIM_OPPR_CYCLE_SUMM
TABLE - BIM.BIM_SALES_CATEGORY_HIER
TABLE - BIM.BIM_SALES_CYCLE_SUMM
TABLE - BIM.BIM_SLIST_PROFIT_SUMM
TABLE - BIM.BIM_SOURCE_CODE_DETAILS
TABLE - BIM.BIM_TARGET_SEGMENTS_DENORM
TABLE - BIM.BIM_TRGT_SGMT_PERF_SUMM
TABLE - BIM.EDW_BIM_CAMP_CMPGNS_L1_LTC
TABLE - BIM.EDW_BIM_CAMP_CMPGNS_L2_LTC
TABLE - BIM.EDW_BIM_CAMP_CMPGNS_L3_LTC
TABLE - BIM.EDW_BIM_CAMP_CMPGNS_L4_LTC
TABLE - BIM.EDW_BIM_CAMP_CMPGNS_L5_LTC
TABLE - BIM.EDW_BIM_CAMP_CMPGNS_L6_LTC
TABLE - BIM.EDW_BIM_CAMP_CMPGNS_L7_LTC
TABLE - BIM.EDW_BIM_CAMP_CMPGNS_L8_LTC
TABLE - BIM.EDW_BIM_CAMP_CMPGNS_LTC
TABLE - BIM.EDW_BIM_CAMP_SCHEDULES_LTC
TABLE - BIM.EDW_BIM_CMPGNS_A_LTC
TABLE - BIM.EDW_BIM_CMPGNS_DENORM
TABLE - BIM.EDW_BIM_CMPGNS_M
TABLE - BIM.EDW_BIM_CMPSTATS_A_LTC
TABLE - BIM.EDW_BIM_CMPSTATS_M
TABLE - BIM.EDW_BIM_CSTA_CMPSTATS_LTC
TABLE - BIM.EDW_BIM_EVENTS_A_LTC
TABLE - BIM.EDW_BIM_EVENTS_M
TABLE - BIM.EDW_BIM_EVNT_EVENTS_LTC
TABLE - BIM.EDW_BIM_EVNT_EVTOFFERS_LTC
TABLE - BIM.EDW_BIM_IHMD_IH_MEDIA_LTC
TABLE - BIM.EDW_BIM_IHOT_IH_OUTCOME_LTC
TABLE - BIM.EDW_BIM_IHRN_IH_REASON_LTC
TABLE - BIM.EDW_BIM_IHRS_IH_RESULT_LTC
TABLE - BIM.EDW_BIM_IH_MEDIA_A_LTC
TABLE - BIM.EDW_BIM_IH_MEDIA_M
TABLE - BIM.EDW_BIM_IH_OUTCM_A_LTC
TABLE - BIM.EDW_BIM_IH_OUTCM_M
TABLE - BIM.EDW_BIM_IH_REASN_A_LTC
TABLE - BIM.EDW_BIM_IH_REASN_M
TABLE - BIM.EDW_BIM_IH_RESLT_A_LTC
TABLE - BIM.EDW_BIM_IH_RESLT_M
TABLE - BIM.EDW_BIM_LEADS_A_LTC
TABLE - BIM.EDW_BIM_LEADS_M
TABLE - BIM.EDW_BIM_LEAD_LEADLINES_LTC
TABLE - BIM.EDW_BIM_LEAD_LEADS_LTC
TABLE - BIM.EDW_BIM_LEAD_STATUS_A_LTC
TABLE - BIM.EDW_BIM_LEAD_STATUS_M
TABLE - BIM.EDW_BIM_LIST_SRCLSTS_LTC
TABLE - BIM.EDW_BIM_LSTA_LEADSTATUS_LTC
TABLE - BIM.EDW_BIM_MDCHN_A_LTC
TABLE - BIM.EDW_BIM_MDCHN_M
TABLE - BIM.EDW_BIM_MDCH_CHANNELS_LTC
TABLE - BIM.EDW_BIM_MDCH_MDCHN_LTC
TABLE - BIM.EDW_BIM_MDCH_MDTYPES_LTC
TABLE - BIM.EDW_BIM_MDCH_MEDIA_LTC
TABLE - BIM.EDW_BIM_MKSG_MKTSGMTS_LTC
TABLE - BIM.EDW_BIM_MKTSGMTS_A_LTC
TABLE - BIM.EDW_BIM_MKTSGMTS_M
TABLE - BIM.EDW_BIM_OFFERS_A_LTC
TABLE - BIM.EDW_BIM_OFFERS_M
TABLE - BIM.EDW_BIM_OFFR_OFFERS_LTC
TABLE - BIM.EDW_BIM_OPPORTUNITIES_A_LTC
TABLE - BIM.EDW_BIM_OPPORTUNITIES_M
TABLE - BIM.EDW_BIM_OPPR_OPPLINES_LTC
TABLE - BIM.EDW_BIM_OPPR_OPRNTIES_LTC
TABLE - BIM.EDW_BIM_OPP_STATUS_A_LTC
TABLE - BIM.EDW_BIM_OPP_STATUS_M
TABLE - BIM.EDW_BIM_OSTA_OPPSTATUS_LTC
TABLE - BIM.EDW_BIM_SOURCE_CODE_DETAILS
TABLE - BIM.EDW_BIM_SRCLSTS_A_LTC
TABLE - BIM.EDW_BIM_SRCLSTS_M
TABLE - BIM.EDW_BIM_TGSMT_A_LTC
TABLE - BIM.EDW_BIM_TGSMT_DENORM
TABLE - BIM.EDW_BIM_TGSMT_M
TABLE - BIM.EDW_BIM_TGST_TGSMT_L1_LTC
TABLE - BIM.EDW_BIM_TGST_TGSMT_L2_LTC
TABLE - BIM.EDW_BIM_TGST_TGSMT_L3_LTC
TABLE - BIM.EDW_BIM_TGST_TGSMT_L4_LTC
TABLE - BIM.EDW_BIM_TGST_TGSMT_L5_LTC
TABLE - BIM.EDW_BIM_TGST_TGSMT_L6_LTC
TABLE - BIM.EDW_BIM_TGST_TGSMT_L7_LTC
TABLE - BIM.EDW_BIM_TGST_TGSMT_L8_LTC
TABLE - BIM.EDW_BIM_TGST_TGSMT_LTC
VIEW - APPS.BIM_DIMV_CHANNELS
VIEW - APPS.BIM_DIMV_EVENT_HEADERS
VIEW - APPS.BIM_DIMV_EVENT_HIER
VIEW - APPS.BIM_DIMV_EVENT_OFFERS
VIEW - APPS.BIM_DIMV_EVENT_TYPES
VIEW - APPS.BIM_DIMV_GEOGRAPHY
VIEW - APPS.BIM_DIMV_INTEREST_CODES
VIEW - APPS.BIM_DIMV_INTEREST_TYPES
VIEW - APPS.BIM_DIMV_MARKET_SGMTS
VIEW - APPS.BIM_DIMV_MEDIA
VIEW - APPS.BIM_DIMV_MEDIA_CHANNELS
VIEW - APPS.BIM_DIMV_OFFERS
VIEW - APPS.BIM_DIMV_PROD_HIER
VIEW - APPS.BIM_DIMV_PROD_LOV
VIEW - APPS.BIM_DIMV_SALES_CHANNELS
VIEW - APPS.BIM_DIMV_SOURCE_CODES_V
VIEW - APPS.BIM_DIMV_SOURCE_LISTS
VIEW - APPS.BIM_DIMV_TARGET_SGMTS
VIEW - APPS.BIM_DIMV_USER_STATUSES
VIEW - APPS.BIM_FCTV_LEADLINES
VIEW - APPS.BIM_FCTV_LEADS
VIEW - APPS.BIM_FCTV_OPPLINES
VIEW - APPS.BIM_FCTV_OPPORTUNITIES
VIEW - APPS.BIM_FCTV_OPPR_CYCLE
VIEW - APPS.BIM_FCTV_ORDER_OFFERS
VIEW - APPS.BIM_FCTV_RESPONSES
VIEW - APPS.BIM_FCTV_SALES_CYCLE
VIEW - APPS.BIM_FCTV_TARGETS
VIEW - APPS.BIM_SUMV_CAMP_COST
VIEW - APPS.BIM_SUMV_CAMP_MARGIN
VIEW - APPS.BIM_SUMV_CAMP_PERF
VIEW - APPS.BIM_SUMV_CAMP_RESP
VIEW - APPS.BIM_SUMV_EVENT_PERF
VIEW - APPS.BIM_SUMV_EVENT_REV
VIEW - APPS.BIM_SUMV_EVENT_RSLTS
VIEW - APPS.BIM_SUMV_LEAD_CONV
VIEW - APPS.BIM_SUMV_SALES_CYCLE
VIEW - APPS.BIM_SUMV_SLIST_PERF
VIEW - APPS.BIM_SUMV_SLIST_PROFIT

Table: BIM_CMPGN_PERF_SUMM

Description: Summarized data by user-defined period and is populated by the BIM_CMPGN_PERF_SUMM_PKG concurrent program.

[top of page]

BIM.BIM_CMPGN_PERF_SUMM does not reference any database object

BIM.BIM_CMPGN_PERF_SUMM is referenced by following:

BIM
VIEW - BIM_CMPGN_PERF_SUMM#

[top of page]

Table: BIM_CMPGN_RESP_SUMM

Description: Summarized data by user-defined period and is populated by BIM_CMPGN_RESP_SUMM_PKG concurrent program.

[top of page]

BIM.BIM_CMPGN_RESP_SUMM does not reference any database object

BIM.BIM_CMPGN_RESP_SUMM is referenced by following:

BIM
VIEW - BIM_CMPGN_RESP_SUMM#

[top of page]

Table: BIM_CMPGN_REVCOST_SUMM

Description: Summarized data by user-defined period and is populated by BIM_CMPGN_RVCST_SUMM_PKG concurrent program.

[top of page]

BIM.BIM_CMPGN_REVCOST_SUMM does not reference any database object

BIM.BIM_CMPGN_REVCOST_SUMM is referenced by following:

BIM
VIEW - BIM_CMPGN_REVCOST_SUMM#

[top of page]

Table: BIM_CUSTOMER_REV_SUMM

Description: Summarized data by user-defined period and is populated by BIM_CUSTOMER_REV_PKG concurrent program.

[top of page]

BIM.BIM_CUSTOMER_REV_SUMM does not reference any database object

BIM.BIM_CUSTOMER_REV_SUMM is referenced by following:

BIM
VIEW - BIM_CUSTOMER_REV_SUMM#

[top of page]

Table: BIM_EDW_CMPFRCST_F

Description: Campaign Forecast fact table .
Foreign Keys from this table:
Foreign Key Column Foreign Table
BIM_EDW_CMPFRCST_F.CMPGN_FK_KEY EDW_BIM_CMPGNS_M
BIM_EDW_CMPFRCST_F.CMPGN_STATUS_FK_KEY EDW_BIM_CMPSTATS_M
BIM_EDW_CMPFRCST_F.EVENT_FK_KEY EDW_BIM_EVENTS_M
BIM_EDW_CMPFRCST_F.MEDCHNL_FK_KEY EDW_BIM_MDCHN_M
BIM_EDW_CMPFRCST_F.MKTSGMT_FK_KEY EDW_BIM_MKTSGMTS_M
BIM_EDW_CMPFRCST_F.SRCLST_FK_KEY EDW_BIM_SRCLSTS_M
BIM_EDW_CMPFRCST_F.TGTSGMT_FK_KEY EDW_BIM_TGSMT_M
BIM_EDW_CMPFRCST_F.BILL_TO_SITE_FK_KEY %
BIM_EDW_CMPFRCST_F.SHIP_TO_SITE_FK_KEY %
BIM_EDW_CMPFRCST_F.INSTANCE_FK_KEY %
BIM_EDW_CMPFRCST_F.ITEM_FK_KEY %
BIM_EDW_CMPFRCST_F.UOM_FK_KEY %
BIM_EDW_CMPFRCST_F.ORG_FK_KEY %
BIM_EDW_CMPFRCST_F.CUSTOMER_FK_KEY %

[top of page]

BIM.BIM_EDW_CMPFRCST_F does not reference any database object

BIM.BIM_EDW_CMPFRCST_F is referenced by following:

BIM
VIEW - BIM_EDW_CMPFRCST_F#

[top of page]

Table: BIM_EDW_CMPFRCST_INC

Description:

[top of page]

BIM.BIM_EDW_CMPFRCST_INC does not reference any database object

BIM.BIM_EDW_CMPFRCST_INC is referenced by following:

BIM
VIEW - BIM_EDW_CMPFRCST_INC#

[top of page]

Table: BIM_EDW_EVTFRCST_F

Description: Event forecast fact table .
Foreign Keys from this table:
Foreign Key Column Foreign Table
BIM_EDW_EVTFRCST_F.CMPGN_FK_KEY EDW_BIM_CMPGNS_M
BIM_EDW_EVTFRCST_F.CMPGN_STATUS_FK_KEY EDW_BIM_CMPSTATS_M
BIM_EDW_EVTFRCST_F.EVENT_FK_KEY EDW_BIM_EVENTS_M
BIM_EDW_EVTFRCST_F.MDCHNL_FK_KEY EDW_BIM_MDCHN_M
BIM_EDW_EVTFRCST_F.MKTSGMT_FK_KEY EDW_BIM_MKTSGMTS_M
BIM_EDW_EVTFRCST_F.OFFER_FK_KEY EDW_BIM_OFFERS_M
BIM_EDW_EVTFRCST_F.SRCLST_FK_KEY EDW_BIM_SRCLSTS_M
BIM_EDW_EVTFRCST_F.TGTSGMT_FK_KEY EDW_BIM_TGSMT_M
BIM_EDW_EVTFRCST_F.BILL_TO_SITE_FK_KEY %
BIM_EDW_EVTFRCST_F.SHIP_TO_SITE_FK_KEY %
BIM_EDW_EVTFRCST_F.INSTANCE_FK_KEY %
BIM_EDW_EVTFRCST_F.ITEM_FK_KEY %
BIM_EDW_EVTFRCST_F.UOM_FK_KEY %
BIM_EDW_EVTFRCST_F.SLSCHNL_FK_KEY %
BIM_EDW_EVTFRCST_F.ORG_FK_KEY %
BIM_EDW_EVTFRCST_F.CUSTOMER_FK_KEY %

[top of page]

BIM.BIM_EDW_EVTFRCST_F does not reference any database object

BIM.BIM_EDW_EVTFRCST_F is referenced by following:

BIM
VIEW - BIM_EDW_EVTFRCST_F#

[top of page]

Table: BIM_EDW_EVTFRCST_INC

Description:

[top of page]

BIM.BIM_EDW_EVTFRCST_INC does not reference any database object

BIM.BIM_EDW_EVTFRCST_INC is referenced by following:

BIM
VIEW - BIM_EDW_EVTFRCST_INC#

[top of page]

Table: BIM_EDW_INTRCTNS_F

Description: Interaction fact table .
Foreign Keys from this table:
Foreign Key Column Foreign Table
BIM_EDW_INTRCTNS_F.CMPGN_FK_KEY EDW_BIM_CMPGNS_M
BIM_EDW_INTRCTNS_F.CMPGN_STATUS_FK_KEY EDW_BIM_CMPSTATS_M
BIM_EDW_INTRCTNS_F.EVENT_FK_KEY EDW_BIM_EVENTS_M
BIM_EDW_INTRCTNS_F.INTRCTN_MEDIA_FK_KEY EDW_BIM_IH_MEDIA_M
BIM_EDW_INTRCTNS_F.INTRCTN_OUTCOME_FK_KEY EDW_BIM_IH_OUTCM_M
BIM_EDW_INTRCTNS_F.INTRCTN_REASON_FK_KEY EDW_BIM_IH_REASN_M
BIM_EDW_INTRCTNS_F.INTRCTN_RESULT_FK_KEY EDW_BIM_IH_RESLT_M
BIM_EDW_INTRCTNS_F.MDCHNL_FK_KEY EDW_BIM_MDCHN_M
BIM_EDW_INTRCTNS_F.MKTSGMT_FK_KEY EDW_BIM_MKTSGMTS_M
BIM_EDW_INTRCTNS_F.OFFER_FK_KEY EDW_BIM_OFFERS_M
BIM_EDW_INTRCTNS_F.SRCLST_FK_KEY EDW_BIM_SRCLSTS_M
BIM_EDW_INTRCTNS_F.TGTSGMT_FK_KEY EDW_BIM_TGSMT_M
BIM_EDW_INTRCTNS_F.BILL_TO_SITE_FK_KEY %
BIM_EDW_INTRCTNS_F.SHIP_TO_SITE_FK_KEY %
BIM_EDW_INTRCTNS_F.INSTANCE_FK_KEY %
BIM_EDW_INTRCTNS_F.ORG_FK_KEY %
BIM_EDW_INTRCTNS_F.CUSTOMER_FK_KEY %

[top of page]

BIM.BIM_EDW_INTRCTNS_F does not reference any database object

BIM.BIM_EDW_INTRCTNS_F is referenced by following:

BIM
VIEW - BIM_EDW_INTRCTNS_F#

[top of page]

Table: BIM_EDW_INTRCTNS_F_ILOG

Description:

[top of page]

BIM.BIM_EDW_INTRCTNS_F_ILOG does not reference any database object

BIM.BIM_EDW_INTRCTNS_F_ILOG is referenced by following:

BIM
VIEW - BIM_EDW_INTRCTNS_F_ILOG#

[top of page]

Table: BIM_EDW_INTRCTNS_INC

Description:

[top of page]

BIM.BIM_EDW_INTRCTNS_INC does not reference any database object

BIM.BIM_EDW_INTRCTNS_INC is referenced by following:

BIM
VIEW - BIM_EDW_INTRCTNS_INC#

[top of page]

Table: BIM_EDW_LEADS_F

Description: Lead fact table .
Foreign Keys from this table:
Foreign Key Column Foreign Table
BIM_EDW_LEADS_F.CMPGN_FK_KEY EDW_BIM_CMPGNS_M
BIM_EDW_LEADS_F.CMPGN_STATUS_FK_KEY EDW_BIM_CMPSTATS_M
BIM_EDW_LEADS_F.EVENT_FK_KEY EDW_BIM_EVENTS_M
BIM_EDW_LEADS_F.LEADLINE_FK_KEY EDW_BIM_LEADS_M
BIM_EDW_LEADS_F.LEADSTATUS_FK_KEY EDW_BIM_LEAD_STATUS_M
BIM_EDW_LEADS_F.MDCHNL_FK_KEY EDW_BIM_MDCHN_M
BIM_EDW_LEADS_F.MKTSGMT_FK_KEY EDW_BIM_MKTSGMTS_M
BIM_EDW_LEADS_F.OFFER_FK_KEY EDW_BIM_OFFERS_M
BIM_EDW_LEADS_F.SRCLST_FK_KEY EDW_BIM_SRCLSTS_M
BIM_EDW_LEADS_F.TGTSGMT_FK_KEY EDW_BIM_TGSMT_M
BIM_EDW_LEADS_F.BILL_TO_SITE_FK_KEY %
BIM_EDW_LEADS_F.SHIP_TO_SITE_FK_KEY %
BIM_EDW_LEADS_F.INSTANCE_FK_KEY %
BIM_EDW_LEADS_F.ITEM_FK_KEY %
BIM_EDW_LEADS_F.UOM_FK_KEY %
BIM_EDW_LEADS_F.SLSCHNL_FK_KEY %
BIM_EDW_LEADS_F.ORG_FK_KEY %
BIM_EDW_LEADS_F.CUSTOMER_FK_KEY %

[top of page]

BIM.BIM_EDW_LEADS_F does not reference any database object

BIM.BIM_EDW_LEADS_F is referenced by following:

BIM
VIEW - BIM_EDW_LEADS_F#

[top of page]

Table: BIM_EDW_LEADS_INC

Description:

[top of page]

BIM.BIM_EDW_LEADS_INC does not reference any database object

BIM.BIM_EDW_LEADS_INC is referenced by following:

BIM
VIEW - BIM_EDW_LEADS_INC#

[top of page]

Table: BIM_EDW_OPRNTIES_F

Description: Opportunity fact table .
Foreign Keys from this table:
Foreign Key Column Foreign Table
BIM_EDW_OPRNTIES_F.CMPGN_FK_KEY EDW_BIM_CMPGNS_M
BIM_EDW_OPRNTIES_F.CMPGN_STATUS_FK_KEY EDW_BIM_CMPSTATS_M
BIM_EDW_OPRNTIES_F.EVENT_FK_KEY EDW_BIM_EVENTS_M
BIM_EDW_OPRNTIES_F.MDCHNL_FK_KEY EDW_BIM_MDCHN_M
BIM_EDW_OPRNTIES_F.MKTSGMT_FK_KEY EDW_BIM_MKTSGMTS_M
BIM_EDW_OPRNTIES_F.OPPLINE_FK_KEY EDW_BIM_OFFERS_M
BIM_EDW_OPRNTIES_F.OPPLINE_FK_KEY EDW_BIM_OPPORTUNITIES_M
BIM_EDW_OPRNTIES_F.OPPSTATUS_FK_KEY EDW_BIM_OPP_STATUS_M
BIM_EDW_OPRNTIES_F.SRCLST_FK_KEY EDW_BIM_SRCLSTS_M
BIM_EDW_OPRNTIES_F.TGTSGMT_FK_KEY EDW_BIM_TGSMT_M
BIM_EDW_OPRNTIES_F.BILL_TO_SITE_FK_KEY %
BIM_EDW_OPRNTIES_F.SHIP_TO_SITE_FK_KEY %
BIM_EDW_OPRNTIES_F.INSTANCE_FK_KEY %
BIM_EDW_OPRNTIES_F.ITEM_FK_KEY %
BIM_EDW_OPRNTIES_F.UOM_FK_KEY %
BIM_EDW_OPRNTIES_F.SLSCHNL_FK_KEY %
BIM_EDW_OPRNTIES_F.ORG_FK_KEY %
BIM_EDW_OPRNTIES_F.CUSTOMER_FK_KEY %

[top of page]

BIM.BIM_EDW_OPRNTIES_F does not reference any database object

BIM.BIM_EDW_OPRNTIES_F is referenced by following:

BIM
VIEW - BIM_EDW_OPRNTIES_F#

[top of page]

Table: BIM_EDW_OPRNTIES_INC

Description:

[top of page]

BIM.BIM_EDW_OPRNTIES_INC does not reference any database object

BIM.BIM_EDW_OPRNTIES_INC is referenced by following:

BIM
VIEW - BIM_EDW_OPRNTIES_INC#

[top of page]

Table: BIM_EDW_RVCT_DLY_F

Description: Daily derived fact table .
Foreign Keys from this table:
Foreign Key Column Foreign Table
BIM_EDW_RVCT_DLY_F.CMPGN_FK_KEY EDW_BIM_CMPGNS_M
BIM_EDW_RVCT_DLY_F.CMPGN_STATUS_FK_KEY EDW_BIM_CMPSTATS_M
BIM_EDW_RVCT_DLY_F.EVENT_FK_KEY EDW_BIM_EVENTS_M
BIM_EDW_RVCT_DLY_F.LEAD_FK_KEY EDW_BIM_LEADS_M
BIM_EDW_RVCT_DLY_F.LEADSTATUS_FK_KEY EDW_BIM_LEAD_STATUS_M
BIM_EDW_RVCT_DLY_F.MEDCHNL_FK_KEY EDW_BIM_MDCHN_M
BIM_EDW_RVCT_DLY_F.MKTSGMT_FK_KEY EDW_BIM_MKTSGMTS_M
BIM_EDW_RVCT_DLY_F.HEADER_OFFER_FK_KEY EDW_BIM_OFFERS_M
BIM_EDW_RVCT_DLY_F.LINE_OFFER_FK_KEY EDW_BIM_OFFERS_M
BIM_EDW_RVCT_DLY_F.OPPORTUNITY_FK_KEY EDW_BIM_OPPORTUNITIES_M
BIM_EDW_RVCT_DLY_F.OPPSTATUS_FK_KEY EDW_BIM_OPP_STATUS_M
BIM_EDW_RVCT_DLY_F.SRCLST_FK_KEY EDW_BIM_SRCLSTS_M
BIM_EDW_RVCT_DLY_F.TGTSGMT_FK_KEY EDW_BIM_TGSMT_M
BIM_EDW_RVCT_DLY_F.BILL_TO_SITE_FK_KEY %
BIM_EDW_RVCT_DLY_F.SHIP_TO_SITE_FK_KEY %
BIM_EDW_RVCT_DLY_F.ITEM_FK_KEY %
BIM_EDW_RVCT_DLY_F.UOM_FK_KEY %
BIM_EDW_RVCT_DLY_F.SLSCHNL_FK_KEY %
BIM_EDW_RVCT_DLY_F.ORG_FK_KEY %
BIM_EDW_RVCT_DLY_F.CUSTOMER_FK_KEY %

[top of page]

BIM.BIM_EDW_RVCT_DLY_F does not reference any database object

BIM.BIM_EDW_RVCT_DLY_F is referenced by following:

BIM
VIEW - BIM_EDW_RVCT_DLY_F#

[top of page]

Table: BIM_EDW_RVCT_MTH_F

Description: Monthly summarized fact table .
Foreign Keys from this table:
Foreign Key Column Foreign Table
BIM_EDW_RVCT_MTH_F.LEADSTATUS_FK_KEY EDW_BIM_LEAD_STATUS_M
BIM_EDW_RVCT_MTH_F.LINE_OFFER_FK_KEY EDW_BIM_OFFERS_M
BIM_EDW_RVCT_MTH_F.CMPGN_FK_KEY EDW_BIM_CMPGNS_M
BIM_EDW_RVCT_MTH_F.CMPGN_STATUS_FK_KEY EDW_BIM_CMPSTATS_M
BIM_EDW_RVCT_MTH_F.EVENT_FK_KEY EDW_BIM_EVENTS_M
BIM_EDW_RVCT_MTH_F.LEAD_FK_KEY EDW_BIM_LEADS_M
BIM_EDW_RVCT_MTH_F.MEDCHNL_FK_KEY EDW_BIM_MDCHN_M
BIM_EDW_RVCT_MTH_F.MKTSGMT_FK_KEY EDW_BIM_MKTSGMTS_M
BIM_EDW_RVCT_MTH_F.HEADER_OFFER_FK_KEY EDW_BIM_OFFERS_M
BIM_EDW_RVCT_MTH_F.OPPORTUNITY_FK_KEY EDW_BIM_OPPORTUNITIES_M
BIM_EDW_RVCT_MTH_F.OPPSTATUS_FK_KEY EDW_BIM_OPP_STATUS_M
BIM_EDW_RVCT_MTH_F.SRCLST_FK_KEY EDW_BIM_SRCLSTS_M
BIM_EDW_RVCT_MTH_F.TGTSGMT_FK_KEY EDW_BIM_TGSMT_M
BIM_EDW_RVCT_MTH_F.BILL_TO_SITE_FK_KEY %
BIM_EDW_RVCT_MTH_F.SHIP_TO_SITE_FK_KEY %
BIM_EDW_RVCT_MTH_F.ITEM_FK_KEY %
BIM_EDW_RVCT_MTH_F.UOM_FK_KEY %
BIM_EDW_RVCT_MTH_F.SLSCHNL_FK_KEY %
BIM_EDW_RVCT_MTH_F.ORG_FK_KEY %
BIM_EDW_RVCT_MTH_F.CUSTOMER_FK_KEY %

[top of page]

BIM.BIM_EDW_RVCT_MTH_F does not reference any database object

BIM.BIM_EDW_RVCT_MTH_F is referenced by following:

BIM
VIEW - BIM_EDW_RVCT_MTH_F#

[top of page]

Table: BIM_EVENT_PERF_SUMM

Description: Summarized data by user-defined period and is populated by BIM_EVENT_PERF_SUMM_PKG concurrent program.

[top of page]

BIM.BIM_EVENT_PERF_SUMM does not reference any database object

BIM.BIM_EVENT_PERF_SUMM is referenced by following:

BIM
VIEW - BIM_EVENT_PERF_SUMM#

[top of page]

Table: BIM_EVENT_RESP_SUMM

Description: Summarized data by user-defined period and is populated by BIM_EVENT_RESP_SUMM_PKG concurrent program.

[top of page]

BIM.BIM_EVENT_RESP_SUMM does not reference any database object

BIM.BIM_EVENT_RESP_SUMM is referenced by following:

BIM
VIEW - BIM_EVENT_RESP_SUMM#

[top of page]

Table: BIM_EVENT_REVCOST_SUMM

Description: Summarized data by user-defined period and is populated by BIM_EVNT_REVCST_SUMM_PKG concurrent program.

[top of page]

BIM.BIM_EVENT_REVCOST_SUMM does not reference any database object

BIM.BIM_EVENT_REVCOST_SUMM is referenced by following:

BIM
VIEW - BIM_EVENT_REVCOST_SUMM#

[top of page]

Table: BIM_GEOGRAPHY

Description: Dimension values for geographic locations and is populated by BIM_GEO_PKG concurrent program.
Primary Key: BIM_GEOGRAPHY_PK
  1. LOCATION_HIERARCHY_CODE

[top of page]

BIM.BIM_GEOGRAPHY does not reference any database object

BIM.BIM_GEOGRAPHY is referenced by following:

BIM
VIEW - BIM_GEOGRAPHY#

[top of page]

Table: BIM_LEAD_CONV_SUMM

Description: Summarized data by user-defined period and is populated by BIM_LEAD_CONV_SUMM_PKG concurrent program.

[top of page]

BIM.BIM_LEAD_CONV_SUMM does not reference any database object

BIM.BIM_LEAD_CONV_SUMM is referenced by following:

BIM
VIEW - BIM_LEAD_CONV_SUMM#

[top of page]

Table: BIM_OPPR_CYCLE_SUMM

Description: Summarized data by user-defined period and is populated by BIM_OPPR_CYCLE_SUMM_PKG concurrent program.

[top of page]

BIM.BIM_OPPR_CYCLE_SUMM does not reference any database object

BIM.BIM_OPPR_CYCLE_SUMM is referenced by following:

BIM
VIEW - BIM_OPPR_CYCLE_SUMM#

[top of page]

Table: BIM_SALES_CATEGORY_HIER

Description: Relationship between user-defined sales interest types, primary interest codes and secondary interest codes and is populated by BIM_SALES_CATEGORIES_PKG concurrent program.
Primary Key: BIM_SALES_CATEGORY_HIER_PK
  1. INTEREST_TYPE_ID
  2. PRIMARY_INTEREST_CODE_ID
  3. SECONDARY_INTEREST_CODE_ID

[top of page]

BIM.BIM_SALES_CATEGORY_HIER does not reference any database object

BIM.BIM_SALES_CATEGORY_HIER is referenced by following:

BIM
VIEW - BIM_SALES_CATEGORY_HIER#

[top of page]

Table: BIM_SALES_CYCLE_SUMM

Description: Summarized data by user-defined period and is populated by BIM_SALES_CYCLE_SUMM_PKG concurrent program.

[top of page]

BIM.BIM_SALES_CYCLE_SUMM does not reference any database object

BIM.BIM_SALES_CYCLE_SUMM is referenced by following:

BIM
VIEW - BIM_SALES_CYCLE_SUMM#

[top of page]

Table: BIM_SLIST_PROFIT_SUMM

Description: Summarized data by user-defined period and is populated by BIM_SRCLIST_PROFIT_PKG concurrent program.

[top of page]

BIM.BIM_SLIST_PROFIT_SUMM does not reference any database object

BIM.BIM_SLIST_PROFIT_SUMM is referenced by following:

BIM
VIEW - BIM_SLIST_PROFIT_SUMM#

[top of page]

Table: BIM_SOURCE_CODE_DETAILS

Description: All the marketing source codes and is populated by BIM_SRC_CODE_DETAILS_PKG concurrent program.
Primary Key: BIM_SOURCE_CODE_DETAILS_PK
  1. SOURCE_CODE_ID

[top of page]

BIM.BIM_SOURCE_CODE_DETAILS does not reference any database object

BIM.BIM_SOURCE_CODE_DETAILS is referenced by following:

BIM
VIEW - BIM_SOURCE_CODE_DETAILS#

[top of page]

Table: BIM_TARGET_SEGMENTS_DENORM

Description: Target segment hierarchy information in a denormalized fashion and is populated by BIM_TRGT_SGMT_DENORM_PKG concurrent program.
Primary Key: BIM_TARGET_SEGMENTS_DENORM_PK
  1. TARGET_SEGMENT_ID
  2. PARENT_TARGET_SEGMENT_ID

[top of page]

BIM.BIM_TARGET_SEGMENTS_DENORM does not reference any database object

BIM.BIM_TARGET_SEGMENTS_DENORM is referenced by following:

BIM
VIEW - BIM_TARGET_SEGMENTS_DENORM#

[top of page]

Table: BIM_TRGT_SGMT_PERF_SUMM

Description: Summarized data by user-defined period and is populated by BIM_TRGT_SGMT_PERF_PKG concurrent program.

[top of page]

BIM.BIM_TRGT_SGMT_PERF_SUMM does not reference any database object

BIM.BIM_TRGT_SGMT_PERF_SUMM is referenced by following:

BIM
VIEW - BIM_TRGT_SGMT_PERF_SUMM#

[top of page]

Table: EDW_BIM_CAMP_CMPGNS_L1_LTC

Description: Campaign Level 1 Table

[top of page]

BIM.EDW_BIM_CAMP_CMPGNS_L1_LTC does not reference any database object

BIM.EDW_BIM_CAMP_CMPGNS_L1_LTC is referenced by following:

BIM
VIEW - EDW_BIM_CAMP_CMPGNS_L1_LTC#

[top of page]

Table: EDW_BIM_CAMP_CMPGNS_L2_LTC

Description: Campaign Level 2 Table

[top of page]

BIM.EDW_BIM_CAMP_CMPGNS_L2_LTC does not reference any database object

BIM.EDW_BIM_CAMP_CMPGNS_L2_LTC is referenced by following:

BIM
VIEW - EDW_BIM_CAMP_CMPGNS_L2_LTC#

[top of page]

Table: EDW_BIM_CAMP_CMPGNS_L3_LTC

Description: Campaign Level 3 Table

[top of page]

BIM.EDW_BIM_CAMP_CMPGNS_L3_LTC does not reference any database object

BIM.EDW_BIM_CAMP_CMPGNS_L3_LTC is referenced by following:

BIM
VIEW - EDW_BIM_CAMP_CMPGNS_L3_LTC#

[top of page]

Table: EDW_BIM_CAMP_CMPGNS_L4_LTC

Description: Campaign Level 4 Table

[top of page]

BIM.EDW_BIM_CAMP_CMPGNS_L4_LTC does not reference any database object

BIM.EDW_BIM_CAMP_CMPGNS_L4_LTC is referenced by following:

BIM
VIEW - EDW_BIM_CAMP_CMPGNS_L4_LTC#

[top of page]

Table: EDW_BIM_CAMP_CMPGNS_L5_LTC

Description: Campaign Level 5 Table

[top of page]

BIM.EDW_BIM_CAMP_CMPGNS_L5_LTC does not reference any database object

BIM.EDW_BIM_CAMP_CMPGNS_L5_LTC is referenced by following:

BIM
VIEW - EDW_BIM_CAMP_CMPGNS_L5_LTC#

[top of page]

Table: EDW_BIM_CAMP_CMPGNS_L6_LTC

Description: Campaign Level 6 Table

[top of page]

BIM.EDW_BIM_CAMP_CMPGNS_L6_LTC does not reference any database object

BIM.EDW_BIM_CAMP_CMPGNS_L6_LTC is referenced by following:

BIM
VIEW - EDW_BIM_CAMP_CMPGNS_L6_LTC#

[top of page]

Table: EDW_BIM_CAMP_CMPGNS_L7_LTC

Description: Campaign Level 7 Table

[top of page]

BIM.EDW_BIM_CAMP_CMPGNS_L7_LTC does not reference any database object

BIM.EDW_BIM_CAMP_CMPGNS_L7_LTC is referenced by following:

BIM
VIEW - EDW_BIM_CAMP_CMPGNS_L7_LTC#

[top of page]

Table: EDW_BIM_CAMP_CMPGNS_L8_LTC

Description: Campaign Level 8 Table

[top of page]

BIM.EDW_BIM_CAMP_CMPGNS_L8_LTC does not reference any database object

BIM.EDW_BIM_CAMP_CMPGNS_L8_LTC is referenced by following:

BIM
VIEW - EDW_BIM_CAMP_CMPGNS_L8_LTC#

[top of page]

Table: EDW_BIM_CAMP_CMPGNS_LTC

Description: Campaign Level Table

[top of page]

BIM.EDW_BIM_CAMP_CMPGNS_LTC does not reference any database object

BIM.EDW_BIM_CAMP_CMPGNS_LTC is referenced by following:

BIM
VIEW - EDW_BIM_CAMP_CMPGNS_LTC#

[top of page]

Table: EDW_BIM_CAMP_SCHEDULES_LTC

Description: Cammpaign Schedule Level Table

[top of page]

BIM.EDW_BIM_CAMP_SCHEDULES_LTC does not reference any database object

BIM.EDW_BIM_CAMP_SCHEDULES_LTC is referenced by following:

BIM
VIEW - EDW_BIM_CAMP_SCHEDULES_LTC#

[top of page]

Table: EDW_BIM_CMPGNS_A_LTC

Description: Top (All) Level for Campaign Dimension

[top of page]

BIM.EDW_BIM_CMPGNS_A_LTC does not reference any database object

BIM.EDW_BIM_CMPGNS_A_LTC is referenced by following:

BIM
VIEW - EDW_BIM_CMPGNS_A_LTC#

[top of page]

Table: EDW_BIM_CMPGNS_DENORM

Description: Campaign Denormalised table

[top of page]

BIM.EDW_BIM_CMPGNS_DENORM does not reference any database object

BIM.EDW_BIM_CMPGNS_DENORM is referenced by following:

BIM
VIEW - EDW_BIM_CMPGNS_DENORM#

[top of page]

Table: EDW_BIM_CMPGNS_M

Description: Campaign dimension table .
Primary Key: EDW_BIM_CMPGNS_M_PK
  1. L10_CAMPAIGN_SCHEDULE_PK_KEY
Foreign Keys to this table:
Foreign Key Column Foreign Table
BIM_EDW_CMPFRCST_FSTG.CMPGN_FK_KEY EDW_BIM_CMPGNS_M
BIM_EDW_CMPFRCST_F.CMPGN_FK_KEY EDW_BIM_CMPGNS_M
BIM_EDW_EVTFRCST_F.CMPGN_FK_KEY EDW_BIM_CMPGNS_M
BIM_EDW_INTRCTNS_F.CMPGN_FK_KEY EDW_BIM_CMPGNS_M
BIM_EDW_LEADS_F.CMPGN_FK_KEY EDW_BIM_CMPGNS_M
BIM_EDW_OPRNTIES_F.CMPGN_FK_KEY EDW_BIM_CMPGNS_M
BIM_EDW_RVCT_DLY_F.CMPGN_FK_KEY EDW_BIM_CMPGNS_M
BIM_EDW_RVCT_MTH_F.CMPGN_FK_KEY EDW_BIM_CMPGNS_M

[top of page]

BIM.EDW_BIM_CMPGNS_M does not reference any database object

BIM.EDW_BIM_CMPGNS_M is referenced by following:

BIM
VIEW - EDW_BIM_CMPGNS_M#

[top of page]

Table: EDW_BIM_CMPSTATS_A_LTC

Description: Top Level of the Campaign Status Dimension

[top of page]

BIM.EDW_BIM_CMPSTATS_A_LTC does not reference any database object

BIM.EDW_BIM_CMPSTATS_A_LTC is referenced by following:

BIM
VIEW - EDW_BIM_CMPSTATS_A_LTC#

[top of page]

Table: EDW_BIM_CMPSTATS_M

Description: Campaign Status dimension star table .
Primary Key: EDW_BIM_CMPSTATS_M_PK
  1. L1_CMPGN_STATUS_PK_KEY
Foreign Keys to this table:
Foreign Key Column Foreign Table
BIM_EDW_CMPFRCST_F.CMPGN_STATUS_FK_KEY EDW_BIM_CMPSTATS_M
BIM_EDW_EVTFRCST_F.CMPGN_STATUS_FK_KEY EDW_BIM_CMPSTATS_M
BIM_EDW_INTRCTNS_F.CMPGN_STATUS_FK_KEY EDW_BIM_CMPSTATS_M
BIM_EDW_LEADS_F.CMPGN_STATUS_FK_KEY EDW_BIM_CMPSTATS_M
BIM_EDW_OPRNTIES_F.CMPGN_STATUS_FK_KEY EDW_BIM_CMPSTATS_M
BIM_EDW_RVCT_DLY_F.CMPGN_STATUS_FK_KEY EDW_BIM_CMPSTATS_M
BIM_EDW_RVCT_MTH_F.CMPGN_STATUS_FK_KEY EDW_BIM_CMPSTATS_M

[top of page]

BIM.EDW_BIM_CMPSTATS_M does not reference any database object

BIM.EDW_BIM_CMPSTATS_M is referenced by following:

BIM
VIEW - EDW_BIM_CMPSTATS_M#

[top of page]

Table: EDW_BIM_CSTA_CMPSTATS_LTC

Description: Campaign Status Level Table

[top of page]

BIM.EDW_BIM_CSTA_CMPSTATS_LTC does not reference any database object

BIM.EDW_BIM_CSTA_CMPSTATS_LTC is referenced by following:

BIM
VIEW - EDW_BIM_CSTA_CMPSTATS_LTC#

[top of page]

Table: EDW_BIM_EVENTS_A_LTC

Description: Top Level for Event Dimension

[top of page]

BIM.EDW_BIM_EVENTS_A_LTC does not reference any database object

BIM.EDW_BIM_EVENTS_A_LTC is referenced by following:

BIM
VIEW - EDW_BIM_EVENTS_A_LTC#

[top of page]

Table: EDW_BIM_EVENTS_M

Description: Event Dimension table .
Primary Key: EDW_BIM_EVENTS_M_PK
  1. L2_EVTOFFER_PK_KEY
Foreign Keys to this table:
Foreign Key Column Foreign Table
BIM_EDW_CMPFRCST_F.EVENT_FK_KEY EDW_BIM_EVENTS_M
BIM_EDW_EVTFRCST_F.EVENT_FK_KEY EDW_BIM_EVENTS_M
BIM_EDW_INTRCTNS_F.EVENT_FK_KEY EDW_BIM_EVENTS_M
BIM_EDW_LEADS_F.EVENT_FK_KEY EDW_BIM_EVENTS_M
BIM_EDW_OPRNTIES_F.EVENT_FK_KEY EDW_BIM_EVENTS_M
BIM_EDW_RVCT_DLY_F.EVENT_FK_KEY EDW_BIM_EVENTS_M
BIM_EDW_RVCT_MTH_F.EVENT_FK_KEY EDW_BIM_EVENTS_M

[top of page]

BIM.EDW_BIM_EVENTS_M does not reference any database object

BIM.EDW_BIM_EVENTS_M is referenced by following:

BIM
VIEW - EDW_BIM_EVENTS_M#

[top of page]

Table: EDW_BIM_EVNT_EVENTS_LTC

Description: Event level table .

[top of page]

BIM.EDW_BIM_EVNT_EVENTS_LTC does not reference any database object

BIM.EDW_BIM_EVNT_EVENTS_LTC is referenced by following:

BIM
VIEW - EDW_BIM_EVNT_EVENTS_LTC#

[top of page]

Table: EDW_BIM_EVNT_EVTOFFERS_LTC

Description: Event Offering Level Table of Event Dimension .

[top of page]

BIM.EDW_BIM_EVNT_EVTOFFERS_LTC does not reference any database object

BIM.EDW_BIM_EVNT_EVTOFFERS_LTC is referenced by following:

BIM
VIEW - EDW_BIM_EVNT_EVTOFFERS_LTC#

[top of page]

Table: EDW_BIM_IHMD_IH_MEDIA_LTC

Description: Interaction Media Level Table .

[top of page]

BIM.EDW_BIM_IHMD_IH_MEDIA_LTC does not reference any database object

BIM.EDW_BIM_IHMD_IH_MEDIA_LTC is referenced by following:

BIM
VIEW - EDW_BIM_IHMD_IH_MEDIA_LTC#

[top of page]

Table: EDW_BIM_IHOT_IH_OUTCOME_LTC

Description: Interaction Outcome Level Table.

[top of page]

BIM.EDW_BIM_IHOT_IH_OUTCOME_LTC does not reference any database object

BIM.EDW_BIM_IHOT_IH_OUTCOME_LTC is referenced by following:

BIM
VIEW - EDW_BIM_IHOT_IH_OUTCOME_LTC#

[top of page]

Table: EDW_BIM_IHRN_IH_REASON_LTC

Description: Interection Reason Level Table .

[top of page]

BIM.EDW_BIM_IHRN_IH_REASON_LTC does not reference any database object

BIM.EDW_BIM_IHRN_IH_REASON_LTC is referenced by following:

BIM
VIEW - EDW_BIM_IHRN_IH_REASON_LTC#

[top of page]

Table: EDW_BIM_IHRS_IH_RESULT_LTC

Description: Level Table for Interection result .

[top of page]

BIM.EDW_BIM_IHRS_IH_RESULT_LTC does not reference any database object

BIM.EDW_BIM_IHRS_IH_RESULT_LTC is referenced by following:

BIM
VIEW - EDW_BIM_IHRS_IH_RESULT_LTC#

[top of page]

Table: EDW_BIM_IH_MEDIA_A_LTC

Description: All Level table .

[top of page]

BIM.EDW_BIM_IH_MEDIA_A_LTC does not reference any database object

BIM.EDW_BIM_IH_MEDIA_A_LTC is referenced by following:

BIM
VIEW - EDW_BIM_IH_MEDIA_A_LTC#

[top of page]

Table: EDW_BIM_IH_MEDIA_M

Description: Interaction Media Dimension Table .
Primary Key: EDW_BIM_IH_MEDIA_M_PK
  1. MDIA_INTRCTN_MEDIA_PK_KEY
Foreign Keys to this table:
Foreign Key Column Foreign Table
BIM_EDW_INTRCTNS_F.INTRCTN_MEDIA_FK_KEY EDW_BIM_IH_MEDIA_M

[top of page]

BIM.EDW_BIM_IH_MEDIA_M does not reference any database object

BIM.EDW_BIM_IH_MEDIA_M is referenced by following:

BIM
VIEW - EDW_BIM_IH_MEDIA_M#

[top of page]

Table: EDW_BIM_IH_OUTCM_A_LTC

Description: All Level table .

[top of page]

BIM.EDW_BIM_IH_OUTCM_A_LTC does not reference any database object

BIM.EDW_BIM_IH_OUTCM_A_LTC is referenced by following:

BIM
VIEW - EDW_BIM_IH_OUTCM_A_LTC#

[top of page]

Table: EDW_BIM_IH_OUTCM_M

Description: Interaction Outcome Dimension .
Primary Key: EDW_BIM_IH_OUTCM_M_PK
  1. OTCM_INTRCTN_OUTCOME_PK_KEY
Foreign Keys to this table:
Foreign Key Column Foreign Table
BIM_EDW_INTRCTNS_F.INTRCTN_OUTCOME_FK_KEY EDW_BIM_IH_OUTCM_M

[top of page]

BIM.EDW_BIM_IH_OUTCM_M does not reference any database object

BIM.EDW_BIM_IH_OUTCM_M is referenced by following:

BIM
VIEW - EDW_BIM_IH_OUTCM_M#

[top of page]

Table: EDW_BIM_IH_REASN_A_LTC

Description: All Level table .

[top of page]

BIM.EDW_BIM_IH_REASN_A_LTC does not reference any database object

BIM.EDW_BIM_IH_REASN_A_LTC is referenced by following:

BIM
VIEW - EDW_BIM_IH_REASN_A_LTC#

[top of page]

Table: EDW_BIM_IH_REASN_M

Description: Interaction Reason Dimension table .
Primary Key: EDW_BIM_IH_REASN_M_PK
  1. RESN_INTRCTN_REASON_PK_KEY
Foreign Keys to this table:
Foreign Key Column Foreign Table
BIM_EDW_INTRCTNS_F.INTRCTN_REASON_FK_KEY EDW_BIM_IH_REASN_M

[top of page]

BIM.EDW_BIM_IH_REASN_M does not reference any database object

BIM.EDW_BIM_IH_REASN_M is referenced by following:

BIM
VIEW - EDW_BIM_IH_REASN_M#

[top of page]

Table: EDW_BIM_IH_RESLT_A_LTC

Description: All Level table .

[top of page]

BIM.EDW_BIM_IH_RESLT_A_LTC does not reference any database object

BIM.EDW_BIM_IH_RESLT_A_LTC is referenced by following:

BIM
VIEW - EDW_BIM_IH_RESLT_A_LTC#

[top of page]

Table: EDW_BIM_IH_RESLT_M

Description: Interaction Result Dimension table .
Primary Key: EDW_BIM_IH_RESLT_M_PK
  1. RSLT_INTRCTN_RESULT_PK_KEY
Foreign Keys to this table:
Foreign Key Column Foreign Table
BIM_EDW_INTRCTNS_F.INTRCTN_RESULT_FK_KEY EDW_BIM_IH_RESLT_M

[top of page]

BIM.EDW_BIM_IH_RESLT_M does not reference any database object

BIM.EDW_BIM_IH_RESLT_M is referenced by following:

BIM
VIEW - EDW_BIM_IH_RESLT_M#

[top of page]

Table: EDW_BIM_LEADS_A_LTC

Description: All Level Table .

[top of page]

BIM.EDW_BIM_LEADS_A_LTC does not reference any database object

BIM.EDW_BIM_LEADS_A_LTC is referenced by following:

BIM
VIEW - EDW_BIM_LEADS_A_LTC#

[top of page]

Table: EDW_BIM_LEADS_M

Description: Lead Dimension Table .
Primary Key: EDW_BIM_LEADS_M_PK
  1. L2_LEADLINE_PK_KEY
Foreign Keys to this table:
Foreign Key Column Foreign Table
BIM_EDW_LEADS_F.LEADLINE_FK_KEY EDW_BIM_LEADS_M
BIM_EDW_RVCT_DLY_F.LEAD_FK_KEY EDW_BIM_LEADS_M
BIM_EDW_RVCT_MTH_F.LEAD_FK_KEY EDW_BIM_LEADS_M

[top of page]

BIM.EDW_BIM_LEADS_M does not reference any database object

BIM.EDW_BIM_LEADS_M is referenced by following:

BIM
VIEW - EDW_BIM_LEADS_M#

[top of page]

Table: EDW_BIM_LEAD_LEADLINES_LTC

Description: Lead Line Level Table

[top of page]

BIM.EDW_BIM_LEAD_LEADLINES_LTC does not reference any database object

BIM.EDW_BIM_LEAD_LEADLINES_LTC is referenced by following:

BIM
VIEW - EDW_BIM_LEAD_LEADLINES_LTC#

[top of page]

Table: EDW_BIM_LEAD_LEADS_LTC

Description: Lead Level Table .

[top of page]

BIM.EDW_BIM_LEAD_LEADS_LTC does not reference any database object

BIM.EDW_BIM_LEAD_LEADS_LTC is referenced by following:

BIM
VIEW - EDW_BIM_LEAD_LEADS_LTC#

[top of page]

Table: EDW_BIM_LEAD_STATUS_A_LTC

Description: All Level Table .

[top of page]

BIM.EDW_BIM_LEAD_STATUS_A_LTC does not reference any database object

BIM.EDW_BIM_LEAD_STATUS_A_LTC is referenced by following:

BIM
VIEW - EDW_BIM_LEAD_STATUS_A_LTC#

[top of page]

Table: EDW_BIM_LEAD_STATUS_M

Description: Lead Status Dimension .
Primary Key: EDW_BIM_LEAD_STATUS_M_PK
  1. L1_LEADSTATUS_PK_KEY
Foreign Keys to this table:
Foreign Key Column Foreign Table
BIM_EDW_LEADS_F.LEADSTATUS_FK_KEY EDW_BIM_LEAD_STATUS_M
BIM_EDW_RVCT_MTH_F.LEADSTATUS_FK_KEY EDW_BIM_LEAD_STATUS_M
BIM_EDW_RVCT_DLY_F.LEADSTATUS_FK_KEY EDW_BIM_LEAD_STATUS_M

[top of page]

BIM.EDW_BIM_LEAD_STATUS_M does not reference any database object

BIM.EDW_BIM_LEAD_STATUS_M is referenced by following:

BIM
VIEW - EDW_BIM_LEAD_STATUS_M#

[top of page]

Table: EDW_BIM_LIST_SRCLSTS_LTC

Description: Source List Level Table .

[top of page]

BIM.EDW_BIM_LIST_SRCLSTS_LTC does not reference any database object

BIM.EDW_BIM_LIST_SRCLSTS_LTC is referenced by following:

BIM
VIEW - EDW_BIM_LIST_SRCLSTS_LTC#

[top of page]

Table: EDW_BIM_LSTA_LEADSTATUS_LTC

Description: Lead Status Level Table .

[top of page]

BIM.EDW_BIM_LSTA_LEADSTATUS_LTC does not reference any database object

BIM.EDW_BIM_LSTA_LEADSTATUS_LTC is referenced by following:

BIM
VIEW - EDW_BIM_LSTA_LEADSTATUS_LTC#

[top of page]

Table: EDW_BIM_MDCHN_A_LTC

Description: All Level Table .

[top of page]

BIM.EDW_BIM_MDCHN_A_LTC does not reference any database object

BIM.EDW_BIM_MDCHN_A_LTC is referenced by following:

BIM
VIEW - EDW_BIM_MDCHN_A_LTC#

[top of page]

Table: EDW_BIM_MDCHN_M

Description: Media Channel Dimension table .
Primary Key: EDW_BIM_MDCHN_M_PK
  1. L4_MDCHNL_PK_KEY
Foreign Keys to this table:
Foreign Key Column Foreign Table
BIM_EDW_CMPFRCST_F.MEDCHNL_FK_KEY EDW_BIM_MDCHN_M
BIM_EDW_EVTFRCST_F.MDCHNL_FK_KEY EDW_BIM_MDCHN_M
BIM_EDW_INTRCTNS_F.MDCHNL_FK_KEY EDW_BIM_MDCHN_M
BIM_EDW_LEADS_F.MDCHNL_FK_KEY EDW_BIM_MDCHN_M
BIM_EDW_OPRNTIES_F.MDCHNL_FK_KEY EDW_BIM_MDCHN_M
BIM_EDW_RVCT_DLY_F.MEDCHNL_FK_KEY EDW_BIM_MDCHN_M
BIM_EDW_RVCT_MTH_F.MEDCHNL_FK_KEY EDW_BIM_MDCHN_M

[top of page]

BIM.EDW_BIM_MDCHN_M does not reference any database object

BIM.EDW_BIM_MDCHN_M is referenced by following:

BIM
VIEW - EDW_BIM_MDCHN_M#

[top of page]

Table: EDW_BIM_MDCH_CHANNELS_LTC

Description: Channel Level Table .

[top of page]

BIM.EDW_BIM_MDCH_CHANNELS_LTC does not reference any database object

BIM.EDW_BIM_MDCH_CHANNELS_LTC is referenced by following:

BIM
VIEW - EDW_BIM_MDCH_CHANNELS_LTC#

[top of page]

Table: EDW_BIM_MDCH_MDCHN_LTC

Description: Media Channel Level Table .

[top of page]

BIM.EDW_BIM_MDCH_MDCHN_LTC does not reference any database object

BIM.EDW_BIM_MDCH_MDCHN_LTC is referenced by following:

BIM
VIEW - EDW_BIM_MDCH_MDCHN_LTC#

[top of page]

Table: EDW_BIM_MDCH_MDTYPES_LTC

Description: Media Type Level table .

[top of page]

BIM.EDW_BIM_MDCH_MDTYPES_LTC does not reference any database object

BIM.EDW_BIM_MDCH_MDTYPES_LTC is referenced by following:

BIM
VIEW - EDW_BIM_MDCH_MDTYPES_LTC#

[top of page]

Table: EDW_BIM_MDCH_MEDIA_LTC

Description: Media Level table .

[top of page]

BIM.EDW_BIM_MDCH_MEDIA_LTC does not reference any database object

BIM.EDW_BIM_MDCH_MEDIA_LTC is referenced by following:

BIM
VIEW - EDW_BIM_MDCH_MEDIA_LTC#

[top of page]

Table: EDW_BIM_MKSG_MKTSGMTS_LTC

Description: Market Segment Level Table .

[top of page]

BIM.EDW_BIM_MKSG_MKTSGMTS_LTC does not reference any database object

BIM.EDW_BIM_MKSG_MKTSGMTS_LTC is referenced by following:

BIM
VIEW - EDW_BIM_MKSG_MKTSGMTS_LTC#

[top of page]

Table: EDW_BIM_MKTSGMTS_A_LTC

Description: All Level Table .

[top of page]

BIM.EDW_BIM_MKTSGMTS_A_LTC does not reference any database object

BIM.EDW_BIM_MKTSGMTS_A_LTC is referenced by following:

BIM
VIEW - EDW_BIM_MKTSGMTS_A_LTC#

[top of page]

Table: EDW_BIM_MKTSGMTS_M

Description: Market Segment dimension table .
Primary Key: EDW_BIM_MKTSGMTS_M_PK
  1. L1_MKTSGMT_PK_KEY
Foreign Keys to this table:
Foreign Key Column Foreign Table
BIM_EDW_CMPFRCST_F.MKTSGMT_FK_KEY EDW_BIM_MKTSGMTS_M
BIM_EDW_EVTFRCST_F.MKTSGMT_FK_KEY EDW_BIM_MKTSGMTS_M
BIM_EDW_INTRCTNS_F.MKTSGMT_FK_KEY EDW_BIM_MKTSGMTS_M
BIM_EDW_LEADS_F.MKTSGMT_FK_KEY EDW_BIM_MKTSGMTS_M
BIM_EDW_OPRNTIES_F.MKTSGMT_FK_KEY EDW_BIM_MKTSGMTS_M
BIM_EDW_RVCT_DLY_F.MKTSGMT_FK_KEY EDW_BIM_MKTSGMTS_M
BIM_EDW_RVCT_MTH_F.MKTSGMT_FK_KEY EDW_BIM_MKTSGMTS_M

[top of page]

BIM.EDW_BIM_MKTSGMTS_M does not reference any database object

BIM.EDW_BIM_MKTSGMTS_M is referenced by following:

BIM
VIEW - EDW_BIM_MKTSGMTS_M#

[top of page]

Table: EDW_BIM_OFFERS_A_LTC

Description: All Level Table .

[top of page]

BIM.EDW_BIM_OFFERS_A_LTC does not reference any database object

BIM.EDW_BIM_OFFERS_A_LTC is referenced by following:

BIM
VIEW - EDW_BIM_OFFERS_A_LTC#

[top of page]

Table: EDW_BIM_OFFERS_M

Description: Offer dimension table .
Primary Key: EDW_BIM_OFFERS_M_PK
  1. L1_OFFER_PK_KEY
Foreign Keys to this table:
Foreign Key Column Foreign Table
BIM_EDW_EVTFRCST_F.OFFER_FK_KEY EDW_BIM_OFFERS_M
BIM_EDW_INTRCTNS_F.OFFER_FK_KEY EDW_BIM_OFFERS_M
BIM_EDW_LEADS_F.OFFER_FK_KEY EDW_BIM_OFFERS_M
BIM_EDW_OPRNTIES_F.OPPLINE_FK_KEY EDW_BIM_OFFERS_M
BIM_EDW_RVCT_MTH_F.LINE_OFFER_FK_KEY EDW_BIM_OFFERS_M
BIM_EDW_RVCT_DLY_F.HEADER_OFFER_FK_KEY EDW_BIM_OFFERS_M
BIM_EDW_RVCT_DLY_F.LINE_OFFER_FK_KEY EDW_BIM_OFFERS_M
BIM_EDW_RVCT_MTH_F.HEADER_OFFER_FK_KEY EDW_BIM_OFFERS_M

[top of page]

BIM.EDW_BIM_OFFERS_M does not reference any database object

BIM.EDW_BIM_OFFERS_M is referenced by following:

BIM
VIEW - EDW_BIM_OFFERS_M#

[top of page]

Table: EDW_BIM_OFFR_OFFERS_LTC

Description: Offer Level Table .

[top of page]

BIM.EDW_BIM_OFFR_OFFERS_LTC does not reference any database object

BIM.EDW_BIM_OFFR_OFFERS_LTC is referenced by following:

BIM
VIEW - EDW_BIM_OFFR_OFFERS_LTC#

[top of page]

Table: EDW_BIM_OPPORTUNITIES_A_LTC

Description: All Level Table .

[top of page]

BIM.EDW_BIM_OPPORTUNITIES_A_LTC does not reference any database object

BIM.EDW_BIM_OPPORTUNITIES_A_LTC is referenced by following:

BIM
VIEW - EDW_BIM_OPPORTUNITIES_A_LTC#

[top of page]

Table: EDW_BIM_OPPORTUNITIES_M

Description: Opportunity Dimension table .
Primary Key: EDW_BIM_OPPORTUNITIES_M_PK
  1. L2_OPPLINE_PK_KEY
Foreign Keys to this table:
Foreign Key Column Foreign Table
BIM_EDW_OPRNTIES_F.OPPLINE_FK_KEY EDW_BIM_OPPORTUNITIES_M
BIM_EDW_RVCT_DLY_F.OPPORTUNITY_FK_KEY EDW_BIM_OPPORTUNITIES_M
BIM_EDW_RVCT_MTH_F.OPPORTUNITY_FK_KEY EDW_BIM_OPPORTUNITIES_M

[top of page]

BIM.EDW_BIM_OPPORTUNITIES_M does not reference any database object

BIM.EDW_BIM_OPPORTUNITIES_M is referenced by following:

BIM
VIEW - EDW_BIM_OPPORTUNITIES_M#

[top of page]

Table: EDW_BIM_OPPR_OPPLINES_LTC

Description: Opportunity Line Level Table .

[top of page]

BIM.EDW_BIM_OPPR_OPPLINES_LTC does not reference any database object

BIM.EDW_BIM_OPPR_OPPLINES_LTC is referenced by following:

BIM
VIEW - EDW_BIM_OPPR_OPPLINES_LTC#

[top of page]

Table: EDW_BIM_OPPR_OPRNTIES_LTC

Description: Opportunity Level Table .

[top of page]

BIM.EDW_BIM_OPPR_OPRNTIES_LTC does not reference any database object

BIM.EDW_BIM_OPPR_OPRNTIES_LTC is referenced by following:

BIM
VIEW - EDW_BIM_OPPR_OPRNTIES_LTC#

[top of page]

Table: EDW_BIM_OPP_STATUS_A_LTC

Description: All Level Table .

[top of page]

BIM.EDW_BIM_OPP_STATUS_A_LTC does not reference any database object

BIM.EDW_BIM_OPP_STATUS_A_LTC is referenced by following:

BIM
VIEW - EDW_BIM_OPP_STATUS_A_LTC#

[top of page]

Table: EDW_BIM_OPP_STATUS_M

Description: Opportunity Status Dimension Table .
Primary Key: EDW_BIM_OPP_STATUS_M_PK
  1. L1_OPPSTATUS_PK_KEY
Foreign Keys to this table:
Foreign Key Column Foreign Table
BIM_EDW_OPRNTIES_F.OPPSTATUS_FK_KEY EDW_BIM_OPP_STATUS_M
BIM_EDW_RVCT_DLY_F.OPPSTATUS_FK_KEY EDW_BIM_OPP_STATUS_M
BIM_EDW_RVCT_MTH_F.OPPSTATUS_FK_KEY EDW_BIM_OPP_STATUS_M

[top of page]

BIM.EDW_BIM_OPP_STATUS_M does not reference any database object

BIM.EDW_BIM_OPP_STATUS_M is referenced by following:

BIM
VIEW - EDW_BIM_OPP_STATUS_M#

[top of page]

Table: EDW_BIM_OSTA_OPPSTATUS_LTC

Description: Opportunity Status Level Table .

[top of page]

BIM.EDW_BIM_OSTA_OPPSTATUS_LTC does not reference any database object

BIM.EDW_BIM_OSTA_OPPSTATUS_LTC is referenced by following:

BIM
VIEW - EDW_BIM_OSTA_OPPSTATUS_LTC#

[top of page]

Table: EDW_BIM_SOURCE_CODE_DETAILS

Description:

[top of page]

BIM.EDW_BIM_SOURCE_CODE_DETAILS does not reference any database object

BIM.EDW_BIM_SOURCE_CODE_DETAILS is referenced by following:

BIM
VIEW - EDW_BIM_SOURCE_CODE_DETAILS#

[top of page]

Table: EDW_BIM_SRCLSTS_A_LTC

Description: All Level Table .

[top of page]

BIM.EDW_BIM_SRCLSTS_A_LTC does not reference any database object

BIM.EDW_BIM_SRCLSTS_A_LTC is referenced by following:

BIM
VIEW - EDW_BIM_SRCLSTS_A_LTC#

[top of page]

Table: EDW_BIM_SRCLSTS_M

Description: Source List Dimension Table .
Primary Key: EDW_BIM_SRCLSTS_M_PK
  1. L1_SRCLST_PK_KEY
Foreign Keys to this table:
Foreign Key Column Foreign Table
BIM_EDW_CMPFRCST_F.SRCLST_FK_KEY EDW_BIM_SRCLSTS_M
BIM_EDW_EVTFRCST_F.SRCLST_FK_KEY EDW_BIM_SRCLSTS_M
BIM_EDW_INTRCTNS_F.SRCLST_FK_KEY EDW_BIM_SRCLSTS_M
BIM_EDW_LEADS_F.SRCLST_FK_KEY EDW_BIM_SRCLSTS_M
BIM_EDW_OPRNTIES_F.SRCLST_FK_KEY EDW_BIM_SRCLSTS_M
BIM_EDW_RVCT_DLY_F.SRCLST_FK_KEY EDW_BIM_SRCLSTS_M
BIM_EDW_RVCT_MTH_F.SRCLST_FK_KEY EDW_BIM_SRCLSTS_M

[top of page]

BIM.EDW_BIM_SRCLSTS_M does not reference any database object

BIM.EDW_BIM_SRCLSTS_M is referenced by following:

BIM
VIEW - EDW_BIM_SRCLSTS_M#

[top of page]

Table: EDW_BIM_TGSMT_A_LTC

Description: All Level Table .

[top of page]

BIM.EDW_BIM_TGSMT_A_LTC does not reference any database object

BIM.EDW_BIM_TGSMT_A_LTC is referenced by following:

BIM
VIEW - EDW_BIM_TGSMT_A_LTC#

[top of page]

Table: EDW_BIM_TGSMT_DENORM

Description: Target Segment denormalised table .

[top of page]

BIM.EDW_BIM_TGSMT_DENORM does not reference any database object

BIM.EDW_BIM_TGSMT_DENORM is referenced by following:

BIM
VIEW - EDW_BIM_TGSMT_DENORM#

[top of page]

Table: EDW_BIM_TGSMT_M

Description: Target Segment dimension table .
Primary Key: EDW_BIM_TGSMT_M_PK
  1. L9_TGTSGMT_PK_KEY
Foreign Keys to this table:
Foreign Key Column Foreign Table
BIM_EDW_CMPFRCST_F.TGTSGMT_FK_KEY EDW_BIM_TGSMT_M
BIM_EDW_EVTFRCST_F.TGTSGMT_FK_KEY EDW_BIM_TGSMT_M
BIM_EDW_INTRCTNS_F.TGTSGMT_FK_KEY EDW_BIM_TGSMT_M
BIM_EDW_LEADS_F.TGTSGMT_FK_KEY EDW_BIM_TGSMT_M
BIM_EDW_OPRNTIES_F.TGTSGMT_FK_KEY EDW_BIM_TGSMT_M
BIM_EDW_RVCT_DLY_F.TGTSGMT_FK_KEY EDW_BIM_TGSMT_M
BIM_EDW_RVCT_MTH_F.TGTSGMT_FK_KEY EDW_BIM_TGSMT_M

[top of page]

BIM.EDW_BIM_TGSMT_M does not reference any database object

BIM.EDW_BIM_TGSMT_M is referenced by following:

BIM
VIEW - EDW_BIM_TGSMT_M#

[top of page]

Table: EDW_BIM_TGST_TGSMT_L1_LTC

Description: Target segment level 1 table .

[top of page]

BIM.EDW_BIM_TGST_TGSMT_L1_LTC does not reference any database object

BIM.EDW_BIM_TGST_TGSMT_L1_LTC is referenced by following:

BIM
VIEW - EDW_BIM_TGST_TGSMT_L1_LTC#

[top of page]

Table: EDW_BIM_TGST_TGSMT_L2_LTC

Description: Target segment level 2 table .

[top of page]

BIM.EDW_BIM_TGST_TGSMT_L2_LTC does not reference any database object

BIM.EDW_BIM_TGST_TGSMT_L2_LTC is referenced by following:

BIM
VIEW - EDW_BIM_TGST_TGSMT_L2_LTC#

[top of page]

Table: EDW_BIM_TGST_TGSMT_L3_LTC

Description: Target segment level 3 table .

[top of page]

BIM.EDW_BIM_TGST_TGSMT_L3_LTC does not reference any database object

BIM.EDW_BIM_TGST_TGSMT_L3_LTC is referenced by following:

BIM
VIEW - EDW_BIM_TGST_TGSMT_L3_LTC#

[top of page]

Table: EDW_BIM_TGST_TGSMT_L4_LTC

Description: Target segment level 4 table .

[top of page]

BIM.EDW_BIM_TGST_TGSMT_L4_LTC does not reference any database object

BIM.EDW_BIM_TGST_TGSMT_L4_LTC is referenced by following:

BIM
VIEW - EDW_BIM_TGST_TGSMT_L4_LTC#

[top of page]

Table: EDW_BIM_TGST_TGSMT_L5_LTC

Description: Target segment level 5 table .

[top of page]

BIM.EDW_BIM_TGST_TGSMT_L5_LTC does not reference any database object

BIM.EDW_BIM_TGST_TGSMT_L5_LTC is referenced by following:

BIM
VIEW - EDW_BIM_TGST_TGSMT_L5_LTC#

[top of page]

Table: EDW_BIM_TGST_TGSMT_L6_LTC

Description: Target segment level 6 table .

[top of page]

BIM.EDW_BIM_TGST_TGSMT_L6_LTC does not reference any database object

BIM.EDW_BIM_TGST_TGSMT_L6_LTC is referenced by following:

BIM
VIEW - EDW_BIM_TGST_TGSMT_L6_LTC#

[top of page]

Table: EDW_BIM_TGST_TGSMT_L7_LTC

Description: Target segment level 7 table .

[top of page]

BIM.EDW_BIM_TGST_TGSMT_L7_LTC does not reference any database object

BIM.EDW_BIM_TGST_TGSMT_L7_LTC is referenced by following:

BIM
VIEW - EDW_BIM_TGST_TGSMT_L7_LTC#

[top of page]

Table: EDW_BIM_TGST_TGSMT_L8_LTC

Description: Target segment level 8 table .

[top of page]

BIM.EDW_BIM_TGST_TGSMT_L8_LTC does not reference any database object

BIM.EDW_BIM_TGST_TGSMT_L8_LTC is referenced by following:

BIM
VIEW - EDW_BIM_TGST_TGSMT_L8_LTC#

[top of page]

Table: EDW_BIM_TGST_TGSMT_LTC

Description: Target segment level table .

[top of page]

BIM.EDW_BIM_TGST_TGSMT_LTC does not reference any database object

BIM.EDW_BIM_TGST_TGSMT_LTC is referenced by following:

BIM
VIEW - EDW_BIM_TGST_TGSMT_LTC#

[top of page]

View: BIM_DIMV_CHANNELS

[top of page]

APPS.BIM_DIMV_CHANNELS references the following:

APPS
VIEW - AMS_CHANNELS_VL
VIEW - AMS_EVENT_HEADERS_VL
VIEW - AMS_EVENT_OFFERS_VL
VIEW - AMS_LOOKUPS
PACKAGE - FND_GLOBAL
- FND_LOOKUPS

APPS.BIM_DIMV_CHANNELS is not referenced by any database object

[top of page]

View: BIM_DIMV_EVENT_HEADERS

[top of page]

APPS.BIM_DIMV_EVENT_HEADERS references the following:

APPS
VIEW - AMS_EVENT_HEADERS_VL

APPS.BIM_DIMV_EVENT_HEADERS is not referenced by any database object

[top of page]

View: BIM_DIMV_EVENT_HIER

[top of page]

APPS.BIM_DIMV_EVENT_HIER references the following:

APPS
VIEW - AMS_EVENT_HEADERS_VL
VIEW - AMS_EVENT_OFFERS_VL
VIEW - AMS_LOOKUPS
PACKAGE - FND_GLOBAL
- FND_LOOKUPS
APPS.BIM_DIMV_EVENT_HIER is referenced by following:

APPS
VIEW - BIM_SUMV_EVENT_PERF
VIEW - BIM_SUMV_EVENT_REV
VIEW - BIM_SUMV_EVENT_RSLTS

[top of page]

View: BIM_DIMV_EVENT_OFFERS

[top of page]

APPS.BIM_DIMV_EVENT_OFFERS references the following:

APPS
VIEW - AMS_EVENT_OFFERS_VL
SYNONYM - HZ_LOCATIONS

APPS.BIM_DIMV_EVENT_OFFERS is not referenced by any database object

[top of page]

View: BIM_DIMV_EVENT_TYPES

[top of page]

APPS.BIM_DIMV_EVENT_TYPES references the following:

APPS
VIEW - AMS_LOOKUPS

APPS.BIM_DIMV_EVENT_TYPES is not referenced by any database object

[top of page]

View: BIM_DIMV_GEOGRAPHY

[top of page]

APPS.BIM_DIMV_GEOGRAPHY references the following:

APPS
SYNONYM - BIM_GEOGRAPHY
PACKAGE - FND_GLOBAL
- FND_LOOKUPS

APPS.BIM_DIMV_GEOGRAPHY is not referenced by any database object

[top of page]

View: BIM_DIMV_INTEREST_CODES

[top of page]

APPS.BIM_DIMV_INTEREST_CODES references the following:

APPS
SYNONYM - AS_INTEREST_CODES_ALL
SYNONYM - AS_INTEREST_CODES_B
SYNONYM - AS_INTEREST_CODES_TL
SYNONYM - AS_INTEREST_TYPES_ALL

APPS.BIM_DIMV_INTEREST_CODES is not referenced by any database object

[top of page]

View: BIM_DIMV_INTEREST_TYPES

[top of page]

APPS.BIM_DIMV_INTEREST_TYPES references the following:

APPS
SYNONYM - AS_INTEREST_TYPES_ALL
SYNONYM - AS_INTEREST_TYPES_B
SYNONYM - AS_INTEREST_TYPES_TL

APPS.BIM_DIMV_INTEREST_TYPES is not referenced by any database object

[top of page]

View: BIM_DIMV_MARKET_SGMTS

[top of page]

APPS.BIM_DIMV_MARKET_SGMTS references the following:

APPS
VIEW - AMS_CELLS_VL
PACKAGE - FND_GLOBAL
- FND_LOOKUPS
APPS.BIM_DIMV_MARKET_SGMTS is referenced by following:

APPS
VIEW - BIM_SUMV_CAMP_MARGIN
VIEW - BIM_SUMV_CAMP_PERF
VIEW - BIM_SUMV_CAMP_RESP
VIEW - BIM_SUMV_EVENT_PERF
VIEW - BIM_SUMV_LEAD_CONV
VIEW - BIM_SUMV_SALES_CYCLE
VIEW - BIM_SUMV_SLIST_PERF

[top of page]

View: BIM_DIMV_MEDIA

[top of page]

APPS.BIM_DIMV_MEDIA references the following:

APPS
VIEW - AMS_LOOKUPS
VIEW - AMS_MEDIA_VL
PACKAGE - FND_GLOBAL
- FND_LOOKUPS

APPS.BIM_DIMV_MEDIA is not referenced by any database object

[top of page]

View: BIM_DIMV_MEDIA_CHANNELS

[top of page]

APPS.BIM_DIMV_MEDIA_CHANNELS references the following:

APPS
VIEW - AMS_CHANNELS_VL
VIEW - AMS_EVENT_HEADERS_VL
VIEW - AMS_EVENT_OFFERS_VL
VIEW - AMS_LOOKUPS
SYNONYM - AMS_MEDIA_CHANNELS
VIEW - AMS_MEDIA_VL
PACKAGE - FND_GLOBAL
- FND_LOOKUPS
APPS.BIM_DIMV_MEDIA_CHANNELS is referenced by following:

APPS
VIEW - BIM_SUMV_CAMP_COST
VIEW - BIM_SUMV_CAMP_MARGIN
VIEW - BIM_SUMV_CAMP_PERF
VIEW - BIM_SUMV_CAMP_RESP
VIEW - BIM_SUMV_LEAD_CONV
VIEW - BIM_SUMV_SALES_CYCLE
VIEW - BIM_SUMV_SLIST_PERF

[top of page]

View: BIM_DIMV_OFFERS

[top of page]

APPS.BIM_DIMV_OFFERS references the following:

APPS
SYNONYM - AMS_ACT_OFFERS
PACKAGE - FND_GLOBAL
- FND_LOOKUPS
- QP_LIST_HEADERS_VL

APPS.BIM_DIMV_OFFERS is not referenced by any database object

[top of page]

View: BIM_DIMV_PROD_HIER

[top of page]

APPS.BIM_DIMV_PROD_HIER references the following:

APPS
SYNONYM - MTL_ITEM_CATEGORIES
- MTL_CATEGORIES

APPS.BIM_DIMV_PROD_HIER is not referenced by any database object

[top of page]

View: BIM_DIMV_PROD_LOV

[top of page]

APPS.BIM_DIMV_PROD_LOV references the following:

APPS
SYNONYM - AS_INTEREST_CODES_TL
SYNONYM - AS_INTEREST_TYPES_TL
SYNONYM - BIM_SALES_CATEGORY_HIER
PACKAGE - FND_GLOBAL
- FND_LOOKUPS
APPS.BIM_DIMV_PROD_LOV is referenced by following:

APPS
VIEW - BIM_SUMV_CAMP_MARGIN
VIEW - BIM_SUMV_CAMP_PERF
VIEW - BIM_SUMV_EVENT_PERF

[top of page]

View: BIM_DIMV_SALES_CHANNELS

[top of page]

APPS.BIM_DIMV_SALES_CHANNELS references the following:

APPS
PACKAGE - FND_GLOBAL
- OE_LOOKUPS
- FND_LOOKUPS
APPS.BIM_DIMV_SALES_CHANNELS is referenced by following:

APPS
VIEW - BIM_SUMV_CAMP_MARGIN
VIEW - BIM_SUMV_CAMP_PERF
VIEW - BIM_SUMV_EVENT_PERF
VIEW - BIM_SUMV_LEAD_CONV
VIEW - BIM_SUMV_SALES_CYCLE
VIEW - BIM_SUMV_SLIST_PERF

[top of page]

View: BIM_DIMV_SOURCE_CODES_V

[top of page]

APPS.BIM_DIMV_SOURCE_CODES_V references the following:

APPS
SYNONYM - AMS_ACT_OFFERS
SYNONYM - AMS_CAMPAIGNS_ALL_B
SYNONYM - AMS_CAMPAIGN_SCHEDULES
SYNONYM - AMS_EVENT_OFFERS_ALL_B
SYNONYM - AMS_SOURCE_CODES

APPS.BIM_DIMV_SOURCE_CODES_V is not referenced by any database object

[top of page]

View: BIM_DIMV_SOURCE_LISTS

[top of page]

APPS.BIM_DIMV_SOURCE_LISTS references the following:

APPS
SYNONYM - AMS_IMP_LIST_HEADERS_ALL
VIEW - AMS_USER_STATUSES_VL
PACKAGE - FND_GLOBAL
- FND_LOOKUPS
APPS.BIM_DIMV_SOURCE_LISTS is referenced by following:

APPS
VIEW - BIM_SUMV_CAMP_RESP
VIEW - BIM_SUMV_SLIST_PROFIT

[top of page]

View: BIM_DIMV_TARGET_SGMTS

[top of page]

APPS.BIM_DIMV_TARGET_SGMTS references the following:

APPS
SYNONYM - AMS_CELLS_ALL_B
SYNONYM - AMS_CELLS_ALL_TL
SYNONYM - BIM_I_SGMT_DENORM
APPS.BIM_DIMV_TARGET_SGMTS is referenced by following:

APPS
VIEW - BIM_SUMV_CAMP_RESP
VIEW - BIM_SUMV_SLIST_PERF

[top of page]

View: BIM_DIMV_USER_STATUSES

[top of page]

APPS.BIM_DIMV_USER_STATUSES references the following:

APPS
VIEW - AMS_USER_STATUSES_VL

APPS.BIM_DIMV_USER_STATUSES is not referenced by any database object

[top of page]

View: BIM_FCTV_LEADLINES

[top of page]

APPS.BIM_FCTV_LEADLINES references the following:

APPS
SYNONYM - AMS_PARTY_MARKET_SEGMENTS
SYNONYM - AS_SALES_LEADS
SYNONYM - AS_SALES_LEAD_LINES
SYNONYM - BIM_SOURCE_CODE_DETAILS
PACKAGE - BIM_TARGET_SEGMENT_PKG
SYNONYM - HZ_LOCATIONS

APPS.BIM_FCTV_LEADLINES is not referenced by any database object

[top of page]

View: BIM_FCTV_LEADS

[top of page]

APPS.BIM_FCTV_LEADS references the following:

APPS
SYNONYM - AMS_PARTY_MARKET_SEGMENTS
SYNONYM - AS_SALES_LEADS
SYNONYM - BIM_SOURCE_CODE_DETAILS
PACKAGE - BIM_TARGET_SEGMENT_PKG
SYNONYM - HZ_LOCATIONS

APPS.BIM_FCTV_LEADS is not referenced by any database object

[top of page]

View: BIM_FCTV_OPPLINES

[top of page]

APPS.BIM_FCTV_OPPLINES references the following:

APPS
SYNONYM - AMS_PARTY_MARKET_SEGMENTS
SYNONYM - AS_LEADS_ALL
SYNONYM - AS_LEAD_LINES_ALL
SYNONYM - BIM_SOURCE_CODE_DETAILS
PACKAGE - BIM_TARGET_SEGMENT_PKG
SYNONYM - HZ_LOCATIONS

APPS.BIM_FCTV_OPPLINES is not referenced by any database object

[top of page]

View: BIM_FCTV_OPPORTUNITIES

[top of page]

APPS.BIM_FCTV_OPPORTUNITIES references the following:

APPS
SYNONYM - AMS_PARTY_MARKET_SEGMENTS
SYNONYM - AS_LEADS_ALL
SYNONYM - BIM_SOURCE_CODE_DETAILS
PACKAGE - BIM_TARGET_SEGMENT_PKG
SYNONYM - HZ_LOCATIONS

APPS.BIM_FCTV_OPPORTUNITIES is not referenced by any database object

[top of page]

View: BIM_FCTV_OPPR_CYCLE

[top of page]

APPS.BIM_FCTV_OPPR_CYCLE references the following:

APPS
SYNONYM - AMS_PARTY_MARKET_SEGMENTS
VIEW - ASO_I_ORDER_HEADERS_V
SYNONYM - ASO_QUOTE_RELATED_OBJECTS
SYNONYM - AS_LEADS_ALL
SYNONYM - BIM_SOURCE_CODE_DETAILS
SYNONYM - HZ_LOCATIONS

APPS.BIM_FCTV_OPPR_CYCLE is not referenced by any database object

[top of page]

View: BIM_FCTV_ORDER_OFFERS

[top of page]

APPS.BIM_FCTV_ORDER_OFFERS references the following:

APPS
SYNONYM - AMS_ACT_OFFERS
VIEW - ASO_I_ORDER_LINES_V
VIEW - ASO_I_ORDER_PRICE_ADJS_V
PACKAGE - OE_PROFILE
PACKAGE - QP_PRICE_LIST_PVT

APPS.BIM_FCTV_ORDER_OFFERS is not referenced by any database object

[top of page]

View: BIM_FCTV_RESPONSES

[top of page]

APPS.BIM_FCTV_RESPONSES references the following:

APPS
SYNONYM - AMS_PARTY_MARKET_SEGMENTS
SYNONYM - AMS_PARTY_SOURCES
SYNONYM - BIM_SOURCE_CODE_DETAILS
PACKAGE - BIM_TARGET_SEGMENT_PKG
SYNONYM - HZ_LOCATIONS
SYNONYM - HZ_PARTY_SITES
SYNONYM - JTF_IH_ACTIVITIES
SYNONYM - JTF_IH_INTERACTIONS
SYNONYM - JTF_IH_RESULTS_B

APPS.BIM_FCTV_RESPONSES is not referenced by any database object

[top of page]

View: BIM_FCTV_SALES_CYCLE

[top of page]

APPS.BIM_FCTV_SALES_CYCLE references the following:

APPS
SYNONYM - AMS_PARTY_MARKET_SEGMENTS
VIEW - ASO_I_ORDER_HEADERS_V
SYNONYM - ASO_QUOTE_RELATED_OBJECTS
SYNONYM - AS_LEADS_ALL
SYNONYM - AS_SALES_LEADS
SYNONYM - AS_SALES_LEAD_OPPORTUNITY
SYNONYM - BIM_SOURCE_CODE_DETAILS
SYNONYM - HZ_LOCATIONS

APPS.BIM_FCTV_SALES_CYCLE is not referenced by any database object

[top of page]

View: BIM_FCTV_TARGETS

[top of page]

APPS.BIM_FCTV_TARGETS references the following:

APPS
SYNONYM - AMS_PARTY_MARKET_SEGMENTS
SYNONYM - AMS_PARTY_SOURCES
SYNONYM - BIM_SOURCE_CODE_DETAILS
PACKAGE - BIM_TARGET_SEGMENT_PKG
SYNONYM - HZ_LOCATIONS
SYNONYM - HZ_PARTY_SITES
SYNONYM - JTF_IH_ACTIVITIES
SYNONYM - JTF_IH_INTERACTIONS
SYNONYM - JTF_IH_MEDIA_ITEMS
SYNONYM - JTF_IH_OUTCOMES_B

APPS.BIM_FCTV_TARGETS is not referenced by any database object

[top of page]

View: BIM_SUMV_CAMP_COST

[top of page]

APPS.BIM_SUMV_CAMP_COST references the following:

APPS
SYNONYM - BIM_CMPGN_REVCOST_SUMM
VIEW - BIM_DIMV_MEDIA_CHANNELS
PACKAGE - FND_GLOBAL

APPS.BIM_SUMV_CAMP_COST is not referenced by any database object

[top of page]

View: BIM_SUMV_CAMP_MARGIN

[top of page]

APPS.BIM_SUMV_CAMP_MARGIN references the following:

APPS
SYNONYM - BIM_CMPGN_PERF_SUMM
VIEW - BIM_DIMV_MARKET_SGMTS
VIEW - BIM_DIMV_MEDIA_CHANNELS
VIEW - BIM_DIMV_PROD_LOV
VIEW - BIM_DIMV_SALES_CHANNELS
PACKAGE - FND_GLOBAL
- BIM_DIMV_OFFERS

APPS.BIM_SUMV_CAMP_MARGIN is not referenced by any database object

[top of page]

View: BIM_SUMV_CAMP_PERF

[top of page]

APPS.BIM_SUMV_CAMP_PERF references the following:

APPS
SYNONYM - BIM_CMPGN_PERF_SUMM
VIEW - BIM_DIMV_MARKET_SGMTS
VIEW - BIM_DIMV_MEDIA_CHANNELS
VIEW - BIM_DIMV_PROD_LOV
VIEW - BIM_DIMV_SALES_CHANNELS
PACKAGE - FND_GLOBAL

APPS.BIM_SUMV_CAMP_PERF is not referenced by any database object

[top of page]

View: BIM_SUMV_CAMP_RESP

[top of page]

APPS.BIM_SUMV_CAMP_RESP references the following:

APPS
SYNONYM - BIM_CMPGN_RESP_SUMM
VIEW - BIM_DIMV_MARKET_SGMTS
VIEW - BIM_DIMV_MEDIA_CHANNELS
VIEW - BIM_DIMV_SOURCE_LISTS
VIEW - BIM_DIMV_TARGET_SGMTS
PACKAGE - FND_GLOBAL

APPS.BIM_SUMV_CAMP_RESP is not referenced by any database object

[top of page]

View: BIM_SUMV_EVENT_PERF

[top of page]

APPS.BIM_SUMV_EVENT_PERF references the following:

APPS
VIEW - BIM_DIMV_EVENT_HIER
VIEW - BIM_DIMV_MARKET_SGMTS
VIEW - BIM_DIMV_PROD_LOV
VIEW - BIM_DIMV_SALES_CHANNELS
SYNONYM - BIM_EVENT_PERF_SUMM
PACKAGE - FND_GLOBAL

APPS.BIM_SUMV_EVENT_PERF is not referenced by any database object

[top of page]

View: BIM_SUMV_EVENT_REV

[top of page]

APPS.BIM_SUMV_EVENT_REV references the following:

APPS
VIEW - BIM_DIMV_EVENT_HIER
SYNONYM - BIM_EVENT_REVCOST_SUMM
PACKAGE - FND_GLOBAL

APPS.BIM_SUMV_EVENT_REV is not referenced by any database object

[top of page]

View: BIM_SUMV_EVENT_RSLTS

[top of page]

APPS.BIM_SUMV_EVENT_RSLTS references the following:

APPS
VIEW - BIM_DIMV_EVENT_HIER
SYNONYM - BIM_EVENT_RESP_SUMM
PACKAGE - FND_GLOBAL

APPS.BIM_SUMV_EVENT_RSLTS is not referenced by any database object

[top of page]

View: BIM_SUMV_LEAD_CONV

[top of page]

APPS.BIM_SUMV_LEAD_CONV references the following:

APPS
VIEW - BIM_DIMV_MARKET_SGMTS
VIEW - BIM_DIMV_MEDIA_CHANNELS
VIEW - BIM_DIMV_SALES_CHANNELS
SYNONYM - BIM_LEAD_CONV_SUMM
PACKAGE - FND_GLOBAL

APPS.BIM_SUMV_LEAD_CONV is not referenced by any database object

[top of page]

View: BIM_SUMV_SALES_CYCLE

[top of page]

APPS.BIM_SUMV_SALES_CYCLE references the following:

APPS
VIEW - BIM_DIMV_MARKET_SGMTS
VIEW - BIM_DIMV_MEDIA_CHANNELS
VIEW - BIM_DIMV_SALES_CHANNELS
SYNONYM - BIM_OPPR_CYCLE_SUMM
SYNONYM - BIM_SALES_CYCLE_SUMM
PACKAGE - FND_GLOBAL

APPS.BIM_SUMV_SALES_CYCLE is not referenced by any database object

[top of page]

View: BIM_SUMV_SLIST_PERF

[top of page]

APPS.BIM_SUMV_SLIST_PERF references the following:

APPS
VIEW - BIM_DIMV_MARKET_SGMTS
VIEW - BIM_DIMV_MEDIA_CHANNELS
VIEW - BIM_DIMV_SALES_CHANNELS
VIEW - BIM_DIMV_TARGET_SGMTS
SYNONYM - BIM_TRGT_SGMT_PERF_SUMM
PACKAGE - FND_GLOBAL

APPS.BIM_SUMV_SLIST_PERF is not referenced by any database object

[top of page]

View: BIM_SUMV_SLIST_PROFIT

[top of page]

APPS.BIM_SUMV_SLIST_PROFIT references the following:

APPS
VIEW - BIM_DIMV_SOURCE_LISTS
SYNONYM - BIM_SLIST_PROFIT_SUMM
PACKAGE - FND_GLOBAL

APPS.BIM_SUMV_SLIST_PROFIT is not referenced by any database object

[top of page]



Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract