V_QUERY_COMBINATIONAVAILABILITY

Provides the ability to query COMBINATION availabilities.

Fields

Field	Field Type	Null	Description
ID	uniqueidentifier		System record ID
COMBINATIONID	uniqueidentifier		COMBINATION system ID
ALLOWMONDAY	bit		Offered Monday
ALLOWTUESDAY	bit		Offered Tuesday
ALLOWWEDNESDAY	bit		Offered Wednesday
ALLOWTHURSDAY	bit		Offered Thursday
ALLOWFRIDAY	bit		Offered Friday
ALLOWSATURDAY	bit		Offered Saturday
ALLOWSUNDAY	bit		Offered Sunday
ALLOWCOMBINATIONDATEFROM	datetime	yes	Start date
ALLOWCOMBINATIONDATETO	datetime	yes	End date
ALLOWCOMBINATIONTIMEFROM	UDT_HOURMINUTE		Start time
ALLOWCOMBINATIONTIMETO	UDT_HOURMINUTE		End time
SEQUENCE	int		Sequence
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

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_COMBINATIONAVAILABILITY AS



                select
                    [COMBINATIONAVAILABILITY].[ID],
                    [COMBINATIONAVAILABILITY].[COMBINATIONID],
                    [COMBINATIONAVAILABILITY].[ALLOWMONDAY],
                    [COMBINATIONAVAILABILITY].[ALLOWTUESDAY],
                    [COMBINATIONAVAILABILITY].[ALLOWWEDNESDAY],
                    [COMBINATIONAVAILABILITY].[ALLOWTHURSDAY],
                    [COMBINATIONAVAILABILITY].[ALLOWFRIDAY],
                    [COMBINATIONAVAILABILITY].[ALLOWSATURDAY],
                    [COMBINATIONAVAILABILITY].[ALLOWSUNDAY],
                    [COMBINATIONAVAILABILITY].[ALLOWCOMBINATIONDATEFROM],
                    [COMBINATIONAVAILABILITY].[ALLOWCOMBINATIONDATETO],
                    [COMBINATIONAVAILABILITY].[ALLOWCOMBINATIONTIMEFROM],
                    [COMBINATIONAVAILABILITY].[ALLOWCOMBINATIONTIMETO],
                    [COMBINATIONAVAILABILITY].[SEQUENCE],
                    [ADDEDBY].[APPLICATIONNAME] as [ADDEDBY_APPLICATION],
                    [ADDEDBY].[USERNAME] as [ADDEDBY_USERNAME],
                    [CHANGEDBY].[APPLICATIONNAME] as [CHANGEDBY_APPLICATION],
                    [CHANGEDBY].[USERNAME] as [CHANGEDBY_USERNAME],
                    [COMBINATIONAVAILABILITY].[DATEADDED],
                    [COMBINATIONAVAILABILITY].[DATECHANGED],
                    [COMBINATIONAVAILABILITY].[TSLONG] 
                /*EXTENSION*/
                from dbo.[COMBINATIONAVAILABILITY]
                left join dbo.[CHANGEAGENT] as [ADDEDBY] 
                        on [COMBINATIONAVAILABILITY].[ADDEDBYID] = [ADDEDBY].ID
                left join dbo.[CHANGEAGENT] as [CHANGEDBY] 
                    on [COMBINATIONAVAILABILITY].[CHANGEDBYID] = [CHANGEDBY].ID