Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 NAME nvarchar(100)   Default = '' The name of the membership program.
 DESCRIPTION nvarchar(255)   Default = '' The description of the membership program.
 ISACTIVE bit   Default = 1 Indicates whether this membership program is active.
 ALLOWMULTIPLEMEMBERSHIPS bit   Default = 0 Allow constituents to have multiple instances of this membership program.
 EXPIRESONCODE tinyint   Default = 0 Enumerated value indicating the expiration date: 0 - Join date, 1 - End of month, 2 - End of calendar year, 3 - End of fiscal year, 4 - Specific date
 BACKDATEMEMBERSHIPS bit   Default = 0 Indicates whether to set memberships starting prior to the cutoff date to the previous month.
 CUTOFFDAY tinyint   Default = 0 The date of the month before which memberships will be back dated to the previous month.
 CUTOFFDATEFORYEAR UDT_MONTHDAY   Default = '0000' The date after which memberships will be pushed to expire in the next year.
 DATEADDED datetime   Default = getdate() Indicates the date this record was added.
 DATECHANGED datetime   Default = getdate() Indicates the date this record was last changed.
 TS timestamp   Timestamp.
 TSLONG bigint (Computed) CONVERT(bigint, TS) Numeric representation of the timestamp.
 CARDFORMAT nvarchar(255)   Default = '' Path of the report used for printing membership cards.
 EXPIRESON nvarchar(20) (Computed) CASE [EXPIRESONCODE] WHEN 0 THEN N'Join date' WHEN 1 THEN N'End of month' WHEN 2 THEN N'End of calendar year' WHEN 3 THEN N'End of fiscal year' WHEN 4 THEN N'Specific date(s)' END Provides a translation for the 'EXPIRESONCODE' field.
 ALLOWADDONADULT bit   Default = 0 Indicates whether this membership program allows add-on named adults.
 ADDONADULTPRICE money   Default = 0 Price of add-on named adult.
 ALLOWADDONGUEST bit   Default = 0 Indicates whether this membership program allows add-on unnamed guests.
 ADDONGUESTPRICE money   Default = 0 Price of add-on unnamed guest.
 ORGANIZATIONADDONADULTPRICE money   Default = 0 Add-on adult price in organization currency.
 ORGANIZATIONADDONGUESTPRICE money   Default = 0 ADd-on guest price in organization currency.

Foreign Key Field Type Null Notes Description
 SITEID uniqueidentifier SITE.ID The site to which this membership program belongs.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 LETTERTEMPLATEID uniqueidentifier LETTERTEMPLATE.ID Letter template used to print membership cards
 BASECURRENCYID uniqueidentifier CURRENCY.ID The base currency associated with this membership program.
 ORGANIZATIONEXCHANGERATEID uniqueidentifier CURRENCYEXCHANGERATE.ID The exchange rate used to convert from amount to organization amount.
 REPORTCATALOGID uniqueidentifier REPORTCATALOG.ID Report spec used for printing membership cards

Index Name Field(s) Unique Primary Clustered
 IX_MEMBERSHIPPROGRAM_BASECURRENCYID BASECURRENCYID      
 IX_MEMBERSHIPPROGRAM_DATEADDED DATEADDED    
 IX_MEMBERSHIPPROGRAM_DATECHANGED DATECHANGED      
 IX_MEMBERSHIPPROGRAM_ID ID      
 PK_MEMBERSHIPPROGRAM ID  
 UC_MEMBERSHIPPROGRAM_NAME NAME    

Trigger Name Description
 TR_MEMBERSHIPPROGRAM_AUDIT_UPDATE
 TR_MEMBERSHIPPROGRAM_AUDIT_DELETE
 TR_MEMBERSHIPPROGRAM_INSERTUPDATE_CURRENCY

Referenced by Field
 APPEAL MEMBERSHIPPROGRAMID
 BATCHBBNCMEMBERSHIP MEMBERSHIPPROGRAMID
 BATCHMEMBERSHIP MEMBERSHIPPROGRAMID
 BATCHREVENUEAPPLICATIONMEMBERSHIP MEMBERSHIPPROGRAMID
 COMBINATIONAVAILABILITYMEMBER MEMBERSHIPPROGRAMID
 COMBINATIONMEMBER MEMBERSHIPPROGRAMID
 CREDITITEMMEMBERSHIP MEMBERSHIPPROGRAMID
 DAILYSALEITEMMEMBERSHIP MEMBERSHIPPROGRAMID
 DISCOUNTAVAILABILITYMEMBER MEMBERSHIPPROGRAMID
 DISCOUNTMEMBER MEMBERSHIPPROGRAMID
 GIFTAIDDISQUALIFIEDBYMEMBERSHIPPROGRAM ID
 MEMBERSHIP MEMBERSHIPPROGRAMID
 MEMBERSHIPLEVEL MEMBERSHIPPROGRAMID
 MEMBERSHIPPROGRAMCAMPAIGN MEMBERSHIPPROGRAMID
 MEMBERSHIPPROGRAMENDDATE MEMBERSHIPPROGRAMID
 MKTMEMBERSHIPRENEWALEFFORTMAILINGPROCESS MEMBERSHIPPROGRAMID
 MKTMEMBERSHIPRENEWALEFFORTPROCESS MEMBERSHIPPROGRAMID
 PRINTMEMBERSHIPCARDSPROCESS MEMBERSHIPPROGRAMID
 SALESORDERITEMMEMBERSHIP MEMBERSHIPPROGRAMID

Entity-Relationship diagram of this table (APPEAL-MKTMEMBERSHIPRENEWALEFFORTMAILINGPROCESS)
Entity-Relationship diagram of this table (MKTMEMBERSHIPRENEWALEFFORTPROCESS-SITE)