V_QUERY_REVENUESOLICITORPOSITION

Revenue Solicitor position information.

Fields

Field	Field Type	Null	Description
REVENUESOLITORID	uniqueidentifier		REVENUESOLITORID
ID	uniqueidentifier		System record ID
DATEFROM	datetime		Date from
DATETO	datetime	yes	Date to
POSITIONNAME	nvarchar(50)		Position name
SITENAME	nvarchar(250)	yes	Site
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
SITEID	uniqueidentifier	yes	Site ID

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  2/1/2011 9:05:14 AM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=2.9.1001.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_REVENUESOLICITORPOSITION AS



                select 
                    RSOL.ID [REVENUESOLITORID],
                    [ORGANIZATIONPOSITIONHOLDER].ID,
                    [ORGANIZATIONPOSITIONHOLDER].DATEFROM,
                    [ORGANIZATIONPOSITIONHOLDER].DATETO,
                    [ORGANIZATIONPOSITION].NAME [POSITIONNAME],
                    [SITE].NAME [SITENAME],
                    [ADDEDBY].APPLICATIONNAME as [ADDEDBY_APPLICATION],
                    [ADDEDBY].USERNAME as [ADDEDBY_USERNAME],
                    [CHANGEDBY].APPLICATIONNAME as [CHANGEDBY_APPLICATION],
                    [CHANGEDBY].USERNAME as [CHANGEDBY_USERNAME],
                    [ORGANIZATIONPOSITIONHOLDER].DATEADDED,
                    [ORGANIZATIONPOSITIONHOLDER].DATECHANGED,
                    [ORGANIZATIONPOSITIONHOLDER].TSLONG,
                    [SITE].[ID] as SITEID
                from dbo.REVENUESOLICITOR RSOL
                inner join dbo.REVENUESPLIT SPLIT on SPLIT.ID = RSOL.REVENUESPLITID
                inner join dbo.REVENUE R on R.ID = SPLIT.REVENUEID
                inner join dbo.ORGANIZATIONPOSITIONHOLDER
                    on [ORGANIZATIONPOSITIONHOLDER].CONSTITUENTID = RSOL.CONSTITUENTID 
                            and R.DATE between [ORGANIZATIONPOSITIONHOLDER].DATEFROM and coalesce([ORGANIZATIONPOSITIONHOLDER].DATETO, R.DATE)
                inner join dbo.ORGANIZATIONPOSITION
                    on [ORGANIZATIONPOSITIONHOLDER].POSITIONID = [ORGANIZATIONPOSITION].ID
                left outer join dbo.SITE
                    on [ORGANIZATIONPOSITION].SITEID = SITE.ID
                left join dbo.CHANGEAGENT as [ADDEDBY] on [ADDEDBY].ID = [ORGANIZATIONPOSITIONHOLDER].ADDEDBYID
                left join dbo.CHANGEAGENT as [CHANGEDBY] on [CHANGEDBY].ID = [ORGANIZATIONPOSITIONHOLDER].CHANGEDBYID