VIEW: BIM.BIM_EDW_INTRCTNS_F#

Source

View Text - Preformatted

select INTERACTION_PK_KEY INTERACTION_PK_KEY, INTERACTION_PK INTERACTION_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, INTRCTN_MEDIA_FK_KEY INTRCTN_MEDIA_FK_KEY, INTRCTN_OUTCOME_FK_KEY INTRCTN_OUTCOME_FK_KEY, INTRCTN_REASON_FK_KEY INTRCTN_REASON_FK_KEY, INTRCTN_RESULT_FK_KEY INTRCTN_RESULT_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, 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, ACTIVITY_ID ACTIVITY_ID, INTERACTION_ID INTERACTION_ID, ACTIVITY_DURATION ACTIVITY_DURATION, ACTIVITY_START_TIME ACTIVITY_START_TIME, ACTIVITY_END_TIME ACTIVITY_END_TIME, SOURCE_CODE SOURCE_CODE, 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_INTRCTNS_F"

View Text - HTML Formatted

SELECT INTERACTION_PK_KEY INTERACTION_PK_KEY
, INTERACTION_PK INTERACTION_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
, INTRCTN_MEDIA_FK_KEY INTRCTN_MEDIA_FK_KEY
, INTRCTN_OUTCOME_FK_KEY INTRCTN_OUTCOME_FK_KEY
, INTRCTN_REASON_FK_KEY INTRCTN_REASON_FK_KEY
, INTRCTN_RESULT_FK_KEY INTRCTN_RESULT_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
, 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
, ACTIVITY_ID ACTIVITY_ID
, INTERACTION_ID INTERACTION_ID
, ACTIVITY_DURATION ACTIVITY_DURATION
, ACTIVITY_START_TIME ACTIVITY_START_TIME
, ACTIVITY_END_TIME ACTIVITY_END_TIME
, SOURCE_CODE SOURCE_CODE
, 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_INTRCTNS_F"