Platform SDK: Broadcast Architecture

Time Slot Table

The Time Slot table in the Guide database defines time slot and channel information for each show episode. The Time Slot table contains the following fields; for information on reserved fields, see Reserved Fields in the Time Slot Table.

Field Description
TS Alternate Audio Exists     Value that indicates whether an audio stream other than the current one is available for this time slot.
TS Alternate Data Exists Value that indicates whether a data stream other than the current one is available is available for this time slot.
TS Channel ID Internally generated unique identifier for a channel associated with this time slot. This field is a foreign key from the Channel table.
TS Closed Caption Value that specifies whether the broadcast for this time slot has closed captions.
TS End Time Ending time for this time slot.
TS Episode ID Internally generated unique identifier for a show episode associated with this time slot. This key is a foreign key from the Episode table.
TS Last Update Last time the row for this time slot was updated in the table.
TS Length Length of this time slot, in minutes.
TS Other Properties Exist Value that indicates whether additional properties exist for the broadcast for this time slot.
TS Rerun Value that specifies whether the broadcast for this time slot is a rerun.
TS Start Time Beginning time for this time slot.
TS Stereo Value that specifies whether the broadcast for this time slot is in stereo.
TS Time Slot ID Unique identifier for this time slot.

See Also

Channel table, Episode table