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 |
||
| 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) |
||
| scores | int | 4 | √ | null |
|
|
Number of memberships scored |
|
| score_MIN | numeric | 21,6 | √ | null |
|
|
Minimum retention score |
|
| score_MAX | numeric | 21,6 | √ | null |
|
|
Maximum retention score |
|
| score_AVG | numeric | 21,6 | √ | null |
|
|
Average retention score |
|
| score_STDEV | numeric | 21,6 | √ | null |
|
|
Standard deviation of retention scores |
|
| model_intercept | numeric | 21,6 | √ | null |
|
|
Intercept from model used to predict retention score |
|
| factors | nvarchar | 1073741823 | √ | null |
|
|
Predictors used to build models |
|
| score_red_top_bnd | numeric | 21,6 | √ | null |
|
|
Upper level score for bucket = Red membership group (average less one standard deviation) |
|
| score_yellow_top_bnd | numeric | 21,6 | √ | null |
|
|
Upper level score for bucket = Yellow membership group (average plus one standard deviation) |
|
| capture_dt | datetime | 16,3 | √ | null |
|
|
Date membership retention scoring was completed |
|
| 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 |
|
| row_version | binary | 8 | √ | null |
|
|
System timestamp (for internal use) |
|
| classifier | nvarchar | 2048 | √ | null |
|
|
Class used for membership risk classification |
|
| regressor | nvarchar | 2048 | √ | null |
|
|
Class used for membership risk scoring |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| MEMBERSHIP_RISK_STATS_PK | Primary key | Asc/Asc/Asc | ORG_ID + as_of + membership_type |
| MEMBERSHIP_RISK_STATS_ROW_VERSION_IX | Performance | Asc | row_version |