Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ACTIVE_HUB_KEY | int identity | 4 | √ | null |
|
|
The Hub record ID |
|||||||
| SCHOLARSHIP_TYPE | varchar | 10 | √ | null |
|
|
The type of scholarship (Individual / Family) |
|||||||
| CHARGE_ID | int | 4 | √ | null |
|
|
Scholarship charge ID |
|||||||
| CUSTOMER_SCHOLARSHIP_ID | int | 4 | √ | null |
|
|
Customer scholarship ID |
|||||||
| CUSTOMER_ID | int | 4 | √ | null |
|
|
Scholarship customer ID |
|||||||
| IS_PRIMARY_CUSTOMER | varchar | 5 | √ | null |
|
|
Whether this is the primary customer for this scholarship (Yes/No) |
|||||||
| FAMILY_ID | int | 4 | √ | null |
|
|
Scholarship family ID |
|||||||
| FAMILYSCHOLARSHIPMEMBERS_ID | int | 4 | √ | null |
|
|
Scholarship family member ID (if no transactions for the member) |
|||||||
| GRANT_DATE | date | 20 | √ | null |
|
|
The first available date for this scholarship |
|||||||
| EXPIRATION_DATE | date | 20 | √ | null |
|
|
The last available date for this scholarship |
|||||||
| SYSTEMUSER_ID | int | 4 | √ | null |
|
|
System user ID who granted the scholarship |
|||||||
| AMOUNT_UNSPECIFIED | varchar | 5 | √ | null |
|
|
Whether the scholarship is for an unspecified amount (Yes/No) |
|||||||
| AWARD_AMOUNT | money | 21,4 | √ | null |
|
|
The amount that was awarded for this scholarship |
|||||||
| AWARDED_AT_ENROLLMENT | varchar | 5 | √ | null |
|
|
Whether this scholarship was awarded at time of enrollment (Yes/No) |
|||||||
| AMOUNT_USED | money | 21,4 | √ | null |
|
|
The amount that has been used for this customer for this scholarship |
|||||||
| 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 |
|||||||
| ACTIVATE_QUALIFYING | varchar | 5 | √ | null |
|
|
Whether qualifications have been activated for this customer scholarship (Yes/No) |
|||||||
| ACTIVITY_QUALIFY_TYPE_ID | int | 4 | √ | null |
|
|
The activity qualification type ID (16: No Activities, 1: All Activities, 2: Individual Activities, 3: By Activity Department, 4: By Activity Category, 5: By Activity Sub-Category, 6: By Activity Group Number) |
|||||||
| ACTIVITY_QUALIFY_TYPE_NAME | varchar | 40 | √ | null |
|
|
The activity qualification type name (No Activities / All Activities / Individual Activities / By Activity Department / By Activity Category / By Activity Sub-Category / By Activity Group Number) |
|||||||
| PROGRAM_QUALIFY_TYPE_ID | int | 4 | √ | null |
|
|
The program qualification type ID (7: No Programs, 8: All Programs, 9: Individual Programs, 10: By Program Type, 11: By Program Group Number) |
|||||||
| PROGRAM_QUALIFY_TYPE_NAME | varchar | 40 | √ | null |
|
|
The program qualification type name (No Programs / All Programs / Individual Programs / By Program Type / By Program Group Number) |
|||||||
| PACKAGE_QUALIFY_TYPE_ID | int | 4 | √ | null |
|
|
The package qualification type ID (12: No Packages, 13: All Packages, 14: Individual Packages, 15: By Package Category) |
|||||||
| PACKAGE_QUALIFY_TYPE_NAME | varchar | 40 | √ | null |
|
|
The package qualification type name (No Packages / All Packages / Individual Packages / By Package Category) |
|||||||
| SCHOLARSHIP_QUALIFICATION_ID | bigint | 8 | √ | null |
|
|
Qualification ID for linking to the customer scholarship qualifications |
|||||||
| ROW_VERSION | binary | 8 | √ | null |
|
|
System timestamp (for internal use) |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| CUSTOMER_SCHOLARSHIPS_ACTIVE_HUB_KEY_PK | Primary key | Asc | ACTIVE_HUB_KEY |
| CUSTOMER_SCHOLARSHIPS_ACTIVITY_QUALIFY_TYPE_ID_IX | Performance | Asc | ACTIVITY_QUALIFY_TYPE_ID |
| CUSTOMER_SCHOLARSHIPS_CHARGE_ID_IX | Performance | Asc | CHARGE_ID |
| CUSTOMER_SCHOLARSHIPS_CUSTOMER_ID_IX | Performance | Asc | CUSTOMER_ID |
| CUSTOMER_SCHOLARSHIPS_CUSTOMER_SCHOLARSHIP_ID_ORG_ID_IX | Performance | Asc/Asc | CUSTOMER_SCHOLARSHIP_ID + ORG_ID |
| CUSTOMER_SCHOLARSHIPS_FAMILYSCHOLARSHIPMEMBERS_ID_IX | Performance | Asc | FAMILYSCHOLARSHIPMEMBERS_ID |
| CUSTOMER_SCHOLARSHIPS_ORG_ID_2_IX | Performance | Asc | ORG_ID |
| CUSTOMER_SCHOLARSHIPS_ORG_ID_IX | Performance | Asc | ORG_ID |
| CUSTOMER_SCHOLARSHIPS_PACKAGE_QUALIFY_TYPE_ID_IX | Performance | Asc | PACKAGE_QUALIFY_TYPE_ID |
| CUSTOMER_SCHOLARSHIPS_PROGRAM_QUALIFY_TYPE_ID_IX | Performance | Asc | PROGRAM_QUALIFY_TYPE_ID |
| CUSTOMER_SCHOLARSHIPS_ROW_VERSION_IX | Performance | Asc | ROW_VERSION |
| CUSTOMER_SCHOLARSHIPS_SCHOLARSHIP_QUALIFICATION_ID_IX | Performance | Asc | SCHOLARSHIP_QUALIFICATION_ID |
| CUSTOMER_SCHOLARSHIPS_SYSTEMUSER_ID_IX | Performance | Asc | SYSTEMUSER_ID |