Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| ACTIVE_HUB_KEY | int | 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_NUMBER | varchar | 20 | √ | null |
|
|
Qualified activity number |
||||
| ACTIVITY_NAME | varchar | 100 | √ | null |
|
|
Qualified activity name |
||||
| ACTIVITY_DEPARTMENT_ID | int | 4 | √ | null |
|
|
Qualified activity department ID |
||||
| ACTIVITY_DEPARTMENT_NAME | varchar | 40 | √ | null |
|
|
Qualified activity department name |
||||
| ACTIVITY_CATEGORY_ID | int | 4 | √ | null |
|
|
Qualified activity category ID |
||||
| ACTIVITY_CATEGORY_NAME | varchar | 80 | √ | null |
|
|
Qualified activity category name |
||||
| ACTIVITY_SUB_CATEGORY_ID | int | 4 | √ | null |
|
|
Qualified activity subcategory ID |
||||
| ACTIVITY_SUB_CATEGORY_NAME | varchar | 40 | √ | null |
|
|
Qualified activity subcategory name |
||||
| ACTIVITY_GROUP_NUMBER | varchar | 255 | √ | null |
|
|
Qualified activity group number |
||||
| PROGRAM_ID | int | 4 | √ | null |
|
|
Qualified program ID |
||||
| PROGRAM_NAME | varchar | 255 | √ | null |
|
|
Qualified program name |
||||
| PROGRAM_TYPE_ID | int | 4 | √ | null |
|
|
Qualified program type ID |
||||
| PROGRAM_TYPE_NAME | varchar | 30 | √ | null |
|
|
Qualified program type name |
||||
| PROGRAM_GROUP_NUMBER | varchar | 255 | √ | null |
|
|
Qualified program group number |
||||
| PACKAGE_ID | int | 4 | √ | null |
|
|
Qualified membership package ID |
||||
| PACKAGE_NAME | varchar | 255 | √ | null |
|
|
Qualified membership package name |
||||
| PACKAGE_CATEGORY_ID | int | 4 | √ | null |
|
|
Qualified membership package category ID |
||||
| PACKAGE_CATEGORY_NAME | varchar | 50 | √ | null |
|
|
Qualified membership package category name |
||||
| 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 | null |
|
|
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 |