MEMBERSHIP_USAGE

0 rows


Description

Membership pass usage history

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ACTIVE_HUB_KEY bigint identity 8 √ null

System Generated key value. No significance to membership data
ALTERNATE_KEY_STATUS_ID Unknown 0 null
ALTERNATE_KEY_STATUSES.ALTERNATE_KEY_STATUS_ID Defined in XML R
ALTERNATE_KEY_TYPE_ID Unknown 0 null
ALTERNATE_KEY_TYPES.ALTERNATE_KEY_TYPE_ID Defined in XML R
PACKAGE_ID int 4 √ null
PACKAGES.PACKAGE_ID Defined in XML R

The membership package ID.
SITE_ID int 4 √ null
SITES.SITE_ID Defined in XML R

Site ID for the membership package
MEMBER_SINCE_DATE date 20 √ null

The original date on which the customer purchased a valid retention eligible membership within the defined retention period. For a single customer, there is only one member since date
CUSTOMER_ID int 4 √ null
CUSTOMERS.CUSTOMER_ID Defined in XML R

The ID for the member.
USAGE_DATE date 20 √ null

The member check-in date.
USAGE_TIME time 32 √ null

The member check-in time.
JOIN_DATE date 20 √ null

Membership sale date of the primary member
EXPIRATION_DATE date 20 √ null

The expiration date of the membership package.
PACKAGECATEGORY_ID Unknown 0 null
PACKAGE_CATEGORIES.PACKAGE_CATEGORY_ID Defined in XML R
SUSPEND_FROM_DATE date 20 √ null

The date from which the membership package was suspended.
SUSPEND_TO_DATE date 20 √ null

The date to which the membership package is suspended.
ENTRYPOINT_ID int 4 √ null
ENTRY_POINTS.ENTRYPOINT_ID Defined in XML R

The ID of the entry point where the member checked-in.
REASON_DECLINED varchar 255 √ null

The reason the pass was declined an entry in the facility
PASS_NUMBER varchar 255 √ null

The member’s pass card number.
VOIDED varchar 255 √ null

Shows whether the usage was voided or not
LAST_SYNC_TIME datetime 16,3 (getdate())

Date and time Hub record was last modified
ACTIVE_HUB_PROCESS_ID bigint 8 √ null

The Hub sync process ID
MEMBERSHIP_ID int 4 √ null
MEMBERSHIPS.MEMBERSHIP_ID Defined in XML R

Membership ID
CHECKOUT_DATE date 20 √ null

Check out date.
CHECKOUT_TIME time 32 √ null

Check out time.
CHECKOUT_ENTRY_POINT_ID int 4 √ null
ENTRY_POINTS.ENTRYPOINT_ID Defined in XML R

Check out entry point ID.
AUTHORIZED varchar 5 √ null

Shows whether the usage was authorized or not
QUANTITY int 4 √ null

Shows the usage quantity.
MEMBERSHIPUSAGE_ID int 4 √ null
CHILD_WATCH_REGISTRATIONS.CHECK_IN_MEMBERSHIP_USAGE_ID Defined in XML R
CHILD_WATCH_REGISTRATIONS.CHECK_OUT_MEMBERSHIP_USAGE_ID Defined in XML R

Membership scan ID
ORG_ID int 4 √ null

Your organization’s unique identifier in the Active Net system
PASS_ID int 4 √ null

The member’s pass card ID.
POSPRODUCT_ID int 4 √ null
POS_PRODUCTS.POSPRODUCT_ID Defined in XML R

The ID of the POS product.
RECEIPT_NUMBER varchar 20 √ null

POS receipt number for the drop-in product sale
CUSTOMER_ALTERNATE_KEY_ID int 4 √ null
CUSTOMER_ALTERNATE_KEYS.CUSTOMER_ALTERNATE_KEY_ID Defined in XML R

The primary key for the customer alternate key record.
ROW_VERSION binary 8 √ null

System timestamp (for internal use)

Indexes

Constraint Name Type Sort Column(s)
MEMBERSHIP_USAGE_PK Primary key Asc ACTIVE_HUB_KEY
MEMBERSHIP_USAGE_CUSTOMER_ALTERNATE_KEY_ID_IX Performance Asc CUSTOMER_ALTERNATE_KEY_ID
MEMBERSHIP_USAGE_CUSTOMER_ID_IX Performance Asc CUSTOMER_ID
MEMBERSHIP_USAGE_MEMBERSHIP_ID_ORG_ID_IX Performance Asc/Asc MEMBERSHIP_ID + ORG_ID
MEMBERSHIP_USAGE_MEMBERSHIPUSAGE_ID_ORG_ID_IX Performance Asc/Asc MEMBERSHIPUSAGE_ID + ORG_ID
MEMBERSHIP_USAGE_nc_cs_ix Performance Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc CUSTOMER_ALTERNATE_KEY_ID + CUSTOMER_ID + MEMBERSHIPUSAGE_ID + PACKAGE_ID + POSPRODUCT_ID + SITE_ID + USAGE_DATE + USAGE_TIME
MEMBERSHIP_USAGE_PACKAGE_ID_IX Performance Asc PACKAGE_ID
MEMBERSHIP_USAGE_POSPRODUCT_ID_IX Performance Asc POSPRODUCT_ID
MEMBERSHIP_USAGE_ROW_VERSION_IX Performance Asc ROW_VERSION
MEMBERSHIP_USAGE_SITE_ID_IX Performance Asc SITE_ID
MEMBERSHIP_USAGE_USAGE_DATE_IX Performance Asc USAGE_DATE

Relationships

Close relationships within degrees of separation