[Home] [Help]
View: BIM_SUMV_EVENT_RSLTS
Product: | BIM - Marketing Intelligence |
Description: | Joins the summary table to the dimension views. |
Implementation/DBA Data: |
APPS.BIM_SUMV_EVENT_RSLTS
|
View Text
SELECT BER.EVENT_ID EVENT_ID
, BER.EVENT_OFFERING_ID EVENT_OFFERING_ID
, BEH.EVENT_NAME EVENT_NAME
, BEH.EVENT_OFFER_NAME EVENT_OFFERING_NAME
, BEH.EVENT_TYPE_CODE EVENT_TYPE
, BER.PERIOD_NAME PERIOD_NAME
, BER.PERIOD_START_DATE START_DATE
, BER.PERIOD_END_DATE END_DATE
, BER.NUM_AVAILABLE NUM_AVAILABLE
, BER.NUM_TARGETED NUM_TARGETED
, BER.NUM_RESPONDED NUM_RESPONDED
, BER.NUM_ENROLLED NUM_ENROLLED
, BER.NUM_ATTENDED NUM_ATTENDED
, BER.NUM_CANCELLED NUM_CANCELLED
FROM BIM_EVENT_RESP_SUMM BER
, BIM_DIMV_EVENT_HIER BEH
WHERE BER.EVENT_OFFERING_ID = BEH.EVENT_OFFER_ID WITH READ ONLY
Columns
Name |
EVENT_ID |
EVENT_OFFERING_ID |
EVENT_NAME |
EVENT_OFFERING_NAME |
EVENT_TYPE |
PERIOD_NAME |
START_DATE |
END_DATE |
NUM_AVAILABLE |
NUM_TARGETED |
NUM_RESPONDED |
NUM_ENROLLED |
NUM_ATTENDED |
NUM_CANCELLED |