MEMBERSHIP_AUDIT_LOG

The Hub record ID

This membership history ID is for troubleshooting purposes

The date and time the membership enters a status as a result of either a transaction or a manual change on the Membership Inquiry page

The date and time the membership exits a status as a result of either a transaction or a manual change on the Membership Inquiry page

This indicates the origin or cause of the membership change:

0 None
1 Join
2 Transfer
3 Renew
4 Renew After Grace
5 Refund And Cancel
6 Refund
7 Fee Adjust
8 Modify
9 Pass Refund
20 Status Change
21 Becomes Effective
22 Becomes Suspended
23 Becomes Unsuspended

Whether this transaction has been voided

The transaction ID of the transaction type for the membership change.

Membership ID

The ID of the membership package

Membership status, including Pending, Active, Voided, Refunded, Renewing, Deferred Commit

The date when the membership became effective

The expiry date of the membership

The date when the membership was suspended

The date when the membership’s suspension ended

The payment method selected for an auto-renewal membership

0 Not autorenewed
1 By credit card
2 By EFT
3 By manual deduction
4 By payment plan

The ID for the primary member

For a punch card membership, this is the maximum number of uses for this membership (not the remaining number of uses)

The ID of the site to which this package belongs

The date when the customer purchased a valid membership

If the previous membership package expired, then the date when the customer purchased a new package is the new “Member Since Date”

Date and time Hub record was last modified

The Hub sync process ID

The reason this package was cancelled

The date the membership enters a status as a result of either a transaction or a manual change on the Membership Inquiry page (date only)

The date the membership exits a status as a result of either a transaction or a manual change on the Membership Inquiry page (date only)

Whether this transaction has been voided.

Your organization’s unique identifier in the Active Net system

The Reason ID for the membership suspension

The Reason ID for the membership package termination

The date that the membership was either manually cancelled, or was scheduled for termination on.

The date that the membership was either manually cancelled, or was scheduled for termination on (date only)

The last date that the membership was active and able to be used before it expired or was cancelled. If a cancellation results in a retroactive change to the final expiration date then the date the cancellation was processed is used here.

The ID of the system user who performed the membership change

The ID of the workstation where the membership change was made

System timestamp (for internal use)