Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ACTIVE_HUB_KEY | int identity | 4 | √ | null |
|
|
The dbo record ID |
|
| 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 |
||
| 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 |
|
| IS_SALE_DISCOUNTED | int | 4 | √ | null |
|
|
Was memebership discounted at sale? |
|
| UNIT_FEE | money | 21,4 | √ | null |
|
|
Unit price of membership |
|
| 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 | int | 4 | √ | null |
|
|
Is the membership a family membership? |
|
| MEMBERSHIP_TYPE | varchar | 25 | √ | null |
|
|
Type of membership for scoring (auto_renewal, retention_eligible) |
|
| AUTO_RENEWAL_TYPE | smallint | 2 | √ | 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 |
|
| AS_OF | datetime | 16,3 | √ | null |
|
|
Date used to compute RETENTION_SCORE |
|
| MODEL_NAME | varchar | 50 | √ | null |
|
|
||
| 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) |
|
| RISK_FACTOR_REASONS | nvarchar | 4000 | √ | null |
|
|
if risk category is risk, there would be some additional reason to explian the status |
|
| CAPTURE_DT | datetime | 16,3 | null |
|
|
The date when record is captured or refreshed |
||
| CREATED_DT | datetime | 16,3 | null |
|
|
Date membership risk was first calculated |
||
| ROW_VERSION | binary | 8 | √ | null |
|
|
System timestamp (for internal use) |
|
| LAST_SYNC_TIME | datetime | 16,3 | (getdate()) |
|
|
Date and time dbo record was last modified |
||
| ACTIVE_HUB_PROCESS_ID | bigint | 8 | √ | null |
|
|
The dbo sync process ID |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_MEMBERSHIP_RISK | Primary key | Asc/Asc | ORG_ID + MEMBERSHIP_ID |