/
dbo.GetInTrackerLog

dbo.GetInTrackerLog

Owned by Logan Bird (Unlicensed)
Last updated: Jul 17, 2019

This table is Identical to dbo.GetInTracker but it records and stores the information every day.

  • Type: MS SQL Table

  • Schema: dbo

  • Data Origin: dbo.GetInTracker Stored Procedure

  • Refresh Schedule: daily

  • Script File Locations 

    • Script 1: F:\TB-Applications\Tableau\File.py

    • Script 2: F:\TB-Applications\Tableau\File.R

  • Known issues:
    • Does not differentiate between parking and non parking listings in EiBO. 

Data Dictionary

Column NameData TypeDescription

EventID

bigintThe key that links the Event
venueIDbigintThe key that links the venue
SeatSectionvarchar(100)Section where the seat is located
SeatRowvarchar(50)Row where the seat is located
EventDatesmalldatetimeDate that the event takes place
EventTimesmalldatetimeTime that the event takes place   (((Unsure why date and time are split)))
MinPricemoneyThe lowest price that the seat has been listed as
CreatedDatesmalldatetimeDate that the price was recorded.

Schema Diagram

  • Only include if data source is not a single raw data source

Related content