CHARGE_QUALIFICATION_LINKS

0 rows


Description

Master table containing defined charge and fee qualification links

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
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)
ACTIVITY_FEE_PACKAGE_ID int 4 √ null

Activity fee package ID
PACKAGE_FEE_PACKAGE_ID int 4 √ null

Package fee package ID

Indexes

Constraint Name Type Sort Column(s)
CHARGE_QUALIFICATION_LINKS_ACTIVE_HUB_KEY_PK Primary key Asc ACTIVE_HUB_KEY
CHARGE_QUALIFICATION_LINKS_ACTIVITY_CATEGORY_ID_IX Performance Asc ACTIVITY_CATEGORY_ID
CHARGE_QUALIFICATION_LINKS_ACTIVITY_DEPARTMENT_ID_IX Performance Asc ACTIVITY_DEPARTMENT_ID
CHARGE_QUALIFICATION_LINKS_ACTIVITY_FEE_ID_IX Performance Asc ACTIVITY_FEE_ID
CHARGE_QUALIFICATION_LINKS_ACTIVITY_FEE_PACKAGE_ID_IX Performance Asc ACTIVITY_FEE_PACKAGE_ID
CHARGE_QUALIFICATION_LINKS_ACTIVITY_ID_IX Performance Asc ACTIVITY_ID
CHARGE_QUALIFICATION_LINKS_ACTIVITY_SITE_ID_IX Performance Asc ACTIVITY_SITE_ID
CHARGE_QUALIFICATION_LINKS_ACTIVITY_SUB_CATEGORY_ID_IX Performance Asc ACTIVITY_SUB_CATEGORY_ID
CHARGE_QUALIFICATION_LINKS_ALTERNATE_KEY_STATUS_ID_IX Performance Asc ALTERNATE_KEY_STATUS_ID
CHARGE_QUALIFICATION_LINKS_ALTERNATE_KEY_TYPE_ID_IX Performance Asc ALTERNATE_KEY_TYPE_ID
CHARGE_QUALIFICATION_LINKS_CHARGE_ID_IX Performance Asc CHARGE_ID
CHARGE_QUALIFICATION_LINKS_CHARGE_QUALIFICATION_LINK_ID_ORG_ID_IX Performance Asc/Asc CHARGE_QUALIFICATION_LINK_ID + ORG_ID
CHARGE_QUALIFICATION_LINKS_CHILD_SEASON_ID_IX Performance Asc CHILD_SEASON_ID
CHARGE_QUALIFICATION_LINKS_CUSTOMER_SCHOLARSHIP_ID_IX Performance Asc CUSTOMER_SCHOLARSHIP_ID
CHARGE_QUALIFICATION_LINKS_GLOBAL_DISCOUNT_ID_IX Performance Asc GLOBAL_DISCOUNT_ID
CHARGE_QUALIFICATION_LINKS_MEMBER_PREFILL_PACKAGE_CATEGORY_ID_IX Performance Asc MEMBER_PREFILL_PACKAGE_CATEGORY_ID
CHARGE_QUALIFICATION_LINKS_MEMBER_PREFILL_PACKAGE_ID_IX Performance Asc MEMBER_PREFILL_PACKAGE_ID
CHARGE_QUALIFICATION_LINKS_nc_cs_ix Performance Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc ACTIVE_HUB_KEY + ACTIVE_HUB_PROCESS_ID + ACTIVITY_CATEGORY_ID + ACTIVITY_DEPARTMENT_ID + ACTIVITY_FEE_ID + ACTIVITY_FEE_PACKAGE_ID + ACTIVITY_ID + ACTIVITY_SITE_ID + ACTIVITY_SUB_CATEGORY_ID + ALTERNATE_KEY_STATUS_ID + ALTERNATE_KEY_TYPE_ID + CHARGE_ID + CHARGE_QUALIFICATION_LINK_ID + CHILD_SEASON_ID + CUSTOMER_SCHOLARSHIP_ID + GLOBAL_DISCOUNT_ID + LAST_SYNC_TIME + MEMBER_PREFILL_PACKAGE_CATEGORY_ID + MEMBER_PREFILL_PACKAGE_ID + ORG_ID + PACKAGE_CATEGORY_ID + PACKAGE_FEE_ID + PACKAGE_FEE_PACKAGE_ID + PACKAGE_ID + PRODUCT_CLASS_ID + PRODUCT_DEPARTMENT_ID + PRODUCT_ID + PRODUCT_SUB_CLASS_ID + PROGRAM_FEE_ID + PROGRAM_ID + PROGRAM_TYPE_ID + QUALIFICATION_TYPE + QUALIFICATION_TYPE_ID + ROW_VERSION + SEASON_ID + STANDARD_CHARGE_ID
CHARGE_QUALIFICATION_LINKS_PACKAGE_CATEGORY_ID_IX Performance Asc PACKAGE_CATEGORY_ID
CHARGE_QUALIFICATION_LINKS_PACKAGE_FEE_ID_IX Performance Asc PACKAGE_FEE_ID
CHARGE_QUALIFICATION_LINKS_PACKAGE_FEE_PACKAGE_ID_IX Performance Asc PACKAGE_FEE_PACKAGE_ID
CHARGE_QUALIFICATION_LINKS_PACKAGE_ID_IX Performance Asc PACKAGE_ID
CHARGE_QUALIFICATION_LINKS_PRODUCT_CLASS_ID_IX Performance Asc PRODUCT_CLASS_ID
CHARGE_QUALIFICATION_LINKS_PRODUCT_DEPARTMENT_ID_IX Performance Asc PRODUCT_DEPARTMENT_ID
CHARGE_QUALIFICATION_LINKS_PRODUCT_ID_IX Performance Asc PRODUCT_ID
CHARGE_QUALIFICATION_LINKS_PRODUCT_SUB_CLASS_ID_IX Performance Asc PRODUCT_SUB_CLASS_ID
CHARGE_QUALIFICATION_LINKS_PROGRAM_FEE_ID_IX Performance Asc PROGRAM_FEE_ID
CHARGE_QUALIFICATION_LINKS_PROGRAM_ID_IX Performance Asc PROGRAM_ID
CHARGE_QUALIFICATION_LINKS_PROGRAM_TYPE_ID_IX Performance Asc PROGRAM_TYPE_ID
CHARGE_QUALIFICATION_LINKS_QUALIFICATION_TYPE_ID_IX Performance Asc QUALIFICATION_TYPE_ID
CHARGE_QUALIFICATION_LINKS_ROW_VERSION_IX Performance Asc ROW_VERSION
CHARGE_QUALIFICATION_LINKS_SEASON_ID_IX Performance Asc SEASON_ID
CHARGE_QUALIFICATION_LINKS_STANDARD_CHARGE_ID_IX Performance Asc STANDARD_CHARGE_ID

Relationships

Close relationships within degrees of separation