|
CDBS Historic Application Search | |
REC> CDBS Historic Search | site map |
This is the Help for the REC Networks CDBS Historic Public Access Site. The CDBS database contained data for AM, FM, TV, LPTV, and DTV stations, and Broadcast, Cable and MVPD EEO filings. This help file provides information about obtaining data from the CDBS database via the World Wide Web.
The major topics in the help file are:
The FCC Media Bureau is responsible for licensing broadcast services in the Unites States. The licensing information for broadcast radio (AM and FM) and television (TV, LPTV, and DTV) is contained in a database management system named CDBS (for Consolidated Database System). This system contains the broadcast applications that were electronically filed to the FCC. It also contains migrated data from applications that were submitted to the FCC on paper that had been stored in previous MB database systems (such as BAPS and MM engineering).
The Media Bureau is also responsible for collecting EEO (Equal Employment Opportunity) information from Broadcast stations and from Cable and MVPD (Multichannel Video Programming Distributor) employment units. The CDBS system contains data migrated from legacy MB EEO databases along with data from recent electronically submitted EEO filings.
These web pages provide the public with the following capabilities for accessing the CDBS database:
The top-level page contains hypertext links to the web pages for the available functions.
The functions all start with a web page that gives a user the ability to input values with which to search the database. Pressing a button will access the CDBS database and then create a new web page that contains a list of matching results. Each match in the list includes a hypertext link that can create a new web page containing detailed information for the match.
The functions can search for station information, application information, or EEO filing information. Often, the general public would like to learn more about the characteristics of stations in an area. In this case, the Station Search would be used. Another type of user is a station itself who would like to retrieve information about a submitted application by using the Application Search. The functions are accessible from the top-level web page by clicking on the appropriate link.
Operation of the three kinds of searches all follow a similar sequence of steps, as follows:
The search web pages contain areas from which values can be specified that are used to search (query) the database. These search screens are implemented using HTML (HyperText Markup Language) 2.0 constructs. Data values are input using an HTML FORM with field types of TEXT, CHECKBOX, and SELECT. If these constructs are unfamiliar to you, you may want to learn more about HTML and WWW browsers before filling out the search screens. These are used in the following ways:
The fields on the search screen are used to search the database. You can use the standard SQL (database Structured Query Language) wildcard characters in fields that contain string values when the exact string value is not known. The percent (%) character can be used to signify a string of zero or more characters. For example, use a Call Sign of WAB% to query for stations with Call Signs that begin with the characters "WAB". The underscore (_) character can be used to signify any single character. Consult an SQL reference for more information. The wildcard characters should not be used in the State field (which requires the appropriate two-character state abbreviation) or the numeric valued fields.
All of the criteria are combined to search the database for matches of ALL of the values. Empty fields are ignored when constructing the criteria.
To clear out the values you have entered, press the "Clear Values" button.
Hypertext links are available at certain places on the search screens (for example, field labels). By clicking on a link, the Help file is opened in your browser window. The window is positioned at the appropriate location in the documentation that covers the topic. To resume filling out the search screen, use your browser's Back command.
You cannot submit a database search without any criteria values.
If a search retrieves an excessive amount of data (currently, more than 50 matching stations or applications/filings), you will get a Warning message. This is to prevent accidental searches from unnecessarily overloading the server. It also warns the user that a particular query may take a while to retrieve the data and display it in the browser. If desired, the search can be continued by pressing a button on the Warning screen. Otherwise, the search can be refined by using the browser's Back button. For more information, see the text of the Warning message.
Sometimes, when the FCC web server or database server has problems,
you may see unusual server or database error messages displayed in the
browser window. We have attempted to prevent these situations and
produce understandable messages, however, please try the operation again,
and contact us if this continues to occur.
Please include the operation that was being attempted, the values of
all of the fields, and the date and time that the problem occurred.
Search Fields
The following information defines the fields that appear on the search screens.
WCAU
or WGBS-TV
.
Values are converted to upper case for searches since this field is
stored in upper case in the database. You can use wildcard characters
(such as %).
NOTE: If you enter a DTV Replacement Translator Call Sign, the search is done as if you had entered the Call Sign or Facility ID of the parent full-service station.
This allows the user to search the database for information about a particular station by entering search criteria in fields. Pressing the "Submit Search" button will search the database and return results to the browser window. From the list of matching stations, the user can click on a hypertext link to retrieve detailed information about a selected station.
The Station Search Details screen contains basic facility information such as current call sign, facility ID number, facility type, and status. It also contains embedded links to provide more detailed information about:
The Details screen includes Virtual Channel, the number displayed on a television set (or DTV converter box) for a DTV station. For most stations, it is the same as their old pre-DTV Transition analog channel number in order to make them easier to find and tune to. When a station is multicasting, the additional channels are displayed as extra numbers following a dash (-) or dot (.) after the virtual channel number (e.g. 26-1, 26-2, 26-3). Note that this may not be the same as its channel on a subscription service like cable or satellite television. Also, it may not be the same as the actual channel that the station is transmitting on (which is the "Channel"). The Correspondence Folder contains CDBS Informal Filings and Imported Letters. It is also available from the Application Search Details screen.
Informal filings are anything that is typically submitted on paper to the Media Bureau and not on an FCC Form. Examples of common Informal filings include Consummation Notices, Address Change Notifications, Requests for Special Temporary Authority, Petitions and Objections. As the different types of Informal filings are released for filing using CDBS, the Bureau will announce their availability. These filings are associated with a facility and/or an application and thus can be retrieved using 'View Correspondence Folder' link. They typically do not contain a File Number but are instead identified by date filed and informal filing type. Clicking on the 'Click to View Filing' link will display the informal filing in a new browser window.
Imported Letters are (PDF format) files that have been associated with a facility and/or application by FCC Media Bureau staff members.
This is a simplified search page that provides an easy way to search the CDBS database for information about Digital (and Analog) Television stations. It provides information about whether stations are operating, and if so, whether they are currently broadcasting analog or digital signals or both, and on what channels.
This search page operates a little differently from the other pages (for example, the asterisk '*' is used as the wildcard character instead of the percent '%'. See its separate help file, at Frequently Asked Questions about CDBS DTV Station Search.
This allows the user to search the database for information about a particular application by entering search criteria in fields. Pressing the "Submit Search" button will search the database and return results to the browser window. From the list of matching applications, the user can click on a hypertext link to retrieve detailed information about a selected application.
Note: CDBS applications that represent engineering proposals for permits that were filed during an auction initial filing window (known as "short forms") are omitted from the normal application search by default. This is to prevent hundreds/thousands of auction short forms from making it hard to find other data. When searching for this kind of permit, you can explicitly specify "Short Form" as the Form Number. Alternatively, you can check the "Include Short Forms" checkbox to also allow them in normal searches so that an application search will include both short forms and other types of applications.
You can also search for applications that are members of an ALTC (or Renewal Translator) group. Often, sales forms (Assignment of License and Transfer of Control) include more than one facility to assign or transfer. The normal application search will not retrieve these stations. Instead, the second part of the Application Search web page provides the ability to search for these members of an ALTC application. This Group Search is independent of the first search, that is, none of the values in the upper fields are used when the Submit Group Search button is pressed. The resulting application list is slightly different in that it shows the File Number of the parent/main application of the group, which is used when retrieving information about the application instead of the member File Number.
The Application Search Results page gives you a table with a summary of applications that matched the criteria. The last column of each row contains one or two hypertext links. There will always be a link named "Info" that opens a new web page containing a table of useful information. This page is intended to provide information about an application's status, rather than complete technical data. If the application itself can be retrieved and displayed in a browser, a link named "Application" will also be available to retrieve and display the entire application. If the "Application" link is dimmed (not active), this feature is not available for that application. The "Paper/Elect" column indicates whether the application was electronically filed (E) or submitted on paper (P) to the FCC.
Application LinkIf the Application link is active, it will open a new browser window with the filed form. (Note: It could take a minute or two for the entire form to be retrieved and displayed.) You can print the form by using your browser's Print command. When finished with this view of the form, close the window and return to the original browser window containing the Search Results screen.
Note that the form will closely resemble the version of the form implemented by the CDBS Electronic Filing System, but may differ a little in format from the paper version. The new window combines all of the form sections together. Exhibits are displayed at the end of the form ordered by exhibit number. The exhibits may contain two parts. If there is a text exhibit, it will be displayed first. Then, if needed, a menu of links to the attached files will be displayed.
All of the attachments are in Adobe PDF (Portable Document Format), however, they have not been included for display in the new browser window. Instead, to view/print an attachment, click on the attachment link. Depending on your browser settings, a plug-in/helper application (for PDF, such as Adobe Acrobat Reader) may open or your browser may ask if you want to open the file, how to open it, or where to save it. If desired, each attachment can be retrieved and printed using the link and its associated program.
Since some of the forms are large, some users may experience system problems trying to retrieve a form. It may take a minute or two for the entire application to be retrieved and displayed. If the complete form does not display or is apparently missing data, you may not have sufficient system resources. Try to solve the problem by closing unnecessary windows on your computer and/or restarting your browser and then pressing the Application link again. Also, in some cases, a form that is displayed accurately in the browser window could contain lines that are overlaid on top of each other in the printed hardcopy. This sometimes happens using Microsoft Internet Explorer (such as version 5.5). To work around this problem, use the Save As command to save the web page to a file (pick a name that you will remember) on your hard drive (or a network drive). Then, use the Open command (under the File menu) and then the Browse button to specify the file that you just saved. The file that opens will look the same as that which was generated dynamically, but it should print without the overlaid lines. (Another alternative would be to use Netscape Navigator which does not have the overlaid text problem.)
Application DetailsWhen viewing the Details web page for an application, there may be other links that provide additional information.
You can view the authorization for a granted application. If an authorization is available, the words "View Authorization" will be highlighted as a link. To view/retrieve the authorization, click on the link, read the information on the displayed web page, wait a minute for the authorization to be retrieved from the database and prepared for viewing, and then click on the "Get Authorization" link in that web page. The authorization will be in Adobe PDF (Portable Document Format) which can be viewed using a tool/plug-in such as the free Adobe Acrobat Reader. The Acrobat Reader can be run inside a browser (as a plug-in or helper application) or as a standalone tool if you have saved the authorization to your local computer. If the authorization does not appear after a minute, the computer doing the processing may be down. Please try again (click on the "Get Authorization" link again) after waiting another couple of minutes. If the file still does not appear, please try again later.
You can view selected engineering information about an application using the "View Engineering Data" link. Note that there may be some cases where the detailed data is not available. Other ways to view the data are by displaying the entire application and by downloading the engineering data files.
You can view the legal actions associated with an application (such as petitions to deny and petitions for reconsideration) by clicking on the View Legal Actions link from the Application Details web page. The resulting web page contains two sections. The first section contains comments made by the legal staff during the processing of the application. The second part contains information about specific legal actions associated with the application (that were entered into the system by the staff).
You can quickly view the information on an application for the question about parties to the application and non-party equity owners. (For example, this is Question 2 in the Legal section of the FCC Form 301.) Click on the View Positional Interest Info link from the Application Details web page. The resulting web page contains a table with the information from the application. Note that this information was not collected for older applications (prior to Electronic Filing).
You can view the informal filings associated with an application.
See the Correspondence Folder paragraph
under the Station Search Details section.
EEO Search
This allows the user to search the database for information about a particular EEO application/filing by entering search criteria in fields. The web page is divided into separate search screens for Broadcast searches and Cable/MVPD Searches. These search screens are independent (that is, the system only uses the search criteria that are filled in for the section containing the button that is pressed).
The first part of the web page allows a search for filings by Broadcast (e.g. TV, AM, FM, etc.) stations. Some EEO forms allow a single filing to apply to more than one station. This broadcast search allows you to search using any of them. Pressing the "Submit Search" button will search the database and return results to the browser window.
The second part of the web page allows a search for filings by Cable/MVPD employment units. Pressing the "Submit Cable/MVPD Search" button will search the database and return results to the browser window.
From the list of matching applications/filings, the user can click on a hypertext link to retrieve detailed information about a selected application. The last column of the list contains one or two hypertext links. There will always be a link named "Info" that opens a new web page containing a table of useful information. This page is intended to provide basic information about a filing (such as when it was filed and entered into the database), rather than the complete data on the form. If the application/filing itself can be retrieved and displayed in a browser, a link named "Application" will also be available to open a new window containing the entire application.
This allows the user to search the database for information about a particular Ownership Report by entering search criteria. Note that the Ownership Reports (FCC Form 323 and 323-E) allow a single application form to contain information that applies to more than one station. This search allows you to search using any of them (that is, any station specified in the list of stations as well as the main station identified at the top of the form.) Pressing the "Submit Search" button will search the database and return results to the browser window.
The results show the matching stations from Ownership Reports with one line being displayed for each station from the report. For example, if the user searches using the ARN of an Ownership Report for which there were 5 stations specified on the report (including the main station at the top of the form), there will be 5 rows in the search results. Each station will have its own ARN and each line will also show the ARN of the main station.
The user can click on a hypertext link to retrieve detailed information about an application. The last column of each results line contains two hypertext links. The first is named "Info" that opens a new web page containing a table of useful information. This page is intended to provide basic information about a filing (such as when it was filed and entered into the database), rather than the complete data on the form. If the application itself can be retrieved and displayed in a browser, a link named "Application" will also be available to open a new window containing the entire application.
This allows the user to search the database for information about a particular antenna that was specified on radio or television applications. Enter search criteria in the desired fields. Press the "Submit Search" button to search the database and return results to the browser window. From the list of matching antennas, the user can click on a hypertext link to retrieve detailed information about the relative field values (if available).
A set of files is available over the internet that contain publicly released CDBS data. The files can be found at the following location:
FCC Home | | | REC Home Page | | | CDBS History Page | | | Radio History Project | | | FCCdata.org | | | FCC.today | | | LPFM.us |
REC Networks Riverton, MD |
|
|