ACTIVITY_FEES

0 rows


Description

Master table showing defined activity fees data

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ACTIVE_HUB_KEY int identity 4 √ null

The Hub record ID
ACTIVITY_FEE_ID int 4 √ null
CHARGE_QUALIFICATION_LINKS.ACTIVITY_FEE_ID Defined in XML R
SCHEDULED_FEE_CHANGES.ACTIVITY_FEE_ID Defined in XML R

Activity fee ID
ACTIVITY_ID int 4 √ null
ACTIVITIES.ACTIVITY_ID Defined in XML R

Activity ID which this fee belongs to
CHARGE_ID int 4 √ null
CHARGES.CHARGE_ID Defined in XML R

Charge ID
CHARGE_NAME varchar 50 √ null

Charge name
CHARGE_TYPE varchar 20 √ null

The type of charge (Fee / Discount / Scholarship)
GLACCOUNT_ID int 4 √ null
GLACCOUNTS.GLACCOUNT_ID Defined in XML R

The default GL account ID to post this charge to
FEE_ORDER int 4 √ null

The order in which the fee should be applied
FEE_AMOUNT money 21,4 √ null

The default fee or discount amount
DISCOUNT_PERCENT money 21,4 √ null

The default discount percentage
DISCOUNT_TYPE varchar 10 √ null

The type of discount (Amount / Percent)
PRIMARY_FEE varchar 5 √ null

Whether this charge is a primary fee (Yes / No)
OVERRIDE_FLAG varchar 20 √ null

Whether this charge can be overridden (Always / Never / By Password)
PREFILL_CONDITION varchar 20 √ null

The prefill condition for this fee (Never / Always / If Resident / If Non-resident / If Minor / If Senior / If Internet / If Member / If Non-member)
PRORATE_FEES varchar 5 √ null

Whether this fee can be prorated (Yes / No)
TAXABLE_BY_TAX_1 varchar 5 √ null

Whether tax 1 applies to this fee (Yes / No)
TAXABLE_BY_TAX_2 varchar 5 √ null

Whether tax 2 applies to this fee (Yes / No)
TAXABLE_BY_TAX_3 varchar 5 √ null

Whether tax 3 applies to this fee (Yes / No)
TAXABLE_BY_TAX_4 varchar 5 √ null

Whether tax 4 applies to this fee (Yes / No)
TAXABLE_BY_TAX_5 varchar 5 √ null

Whether tax 5 applies to this fee (Yes / No)
TAXABLE_BY_TAX_6 varchar 5 √ null

Whether tax 6 applies to this fee (Yes / No)
TAXABLE_BY_TAX_7 varchar 5 √ null

Whether tax 7 applies to this fee (Yes / No)
TAXABLE_BY_TAX_8 varchar 5 √ null

Whether tax 8 applies to this fee (Yes / No)
UNIT_OF_MEASURE varchar 40 √ null

The default unit of measure for the amount
ONLINE_QUESTION varchar 100 √ null

Online question to be asked for this charge
DISCOUNTABLE varchar 5 √ null

Whether this charge can be discounted (Yes / No)
MULTI_CHILD_MIN int 4 √ null

The minimum number of registrants for multi-person registration with this fee
MULTI_CHILD_MAX int 4 √ null

The maximum number of registrants for multi-person registration with this fee
ACTIVATION_DATE date 20 √ null

The first available date for this fee
EXPIRATION_DATE date 20 √ null

The last available date for this fee
MIN_PLAYERS int 4 √ null

The minimum number of team players for this fee to be applied
MAX_PLAYERS int 4 √ null

The maximum number of team players for this fee to be applied
ACTIVATION_PASSWORD varchar 100 √ null

The answer to the online question that must be entered to activate this fee
ALLOWED_QUANTITY_CHANGED varchar 5 √ null

Whether the quantity for this fee can be changed online (Yes / No)
ALLOWED_MIN_QUANTITY int 4 √ null

The minimum allowed quantity for this fee to be applied
ALLOWED_MAX_QUANTITY int 4 √ null

The maximum allowed quantity for this fee to be applied
AGES_MIN int 4 √ null

The minimum age for this fee to be applied
AGES_MAX int 4 √ null

The maximum age for this fee to be applied
CUSTOMER_TYPE_ID int 4 √ null
CUSTOMER_TYPES.CUSTOMER_TYPE_ID Defined in XML R

The customer type ID that this charge applies to
PRORATE_REFUND_FEES varchar 5 √ null

Whether a refund of this fee can be prorated (Yes / No)
ACTIVITY_TEAM_CATEGORY_ID int 4 √ null
ACTIVITY_TEAM_CATEGORIES.ACTIVITY_TEAM_CATEGORY_ID Defined in XML R

Activity team category ID
TEAM_PREFILL_CONDITION varchar 20 √ null

The team prefill condition for this fee (No Teams or Groups / Teams and Groups / Teams Only / Groups Only)
USE_REGIONAL_PRICING varchar 5 √ null

Whether regional pricing should be used (Yes / No)
MULTI_ACTIVITY_MIN int 4 √ null

The minimum number of activities for multi-activity registration with this fee
MULTI_ACTIVITY_MAX int 4 √ null

The maximum number of activities for multi-activity registration with this fee
MULTI_CHILD_APPLIES_TO_ALL varchar 5 √ null

Whether multi-person registration with this fee applies to all registrants up to the max number entered
MULTI_ACTIVITY_APPLIES_TO_ALL varchar 5 √ null

Whether multi-activity registration with this fee applies to all activities up to the max number entered
TRIAL_CLASS_FEE varchar 5 √ null

Whether this charge can be a trial class fee (Yes / No)
ACTIVATE_QUALIFYING_ACTIVITIES varchar 5 √ null

Whether this charge has qualifying activity criteria (Yes / No)
APPLIES_TO_ALL_ACTIVITIES varchar 5 √ null

Whether this charge applies to all activities (Yes / No)
ACTIVITY_GROUP_NUMBER varchar 50 √ null

The specific group number that his charge applies to
QUALIFYING_TIME_PERIOD int 4 √ null

This charge will be valid only within the last this number of months of the selected season and/or child season
PER_BOOKING varchar 5 √ null

Whether this fee is charged per booking (Yes / No)
EXCLUDE_FROM_PAYMENT_PLAN varchar 5 √ null

Whether this charge should be excluded from any payment plan (Yes / No)
PER_BOOKING_PER_HOUR varchar 5 √ null

Whether this fee is charged per booking per hour (Yes / No)
QUALIFYING_MIN_REGISTRATIONS int 4 √ null

This charge will apply if the customer has had at least this number of registrations
QUALIFYING_MAX_REGISTRATIONS int 4 √ null

This charge will apply if the customer has had at most this number of registrations
VOLUME_PRICING_PLAN_ID int 4 √ null

Volume pricing plan ID
MULTI_PERSON_QUALIFYING_TIME_PERIOD int 4 √ null

This multi-person registration fee will only consider prior registrations within this last number of months
PER_BOOKING_PER_HOUR_MIN int 4 √ null

The minimum per booking per hour units to be charged
PER_BOOKING_PER_HOUR_MAX int 4 √ null

The maximum per booking per hour units to be charged
PER_BOOKING_PER_HOUR_DURATION int 4 √ null

The number of minutes that each unit of a per booking per hour fee will be charged for
SYSTEM_GL_ACCOUNT_PACKAGE_ID int 4 √ null
SYSTEM_GL_ACCOUNT_PACKAGES.SYSTEM_GL_ACCOUNT_PACKAGE_ID Defined in XML R

System account package ID
DISCOUNT_ORDER int 4 √ null

The order in which the discount should be applied
DISCOUNT_GROUP_NUMBER int 4 √ null

Discount group number
EXCLUDE_OTHER_DISCOUNTS_IN_GROUP varchar 5 √ null

Whether other discounts in the same group should be excluded (Yes / No)
MULTI_REGISTRATION_COUNT_ALL_ENROLLMENTS varchar 5 √ null

Whether multi-person registration will include later enrollments in its count
DISCOUNT_CHEAPEST varchar 5 √ null

Whether the discount should be applied to the lowest cost enrollment in a multi-person registration
IS_MULTI_GL varchar 5 √ null

Whether this fee splits GL postings across multiple GL accounts (Yes / No)
PRORATED_EARLIEST_TO_LATEST varchar 5 √ null

Whether the amount should be prorated from earlies to latest (Yes / No)
DROP_IN_FEE varchar 5 √ null

Whether this fee is a drop-in fee (Yes / No)
FEE_DESCRIPTION varchar 8000 √ null

The description of this fee
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)
ACTIVITY_FEES_ACTIVE_HUB_KEY_PK Primary key Asc ACTIVE_HUB_KEY
ACTIVITY_FEES_ACTIVITY_FEE_ID_ORG_ID_UQ Must be unique Asc/Asc ACTIVITY_FEE_ID + ORG_ID
ACTIVITY_FEES_ACTIVITY_ID_IX Performance Asc ACTIVITY_ID
ACTIVITY_FEES_CHARGE_ID_IX Performance Asc CHARGE_ID
ACTIVITY_FEES_CUSTOMER_TYPE_ID_IX Performance Asc CUSTOMER_TYPE_ID
ACTIVITY_FEES_GLACCOUNT_ID_IX Performance Asc GLACCOUNT_ID
ACTIVITY_FEES_ROW_VERSION_IX Performance Asc ROW_VERSION
ACTIVITY_FEES_SYSTEM_GL_ACCOUNT_PACKAGE_ID_IX Performance Asc SYSTEM_GL_ACCOUNT_PACKAGE_ID

Relationships

Close relationships within degrees of separation