CHARGE_QUALIFICATION_LINKS

0 rows


Description

Master table containing defined charge and fee qualification links (for internal use).

Columns

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

The Hub record ID
CHARGE_QUALIFICATION_LINK_ID int 4 √ null

Charge qualification link ID
GLOBAL_DISCOUNT_ID int 4 √ null
GLOBAL_DISCOUNTS.GLOBAL_DISCOUNT_ID Defined in XML R

Global discount ID
ACTIVITY_FEE_ID int 4 √ null
ACTIVITY_FEES.ACTIVITY_FEE_ID Defined in XML R

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

Activity ID
ACTIVITY_CATEGORY_ID int 4 √ null
ACTIVITY_CATEGORIES.ACTIVITY_CATEGORY_ID Defined in XML R

Activity category ID
ACTIVITY_SUB_CATEGORY_ID int 4 √ null
ACTIVITY_SUB_CATEGORIES.ACTIVITY_SUB_CATEGORY_ID Defined in XML R

Activity subcategory ID
ACTIVITY_SITE_ID int 4 √ null
SITES.SITE_ID Defined in XML R

Activity site ID
ACTIVITY_DEPARTMENT_ID int 4 √ null
ACTIVITY_DEPARTMENTS.ACTIVITY_DEPARTMENT_ID Defined in XML R

Activity department ID
PROGRAM_ID int 4 √ null
PROGRAMS.PROGRAM_ID Defined in XML R

Program ID
PROGRAM_TYPE_ID int 4 √ null
PROGRAM_TYPES.PROGRAM_TYPE_ID Defined in XML R

Program type ID
QUALIFICATION_TYPE_ID int 4 √ null

Qualification type ID
QUALIFICATION_TYPE varchar 30 √ null

Qualification type
CHARGE_ID int 4 √ null
CHARGES.CHARGE_ID Defined in XML R

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

Package ID
PACKAGE_CATEGORY_ID int 4 √ null
PACKAGE_CATEGORIES.PACKAGE_CATEGORY_ID Defined in XML R

Package category ID
SEASON_ID int 4 √ null

Season ID
CHILD_SEASON_ID int 4 √ null

Child season ID
ALTERNATE_KEY_TYPE_ID int 4 √ null
ALTERNATE_KEY_TYPES.ALTERNATE_KEY_TYPE_ID Defined in XML R

Alternate key type ID
ALTERNATE_KEY_STATUS_ID int 4 √ null
ALTERNATE_KEY_STATUSES.ALTERNATE_KEY_STATUS_ID Defined in XML R

Alternate key status ID
PACKAGE_FEE_ID int 4 √ null
PACKAGE_FEES.PACKAGE_FEE_ID Defined in XML R

Package fee ID
STANDARD_CHARGE_ID int 4 √ null
STANDARD_CHARGES.STANDARD_CHARGE_ID Defined in XML R

Standard charge ID
MEMBER_PREFILL_PACKAGE_ID int 4 √ null
PACKAGES.PACKAGE_ID Defined in XML R

Member prefill package ID
MEMBER_PREFILL_PACKAGE_CATEGORY_ID int 4 √ null
PACKAGE_CATEGORIES.PACKAGE_CATEGORY_ID Defined in XML R

Member prefill package category ID
CUSTOMER_SCHOLARSHIP_ID int 4 √ null
CUSTOMER_SCHOLARSHIPS.CUSTOMER_SCHOLARSHIP_ID Defined in XML R

Customer scholarship ID
PROGRAM_FEE_ID int 4 √ null
PROGRAM_FEES.PROGRAM_FEE_ID Defined in XML R

Program fee ID
PRODUCT_ID int 4 √ null
POS_PRODUCTS.POSPRODUCT_ID Defined in XML R

Product ID
PRODUCT_DEPARTMENT_ID int 4 √ null
PRODUCT_DEPARTMENTS.PRODUCT_DEPARTMENT_ID Defined in XML R

Product department ID
PRODUCT_CLASS_ID int 4 √ null
PRODUCT_CLASSES.PRODUCT_CLASS_ID Defined in XML R

Product class ID
PRODUCT_SUB_CLASS_ID int 4 √ null
PRODUCT_SUBCLASSES.PRODUCT_SUBCLASS_ID Defined in XML R

Product sub class ID
ACTIVITY_FEE_PACKAGE_ID int 4 √ null

Activity fee package ID
PACKAGE_FEE_PACKAGE_ID int 4 √ null

Package fee package ID
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