V_QUERY_MEMBERSHIPPROGRAM
Query view used for membership program information.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| NAME | nvarchar(100) | Name | |
| DESCRIPTION | nvarchar(255) | Description | |
| SITE | nvarchar(250) | yes | Site |
| ISACTIVE | bit | Active | |
| ALLOWMULTIPLEMEMBERSHIPS | bit | Allow multiple memberships | |
| EXPIRESON | nvarchar(20) | yes | Expires on |
| CUTOFFDAY | tinyint | Cutoff day | |
| CUTOFFDATEFORYEAR | UDT_MONTHDAY | Cutoff date for year | |
| CARDFORMAT | nvarchar(255) | yes | Card format |
| 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 |
| BASECURRENCYID | uniqueidentifier | yes | Base currency ID |
| ALLOWADDONADULT | bit | Allow additional members | |
| ADDONADULTPRICE | money | Additional member price | |
| ALLOWADDONGUEST | bit | Allow guests | |
| ADDONGUESTPRICE | money | Guest price | |
| ORGANIZATIONEXCHANGERATEID | uniqueidentifier | yes | Currency exchange rate |
| ORGANIZATIONADDONADULTPRICE | money | Additional member price (organization currency) | |
| ORGANIZATIONADDONGUESTPRICE | money | Guest price (organization currency) | |
| SITEID | uniqueidentifier | yes | Site ID |
| PROGRAMTYPE | nvarchar(20) | yes | |
| PROGRAMBASEDON | nvarchar(19) | yes | |
| CATEGORY | nvarchar(27) | yes | |
| DEDUCTIBILITY | nvarchar(43) | yes | |
| RENEWALWINDOWSTARTTYPE | nvarchar(28) | yes | |
| RENEWALWINDOWSTARTTIME | nvarchar(2) | yes | |
| RENEWALWINDOWSTARTINTERVAL | nvarchar(6) | yes | |
| DUESTREATEDASCONTRIBUTION | bit | ||
| MULTIPLEPAYMENTSEACHTERM | bit | ||
| INSTALLMENTPOSTSTATUS | nvarchar(11) | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 11/11/2014 4:27:37 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.2.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_MEMBERSHIPPROGRAM AS
select
MP.ID,
MP.NAME,
MP.DESCRIPTION,
SITE.NAME as SITE,
MP.ISACTIVE,
MP.ALLOWMULTIPLEMEMBERSHIPS,
MP.EXPIRESON,
MP.CUTOFFDAY,
MP.CUTOFFDATEFORYEAR,
dbo.UFN_GETMEMBERSHIPCARDFORMATINUSE(MP.ID) as CARDFORMAT,
ADDEDBY.APPLICATIONNAME as ADDEDBY_APPLICATION,
ADDEDBY.USERNAME as ADDEDBY_USERNAME,
CHANGEDBY.APPLICATIONNAME as CHANGEDBY_APPLICATION,
CHANGEDBY.USERNAME as CHANGEDBY_USERNAME,
MP.DATEADDED,
MP.DATECHANGED,
MP.TSLONG,
MP.BASECURRENCYID,
MP.ALLOWADDONADULT,
MP.ADDONADULTPRICE,
MP.ALLOWADDONGUEST,
MP.ADDONGUESTPRICE,
MP.ORGANIZATIONEXCHANGERATEID,
MP.ORGANIZATIONADDONADULTPRICE,
MP.ORGANIZATIONADDONGUESTPRICE,
SITE.ID as SITEID,
MP.PROGRAMTYPE,
MP.PROGRAMBASEDON,
MP.CATEGORY,
MP.DEDUCTIBILITY,
MP.RENEWALWINDOWSTARTTYPE,
MP.RENEWALWINDOWSTARTTIME,
MP.RENEWALWINDOWSTARTINTERVAL,
MP.DUESTREATEDASCONTRIBUTION,
MP.MULTIPLEPAYMENTSEACHTERM,
MP.INSTALLMENTPOSTSTATUS
/*#EXTENSION*/
from
dbo.MEMBERSHIPPROGRAM as MP
left join
dbo.SITE
on
SITE.ID = MP.SITEID
left join
dbo.CHANGEAGENT as ADDEDBY
on
ADDEDBY.ID = MP.ADDEDBYID
left join
dbo.CHANGEAGENT as CHANGEDBY
on
CHANGEDBY.ID = MP.CHANGEDBYID