PROGRAM_FEES

The Hub record ID

Program fee ID

Program ID which this fee belongs to

Charge ID

Charge name

The type of charge (Fee / Discount / Scholarship)

The default GL account ID to post this charge to

The default fee or discount amount

The order in which the fee should be applied

The type of discount (Amount / Percent)

The default discount percentage

Whether this charge can be discounted (Yes / No)

Whether this charge can be overridden (Always / Never / By Password)

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

Whether tax 1 applies to this fee (Yes / No)

Whether tax 2 applies to this fee (Yes / No)

Whether tax 3 applies to this fee (Yes / No)

Whether tax 4 applies to this fee (Yes / No)

Whether tax 5 applies to this fee (Yes / No)

Whether tax 6 applies to this fee (Yes / No)

Whether tax 7 applies to this fee (Yes / No)

Whether tax 8 applies to this fee (Yes / No)

The default unit of measure for the amount

The minimum number of registrants for multi-person registration with this fee

The maximum number of registrants for multi-person registration with this fee

The minimum number of days per week booked for this fee to be applied

The maximum number of days per week booked for this fee to be applied

The first available date for this fee

The last available date for this fee

The minimum number of sessions booked for this fee to be applied

The maximum number of sessions booked for this fee to be applied

The customer type ID that this charge applies to

The minimum age for this fee to be applied

The maximum age for this fee to be applied

Online question to be asked for this fee

The answer to the online question that must be entered to activate this fee

Whether the quantity for this fee can be changed online (Yes / No)

The minimum allowed quantity for this fee to be applied

The maximum allowed quantity for this fee to be applied

Whether this fee can be prorated (Yes / No)

Whether the sessions booked need to be concurrent for the number of sessions qualification (Yes / No)

The minimum number of hours per week booked for this fee to be applied

The maximum number of hours per week booked for this fee to be applied

Whether this charge can be a trial class fee (Yes / No)

Whether this charge should be excluded from any payment plan (Yes / No)

Whether the activation and expiration dates are based on registration date rather than session date (Yes / No)

Whether the fee should be included in the original enrollment only (Yes / No)

Session ID which this fee belongs to

The minimum number of session bookings per billing unit for this fee to be applied

The maximum number of session bookings per billing unit for this fee to be applied

System account package ID

The order in which the discount should be applied

Whether this is a one-time fee (Yes / No)

This multi-person registration fee will only consider prior registrations within this last number of months

Whether the discount should be applied to the lowest cost enrollment in a multi-person registration

Whether this fee splits GL postings across multiple GL accounts (Yes / No)

The minimum number of weeks booked for this fee to be applied

The maximum number of weeks booked for this fee to be applied

Whether the fee is non-refundable (Yes / No)

Whether this charge is a primary fee (Yes / No)

Date and time Hub record was last modified

The Hub sync process ID

Your organization’s unique identifier in the Active Net system

System timestamp (for internal use)