Table: BIM_EDW_LEADS_F

Product:	BIM - Marketing Intelligence
Description:	Lead fact table .
Implementation/DBA Data:	BIM.BIM_EDW_LEADS_F

Foreign Keys

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