V_QUERY_INCENTIVES
Query view used for incentives options of the faf event.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| EventID | uniqueidentifier | Event id | |
| NAME | nvarchar(100) | Name | |
| DESCRIPTION | nvarchar(1000) | Description | |
| MAXIMUMAMOUNT | money | Minimum to qualify for incentive | |
| TYPE | nvarchar(23) | yes | Type |
| ALLOWPARTICIPANTCHOOSEONEBENEFIT | int | Allow participant to choose one benefit | |
| ALLOWPARTICIPANTCHOOSEALLBENEFIT | int | Allow participant to receive all benefits | |
| ALLOWPARTICIPANTONLYRECEIVEBENEFITEACHLEVEL | int | Allow participant to receive benefits from each level | |
| ALLOWPARTICIPANTONLYRECEIVEBENEFITTOPLEVEL | int | Allow participant to only receive benefits from highest level | |
| ALLOWPARTICIPANTSWAIVEBENEFITS | bit | yes | Allow participant to waive benefits |
| 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:23 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_INCENTIVES AS
select FIL.ID
,FIL.EventID
,FIL.NAME
,FIL.DESCRIPTION
,FIL.MAXIMUMAMOUNT --Minimum to qualify for incentive
,FIL.TYPE
,(case when EA.ALLOWPARTICIPANTCHOOSEBENEFITCODE = 0 then 1 else 0 end) as ALLOWPARTICIPANTCHOOSEONEBENEFIT --Allow participant to choose one benefit
,(case when EA.ALLOWPARTICIPANTCHOOSEBENEFITCODE = 1 then 1 else 0 end) AS ALLOWPARTICIPANTCHOOSEALLBENEFIT --Allow participant to receive all benefits
,(case when EA.ALLOWPARTICIPANTONLYRECEIVEBENEFITLEVELCODE = 0 then 1 else 0 end)ALLOWPARTICIPANTONLYRECEIVEBENEFITEACHLEVEL--Allow participant to receive benefits from each level
,(case when EA.ALLOWPARTICIPANTONLYRECEIVEBENEFITLEVELCODE = 1 then 1 else 0 end)ALLOWPARTICIPANTONLYRECEIVEBENEFITTOPLEVEL--Allow participant to only receive benefits from highest level
,ALLOWPARTICIPANTSWAIVEBENEFITS--Allow participant to waive benefits
--system fields
,ADDEDBY.APPLICATIONNAME as [ADDEDBY_APPLICATION],
ADDEDBY.USERNAME as [ADDEDBY_USERNAME],
CHANGEDBY.APPLICATIONNAME as [CHANGEDBY_APPLICATION],
CHANGEDBY.USERNAME as [CHANGEDBY_USERNAME],
FIL.DATEADDED,
FIL.DATECHANGED,
FIL.TSLONG
from dbo.FAFINCENTIVELEVEL FIL
left join dbo.EVENTATTRIBUTES EA ON FIL.EVENTID=EA.EVENTID
left join dbo.CHANGEAGENT as [ADDEDBY] on [ADDEDBY].ID = FIL.ADDEDBYID
left join dbo.CHANGEAGENT as [CHANGEDBY] on [CHANGEDBY].ID = FIL.CHANGEDBYID