MEMBERSHIP_USAGE

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

ACTIVE_HUB_KEY

bigint

null

System Generated key value. No significance to membership data

PACKAGE_ID

int

√

null

PACKAGES.PACKAGE_ID

Defined in XML

The membership package ID.

PACKAGE

varchar

255

√

null

The membership package name.

PACKAGECATEGORY_ID

int

√

null

PACKAGE_CATEGORIES.PACKAGE_CATEGORY_ID

Defined in XML

Package Category ID of the membership package

PACKAGE_CATEGORY

varchar

√

null

The membership package category name.

SITE_ID

int

√

null

SITES.SITE_ID

Defined in XML

Site ID for the membership package

SITE

varchar

255

√

null

Site name for the membership package

MEMBER_SINCE_DATE

date

√

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

√

null

CUSTOMERS.CUSTOMER_ID

Defined in XML

The ID for the member.

MEMBER_NAME

varchar

511

null

The full name of the member.

MEMBER_FIRST_NAME

varchar

255

√

null

The first name of the member.

MEMBER_LAST_NAME

varchar

255

√

null

The last name of the member.

DATE_OF_BIRTH

datetime

16,3

√

null

DOB of the customer who used the facility

ADDRESS

varchar

255

√

null

Customer’s address 1

CUSTOMER_CITY

varchar

255

√

null

Customer’s residential address city

CUSTOMER_PROV_STATE

varchar

255

√

null

Customer’s residential address province

CUSTOMER_HOME_PHONE

varchar

255

√

null

Customer’s home phone

CUSTOMER_EMAIL

varchar

255

√

null

Customers email address

CUSTOMER_POSTAL_ZIP_CODE

varchar

255

√

null

Customer’s zip code

USAGE_DATE

date

√

null

The member check-in date.

USAGE_TIME

time

√

null

The member check-in time.

JOIN_DATE

date

√

null

Membership sale date of the primary member

EXPIRATION_DATE

date

√

null

The expiration date of the membership package.

SUSPEND_FROM_DATE

date

√

null

The date from which the membership package was suspended.

SUSPEND_TO_DATE

date

√

null

The date to which the membership package is suspended.

ENTRYPOINT_ID

int

√

null

ENTRY_POINTS.ENTRYPOINT_ID

Defined in XML

The ID of the entry point where the member checked-in.

ENTRY_POINT

varchar

√

null

The member check-in entry point name.

REASON_DECLINED

varchar

255

√

null

The reason the pass was declined an entry in the facility

CUSTOMERTYPE_ID

int

√

null

ID of customer type description

CUSTOMER_TYPE

varchar

√

null

Customer type description (For example, Employee, Individual, Non-profit)

PASS_NUMBER

varchar

255

√

null

The member’s pass card number.

VOIDED

varchar

255

√

null

Shows whether the usage was voided or not

AKT_IND

varchar

null

The member’s alternate key ID.

LAST_SYNC_TIME

datetime

16,3

null

Date and time Hub record was last modified

ACTIVE_HUB_PROCESS_ID

bigint

√

null

The Hub sync process ID

MEMBERSHIP_ID

int

√

null

MEMBERSHIPS.MEMBERSHIP_ID

Defined in XML

Membership ID

ALTERNATE_KEY_TYPE

varchar

√

null

Alternate key type.

ALTERNATE_KEY_STATUS

varchar

√

null

Alternate key status.

ALTERNATE_KEY_VALUE

varchar

255

√

null

Alternate key ID.

CHECKOUT_DATE

date

√

null

Check out date.

CHECKOUT_TIME

time

√

null

Check out time.

CHECKOUT_ENTRY_POINT_ID

int

√

null

ENTRY_POINTS.ENTRYPOINT_ID

Defined in XML

Check out entry point ID.

CHECKOUT_ENTRY_POINT

varchar

√

null

Check out entry point name.

AUTHORIZED

varchar

√

null

Shows whether the usage was authorized or not

QUANTITY

int

√

null

Shows the usage quantity.

MEMBERSHIPUSAGE_ID

int

√

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

√

null

Your organization’s unique identifier in the Active Net system

PASS_ID

int

√

null

The member’s pass card ID.

ALTERNATE_KEY_TYPE_ID

int

√

null

ALTERNATE_KEY_TYPES.ALTERNATE_KEY_TYPE_ID

Defined in XML

Alternate key type ID

ALTERNATE_KEY_STATUS_ID

int

√

null

ALTERNATE_KEY_STATUSES.ALTERNATE_KEY_STATUS_ID

Defined in XML

Alternate key status ID

POSPRODUCT_ID

int

√

null

POS_PRODUCTS.POSPRODUCT_ID

Defined in XML

The ID of the POS product.

PRODUCT_NAME

varchar

100

√

null

The name of the POS product.

RECEIPT_NUMBER

varchar

√

null

POS receipt number for the drop-in product sale

CUSTOMER_ALTERNATE_KEY_ID

int

√

null

CUSTOMER_ALTERNATE_KEYS.CUSTOMER_ALTERNATE_KEY_ID

Defined in XML

The primary key for the customer alternate key record.

Relationships

Close relationships within degrees of separation

One
Two degrees

View Definition

CREATE   VIEW dbo.MEMBERSHIP_USAGE 
AS 
SELECT 
    src.ACTIVE_HUB_KEY,
    src.PACKAGE_ID,
    pa1.PACKAGE_NAME AS PACKAGE,
    pa1.CATEGORY_ID AS PACKAGECATEGORY_ID,
    pc1.CATEGORY_NAME AS PACKAGE_CATEGORY,
    src.SITE_ID,
    si1.SITE_NAME AS SITE,
    src.MEMBER_SINCE_DATE,
    src.CUSTOMER_ID,
    CONCAT(cu1.CUSTOMER_FIRST_NAME, IIF(cu1.CUSTOMER_FIRST_NAME IS NOT NULL AND cu1.CUSTOMER_LAST_NAME IS NOT NULL, ' ', ''), cu1.CUSTOMER_LAST_NAME) AS MEMBER_NAME,
    cu1.CUSTOMER_FIRST_NAME AS MEMBER_FIRST_NAME,
    cu1.CUSTOMER_LAST_NAME AS MEMBER_LAST_NAME,
    cu1.DATE_OF_BIRTH,
    cu1.CUSTOMER_ADDRESS1 AS ADDRESS,
    cu1.CITY AS CUSTOMER_CITY,
    cu1.STATE_PROVINCE AS CUSTOMER_PROV_STATE,
    cu1.HOMEPHONE AS CUSTOMER_HOME_PHONE,
    cu1.CUSTOMER_EMAIL,
    cu1.ZIP_POSTALCODE AS CUSTOMER_POSTAL_ZIP_CODE,
    src.USAGE_DATE,
    src.USAGE_TIME,
    src.JOIN_DATE,
    src.EXPIRATION_DATE,
    src.SUSPEND_FROM_DATE,
    src.SUSPEND_TO_DATE,
    src.ENTRYPOINT_ID,
    ep2.ENTRY_POINT_NAME AS ENTRY_POINT,
    src.REASON_DECLINED,
    cu1.CUSTOMER_TYPE_ID AS CUSTOMERTYPE_ID,
    ct1.CUSTOMER_TYPE_NAME AS CUSTOMER_TYPE,
    src.PASS_NUMBER,
    src.VOIDED,
    (CASE WHEN src.CUSTOMER_ALTERNATE_KEY_ID IS NOT NULL THEN 'Yes' ELSE 'No' END) AS AKT_IND,
    src.LAST_SYNC_TIME,
    src.ACTIVE_HUB_PROCESS_ID,
    src.MEMBERSHIP_ID,
    ak2.ALTERNATE_KEY_TYPE,
    ak1.ALTERNATE_KEY_STATUS,
    cak.ALTERNATE_KEY_VALUE,
    src.CHECKOUT_DATE,
    src.CHECKOUT_TIME,
    src.CHECKOUT_ENTRY_POINT_ID,
    ep1.ENTRY_POINT_NAME AS CHECKOUT_ENTRY_POINT,
    src.AUTHORIZED,
    src.QUANTITY,
    src.MEMBERSHIPUSAGE_ID,
    src.ORG_ID,
    src.PASS_ID,
    cak.ALTERNATE_KEY_TYPE_ID,
    cak.ALTERNATE_KEY_STATUS_ID,
    src.POSPRODUCT_ID,
    ppr.PRODUCT_NAME,
    src.RECEIPT_NUMBER,
    src.CUSTOMER_ALTERNATE_KEY_ID
FROM 
    hub.MEMBERSHIP_USAGE src
    LEFT JOIN hub.CUSTOMERS cu1 ON (cu1.CUSTOMER_ID = src.CUSTOMER_ID)
    LEFT JOIN hub.CUSTOMER_ALTERNATE_KEYS cak ON (cak.CUSTOMER_ALTERNATE_KEY_ID = src.CUSTOMER_ALTERNATE_KEY_ID)
    LEFT JOIN hub.ALTERNATE_KEY_STATUSES ak1 ON (ak1.ALTERNATE_KEY_STATUS_ID = cak.ALTERNATE_KEY_STATUS_ID)
    LEFT JOIN hub.ALTERNATE_KEY_TYPES ak2 ON (ak2.ALTERNATE_KEY_TYPE_ID = cak.ALTERNATE_KEY_TYPE_ID)
    LEFT JOIN hub.ENTRY_POINTS ep1 ON (ep1.ENTRYPOINT_ID = src.CHECKOUT_ENTRY_POINT_ID)
    LEFT JOIN hub.ENTRY_POINTS ep2 ON (ep2.ENTRYPOINT_ID = src.ENTRYPOINT_ID)
    LEFT JOIN hub.PACKAGES pa1 ON (pa1.PACKAGE_ID = src.PACKAGE_ID)
    LEFT JOIN hub.PACKAGE_CATEGORIES pc1 ON (pc1.PACKAGE_CATEGORY_ID = pa1.CATEGORY_ID)
    LEFT JOIN hub.SITES si1 ON (si1.SITE_ID = src.SITE_ID)
    LEFT JOIN hub.POS_PRODUCTS ppr ON (ppr.POSPRODUCT_ID = src.POSPRODUCT_ID)
    LEFT JOIN hub.CUSTOMER_TYPES ct1 ON (ct1.CUSTOMER_TYPE_ID = cu1.CUSTOMER_TYPE_ID);

Description

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views