Tables

Utility table useful when report needs to be built on year, month, quarter etc. Usually joins by dt_dt

Postings in the GL ledger, where positive amounts are debits and negative amounts are credits. Does not include voided records.

Contains information on facility types that are linked to each event type that is not configured for all facilities

Reservation patterns for generating activity class dates

Rush event data

Detailed class times and locations per activity

Contains information on equipment hours by date range

LOG of External clients api calls

Payment chargeback information

Contains defined stages that may be initiated from each stage sequence

Customer family details

Your organization’s defined league schedule timeslot configurations

Customers’ details

Membership pass usage history

Zones that are eligible for pririty registration

Membership end of day statistics for all packages, by package (includes site and category). Goes back to the 1st of the month 24 months ago.

Master table showing defined usage fees data

Your organization’s defined CUSTOM_PAYMENT_TYPES

Your organization’s defined league schedule pairing officials

Master table containing defined package fee alternate key qualifications

Your organization’s defined prerequisites for programs

Custom questions for membership sale transactions.

Membership end of day statistics for retention-only packages, by package (includes site and category). Goes back to the 1st of the month 24 months ago.

Predefined answers for activity custom questions.

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

Your organization’s defined activity sub-categories

Customer interest lists for facilities, packages, activities and programs

Voided receipt detail payment data . Only includes voided records.

Your organization’s defined league schedule officials

Your organization’s defined parent locations

Coupon batch information

Your organization’s defined customer waivers

Your organization’s defined alternate key types

Your organization’s information

Customer interest lists for facilities, packages, activities and programs

Contains information on alternate key types which are configured as package prerequisites

Your organization’s defined funds

Subsidy program annual budget VIEW

Contains information on defined activity groups for shared registration capacity

POS product sales

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

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

Your organization’s defined cash summary sheet layouts

Contains information on configured prerequisites for facility reservations

Master table showing GL accounts details

Your organization’s defined locker rooms

Showing the activity enrollments by customer

Your organization’s defined custom question types

Your organization’s defined customer waivers

Your organization’s defined league schedule facilities

Contains information on facility hours by date range

Your organization’s defined geographic areas

FlexReg registration summary by customer, program and session

Your organization’s defined workstation groups

Master table showing instructor facility details

Your organization’s defined product departments

Schedule configuration for payment plans

Your organization’s defined locker banks per locker room

Child-watch registration data by room and customer

Customer accounts

Predefined answers for activity custom questions.

Company details

AR transaction data. Does not include voided records.

Your organization’s defined locker sizes

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

Your organization’s defined child-watch rooms

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

Your organization’s defined activity team categories

Your organization’s defined checklist items

Contains information on defined schedule types for reservations

Master table showing facility details

Master table showing defined global discount data

Master table showing FlexReg program sessions

Customer notes and alerts

Your organization’s defined returning participant criteria for activities

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

Your organization’s defined POS button layouts

Contains information on equipment rental blocks

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

Contains the interest lists that are assigned to each program

Master table showing FlexReg sessions

Coupon batch qualification information

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

Customer subsidies setup VIEW

Contains the parent to child links for stage sequences stages

Provides Instructor Attendance for Activity Sessions as well as Private Lessons

Sudsidy program

Contains information on defined equipment categories

VOIDED AR transaction data.

Voided receipt header records for transactions and payments. Only includes voided records.

Attendance counts of an Activity

Defined open times per package entry point

Columns dynamically generated for questions for program sessions beginning or ending in the past 3 and future 3 months, populated with the most recent answer to that question

Facility schedules VIEW

Your organization’s defined league facilities

Contains the interest lists that are assigned to each package

The log of all payment and refund authorization requests

Membership end of day statistics for retention-only packages, by site. Goes back to the 1st of the month 24 months ago.

Your organization’s defined coupon categories

Master table showing FlexReg programs

Master table showing scheduled fee changes data

Custom questions for membership sale transactions.

Your organization’s defined POS control codes

Your organization’s defined customer titles

Class times and locations per activity as generated from activity reservation templates

Master table showing defined global surcharge data

Membership end of day statistics for all packages, by site and category. Goes back to the 1st of the month 24 months ago.

Your organization’s defined instructor roles

Your organization’s defined team players

Participant Zones that are eligible for priority registration for an activity

Your organization’s defined card types

Contains information on equipment types that are linked to each event type that is not configured for all equipment

Contains the program attendance history of registrant drop-offs and pick-ups

Master table showing defined locker fees data

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

Your organization’s defined school grades

History of membership package holder customers

Your organization’s defined entry points per membership package

Your organization’s defined team categories

Membership end of day statistics details for all packages.

Your organization’s defined league officials

Custom question and answer details, for customers and transactions. Includes all answers from 2019-07-01 to current.

Your organization’s defined lockers

Your organization’s defined officials

Your organization’s defined activity categories

Voided receipt detail data. Only includes voided records.

Master table showing defined charges data

Membership end of month statistics for all packages, by site. Goes back to the end of January 4 years ago.

Membership end of month statistics for retention-only packages, by site. Goes back to the end of January 4 years ago.

Custom questions for membership sale transactions.

Your organization’s defined campaigns

Master table containing defined customer scholarship charge qualifications

Table showing a breakdown of permit revenue per facility and date

Contains information on configured parent and child relationships between facilities

Your organization’s defined prerequisites for activities

Membership end of day statistics for retention-only packages, by site and category. Goes back to the 1st of the month 24 months ago.

Contains information on reservation groups

Membership end of day statistics for all packages, by category. Goes back to the 1st of the month 24 months ago.

Your organization’s defined league no play dates

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

Contains information on equipment that is linked to each reservation group

Membership end of month statistics for all packages, by site and category. Goes back to the end of January 4 years ago.

Contains the interest lists that are assigned to each activity

Custom questions for activity enrollment transactions.

Your organization’s defined age categories

Columns dynamically generated for point of sale questions answered in the last 36 months, populated with the answer to that question

Updated credit card information

Contains family members and their assigned family head of household

Membership end of month statistics for all packages, by category. Goes back to the end of January 4 years ago.

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

All defined customer alternate keys

Record of who is authorized to pick up who

Master table containing defined activity fee multi-person qualifications

Your organization’s defined centers

Contains stage sequence links to event types that will initiate the stage sequence stage

Sudsidy program

Your organization’s defined league types

Your organization’s defined league schedules

Columns dynamically generated for each customer prospect question, populated with the answer to that question

Master table containing defined program fee alternate key qualifications

DEPRECATED: Please use views dbo.PROGRAM_SESSIONS or dbo.SESSIONS_ONLY instead

Contains facility utilization information by date. For reservations that ended in the past 36 months or which will begin in the next 12 months.

Your organization’s defined contact types

Your organization’s defined profiles

Your organization’s defined league contacts

Your organization’s defined gift card types

Contains information on defined activity groups for shared registration capacity

Coupon information

Master table containing defined activity fee package qualifications

Columns dynamically generated for membership questions answered in the last 36 months, populated with the most recent answer to that question

Contains information on event type capacity per facility

Your organization’s defined package categories

Payment plan configurations

Master table showing defined POS products

Contains stage sequence links to facility types that will initiate the stage sequence stage

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

Master table showing defined program fees data

Your organization’s defined activity grades

Master table showing instructor details

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

Information on previously merged customers

Customer subsidy allocations VIEW

Master table showing FlexReg program session dates

Contains stage sequence links to customer types that will initiate the stage sequence stage

Customer photos for passes

Authorization profiles assigned to system users

Contains information on configured disclaimers

Questions contained within custom question groups.

Voided receipt payment data. Only includes voided records.

Custom question groups, for customers and transactions.

Saved credit card and electronic payment information

Membership end of day statistics for retention-only packages, by category. Goes back to the 1st of the month 24 months ago.

Custom questions for membership renewal transactions.

Contains information on instructor facility rental blocks

Your organization’s defined prerequisites for activities and programs

Master table containing defined activity fee package qualifications

Subsidy default allocations VIEW

Your organization’s defined activity types

Contains information on instructor facility hours by date range

Contains information on site restrictions for gift card types

Addtional GL fee items

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

Your organization’s defined entry points

FlexReg registrations by session date

DEPRECATED - REPLACED BY dbo.VOIDED_RECEIPT_GL_POSTINGS

Your organization’s defined program net revenue

Attendance details of an Activity

Coupon usage information

Contains information on configured reservation date ranges

Your organization’s defined postponement reasons

Your organization’s defined activity departments

Master table containing defined activity fee activity qualifications

Contains stage sequence links to custom questions that will initiate the stage sequence stage

Membership end of month statistics for retention-only packages, by site and category. Goes back to the end of January 4 years ago.

Master table showing equipment details

Contains information on facilities that are linked to each reservation group

Contains information on instructor facilities that are linked to each reservation group

Voided transaction data. Only includes voided records.

Your organization’s defined stages

Your organization’s defined teams and groups

Contains stage sequence links to facilities that will initiate the stage sequence stage

Contains information on alternate key statuses which are configured as package prerequisites

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

Contains information on configured skip dates

Your organization’s defined POS receipts

Contains information on upcoming membership renewals

DEPRECATED - REPLACED BY dbo.RECEIPT_GL_POSTINGS

Contains information on reservation date ranges assigned to each facility type

Membership end of month statistics for all packages, by package (includes site and category). Goes back to the end of January 4 years ago.

Master table containing defined global discount qualifications

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

Master table showing defined activity fees data

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

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

Contains information on facilities that are linked to each event type that is not configured for all facilities

View containing scheduled fee rates and associated activity details.

Contains information on locker reservations

Master table showing defined workstations data

Your organization’s defined occupations

Customers’ data for granted scholarships

Columns dynamically generated for each Customer questions, populated with the most recent answer to that question

Postal codes that are eligible for priority registration grouped into zones

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

Custom questions for customers

Custom questions, for customers and transactions

Equipment Lending transaction history

Coupon qualification information

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

Your organization’s defined customer types

Contains facility availability information by date, calculated for the past 36 months and into the future for the next 12 months.

Membership end of month statistics for retention-only packages, by package (includes site and category). Goes back to the end of January 4 years ago.

Contains information on defined facility types

Master table showing defined standard resource charges data

Contains information on configured users and approvers for facilities

Contains information on facilities to be closed during the skip date period

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

Your organization’s defined product classes

Membership retention scoring and CLASSification

Contains detailed projections of future revenue to be recognized for current deferred revenue postings. The data is generated daily for an as-of date of the end of day yesterday.

Master table showing packages detail

Contains stages required for individual transactions

Instructor time slot reservation data for private lesson enrollments

Customers’ data for granted scholarship qualifications

Posted receipt payment data. Does not include voided records.

Columns dynamically generated for each question attached to an Activity beginning or ending in the past 3 and future 3 months, populated with the most recent answer to that question

Organization’s system users

Contains information on defined event types for reservations

Your organization’s defined locker date ranges for reservations

Company authorized agent details

Contains information on gift cards that have been sold

Your organization’s defined stage sequences

Receipt header records for transactions and payments. Does not include voided or abandoned records.

Participant Zones that are eligible for priority registration for an activity

Your organization’s defined skills

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

Your organization’s defined prerequisites for membership packages

Master table showing defined scholarship charge data

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

Account credit transaction history for customers and companies

Your organization’s defined child seasons

Master table showing Supervisor details

Contains information on facility rental blocks

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

Your organization’s defined genders

Your organization’s defined team contacts

Your organization’s defined program types

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

Master table containing defined standard charge alternate key qualifications

Master table containing defined charge activity qualifications

Your organization’s defined league schedule timeslots

Table containing rental permit data

Your organization’s defined demographics

Your organization’s defined note alert types

Your organization’s defined leagues

Subsidy usages VIEW

Your organization’s defined activity divisions

Posted transaction data. Does not include voided records.

Your organization’s defined customer alternate key statuses

Your organization’s defined seasons

Contains information on defined equipment types

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

Contains summary information of payment plans which have an outstanding balance

Membership end of month statistics for retention-only packages, by category. Goes back to the end of January 4 years ago.

Contains information on equipment to be closed during the skip date period

Your organization’s defined system GL account packages

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

Predefined answers for custom questions (for internal use).

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

Membership history

Master table showing defined package fees data

Refund Requests

Contains system access information for staff users and online customers

Custom questions for program enrollment transactions.

Your organization’s defined family roles

Your organization’s defined league schedule match and game pairings

Contains the interest lists that are assigned to each facility

Voided transactions in the GL ledger, where positive amounts are debits and negative amounts are credits. Only includes voided records.

Your organization’s configured customer third-party billings

Your organization’s defined product subclasses

Membership end of day statistics for all packages, by site. Goes back to the 1st of the month 24 months ago.

Posted receipt detail data. Does not include voided records.

Miscellaneous reference values to support cascading updates.

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

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

Membership end of day statistics details for all packages.

Columns dynamically generated for facility permit questions answered for permits with event start and end dates in the past 3 and future 3 months, populated with the most recent answer to that question