MEMBERSHIPPROMO

Provides a way for organizations to extend terms of or reduce prices of memberships

For the full definition of the MEMBERSHIPPROMO table, see MEMBERSHIPPROMO.

Fields

Field	Change	Field Type	Null	Notes	Description
FORMATTEDVALUE	Changed	nvarchar(max) (Computed)	yes	case PROMOTIONTYPECODE when 0 then case DISCOUNTCALCULATIONTYPECODE when 0 then '$' + cast(AMOUNT as nvarchar(max)) + ' off' when 1 then cast([PERCENT] as nvarchar(6)) + '% off' end when 1 then case EXTENSIONCALCULATIONTYPECODE when 0 then cast(EXTENSIONVALUE as nvarchar(2)) + ' days' when 1 then cast(EXTENSIONVALUE as nvarchar(2)) + ' months' end end	Expression changed from case PROMOTIONTYPECODE when 0 then case DISCOUNTCALCULATIONTYPECODE when 0 then '$' + cast(AMOUNT as nvarchar(max)) + ' off' when 1 then cast([PERCENT] as nvarchar(6)) + '% off' end when 1 then case EXTENSIONCALCULATIONTYPECODE when 0 then cast(EXTENSIONVALUE as nvarchar(2)) + ' days' when 1 then cast(EXTENSIONVALUE as nvarchar(2)) + ' months' end end to case PROMOTIONTYPECODE when 0 then case DISCOUNTCALCULATIONTYPECODE when 0 then '$' + cast(AMOUNT as nvarchar(max)) + ' off' when 1 then cast([PERCENT] as nvarchar(6)) + '% off' end when 1 then case EXTENSIONCALCULATIONTYPECODE when 0 then cast(EXTENSIONVALUE as nvarchar(2)) + ' days' when 1 then cast(EXTENSIONVALUE as nvarchar(2)) + ' months' end end