MEMBERSHIPLEVELRENEWAL

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
INTERVALCODE	tinyint		Default = 0
INTERVAL	nvarchar(14) (Computed)	yes	CASE [INTERVALCODE] WHEN 0 THEN N'1 month' WHEN 1 THEN N'2 months' WHEN 2 THEN N'3 months' WHEN 3 THEN N'4 months' WHEN 4 THEN N'5 months' WHEN 5 THEN N'6 months' WHEN 6 THEN N'7 months' WHEN 7 THEN N'8 months' WHEN 8 THEN N'9 months' WHEN 9 THEN N'10 months' WHEN 10 THEN N'11 months' WHEN 11 THEN N'12 months' WHEN 12 THEN N'Rest of window' END
DATEADDED	datetime		Default = getdate()
DATECHANGED	datetime		Default = getdate()
TS	timestamp
TSLONG	bigint (Computed)	yes	CONVERT(bigint, TS)
STATUSCODE	tinyint		Default = 0
STATUS	nvarchar(9) (Computed)	yes	CASE [STATUSCODE] WHEN 0 THEN N'Active' WHEN 1 THEN N'Cancelled' WHEN 2 THEN N'Pending' WHEN 3 THEN N'Grace' WHEN 4 THEN N'Lapsed' WHEN 5 THEN N'Expired' END

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
MEMBERSHIPLEVELID	uniqueidentifier	yes	MEMBERSHIPLEVEL.ID
ADDEDBYID	uniqueidentifier		CHANGEAGENT.ID
CHANGEDBYID	uniqueidentifier		CHANGEAGENT.ID

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_MEMBERSHIPLEVELRENEWAL_DATEADDED	DATEADDED			yes
IX_MEMBERSHIPLEVELRENEWAL_DATECHANGED	DATECHANGED
PK_MEMBERSHIPLEVELRENEWAL	ID	yes	yes

Triggers

Trigger Name	Description
TR_MEMBERSHIPLEVELRENEWAL_AUDIT_UPDATE
TR_MEMBERSHIPLEVELRENEWAL_AUDIT_DELETE

Referenced by

Referenced by	Field
MEMBERSHIPLEVEL	MEMBERSHIPLEVELRENEWAL1ID
MEMBERSHIPLEVEL	MEMBERSHIPLEVELRENEWAL2ID
MEMBERSHIPLEVEL	MEMBERSHIPLEVELRENEWAL3ID
MEMBERSHIPLEVELRENEWALRULES	MEMBERSHIPLEVELRENEWAL1ID
MEMBERSHIPLEVELRENEWALRULES	MEMBERSHIPLEVELRENEWAL2ID
MEMBERSHIPLEVELRENEWALRULES	MEMBERSHIPLEVELRENEWAL3ID