Primary Key | Field Type |
---|---|
ID | uniqueidentifier |
Field | Field Type | Null | Notes | Description |
---|---|---|---|---|
TRANSACTIONDATE | datetime | The date of this membership transaction. | ||
EXPIRATIONDATE | datetime | The expiration date for the membership set by this transaction. | ||
ISGIFT | bit | Default = 0 | Indicates that this membership transaction was purchased by a constituent other than the member. | |
NUMBEROFCHILDREN | smallint | Default = ((0)) | The number of children allowed on this membership. | |
COMMENTS | nvarchar(1000) | Default = '' | Remarks about this membership. | |
ACTIONCODE | tinyint | Default = 0 | The action of this transaction on the membership. | |
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. | |
ACTION | nvarchar(9) (Computed) | CASE [ACTIONCODE] WHEN 0 THEN N'Join' WHEN 1 THEN N'Renew' WHEN 2 THEN N'Upgrade' WHEN 3 THEN N'Downgrade' WHEN 4 THEN N'Drop' WHEN 5 THEN N'Rejoin' WHEN 6 THEN N'Cancel' END | ||
BASEAMOUNT | money | Default = 0 | ||
UPGRADEMETHODCODE | tinyint | Default = 0 | ||
UPGRADEMETHOD | nvarchar(15) (Computed) | CASE [UPGRADEMETHODCODE] WHEN 0 THEN N'Not an upgrade' WHEN 1 THEN N'Renewal upgrade' WHEN 2 THEN N'Midterm upgrade' END |
Foreign Key | Field Type | Null | Notes | Description |
---|---|---|---|---|
MEMBERSHIPID | uniqueidentifier | MEMBERSHIP.ID | FK to MEMBERSHIP | |
MEMBERSHIPLEVELID | uniqueidentifier | MEMBERSHIPLEVEL.ID | FK to MEMBERSHIPLEVEL | |
MEMBERSHIPLEVELTERMID | uniqueidentifier | MEMBERSHIPLEVELTERM.ID | FK to MEMBERSHIPLEVELTERM | |
DONORID | uniqueidentifier | CONSTITUENT.LOCALID | The constituent who purchased this membership as a gift. | |
ADDEDBYID | uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. | |
CHANGEDBYID | uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. | |
MEMBERSHIPLEVELTYPECODEID | uniqueidentifier | MEMBERSHIPLEVELTYPECODE.ID | The type of membership. | |
REVENUESPLITID | uniqueidentifier | FINANCIALTRANSACTIONLINEITEM.ID | The REVENUESPLIT record that is linked to this membership transaction. | |
MEMBERSHIPPROMOID | uniqueidentifier | MEMBERSHIPPROMO.ID |
Index Name | Field(s) | Unique | Primary | Clustered |
---|---|---|---|---|
IX_MEMBERSHIPTRANSACTION_DATEADDED | DATEADDED | |||
IX_MEMBERSHIPTRANSACTION_DATECHANGED | DATECHANGED | |||
IX_MEMBERSHIPTRANSACTION_DONORID | DONORID | |||
IX_MEMBERSHIPTRANSACTION_MEMBERSHIPID | MEMBERSHIPID | |||
IX_MEMBERSHIPTRANSACTION_REVENUESPLITID | REVENUESPLITID | |||
IX_MEMBERSHIPTRANSACTION_TRANSACTIONDATE | TRANSACTIONDATE | |||
IX_MEMBERSHIPTRANSACTION_TRANSACTIONDATE_DATEADDED | TRANSACTIONDATE, DATEADDED | |||
PK_MEMBERSHIPTRANSACTION | ID |
Trigger Name | Description |
---|---|
TR_MEMBERSHIPTRANSACTION_AUDIT_ETLDELETEDID | |
TR_MEMBERSHIPTRANSACTION_AUDIT_UPDATE | |
TR_MEMBERSHIPTRANSACTION_AUDIT_DELETE |
Referenced by | Field |
---|---|
MEMBERSHIPADDON | MEMBERSHIPTRANSACTIONID |
MEMBERSHIPCONTRIBUTIONPORTION | MEMBERSHIPTRANSACTIONID |
MEMBERSHIPPROGRAMCONTRIBUTIONREVENUE | ORIGINALMEMBERSHIPTRANSACTIONID |
MEMBERSHIPPROGRAMCONTRIBUTIONREVENUE | CURRENTMEMBERSHIPTRANSACTIONID |
SALESORDERITEMMEMBERSHIP | MEMBERSHIPTRANSACTIONID |
SALESORDERITEMMEMBERSHIPADDON | MEMBERSHIPTRANSACTIONID |