MEMBERSHIP_AUDIT_LOG

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 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 and time the membership exits a status as a result of either a transaction or a manual change on the Membership Inquiry page

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)

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

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

Membership ID

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

The date when the membership became effective

The expiry date of the membership

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

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 of the membership package

Name of the membership package

The ID of the package category

Package Category Name

Whether this package is a retention eligible package

Whether this package is a retention eligible package.

The ID for the primary member

First name of the primary member

Last name of the primary member

Emaild address of the primary member

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”

The date when the membership was suspended

The date when the membership’s suspension ended

The Reason ID for the membership suspension

The reason this package was suspended

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 Reason ID for the membership package termination

The reason this package was cancelled

Whether the sale of a new retention eligible membership constitutes a new join, or is considered to be reinstated because a prior retention eligible membership ended within the grace period. Other actions for a retention eligible membership will show as not applicable. (New Join / Reinstated / Not Applicable / Not Retention Eligible)

Whether the expiry or cancellation of a retention eligible membership constitutes a termination, is considered to be recaptured as another retention eligible membership was purchased within the grace period, or is still pending termination as the grace period has not yet passed. Other actions for a retention eligible membership will show as not applicable. (Termination Pending / Terminated / Recaptured / Not Applicable / Not Retention Eligible)

Whether this transaction has been voided

Whether this transaction has been voided.

The ID of the site to which this package belongs

The name of the site to which this package belongs

The ID of the system user who performed the membership change

First name of the system user

Last name of the system user

The ID of the workstation where the membership change was made

The name of the workstation where the membership change was made

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 Hub record ID

Your organization’s unique identifier in the Active Net system

Date and time Hub record was last modified

The Hub sync process ID

For a Transaction Type of “Transfer”, the previous Package ID, otherwise 0.

For a Transaction Type of “Transfer”, the previous Package Name, otherwise “Not Applicable.”

For a Transaction Type of “Transfer”, the previous Site ID, otherwise 0.

For a Transaction Type of “Transfer”, the previous Site Name, otherwise “Not Applicable.”

The ID value from the Active Net system