V_QUERY_CONSTITUENTGROUP
Provides the ability to query constituent group fields.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| STARTDATE | datetime | yes | Group consolidation date |
| DESCRIPTION | nvarchar(300) | Description | |
| CANBEDONOR | bit | Can be donor | |
| INCLUDEMEMBERGIVING | bit | Includes member giving | |
| NAME | nvarchar(150) | Group type | |
| 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 | |
| GROUPTYPEDESCRIPTION | nvarchar(300) | Group type description | |
| GROUPTYPEID | uniqueidentifier | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 9/30/2015 1:01:47 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.153.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_CONSTITUENTGROUP AS
select
GD.ID,
GD.STARTDATE,
GD.DESCRIPTION,
GT.CANBEDONOR,
GT.INCLUDEMEMBERGIVING,
GT.NAME,
ADDEDBY.APPLICATIONNAME as ADDEDBY_APPLICATION,
ADDEDBY.USERNAME as ADDEDBY_USERNAME,
CHANGEDBY.APPLICATIONNAME as CHANGEDBY_APPLICATION,
CHANGEDBY.USERNAME as CHANGEDBY_USERNAME,
GD.DATEADDED,
GD.DATECHANGED,
GT.DESCRIPTION as GROUPTYPEDESCRIPTION,
[GD].[GROUPTYPEID]
from
dbo.GROUPDATA GD
inner join
dbo.GROUPTYPE GT on GD.GROUPTYPEID = GT.ID
left outer join
dbo.CHANGEAGENT as ADDEDBY on ADDEDBY.ID = GD.ADDEDBYID
left outer join
dbo.CHANGEAGENT as CHANGEDBY on CHANGEDBY.ID = GD.CHANGEDBYID