V_QUERY_SPONSORSHIPOPTIONS
Query view used for goals of the faf event.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| EVENTID | uniqueidentifier | Event id | |
| NAME | nvarchar(50) | Name | |
| DESCRIPTION | nvarchar(1000) | Description | |
| ISNOTAVAILABLEONLINEREG | bit | Not available online | |
| AMOUNT | money | Amount | |
| TAXDEDUCTIBLEAMOUNT | money | Tax deductable amount | |
| EARLYREGISTRATIONDATE | datetime | yes | Early discount date |
| EARLYREGISTRATIONDISCOUNT | money | Early discount amount | |
| LATEFEEDATE | datetime | yes | Late fee date |
| LATEFEEAMOUNT | money | Late fee amount | |
| ALLOWSPONSORWAIVEBENEFITS | bit | Allow sponsor to waive benefit | |
| NUMBERAVAILABLE | int | Number available | |
| 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: 11/30/2010 11:19:44 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.8.2022.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_SPONSORSHIPOPTIONS AS
select EST.ID
,EST.EVENTID
,EST.NAME
,EST.DESCRIPTION
,EST.ISNOTAVAILABLEONLINEREG --Not available online
,EST.FEESAMOUNT AMOUNT
,EST.TAXDEDUCTIBLEAMOUNT --Tax deductable amount
,EST.EARLYREGISTRATIONDATE --Early discount date
,EST.EARLYREGISTRATIONDISCOUNT --Early discount amount
,EST.LATEFEEDATE --Late fee date
,EST.LATEFEE LATEFEEAMOUNT --Late fee amount
,isnull(EST.ALLOWSPONSORWAIVEBENEFITS,0) ALLOWSPONSORWAIVEBENEFITS --Allow sponsor to waive benefit
,EST.NUMBERAVAILABLE --Number available
--system fields
,ADDEDBY.APPLICATIONNAME as [ADDEDBY_APPLICATION],
ADDEDBY.USERNAME as [ADDEDBY_USERNAME],
CHANGEDBY.APPLICATIONNAME as [CHANGEDBY_APPLICATION],
CHANGEDBY.USERNAME as [CHANGEDBY_USERNAME],
EST.DATEADDED,
EST.DATECHANGED,
EST.TSLONG
from dbo.EVENTSPONSORSHIPTYPE EST
left join dbo.CHANGEAGENT as [ADDEDBY] on [ADDEDBY].ID = EST.ADDEDBYID
left join dbo.CHANGEAGENT as [CHANGEDBY] on [CHANGEDBY].ID = EST.CHANGEDBYID