Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| AUDIT_DATE | date | 20 | √ | null |
|
|
The date that the statistics have been generated for |
|
| ORG_ID | int | 4 | √ | null |
|
|
||
| SITE_ID | int | 4 | √ | null |
|
|
The ID of the site to which this package belongs |
|
| SITE_NAME | varchar | 255 | √ | null |
|
|
The name of the site to which this package belongs |
|
| MEMBERSHIP_ID | int | 4 | √ | null |
|
|
the membership_id |
|
| PRIMARY_MEMBER_CUSTOMER_ID | int | 4 | √ | null |
|
|
The primary customer ID to which the membership package is assigned. |
|
| PACKAGE_ID | int | 4 | √ | null |
|
|
The package ID of the customers membership. |
|
| PACKAGE_NAME | varchar | 255 | √ | null |
|
|
The package name of the customers membership. |
|
| CATEGORY_ID | int | 4 | √ | null |
|
|
Package Category ID of the membership package. |
|
| CATEGORY_NAME | varchar | 50 | √ | null |
|
|
Package Category of the membership package. |
|
| PASS_COUNT | int | 4 | √ | null |
|
|
The count of active membership passes |
|
| IS_RESIDENT | varchar | 3 | null |
|
|
Customer’s resident status. |
||
| IS_RETENTION_ELIGIBLE | varchar | 5 | √ | null |
|
|
Whether packages of this category should have retention eligibility. |
|
| IS_SUSPENDED | varchar | 3 | null |
|
|
Whether membership is suspended as of the end of the audit date |