ACTIVITIES

0 rows


Description

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

Columns

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

The Hub record ID
ACTIVITY_ID int 4 √ null
ACTIVITY_DATES.ACTIVITY_ID Defined in XML R
ACTIVITY_DIVISIONS.ACTIVITY_ID Defined in XML R
ACTIVITY_ENROLLMENTS.ACTIVITY_ID Defined in XML R
ACTIVITY_FEES.ACTIVITY_ID Defined in XML R
ACTIVITY_PRIVATE_LESSONS.ACTIVITY_ID Defined in XML R
ACTIVITY_RESERVATION_PATTERNS.ACTIVITY_ID Defined in XML R
ACTIVITY_TEAM_CATEGORIES.ACTIVITY_ID Defined in XML R
AR_SCHEDULED_DETAILS.ACTIVITY_ID Defined in XML R
CHARGE_QUALIFICATION_LINKS.ACTIVITY_ID Defined in XML R
COUPON_BATCH_QUALIFICATIONS.ACTIVITY_ID Defined in XML R
COUPON_QUALIFICATIONS.ACTIVITY_ID Defined in XML R
CUSTOM_QUESTION_ANSWERS.ACTIVITY_ID Defined in XML R
CUSTOMER_SCHOLARSHIP_QUALIFICATIONS.ACTIVITY_ID Defined in XML R
DEFERRED_REVENUE_PROJECTIONS.ACTIVITY_ID Defined in XML R
FACILITY_RENTAL_BLOCKS.ACTIVITY_ID Defined in XML R
FACILITY_RESERVATION.ACTIVITY_ID Defined in XML R
INTEREST_LISTS.ACTIVITY_ID Defined in XML R
LEAGUES.ACTIVITY_ID Defined in XML R
PREREQUISITES.ACTIVITY_ID Defined in XML R
PREREQUISITES.PREREQUISITE_ACTIVITY_ID Defined in XML R
TEAMS.ACTIVITY_ID Defined in XML R
TRANSACTIONS.ACTIVITY_ID Defined in XML R
WISHLISTS.ACTIVITY_ID Defined in XML R

The ID of this activity
SITE_ID int 4 √ null
SITES.SITE_ID Defined in XML R

The site ID of this activity
ACTIVITYNUMBER varchar 20 √ null

The activity number of this activity
ACTIVITYNAME nvarchar 240 √ null

The name of this activity
ACTIVITY_SUBACTIVITY varchar 20 √ null

Whether this is a sub-activity (Activity / SubActivity)
ACTIVITYSTATUS_ID int 4 √ null

The current status ID of this activity
ACTIVITY_STATUS_DESC varchar 50 √ null

The current status description of this activity
ACTIVITY_TYPE_ID int 4 √ null
ACTIVITY_TYPES.ACTIVITY_TYPE_ID Defined in XML R

The activity type ID of this activity
ACTIVITY_CATEGORY_ID int 4 √ null
ACTIVITY_CATEGORIES.ACTIVITY_CATEGORY_ID Defined in XML R

The activity category ID of this activity
ACTIVITY_OTHER_CATEGORY_ID int 4 √ null
ACTIVITY_SUB_CATEGORIES.ACTIVITY_SUB_CATEGORY_ID Defined in XML R

The activity subcategory ID of this activity
ACTIVITY_DEPARTMENT_ID int 4 √ null
ACTIVITY_DEPARTMENTS.ACTIVITY_DEPARTMENT_ID Defined in XML R

The activity department ID of this activity
FACILITY_ID int 4 √ null
FACILITIES.FACILITY_ID Defined in XML R

The facility ID of this activity
INSTRUCTOR_ID int 4 √ null
INSTRUCTORS.INSTRUCTOR_ID Defined in XML R

The primary instructor ID of this activity
SUPERVISOR_ID int 4 √ null
SUPERVISORS.SUPERVISOR_ID Defined in XML R

The supervisor ID of this activity
BEGINNINGDATE datetime 16,3 √ null

The beginning date of this activity
ENDINGDATE datetime 16,3 √ null

The ending date of this activity
AGESMIN int 4 √ null

The minimum age (years) allowed for this activity
AGESMAX int 4 √ null

The maximum age (years) allowed for this activity
NUMBEROFSESSIONS int 4 √ null

The total number of sessions for this activity
NUMBEROFHOURS money 21,4 √ null

The total number of hours for this activity
NUMBER_OF_HOLDS int 4 √ null

The current number of holds for this activity
NUMBER_WAITLISTS int 4 √ null

The current number of people waitlisted for this activity
NUMBER_OPEN int 4 √ null

The current number of openings for this activity
ENROLLMIN int 4 √ null

The minimum number of enrollees for this activity
ENROLLMAX int 4 √ null

The maximum number of enrollees for this activity
ENROLLED int 4 √ null

The current number of enrollees for this activity
ENROLLSTATUS varchar 25 √ null

The current enrollment status for the activity (Under Minimum, Under Maximum, Full, Full with Waiting List)
FILLRATE float 8 √ null

The Fill Rate is calculated using the following formula: % (# of Registrations / Max Registration). Pseudocode: If ACTIVITIES.IGNOREMAXIMUM <> 0 then null else if ACTIVITIES.ENROLLMAX = 0 and ACTIVITIES.IGNOREMAXIMUM = 0 and ACTIVITYSTATISTICS.NUMBER_ENROLLED = 0 then 0 Else if ACTIVITIES.ENROLLMAX = 0 and ACTIVITIES.IGNOREMAXIMUM = 0 and ACTIVITYSTATISTICS.NUMBER_ENROLLED <> 0 then 1 else ACTIVITYSTATISTICS.NUMBER_ENROLLED/ (1.00 * ACTIVITIES.ENROLLMAX)
REVENUE money 21,4 √ null

The revenue amount for the activity excluding tax
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
ALLOW_DROPIN varchar 5 √ null

Are drop-ins allowed for this activity?
DROPIN_FEE_CHARGE_AMOUNT money 21,4 √ null

The drop-in charge amount for the activity if set
ORG_ID int 4 √ null

Your organization’s unique identifier in the Active Net system
SEASON_ID int 4 √ null
SEASONS.SEASON_ID Defined in XML R

The parent season ID of the activity
CHILD_SEASON_ID int 4 √ null
CHILD_SEASONS.CHILD_SEASON_ID Defined in XML R

The child season ID of the activity
CREATE_MEETING_DATES varchar 5 √ null

Whether meeting dates should be generated for the activity (Yes/No)
RESERVE_FACILITIES varchar 5 √ null

Whether facilities should be reserved for the generated activity meeting dates (Yes/No)
GENDER_INDEX int 4 √ null
GENDERS.GENDER_INDEX Defined in XML R

The gender ID of the activity
AGE_CALC_DATE date 20 √ null

The start date for calculating participant age
AGE_MAX_WEEKS int 4 √ null

Maximum participant age (weeks) of the activity
AGE_MIN_WEEKS int 4 √ null

Minimum participant age (weeks) of the activity
AGE_MAX_MONTHS int 4 √ null

Maximum participant age (months) of the activity
AGE_MIN_MONTHS int 4 √ null

Minimum participant age (months) of the activity
ALLOW_ADD_GROUP_MEMBER varchar 5 √ null

Whether individual group members can be added for this activity (Yes/No)
ALLOW_ADD_TEAM_MEMBER varchar 5 √ null

Whether individual team members can be added for this activity (Yes/No)
ALLOW_AMEND_GROUP_MEMBERS varchar 5 √ null

Whether group contacts are allowed to amend member registration information (Yes/No)
ALLOW_AMEND_TEAM_MEMBERS varchar 5 √ null

Whether team contacts are allowed to amend member registration information (Yes/No)
ALLOW_ATTENDANCE_ENTRY varchar 15 √ null

Whether attendance can be entered for this activity (Yes / No / Use Default)
ALLOW_PRIVATE_LESSON_BOOKINGS_ONLINE varchar 5 √ null

Whether this activity allows private lesson bookings online (Yes/No)
ALLOW_CHANGE_MAX_BOOKING varchar 5 √ null

Whether selecting desired private lesson booking quantity per enrollee is allowed (Yes/No)
ALLOW_CHANGE_MAX_BOOKING_ONLINE varchar 5 √ null

Whether selecting desired private lesson booking quantity per enrollee is allowed online (Yes/No)
ALLOW_EDIT_GROUP_MEMBER_SKILLS varchar 5 √ null

Whether group contacts are allowed to edit member skills (Yes/No)
ALLOW_EDIT_GROUP_INFO varchar 5 √ null

Whether group contacts are allowed to edit group information (Yes/No)
ALLOW_EDIT_GROUP_MEMBER_INFO varchar 5 √ null

Whether group contacts are allowed to edit member information (Yes/No)
ALLOW_EDIT_PARTICIPANT_SKILL_ONLINE varchar 5 √ null

Whether instructors are allowed to edit participant skills online (Yes/No)
ALLOW_EDIT_TEAM_INFO varchar 5 √ null

Whether team contacts are allowed to edit team information (Yes/No)
ALLOW_EDIT_TEAM_MEMBER_INFO varchar 5 √ null

Whether team contacts are allowed to edit member information (Yes/No)
ALLOW_EDIT_TEAM_MEMBER_SKILLS varchar 5 √ null

Whether team contacts are allowed to edit member skills (Yes/No)
ALLOW_ENROLL_WITH_DEPOSIT varchar 5 √ null

Whether this activity allows enrollment with deposit (Yes/No)
ALLOW_GROUP_ADD varchar 5 √ null

Whether group creation is allowed for this activity (Yes/No)
ALLOW_GROUP_ADD_ONLINE varchar 5 √ null

Whether group creation is allowed online for this activity (Yes/No)
ALLOW_IGNORE_CATEGORY_SCHEDULE_CONFLICT varchar 5 √ null

Whether users should be allowed to ignore schedule conflicts except for conflicts in the same activity category (Yes/No)
ALLOW_IGNORE_SCHEDULE_CONFLICT varchar 5 √ null

Whether users should be allowed to ignore schedule conflicts during enrollment (Yes/No)
ALLOW_PRE_BOOK_PRIVATE_LESSON_ONLY_ONLINE varchar 15 √ null

Whether pre-booked private lessons are allowed (Yes / No / Use Default)
ALLOW_PRE_BOOK_PRIVATE_LESSON_ONLY_STAFF varchar 15 √ null

Whether pre-booked private lessons are allowed online (Yes / No / Use Default)
ALLOW_PRIORITY_REGISTRATION varchar 5 √ null

Whether priority registration for returning participants is enabled for this activity (Yes/No)
ALLOW_PRIVATE_LESSON_BOOKINGS varchar 5 √ null

Whether this activity allows private lesson bookings (Yes/No)
ALLOW_REMOVE_GROUP_MEMBERS varchar 5 √ null

Whether group contacts are allowed to remove group members (Yes/No)
ALLOW_REMOVE_TEAM_MEMBERS varchar 5 √ null

Whether team contacts are allowed to remove team members (Yes/No)
ALLOW_ROLLOVER_HOLD_SEAT varchar 5 √ null

Whether a hold is placed on registration seats for enrollees of the activity during rollover (Yes/No)
ALLOW_SELLING_PREREQUISITE_MEMBERSHIP_WHEN_WAITLISTING varchar 5 √ null

Whether a prerequisite membership may be purchased when waitlisting online (Yes/No)
ALLOW_SUB_ACTIVITY_TEAM_MANAGEMENT varchar 5 √ null

Whether team/group management for sub-activities is allowed (Yes/No)
ALLOW_TEAM_ADD varchar 5 √ null

Whether team creation is allowed for this activity (Yes/No)
ALLOW_TEAM_ADD_ONLINE varchar 5 √ null

Whether team creation is allowed online for this activity (Yes/No)
ALLOW_TEAM_CONTACT_TO_DISABLE_PAYPLAN_USE varchar 5 √ null

Whether team/group contacts are allowed to set whether new members can select payment plan (Yes/No)
ALLOW_TEAM_ROLLOVER_ONLINE varchar 5 √ null

Whether team rollover is allowed during online enrollment (Yes/No)
ALLOW_THIRD_PARTY_BILLING varchar 5 √ null

Whether third-party billing should be available for this activity (Yes/No)
ALLOW_TRANSFER varchar 5 √ null

Whether this activity allows transfer to a different activity (Yes/No)
ALLOW_TRANSFER_GROUP_MEMBERS varchar 5 √ null

Whether group contacts are allowed to transfer group members (Yes/No)
ALLOW_TRANSFER_TEAM_MEMBERS varchar 5 √ null

Whether team contacts are allowed to transfer team members (Yes/No)
ALLOW_TRIAL_CLASS varchar 5 √ null

Whether this activity allows trial enrollments (Yes/No)
ALLOW_VIEW_AND_PAY_GROUP_OUTSTANDING_BALANCES varchar 5 √ null

Whether group contacts are allowed to view and pay member outstanding balances (Yes/No)
ALLOW_VIEW_AND_PAY_TEAM_OUTSTANDING_BALANCES varchar 5 √ null

Whether team contacts are allowed to view and pay member outstanding balances (Yes/No)
ALLOW_VIEW_GROUP_CUSTOM_QUESTIONS_AND_ANSWERS varchar 5 √ null

Whether group contacts are allowed to view member custom questions and answers (Yes/No)
ALLOW_VIEW_GROUP_MEMBERS varchar 5 √ null

Whether group contacts are allowed to view member information (Yes/No)
ALLOW_VIEW_TEAM_MEMBERS varchar 5 √ null

Whether team contacts are allowed to view member information (Yes/No)
ALLOW_VIEW_TEAM_CUSTOM_QUESTIONS_AND_ANSWERS varchar 5 √ null

Whether team contacts are allowed to view member custom questions and answers (Yes/No)
ALLOW_WAITLISTING varchar 5 √ null

Whether this activity allows waitlisting (Yes/No)
ALLOW_WITHDRAWAL varchar 5 √ null

Whether this activity allows withdrawal (Yes/No)
BOOKING_PATTERN_FREQUENCY varchar 10 √ null

Private lesson booking pattern frequency (Weekly / Bi-Weekly / Monthly / None)
BOOKING_PATTERN_SAME_DAY_OF_WEEK varchar 5 √ null

Private lesson booking pattern keep same day of week (Yes/No)
BOOKING_PATTERN_SAME_TIME varchar 5 √ null

Private lesson booking pattern keep same start and end times (Yes/No)
COPIED_FROM_ACTIVITY_ID int 4 √ null

The ID of the activity that this activity was copied from
CATALOG_DESCRIPTION varchar 8000 √ null

The catalog description to be displayed for this activity
TAX_RECEIPT_ELIGIBLE varchar 5 √ null

Whether this activity is eligible for tax receipts (Yes/No)
ENABLE_DEFERRED_REVENUE varchar 15 √ null

Whether deferred revenue is enabled for this activity (Yes / No / Use Default)
ENABLE_PRIVATE_LESSON_DATES varchar 5 √ null

Whether private lesson dates are enabled to override activity dates (Yes/No)
ENABLE_RESERVABLE_ON_MEMBER_APP varchar 5 √ null

Show on ACTIVE Net Captivate App (Yes/No)
ENDING_TIME time 16 √ null

The default ending time for activity classes
ENFORCE_BOOKING_PATTERN varchar 5 √ null

Whether this private lesson activity enforces a booking pattern (Yes/No)
EXCLUDE_IN_CATALOG varchar 5 √ null

Whether this activity should be excluded from any generated catalog of activities (Yes/No)
MAX_GRADE_ID int 4 √ null
GRADES.GRADE_ID Defined in XML R

The maximum grade ID for participants of this activity
MIN_GRADE_ID int 4 √ null
GRADES.GRADE_ID Defined in XML R

The minimum grade ID for participants of this activity
HIDE_ON_INTERNET varchar 5 √ null

Whether this activity should be excluded from display online (Yes/No)
INTERNET_REGISTRATION_DATE_TIME datetime 16,3 √ null

The date and time that registration opens for online enrollments
INTERNET_REGISTRATION_END_DATE_TIME datetime 16,3 √ null

The date and time that registration ends for online enrollments
IS_SEARCHABLE varchar 5 √ null

Whether this activity is searchable in the online catalog (Yes/No)
IN_PERSON_REGISTRATION_DATE_TIME datetime 16,3 √ null

The date and time that registration opens for in-person enrollments
IN_PERSON_REGISTRATION_END_DATE_TIME datetime 16,3 √ null

The date and time that registration ends for in-person enrollments
ROSTER_LAST_PRINTED_DATE_TIME datetime 16,3 √ null

The date and time that a roster was last printed for this activity
MAX_ENROLLED_ONLINE_UNTIL_DAY int 4 √ null

The number of days after in-person registration starts that the online quota override is enforced for
MAX_LESSONS_PER_ENROLLEE int 4 √ null

The maximum number of private lessons permitted per enrollee
MAX_NUM_ENROLLEE_PER_LESSON int 4 √ null

The maximum number of enrollees per private lesson time slot
MAX_QUANTITY_BASED_ENROLLMENT int 4 √ null

The maximum quantity that may be enrolled when quantity-based enrollment is enabled
MAX_ENROLLED_ONLINE int 4 √ null

The maximum number of enrollments that may be done online for this activity overriding the online quota
MAX_TEAMS int 4 √ null

The maximum number of teams that may be enrolled in this activity
MEMBER_INTERNET_REGISTRATION_DATE_TIME datetime 16,3 √ null

The date and time that registration opens for online enrollments for members
MEMBER_IN_PERSON_REGISTRATION_DATE_TIME datetime 16,3 √ null

The date and time that registration opens for in-person enrollments for members
MIN_LESSONS_PER_ENROLLEE int 4 √ null

The minimum number of private lessons required per enrollee
MIN_PRIVATE_LESSON_DURATION int 4 √ null

The minimum duration of private lessons in minutes
MAX_PRIVATE_LESSON_DURATION int 4 √ null

The maximum duration of private lessons in minutes
LAST_MODIFIED_DATE_TIME datetime 16,3 √ null

The date and time the activity was last modified
ALLOW_INTERNET_REGISTRATION varchar 5 √ null

Whether online registration is allowed for this activity (Yes/No)
NON_RESIDENT_INTERNET_REGISTRATION_DATE_TIME datetime 16,3 √ null

The date and time that registration opens for in-person enrollments for non-residents
NON_RESIDENT_IN_PERSON_REGISTRATION_DATE_TIME datetime 16,3 √ null

The date and time that registration opens for online enrollments for non-residents
NUMBER_OF_MEETING_DATES int 4 √ null

The number of meeting dates for this activity
ONLINE_ACTIVITY_LOCATION_DESCRIPTION varchar 200 √ null

The activity location description to be displayed online
PARENT_ACTIVITY_ID int 4 √ null

The ID of the activity that is the parent of this activity
PRIVATE_LESSON_BEGINNING_DATE date 20 √ null

The private lesson beginning date (when overriding activity dates)
PRIVATE_LESSON_BOOKING_INTERVAL int 4 √ null

The private lesson booking grid interval in minutes
PRIVATE_LESSON_ENDING_TIME time 16 √ null

The private lesson ending time (when overriding activity dates)
PRIVATE_LESSON_ENDING_DATE date 20 √ null

The private lesson ending date (when overriding activity dates)
PRIVATE_LESSON_MAX_NUM_SEARCH_DAYS int 4 √ null

The private lesson maximum number of days of availability to be displayed in the search date range
PRIVATE_LESSON_NUM_SEARCH_MONTHS int 4 √ null

The private lesson default number of months of availability to be displayed in the search date range
PRIVATE_LESSON_STARTING_TIME time 16 √ null

The private lesson starting time (when overriding activity dates)
PRIVATE_LESSON_WEEKDAYS varchar 7 √ null

Whether private lessons are configured for specific days of the week (when overriding activity dates)
PRIVATE_LESSON_WEEKS_OF_MONTH varchar 5 √ null

Whether private lessons are configured for specific weeks of the month (when overriding activity dates)
RECEIPT_NOTES varchar 8000 √ null

Notes for this activity that should be included on the receipt
REQUIRE_AUTHORIZED_PICKUPS varchar 5 √ null

Whether this activity requires entry of authorized pickups during enrollment (Yes/No)
REQUIRE_USA_HOCKEY_NUMBER varchar 5 √ null

Whether this activity requires entry of USA Hockey number during enrollment (Yes/No)
REQUIRE_WAIVER_INITIALS_ONLINE varchar 5 √ null

Whether this activity requires entry of initials for the waiver online (Yes/No)
REQUIRE_WITHDRAW_REASON varchar 5 √ null

Whether this activity requires entry of a reason during withdrawal (Yes/No)
RESIDENCY_TYPE varchar 20 √ null

The residency requirements for this activity (Resident Only / Non-Resident Only / Both)
RETIRED varchar 5 √ null

Deprecated, use ACTIVITY_STATUS_DESC = “Retired”
ROLLED_OVER_TO_ACTIVITY_ID int 4 √ null

The ID of the activity that this activity has been rolled over to
SHOW_PRICE_INFO_ONLINE varchar 5 √ null

Whether price info for this activity should be displayed online (Yes/No)
SHOW_PRIMARY_FEE_ONLY varchar 5 √ null

Whether only the primary fee for this activity should be displayed online (Yes/No)
SHOW_PRIVATE_LESSON_DATES_ON_RECEIPT varchar 15 √ null

Whether private lesson dates should be included on the receipt (Yes / No / Use Default)
SHOW_SCHOLARSHIP_ONLINE varchar 5 √ null

Whether scholarship info for this activity should be displayed online (Yes/No)
STARTING_TIME time 16 √ null

The default starting time for activity classes
TEAM_ENROLLMENTS_ONLY varchar 5 √ null

Whether this activity only allows team enrollment (Yes/No)
MAX_PLAYERS_PER_TEAM int 4 √ null

The maximum number of players per team for this activity
MIN_PLAYERS_PER_TEAM int 4 √ null

The minimum number of players per team for this activity
WAIVER_TEXT varchar 8000 √ null

Waiver text to be displayed during enrollment for this activity
WEEKDAYS varchar 7 √ null

Whether the activity is configured for specific days of the week
WEEKS_OF_MONTH varchar 5 √ null

Whether the activity is configured for specific weeks of the month
ENROLLMENT_EMAIL_NOTIFICATION_ID int 4 √ null

Enrollment email notification ID
WITHDRAWAL_EMAIL_NOTIFICATION_ID int 4 √ null

Withdrawal email notification ID
SHOW_TEAM_GROUP_REGISTRATION_OPTIONS varchar 5 √ null

Whether team/group registration options should be displayed during online enrollment (Yes/No)
ONLINE_NOTES varchar 8000 √ null

The online notes to be displayed for this activity
ROW_VERSION binary 8 √ null

System timestamp (for internal use)
ACTIVITY_GROUP_ID int 4 √ null
ACTIVITY_GROUPS.ACTIVITY_GROUP_ID Defined in XML R

The activity group ID
ONLINE_URL varchar 255 √ null

The online landing page for this activity
REVENUE_PLUS_TAX money 21,4 √ null

The revenue amount for the activity including tax
IGNOREMAXIMUM varchar 5 √ null

Ignore maximum enrollment setting
IGNORE_PARENTS_MAXIMUM varchar 5 √ null

Ignore parent activity maximum setting
IGNORE_AGE_RESTRICTION_FOR_CONTACT varchar 5 √ null

Ignore age restriction for contact
IGNORE_AGE_RESTRICTION_FOR_GROUP_CONTACT varchar 5 √ null

Ignore age restriction for group contact
IGNOREMAXENROLLEDONLINE varchar 5 √ null

Ignore max enrolled online setting
ALLOW_SUBSIDY varchar 5 √ null

Allow subsidy for activity enrollmen
DISPLAY_DATE datetime 16,3 √ null

DISPLAY DATE for activity
EXTERNAL_EVENT_NUMBER varchar 20 √ null

The number of external event.
LOCAL_PRIORITY_REGISTRATION smallint 2 √ null

Whether the activity allows for priority registration
CANCELLATION_REASON_ID int 4 √ null

Activty cancellation reason ID, from Reasons table.
CANCELLATION_REASON_TEXT varchar 4000 √ null

Activty cancellation reason text, from Reasons table.
CANCELLATION_REASON_DATE datetime 16,3 √ null

Activty cancellation date.

Indexes

Constraint Name Type Sort Column(s)
ACTIVITIES_PK Primary key Asc ACTIVE_HUB_KEY
ACTIVITIES_ACTIVITY_CATEGORY_ID_ACTIVITY_OTHER_CATEGORY_ID_BEGINNINGDATE_IX Performance Asc/Asc/Asc ACTIVITY_CATEGORY_ID + ACTIVITY_OTHER_CATEGORY_ID + BEGINNINGDATE
ACTIVITIES_ACTIVITY_DEPARTMENT_ID_IX Performance Asc ACTIVITY_DEPARTMENT_ID
ACTIVITIES_Activity_ID_ORG_ID_UQ Must be unique Asc/Asc ACTIVITY_ID + ORG_ID
ACTIVITIES_ACTIVITY_OTHER_CATEGORY_ID_IX Performance Asc ACTIVITY_OTHER_CATEGORY_ID
ACTIVITIES_ACTIVITY_TYPE_ID_IX Performance Asc ACTIVITY_TYPE_ID
ACTIVITIES_ACTIVITYNUMBER_IX Performance Asc ACTIVITYNUMBER
ACTIVITIES_BEGINNINGDATE_ENDINGDATE_IX Performance Asc/Asc BEGINNINGDATE + ENDINGDATE
ACTIVITIES_CHILD_SEASON_ID_IX Performance Asc CHILD_SEASON_ID
ACTIVITIES_FACILITY_ID_IX Performance Asc FACILITY_ID
ACTIVITIES_INSTRUCTOR_ID_IX Performance Asc INSTRUCTOR_ID
ACTIVITIES_ORG_ID_IX Performance Asc ORG_ID
ACTIVITIES_PARENT_ACTIVITY_ID_IX Performance Asc PARENT_ACTIVITY_ID
ACTIVITIES_ROW_VERSION_IX Performance Asc ROW_VERSION
ACTIVITIES_SEASON_ID_IX Performance Asc SEASON_ID
ACTIVITIES_SITE_ID_IX Performance Asc SITE_ID
ACTIVITIES_SUPERVISOR_ID_IX Performance Asc SUPERVISOR_ID

Relationships

Close relationships within degrees of separation