V_QUERY_RE7_VOLUNTEERASSIGNMENT
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| LOCALID | int | ||
| DEPARTMENT | nvarchar(100) | yes | |
| LOCATION | nvarchar(100) | yes | |
| POSITION | nvarchar(50) | yes | |
| DATESTART | datetime | yes | |
| DATESTART_DATEID | int | yes | |
| TIMESTART | UDT_HOURMINUTE | yes | |
| DATEEND | datetime | yes | |
| DATEEND_DATEID | int | yes | |
| TIMEEND | UDT_HOURMINUTE | yes | |
| VOLUNTEER_LOCALID | int | ||
| JOB_LOCALID | int | ||
| CATEGORY | nvarchar(100) | yes | |
| TASK | nvarchar(100) | yes | |
| SUPERVISOR | nvarchar(50) | yes | |
| STATUS | varchar(9) | yes | |
| ONLINEJOB | bit | ||
| TYPE | nvarchar(100) | yes | |
| DAY | varchar(10) | ||
| LETTERSENT | bit | ||
| DATELETTERSENT | datetime | yes | |
| DATEREQUESTED | datetime | yes | |
| DATELETTERSENT_DATEID | int | yes | |
| DATEREQUESTED_DATEID | int | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 2/6/2025 8:50:38 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.3901.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_RE7_VOLUNTEERASSIGNMENT AS
select
[V].[LOCALID],
[D].[DESCRIPTION] [DEPARTMENT],
[L].[DESCRIPTION] [LOCATION],
[V].[POSITION],
[V].[DATESTART],
[V].[DATESTART_DATEID],
[V].[TIMESTART],
[V].[DATEEND],
[V].[DATEEND_DATEID],
[V].[TIMEEND],
[V].[VOLUNTEER_LOCALID],
[V].[JOB_LOCALID],
[C].[DESCRIPTION] [CATEGORY],
[T].[DESCRIPTION] [TASK],
[V].[SUPERVISOR],
case [V].[STATUS] when 1 then 'Assigned' when 2 then 'Requested' end [STATUS],
[V].[ONLINEJOB],
[VT].[DESCRIPTION] [TYPE],
case [V].[DAYCODE_LOCALID]
when 1 then 'Sundays'
when 2 then 'Mondays'
when 3 then 'Tuesdays'
when 4 then 'Wednesdays'
when 5 then 'Thursdays'
when 6 then 'Fridays'
when 7 then 'Saturdays'
when 8 then 'All Days'
when 9 then 'Weekdays'
when 10 then 'Weekends'
else '' end [DAY],
[V].[LETTERSENT],
[V].[DATELETTERSENT],
[V].[DATEREQUESTED],
[V].[DATELETTERSENT_DATEID],
[V].[DATEREQUESTED_DATEID]
from [dbo].[RE7_VOLUNTEERASSIGNMENT] [V]
left outer join [dbo].[RE7_DEPARTMENTCODE] [D] on [V].[DEPARTMENTCODE_LOCALID] = [D].[LOCALID]
left outer join [dbo].[RE7_LOCATIONCODE] [L] on [V].[LOCATIONCODE_LOCALID] = [L].[LOCALID]
left outer join [dbo].[RE7_VOLUNTEERJOBCATEGORYCODE] [C] on [V].[CATEGORYCODE_LOCALID] = [C].[LOCALID]
left outer join [dbo].[RE7_TASKCODE] [T] on [V].[TASKCODE_LOCALID] = [T].[LOCALID]
left outer join [dbo].[RE7_VOLUNTEERTYPECODE] [VT] on [V].[VOLUNTEERTYPECODE_LOCALID] = [VT].[LOCALID]