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 |
|
| CHARGE_NAME | varchar | 50 | √ | null |
|
|
Scholarship charge name |
|
| SITE_ID | int | 4 | √ | null |
|
|
Site ID |
|
| SITE_NAME | varchar | 255 | √ | null |
|
|
The site to which the scholarship charge belongs |
|
| SCHOLARSHIP_TYPE | varchar | 10 | √ | null |
|
|
The type of scholarship (Individual / Family) |
|
| DISCOUNT_TYPE | varchar | 10 | √ | null |
|
|
The type of discount (Amount / Percent) |
|
| DISCOUNT_PERCENT | money | 21,4 | √ | null |
|
|
The default discount percentage |
|
| DISCOUNT_AMOUNT | money | 21,4 | √ | null |
|
|
The default discount amount |
|
| DISCOUNT_UNITOFMEASURE | varchar | 40 | √ | null |
|
|
The default unit of measure for the amount |
|
| DISCOUNT_PER_MODULE | varchar | 5 | √ | null |
|
|
Whether the percent or amount of the scholarship may differ per module (Yes / No) |
|
| MEMBERSHIP_PERCENT | money | 21,4 | √ | null |
|
|
The default discount percentage for memberships |
|
| MEMBERSHIP_AMOUNT | money | 21,4 | √ | null |
|
|
The default discount amount for memberships |
|
| ACTIVITY_PERCENT | money | 21,4 | √ | null |
|
|
The default discount percentage for activities |
|
| ACTIVITY_AMOUNT | money | 21,4 | √ | null |
|
|
The default discount amount for activities |
|
| PROGRAM_DISCOUNT | money | 21,4 | √ | null |
|
|
The default discount percentage for programs |
|
| PROGRAM_AMOUNT | money | 21,4 | √ | null |
|
|
The default discount amount for programs |
|
| PROGRAM_UNITOFMEASURE | varchar | 40 | √ | null |
|
|
The default unit of measure for the amount for programs |
|
| START_DATE | date | 20 | √ | null |
|
|
The first available date for this scholarship |
|
| EXPIRATION_DATE | date | 20 | √ | null |
|
|
The last available date for this scholarship |
|
| OPENING_BALANCE | money | 21,4 | √ | null |
|
|
The opening balance of the scholarship fund (if not unlimited) |
|
| UNLIMITED_BALANCE | varchar | 5 | √ | null |
|
|
Whether the scholarship fund has an unlimited balance (Yes / No) |
|
| AWARD_AT_ENROLLMENT | varchar | 5 | √ | null |
|
|
Whether this scholarship is awarded at time of enrollment (Yes / No) |
|
| GLACCOUNT_ID | int | 4 | √ | null |
|
|
The default GL account ID to post this scholarship to |
|
| GL_ACCOUNT_NAME | varchar | 200 | √ | null |
|
|
GL account name |
|
| GL_ACCOUNT_NUMBER | varchar | 200 | √ | null |
|
|
GL account number |
|
| DISABLE_SCHOLARSHIP_AFTER_FIRST_USE | varchar | 5 | √ | null |
|
|
Whether the scholarship should be disabled after the first use (Yes / No) |
|
| OPENING_BALANCE_USE_SUM_OF_DONATED | varchar | 5 | √ | null |
|
|
Whether the opening balance of this scholarship should be the sum of the donated amounts (Yes / No) |
|
| TREAT_DISCOUNT_AS_PAYMENT | varchar | 5 | √ | null |
|
|
Whether the scholarship discount should be treated as a payment (Yes / No) |
|
| FUND_SCHOLARSHIP_FROM_CAMPAIGN | varchar | 5 | √ | null |
|
|
Whether the scholarship should be funded from a campaign (Yes / No) |
|
| PREFILL_CONDITION | varchar | 20 | √ | null |
|
|
The prefill condition for this charge (Never / Always / If Resident / If Non-resident / If Minor / If Senior / If Internet / If Member / If Non-member) |
|
| OVERRIDE_FLAG | varchar | 20 | √ | null |
|
|
Whether this charge can be overridden (Always / Never / By Password) |
|
| ADD_TO_NEW_ACTIVITY | varchar | 5 | √ | null |
|
|
Whether this charge should automatically be added as a fee on new activities (Yes / No) |
|
| TRIAL_CLASS_FEE | varchar | 5 | √ | null |
|
|
Whether this charge can be a trial class fee (Yes / No) |
|
| CUSTOMER_TYPE_ID | int | 4 | √ | null |
|
|
The customer type ID that this charge applies to |
|
| CUSTOMER_TYPE | varchar | 60 | √ | null |
|
|
The customer type that this charge applies to |
|
| SEASON_ID | int | 4 | √ | null |
|
|
The season ID that the scholarship is available for |
|
| SEASON | varchar | 40 | √ | null |
|
|
The season that the scholarship is available for |
|
| CHILD_SEASON_ID | int | 4 | √ | null |
|
|
The child season ID that the scholarship is available for |
|
| CHILD_SEASON | varchar | 40 | √ | null |
|
|
The child season that the scholarship is available for |
|
| RETIRED | varchar | 5 | √ | null |
|
|
Whether this scholarship charge has been retired (Yes / No) |
|
| 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 |