V_QUERY_STAFFINGRESOURCE
Provides the ability to query staffing resources.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| NAME | nvarchar(50) | Name | |
| DESCRIPTION | nvarchar(255) | Description | |
| QUANTITY | int | Quantity | |
| CAPACITYPERRESOURCE | int | Capacity per resource | |
| SCREENPLAN | nvarchar(50) | yes | Screening plan |
| PRICINGSTRUCTURE | nvarchar(24) | yes | Pricing structure |
| PRICE | money | yes | Cost per resource |
| 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 |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 8/17/2011 2:35:49 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_STAFFINGRESOURCE AS
select
[VOLUNTEERTYPE].ID,
[VOLUNTEERTYPE].NAME,
[VOLUNTEERTYPE].[DESCRIPTION],
[VOLUNTEERTYPE].QUANTITY,
[VOLUNTEERTYPE].[CAPACITYPERRESOURCE],
[SCREENPLAN].NAME as SCREENPLAN,
[VOLUNTEERTYPEPRICING].[PRICINGSTRUCTURE],
[VOLUNTEERTYPEPRICING].[PRICE],
[ADDEDBY].APPLICATIONNAME as [ADDEDBY_APPLICATION],
[ADDEDBY].USERNAME as [ADDEDBY_USERNAME],
[CHANGEDBY].APPLICATIONNAME as [CHANGEDBY_APPLICATION],
[CHANGEDBY].USERNAME as [CHANGEDBY_USERNAME],
[VOLUNTEERTYPE].DATEADDED,
[VOLUNTEERTYPE].DATECHANGED,
[VOLUNTEERTYPE].TSLONG
/*EXTENSION*/
from
dbo.[VOLUNTEERTYPE]
left outer join
dbo.[VOLUNTEERTYPEPRICING] on [VOLUNTEERTYPE].ID = [VOLUNTEERTYPEPRICING].ID
left outer join
dbo.SCREENPLAN on [VOLUNTEERTYPE].SCREENPLANID = SCREENPLAN.ID
left outer join
dbo.CHANGEAGENT as [ADDEDBY] on [VOLUNTEERTYPE].ADDEDBYID = [ADDEDBY].ID
left outer join
dbo.CHANGEAGENT as [CHANGEDBY] on [VOLUNTEERTYPE].CHANGEDBYID = [CHANGEDBY].ID