Tables


SchemaSpy Analysis of ActiveHub.hub

Generated on Sat Apr 25 01:04 GMT 2026

XML Representation
Insertion Order Deletion Order
TABLES 237
VIEWS 0
COLUMNS 5268
Constraints 0
Anomalies 19
Routines 4

Database Properties

Database Type: Microsoft SQL Server - 16.00.4245

Schema hub

Tables that contain raw base data for use by the ACTIVE Net Hub engine. These tables are designed for efficient loading but are not easy to use for reports. You shouldn’t need to use them but they are documented here for transparency. Objects in this schema may change over time and are not guaranteed to be compatible with previous development.

Tables

Table / View Children Parents Columns Rows Type Comments
RECEIPT_GL_POSTINGS 1 9 20 0 Table

Postings in the GL ledger, where positive amounts are debits and negative amounts are credits

ACTIVITY_RESERVATION_PATTERNS 0 2 21 0 Table

Reservation patterns for generating activity class dates

PEAK_LOAD_PERIODS 0 0 19 0 Table

Rush event details

ACTIVITY_DATES 0 3 14 0 Table

Detailed class times and locations per activity

EXTERNAL_CLIENT_API_REQUEST_LOG 0 0 25 0 Table

LOG of External clients api calls

PAYMENT_CHARGEBACKS 0 2 39 0 Table

Payment chargeback information

STAGE_SEQUENCE_STAGES 2 2 8 0 Table

Your organization’s defined stage sequence stages

FAMILY_MEMBERS 0 2 12 0 Table

Customer family details

LEAGUE_SCHEDULE_TIMESLOT_CONFIGURATIONS 1 1 9 0 Table

Your organization’s defined league schedule timeslot configurations

CUSTOMERS 59 7 93 0 Table

Customers’ details

MEMBERSHIP_USAGE 2 11 33 0 Table

Membership pass usage history

PARTICIPANT_ZONES 0 0 8 0 Table

Zones that are eligible for pririty registration

SYSTEMINFO 0 0 8 0 Table

Your organization’s site level settings information

USAGE_FEES 2 9 45 0 Table

Master table showing defined usage fees data

CUSTOM_PAYMENT_TYPES 1 1 9 0 Table

Your organization’s defined custom payment types

LEAGUE_SCHEDULE_PAIRING_OFFICIALS 0 2 7 0 Table

Your organization’s defined league schedule pairing officials

FACILITY_TYPE_LINKS 0 3 10 0 Table

Contains information on related records that are linked to facility type records

ITEM_CHANGE_LOG 0 0 12 0 Table
ACTIVITY_SUB_CATEGORIES 5 0 8 0 Table

Your organization’s defined activity sub-categories

LEAGUE_SCHEDULE_OFFICIALS 0 2 7 0 Table

Your organization’s defined league schedule officials

PARENT_LOCATIONS 3 0 7 0 Table

Your organization’s defined parent locations

COUPON_BATCHES 2 4 32 0 Table

Coupon batch information

CUSTOMER_WAIVERS 1 1 18 0 Table

Your organization’s defined customer waivers

ALTERNATE_KEY_TYPES 7 0 27 0 Table

Your organization’s defined alternate key types

ORGS 0 0 14 0 Table

Your organization’s information

INTEREST_LISTS 0 7 19 0 Table

Customer interest lists for facilities, packages, activities and programs

FUNDS 1 0 7 0 Table

Your organization’s defined funds

SUBSIDY_ANNUAL_BUDGET 0 0 12 0 Table

Subsidy program annual budget table

ACTIVITY_GROUPS 1 0 7 0 Table

Contains information on defined activity groups for shared registration capacity

POS_SALES_DETAILS 0 6 27 0 Table

POS product sales

CUSTOMERLOG 0 0 15 0 Table

Audit records showing what, when and who made changes to CUSTOMER table data.

RANKING_SYSTEMS 1 0 35 0 Table

Your organization’s defined ranking systems for league and tournament standings

CASH_SUMMARY_SHEET_LAYOUTS 1 4 13 0 Table

Your organization’s defined cash summary sheet layouts

FACILITY_PREREQUISITES 1 3 11 0 Table

Contains information on configured prerequisites for facility reservations

GLACCOUNTS 56 1 16 0 Table

Master table showing GL accounts details

LOCKER_ROOMS 3 3 17 0 Table

Your organization’s defined locker rooms

ACTIVITY_ENROLLMENTS 0 7 43 0 Table

Showing the activity enrollments by customer

CUSTOM_QUESTION_TYPES 1 0 6 0 Table

Your organization’s defined custom question types

ACTIVITY_INSTRUCTORS 0 0 10 0 Table

Provides the link between INSTRUCTORS and the ACTIVITIES they are assigned to

CUSTOMER_SIGNED_WAIVERS 0 6 22 0 Table

Your organization’s defined customer waivers

SCHEDULED_FEE_RATES 0 0 9 0 Table

Master table showing scheduled fee rates

LEAGUE_SCHEDULE_FACILITIES 0 2 7 0 Table

Your organization’s defined league schedule facilities

FACILITY_HOURS 2 1 25 0 Table

Contains information on facility hours by date range

GEOGRAPHIC_AREAS 5 0 9 0 Table

Your organization’s defined geographic areas

WORKSTATION_GROUPS 1 0 6 0 Table

Your organization’s defined workstation groups

PRODUCT_DEPARTMENTS 5 0 6 0 Table

Your organization’s defined product departments

PAYMENTPLANCONFIGSCHEDULES 0 0 11 0 Table

Schedule configuration for payment plans

LOCKER_BANKS 1 2 15 0 Table

Your organization’s defined locker banks per locker room

CHILD_WATCH_REGISTRATIONS 0 10 23 0 Table

Child-watch registration data by room and customer

CUSTOM_QUESTION_ANSWERS_SCHOLARSHIP_APPLICATION 0 0 18 0 Table

Custom question for scholarship application and answer details, for customers and transactions

COMPANIES 24 4 32 0 Table

Company details

LOCKER_SIZES 3 0 6 0 Table

Your organization’s defined locker sizes

CHILD_WATCH_ROOMS 1 2 11 0 Table

Your organization’s defined child-watch rooms

ACTIVITY_TEAM_CATEGORIES 2 2 9 0 Table

Your organization’s defined activity team categories

SCHEDULE_TYPES 5 4 24 0 Table

Contains information on defined schedule types for reservations

FACILITIES 34 6 103 0 Table

Master table showing facility details

GLOBAL_DISCOUNTS 1 2 55 0 Table

Master table showing defined global discount and surcharge data

PROGRAM_SESSIONS 0 2 13 0 Table

Master table showing FlexReg program sessions

CUSTOMER_NOTES 0 5 18 0 Table

Customer notes and alerts

FACILITY_PREREQUISITE_ALTERNATE_KEY_STATUSES 0 2 8 0 Table

Contains information on configured alternate key statuses for alternate key type facility prerequisites

POS_LAYOUTS 3 1 7 0 Table

Your organization’s defined POS button layouts

CUSTOM_QUESTION_LINKS 0 0 39 0 Table

Custom questions linked to individual subject areas (for internal use).

COUPON_BATCH_QUALIFICATIONS 0 13 19 0 Table

Coupon batch qualification information

FACILITY_RESERVATION 3 12 39 0 Table

Facility booking data along with the permit number and customer’s detail

CUSTOMER_SUBSIDIES 0 0 11 0 Table

Customer subsidies setup table

STAGE_SEQUENCE_STAGE_CHILD_STAGES 0 2 7 0 Table

Contains the parent to child links for stage sequences stages

SUBSIDIES 0 0 13 0 Table

Sudsidy program

EQUIPMENT_CATEGORIES 0 1 10 0 Table

Contains information on defined equipment categories

ACTIVITY_ATTENDANCE_COUNTS 0 0 8 0 Table

Attendance counts of an Activity

PACKAGE_ENTRY_POINT_TIMES 0 1 11 0 Table

Defined open times per package entry point

FACILITY_SCHEDULES 0 0 58 0 Table

Facility schedules table

AGENCY_RECEIPTDETAILS 0 0 17 0 Table

Additional tax & fee details

LEAGUE_FACILITIES 0 2 7 0 Table

Your organization’s defined league facilities

OrgDeletedRecordsLog 0 0 8 0 Table

Internal processing table

CREDIT_CARD_PROCESSING_LOG 0 8 38 0 Table

The log of all payment and refund authorization requests

COUPON_CATEGORIES 2 0 6 0 Table

Your organization’s defined coupon categories

EQUIPMENTLENDINGTRANSACTIONS 0 0 17 0 Table
PROGRAMS 15 9 64 0 Table

Master table showing FlexReg programs

SCHEDULED_FEE_CHANGES 0 4 13 0 Table

Master table showing scheduled fee changes data

POS_CONTROL_CODES 1 0 22 0 Table

Your organization’s defined POS control codes

CUSTOMER_TITLES 1 0 6 0 Table

Your organization’s defined customer titles

INSTRUCTOR_ROLES 1 0 26 0 Table

Your organization’s defined instructor roles

TEAM_PLAYERS 0 3 9 0 Table

Your organization’s defined team players

SCHOLARSHIP_APPLICATIONS 0 0 16 0 Table

Participant Zones that are eligible for priority registration for an activity

CARD_TYPES 5 0 7 0 Table

Your organization’s defined card types

MEMBERSHIP_RISK 0 0 31 0 Table
PROGRAM_ATTENDANCE_HISTORY 2 6 22 0 Table

Contains the program attendance history of registrant dropoffs and pickups

LOCKER_FEES 0 6 36 0 Table

Master table showing defined locker fees data

FACILITY_LINKS 0 4 16 0 Table

Contains information on related records that are linked to facility records

GRADES 3 0 8 0 Table

Your organization’s defined school grades

MEMBERSHIP_CUSTOMER_PACKAGE_HISTORY 0 0 17 0 Table

History of membership package holder customers

PACKAGE_ENTRY_POINTS 1 3 19 0 Table

Your organization’s defined entry points per membership package

TEAM_CATEGORIES 1 1 8 0 Table

Your organization’s defined team categories

LEAGUE_OFFICIALS 0 2 7 0 Table

Your organization’s defined league officials

CUSTOM_QUESTION_ANSWERS 0 10 29 0 Table

Custom Question Answers

LOCKERS 2 3 15 0 Table

Your organization’s defined lockers

OFFICIALS 3 2 16 0 Table

Your organization’s defined officials

ACTIVITY_CATEGORIES 8 3 16 0 Table

Your organization’s defined activity categories

CHARGES 14 6 121 0 Table

Master table showing defined charges data

CAMPAIGNS 1 5 28 0 Table

Your organization’s defined campaigns

DEPARTMENTS 0 0 7 0 Table

Your organization’s defined departments

FACILITY_USAGE_REVENUE 0 4 12 0 Table

Table showing a breakdown of permit revenue per facility and date

FACILITY_OVERLAPS 0 2 9 0 Table

Contains information on configured parent and child relationships between facilities

RESERVATION_GROUPS 2 6 21 0 Table

Contains information on reservation groups

LEAGUE_NO_PLAY_DATES 0 1 8 0 Table

Your organization’s defined league no play dates

MEMBERSHIPS 6 11 74 0 Table

Membership details for all the primary members and their family (if enrolled in any package)

AGE_CATEGORIES 1 0 8 0 Table

Your organization’s defined age categories

CREDITCARD_UPDATES 0 0 24 0 Table

Updated credit card information

ACTIVITIES 23 14 178 0 Table

A high level of the activity totals. This table shows one row per activity and can be used as a master table. Joins usually by ACTIVITY_ID

CUSTOMER_ALTERNATE_KEYS 1 3 11 0 Table

All defined customer alternate keys

DCPICKUPAUTHORIZATIONS 0 2 8 0 Table

Record of who is authorized to pick up who

CENTERS 7 3 67 0 Table

Your organization’s defined centers

SUBSIDY_LINKS 0 0 9 0 Table

Sudsidy program

LEAGUE_TYPES 1 0 7 0 Table

Your organization’s defined league types

LEAGUE_SCHEDULES 6 1 32 0 Table

Your organization’s defined league schedules

SESSIONS 4 3 31 0 Table

Master table showing FlexReg sessions

CONTACT_TYPES 3 0 7 0 Table

Your organization’s defined contact types

PROFILES 2 0 8 0 Table

Your organization’s defined profiles

LEAGUE_CONTACTS 0 4 11 0 Table

Your organization’s defined league contacts

GIFT_CARD_TYPES 2 1 28 0 Table

Your organization’s defined gift card types

DCSESSIONDATES 0 0 19 0 Table

Master table showing FlexReg program session dates

PREP_CODES 3 1 10 0 Table

Contains information on defined prep codes for setup and takedown time duration

COUPONS 3 4 28 0 Table

Coupon information

PACKAGE_CATEGORIES 11 0 12 0 Table

Your organization’s defined package categories

PAYMENTPLANCONFIG 0 0 55 0 Table

Payment plan configurations

POS_PRODUCTS 9 9 59 0 Table

Master table showing defined POS products

UPLOADED_FILES 28 3 19 0 Table

Contains details of uploaded system and customer files. Does not contain the actual file content.

PROGRAM_FEES 2 6 64 0 Table

Master table showing defined activity fees data

ACTIVITY_PASS_FAIL_GRADES 1 0 11 0 Table

Your organization’s defined activity pass fail grades

INSTRUCTORS 1 4 12 0 Table

Master table showing instructor details

CUSTOM_QUESTION_GROUP_LINKS 0 0 22 0 Table

Custom question groups linked to individual subject areas (for internal use).

CUSTOMER_MERGE_LOG 0 2 22 0 Table

Information on previously merged customers

CUSTOMER_SUBSIDY_ALLOCATIONS 0 0 10 0 Table

Customer subsidy allocations table

CUSTOMER_PHOTOS 0 1 8 0 Table

Customer photos for passes

SYSTEM_USER_PROFILES 0 2 8 0 Table

Authorization profiles assigned to system users

DISCLAIMERS 2 1 9 0 Table

Contains information on configured disclaimers

SAVED_CREDIT_CARDS 2 5 24 0 Table

Saved credit card and electronic payment information

PREREQUISITES 0 9 22 0 Table

Your organization’s defined prerequisites for activities and programs

SUBSIDY_DEFAULT_ALLOCATIONS 0 0 12 0 Table

Subsidy default allocations table

ACTIVITY_TYPES 1 0 9 0 Table

Your organization’s defined activity types

GIFT_CARD_TYPE_SITES 0 2 8 0 Table

Contains information on site restrictions for gift card types

MULTIGLFEE 0 0 12 0 Table

Addtional GL fee items

CUSTOMER_THIRD_PARTY_BILLING_LINKS 0 8 15 0 Table

Contains the amounts that have been billed to third parties for customer transactions

ENTRY_POINTS 4 1 21 0 Table

Your organization’s defined entry points

PROGRAM_REGISTRATIONS 1 12 58 0 Table

FlexReg registrations by session date

CUSTOMERACCOUNTS 0 0 21 0 Table

Customer accounts

COUPON_USAGE 0 5 12 0 Table

Coupon usage information

RESERVATION_DATE_RANGES 3 1 27 0 Table

Contains information on configured reservation date ranges

POSTPONEMENT_REASONS 1 0 6 0 Table

Your organization’s defined postponement reasons

ACTIVITY_DEPARTMENTS 6 3 10 0 Table

Your organization’s defined activity departments

STAGES 2 2 23 0 Table

Your organization’s defined stages and checklist items

SUSPENSION_TRANSACTION 0 0 23 0 Table
TEAMS 7 6 21 0 Table

Your organization’s defined teams and groups

SITES 63 9 65 0 Table

Organization’s sites. Can be used in various joins E.g. Activity Site, Revenue Site, Transaction Site

SKIP_DATES 2 2 23 0 Table

Contains information on configured skip dates

POS_RECEIPTS 1 0 8 0 Table

Your organization’s defined POS receipts

PRELIMINARY_DRAFTS 0 6 26 0 Table

Contains information on upcoming membership renewals

FINANCIAL_GL_TRANSACTIONS 0 0 36 0 Table

DEPRECATED - REPLACED BY hub.RECEIPT_GL_POSTINGS

REPORT_DEFINITIONS 1 1 39 0 Table

Your organization’s report definitions which have been saved for reprinting or scheduling

ACTIVITY_FEES 2 6 76 0 Table

Master table showing defined activity fees data

WISHLISTS 0 4 15 0 Table

The record of a customer’s expressed interest in following the availability of an activity or program

POS_PRODUCTS_CENTER_QUANTITY 0 4 14 0 Table

Master table showing POS product inventory levels and settings per center and site

ACTIVITY_SCHEDULED_FEE_RATES 0 0 9 0 Table

Table containing Activity Fee Changes based on Activity Start Date

LOCKER_SCHEDULES 0 5 12 0 Table

Contains information on locker reservations

WORKSTATIONS 20 26 95 0 Table

Master table showing defined workstations data

OCCUPATIONS 1 0 7 0 Table

Your organization’s defined occupations

CUSTOMER_SCHOLARSHIPS 2 2 27 0 Table

Customers’ data for granted scholarships

PARTICIPANT_ZONE_POSTAL_CODES 0 0 8 0 Table

Postal codes that are eligible for priority registration grouped into zones

RECEIPT_DETAIL_PAYMENTS 0 3 12 0 Table

Contains the payment distribution to each receipt detail item that it is applied to

CUSTOM_QUESTIONS 2 2 31 0 Table

Custom questions, for customers and transactions

COUPON_QUALIFICATIONS 0 17 33 0 Table

Coupon qualification information

FACILITY_OPEN_TIMES 0 2 12 0 Table

Contains information on facility open and close times per day of the week

CUSTOMER_TYPES 12 0 9 0 Table

Your organization’s defined customer types

FACILITY_AVAILABILITY 0 4 17 0 Table

Contains facility availability information by date

FACILITY_TYPES 4 5 48 0 Table

Contains information on defined facility types

STANDARD_CHARGES 3 10 59 0 Table

Master table showing defined standard resource charges data

FACILITY_USERS 0 2 9 0 Table

Contains information on configured users and approvers for facilities

AR_SCHEDULED_DETAILS 1 13 30 0 Table

Contains detailed due date information of payment plans where the due date has an outstanding balance

PRODUCT_CLASSES 5 1 7 0 Table

Your organization’s defined product classes

MEMBERSHIP_RISK_SCORE 0 0 30 0 Table

Membership retention scoring and classification

DEFERRED_REVENUE_PROJECTIONS 0 13 25 0 Table

Contains detailed projections of future revenue to be recognized for current deferred revenue postings

PACKAGES 22 3 31 0 Table

Master table showing packages detail

TRANSACTION_STAGES 0 6 28 0 Table

Contains stages required for individual transactions

ACTIVITY_PRIVATE_LESSONS 1 8 23 0 Table

Instructor time slot reservation data for private lesson enrollments

CUSTOMER_SCHOLARSHIP_QUALIFICATIONS 0 9 26 0 Table

Customers’ data for granted scholarship qualifications

MEMBERSHIP_RISK_STATS 0 0 18 0 Table

Membership Risk Stats as of date

RECEIPT_PAYMENTS 6 13 46 0 Table

Posted receipt payment data

SYSTEM_USERS 34 2 28 0 Table

Organization’s system users

EVENT_TYPES 9 4 30 0 Table

Contains information on defined event types for reservations

LOCKER_DATE_RANGES 0 2 7 0 Table

Your organization’s defined locker date ranges for reservations

COMPANY_AUTHORIZED_AGENTS 0 3 10 0 Table

Company authorized agent details

GIFT_CARDS 2 6 22 0 Table

Contains information on gift cards that have been sold

STAGE_SEQUENCES 3 0 6 0 Table

Your organization’s defined stage sequences

ACTIVITYATTENDANCE 0 0 20 0 Table

Attendance details of an Activity

RECEIPT_HEADERS 9 4 34 0 Table

Receipt header records for transactions and payments

ACTIVITY_PARTICIPANT_ZONES 0 0 8 0 Table

Participant Zones that are eligible for priority registration for an activity

SKILLS 1 0 12 0 Table

Your organization’s defined skills

CHARGE_QUALIFICATION_LINKS 0 24 36 0 Table

Master table containing defined charge and fee qualification links

PACKAGE_PREREQUISITES 0 5 17 0 Table

Your organization’s defined prerequisites for membership packages

CUSTOMER_SKILLS 0 0 13 0 Table

Data for Customers that have skills applied to their account as can be seen in the ACTIVENet Customer Skills Report

ACCOUNT_CREDIT_HISTORY 1 9 20 0 Table

Account credit transaction history for customers and companies

CHILD_SEASONS 4 1 21 0 Table

Your organization’s defined child seasons

SUPERVISORS 3 2 12 0 Table

Master table showing Supervisor details

FACILITY_RENTAL_BLOCKS 0 2 12 0 Table

Contains information on facility rental blocks

STAGE_SEQUENCE_LINKS 0 6 12 0 Table

Contains stage sequence links to individual subject areas (for internal use)

GENDERS 6 0 11 0 Table

Your organization’s defined genders

TEAM_CONTACTS 0 4 14 0 Table

Your organization’s defined team contacts

PROGRAM_TYPES 6 0 6 0 Table

Your organization’s defined program types

REASONS 8 0 8 0 Table

Your organization’s defined reasons, used for withdrawals, cancellations, suspensions, etc.

LEAGUE_SCHEDULE_TIMESLOTS 0 2 11 0 Table

Your organization’s defined league schedule timeslots

PERMITS 5 6 27 0 Table

Table containing rental permit data

DEMOGRAPHICS 0 0 6 0 Table

Your organization’s defined demographics

NOTE_ALERT_TYPES 1 0 7 0 Table

Your organization’s defined note alert types

LEAGUES 7 5 33 0 Table

Your organization’s defined leagues

SUBSIDY_USAGES 0 0 15 0 Table

Subsidy usages table

ACTIVITY_DIVISIONS 1 2 11 0 Table

Your organization’s defined activity divisions

TRANSACTIONS 25 28 85 0 Table

Posted transaction data

ALTERNATE_KEY_STATUSES 5 0 10 0 Table

Your organization’s defined customer alternate key statuses

SEASONS 7 1 20 0 Table

Your organization’s defined seasons

SAVED_CREDIT_CARD_HISTORY 0 8 24 0 Table

History of updates and deletions of saved credit card and electronic payment information

AR_SCHEDULED_HEADERS 3 9 29 0 Table

Contains summary information of payment plans which have an outstanding balance

SYSTEM_GL_ACCOUNT_PACKAGES 11 12 19 0 Table

Your organization’s defined system GL account packages

CUSTOM_QUESTION_LINKED_ANSWERS 0 0 18 0 Table

Predefined answers for custom questions (for internal use).

FROM_EMAIL_ADDRESSES 0 1 9 0 Table

Your organization?s defined from email addresses to be used in outgoing emails

MEMBERSHIP_AUDIT_LOG 0 10 35 0 Table

Membership history

PACKAGE_FEES 2 5 52 0 Table

Master table showing defined package fees data

ANET_DELETE_TRACKING_LOG 0 0 14 0 Table

Internal processing table

REQUEST_REFUND 0 0 16 0 Table

Refund Requests

SYSTEM_USAGE_LOG 0 4 16 0 Table

Contains system access information for staff users and online customers

ARTRANSACTIONS 0 0 23 0 Table

AR Transaction details

FAMILY_ROLES 1 0 8 0 Table

Your organization’s defined family roles

LEAGUE_SCHEDULE_PAIRINGS 1 7 32 0 Table

Your organization’s defined league schedule match and game pairings

CUSTOMER_THIRD_PARTY_BILLINGS 1 2 16 0 Table

Your organization’s configured customer third-party billings

PRODUCT_SUBCLASSES 4 1 7 0 Table

Your organization’s defined product subclasses

RECEIPT_DETAILS 8 15 101 0 Table

Posted receipt detail data

REFERENCE_VALUES 0 0 9 0 Table

Miscellaneous reference values to support cascading updates.

PACKAGE_LINKS 0 3 10 0 Table

Contains information on related records that are linked to package records (for internal use)