V_QUERY_TRACKITEM

Provides the ability query track item information.

Fields

Field	Field Type	Null	Description
ID	uniqueidentifier		System record ID
TRACKID	uniqueidentifier		TRACKID
NAME	nvarchar(100)		Name
TYPE	nvarchar(23)	yes	Type
STARTDAY	int	yes	Start day
STARTTIME	UDT_HOURMINUTE		Start time
ENDDAY	int	yes	End day
ENDTIME	UDT_HOURMINUTE		End time
PROGRAMID	uniqueidentifier	yes	PROGRAMID
EVENTLOCATIONID	uniqueidentifier	yes	EVENTLOCATIONID
BLOCKEVENT	bit		Mark unavailable
NOTES	nvarchar(500)		Notes
ADDEDBY_APPLICATION	nvarchar(200)		Added by application
ADDEDBY_USERNAME	nvarchar(128)		Added by user name
CHANGEDBY_APPLICATION	nvarchar(200)		Changed by application
CHANGEDBY_USERNAME	nvarchar(128)		Changed by user name
DATEADDED	datetime		Date added
DATECHANGED	datetime		Date changed
TSLONG	bigint	yes	Timestamp value

Definition

Copy

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



                select
                    TRACKITEM.ID,
                    TRACKITEM.TRACKID,
                    TRACKITEM.NAME,
                    TRACKITEM.TYPE,
                    TRACKITEM.STARTDAY + 1 as [STARTDAY],
                    TRACKITEM.STARTTIME,
                    TRACKITEM.ENDDAY + 1 as [ENDDAY],
                    TRACKITEM.ENDTIME,
                    TRACKITEM.PROGRAMID,
                    TRACKITEM.EVENTLOCATIONID,
                    TRACKITEM.BLOCKEVENT,
                    TRACKITEM.NOTES,
                    isnull([ADDEDBY].APPLICATIONNAME, '') as [ADDEDBY_APPLICATION],
                    isnull([ADDEDBY].USERNAME, '') as [ADDEDBY_USERNAME],
                    isnull([CHANGEDBY].APPLICATIONNAME, '') as [CHANGEDBY_APPLICATION],
                    isnull([CHANGEDBY].USERNAME, '') as [CHANGEDBY_USERNAME],
                    TRACKITEM.DATEADDED,
                    TRACKITEM.DATECHANGED,
                    TRACKITEM.TSLONG

                    /*#EXTENSION*/

                from
                    dbo.TRACKITEM
                left outer join
                    dbo.CHANGEAGENT as [ADDEDBY] on [ADDEDBY].ID = TRACKITEM.ADDEDBYID
                left outer join
                    dbo.CHANGEAGENT as [CHANGEDBY] on [CHANGEDBY].ID = TRACKITEM.CHANGEDBYID