MEMBERSHIPS

System Generated key value. No significance to membership data

the membership_id

Customer_ID of the member

The package ID of the customers membership.

The first name of the customer

The last name of the customer

The date when the customer account was created

The first name of the primary member to which the membership package is assigned

The last name of the primary member to which the membership package is assigned

The primary customer ID to which the membership package is assigned.

The status (active, expired, suspended, canceled, etc.) of the membership package.

The effective date of the membership package.

The expiration date of the membership package.

Date punch pass expires

The payment method selected for an auto-renewal membership (Not Auto-Renewed / Credit Card / ECP / Manual Deduction / Payment Plan)

The most recent renewal date for the membership package.

The date from which the membership package was suspended.

The date to which the membership package is suspended.

Whether the membership package is scheduled for a future automatic cancellation at renewal.

The date when the automatic cancellation at renewal will be executed

The maximum number of uses/punches available for the membership package, when the membership package has defined usage restrictions.

Whether auto renewal is suspended or not

The date and time membership was last modified

Name of the membership package

The site ID of the membership package

The site name of the membership package

Package Category ID of the membership package

Package category name of the membership package

Whether the package is a family membership

Whether the package is a family membership (Yes/No)

Status of the package 1=Active,0=Inactive)

Status of the package (Open/Closed)

Specific timeperiod the package is active

Specific time period the package is active

Specific number of days the package is active

Whether or not the package is retention eligible

Whether this package is a retention eligible package.

Customers membership pass number

The earliest date and time on which the membership became effective. Note: Can be prior to the sale date of the membership Applies to all memberships regardless of retention eligible status

The number of uses/punches that were used for the membership package, when the membership package has defined usage restrictions.

Total number of passes this member has

The entry points to which the pass holder of the membership package can access.

Pass number of the primary member

Whether the membership has a scheduled cancellation

Date of the scheduled cancellation

Reason for the scheduled cancellation

The termination date for a membership, when the latest membership sale or renewal transaction has been manually cancelled.

The reason the membership package was terminated

Date and time Hub record was last modified

The Hub sync process ID

The termination date for a membership, when the latest membership sale or renewal transaction has been manually cancelled (date only)

The date when the customer account was created (date only)

The effective date of the membership package (date only)

The expiration date of the membership package (date only)

The most recent renewal date for the membership package (date only)

The earliest date-only on which the membership became effective. Note: Can be prior to the sale date of the membership Applies to all memberships regardless of retention eligible status

The date membership was last modified (date only)

The date when the automatic cancellation at renewal will be executed (date only)

Date of the scheduled cancellation (date only)

The date from which the membership package was suspended (date only)

The date to which the membership package is suspended (date only)

Whether the membership package is scheduled for a future automatic cancellation at renewal.

Whether auto renewal is suspended or not.

Whether the membership has a scheduled cancellation.

Whether this customer is the primary customer for this membership.

The date and time the membership was last used

The date the membership was last used (date only)

The membership pass id for this membership and customer

Your organization’s unique identifier in the Active Net system

The Reason ID for the membership package termination

Reason ID for the scheduled cancellation

Reason ID for the scheduled cancellation at renewal

Reason for the scheduled cancellation at renewal

The reason for the membership suspension

The Reason ID for the membership suspension

DEPRECATED - Same as SCHEDULED_CANCELLATION_REASON_ID

DEPRECATED - Same as SUSPENDED_REASON

DEPRECATED - Same as SCHEDULED_AUTOMATIC_CANCELLATION_REASON_ID

DEPRECATED - Same as SCHEDULED_AUTOMATIC_CANCELLATION_REASON

Date of the manual cancellation of auto renewal

Date of the manual cancellation of auto renewal (date only)

Reason ID for the manual cancellation of auto renewal

Reason for the manual cancellation of auto renewal

Third party billing company ID

Third party billing receive type (Per Customer, Per Family, Per Month Per Customer, Percent)

Third party billing amount to receive each scheduled period

Third party billing percent to receive each scheduled period

Third party billing amount received last period

Third party billing date last received

Third party billing total billed to date

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.