V_QUERY_RESERVATIONRATESCALEAPPLICATION

Provides the ability to query reservation rate scale application information.

Fields

Field	Field Type	Null	Description
ID	uniqueidentifier		System record ID
RESERVATIONRATESCALEID	uniqueidentifier		RESERVATIONRATESCALEID
TYPE	nvarchar(25)	yes	Item type
AMOUNT	money		Amount
PROGRAMID	uniqueidentifier	yes	PROGRAMID
FEEID	uniqueidentifier	yes	FEEID
RESOURCEID	uniqueidentifier	yes	RESOURCEID
VOLUNTEERTYPEID	uniqueidentifier	yes	VOLUNTEERTYPEID
ISADDEDMANUALLY	bit		Is added automatically
ISADDEDAUTOMATICALLY	bit		Is added manually
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:56 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_RESERVATIONRATESCALEAPPLICATION AS



                select
                    RESERVATIONRATESCALEAPPLICATION.ID,
                    RESERVATIONRATESCALEAPPLICATION.RESERVATIONRATESCALEID,
                    RESERVATIONRATESCALEAPPLICATION.TYPE,
                    RESERVATIONRATESCALEAPPLICATION.AMOUNT,
                    RESERVATIONRATESCALEAPPLICATION.PROGRAMID,
                    RESERVATIONRATESCALEAPPLICATION.FEEID,
                    RESERVATIONRATESCALEAPPLICATION.RESOURCEID,
                    RESERVATIONRATESCALEAPPLICATION.VOLUNTEERTYPEID,
                    RESERVATIONRATESCALEAPPLICATION.ISADDEDMANUALLY,
                    RESERVATIONRATESCALEAPPLICATION.ISADDEDAUTOMATICALLY,
                    isnull([ADDEDBY].APPLICATIONNAME, '') as [ADDEDBY_APPLICATION],
                    isnull([ADDEDBY].USERNAME, '') as [ADDEDBY_USERNAME],
                    isnull([CHANGEDBY].APPLICATIONNAME, '') as [CHANGEDBY_APPLICATION],
                    isnull([CHANGEDBY].USERNAME, '') as [CHANGEDBY_USERNAME],
                    RESERVATIONRATESCALEAPPLICATION.DATEADDED,
                    RESERVATIONRATESCALEAPPLICATION.DATECHANGED,
                    RESERVATIONRATESCALEAPPLICATION.TSLONG

                    /*#EXTENSION*/

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