Club Speed integration summary

Stitch’s Club Speed integration replicates data using the Club Speed API . Refer to the Schema section for a list of objects available for replication.

Club Speed feature snapshot

A high-level look at Stitch's Club Speed (v1.0) integration, including release status, useful links, and the features supported in Stitch.

STITCH
Release Status Released Supported By

Singer Community

Stitch Plan

Free

Singer GitHub Repository

Club Speed Repository

DATA SELECTION
Table Selection

Supported

Column Selection

Supported

REPLICATION SETTINGS
Anchor Scheduling

Supported

Advanced Scheduling

Unsupported

Table-level Reset

Unsupported

Configurable Replication Methods

Unsupported

TRANSPARENCY
Extraction Logs

Supported

Loading Reports

Supported

Connecting Club Speed

Club Speed setup requirements

To set up Club Speed in Stitch, you need:

  • A Club Speed API key. To use Stitch’s Club Speed integration, you’ll need an API key generated by Club Speed. Reach out to Club Speed support to have them generate this credential for you.

    After you’ve received the API key, you can complete the setup in Stitch.

Step 1: Add Club Speed as a Stitch data source

  1. Sign into your Stitch account.
  2. On the Stitch Dashboard page, click the Add Integration button.

  3. Click the Club Speed icon.

  4. Enter a name for the integration. This is the name that will display on the Stitch Dashboard for the integration; it’ll also be used to create the schema in your destination.

    For example, the name “Stitch Club Speed” would create a schema called stitch_club_speed in the destination. Note: Schema names cannot be changed after you save the integration.

  5. In the Club Speed Subdomain field, enter your Club Speed subdomain. For example: If the full subdomain were stitchdata.clubspeedtiming.com, you’d only enter stitchdata into this field.
  6. In the Club Speed Private Key field, paste your Club Speed private API key. Note: You’ll need to contact Club Speed to obtain this credential.

Step 2: Define the historical sync

The Sync Historical Data setting will define the starting date for your Club Speed integration. This means that:

  • For tables using Incremental Replication, data equal to or newer than this date will be replicated to your data warehouse.
  • For tables using Full Table Replication, all data - including records that are older, equal to, or newer than this date - will be replicated to your data warehouse.

Change this setting if you want to replicate data beyond Club Speed’s default setting of 1 year. For a detailed look at historical replication jobs, check out the Syncing Historical SaaS Data guide.

Step 3: Create a replication schedule

In the Replication Frequency section, you’ll create the integration’s replication schedule. An integration’s replication schedule determines how often Stitch runs a replication job, and the time that job begins.

Club Speed integrations support the following replication scheduling methods:

To keep your row usage low, consider setting the integration to replicate less frequently. See the Understanding and Reducing Your Row Usage guide for tips on reducing your usage.

Initial and historical replication jobs

After you finish setting up Club Speed, its Sync Status may show as Pending on either the Stitch Dashboard or in the Integration Details page.

For a new integration, a Pending status indicates that Stitch is in the process of scheduling the initial replication job for the integration. This may take some time to complete.

Free historical data loads

The first seven days of replication, beginning when data is first replicated, are free. Rows replicated from the new integration during this time won’t count towards your quota. Stitch offers this as a way of testing new integrations, measuring usage, and ensuring historical data volumes don’t quickly consume your quota.


Club Speed table schemas

Replication Method :

Full Table

Primary Key :

onlineBookingsId

The booking table contains info about bookings. A booking record exposes a heat to the online booking inerface in Club Speed.

onlineBookingsId
INTEGER

The ID for the booking.

Reference:

heatId
INTEGER

The heat ID for the booking.

Reference:

isPublic
BOOLEAN

Indicates whether the booking is available to the online booking interface.

productsId
INTEGER

The ID of the product for the booking.

Reference:

quantityTotal
INTEGER

The total number of booking reserverations to make available.


booking_availability

Replication Method :

Full Table

Primary Key :

heatId

The booking_availability table contains info about the current availability for online bookings. These take into account both online and local booking reservations.

heatId
INTEGER

The heat ID for the booking.

Reference:

heatDescription
STRING

The description of the heat.

heatSpotsAvailableCombined
INTEGER

The heat ID for the booking.

Reference:

heatSpotsAvailableOnline
INTEGER

The number of spots to be exposed to the online interface for the entire heat.

heatSpotsTotalActual
INTEGER

The original number of total spots for the heat.

heatStartsAt
DATE-TIME

The start time for the heat.

heatTypeId
INTEGER

The heat type ID.

Reference:

isPublic
BOOLEAN

Indicates whether the booking should be made available in the online booking interface.

products
ARRAY

A list of products associated with the booking.

productsId
INTEGER

The product ID.

Reference:

onlineBookingsId
INTEGER

The booking ID.

Reference:

price1
NUMBER

The price of the product for the booking.

productDescription
STRING

The description of the product for the booking.

productSpotsAvailableOnline
INTEGER

The number of spots intended to be exposed to the online interface for the product.

productSpotsTotal
INTEGER

The total number of spots originally made available through the product pairing.

productType
STRING

The ID of the product type.

booking_availability (table), products (attribute)

Replication Method :

Key-based Incremental

Replication Key :

createdDate

Primary Key :

checkDetailId

The check_details table contains info about line items and quantity info attached to checks.

checkDetailId
INTEGER

The check detail ID.

Reference:

createdDate
DATE-TIME

The timestamp when the check detail was created.

calculateType
INTEGER

The type of application for an applied discount.

checkId
INTEGER

The ID of the parent check for the check detail.

discountApplied
NUMBER

The amount of the discount applied to the check detail.

discountDesc
STRING

The description of the applied discount.

discountId
INTEGER

The ID of the applied discount.

Reference:

discountNotes
STRING

Notes about the discount application.

discountUserId
INTEGER

The ID of the user who applied the discount.

Reference:

g_CustId
INTEGER

The ID of the customer on which to apply points on purchase. Note: This may reference a gift card.

Reference:

g_Points
NUMBER

The amount of money to be given to the customer (g_CustId) at purchase or check finalization.

gst
NUMBER

The percent of the tax to be applied as GST.

m_DaysAdded
INTEGER

p_CustId
INTEGER

The ID of the customer on which to apply points on purchase.

Reference:

p_Points
INTEGER

The number of points to be applied on purchase.

productId
INTEGER

The ID of the product on the check detail.

Reference:

productName
STRING

The name of the product on the check detail.

qty
INTEGER

The quantity of the product on the check detail.

r_Points
INTEGER

The number of reservation points to be applied on purchase.

s_CustId
INTEGER

Reference:

s_NoOfLapsOrSeconds
INTEGER

s_SaleBy
INTEGER

s_Vol
INTEGER

status
INTEGER

The status of the check detail. Possible values are:

  • 1 (New)
  • 2 (Voided)
  • 3 (Permanent)

taxId
INTEGER

The ID of the tax to be applied to the check detail.

Reference:

taxPercent
NUMBER

The percent of tax to be applied.

type
INTEGER

The type of the product. Possible values are:

  • 1 - Regular
  • 2 - Point
  • 3 - Food
  • 4 - Reservation
  • 5 - GameCard
  • 6 - Membership
  • 7 - Gift Card
  • 8 - Entitle

unitPrice
NUMBER

The unit price of the product.

unitPrice2
NUMBER

The unit price of the product.

voidNotes
STRING

Notes added while voiding the check detail.


Replication Method :

Key-based Incremental

Replication Key :

closedDate

Primary Key :

checkId

The checks table contains info about checks, or financial invoices, that have been closed.

checkId
INTEGER

The check ID.

Reference:

closedDate
DATE-TIME

The timestamp when the check was closed.

broker
STRING

The name of the check broker.

customerId
INTEGER

The ID of the customer for the check.

Reference:

discount
NUMBER

The discount applied to the entire check.

discountId
INTEGER

The ID of the discount applied to the check.

Reference:

discountNotes
STRING

Notes about the discount applied to the check.

discountUserId
INTEGER

The ID of the user who applied the discount.

Reference:

fee
NUMBER

The additional fee to be applied to the entire check.

gratuity
NUMBER

The gratuity to be applied to the whole check.

invoiceDate
DATE-TIME

The timestamp on which the invoice was handled.

isTaxExempt
BOOLEAN

Indicates if the entire check is exempt from taxation.

name
STRING

The name of the check.

notes
STRING

Any notes about the check.

openedDate
DATE-TIME

The timestamp on which the check was opened.

status
INTEGER

The status of the check. Possible values are:

  • 0 - Open
  • 1 - Closed

total
NUMBER

The applied total for the check. This includes all underlying check details, taxes, discounts, fees, and gratuity.

type
INTEGER

The type of the check. Possible values are:

  • 1 - Regular
  • 2 - Event

userId
INTEGER

The ID of the user who created the check.

Reference:


Replication Method :

Key-based Incremental

Replication Key :

lastVisited

Primary Key :

customerId

The customers table contains info about the customers for a location.

customerId
INTEGER

The customer ID.

Reference:

lastVisited
DATE-TIME

The date on which the customer last visited.

Address
STRING

The first address line for the customer.

Address2
STRING

The second address line for the customer.

City
STRING

The city of residence for the customer.

Country
STRING

The country of residence for the customer.

Custom1
STRING

Custom data holder 1.

Custom2
STRING

Custom data holder 2.

Custom3
STRING

Custom data holder 3.

Custom4
STRING

Custom data holder 4.

LicenseNumber
STRING

The license number for the customer.

State
STRING

The state of residence for the customer.

Zip
STRING

The post code for the address of the customer.

accountCreated
DATE-TIME

The timestamp when the customer record was created.

birthdate
DATE-TIME

The customer’s birth date.

cardId
INTEGER

The membership card number for the customer.

company
STRING

The company of the customer.

creditLimit
NUMBER

The credit limit for the customer.

creditOnHold
BOOLEAN

Indicates whether the customer’s credit is on hold.

deleted
BOOLEAN

Indicates whether the customer has been soft deleted.

donotemail
BOOLEAN

Indicates whether the customer wishes to receive emails.

email
STRING

The email addresss of the customer.

fax
STRING

The fax number of the customer.

firstname
STRING

The customer’s first name.

gender
INTEGER

The customer’s gender. Possible values are:

  • 0 - Other/Unspecified
  • 1 - Male
  • 2 - Female

generalNotes
STRING

Any notes about the customer.

howdidyouhearaboutus
INTEGER

The ID of the source for the customer.

Reference:

ignoreDOB
BOOLEAN

Indicates whether the customer’s birth date can be ignored.

isEmployee
BOOLEAN

Indicates if the customer is also an employee.

isGiftCard
BOOLEAN

Indicates if the customer record should be considered a gift card.

lastname
STRING

The customer’s last name.

memberShipTextLong
STRING

Description of the membership for the customer.

membershipStatus
INTEGER

The customer’s membership status.

membershipText
STRING

Abbreviation of the membership for the customer.

mobilephone
STRING

The mobile phone for the customer.

originalId
INTEGER

phoneNumber
STRING

The phone number for the customer.

phoneNumber2
STRING

The alternate phone number for the customer.

priceLevel
INTEGER

The price level that this customer’s membership type grants to the customer.

privacy1
BOOLEAN

Indicates whether the name of the customer should be hidden from race results.

proskill
INTEGER

The current proskill for the customer.

racername
STRING

The nickname for the customer.

status1
INTEGER

Indicates a specific status. This is customizable per venue to handle indicators such as Customer added from POS, Customer added from Online Event Registration, Customer signed secondary waiver, etc.

status2
INTEGER

See status1.

status3
INTEGER

See status1.

status4
INTEGER

See status1.

totalRaces
INTEGER

The total number of times this customer has raced.

totalVisits
INTEGER

The total number of times this customer has visited.

waiver
INTEGER

Indicates the primary waiver the customer has signed.

waiver2
INTEGER

Indicates the secondary waiver the customer has signed.

webUserName
STRING


Replication Method :

Full Table

Primary Key :

discountId

The discount_types table contains info about discount types.

discountId
INTEGER

The discount ID.

Reference:

amount
NUMBER

The amount of the discount. Refer to calculateType for usage.

calculateType
INTEGER

The calculation type for the discount, which determines how amount is calculated. Possible values are:

  • 1 - Amount
  • 2 - Percentage

deleted
BOOLEAN

Indicates whether the discount has been soft deleted.

description
STRING

The description for the discount.

enabled
BOOLEAN

Indicates whether the discount is currently enabled.

needApproved
BOOLEAN

Indicates whether the discount should require manager approval.

productClassId
INTEGER

The product class that is applicable for the discount.

Reference:


event_heat_details

Replication Method :

Key-based Incremental

Replication Key :

added

Primary Key :

customerId : eventId

The event_heat_details table contains info about customers who have been placed in a queue for a specific event.

customerId
INTEGER

The ID of the customer in the queue.

Reference:

eventId
INTEGER

The ID of the event.

Reference:

added
DATE-TIME

The date at which the customer was added to the event queue.

proskill
INTEGER

The proskill for the customer.

roundLoseNum
INTEGER

The round at which the customer dropped out of the event.

totalRaces
INTEGER

The total number of races in the event.


Replication Method :

Full Table

Primary Key :

eventHeatTypeId

The event_heat_types table contains info about event type classifications, which are used to look up event_rounds when creating events.

eventHeatTypeId
INTEGER

The event heat type ID.

cadetsPerHeat
INTEGER

The maximum number of cadet racers for an event round.

description
STRING

The description of the event round.

eventTypeId
INTEGER

The event type for the default event round information.

Reference:

heatTypeId
INTEGER

The heat type to be used with the resulting heat.

Reference:

heatsPerRacer
INTEGER

The number of heats in which each racer will participate.

racersPerHeat
INTEGER

The maximum number of racers for the event round.

roundNumber
INTEGER

The ordered round number in the event.


Replication Method :

Full Table

Primary Key :

eventReservationLinkId

The event_reservation_links table contains lists of check and reservation IDs, or checks that are linked to event reservations.


event_reservation_types

Replication Method :

Full Table

Primary Key :

eventReservationTypeId

The event_reservation_types table contains info about the descriptions for event reservation types.

eventReservationTypeId
INTEGER

The event reservation type ID.

Reference:

description
STRING

The description of the event reservation type.


event_reservations

Replication Method :

Key-based Incremental

Replication Key :

startTime

Primary Key :

eventReservationId

The event_reservations table contains info about event reservations, which are linked to events.

eventReservationId
INTEGER

The event reservation ID.

Reference:

startTime
DATE-TIME

The expected start time of the event reservation.

allowOnlineReservation
BOOLEAN

Indicates whether reservations can be made online.

deleted
BOOLEAN

Indicates whether the event reservation has been soft deleted.

description
STRING

The description for the event reservation.

endTime
DATE-TIME

The time at which the event reservation is expected to end.

eventTypeId
INTEGER

The ID for the event type of the event.

Reference:

externalSystemId
INTEGER

A field for storing an external reference for the event reservation.

isEventClosure
BOOLEAN

mainId
INTEGER

The ID for the parent event reservation.

Reference:

minNoOfAdultsPerBooking
INTEGER

The minimum number of customers per booking.

noOfRacers
INTEGER

The current number of booked customers.

notes
STRING

The notes for the event reservation.

ptsPerReservation
INTEGER

The number of points required to make a reservation.

repId
INTEGER

status
INTEGER

The index for the event status of the event reservation.

subject
STRING

The name for the event reservation.

typeId
INTEGER

The event reservation type ID.

Reference:

userId
INTEGER

The ID of the user that made the event reservation.

Reference:


Replication Method :

Full Table

Primary Key :

eventRoundId

The event_rounds table contains info about event rounds. This table acts as a link between events and their corresponding rounds in the heat_main.

eventRoundId
INTEGER

The event round ID.

Reference:

cadetsPerHeat
INTEGER

The maximum number of cadet racers for the event round.

eventId
INTEGER

The ID of the parent event.

Reference:

heatDescription
STRING

The description of the heat.

heatTypeId
INTEGER

The heat type ID of the heat.

Reference:

heatsPerRacer
INTEGER

The number of heats in which each racer will participate.

racersPerHeat
INTEGER

The maximum number of racers for this event round.

roundNumber
INTEGER

The ordered round number in the event.


Replication Method :

Full Table

Primary Key :

eventStatusId

The event_statuses table contains info about event statuses, which are statuses assigned to event_reservations.

eventStatusId
INTEGER

The event status ID.

colorId
INTEGER

The ID of the color which will be used to highlight the event when given this status

seq
INTEGER

The order in which the event status appears in dropdowns.

status
STRING

The readable description of the status.


Replication Method :

Full Table

Primary Key :

eventTaskId

The event_task_types table contains info about event task types, which are event_tasks to be tracked for completion.

eventTaskId
INTEGER

The event task ID.

Reference:

deleted
BOOLEAN

Indicates whether the event task has been soft deleted.

description
STRING

The description of the task type.

name
STRING

The name of the task type.

seq
INTEGER

The sequence in which the task type should appear.


Replication Method :

Key-based Incremental

Replication Key :

completedAt

Primary Key :

eventTaskId

The event_tasks table contains info about the tasks to be completed for a given event_reservation.

eventTaskId
INTEGER

The event task ID.

Reference:

completedAt
DATE-TIME

The date on which the task was completed. This field will be populated only if the task has been completed.

completedBy
INTEGER

The ID of the user that completed the task. This field will be populated only if the task has been completed.

Reference:

eventReservationId
INTEGER

The ID of the event reservation.

Reference:

eventTaskTypeId
INTEGER

The event task ID.

Reference:


Replication Method :

Full Table

Primary Key :

eventTypeId

The event_types table contains info about event types.

eventTypeId
INTEGER

The event type ID.

Reference:

deleted
BOOLEAN

Indicates if the event type was soft deleted.

description
STRING

The description of the event type.

displayAtRegistration
BOOLEAN

Indicates whether the event type should show during registration.

enabled
BOOLEAN

Indicates whether the event type is currently enabled.

eventTypeName
STRING

The name of the event type.

eventTypeTheme
INTEGER

The theme of the event type.

memberOnly
BOOLEAN

Indicates whether or not a membership is required for this event type.

onlineProductId
INTEGER

The ID of the product used to purchase the event.

Reference:

ptsPerReservation
INTEGER

The number of points required per reservation.

trackId
INTEGER

The ID of the track for which this event can be added.

Reference:


Replication Method :

Key-based Incremental

Replication Key :

eventScheduledTime

Primary Key :

eventId

The events table contains info about events.

eventId
INTEGER

The event ID.

Reference:

eventScheduledTime
DATE-TIME

The scheduled time for the event.

createdHeatSpots
INTEGER

The number of heat spots that have been created for the event.

createdHeatTime
DATE-TIME

The time at which the relevant heat will start.

eventDesc
STRING

The description of the event.

eventDuration
INTEGER

The expected duration of the event, in minutes.

eventNotes
STRING

The notes for the event.

eventTheme
INTEGER

The theme for the event.

eventTypeId
INTEGER

The ID for the event type.

Reference:

eventTypeName
STRING

The name of the type of the event.

memberOnly
BOOLEAN

Indicates whether entry into the event requires a membership.

reservationId
INTEGER

The ID of the reservation for the event.

Reference:

totalRacers
INTEGER

The total number of racers for the event.

trackNo
INTEGER

The number of the track to be used for the event.


gift_card_history

Replication Method :

Key-based Incremental

Replication Key :

transactionDate

Primary Key :

giftCardHistoryId

The gift_card_history table acts as a transactional log for keeping track of each change that occurs with gift cards.

giftCardHistoryId
INTEGER

The gift card history ID.

transactionDate
DATE-TIME

The date at which the transaction occurred.

checkDetailId
INTEGER

The check line item that resulted in this change.

Reference:

checkId
INTEGER

The check which resulted in this change.

Reference:

customerId
INTEGER

The holder of the gift card. Note: This may correspond to either a standard gift card or a member card on a customer account.

Reference:

ipAddress
STRING

The IP address of the machine from which the change originated.

notes
STRING

Any notes for the transaction.

points
NUMBER

The number of changed points for this transaction.

type
INTEGER

The type of the transaction. Possible values are:

  • 0 - Sold gift card
  • 1 - Transferred gift card in
  • 9 - Void sold gift card
  • 10 - Paid with gift card
  • 11 - Void paid with gift card
  • 12 - Refunded to gift card
  • 13 - Sold gift card external
  • 14 - Void sold gift card external
  • 15 - Paid with gift card external
  • 16 - Void paid with gift card external
  • 17 - Refunded to gift card external
  • 18 - Invoice paid

userId
INTEGER

The ID of the user that recorded the transaction.

Reference:


Replication Method :

Key-based Incremental

Replication Key :

finish

Primary Key :

heatId

The heat_main table contains info about finished heat mains, which are instances of races on the standard venue calendar.

heatId
INTEGER

The heat ID.

Reference:

finish
DATE-TIME

The actual finish time of the heat.

beginning
DATE-TIME

The actual start time of the heat.

eventRound
INTEGER

The ID of the event round which corresponds to the heat.

Reference:

heatColor
INTEGER

An integer representation of the color to be used on the heat calendar.

lapsOrMinutes
INTEGER

The quantity of laps or minutes (depending on heat type) required for the heat to finish.

memberOnly
BOOLEAN

Indicates whether a heat should only allow entrance to members.

notes
STRING

Notes for the heat.

numberOfReservation
INTEGER

The number of additional reservations for the heat. Note: These typically represent purchased slots in a heat.

pointsNeeded
INTEGER

The number of points required to enter the heat.

raceBy
INTEGER

The indication of whether the heat will treat the value of lapsOrMinutes as laps or minutes. Possible values are:

  • 0 - Minutes
  • 1- Laps

racersPerHeat
INTEGER

The total number of racers available for the heat.

scheduleDuration
INTEGER

The expected duration of the heat.

scheduledTime
DATE-TIME

The scheduled start time of the heat.

speedLevel
INTEGER

The speed level for the heat.

status
INTEGER

The status of the heat. Possible values are:

  • 0 - Open
  • 1 - Racing
  • 2 - Finished
  • 3 - Aborted
  • 4 - Closed

track
INTEGER

The ID for the track for the heat.

Reference:

type
INTEGER

The heat type for the heat.

Reference:

winBy
INTEGER

The indication of whether the heat is won by laps or position. Possible values are:

  • 0 - Best Time
  • 1 - Finish Position

heat_main_details

Replication Method :

Key-based Incremental

Replication Key :

heat_main.finish

Primary Key :

heatId : customerId

The heat_main_details table contains info about customers that were entered into finished heats.

heatId
INTEGER

The heat ID.

Reference:

customerId
INTEGER

The customer ID.

Reference:

autoNo
INTEGER

The kart number for the customer. Note: This is not assigned until during/after the heat.

finishPosition
INTEGER

The finish position for the customer.

firstTime
BOOLEAN

Indicates whether or not this is the customer’s first race.

groupFinishPosition
INTEGER

The finish position of the customer relative to their group.

groupId
INTEGER

The ID of the group the racer belongs to.

lineUpPosition
INTEGER

The line up position scheduled for the customer.

pointHistoryId
INTEGER

The ID of the point history utilized to add this customer to the heat.

positionEditedDate
DATE-TIME

The timestamp at which the position was edited.

proskill
INTEGER

The proskill of the customer.

proskillDiff
INTEGER

The amount at which the proskill of the customer changed as an outcome of the heat.

scores
NUMBER

timeAdded
DATE-TIME

The time at which the customer was added to the heat.

userId
INTEGER

The ID of the user that added the customer to the heat.

Reference:


Replication Method :

Full Table

Primary Key :

heatTypesId

The heat_types table contains info about heat types.

heatTypesId
INTEGER

The heat type ID.

Reference:

cannotBelow
INTEGER

The minimum cut off for lap times, in milliseconds.

cannotExceed
INTEGER

The maximum cut off for lap times, in milliseconds.

cost
INTEGER

The number of points required for the heat type.

deleted
BOOLEAN

Indicates whether the heat type has been soft deleted.

enabled
BOOLEAN

Indicates whether the heat type is enabled.

isEventHeatOnly
BOOLEAN

Indicates whether the heat type is meant only for events.

isPracticeHeat
BOOLEAN

Indicates whether this heat type is meant to be a practice round.

lapsOrMinutes
INTEGER

The quantity of laps or minutes (depending on the heat type) required for the heat type to finish.

memberOnly
BOOLEAN

Indicates whether a heat type should only allow entrance to members.

name
STRING

The name of the heat type.

raceBy
INTEGER

Indicates whether the heat type should treat lapsOrMinutes as laps or minutes. Possible values are:

  • 0 - Minutes
  • 1 - Laps

racersPerHeat
INTEGER

The total number of racers available for the heat type.

scheduleDuration
INTEGER

The expected duration of the heat type.

speedLevel
INTEGER

The speed level for the heat type.

trackId
INTEGER

The default track ID for the heat type.

Reference:

winBy
INTEGER

The indication of whether the heat type is won by laps or position. Possible values are:

  • 0 - Best Time
  • 1 - Finish Position

Replication Method :

Full Table

Primary Key :

membershipTypeId

The membership_types table contains info about memberships.

membershipTypeId
INTEGER

The membership type ID.

Reference:

description
STRING

The description of the membership type.

enabled
INTEGER

Indicates whether the membership type is currently enabled.

expirationType
INTEGER

The number of days when this membership will expire.

expires
BOOLEAN

Indicates whether or not the membership should ever expire.

priceLevel
INTEGER

The price level that this membership type would grant to a customer.

seq
INTEGER

The sequence in which the membership type should appear in a dropdown.


Replication Method :

Key-based Incremental

Replication Key :

changed

Primary Key :

customerId : membershipTypeId

The memberships table contains info about memberships, which is a pairing of a customer and membership_type.

customerId
INTEGER

The customer ID.

membershipTypeId
INTEGER

The membership type ID.

changed
DATE-TIME

The date at which the membership last changed.

byUserId
INTEGER

The ID of the user who created the membership.

Reference:

expiration
DATE-TIME

The date at which the membership will expire.

notes
STRING

Any notes about the membership.


Replication Method :

Key-based Incremental

Replication Key :

payDate

Primary Key :

paymentId

The payments table contains info about collected payments.

paymentId
INTEGER

The payment ID.

Reference:

payDate
DATE-TIME

The timestamp at which the payment was collected.

cardType
STRING

The type of credit card used to make the payment. This will usually be populated only if payType is Credit.

checkId
INTEGER

The ID of the check for which payment was applied.

Reference:

customerId
INTEGER

The ID of the customer that made the payment.

Reference:

extCardType
STRING

The card or payment processor type for the payment.

payAmount
NUMBER

The monetary amount of the payment.

payStatus
INTEGER

The status of the payment. Possible values are:

  • 1 - Paid
  • 2 - Void

payTax
NUMBER

The monetary amount of the payment which was applied to tax. Note: payAmount is inclusive of this value.

payTerminal
STRING

The terminal at which the payment was collected.

payType
INTEGER

The type of the payment which was collected. Possible values are:

  • 1 - Cash
  • 2 - Credit
  • 3 - External / Third Party Processor
  • 4 - Gift Card
  • 5 - Voucher
  • 6 - Complementary

transaction
STRING

A reference to a transaction number, typically one which was returned from a third party processor.

userId
INTEGER

The ID of the user that created the payment.

Reference:

voidDate
DATE-TIME

The timestamp at which the payment was voided.

voidNotes
STRING

The notes as to why the payment was voided.

voidTerminal
STRING

The terminal where the payment was voided.

voidUser
INTEGER

The ID of the user that voided the payment.

Reference:


Replication Method :

Key-based Incremental

Replication Key :

voidDate

Primary Key :

paymentId

The payments_voided table contains info about voided payments.

paymentId
INTEGER

The payment ID.

Reference:

voidDate
DATE-TIME

The timestamp at which the payment was voided.

cardType
STRING

The type of credit card used to make the payment. This will usually be populated only if payType is Credit.

checkId
INTEGER

The ID of the check for which payment was applied.

Reference:

customerId
INTEGER

The ID of the customer that made the payment.

Reference:

extCardType
STRING

The card or payment processor type for the payment.

payAmount
NUMBER

The monetary amount of the payment.

payDate
DATE-TIME

The timestamp at which the payment was collected.

payStatus
INTEGER

The status of the payment. Possible values are:

  • 1 - Paid
  • 2 - Void

payTax
NUMBER

The monetary amount of the payment which was applied to tax. Note: payAmount is inclusive of this value.

payTerminal
STRING

The terminal at which the payment was collected.

payType
INTEGER

The type of the payment which was collected. Possible values are:

  • 1 - Cash
  • 2 - Credit
  • 3 - External / Third Party Processor
  • 4 - Gift Card
  • 5 - Voucher
  • 6 - Complementary

transaction
STRING

A reference to a transaction number, typically one which was returned from a third party processor.

userId
INTEGER

The ID of the user that created the payment.

Reference:

voidNotes
STRING

The notes as to why the payment was voided.

voidTerminal
STRING

The terminal where the payment was voided.

voidUser
INTEGER

The ID of the user that voided the payment.

Reference:


Replication Method :

Full Table

Primary Key :

productClassId

The product_classes table contains info about classes applied to products. Product classes determine how products are aggregated in Club Speed’s reporting system.

productClassId
INTEGER

The product class ID.

Reference:

deleted
BOOLEAN

Indicates whether the product class has been soft deleted.

description
STRING

The description of the product class.

exportName
STRING

The export name to be used when building exports from reports.


Replication Method :

Full Table

Primary Key :

productId

The products table contains info about products.

productId
INTEGER

The product ID.

Reference:

deleted
BOOLEAN

Indicates whether the product has been soft deleted.

description
STRING

The description of the product.

enabled
BOOLEAN

Indicates whether the product is currently enabled.

g_Points
NUMBER

The amount of gift card points provided when this product is purchased.

p_Points
NUMBER

The number of points provided when this product is purchased.

price1
NUMBER

The price of the product.

price2
NUMBER

priceCadet
NUMBER

productClassId
INTEGER

The ID of the reporting product class for the product.

Reference:

productType
INTEGER

The type of the product. Possible values are:

  • 1 - Regular
  • 2 - Point
  • 3 - Food
  • 4 - Reservation
  • 5 - GameCard
  • 6 - Membership
  • 7 - Gift Card
  • 8 - Entitle

r_Points
NUMBER

The amount of reservation points provided when this product is purchased.

taxId
INTEGER

The tax ID for the product.

Reference:


Replication Method :

Key-based Incremental

Replication Key :

createdAt

Primary Key :

onlineBookingReservationsId

The reservations table contains info about reservations. Reservations are indications that a customer is looking to purchase a spot in a booking or has already purchased a spot.

onlineBookingReservationsId
INTEGER

The online booking reservation ID.

Reference:

createdAt
DATE-TIME

The timestamp at which the reservation was created.

checkId
INTEGER

The ID of the check for the reservation.

Reference:

customersId
INTEGER

The ID of the customer for the reservation.

Reference:

expiresAt
DATE-TIME

The timestamp at which the reservation will be automatically expired, if the status (onlineBookingReservationStatusId) is not set to 1 (Permanent).

onlineBookingReservationStatusId
INTEGER

The ID for the status of the reservation. Statuses should be set to Temporary while the underlying kart is open, and set to Permanent after the purchase has been made. Possible values are:

  • 1 - Temporary
  • 2 - Permanent

onlineBookingsId
INTEGER

The ID of the booking for the reservation.

Reference:

quantity
INTEGER

The quantity of reservations to hold.

sessionId
STRING

An optional session identifier to be used for documentation and debugging purposes, typically generated by an external website.


Replication Method :

Full Table

Primary Key :

sourceId

The sources table contains info about how customers find and register at venues.

sourceId
INTEGER

The source ID.

Reference:

deleted
BOOLEAN

Indicates whether the source has been soft deleted.

enabled
BOOLEAN

Indicates whether the source is currently enabled.

locationId
INTEGER

The ID of the venue location the source applies to.

name
STRING

The name of the source.

seq
INTEGER

The sequence in which the source should display in a dropdown.


Replication Method :

Full Table

Primary Key :

taxId

The taxes table contains info about tax calculations, which are typically applied to products.

taxId
INTEGER

The tax ID.

Reference:

amount
NUMBER

The percentage of the tax. For example: 6.25 would indicate 6.25%.

deleted
BOOLEAN

Indicates whether the tax has been soft deleted.

description
STRING

The description of the tax.

gst
NUMBER

The percentage of the tax which should be considered GST, where applicable.


Replication Method :

Full Table

Primary Key :

userId

The users table contains info about employees and system users. Note: While some employees may also be customers, this table does not contain customer information.

userId
INTEGER

The user ID.

Reference:

cardId
INTEGER

The card ID for the user.

deleted
BOOLEAN

Indicates whether the user has been soft deleted.

email
STRING

The email address for the user.

empStartDate
DATE-TIME

The date on which the user started employment.

enabled
BOOLEAN

Indicates whether the user is currently enabled.

firstname
STRING

The user’s first name.

isSystemUser
BOOLEAN

Indicates whether the user is a system/application user or a track employee.

lastname
STRING

The user’s last name.

phone
STRING

The user’s phone number.

username
STRING

The user’s username.



Questions? Feedback?

Did this article help? If you have questions or feedback, feel free to submit a pull request with your suggestions, open an issue on GitHub, or reach out to us.