Verifying EPG data

<u>Backgound of the Invention</u>

This invention relates to an electronic program guide ("EPG") system that provides users with schedule information for broadcast or cablecast programs available for viewing on a video display. More particularly, it relates to a system and method for verification of the EPG data prior to transmission to a plurality of remote locations such as cable system head ends or viewer sites.

Electronic program guides for television systems are known in the art, particularly with regard to cable television systems. For example, one common implementation of a electronic program guide utilizes a dedicated cable television channel for continuously broadcasting program schedule information. The advantage of such a system is that it is relatively easy to deploy because it is centrally implemented at the cable head-end. No additional electronics or software are required at the viewer location because full control of the display is maintained at the cable head-end. The display information is then broadcast continuously on a dedicated cable channel. The television viewer simply tunes the cable converter box or television tuner to the channel on which the schedule information is modulated and views the program listings. Typically, these program guides utilize a scrolling display of television listings or a fixed display that periodically changes. Some systems employ a partial screen of listings with additional information in the remainder of the screen such as advertisements for movies on pay channels, pay-per-view (PPV) event schedules, time and weather information, and other commercial information. These systems generally incorporate a grid or matrix to display the program schedule information, with a different row for each channel and columns representing different time slots.

In addition, interactive program guides are also known. Such guides permit the user to select the program listings to be displayed based on user selection criteria and display the listings on the television receiver in a desired format. Interactive guides are more versatile than dedicated channel guides because they operate under user control. However, they are more costly to implement because they require memory and processor capabilities at each user site. The present invention may be used with either dedicated channel or interactive program guides because it operates on the program listings data common to both types of guides.

Modem cable systems include upwards of 100 channels. Thus, for both dedicated channel and interactive program EPGs, large quantities of data are required to provide a complete listing of program schedule information. Such a schedule management method is known from <patcit id="pcit0001" dnum="US5311423A"><text>US5311423</text></patcit>. A problem common to both types of systems is that there are often errors in the data that must be corrected. Errors may arise for any number of reasons. First, it is common for a complete database of program listings to be compiled from several different sources. Much of the data is available on a national basis, including network schedules (both broadcast and cable), pay-per-view listings, and regional programming. Some data, however, must be obtained at a local level, including locally originated programs, channel maps for individual cable systems, and pricing for pay-per-view programs. The fact that there is no single entity responsible for compilation of the entire listings database increases the risk of errors. For example, a portion of the data may need to be converted to a different format before it can be utilized in the program guide.

Second, the listings database contains an enormous amount of data. Electronic program guides, whether of the dedicated channel or interactive variety, include a database comprising the program listings information for the various stations and pay-per-view channels. The listings data may be arranged in weekly blocks or other time periods. As an example, consider a cable system with eighty (80) channels, each one broadcasting 24 hours a day. Assuming for each station a daily average of four hours of two-hour programs, five hours of on-hour programs, and the balance comprising one-half hour programs, 37 different programs are aired per channel per day. Thus, a one week database comprises on average information for 37x80x7 = 20,720 programs. Although many programs repeat on a daily basis, it is apparent that even one weeks' worth of program listings for the average cable system is a very large amount of data. In addition, while much of the data may be compiled in advance, a substantial number of listings must be added, and schedule changes accounted for, shortly before the data is transmitted to the various cable systems. The volume of data makes it difficult and time consuming to manually ensure its reliability.

Finally, certain programs, primarily sports events, are not scheduled as far in advance as other programs. For example, although a time slot may be slated for a baseball game, it may not be known until one week or less in advance of the scheduled game, the particular game to be broadcast. There is thus a need to efficiently and quickly identify entries in a listings database that require editing of one form or another either to add information or correct errors.

A program listings database with incorrect listings or incomplete information is of limited utility. There is thus a need to ensure the reliability of the data transmitted to the cable systems and ultimately to viewers. However, because the volume of data is so great, there is a need for an automated procedure for verification of the data to reduce the number of manual hours required. There is thus a need for an automated system and method of reviewing the EPG data and flagging any errors therein. In addition, there is a need to provide a list of any such errors to a database editor to permit the editor to take whatever corrective action is necessary. In addition, different data may need to be generated for different cable systems because, e.g., each cable system may have different local programming or pay-per-view programs or schedules.

One factor that complicates the task is the need for a program listings database to be compatible with a plurality of different platforms. Different cable systems may have different hardware configurations at the cable system head-end and different set-top converter boxes at the viewer locations. For example, EPGs typically display program listings in grid format with columns representing different time slots and rows representing different channels. Set-top converters vary with regard to their text display capabilities. Some may display text using a proportional font while others use a standard font. In addition, some are configured to display symbols in the grid cells in addition to text which decreases the available space for text display. Thus, the database must be configured in such a way to accommodate the varying capabilities of set-top converters. One way to accomplish this is by editing the text (program titles, copy, station identifications, and any other text included in the EPG) to abbreviate any text that does not fit into a particular grid cell. A system for assisting in this "text fit" process is described in co-pending application serial number <patcit id="pcit0002" dnum="US08247059B"><text>08/247,059</text></patcit>. Thus, when verifying the data prior to transmission to a cable system, it is necessary to specify the platform on which the EPG operates so as to determine if the listings are properly edited for the particular platform.

The system and method of the present invention provides for automated checking of the program listings data in the database. The disclosed invention solves these and other problems of prior art EPG systems by providing a system and method as set out in claims 1 and 15, for verification of the EPG data prior to transmission to a cable or other pay television system (or prior to transmission to viewers). Prior to being processed by the data verification system of the present invention, the database of television program schedule listings may undergo initial processing as follows. First, the data is collected from the various information providers and checked for high level errors. Next, it may be required to normalize the data to the EPG database structure and format as it is possible that the information collected from the different sources uses different formats and syntax. Finally, the data may be processed with a text fit system to determine if any titles in the database require editing in order to fit within a grid cell of a predetermined size for any of the different platforms on which the EPG will operate. Alternatively, the text fit process may be incorporated as part of the listing verification process so that text requiring editing to fit within a particular grid cell size is identified and presented to the user for editing if not already included in a library or look-up table of pre-edited text.

At this stage, the listing verification system and procedure of the present invention operates on the data to check for any errors in the data. In particular, checks may be run for any missing stations, schedule gaps, schedule overlaps, missing titles, missing copy, missing fields (i.e., run time, slot time, program type), missing movie ratings, missing program origin, missing PPV price, PPV events on non-PPV station, non-PPV event on PPV station, inappropriate language, lengthy titles, lengthy copy, and editorial errors. "Lengthy" as used herein refers to text that is too long to fit into the allocated grid space in the program guide. Errors are automatically written to output files and separate files are used for each of the above parameters.

The database may also be processed by additional steps such as a program listings editing system to create, delete, or modify individual program listings and a channel map editing system to create, delete, or modify individual channel maps, which contain information identifying the stations carried by a cable system as well as the on-air times for each station. The program listings may be searched using the program title, program identification number (PIN), or station name. It is preferable to perform these editing steps prior to listing verification and text fit to ensure that all of the data in the data file has been processed by these latter two steps. Alternatively, the listing verification process may be re-run if any editing is performed after initial verification of the data. Finally, an extract process is run against the database to create data files containing cable system specific data based on a specified date range and channel map. The data files may be ASCII or tightly packed binary files readable by the cable system to which it is destined. Finally, the data is processed according to the specific platform and transmitted to the designated cable system. Cable system as used herein is not limited to standard cable television systems but includes direct broadcast television systems, over-the-air pay television systems, and any other television program distribution system including central control over the distribution of a television signals for a plurality of stations.

Brief Description of the Drawings

<ul id="ul0001" list-style="none" compact="compact"><li><figref idref="f0001">Fig. 1</figref> is a block diagram showing an EPG delivery system including the data verification system of the invention herein.</li><li><figref idref="f0002">Fig. 2</figref> is a flow chart illustrating the overall operation of the data verification system of the invention herein.</li><li><figref idref="f0003">Fig. 3</figref> is a flow chart showing the operation of the schedule gaps and overlaps verification step of one embodiment of the data verification system of the invention herein.</li><li><figref idref="f0004">Fig. 4</figref> is an illustration of a user interface for setting the parameters of one embodiment of the data verification system of the invention herein.</li><li><figref idref="f0005">Fig.5</figref> is an illustration of a post-verification correction menu of one embodiment of the data verification system of the invention herein.</li><li><figref idref="f0006">Fig. 6</figref> is illustration of the correction editor feature of one embodiment of the data verification system of the invention herein.</li></ul>

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENT

System Configuration

<figref idref="f0001">Fig. 1</figref> is a block diagram illustrating schematically the general configuration for one embodiment of an electronic program guide delivery system. Information for the database may originate from several different information providers. For example, one source may provide all the national listings which may include network (both broadcast and cable) schedules, and regional program schedules or, alternatively, there may be multiple sources of such information. A single second source (or combination of second sources) may provide local listings information which includes schedules for locally originated programs, channel maps for individual cable systems, and information on shared channels (single cable channels that carry different programming during different parts of the day). A third information provider (or multiple providers) may furnish all of the listings information for pay-per-view events. It may even be the case that each of these categories of program schedule information are provided by multiple sources. Of course, it is also possible that all the information be gathered and provided by a single source or that overlapping information be gathered from the multiple sources. In addition, there may be other information providers such as billing vendors that furnish billing information.

Due to the fact that the listings database is likely to be comprised of information from a variety of different sources which may or may not furnish the data in the desired format, it may be necessary to perform format conversion and/or syntax verification on the received data prior to loading it into the database. This step is necessary to ensure that the data is in a uniform format in the database for further processing. A second function which may be performed on the data is pre-verification editing. One example of such editing is processing of the data by the text fit system disclosed in co-pending application serial number <patcit id="pcit0003" dnum="WO247059A"><text>247,059</text></patcit>. Text fit processing in effect expands the database to include multiple values for text fields for individual listings to accommodate different EPG platforms. For example, varying amounts of space are allocated for program titles for the different platforms. In addition, within the same platform, multiple versions of a title may be required to fit inside grid cells of, e.g., for a two hour program, 30, 60, 90, and 120 minutes. The text fit system determines whether an edited version of a title is required to fit within the designated space for a particular platform and grid cell. The database is then edited to include an abbreviated version of the title as well as the full title for the listing. It is also possible that a portion of the data will already contain multiple versions of titles. In some cases, it may be desirable to incorporate the text fit process into the verification utility by using the verification utility to first identify listings requiring processing with the text fit system and then running the text fit system on these identified listings. Depending on the particular implementation of the EPG delivery system, it may be desirable or necessary to perform additional pre-verification processing on the data.

Following the pre-verification processing steps, the listings database is assembled and processed by the data verification system. As shown in <figref idref="f0001">Fig. 1</figref>, the data verification system operates on the listings database and generates error reports for errors found therein. The program listings and channel map editing systems are used to make changes to the data in the listings database. The data verification system operates under user control to determine which data fields are to be checked. Alternatively, the system can operate fully automatically to check all data fields. An advantageous feature of one embodiment of the present invention is the creation of reports for each type of error. The reports permit the editor to reconcile any missing or conflicting information in the database with the information provider. The reports may be electronically generated and then viewed on a computer, stored in electronic format, or printed as hard copies. The utility operates on the database of program listings information for a user definable time period, such as one week. For each verification utility, stations may be selected individually, by channel map, platform type, multi-system operator ("MSO"), or arbitrary grouping. Each of the processing options associated with the system is discussed below. The operation of the various options is discussed under the section headed "System Operation."

1. Missing Stations

In order to determine if there are any stations missing from the database, the listings database (or any subset thereof) is checked against a second database that includes a list of all stations that should be included in the listings database or subset, such as a station list file for a particular cable system. The missing stations verification utility then outputs to a file a list of the missing stations.

2. Schedule Gaps and Overlaps

It is important to ensure that there are no gaps in the programming schedule. Included in the database is an indication of the daily on-the-air periods for each station. The database is then checked to determine if, for any designated station, there are any gaps between the ending time of a program and the start time of the next program. The end times for listings are calculated by adding the program's slot time (total time until the beginning of the next listing) to the start time. The system provides the flexibility of being able to specify any time range for checking for gaps and overlaps. If the beginning of the time range for a channel does not coincide with the beginning of a program, the system will check for the "intersecting listing", i.e., the listing starting prior to and ending after the beginning of the specified time range. Schedule holes are written to a file that includes the date, station, start time, and end time of the hole or other information sufficient to uniquely identify the schedule hole.

This option also checks for overlaps in a similar manner. If the listings data indicates that a program on a particular channel begins prior to the sum of the start time plus the run time of the previous program, the listing is flagged as a program overlap error.

3. Missing Titles

The listings database is checked for missing titles for program events, i.e., where the listing has no title field. Listings with missing titles are written to a file that includes the date, station, and start time of the listing.

4. Missing Copy

Certain program listings include additional descriptive information in addition to the program title called "copy." These include movies, live sports, and pay-per-view programs. The additional information may also be provided for other programs as well as determined by the operating rules for the EPG. The missing copy option checks these listings for missing copy and writes any such listings to a file with sufficient context data to identify the program, such as program date, station, start time, and title.

5. Missing Fields

This option checks the database listings to ensure that all required fields for each type of program are present. For example, according to the operating rules of the EPG as defined by the EPG provider, the schedule information for pay-per-view and premium movies must include an MPAA rating as this parameter may be used by viewers to lock-out certain movies. Thus, the missing fields option will check that the MPAA rating, as well as the other fields dictated by the operating rules, are in the database for the pay-per-view and premium listings. For PPV events, the operating rules may further dictate that the schedule information include price information, a telephone number for ordering the event, and promotional copy used for advertising the event. The missing fields option would then check these fields as well for programs designated as PPV events. Similarly, the operating rules may dictate different required fields for other types of listings. Listings with missing fields are written to a file including the date, station, and start time of the program, as well as an identification of the missing field.

6. Missing Movie Ratings

The listings database includes the MPAA movie ratings for movies to be shown on premium and PPV channels. Any such movies with missing ratings are written to a file including the date, station, start time, and title of the movie.

7. Lengthy Titles

Some or all of the data in the database may have already been processed with the text fit system to provide multiple titles where required to fit into the grid cells. The lengthy titles option permits the user to perform an additional check for any titles that do not fit into the maximum allowable space for each of the selected platforms and also identifies those entries not yet processed with the text fit system. Any such titles found are written to a file including the platform, date, station, start time, and title of the listings. This option may be selected for any of the platforms on which the EPG operates. The titles may then be processed using text fit and the verification utility re-run on the database.

8. Lengthy Copy

This option is similar to the lengthy copy option and searches the listings database for the copy for movies, live sports, pay-per-view programs, and any other entries with copy that will not fit into the allowable space for the selected platforms. Any such listings found are written to a file including the platform, date, station, start time, and title of the listings.

9. Editorial Errors

The listings database is searched for editorial errors which can include, inter alias, duplicated titles or years in the copy of a movie, cross references to other days, and certain phrases such as "at press time." Editorial errors are written to a file including the date, station, start time, and description of the error found for each listing. Of course, these particular errors represent only one particular embodiment of the system designed to detect the most common types of errors -- the utility may readily be modified to detect any specified editorial errors.

10. Language

This option searches the listings database for inappropriate language in titles, copy, and messages. The listings database is checked against a language dictionary that includes all of the language deemed inappropriate. Listings with any such language are written to a file including the date, station, start time, and inappropriate language found.

11. Other Verification Options

The above options for verifying the data in the listings database are not exhaustive. The verification system may be readily configured to check any field in the database. Some of the other fields which may be checked are as follows: missing program type, missing slot time, missing run time, missing program origin, PPV event on a non-PPV station, non-PPV event on a PPV station, and missing price or promotional copy for PPV events. Program type refers to the type of broadcast, i.e., broadcast, PPV, near video on demand ("NVOD"), etc. The slot time of a program is the total time from the beginning of one program until the start of the next program, including commercial time, and program run time is the actual running time of the program itself. The slot time for a program must exceed (or be only slightly less than) its run time, which is another possible verification option. Program origin indicates the source of the program. The program type and station type are used to check whether a PPV event is scheduled on a non-PPV station and whether a non-PPV event is scheduled on a PPV station.

It will be recognized by those of skill in the art that the particular information written to the appropriate file when an error or omission is located is not critical. All that is necessary is that sufficient context data is supplied to uniquely identify the faulty listing for correction purposes.

The data verification system may also be configured with an error navigation feature as follows. Following processing of the database or designated subset thereof and generation of the various error reports, the system may be configured to return to the portions of the database identified as containing errors, retrieve the appropriate database entries, and present them to the user for correction. Following correction of the errors, the database may again be processed with the data verification utility to check for errors. In this manner, an iterative process may be implemented to correct and verify all of the data in the database.

System ration

The data verification utility operates as shown in the flow diagram of <figref idref="f0002">Fig. 2</figref>. First the user is queried to specify the platform or platforms and the channel maps for which the utility is to be run. Alternatively, with a database such as that described in Tables 1 and 2, the user need only specify the cable group, system, or head end. The verification system can then extract from the database the appropriate platform(s) and channel map(s). Next, the desired verification options are chosen. Alternatively, the user may elect to activate all verification options. Depending on the options selected, the user may be queried for additional information. If the "Check Lengthy Titles" or "Check Lengthy Copy" option is selected, the user must input the path and filename for a font library file in order to determine the proper font to be used for display of the text. If the selection of a platform uniquely determines the font, this step may be eliminated as the file may be selected automatically. The particular font chosen affects the space required to display the text. Of course, the user may be supplied with a list of possible files and need only select a file from the displayed list. If the "Check Missing Stations" option is selected, the user will be requested to enter a master list of all stations that should appear in the listings database or a subset of stations representing the list for a particular cable system. This information may be contained in a station list file. If the "Check Language" option is selected, the user enters a language dictionary file containing a library of inappropriate words. Finally, the user is queried to enter a path and filenames for the output verification reports. Of course, a default path and filename may be used. Separate verification reports are generated for each selected option. The user may also elect to combine chosen reports into a single report.

Alternatively, to minimize the amount of user interaction required, the database may be configured to define all the necessary parameters so that the user need only select the cable system and verification options. For each cable system (or cable group or head end), the database contains a table with the correct platform(s) and a table listing the different fonts available for use with the platforms so that the user need not designate the font library file. Similarly, the language dictionary file may be defined by the choice of platform, eliminating the need for the user to define the file.

Following input of all the requested information, the data verification utility displays the selected options and user entered parameters for confirmation by the user. The data verification process then begins. Following processing, the system displays to the user a summary report showing the cumulative total errors located for each of the selected options. In addition, output reports are generated for each of the options selected including all listings found with the indicated error or omission.

Table 1 is an alphabetical list of all the data fields in one embodiment of a relational database for television program listings. The table shows the format, size, and data range for each field. Not every data field is used for each database entry. For example, fields such as actor_name, mpaa_rating, mpaa_ra_description, mpaa_reason, mpaa_reason_code, star-rating, and year will generally be used only for movies. Those of ordinary skill in the art will recognize that the disclosed data verification utility may be designed to operate with any database configuration. Table 2 illustrates the structure of the relational database of <figref idref="f0001">Fig. 1</figref> showing how the various database fields are organized as well as the primary keys (pk) and foreign keys. The bold typeface indicates the name of a table in the database and the entries listed underneath are the fields that comprise the table. <tables id="tabl0001" num="0001"><table frame="none"><title><u>Table 1</u></title><tgroup cols="3" colsep="0"><colspec colnum="1" colname="col1" colwidth="39mm" /><colspec colnum="2" colname="col2" colwidth="67mm" /><colspec colnum="3" colname="col3" colwidth="44mm" /><thead><row><entry valign="top">Element</entry><entry valign="top">Definition</entry><entry valign="top">Referenced By</entry></row></thead><tbody><row rowsep="0"><entry>actor_name</entry><entry>= \ name of actor \</entry><entry>Movie__Credits</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type VARCHAR2 (64)</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>available_undl</entry><entry>= \ date &amp; time YCTV program ends \</entry><entry>Schedule</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type DATE</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>barker_description</entry><entry>= \ text describing 'barker_type' \</entry><entry>Barker_Type</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type VARCHAR2 (32)</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>barker_type</entry><entry>= \ video barker type \</entry><entry>Barker_Type</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type NUMBER (4, 0)</entry><entry>Instance_Time</entry></row><row rowsep="0">&lt;entry /&gt;<entry>range {0...5}</entry><entry>Channel_Map</entry></row><row rowsep="0"><entry>billing</entry><entry>= \ actor credit ranking \</entry><entry>Movie__Credits</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type NUMBER (2, 0)</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>category</entry><entry>= \ program category \</entry><entry>Category</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type VARCHAR2 (16)</entry><entry>Program</entry></row><row rowsep="0">&lt;entry /&gt;<entry>unique</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>channel_number</entry><entry>= \ headend channel number \</entry><entry>Channel_Map</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type NUMBER (7, 0)</entry><entry>Instance_Time</entry></row><row rowsep="0">&lt;entry /&gt;<entry>range {0 ... 9,999,999 }</entry><entry>Channel_Map__PPV</entry></row><row rowsep="0"><entry>channel_label</entry><entry>= \ parallel channel station label \</entry><entry>Channel_Map</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type VARCHAR2 (16)</entry><entry>Instance_Time</entry></row><row rowsep="0">&lt;entry /&gt;<entry>Channel_Map__PPV</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>character</entry><entry>= \ 8 bit ASCII character \</entry><entry>Pixel_Map</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type NUMBER (3, 0)</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>range { 0 ... 255 }</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>characters_field_width</entry><entry>=</entry><entry>\ platform field width</entry></row><row rowsep="0"><entry>(characters) \</entry><entry>Platform__Field</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>type NUMBER (4, 0)</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>range { 1 ... 9,999 }</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>closed_caption</entry><entry>= \ closed captioning indicator \</entry><entry>Schedule</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type NUMBER (5, 0) [BOOLEAN]</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>range { YES | NO }</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>color_class</entry><entry>= \ color state of movie \</entry><entry>Color_Class</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type VARCHAR2 (16)</entry><entry>Schedule</entry></row><row rowsep="0">&lt;entry /&gt;<entry>range { 'BW' | 'Color' | 'Colorized' }</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>company_address =</entry><entry>\ cable company address \</entry><entry>Cable_Company</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type VARCHAR2 (512)</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>company id</entry><entry>= \ cable system company identifier \</entry><entry>Cable_Company</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type NUMBER (8, 0)</entry><entry>Company_Contact</entry></row><row rowsep="0">&lt;entry /&gt;<entry>range { 1... 99,999,999}</entry><entry>MSO__Company</entry></row><row rowsep="0"><entry>company_logo</entry><entry>= \ cable company logo \</entry><entry>Cable_Company</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type VARCHAR2 (512)</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>company_name</entry><entry>= \ cable company description \</entry><entry>Cable_Company</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type VARCHAR2 (512)</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>company_owner</entry><entry>= \ cable company name \</entry><entry>Cable_Company</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type VARCHAR2 (128)</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>contact_email</entry><entry>= \ contact electronic mail address \</entry><entry>MSO_Contact</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type VARCHAR2 (64)</entry><entry>Company_Contact</entry></row><row rowsep="0"><entry>contact_fax</entry><entry>= \ contact fax phone number \</entry><entry>MSO_Contact</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type VARCHAR2 (16)</entry><entry>Company_Contact</entry></row><row rowsep="0"><entry>contact_name</entry><entry>= \ contact name \</entry><entry>MSO_Contact</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type VARCHAR2 (64)</entry><entry>Company_Contact</entry></row><row rowsep="0"><entry>contact_phone</entry><entry>= \ contact phone number \</entry><entry>MSO_Contact</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type VARCHAR2 (16)</entry><entry>Company_Contact</entry></row><row rowsep="0"><entry>day</entry><entry>= \ day of week code \</entry><entry>Day</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type CHAR</entry><entry>Channel_Map</entry></row><row rowsep="0">&lt;entry /&gt;<entry namest="col2" nameend="col3" align="left">range { 'N' | 'M'| 'T' | 'W' | 'H' | 'F' | 'S' }</entry></row><row rowsep="0">&lt;entry /&gt;&lt;entry /&gt;<entry>Channel_Map__PPV</entry></row><row rowsep="0"><entry>day_description</entry><entry>= \ day of week description \</entry><entry>Day</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type VARCHAR2 (32)</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>range { 'Sunday' |</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>  'Monday' |</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>  'Tuesday' |</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>  'Wednesday' |</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>  'Thursday' |</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>  'Friday' |</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>  'Saturday' }</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>daylight_savings_time</entry><entry>=\ daylight savings time indicator \</entry><entry>Headend</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type NUMBER (5, 0) [BOOLEAN]</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>range { YES | NO }</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>do_textfit</entry><entry>= \ perform textfit on associated text \</entry><entry>Platform</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type NUMBER (5, 0)</entry><entry>Field_Type</entry></row><row rowsep="0"><entry>end_time</entry><entry>= \ station channel broadcast end time \</entry><entry>Channel_Map</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type DATE</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>event_datetime</entry><entry>= \ EST timestamp of broadcast event \</entry><entry>Schedule</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type DATE</entry><entry>Schedule_Text</entry></row><row rowsep="0"><entry>event_price</entry><entry>= \ broadcast event cost to viewer \</entry><entry>Schedule</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type NUMBER (7, 2)</entry><entry>Channel_Map__PPV</entry></row><row rowsep="0">&lt;entry /&gt;<entry>range { 0.00 ... 99,999.99 }</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>field_description</entry><entry>= \ field type description \</entry><entry>Field_Type</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type VARCHAR2 (32)</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>1 TVG title</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>2 Ext title</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>3 Alt1 title</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>4 Grid title</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>5 Short copy</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>6 Long copy</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>7 Promo copy</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>8 Originator</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>9 Guideline</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>100</entry><entry>TVG title 30 min.</entry></row><row rowsep="0">&lt;entry /&gt;<entry>101</entry><entry>TVG title 60 min.</entry></row><row rowsep="0">&lt;entry /&gt;<entry>102</entry><entry>TVG title 90 min.</entry></row><row rowsep="0">&lt;entry /&gt;<entry>103</entry><entry>TVG title 120 min.</entry></row><row rowsep="0">&lt;entry /&gt;<entry>200</entry><entry>Ext title 30 min.</entry></row><row rowsep="0">&lt;entry /&gt;<entry>201</entry><entry>Ext title 60 min.</entry></row><row rowsep="0">&lt;entry /&gt;<entry>202</entry><entry>Ext title 90 min.</entry></row><row rowsep="0">&lt;entry /&gt;<entry>203</entry><entry>Ext title 120 min.</entry></row><row rowsep="0"><entry>field_lines</entry><entry>= \ number of screen field lines \</entry><entry>Platform__Field</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type NUMBER (2, 0)</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>range {1... 99}</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>field_source_type</entry><entry>= \ source of a text fitted value \</entry><entry>Platform__Field</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type NUMBER (3,0)</entry><entry>Platform__Value</entry></row><row rowsep="0"><entry>field_type</entry><entry>= \ type of named field on platform \</entry><entry>Field_Type</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type NUMBER (3, 0)</entry><entry>Platform__Value</entry></row><row rowsep="0">&lt;entry /&gt;<entry>Platform__Field</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>Program_Map</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>Schedule_Text</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>font_type</entry><entry>= \ type of font used on platform\</entry><entry>Font_Type</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type NUMBER (4, 0)</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col3" align="left">Character_Pair_Kerning</entry></row><row rowsep="0">&lt;entry /&gt;<entry>range { 1 ... 9,999 }</entry><entry>Platform__Field</entry></row><row rowsep="0"><entry>group_description</entry><entry>= \ physical headend group identifier \</entry><entry>Groups</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type VARCHAR2 (128)</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>group_id</entry><entry>= \ logical system group identifier \</entry><entry>Groups</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type NUMBER (8, 0)</entry><entry>Groups__System</entry></row><row rowsep="0">&lt;entry /&gt;<entry>range { 1 ... 99,999,999 }</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>unique</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>guideline_weight</entry><entry>= \ TV Guide recommendation level \</entry><entry>Schedule</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type NUMBER (2, 0)</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>range {0 ... 4 }</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>headend_id</entry><entry>= \ target headend identifier \</entry><entry>Headend</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type VARCHAR2 (32)</entry><entry>System__Headend</entry></row><row rowsep="0">&lt;entry /&gt;<entry>unique</entry><entry>Map_Time</entry></row><row rowsep="0"><entry>instance_end_datetime</entry><entry>= \ end date/time of</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>scheduled event \</entry><entry>Instance_Time</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type DATE</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>instance_start_datetime</entry><entry>=</entry><entry>\ start date/time of</entry></row><row rowsep="0"><entry>scheduled event \</entry><entry>Instance_Time</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>type DATE</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>kerning_value</entry><entry>= \ kerning space value (pixels) \</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">Character_Pair_Kerning</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>type NUMBER (2,0)</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>range { 1 ... 99 }</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>last_verify_time</entry><entry>= \ last verification date and time \</entry><entry>Log_Control</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type DATE</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>left_char</entry><entry>= \ left character of kerning pair \</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">Character_Pair_Kerning</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>type NUMBER (3, 0)</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>range {0 ... 255 }</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>live_indicator</entry><entry namest="col2" nameend="col3" align="left">= \ program broadcast state (live/taped) \Program</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type NUMBER (5, 0)</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>range {YES | NO }</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>load_date</entry><entry>= \ last load process date \</entry><entry>Log_Control</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type DATE</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>load_end_time</entry><entry>= \ last load process end time \</entry><entry>Log_Control</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type DATE</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>load_start_time</entry><entry>= \ last load process start time \</entry><entry>Log_Control</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type DATE</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>log_file_drive</entry><entry>= \ log file drive specification \</entry><entry>Log_Control</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type VARCHAR2 (128)</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>log_id</entry><entry>= \ log control file identifier \</entry><entry>Log_Control</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type NUMBER (2, 0)</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>range { 1 }</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>unique</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>log_file_seqno</entry><entry>= \ last log file sequence number \</entry><entry>Log_Control</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type NUMBER (2, 0)</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>long_station_id</entry><entry>= \ station identifier long form \</entry><entry>Station</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type VARCHAR2 (64)</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>long_station_name</entry><entry>= \ station name (long form) \</entry><entry>Station</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type VARCHAR (512)</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>map_end_time</entry><entry>= \ channel map block start time \</entry><entry>Map_Time</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type DATE</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>map_start_time</entry><entry>= \ channel map block end time \</entry><entry>Map_Time</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type DATE</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>map_time_id</entry><entry>= \ channel map block designator \</entry><entry>Map_Time</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type VARCHAR2 (48)</entry><entry>Instance_Time</entry></row><row rowsep="0">&lt;entry /&gt;<entry>unique</entry><entry>Channel_Map</entry></row><row rowsep="0">&lt;entry /&gt;<entry>Channel_Map__PPV</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>mpaa_rating</entry><entry>= \ MPAA rating character \</entry><entry>MPAA_Rating</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type CHAR</entry><entry>Movie</entry></row><row rowsep="0">&lt;entry /&gt;<entry>range { 'N' |'G' | 'P' |</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>  '3' | 'R' | '7' }</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>mpaa_rating_code</entry><entry>= \ MPAA rating code \</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>type CHAR (10)</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>mpaa_ra_description</entry><entry>=\ MPAA rating code description \</entry><entry>MPAA _Rating</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type VARCHAR2 (128)</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>range { 'NR - Not Rated' |</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>  'G - General Audiences' |</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>  'PG - Parental Guidance' |</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry namest="col2" nameend="col3" align="left">  'PG-13 - Parental Guidance (some material not suitable for under 13 yrs)' |</entry></row><row rowsep="0">&lt;entry /&gt;<entry>  'R - Restricted' |</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>  'NC-17 - No one under 17 admitted' }</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>mpaa_reason</entry><entry>= \ MPAA rating reason description \</entry><entry>MPAA_Reason</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type VARCHAR2 ( 64)</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">Movie__MPAA_Reason</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>range { 'adult themes' |</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>  'adult situations' |</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>  'sexual situations' |</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>  'strong language' |</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>  'violence' |</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>  'nudity' |</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>  'partial nudity' }</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>mpaa_reason_code</entry><entry>= \ MPAA rating reason code \</entry><entry>MPAA_Reason</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type CHAR</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>range { 'T' | 'A'| 'S' |</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>  'L' | 'V' | 'N' | 'P' }</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>mso_address</entry><entry>= \ multi system owner address \</entry><entry>MSO</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type VARCHAR2 (512)</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>mso_id</entry><entry>= \ multi system owner identifier\</entry><entry>MSO</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type NUMBER (8, 0)</entry><entry>MSO_Contact</entry></row><row rowsep="0">&lt;entry /&gt;<entry>range { 1 ... 99,999,999 }</entry><entry>MSO__Company</entry></row><row rowsep="0"><entry>mso_logo</entry><entry>= \ multi system owner logo \</entry><entry>MSO</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type VARCHAR2 (512)</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>mso_name</entry><entry>= \ multi system owner description</entry><entry>\ MSO</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type VARCHAR2 (512)</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>mso _owner</entry><entry>= \ multi system owner name \</entry><entry>MSO</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type VARCHAR2 (128)</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>onscreen_text_id</entry><entry>= \ TV Guide on screen name \</entry><entry>Edited_Station</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type NUMBER</entry><entry>Platform__Station</entry></row><row rowsep="0">&lt;entry /&gt;<entry>Text_Catalog (text_id)</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>original_air_date</entry><entry>= \ YCTV event first broadcast \</entry><entry>Schedule</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type DATE</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry namest="col2" nameend="col3" align="left">range { SYSTEM_MIN_DATE ... SYSTEM_MAX_ DATE }</entry></row><row rowsep="0"><entry>pin</entry><entry>= \ TV Guide program identifier \</entry><entry>Program</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type CHAR (20)</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>format pppppppp.ssssssss.XX</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>where (XX is</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>  MV = movie |</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>  SR = series |</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>  MS = miscellaneous |</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>  SM = series master (for lock-out) |</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>  UN = unknown (is not assigned ))</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>pixel_map</entry><entry>= \ character pixel set identifier \</entry><entry>Valid_Pixel_Map</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type NUMBER (2, 0)</entry><entry>Font_Type</entry></row><row rowsep="0">&lt;entry /&gt;<entry>range { 1 ... 99 }</entry><entry>Pixel_Map</entry></row><row rowsep="0"><entry>pixel_width</entry><entry>= \ width of character (pixels) \</entry><entry>Pixel_Map</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type NUMBER (2, 0)</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>range { 1 ... 99 }</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>pixels_field_width =</entry><entry>\ width of platform field (pixels) \</entry><entry>Platform_Field</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type NUMBER (4, 0)</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>range { 1 ... 9,999 }</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>platform_text_id</entry><entry>= \ platform field text catalog id \</entry><entry>Platform__Value</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type NUMBER</entry><entry>Schedule_Text</entry></row><row rowsep="0">&lt;entry /&gt;<entry>Text_Catalog (text_id)</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>platform_id</entry><entry>= \ target display unit platform \</entry><entry>Platform</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type VARCHAR2 (16)</entry><entry>Platform__Field</entry></row><row rowsep="0">&lt;entry /&gt;<entry>range { 'Catalyst Visual' |</entry><entry>Platform__Station</entry></row><row rowsep="0">&lt;entry /&gt;<entry>  'ESP 8600x' |</entry><entry>Platform__Value</entry></row><row rowsep="0">&lt;entry /&gt;<entry>  'ESP SA Grid' |</entry><entry>Edited_Station</entry></row><row rowsep="0">&lt;entry /&gt;<entry>  'ESP Turbo' |</entry><entry>System</entry></row><row rowsep="0">&lt;entry /&gt;<entry>  'Starnet Passive' }</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>preview_end_offset</entry><entry namest="col2" nameend="col3" align="left">= \ PPV preview window end time offset \Schedule</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type DATE</entry><entry>Channel_Map__PPV</entry></row><row rowsep="0"><entry>preview_start_offset =</entry>&lt;entry /&gt;<entry>\ PPV preview</entry></row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">window start time offset \</entry><entry>Schedule</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type DATE</entry><entry>Channel_Map__PPV</entry></row><row rowsep="0"><entry>print_run_time</entry><entry>= \ actual broadcast event run time \</entry><entry>Schedule</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type NUMBER (7, 0)</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>range { 0 ... 9,999,999 }</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>where ( 0 : = continuous running time )</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>programed</entry><entry>= \ program identifier \</entry><entry>Program</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type NUMBER</entry><entry>Movie</entry></row><row rowsep="0">&lt;entry /&gt;<entry>unique</entry><entry>Movie__Credits</entry></row><row rowsep="0">&lt;entry /&gt;<entry> Movie__MPAA_Reason</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry> Program_Map</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry> Schedule</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>program_text_id</entry><entry>= \ program event field text identifier \</entry><entry>Program_Map</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type NUMBER</entry><entry>Platform__Value</entry></row><row rowsep="0">&lt;entry /&gt;<entry>Schedule_Text</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>Text_Catalog (text_id)</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>program_type</entry><entry>= \ type of broadcast event \</entry><entry>Program Type</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type VARCHAR2 (8)</entry><entry>Schedule</entry></row><row rowsep="0">&lt;entry /&gt;<entry>range { 'Other' |</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>  'PPV' |</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>  'YCTV' |</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>  'NVOD' }</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>purchase_call_phone</entry><entry>= \ PPV purchase call phone number \</entry><entry>Schedule</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type VARCHAR2 (16)</entry><entry>Channel_Map__PPV</entry></row><row rowsep="0"><entry>purchase_end_offset</entry><entry>= \ PPV purchase window end time offset</entry><entry>\ Schedule</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type NUMBER (4, 0)</entry><entry>Channd_Map__PPV</entry></row><row rowsep="0"><entry>purchase_start_offset</entry><entry>= \ PPV purchase window start time offset</entry><entry>\Schedule</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type NUMBER (4, 0)</entry><entry>Channel_Map_PPV</entry></row><row rowsep="0"><entry>right_char</entry><entry>= \ right character of kerning pair \</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col3" align="left">Character_Pair_Kerning</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type NUMBER (3, 0)</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>range { 0 ... 255 }</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>role_name</entry><entry>= \ alias actor name \</entry><entry>Movie__Credit</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type VARCHAR2 (64)</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>searchtype</entry><entry>= \ word search type - whole word or</entry><entry>not \Wordlist</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type NUMBER (2, 0) ?</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>range { 0 | 1 }</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>series_id</entry><entry>= \ program series identifier \</entry><entry>Schedule</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type NUMBER (7, 0)</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>range { 1 ... 9,999,999 }</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>seqno</entry><entry>= \ sequence number to maintain order</entry><entry>\Day</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type NUMBER (2, 0)</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>Movie__MPAA_Reason</entry>&lt;entry /&gt;&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>range { 1 ... 99 }</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>slot_run_time</entry><entry>= \ broadcast event run time (minutes) \</entry><entry>Schedule</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type NUMBER (7, 0)</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>range { 0 ... 9,999,999 }</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>where ( 0 : = continuous running time )</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>star_rating</entry><entry>= \ TV Guide movie quality rating \</entry><entry>Movie</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type NUMBER (2, 0)</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>range { 0 ... 5 }</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>start_time</entry><entry>= \ broadcast station channel start time</entry><entry>\Channel_Map</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type DATE</entry><entry>Channel_Map__PPV</entry></row><row rowsep="0"><entry>station_description =</entry><entry>\ station type description \</entry><entry>Station_Type</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type VARCHAR2 (32)</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>range { 'Broadcast' |</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>  'Cable' |</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>  'Premium' |</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>  'Select Entertainment' |</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>  'PPV' |</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>  'Hits at Home' |</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>  'YCTV'}</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>station_id</entry><entry>= \ broadcast station call letters \</entry><entry>Station</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type VARCHAR2 (16)</entry><entry>Edited_Station</entry></row><row rowsep="0">&lt;entry /&gt;<entry>unique</entry><entry>Instance_Time</entry></row><row rowsep="0">&lt;entry /&gt;<entry> Platform_Station</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry> Schedule</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry> Channel_Map</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry> Channel_Map__PPV</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry> Schedule_Text</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>station_priority</entry><entry>= \ schedule conflict resolution priority \</entry><entry>Channel_Map</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type NUMBER (2, 0)</entry><entry>Instance_Time</entry></row><row rowsep="0">&lt;entry /&gt;<entry>range ( 1 ... 5 )</entry><entry>Channel_Map__PPV</entry></row><row rowsep="0"><entry>station_type</entry><entry>= \ type of station class \</entry><entry>Station_Type</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type NUMBER (2, 0)</entry><entry>Station</entry></row><row rowsep="0">&lt;entry /&gt;<entry>range { 10 ... 99 }</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>system_description</entry><entry>= \ system description \</entry><entry>System</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type VARCHAR2 (64)</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>system_id</entry><entry><b>=</b> \ system identifier \</entry><entry>System</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type NUMBER (8, 0)</entry><entry>Groups__System</entry></row><row rowsep="0">&lt;entry /&gt;<entry>range { 1 ... 99,999,999 }</entry><entry>System__Headend</entry></row><row rowsep="0">&lt;entry /&gt;<entry>unique</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>text</entry><entry>= \ catalog text character string \</entry><entry>Text_Catalog</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type VARCHAR2 (512)</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>text_id</entry><entry>= \ catalog text identifier \</entry><entry>Text_Catalog</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type NUMBER</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>timezone</entry><entry>= \ broadcast event time zone \</entry><entry>Timezone</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type CHAR (3)</entry><entry>Headend</entry></row><row rowsep="0">&lt;entry /&gt;<entry>range {'ET' | 'CT' |</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>  'MT' | 'PT' |</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>  'AT' | 'HAT' |</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>  'LT' | 'ST' }</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>touched</entry><entry>= \ text last touched timestamp \</entry><entry>Text_Catalog</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type DATE</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>tz_description</entry><entry>= \ timezone description \</entry><entry>Timezone</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type VARCHAR2 (64)</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>word</entry><entry>= \ proscribed work \</entry><entry>Wordlist</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type VARCHAR2 (50)</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>unique</entry>&lt;entry /&gt;</row><row rowsep="0"><entry>year</entry><entry>= \ movie release year \</entry><entry>Movie</entry></row><row rowsep="0">&lt;entry /&gt;<entry>type NUMBER (4, 0)</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>range { 0 ... 9,999 }</entry>&lt;entry /&gt;</row></tbody></tgroup></table></tables><tables id="tabl0002" num="0002"><table frame="none"><title><u>Table 2</u></title><tgroup cols="3" colsep="0"><colspec colnum="1" colname="col1" colwidth="26mm" /><colspec colnum="2" colname="col2" colwidth="41mm" /><colspec colnum="3" colname="col3" colwidth="38mm" /><thead><row><entry valign="top">Table</entry><entry valign="top">Attribute/Primary Key</entry><entry valign="top">Foreign Key Table</entry></row></thead><tbody><row rowsep="0"><entry><b>Barker_Type</b></entry>&lt;entry /&gt;&lt;entry /&gt;</row><row rowsep="0"><entry>  pk</entry><entry>= barker_type</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  barker_type</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  barker_description</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col3" align="left"><b>Cable_Company</b></entry></row><row rowsep="0"><entry>  pk</entry><entry>= company_id</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  company_id</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  company_name</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  company_owner</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  company_address</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  company_logo</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col3" align="left"><b>Category</b></entry></row><row rowsep="0"><entry>  pk</entry><entry>= category</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  category</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col3" align="left"><b>Channel_Map</b></entry></row><row rowsep="0"><entry>  pk</entry><entry>= map_time_id</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>+ channel_number</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>+ channel_label</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>+ station_priority</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>+ day</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>+ start_time</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  map_time_id</entry><entry>Map_Time</entry></row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  channel_number</entry><entry>channel_number</entry></row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  channel_label</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  station_priority</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  day</entry><entry>Day</entry></row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  start_time</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  end_time</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  station_id</entry><entry>Station</entry></row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  barker_type</entry><entry>Barker_Type</entry></row><row rowsep="0"><entry namest="col1" nameend="col3" align="left"><b>Channel_Map__PPV</b></entry></row><row rowsep="0"><entry>  pk</entry><entry>= map_time_id</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>+ channel_number</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>+ channel_label</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>+ station_priority</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>+ day</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>+ start_time</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  map_time_id</entry><entry>Map_Time</entry></row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  channel_number</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  channel_label</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  station_priority</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  day</entry><entry>Day</entry></row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  start_time</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  purchase_start_offset</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  purchase_end_offset</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  purchase_call_phone</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  preview_start_offset</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  preview_end_offset</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  event_price</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col3" align="left"><b>Character_Pair_Kerning</b></entry></row><row rowsep="0"><entry>  pk</entry><entry>= font_type</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>+ left_char</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>+ right_char</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  font_type</entry><entry>Font_Type</entry></row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  left_char</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  right_char</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  kerning_value</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col3" align="left"><b>Color_Class</b></entry></row><row rowsep="0"><entry>  pk</entry><entry>= color_class</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  color_class</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col3" align="left"><b>Company_Contact</b></entry></row><row rowsep="0"><entry>  pk</entry><entry>= company_id</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>+ contact_name</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  company_id</entry><entry>Cable_Company</entry></row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  contact_name</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  contact_phone</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  contact_fax</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  contact_email</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col3" align="left"><b>Day</b></entry></row><row rowsep="0"><entry>  pk</entry><entry>= day</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  day</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  day_description</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  seqno</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col3" align="left"><b>Edited_Station</b></entry></row><row rowsep="0"><entry>  pk</entry><entry>= platform_id</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>+ station_id</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  platform_id</entry><entry>Platform</entry></row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  station_id</entry><entry>Station</entry></row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  onscreen_text_id</entry><entry>Text_Catalog (text_id)</entry></row><row rowsep="0"><entry namest="col1" nameend="col3" align="left">Field_Type</entry></row><row rowsep="0"><entry>  pk</entry><entry>= field_type</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  field_type</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  field_description</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  do_textfit</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col3" align="left"><b>Font_Type</b></entry></row><row rowsep="0"><entry>  pk</entry><entry>= font_type</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  font_type</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  pixel_map</entry><entry>Valid_Pixel_Map</entry></row><row rowsep="0"><entry namest="col1" nameend="col3" align="left"><b>Groups</b></entry></row><row rowsep="0"><entry>  pk</entry><entry>= group_id</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  group_id</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  group_description</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col3" align="left"><b>Groups__System</b></entry></row><row rowsep="0"><entry>  pk</entry><entry>= group_id</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>+ system_id</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  group_id</entry><entry>Groups</entry></row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  system_id</entry><entry>System</entry></row><row rowsep="0"><entry namest="col1" nameend="col3" align="left"><b>Headend</b></entry></row><row rowsep="0"><entry>  pk</entry><entry>= headend_id</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  headend_id</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  timezone</entry><entry>Timezone</entry></row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  daylight_savings_time</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col3" align="left"><b>Instance_Time</b></entry></row><row rowsep="0"><entry>  pk</entry><entry>= map_time_id</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>+ channel_number</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>+ channel_label</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>+ station_priority</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>+ instance_start_datetime</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  map_time_id</entry><entry>Map_Time</entry></row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  channel_number</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  channel_label</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  station_priority</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  instance_start_datetime</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  instance_end_datetime</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  station_id</entry><entry>Station</entry></row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  barker_type</entry><entry>Barker_Type</entry></row><row rowsep="0"><entry namest="col1" nameend="col3" align="left"><b>Log_Control</b></entry></row><row rowsep="0"><entry>  pk</entry><entry>= log_id</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  log_id</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  load_date</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  load_start_time</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  load_end_time</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  last_verify_time</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  log_file_seqno</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  log_file_drive</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col3" align="left"><b>Map_Time</b></entry></row><row rowsep="0"><entry>  pk</entry><entry>= map_time_id</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  map _time_id</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  headend_id</entry><entry>Headend</entry></row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  map_start_time</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  map_end_time</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col3" align="left"><b>Movie</b></entry></row><row rowsep="0"><entry>  pk</entry><entry>= program_id</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  program_id</entry><entry>Program</entry></row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  mpaa_rating</entry><entry>MPAA_Rating</entry></row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  year</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  star_rating</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col3" align="left"><b>Movie__Credits</b></entry></row><row rowsep="0"><entry>  pk</entry><entry>= program_id</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>+ billing</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  program_id</entry><entry>Movie</entry></row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  billing</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  actor_name</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  role_name</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col3" align="left"><b>Movie__MPAA_Reason</b></entry></row><row rowsep="0"><entry>  pk</entry><entry>= program_id</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>+ mpaa_reason</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  program_id</entry><entry>Movie</entry></row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  mpaa_reason</entry><entry>MPAA_Reason</entry></row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  seqno</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col3" align="left"><b>MPAA_Rating</b></entry></row><row rowsep="0"><entry>  pk</entry><entry>= mpaa_rating</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  mpaa_rating</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  mpaa_rating_code</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  mpaa_ra_description</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col3" align="left"><b>MPAA_Reason</b></entry></row><row rowsep="0"><entry>  pk</entry><entry>= mpaa_reason</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  mpaa_reason</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  mpaa_reason_code</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col3" align="left"><b>MSO</b></entry></row><row rowsep="0"><entry>  pk</entry><entry>= mso_id</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  mso_id</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  mso_name</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  mso_owner</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  mso_address</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  mso_logo</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col3" align="left"><b>MSO__Company</b></entry></row><row rowsep="0"><entry>  pk</entry><entry>= mso_id</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>+ company_id</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  mso_id</entry><entry>MSO</entry></row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  company_id</entry><entry>Cable_Company</entry></row><row rowsep="0"><entry namest="col1" nameend="col3" align="left"><b>MSO_Contact</b></entry></row><row rowsep="0"><entry>  pk</entry><entry>= mso_id</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>+ contact_name</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  mso_id</entry><entry>MSO</entry></row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  contact_name</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  contact_phone</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  contact_fax</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  contact_email</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col3" align="left"><b>Pixel_Map</b></entry></row><row rowsep="0"><entry>  pk</entry><entry>= pixel_map</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>+ character</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  pixel_map</entry><entry>Valid_Pixel_Map</entry></row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  character</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  pixel_width</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col3" align="left"><b>Platform</b></entry></row><row rowsep="0"><entry>  pk</entry><entry>= platform_id</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  platform_id</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  do_textfit</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col3" align="left"><b>Platform__Field</b></entry></row><row rowsep="0"><entry>  pk</entry><entry>= platform_id</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>+ field_type</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  platform_id</entry><entry>Platform</entry></row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  field_type</entry><entry>Field_Type</entry></row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  characters_field_width</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  pixels_field_width</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  field_lines</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  field_source_type</entry><entry>Field_Type (field_type)</entry></row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  font_type</entry><entry>Font_Type</entry></row><row rowsep="0"><entry namest="col1" nameend="col3" align="left"><b>Platform__Station</b></entry></row><row rowsep="0"><entry>  pk</entry><entry>= platform_id</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>+ station_id</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  platform_id</entry><entry>Platform</entry></row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  station_id</entry><entry>Station</entry></row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  onscreen_text_id</entry><entry>Text_Catalog (text_id)</entry></row><row rowsep="0"><entry namest="col1" nameend="col3" align="left"><b>Platform__Value</b></entry></row><row rowsep="0"><entry>  pk</entry><entry>= platform_id</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>+ field_type</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>+ program_text_id</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  platform_id</entry><entry>Platform</entry></row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  field_type</entry><entry>Field_Type</entry></row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  program_text_id</entry><entry>Text_Catalog (text_id)</entry></row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  platform_text_id</entry><entry>Text_Catalog (text_id)</entry></row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  field_source_type</entry><entry>Field_Type (field_type)</entry></row><row rowsep="0"><entry namest="col1" nameend="col3" align="left"><b>Program</b></entry></row><row rowsep="0"><entry>  pk =</entry><entry>program_id</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  program_id</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  pin</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  live_indicator</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  category</entry><entry>Category</entry></row><row rowsep="0"><entry namest="col1" nameend="col3" align="left"><b>Program_Map</b></entry></row><row rowsep="0"><entry>  pk</entry><entry>= program_id</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>+ field_type</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  program_id</entry><entry>Program</entry></row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  field_type</entry><entry>Field_Type</entry></row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  program_text_id</entry><entry>Text_Catalog (text_id)</entry></row><row rowsep="0"><entry namest="col1" nameend="col3" align="left"><b>Program_Type</b></entry></row><row rowsep="0"><entry>  pk</entry><entry>= program_type</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  program_type</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col3" align="left"><b>Schedule</b></entry></row><row rowsep="0"><entry>  pk</entry><entry>= station_id</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>+ event_datetime</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  station_id</entry><entry>Station</entry></row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  event_datetime</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  series_id</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  program_id</entry><entry>Program</entry></row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  closed_caption</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  color_class</entry><entry>Color_Class</entry></row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  slot_run_time</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  Print_run_time</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  event_price</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  purchase_start_offset</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  purchase_end_offset</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  purchase_call_phone</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  preview_start_offset</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  preview_end_offset</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  original_air_date</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  available_until</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  guideline_weight</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  program_type</entry><entry>Program_Type</entry></row><row rowsep="0"><entry namest="col1" nameend="col3" align="left"><b>Schedule_Text</b></entry></row><row rowsep="0"><entry>  pk</entry><entry>= station_id</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>+ event_datetime</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>+ field_type</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  Station_id</entry><entry>Station</entry></row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  event_datetime</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  field_type</entry><entry>Field_Type</entry></row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  program_text_id</entry><entry>Text_Catalog (text_id)</entry></row><row rowsep="0"><entry>  fk</entry><entry>= station_id</entry><entry>Schedule</entry></row><row rowsep="0">&lt;entry /&gt;<entry>+ event_datetime</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col3" align="left"><b>Station</b></entry></row><row rowsep="0"><entry>  pk</entry><entry>= station_id</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  station_id</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  station_type</entry><entry>Station_Type</entry></row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  long_station_name</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col3" align="left"><b>Station_Type</b></entry></row><row rowsep="0"><entry>  pk</entry><entry>= station_type</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  station_type</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  station_description</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col3" align="left"><b>System</b></entry></row><row rowsep="0"><entry>  pk</entry><entry>= system_id</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  system_id</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  system_description</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  platform_id</entry><entry>Platform</entry></row><row rowsep="0"><entry namest="col1" nameend="col3" align="left"><b>System__Headend</b></entry></row><row rowsep="0"><entry>  pk</entry><entry>= system_id</entry>&lt;entry /&gt;</row><row rowsep="0">&lt;entry /&gt;<entry>+ headend_id</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  system_id</entry><entry>System</entry></row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  headend_id</entry><entry>Headend</entry></row><row rowsep="0"><entry namest="col1" nameend="col3" align="left"><b>Text_Catalog</b></entry></row><row rowsep="0"><entry>  pk</entry><entry>= text_id</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  text_id</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  text</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  touched</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col3" align="left"><b>Timezone</b></entry></row><row rowsep="0"><entry>  pk</entry><entry>= timezone</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  timezone</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  tz_description</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col3" align="left"><b>Valid_Pixel_Map</b></entry></row><row rowsep="0"><entry>  pk</entry><entry>= pixel_map</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  pixel_map</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col3" align="left"><b>Wordlist</b></entry></row><row rowsep="0"><entry>  pk</entry><entry>= word</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  word</entry>&lt;entry /&gt;</row><row rowsep="0"><entry namest="col1" nameend="col2" align="left">  searchtype</entry>&lt;entry /&gt;</row></tbody></tgroup></table></tables>

<u>Missing Stations</u>

As shown in <figref idref="f0002">Fig. 2</figref>, in order to check for missing stations, the user must designate a station list file. The station list file may contain every station in the database, a subset of stations representing the stations in a particular cable system, any user defined group of stations, or a single station. In addition, the station list file contains a data field for each station indicating the daily on-air times for that station. The listings database (i.e., the station_id field) is then searched against this file to determine if each station in the station list file is included in the database. If missing stations are found, the total number of missing stations is incremented and displayed and the name of the missing station is written to an output file.

Schedule Gaps and Overlaps

The schedule gap and overlap option operates as shown in <figref idref="f0003">Fig. 3</figref>. The flow chart shows the operation for a single station but operation is the same for each station in a station list file. First, a time range is selected for checking for gaps and overlaps. The system then checks the database to determine if the beginning of the time range coincides with the start of a program and begins the process with this listing. If the beginning of the time range intersects a program already showing, the system begins the process with this listing. The start time (start_time) for the first listing to be checked is then retrieved form the database. If there are no gaps or overlaps in the schedule, the start time of the next listing should be the start time of the previous listing plus the slot run time (slot_run_time) of the previous listing. Each listing is then checked in succession according to the following equations used to determine whether there is a hole or a gap: <maths id="math0001" num=""><math display="block"><msub><mi mathvariant="normal">T</mi><mrow><mi mathvariant="normal">n</mi><mo>+</mo><mn mathvariant="normal">1</mn></mrow></msub><mo>=</mo><msub><mi mathvariant="normal">T</mi><mi mathvariant="normal">n</mi></msub><mo>+</mo><msub><mi>RT</mi><mi mathvariant="normal">n</mi></msub><mfenced><mi>schedule is correct</mi></mfenced></math><img file="EP2175646B1_D0001.tif" /></maths><maths id="math0002" num=""><math display="block"><msub><mi mathvariant="normal">T</mi><mrow><mi mathvariant="normal">n</mi><mo>+</mo><mn mathvariant="normal">1</mn></mrow></msub><mo>&gt;</mo><msub><mi mathvariant="normal">T</mi><mi mathvariant="normal">n</mi></msub><mo>+</mo><msub><mi>RT</mi><mi mathvariant="normal">n</mi></msub><mfenced><mi>schedule gap</mi></mfenced></math><img file="EP2175646B1_D0002.tif" /></maths><maths id="math0003" num=""><math display="block"><msub><mi mathvariant="normal">T</mi><mrow><mi mathvariant="normal">n</mi><mo>+</mo><mn mathvariant="normal">1</mn></mrow></msub><mo>&lt;</mo><msub><mi mathvariant="normal">T</mi><mi mathvariant="normal">n</mi></msub><mo>+</mo><msub><mi>RT</mi><mi mathvariant="normal">n</mi></msub><mspace width="1em" /><mfenced><mi>schedule overlap</mi></mfenced></math><img file="EP2175646B1_D0003.tif" /></maths> where T_a represents the start time and RT, the slot run time for the nth listing in the database. Each entry in the database is checked independently of the other entries so that a schedule gap or overlap for a particular pair of programs will not affect all of the subsequent listings in the database. For stations that do not broadcast 24 hours a day, an off-the-air place holder is inserted into the database and treated as a program.

For some television stations, particularly premium stations, a small gap or overlap (i.e., 5 minutes) in programs may be permitted. For example, on a premium movie channel, a movie may begin 5 minutes or so after the slot time so that if the previous movie runs 3 minutes into the slot time, there is no actual overlap. Similarly, a movie with a running time of, e.g., 87 minutes will end prior to the beginning of the next time slot. However, it is common for premium stations to fill this apparent gap with advertising or other promotional material. If is the case, the equations may be modified as follows to reflect the fact that such small gaps and overlaps are permissible: <maths id="math0004" num=""><math display="block"><msub><mi mathvariant="normal">T</mi><mrow><mi mathvariant="normal">n</mi><mo>+</mo><mn mathvariant="normal">1</mn></mrow></msub><mo>=</mo><mfenced separators=""><msub><mi mathvariant="normal">T</mi><mi mathvariant="normal">n</mi></msub><mo>+</mo><msub><mi>RT</mi><mi mathvariant="normal">n</mi></msub></mfenced><mo>+</mo><mo>/</mo><mo>-</mo><mn>5</mn><mspace width="1em" /><mi>minutes</mi><mspace width="1em" /><mfenced><mi>schedule is correct</mi></mfenced></math><img file="EP2175646B1_D0004.tif" /></maths><maths id="math0005" num=""><math display="block"><msub><mi mathvariant="normal">T</mi><mrow><mi mathvariant="normal">n</mi><mo>+</mo><mn mathvariant="normal">1</mn></mrow></msub><mo>&gt;</mo><msub><mi mathvariant="normal">T</mi><mi mathvariant="normal">n</mi></msub><mo>+</mo><msub><mi>RT</mi><mi mathvariant="normal">n</mi></msub><mo>+</mo><mn>5</mn><mspace width="1em" /><mi>minutes</mi><mspace width="1em" /><mfenced><mi>schedule gap</mi></mfenced></math><img file="EP2175646B1_D0005.tif" /></maths><maths id="math0006" num=""><math display="block"><msub><mi mathvariant="normal">T</mi><mrow><mi mathvariant="normal">n</mi><mo>+</mo><mn mathvariant="normal">1</mn></mrow></msub><mo>&lt;</mo><msub><mi mathvariant="normal">T</mi><mi mathvariant="normal">n</mi></msub><mo>+</mo><msub><mi>RT</mi><mi mathvariant="normal">n</mi></msub><mo>-</mo><mn>5</mn><mspace width="1em" /><mi>minutes</mi><mspace width="1em" /><mfenced><mi>schedule overlap</mi></mfenced></math><img file="EP2175646B1_D0006.tif" /></maths>

Missing Titles, Copy, Fields, and Movie Ratings

The missing titles, missing copy, missing fields, and missing movie ratings utilities operate as follows. For each of these options, the listings are checked for the missing information by searching the designated field or fields. For missing titles, all of the different titles for a program may be checked, including the full (TVG) title and the various shortened versions (i.e., for 30, 60, 90, and 120 minute grid boxes). For the missing copy option, the long copy, short copy, and promo copy fields may be checked. In the database described by Tables 1 and 2, all textual data (including program titles, copy, and originator) for a program is stored in a Text_Catalog table, which is indexed using a text_id. The text_id is obtained from another table, such as Program_Map, which consists of an array of pointers into the Text_Catalog. The Program_Map table is indexed using the program_id and field_type. There is a text pointer for each of the different field types as indicated under the field_description in Table 1. Using a program_id, all text data associated with a program may be retrieved.

For the missing movie rating option, the MPAA_rating field is checked. For the missing fields option, all fields which should be present for a particular listing (according to the operating rules of the EPG) are checked. When any of the above missing fields is found, the appropriate count is incremented and displayed. In addition, the date, start time, station identification, and title (for missing copy and MPAA ratings) are written to the appropriate output verification report.

The missing copy option will check for missing copy for all the listings that should include copy such as movies, live sports, and pay-per-view programs. The missing movie ratings option checks all premium channels and pay-per-view events for movie ratings since only these channels will air un-edited movies. It is of course also possible to generate a single output verification report including all of the listings with missing information. Thus, a single file can be generated listing all listings with missing titles, copy, and/or movie ratings.

Lengthy Titles and Lengthy Copy

The operation of the lengthy titles and lengthy copy options is as follows. Based on the platform or platforms selected by the user (the Platform_id field), the system checks a table in the database that indicates the various different display formats for each listing. For example, if the platform supports both an interactive and channel guide type EPG, each with different display characteristics, the table will indicate that each should be included in the database. Thus, for a two hour movie, the system will check that there are titles for each listing tagged as 30, 60, 90, and 120 minute listings to fit into the different sized grid cells for each of the two types of EPGs. If any of the required titles are missing, the system will write sufficient information to the output report to identify the missing title. In addition, the system checks the multiple versions of the titles in the database to ensure that each fits into the designated space for the particular platform. The space required for display of the listings is determined by consulting the table listing the available fonts for the platform and calculating the space required based on the font and character pair kerning. The character_pair_kerning table shown in Table 2 returns the kerning value for character pairs that are kerned which is used to determine the actual space required for display of a character pair. In order to avoid calculating the space required for display of an entire word each time the word is encountered in the database, a look-up table may be built including, for each different font, the space required for display of a word, accounting for character pair kerning. In this manner, the look up table is consulted prior to actually calculating the required space. If the word is in the look-up table, it is not necessary to calculate the space requirement. If it is not, following calculation of the space requirement, the word is added to the look-up table for future reference. Alternatively, in order to avoid recalculation of whether any particular title will fit in a particular display for a particular platform, an appropriate tag is applied to each title that previously has been text-fitted. Then, when the verification process is run, in order to determine if all text-fitted titles are present, the system checks for the presence of titles previously tagged for the specific platform.

For lengthy copy, each listing which, according to the operating rules of the EPG, should include copy, is checked. Based on the platform chosen, the system consults a table in the database that indicates the space available for copy. Lengthy copy is then checked in the same manner as lengthy titles. If the space required for display of the title or copy exceeds the available space, the count is incremented and displayed and the platform, date, start time, station identification and lengthy title or copy are written to the appropriate verification report.

Editorial Errors

The above options check for fields that are completely missing data and fields that include data that exceeds the designated space in which it must fit. They do not, however, detect errors in the data itself. The editorial errors option supplements these options by checking for particular errors in the data fields. This option searches the listings for the more common types of errors found in the database. These include duplicated movie titles and years, cross references to other days of the programming week (for programs repeating each day), and the phrase "at press time" (often used where at the time the database is compiled certain information about a program is not yet known). For each such editorial error located, the count is incremented and displayed, and the date, time, station identification, and type of error are written to the output verification file.

The above editorial errors are only a few of the errors that may occur in the database. If additional types of errors are detected, these may also be checked by the editorial error option.

Inappropriate Language

The inappropriate language option is similar to the editorial errors option in that it checks the listings database for certain words and phrases that are not appropriate for an EPG. All such words and phrases are included in the language dictionary file. The database is then checked for any character strings matching these words and phrases. If any matches are found, the count is incremented by one and displayed and the date, start time, station identification, and inappropriate language found are written to the output file. The inappropriate language utility may be configured to check each database field containing textual data. Alternatively, only certain text fields may be designated for checking against the inappropriate language file.

Other Verification Options

Operation of the other verification options is similar to that of the options enumerated above. Missing program type, slot time, run time, program origin, PPV price and PPV promotional copy may be implemented in the same manner as the other missing field options. The PPV event on a non-PPV station and non-PPV event on a PPV station options are implemented by comparing the program_type and station_type fields for a program.

System Implementation

It will be recognized by those of skill in the art that the system may be implemented on any of a number of digital computers. In one embodiment, a 486 based personal computer system may be used. Alternatively, due to the large amount of data to be processed, a more powerful workstation computer may be used. A mass storage device, such as an optical disc, hard drive, or magnetic tape is used to store the database. The data verification utility may be resident on the computer which includes a display device and keyboard for entry of user commands. In one embodiment, the utility is implemented in a Microsoft Windows environment for maximum user friendliness. <figref idref="f0004">Fig. 4</figref>. shows a verification set-up screen for selecting the various verification options. In the top portion of the screen 10, the user selects whether to run verification on a group of cable systems, a single cable system, or a single head end. Also in the top portion of screen 10, the user selects the starting and ending times on which the data verification is run. In the lower portion of the screen 20, the various verification options are selected. Alternatively, all tests may be selected using a single button. After verification is run, the user is presented with correction menu 30 shown in <figref idref="f0005">Fig. 5</figref>. The correction menu permits the user to correct the errors by type of error. Upon selecting an error type for correction, the user is presented with the correction editor screen shown in <figref idref="f0006">Fig. 6</figref>. The correction editor screen displays the values of the different fields for the program listing containing an error so that the user may make the appropriate changes.

Once the data is processed by the data verification utility and the additions, changes, and edits are made to the listings database, the data for a particular cable system is extracted and prepared for transmission to the cable system. At this stage, the data corresponding to a particular channel map is extracted from the database and converted to ASCII format or a binary data format readable by the cable system. The data file may be transmitted to the cable system by any of a number of means such as by satellite, telephone line, portable storage medium, or broadcast.

In an alternate embodiment, the data verification utility may be resident at each of the cable system head-ends. In this manner, the cable system's individual data file is extracted from the program listings database and transmitted to the cable system. The various checking options associated with the utility may then be run at the cable system head end prior to transmission of the EPG data to individual viewers. Thus, only the data for stations carried by the particular cable system is checked. The advantage of this arrangement is that it provides for listings editing capabilities at each cable system so that errors not detected by the EPG provider may be corrected and last minute changes reflected in the data provided to the viewers.

The code for a particular computer program to implement the invention disclosed herein will be readily apparent to those skilled in the art of video system programming and graphic display based on the description contained herein and associated figures. It will also be appreciated by those skilled in the art that there can be departure from the specific embodiment of the invention described herein without departing from the true scope of the claims appended hereto.