PACKAGE_FEES

0 rows


Description

Master table showing defined package fees data

Columns

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

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

Package fee ID
PACKAGE_ID int 4 √ null
PACKAGES.PACKAGE_ID Defined in XML R

Package 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
DISCOUNT_PERCENT money 21,4 √ null

The default discount percentage
DISCOUNT_TYPE varchar 10 √ null

The type of discount (Amount / Percent)
FEE_AMOUNT money 21,4 √ null

The default fee or discount amount
FEE_ORDER int 4 √ null

The order in which the fee should be applied
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)
PRIMARY_FEE varchar 5 √ null

Whether this charge is a primary fee (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)
DISCOUNTABLE varchar 5 √ null

Whether this charge can be discounted (Yes / No)
ACTIVATION_DATE date 20 √ null

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

The last available date for this fee
FEE_CHANGE_DATE date 20 √ null

The date that the fee amount is scheduled to automatically change
SCHEDULED_FEE money 21,4 √ null

The amount that the fee is scheduled to automatically change to
PRORATE_FEE varchar 5 √ null

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

Whether this fee is calculated on a per use basis (Yes / No)
MIN_PASSES int 4 √ null

The minimum number of passes purchased for this fee to be applied
MAX_PASSES int 4 √ null

The maximum number of passes purchased for this fee to be applied
PER_PASS_FEE varchar 5 √ null

Whether this fee is calculated on a per pass basis (Yes / No)
CUSTOMER_TYPE_ID int 4 √ null
CUSTOMER_TYPES.CUSTOMER_TYPE_ID Defined in XML R

The customer type ID that this charge applies to
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
APPLY_ONLY_RENEWAL varchar 5 √ null

Whether this fee is applied only to renewals (Yes / No)
APPLY_ONLY_TIME_PERIODS int 4 √ null

The minimum number of time periods purchased for this discount to apply
PRORATE_REFUND_FEES varchar 5 √ null

Whether refunds of this fee can be prorated (Yes / No)
MIN_USES int 4 √ null

The minimum number of uses purchased for this fee to be applied
MAX_USES int 4 √ null

The maximum number of uses purchased for this fee to be applied
EXCLUDE_FROM_PAYMENT_PLAN varchar 5 √ null

Whether this charge should be excluded from any payment plan (Yes / No)
PRORATE_ENROLLMENT_FEE_DATE date 20 √ null

The minimum date that the fee can be prorated during purchase
PRORATE_REFUND_FEES_DATE date 20 √ null

The minimum date that the fee can be prorated during renewal
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
APPLY_ONLY_SUSPENDED_CYCLE_AUTO_RENEWAL varchar 5 √ null

Whether the fee should only apply to suspended cycle of auto-renewal (Yes / No)
IS_MULTI_GL varchar 5 √ null

Whether this fee splits GL postings across multiple GL accounts (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)
PACKAGE_FEES_ACTIVE_HUB_KEY_PK Primary key Asc ACTIVE_HUB_KEY
PACKAGE_FEES_CHARGE_ID_IX Performance Asc CHARGE_ID
PACKAGE_FEES_CUSTOMER_TYPE_ID_IX Performance Asc CUSTOMER_TYPE_ID
PACKAGE_FEES_GLACCOUNT_ID_IX Performance Asc GLACCOUNT_ID
PACKAGE_FEES_PACKAGE_FEE_ID_ORG_ID_UQ Must be unique Asc/Asc PACKAGE_FEE_ID + ORG_ID
PACKAGE_FEES_PACKAGE_ID_IX Performance Asc PACKAGE_ID
PACKAGE_FEES_ROW_VERSION_IX Performance Asc ROW_VERSION
PACKAGE_FEES_SYSTEM_GL_ACCOUNT_PACKAGE_ID_IX Performance Asc SYSTEM_GL_ACCOUNT_PACKAGE_ID

Relationships

Close relationships within degrees of separation