V_QUERY_VOLUNTEER
This provides the ability to query all volunteer fields.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| VOLUNTEER_TRANSLATION | nvarchar(154) | yes | Name |
| ISACTIVE | bit | yes | Active |
| SPONSORID_TRANSLATION | nvarchar(154) | yes | Sponsor |
| EMERGENCYCONTACTNAME | nvarchar(255) | yes | Emergency contact name |
| EMERGENCYCONTACTPHONE | nvarchar(100) | yes | Emergency contact phone |
| AVAILABILITYCOMMENT | nvarchar(4000) | yes | Availability comment |
| UNAVAILABLEFROM | datetime | yes | Unavailable from |
| UNAVAILABLETO | datetime | yes | Unavailable to |
| 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 | yes | Date added |
| DATECHANGED | datetime | yes | Date changed |
| TSLONG | bigint | yes | Timestamp value |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 11/11/2014 4:09:36 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.2.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_VOLUNTEER AS
select
CONSTITUENT.ID,
CONSTITUENT.NAME as [VOLUNTEER_TRANSLATION],
dbo.UFN_CONSTITUENT_ISVOLUNTEER(CONSTITUENT.ID) as ISACTIVE,
(select CONSTITUENT.NAME from dbo.CONSTITUENT where CONSTITUENT.ID = VOLUNTEER.SPONSORID) as [SPONSORID_TRANSLATION],
VOLUNTEER.EMERGENCYCONTACTNAME,
VOLUNTEER.EMERGENCYCONTACTPHONE,
VOLUNTEER.AVAILABILITYCOMMENT,
VOLUNTEER.UNAVAILABLEFROM,
VOLUNTEER.UNAVAILABLETO,
[ADDEDBY].APPLICATIONNAME as [ADDEDBY_APPLICATION],
[ADDEDBY].USERNAME as [ADDEDBY_USERNAME],
[CHANGEDBY].APPLICATIONNAME as [CHANGEDBY_APPLICATION],
[CHANGEDBY].USERNAME as [CHANGEDBY_USERNAME],
VOLUNTEER.DATEADDED,
VOLUNTEER.DATECHANGED,
VOLUNTEER.TSLONG
/*#EXTENSION*/
from dbo.CONSTITUENT
left join dbo.VOLUNTEER on CONSTITUENT.ID = VOLUNTEER.ID
left join dbo.CHANGEAGENT as [ADDEDBY] on [ADDEDBY].ID = VOLUNTEER.ADDEDBYID
left join dbo.CHANGEAGENT as [CHANGEDBY] on [CHANGEDBY].ID = VOLUNTEER.CHANGEDBYID
where
VOLUNTEER.ID is not null or
exists(select 1 from dbo.VOLUNTEERDATERANGE where VOLUNTEERDATERANGE.CONSTITUENTID = CONSTITUENT.ID)