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) |