Skip to main content

KORE Sponsorship

Ashleigh Rentz
  • Updated

Overview

Organizations that subscribe to KORE Sponsorship can access much of its data through this DWA integration. KORE will configure this integration for you during on-boarding.

These tables are stored in the korepss schema. Some tables are shared with other KORE CRM products. For more information, see our overview of the schema.

 

ERD

Note: For clarity, many column names are omitted from this diagram.

Tip: Click the diagram to enlarge it. You can then click the pencil icon in the bottom toolbar to open a copy of it on diagrams.net. There, you can click an arrow to make its path more visible, move boxes around as you please, and more.

Column names beginning with sf_ refer to information in your CRM, regardless of whether you use Salesforce or Dynamics 365. For example, kore_contractbase.sf_dealsheetid specifies a deal sheet number within your CRM.

 

Notes

Contracts are a cornerstone of KORE Sponsorship, so several tables hold information about them:

  • kore_contractbase: The main details about a contract. The table also contains several foreign keys to other tables.
  • kore_rosterrelationshipbase: Connects an organization's users to deal sheets.
  • kore_contractseasonbase: Includes details about costs and revenue.
  • kore_contractlinebase: Details about which inventory items are included in the contract.

 

Example queries

List the event details for playoff games in 2021:

SELECT * FROM korepss.kore_eventbase ke 
INNER JOIN korepss.kore_gametypebase kg ON ke.kore_gametypeid = kg.kore_gametypeid 
INNER JOIN korepss.kore_seasonbase ks ON ke.kore_seasonid = ks.kore_seasonid 
WHERE kg.kore_name = 'Playoff'
  AND ks.kore_year = 2021
LIMIT 20;

 

If your organization subscribes to both Sponsorship and Suites & Premium, you can use the shared tables as a bridge. For example, suppose you want to identify Sponsorship contracts which include a premium deal component. The shared kore_contractbase table can serve as the bridge:

SELECT * FROM kore_contractbase kc 
INNER JOIN kore_premiumdealbase kp ON kc.kore_contractid = kp.kore_contractid 
INNER JOIN kore_contractseasonbase kcs ON kc.kore_contractid = kcs.kore_contractid 
LIMIT 20;