USAGE_FEES

0 rows


Description

Master table showing defined usage fees data

Columns

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

The Hub record ID
USAGE_FEE_ID int 4 √ null
COUPON_BATCH_QUALIFICATIONS.USAGE_FEE_ID Defined in XML R
COUPON_QUALIFICATIONS.USAGE_FEE_ID Defined in XML R

Usage fee ID
USAGE_FEE_NAME varchar 50 √ null

Usage fee name
USAGE_FEE_DESCRIPTION varchar 500 √ null

Usage fee description
USAGE_FEE_FOR varchar 10 √ null

What the usage fee is for (packages / activities)
IS_DEFAULT_FOR_ACTIVITIES varchar 5 √ null

Whether this usage fee is the default for activities (Yes / No)
IS_DEFAULT_FOR_PACKAGES varchar 5 √ null

Whether this usage fee is the default for packages (Yes / No)
SITE_ID int 4 √ null
SITES.SITE_ID Defined in XML R

Site ID
SITE_NAME varchar 255 √ null

Site name
EXCLUDE_FROM_PAYMENT_PLAN varchar 5 √ null

Whether this usage fee should be excluded from payment plans (Yes / No)
FEE_CHARGE_ID int 4 √ null
CHARGES.CHARGE_ID Defined in XML R

The charge ID for the fee
FEE_CHARGE_NAME varchar 50 √ null

The charge name for the fee
FEE_GLACCOUNT_ID int 4 √ null
GLACCOUNTS.GLACCOUNT_ID Defined in XML R

The GL account ID for the fee
FEE_GL_ACCOUNT_NAME varchar 200 √ null

The GL account name for the fee
FEE_GL_ACCOUNT_NUMBER varchar 200 √ null

The GL account number for the fee
IS_DISCOUNTABLE_FOR_PACKAGES varchar 5 √ null

Whether this usage fee is the discountable for packages (Yes / No)
FEE_SYSTEM_GL_ACCOUNT_PACKAGE_ID int 4 √ null
SYSTEM_GL_ACCOUNT_PACKAGES.SYSTEM_GL_ACCOUNT_PACKAGE_ID Defined in XML R

The system GL account package ID for the fee
FEE_SYSTEM_GL_ACCOUNT_PACKAGE varchar 50 √ null

The system GL account package name for the fee
DISCOUNT_SYSTEM_GL_ACCOUNT_PACKAGE_ID int 4 √ null
SYSTEM_GL_ACCOUNT_PACKAGES.SYSTEM_GL_ACCOUNT_PACKAGE_ID Defined in XML R

The system GL account package ID for the discount
DISCOUNT_SYSTEM_GL_ACCOUNT_PACKAGE varchar 50 √ null

The system GL account package name for the discount
APPLY_TYPE varchar 20 √ null

How this usage fee is to be applied (Per Member / Per Family Member / Per Individual)
GOOD_FOR_TYPE varchar 20 √ null

When the activity usage fee is valid (Date Range / Selected Seasons)
GOOD_FOR_START_DATE date 20 √ null

The start date that the activity usage fee is valid
GOOD_FOR_END_DATE date 20 √ null

The end date that the activity usage fee is valid
OVERRIDE_FEE_AMOUNT money 21,4 √ null

The overridden fee amount for the first member
OVERRIDE_ALT_FEE_AMOUNT money 21,4 √ null

The overridden fee amount for subsequent members
MAX_FAMILY_USAGE_FEE_AMOUNT money 21,4 √ null

The maximum total usage fees for a family
EARLY_REGISTRATION_UNTIL_TYPE varchar 30 √ null

How early registration will be determined (Before start date for season / Before start date for child season / Until date / None)
EARLY_REGISTRATION_UNTIL_SEASON_ID int 4 √ null
SEASONS.SEASON_ID Defined in XML R

The season ID that the registration must be prior to be considered early registration
EARLY_REGISTRATION_UNTIL_SEASON varchar 40 √ null

The season name that the registration must be prior to be considered early registration
EARLY_REGISTRATION_UNTIL_CHILD_SEASON_ID int 4 √ null
CHILD_SEASONS.CHILD_SEASON_ID Defined in XML R

The child season ID that the registration must be prior to be considered early registration
EARLY_REGISTRATION_UNTIL_CHILD_SEASON varchar 40 √ null

The child season name that the registration must be prior to be considered early registration
EARLY_REGISTRATION_UNTIL_DATE date 20 √ null

The date that the registration must be prior to be considered early registration
EARLY_REGISTRATION_DISCOUNT_CHARGE_ID int 4 √ null
CHARGES.CHARGE_ID Defined in XML R

The charge ID for the early registration discount
EARLY_REGISTRATION_DISCOUNT_CHARGE_NAME varchar 50 √ null

The charge name for the early registration discount
EARLY_REGISTRATION_DISCOUNT_GLACCOUNT_ID int 4 √ null
GLACCOUNTS.GLACCOUNT_ID Defined in XML R

The GL account ID for the early registration discount
EARLY_REGISTRATION_DISCOUNT_GL_ACCOUNT_NAME varchar 200 √ null

The GL account name for the early registration discount
EARLY_REGISTRATION_DISCOUNT_GL_ACCOUNT_NUMBER varchar 200 √ null

The GL account number for the early registration discount
EARLY_REGISTRATION_OVERRIDE_DISCOUNT_AMOUNT money 21,4 √ null

The early registration discount amount for the first member
EARLY_REGISTRATION_OVERRIDE_DISCOUNT_PERCENT money 21,4 √ null

The early registration discount amount for subsequent members
EARLY_REGISTRATION_OVERRIDE_ALT_DISCOUNT_AMOUNT money 21,4 √ null

The early registration discount amount for subsequent members
EARLY_REGISTRATION_OVERRIDE_ALT_DISCOUNT_PERCENT money 21,4 √ null

The early registration discount amount for subsequent members
WAIVED_FOR_EARLY_REGISTRATION_FEES_AMOUNT money 21,4 √ null

The minimum early registration enrollment amount for the usage fee to be waived
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)
IS_RETIRED varchar 5 √ null

Whether this fee has been retired from further use (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

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views