| NAME |
nvarchar(100) |
|
Default = '' |
The name of the membership program. |
| DESCRIPTION |
nvarchar(255) |
|
Default = '' |
The description of the membership program. |
| TYPECODE |
tinyint |
|
Default = 0 |
Enumerated value for the type of recognition program: 0 - Annual Giving, 1 - Lifetime Giving |
| ISACTIVE |
bit |
|
Default = 1 |
Indicates whether this membership program is active. |
| EXPIRESONCODE |
tinyint |
|
Default = 0 |
Enumerated value indicating the expiration date: 0 - End of calendar year, 1 - End of fiscal year |
| BACKDATEMEMBERSHIPS |
bit |
|
Default = 0 |
Indicates whether to set memberships starting prior to the cutoff date to the previous month. |
| CUTOFFDATEFORYEAR |
UDT_MONTHDAY |
|
Default = '0000' |
The date after which memberships will be pushed to expire in the next year. |
| GIFTTYPESFILTER |
xml |
yes |
|
A collection of gift types to use for filtering revenue when processing this membership program. |
| STARTDATE |
datetime |
yes |
|
The date to use as a start date for considering revenue when processing this membership program. |
| MAXIMUMAMOUNT |
money |
|
Default = 0 |
The maximum gift amount used to limit calculation of membership in this program. |
| REVENUECODE |
tinyint |
|
Default = 0 |
IGNORED. Indicates whether to include revenue only, planned gifts only, or both for a lifetime giving recognition program. |
| LASTPROCESSEDON |
datetime |
yes |
|
The last time this recognition program was processed. |
| 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) |
yes |
CONVERT(bigint, TS) |
Numeric representation of the timestamp. |
| ALLOWINDIVIDUAL |
bit |
|
Default = 1 |
Indicates whether this membership program is available to individuals. |
| ALLOWHOUSEHOLD |
bit |
|
Default = 1 |
Indicates whether this membership program is available to households. |
| ALLOWGROUP |
bit |
|
Default = 1 |
Indicates whether this membership program is available to groups. |
| ALLOWORGANIZATION |
bit |
|
Default = 1 |
Indicates whether this membership program is available to organizations. |
| PLANNEDGIFTCODE |
tinyint |
|
Default = 0 |
Describes whether planned gifts booked as revenue should be counted with revenue, separately, or not at all |
| TYPE |
nvarchar(15) (Computed) |
yes |
CASE [TYPECODE] WHEN 0 THEN N'Annual giving' WHEN 1 THEN N'Lifetime giving' END |
Provides a translation for the 'TYPECODE' field. |
| EXPIRESON |
nvarchar(20) (Computed) |
yes |
CASE [EXPIRESONCODE] WHEN 0 THEN N'End of calendar year' WHEN 1 THEN N'End of fiscal year' END |
Provides a translation for the 'EXPIRESONCODE' field. |
| REVENUE |
nvarchar(26) (Computed) |
yes |
CASE [REVENUECODE] WHEN 0 THEN N'Revenue only' WHEN 1 THEN N'Planned giving only' WHEN 2 THEN N'Revenue and planned giving' END |
Provides a translation for the 'REVENUECODE' field. |
| PLANNEDGIFT |
nvarchar(43) (Computed) |
yes |
CASE [PLANNEDGIFTCODE] WHEN 0 THEN N'No planned gifts' WHEN 1 THEN N'Include planned gifts' WHEN 2 THEN N'Include planned gifts with separate minimum' END |
Provides a translation for the 'PLANNEDGIFTCODE' field. |
| ORGANIZATIONMAXIMUMAMOUNT |
money |
|
Default = 0 |
The maximum gift amount in organization currency. |
| INCLUDECREDITWITHOUTTYPE |
bit |
|
Default = 1 |
Indicates whether to include recognition credit without a type. |
| USEGROSSAMOUNT |
bit |
|
Default = 0 |
|