V_QUERY_EVENTAUCTION

Provides the ability to query information about auctions.

Fields

Field	Field Type	Null	Description
ID	uniqueidentifier		System record ID
MAINEVENTID	uniqueidentifier	yes	Main Event System ID
NAME	nvarchar(100)		Name
DESCRIPTION	nvarchar(255)		Description
STARTDATE	date		Start date
STARTTIME	UDT_HOURMINUTE		Start time
ENDDATE	date		End date
ENDTIME	UDT_HOURMINUTE		End time
CAPACITY	int		Capacity
EVENTLOCATIONID	uniqueidentifier	yes	Location system ID
EVENTLOCATIONCONTACTID	uniqueidentifier	yes	Location contact system ID
EVENTLOCATIONCONTACTNAME	nvarchar(154)	yes	Location contact name
ISACTIVE	bit		Active
ADDEDBY_APPLICATION	nvarchar(200)	yes	Added by application
ADDEDBY_USERNAME	nvarchar(128)	yes	Added by user name
CHANGEDBY_APPLICATION	nvarchar(200)	yes	Changed by application
CHANGEDBY_USERNAME	nvarchar(128)	yes	Changed by user name
DATEADDED	datetime		Date added
DATECHANGED	datetime		Date changed
TSLONG	bigint	yes	Timestamp value
SEATINGBASIS	varchar(27)	yes	Seating basis
SEATINGAVAILABLE	int	yes	Total seating available
SEATINGCAPACITY	int	yes	Total seating capacity
KPICONTEXTRECORDID	nvarchar(100)	yes	KPIs context record ID
CATEGORY	nvarchar(100)	yes	Category
PROGRAMID	uniqueidentifier	yes	Program system ID
EVENTLOCATIONROOMID	uniqueidentifier	yes	Room/Unit ID

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  8/17/2011 2:36:01 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_EVENTAUCTION AS



                select
                    EVENT.ID,
                    EVENT.MAINEVENTID,
                    EVENT.NAME,
                    EVENT.DESCRIPTION,
                    EVENT.STARTDATE,
                    EVENT.STARTTIME,
                    EVENT.ENDDATE,
                    EVENT.ENDTIME,
                    EVENT.CAPACITY,
                    EVENT.EVENTLOCATIONID,
                    EVENT.EVENTLOCATIONCONTACTID,
                    dbo.UFN_CONSTITUENT_BUILDNAME(EVENT.EVENTLOCATIONCONTACTID) [EVENTLOCATIONCONTACTNAME],
                    EVENT.ISACTIVE,
                    ADDEDBY.APPLICATIONNAME as ADDEDBY_APPLICATION,
                    ADDEDBY.USERNAME as ADDEDBY_USERNAME,
                    CHANGEDBY.APPLICATIONNAME as CHANGEDBY_APPLICATION,
                    CHANGEDBY.USERNAME as CHANGEDBY_USERNAME,
                    EVENT.DATEADDED,
                    EVENT.DATECHANGED,
                    EVENT.TSLONG,
                    case
                        when SEATING.SUBSECTIONTYPECODE = 0 then 'Sections, Tables, and Seats'
                        when SEATING.SUBSECTIONTYPECODE = 1 then 'Sections, Rows, and Seats'
                        when SEATING.SUBSECTIONTYPECODE = 2 then 'Sections and Seats'
                    end [SEATINGBASIS],
                    dbo.UFN_EVENTSEATING_GETSEATAVAILABLE(EVENT.ID) [SEATINGAVAILABLE],
                    dbo.UFN_EVENTSEATING_GETSEATCAPACITY(EVENT.ID) [SEATINGCAPACITY],
                    cast(EVENT.ID as nvarchar(100)) as [KPICONTEXTRECORDID],
                    (SELECT DESCRIPTION FROM dbo.EVENTCATEGORYCODE WHERE ID=EVENT.EVENTCATEGORYCODEID) as [CATEGORY],
                    EVENT.PROGRAMID,
                    EVENT.EVENTLOCATIONROOMID

                    /*#EXTENSION*/

                from
                    dbo.EVENT
                    inner join dbo.EVENTAUCTION on EVENT.ID = EVENTAUCTION.ID
                    left join dbo.EVENTSEATING as SEATING on SEATING.ID = EVENT.ID
                    left join dbo.CHANGEAGENT as ADDEDBY ON ADDEDBY.ID = EVENT.ADDEDBYID
                    left join dbo.CHANGEAGENT as CHANGEDBY ON CHANGEDBY.ID = EVENT.CHANGEDBYID
                where
                    EVENT.PROGRAMID is null