| 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. |
| PROGRAMTYPECODE |
tinyint |
|
Default = 0 |
|
| PROGRAMTYPE |
nvarchar(20) (Computed) |
|
CASE [PROGRAMTYPECODE] WHEN 0 THEN N'Annual' WHEN 1 THEN N'Recurring/Sustaining' WHEN 2 THEN N'Lifetime' END |
|
| PROGRAMBASEDONCODE |
tinyint |
|
Default = 0 |
|
| PROGRAMBASEDON |
nvarchar(19) (Computed) |
|
CASE [PROGRAMBASEDONCODE] WHEN 0 THEN N'Dues based' WHEN 1 THEN N'Contributions based' WHEN 2 THEN N'Both' END |
|
| CATEGORYCODE |
tinyint |
|
Default = 9 |
|
| DEDUCTIBILITYCODE |
tinyint |
|
Default = 1 |
|
| DUESTREATEDASCONTRIBUTION |
bit |
|
Default = 0 |
|
| ONEPAYMENTEACHTERM |
bit |
|
Default = 1 |
|
| MULTIPLEPAYMENTSEACHTERM |
bit |
|
Default = 0 |
|
| RENEWALWINDOWSTARTTYPECODE |
tinyint |
|
Default = 0 |
|
| RENEWALWINDOWSTARTTYPE |
nvarchar(28) (Computed) |
|
CASE [RENEWALWINDOWSTARTTYPECODE] WHEN 0 THEN N'Given time before expiration' WHEN 1 THEN N'Day of month of expiration' WHEN 2 THEN N'No automatic renewal' END |
|
| RENEWALWINDOWSTARTTIMECODE |
tinyint |
|
Default = 0 |
|
| RENEWALWINDOWSTARTINTERVALCODE |
tinyint |
|
Default = 0 |
|
| RENEWALWINDOWSTARTINTERVAL |
nvarchar(6) (Computed) |
|
CASE [RENEWALWINDOWSTARTINTERVALCODE] WHEN 0 THEN N'Days' WHEN 1 THEN N'Months' END |
|
| RENEWALWINDOWSTARTCUTOFFDAY |
tinyint |
|
Default = 1 |
|
| RENEWALWINDOWREVENUETYPECODE |
tinyint |
|
Default = 0 |
|
| RENEWALWINDOWREVENUETYPE |
nvarchar(14) (Computed) |
|
CASE [RENEWALWINDOWREVENUETYPECODE] WHEN 0 THEN N'Rejoin' WHEN 1 THEN N'New membership' END |
|
| RENEWALWINDOWSTARTTIME |
nvarchar(2) (Computed) |
|
CASE [RENEWALWINDOWSTARTTIMECODE] WHEN 0 THEN N'1' WHEN 1 THEN N'2' WHEN 2 THEN N'3' WHEN 3 THEN N'4' WHEN 4 THEN N'5' WHEN 5 THEN N'6' WHEN 6 THEN N'7' WHEN 7 THEN N'8' WHEN 8 THEN N'9' WHEN 9 THEN N'10' WHEN 10 THEN N'11' WHEN 11 THEN N'12' WHEN 12 THEN N'13' WHEN 13 THEN N'14' WHEN 14 THEN N'15' WHEN 15 THEN N'16' WHEN 16 THEN N'17' WHEN 17 THEN N'18' WHEN 18 THEN N'19' WHEN 19 THEN N'20' WHEN 20 THEN N'21' WHEN 21 THEN N'22' WHEN 22 THEN N'23' WHEN 23 THEN N'24' WHEN 24 THEN N'25' WHEN 25 THEN N'26' WHEN 26 THEN N'27' WHEN 27 THEN N'28' WHEN 28 THEN N'29' WHEN 29 THEN N'30' WHEN 30 THEN N'31' END |
|
| NONRENEWALACTIONTYPECODE |
tinyint |
|
Default = 4 |
|
| NONRENEWALACTIONTYPE |
nvarchar(7) (Computed) |
|
CASE [NONRENEWALACTIONTYPECODE] WHEN 4 THEN N'Lapsed' WHEN 5 THEN N'Expired' END |
|
| LASTPROCESSEDON |
datetime |
|
|
|
| CATEGORY |
nvarchar(27) (Computed) |
|
CASE [CATEGORYCODE] WHEN 0 THEN N'Alumni Association' WHEN 1 THEN N'Museum' WHEN 2 THEN N'Zoo/Aquarium' WHEN 3 THEN N'Public Radio' WHEN 4 THEN N'Nature/Environmental' WHEN 5 THEN N'Arboretum/Botanical Gardens' WHEN 6 THEN N'Political' WHEN 7 THEN N'Library' WHEN 8 THEN N'Lobbying' WHEN 9 THEN N'None' END |
|
| DEDUCTIBILITY |
nvarchar(43) (Computed) |
|
CASE [DEDUCTIBILITYCODE] WHEN 0 THEN N'Yes, the entire amount is deductible' WHEN 1 THEN N'Yes, a portion is considered tax deductible' WHEN 2 THEN N'No, nothing is tax deductible' END |
|
| ISTYPEPROGRAM |
bit |
|
Default = 0 |
|
| WHEREISREVENUETRACKEDCODE |
tinyint |
|
Default = 0 |
|
| WHEREISREVENUETRACKED |
nvarchar(26) (Computed) |
|
CASE [WHEREISREVENUETRACKEDCODE] WHEN 0 THEN N'Are made in this system' WHEN 1 THEN N'Are made in another system' END |
|
| MULTIPLETERMS |
bit |
|
Default = 0 |
|
ID
SITEID
IX_MEMBERSHIPPROGRAM_BASECURRENCYID
IX_MEMBERSHIPPROGRAM_DATEADDED
TR_MEMBERSHIPPROGRAM_AUDIT_ETLDELETEDID