Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ACTIVE_HUB_KEY | int identity | 4 | √ | null |
|
|
||
| ORG_ID | int | 4 | null |
|
|
Id of the parent organization of membership |
||
| MEMBERSHIP_ID | int | 4 | null |
|
|
The ID of the membership that the customer is associated with. |
||
| CUSTOMER_ID | int | 4 | null |
|
|
The ID for the primary member |
||
| PACKAGE_ID | int | 4 | null |
|
|
The ID of the most recent package for the customer on the membership. |
||
| PASS_ID | int | 4 | null |
|
|
The ID of the most recent pass for the customer on the membership. Historical data will have the value (0). |
||
| PASSNUMBER | varchar | 30 | null |
|
|
The most recent pass number for the customer on the membership. Historical data will be empty. |
||
| VALID_PASS | bit | 1 | null |
|
|
Does customer currently have a pass associated to the membership? |
||
| VALID_FROM | datetime | 16,3 | null |
|
|
When the customer was first associated to the memebership |
||
| VALID_TO | datetime | 16,3 | null |
|
|
Expiration date of the membership or the date the customer was no longer associated with the membership |
||
| BEG_DATESTAMP | datetime | 16,3 | √ | null |
|
|
The start datetime when the customer was first associated to the memebership |
|
| END_DATESTAMP | datetime | 16,3 | √ | null |
|
|
The end datetime of the membership or the datetime the customer was no longer associated with the membership |
|
| ROW_VERSION_FROM | binary | 8 | null |
|
|
|||
| ROW_VERSION | binary | 8 | null |
|
|
|||
| PROCESSED_DATE | datetime | 16,3 | null |
|
|
Date and time record was processed |
||
| LAST_SYNC_TIME | datetime | 16,3 | (getdate()) |
|
|
|||
| ACTIVE_HUB_PROCESS_ID | bigint | 8 | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| MEMBERSHIP_CUSTOMER_PACKAGE_HISTORY_ORG_ID_MEMBERSHIP_ID_CUSTOMER_ID_PASS_ID_PK | Primary key | Asc/Asc/Asc/Asc/Asc | ORG_ID + MEMBERSHIP_ID + CUSTOMER_ID + PASS_ID + VALID_FROM |
| MEMBERSHIP_CUSTOMER_PACKAGE_HISTORY_ACTIVE_HUB_KEY_IX | Performance | Asc | ACTIVE_HUB_KEY |
| MEMBERSHIP_CUSTOMER_PACKAGE_HISTORY_ROW_VERSION_IX | Performance | Asc | ROW_VERSION |