v_FACT_EVENTPRICE
Contains information about event prices and registration options
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| EVENTPRICEFACTID | int | BBDW.[FACT_EVENTPRICE].[EVENTPRICEFACTID] | |
| EVENTPRICESYSTEMID | uniqueidentifier | yes | BBDW.[FACT_EVENTPRICE].[EVENTPRICESYSTEMID] |
| EVENTDIMID | int | yes | BBDW.[FACT_EVENTPRICE].[EVENTDIMID] |
| NAME | nvarchar(200) | yes | BBDW.[FACT_EVENTPRICE].[NAME] |
| RECEIPTAMOUNT | money | yes | BBDW.[FACT_EVENTPRICE].[RECEIPTAMOUNT] |
| COST | money | yes | BBDW.[FACT_EVENTPRICE].[COST] |
| REGISTRATIONCOUNT | int | yes | BBDW.[FACT_EVENTPRICE].[REGISTRATIONCOUNT] |
Definition
Copy
create view [BBDW].[v_FACT_EVENTPRICE] as
select
ep.[EVENTPRICEFACTID],
ep.[EVENTPRICESYSTEMID],
ep.[EVENTDIMID],
ep.[NAME],
ep.[RECEIPTAMOUNT],
ep.[COST],
ep.[REGISTRATIONCOUNT]
from BBDW.[FACT_EVENTPRICE] ep