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 |
|
|
|||
| LAST_SYNC_TIME | datetime | 16,3 | null |
|
|
|||
| ACTIVE_HUB_PROCESS_ID | bigint | 8 | null |
|
|