Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| ACTIVE_HUB_KEY | int identity | 4 | √ | null |
|
|
The Hub record ID |
||||
| CHARGE_ID | int | 4 | √ | null |
|
|
Scholarship charge ID |
||||
| CUSTOMER_ID | int | 4 | √ | null |
|
|
Scholarship customer ID |
||||
| FAMILY_ID | int | 4 | √ | null |
|
|
Scholarship family ID |
||||
| AMOUNT | money | 21,4 | √ | null |
|
|
Qualification amount |
||||
| PERCENTAGE | money | 21,4 | √ | null |
|
|
Qualification percentage |
||||
| UNIT_OF_MEASURE | varchar | 10 | √ | null |
|
|
Qualification unit of measure for daycare programs |
||||
| QUALIFY_TYPE_ID | int | 4 | √ | null |
|
|
Qualification type ID (1: All Activities, 2: Individual Activities, 3: By Activity Department, 4: By Activity Category, 5: By Activity Sub-Category, 6: By Activity Group Number, 7: No Programs, 8: All Programs, 9: Individual Programs, 10: By Program Type, 11: By Program Group Number, 12: No Packages, 13: AllPackages, 14: Individual Packages, 15: By Package Category, 16: No Activities) |
||||
| QUALIFY_TYPE_NAME | varchar | 40 | √ | null |
|
|
Qualification type name (No Activities / All Activities / Individual Activities / By Activity Department / By Activity Category / By Activity Sub-Category / By Activity Group Number / No Programs / All Programs / Individual Programs / By Program Type / By Program Group Number / No Packages / All Packages / Individual Packages / By Package Category) |
||||
| ACTIVITY_ID | int | 4 | √ | null |
|
|
Qualified activity ID |
||||
| ACTIVITY_DEPARTMENT_ID | int | 4 | √ | null |
|
|
Qualified activity department ID |
||||
| ACTIVITY_CATEGORY_ID | int | 4 | √ | null |
|
|
Qualified activity category ID |
||||
| ACTIVITY_SUB_CATEGORY_ID | int | 4 | √ | null |
|
|
Qualified activity subcategory ID |
||||
| ACTIVITY_GROUP_NUMBER | varchar | 255 | √ | null |
|
|
Qualified activity group number |
||||
| PROGRAM_ID | int | 4 | √ | null |
|
|
Qualified program ID |
||||
| PROGRAM_TYPE_ID | int | 4 | √ | null |
|
|
Qualified program type ID |
||||
| PROGRAM_GROUP_NUMBER | varchar | 255 | √ | null |
|
|
Qualified program group number |
||||
| PACKAGE_ID | int | 4 | √ | null |
|
|
Qualified membership package ID |
||||
| PACKAGE_CATEGORY_ID | int | 4 | √ | null |
|
|
Qualified membership package category ID |
||||
| CUSTOMER_SCHOLARSHIP_DISCOUNT_ID | int | 4 | √ | null |
|
|
Customer scholarship discount ID (for internal use) |
||||
| CUSTOMER_SCHOLARSHIP_RESTRICTION_ID | int | 4 | √ | null |
|
|
Customer scholarship restriction ID (for internal use) |
||||
| SCHOLARSHIP_QUALIFICATION_ID | bigint | 8 | √ | null |
|
|
Qualification ID for linking to the customer scholarships |
||||
| 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 |
||||
| ROW_VERSION | binary | 8 | √ | null |
|
|
System timestamp (for internal use) |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| CUSTOMER_SCHOLARSHIP_QUALIFICATIONS_ACTIVE_HUB_KEY_PK | Primary key | Asc | ACTIVE_HUB_KEY |
| CUSTOMER_SCHOLARSHIP_QUALIFICATIONS_ACTIVITY_CATEGORY_ID_IX | Performance | Asc | ACTIVITY_CATEGORY_ID |
| CUSTOMER_SCHOLARSHIP_QUALIFICATIONS_ACTIVITY_DEPARTMENT_ID_IX | Performance | Asc | ACTIVITY_DEPARTMENT_ID |
| CUSTOMER_SCHOLARSHIP_QUALIFICATIONS_ACTIVITY_ID_IX | Performance | Asc | ACTIVITY_ID |
| CUSTOMER_SCHOLARSHIP_QUALIFICATIONS_ACTIVITY_SUB_CATEGORY_ID_IX | Performance | Asc | ACTIVITY_SUB_CATEGORY_ID |
| CUSTOMER_SCHOLARSHIP_QUALIFICATIONS_CHARGE_ID_IX | Performance | Asc | CHARGE_ID |
| CUSTOMER_SCHOLARSHIP_QUALIFICATIONS_CUSTOMER_ID_IX | Performance | Asc | CUSTOMER_ID |
| CUSTOMER_SCHOLARSHIP_QUALIFICATIONS_CUSTOMER_SCHOLARSHIP_DISCOUNT_ID_ORG_ID_IX | Performance | Asc/Asc | CUSTOMER_SCHOLARSHIP_DISCOUNT_ID + ORG_ID |
| CUSTOMER_SCHOLARSHIP_QUALIFICATIONS_CUSTOMER_SCHOLARSHIP_RESTRICTION_ID_ORG_ID_IX | Performance | Asc/Asc | CUSTOMER_SCHOLARSHIP_RESTRICTION_ID + ORG_ID |
| CUSTOMER_SCHOLARSHIP_QUALIFICATIONS_FAMILY_ID_IX | Performance | Asc | FAMILY_ID |
| CUSTOMER_SCHOLARSHIP_QUALIFICATIONS_PACKAGE_CATEGORY_ID_IX | Performance | Asc | PACKAGE_CATEGORY_ID |
| CUSTOMER_SCHOLARSHIP_QUALIFICATIONS_PACKAGE_ID_IX | Performance | Asc | PACKAGE_ID |
| CUSTOMER_SCHOLARSHIP_QUALIFICATIONS_PROGRAM_ID_IX | Performance | Asc | PROGRAM_ID |
| CUSTOMER_SCHOLARSHIP_QUALIFICATIONS_PROGRAM_TYPE_ID_IX | Performance | Asc | PROGRAM_TYPE_ID |
| CUSTOMER_SCHOLARSHIP_QUALIFICATIONS_QUALIFY_TYPE_ID_IX | Performance | Asc | QUALIFY_TYPE_ID |
| CUSTOMER_SCHOLARSHIP_QUALIFICATIONS_ROW_VERSION_IX | Performance | Asc | ROW_VERSION |
| CUSTOMER_SCHOLARSHIP_QUALIFICATIONS_SCHOLARSHIP_QUALIFICATION_ID_IX | Performance | Asc | SCHOLARSHIP_QUALIFICATION_ID |