VIEW: BIM.BIM_EDW_EVTFRCST_F#

Source

View Text - Preformatted

select EVTFRCST_PK_KEY EVTFRCST_PK_KEY, EVTFRCST_PK EVTFRCST_PK, CMPGN_FK_KEY CMPGN_FK_KEY, CMPGN_STATUS_FK_KEY CMPGN_STATUS_FK_KEY, EVENT_FK_KEY EVENT_FK_KEY, MDCHNL_FK_KEY MDCHNL_FK_KEY, MKTSGMT_FK_KEY MKTSGMT_FK_KEY, TGTSGMT_FK_KEY TGTSGMT_FK_KEY, SRCLST_FK_KEY SRCLST_FK_KEY, OFFER_FK_KEY OFFER_FK_KEY, CUSTOMER_FK_KEY CUSTOMER_FK_KEY, TIME_FK_KEY TIME_FK_KEY, ORG_FK_KEY ORG_FK_KEY, ITEM_FK_KEY ITEM_FK_KEY, UOM_FK_KEY UOM_FK_KEY, SLSCHNL_FK_KEY SLSCHNL_FK_KEY, BASE_CURRENCY_FK_KEY BASE_CURRENCY_FK_KEY, GLOBAL_CURRENCY_FK_KEY GLOBAL_CURRENCY_FK_KEY, TRX_CURRENCY_FK_KEY TRX_CURRENCY_FK_KEY, BILL_TO_SITE_FK_KEY BILL_TO_SITE_FK_KEY, SHIP_TO_SITE_FK_KEY SHIP_TO_SITE_FK_KEY, INSTANCE_FK_KEY INSTANCE_FK_KEY, EVENT_ACTUAL_COST_G EVENT_ACTUAL_COST_G, EVENT_ACTUAL_COST_B EVENT_ACTUAL_COST_B, EVENT_ACTUAL_COST_T EVENT_ACTUAL_COST_T, EVENT_FRCST_COST_G EVENT_FRCST_COST_G, EVENT_FRCST_COST_B EVENT_FRCST_COST_B, EVENT_FRCST_COST_T EVENT_FRCST_COST_T, EVENT_FRCST_REVENUE_G EVENT_FRCST_REVENUE_G, EVENT_FRCST_REVENUE_B EVENT_FRCST_REVENUE_B, EVENT_FRCST_REVENUE_T EVENT_FRCST_REVENUE_T, EVENT_NUMBER_CANCELLED EVENT_NUMBER_CANCELLED, EVENT_NUMBER_ATTENDED EVENT_NUMBER_ATTENDED, EVENT_NUMBER_AVAILABLE EVENT_NUMBER_AVAILABLE, EVENT_NUMBER_ENROLLED EVENT_NUMBER_ENROLLED, USER_MEASURE1 USER_MEASURE1, USER_MEASURE2 USER_MEASURE2, USER_MEASURE3 USER_MEASURE3, USER_MEASURE4 USER_MEASURE4, USER_MEASURE5 USER_MEASURE5, USER_FK1_KEY USER_FK1_KEY, USER_FK2_KEY USER_FK2_KEY, USER_FK3_KEY USER_FK3_KEY, USER_FK4_KEY USER_FK4_KEY, USER_FK5_KEY USER_FK5_KEY, USER_ATTRIBUTE1 USER_ATTRIBUTE1, USER_ATTRIBUTE2 USER_ATTRIBUTE2, USER_ATTRIBUTE3 USER_ATTRIBUTE3, USER_ATTRIBUTE4 USER_ATTRIBUTE4, USER_ATTRIBUTE5 USER_ATTRIBUTE5, USER_ATTRIBUTE6 USER_ATTRIBUTE6, USER_ATTRIBUTE7 USER_ATTRIBUTE7, USER_ATTRIBUTE8 USER_ATTRIBUTE8, USER_ATTRIBUTE9 USER_ATTRIBUTE9, USER_ATTRIBUTE10 USER_ATTRIBUTE10, USER_ATTRIBUTE11 USER_ATTRIBUTE11, USER_ATTRIBUTE12 USER_ATTRIBUTE12, USER_ATTRIBUTE13 USER_ATTRIBUTE13, USER_ATTRIBUTE14 USER_ATTRIBUTE14, USER_ATTRIBUTE15 USER_ATTRIBUTE15, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, SECURITY_GROUP_ID SECURITY_GROUP_ID from "BIM"."BIM_EDW_EVTFRCST_F"

View Text - HTML Formatted

SELECT EVTFRCST_PK_KEY EVTFRCST_PK_KEY
, EVTFRCST_PK EVTFRCST_PK
, CMPGN_FK_KEY CMPGN_FK_KEY
, CMPGN_STATUS_FK_KEY CMPGN_STATUS_FK_KEY
, EVENT_FK_KEY EVENT_FK_KEY
, MDCHNL_FK_KEY MDCHNL_FK_KEY
, MKTSGMT_FK_KEY MKTSGMT_FK_KEY
, TGTSGMT_FK_KEY TGTSGMT_FK_KEY
, SRCLST_FK_KEY SRCLST_FK_KEY
, OFFER_FK_KEY OFFER_FK_KEY
, CUSTOMER_FK_KEY CUSTOMER_FK_KEY
, TIME_FK_KEY TIME_FK_KEY
, ORG_FK_KEY ORG_FK_KEY
, ITEM_FK_KEY ITEM_FK_KEY
, UOM_FK_KEY UOM_FK_KEY
, SLSCHNL_FK_KEY SLSCHNL_FK_KEY
, BASE_CURRENCY_FK_KEY BASE_CURRENCY_FK_KEY
, GLOBAL_CURRENCY_FK_KEY GLOBAL_CURRENCY_FK_KEY
, TRX_CURRENCY_FK_KEY TRX_CURRENCY_FK_KEY
, BILL_TO_SITE_FK_KEY BILL_TO_SITE_FK_KEY
, SHIP_TO_SITE_FK_KEY SHIP_TO_SITE_FK_KEY
, INSTANCE_FK_KEY INSTANCE_FK_KEY
, EVENT_ACTUAL_COST_G EVENT_ACTUAL_COST_G
, EVENT_ACTUAL_COST_B EVENT_ACTUAL_COST_B
, EVENT_ACTUAL_COST_T EVENT_ACTUAL_COST_T
, EVENT_FRCST_COST_G EVENT_FRCST_COST_G
, EVENT_FRCST_COST_B EVENT_FRCST_COST_B
, EVENT_FRCST_COST_T EVENT_FRCST_COST_T
, EVENT_FRCST_REVENUE_G EVENT_FRCST_REVENUE_G
, EVENT_FRCST_REVENUE_B EVENT_FRCST_REVENUE_B
, EVENT_FRCST_REVENUE_T EVENT_FRCST_REVENUE_T
, EVENT_NUMBER_CANCELLED EVENT_NUMBER_CANCELLED
, EVENT_NUMBER_ATTENDED EVENT_NUMBER_ATTENDED
, EVENT_NUMBER_AVAILABLE EVENT_NUMBER_AVAILABLE
, EVENT_NUMBER_ENROLLED EVENT_NUMBER_ENROLLED
, USER_MEASURE1 USER_MEASURE1
, USER_MEASURE2 USER_MEASURE2
, USER_MEASURE3 USER_MEASURE3
, USER_MEASURE4 USER_MEASURE4
, USER_MEASURE5 USER_MEASURE5
, USER_FK1_KEY USER_FK1_KEY
, USER_FK2_KEY USER_FK2_KEY
, USER_FK3_KEY USER_FK3_KEY
, USER_FK4_KEY USER_FK4_KEY
, USER_FK5_KEY USER_FK5_KEY
, USER_ATTRIBUTE1 USER_ATTRIBUTE1
, USER_ATTRIBUTE2 USER_ATTRIBUTE2
, USER_ATTRIBUTE3 USER_ATTRIBUTE3
, USER_ATTRIBUTE4 USER_ATTRIBUTE4
, USER_ATTRIBUTE5 USER_ATTRIBUTE5
, USER_ATTRIBUTE6 USER_ATTRIBUTE6
, USER_ATTRIBUTE7 USER_ATTRIBUTE7
, USER_ATTRIBUTE8 USER_ATTRIBUTE8
, USER_ATTRIBUTE9 USER_ATTRIBUTE9
, USER_ATTRIBUTE10 USER_ATTRIBUTE10
, USER_ATTRIBUTE11 USER_ATTRIBUTE11
, USER_ATTRIBUTE12 USER_ATTRIBUTE12
, USER_ATTRIBUTE13 USER_ATTRIBUTE13
, USER_ATTRIBUTE14 USER_ATTRIBUTE14
, USER_ATTRIBUTE15 USER_ATTRIBUTE15
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, SECURITY_GROUP_ID SECURITY_GROUP_ID
FROM "BIM"."BIM_EDW_EVTFRCST_F"