V_QUERY_EXCHANGECALENDARITEMBATCHCONTROLREPORT

View used for output of the Exchange calendar item batch control report.

Fields

Field	Field Type	Null	Description
ID	uniqueidentifier		System record ID
CONSTITUENTID	uniqueidentifier		CONSTITUENTID
CONSTITUENTNAME	nvarchar(154)	yes	Constituent name
KEYNAME	nvarchar(100)		Key name
FIRSTNAME	nvarchar(50)		First name
MIDDLENAME	nvarchar(50)		Middle name
RECORDTYPE	varchar(23)		Record type
OBJECTIVE	nvarchar(100)		Objective
TYPE	nvarchar(100)	yes	Type
EXPECTEDDATE	varchar(30)	yes	Date

Definition

Copy

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



                select distinct
                    INTERACTION.ID,
                    CONSTITUENT.ID as CONSTITUENTID,
                    dbo.UFN_CONSTITUENT_BUILDNAME(CONSTITUENT.ID) as CONSTITUENTNAME,
                    CONSTITUENT.KEYNAME,
                    CONSTITUENT.FIRSTNAME,
                    CONSTITUENT.MIDDLENAME, 
                    case
                        when INTERACTION.PROSPECTPLANID is null then 'Constituent interaction'
                        else 'Prospect plan step'
                    end as RECORDTYPE,
                    INTERACTION.OBJECTIVE, 
                    dbo.UFN_INTERACTIONTYPECODE_GETDESCRIPTION(INTERACTION.INTERACTIONTYPECODEID) as TYPE,
                    convert(varchar, INTERACTION.EXPECTEDDATE, 101) as EXPECTEDDATE
                from
                    dbo.CONSTITUENT 
                inner join dbo.INTERACTION 
                    on CONSTITUENT.ID = INTERACTION.CONSTITUENTID

                union all

                select distinct
                    STEP.ID,                            
                    CONSTITUENT.ID as CONSTITUENTID,
                    dbo.UFN_CONSTITUENT_BUILDNAME(CONSTITUENT.ID) as CONSTITUENTNAME,
                    CONSTITUENT.KEYNAME,
                    CONSTITUENT.FIRSTNAME,
                    CONSTITUENT.MIDDLENAME,   
                    'Stewardship plan step' as RECORDTYPE,
                    STEP.OBJECTIVE, 
                    dbo.UFN_INTERACTIONTYPECODE_GETDESCRIPTION(STEP.CONTACTMETHODCODEID) as TYPE,
                    convert(varchar, STEP.TARGETDATE, 101) as EXPECTEDDATE
                from
                    dbo.CONSTITUENT
                inner join dbo.STEWARDSHIPPLAN
                    on STEWARDSHIPPLAN.CONSTITUENTID = CONSTITUENT.ID
                inner join dbo.STEWARDSHIPPLANSTEP STEP
                    on STEP.PLANID = STEWARDSHIPPLAN.ID