Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| ACTIVE_HUB_KEY | int identity | 4 | √ | null |
|
|
The Hub record ID |
||||
| PRELIMINARY_DRAFT_ID | int | 4 | √ | null |
|
|
The preliminary draft ID |
||||
| DRAFT_DATE | date | 20 | √ | null |
|
|
The expected renewal date for the membership |
||||
| MEMBERSHIP_ID | int | 4 | √ | null |
|
|
The ID of the membership to be renewed |
||||
| PACKAGE_ID | int | 4 | √ | null |
|
|
The ID of the package for the membership to be renewed |
||||
| MEMBERSHIP_EXPIRES_DATE | date | 20 | √ | null |
|
|
The current expiration date of the membership |
||||
| AMOUNT_NOT_INCLUDING_DISCOUNTS | money | 21,4 | √ | null |
|
|
The expected renewal amount excluding any discounts that may be applied |
||||
| AMOUNT_OF_SCHOLARSHIPS | money | 21,4 | √ | null |
|
|
The expected amount of scholarships to be applied at time of renewal |
||||
| AMOUNT_OF_DISCOUNTS | money | 21,4 | √ | null |
|
|
The expected amount of discounts to be applied at time of renewal |
||||
| AMOUNT_OF_USAGE_FEES | money | 21,4 | √ | null |
|
|
The expected amount of usage fees to be applied at time of renewal |
||||
| AMOUNT_OF_THIRD_PARTY_BILLINGS | money | 21,4 | √ | null |
|
|
The expected amount of third party billings to be applied at time of renewal |
||||
| PAYER_CUSTOMER_ID | int | 4 | √ | null |
|
|
The ID of customer to be set as payer for the renewal charges |
||||
| PAYER_COMPANY_ID | int | 4 | √ | null |
|
|
The ID of company to be set as payer for the renewal charges |
||||
| AUTOMATIC_RENEWAL_TYPE | varchar | 20 | √ | null |
|
|
The payment method selected for the auto-renewal of the membership (Not Auto-Renewed / Credit Card / ECP / Manual Deduction / Payment Plan) |
||||
| CARD_TYPE_ID | int | 4 | √ | null |
|
|
The card type ID of credit card to be used for the membership renewal payment |
||||
| CARD_NUMBER | varchar | 10 | √ | null |
|
|
The masked credit card number to be used for the membership renewal payment |
||||
| CARD_EXPIRATION | varchar | 10 | √ | null |
|
|
The credit card expiration date (mm/yyyy) to be used for the membership renewal payment |
||||
| BANK_ACCOUNT_NUMBER | varchar | 10 | √ | null |
|
|
The masked bank account number to be used for the membership renewal payment |
||||
| REVENUE_SITE_ID | int | 4 | √ | null |
|
|
The site ID that the membership renewal revenue will be posted to |
||||
| IS_ERROR_EXPECTED | varchar | 5 | √ | null |
|
|
Whether an error is expected for this membership renewal (Yes/No) |
||||
| ERROR_DESCRIPTION | varchar | 2000 | √ | null |
|
|
The error message that is expected for this membership renewal |
||||
| UPDATED_DATE_TIME | datetime | 16,3 | √ | null |
|
|
The date and time that this membership draft was generated |
||||
| ROW_VERSION | binary | 8 | √ | null |
|
|
System timestamp (for internal use) |
||||
| 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 |
||||
| ORG_ID | int | 4 | √ | null |
|
|
Your organization’s unique identifier in the Active Net system |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRELIMINARY_DRAFTS_ACTIVE_HUB_KEY_PK | Primary key | Asc | ACTIVE_HUB_KEY |
| PRELIMINARY_DRAFTS_CARD_TYPE_ID_IX | Performance | Asc | CARD_TYPE_ID |
| PRELIMINARY_DRAFTS_MEMBERSHIP_ID_IX | Performance | Asc | MEMBERSHIP_ID |
| PRELIMINARY_DRAFTS_ORG_ID_IX | Performance | Asc | ORG_ID |
| PRELIMINARY_DRAFTS_PACKAGE_ID_IX | Performance | Asc | PACKAGE_ID |
| PRELIMINARY_DRAFTS_PAYER_COMPANY_ID_IX | Performance | Asc | PAYER_COMPANY_ID |
| PRELIMINARY_DRAFTS_PAYER_CUSTOMER_ID_IX | Performance | Asc | PAYER_CUSTOMER_ID |
| PRELIMINARY_DRAFTS_PRELIMINARY_DRAFT_ID_ORG_ID_UQ | Must be unique | Asc/Asc | PRELIMINARY_DRAFT_ID + ORG_ID |
| PRELIMINARY_DRAFTS_REVENUE_SITE_ID_IX | Performance | Asc | REVENUE_SITE_ID |
| PRELIMINARY_DRAFTS_ROW_VERSION_IX | Performance | Asc | ROW_VERSION |