Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ORG_ID | int | 4 | null |
|
|
Your organization’s unique identifier in the Active Net system |
||
| SITE_ID | int | 4 | √ | null |
|
|
The site ID of the membership package |
|
| PACKAGE_ID | int | 4 | √ | null |
|
|
The ID of the membership package |
|
| PACKAGE_CATEGORY_ID | int | 4 | √ | null |
|
|
Package category ID |
|
| 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. |
|
| CUSTOMER_AGE | int | 4 | √ | null |
|
|
Primary member customer age in years |
|
| CUST_TRAN_COUNT | int | 4 | √ | null |
|
|
Pass-holder non-memberships transactions |
|
| CUSTOMER_DISTANCE | numeric | 21,6 | √ | null |
|
|
Primary member customer distance from membership package site |
|
| DAYS_SINCE_USED | int | 4 | √ | null |
|
|
Days since membership last used |
|
| MEMBERSHIP_AGE | int | 4 | √ | null |
|
|
Membership age in days |
|
| PACKAGE_PERIOD | int | 4 | √ | null |
|
|
Package period in days |
|
| PASS_COUNT | int | 4 | √ | null |
|
|
Number of passes assigned to membership |
|
| RENEWAL_COUNT | int | 4 | √ | null |
|
|
Number of renewals of membership |
|
| USAGE_COUNT | int | 4 | √ | null |
|
|
Number of membership usages of membership |
|
| IS_FAMILY_MEMBERSHIP | varchar | 3 | null |
|
|
Is the membership a family membership? |
||
| IS_SALE_DISCOUNTED | varchar | 3 | null |
|
|
Was memebership discounted at sale? |
||
| UNIT_FEE | money | 21,4 | √ | null |
|
|
Unit price of membership |
|
| AS_OF | datetime | 16,3 | √ | null |
|
|
Date used to compute RETENTION_SCORE |
|
| MEMBERSHIP_TYPE | varchar | 25 | √ | null |
|
|
Type of membership for scoring (auto_renewal, retention_eligible) |
|
| MEMBERSHIP_AUTORENEWAL_TYPE | varchar | 19 | null |
|
|
Type of auto-renewal for membership at time of scoring - Not auto renewed - By credit card - By EFT - By manual deduction - By payment plan |
||
| DAYS_SINCE_TRAN | int | 4 | √ | null |
|
|
Days since a non-membership Transaction for all pass holders |
|
| CREATED_DT | datetime | 16,3 | null |
|
|
Date membership risk was first calculated |
||
| CAPTURE_DT | datetime | 16,3 | null |
|
|
The date when record is captured or refreshed |
||
| RISK_CATEGORY | varchar | 25 | null |
|
|
Predicted CLASSification of membership renewal independent of RETENTION_SCORE (Risk, Retain) |
||
| RETENTION_SCORE | numeric | 21,6 | √ | null |
|
|
Predicted likelyhood of membership being renewed (0 = least likely, 100 = most likely) |
|
| REASON_1 | nvarchar | 8000 | √ | null |
|
|
In order of importance, the first reason that this membership is at risk |
|
| REASON_2 | nvarchar | 8000 | √ | null |
|
|
In order of importance, the second reason that this membership is at risk |
|
| REASON_3 | nvarchar | 8000 | √ | null |
|
|
In order of importance, the third reason that this membership is at risk |
|
| REASON_4 | nvarchar | 8000 | √ | null |
|
|
In order of importance, the fourth reason that this membership is at risk |