License data
When a BTA or MTA market code is entered, all licenses with that market code are selected from the PCS_LICENSE table.
If a channel block is supplied, the selection is named [Market code]_[Channel block]_PCS_LIC, where [Market code] is the BTA or MTA code and [Channel block] is the channel block specified in the query.
If a channel code is not specified, the selection is named [Market code]_PCS_LIC.
When a CMA market code is entered, all licenses with that market code are selected from the CELLULAR_LICENSE table. If a channel block is supplied, the selection is named [Market code]_[Channel block]_CELL_LIC, where [Market code] is the CMA code and [Channel block] is the channel block specified in the query.
If no channel block is specified, the selection is named [Market code]_CELL_LIC.
All licenses with a specified market code block are selected from the PCS_FREQUENCY table. The result is joined to the PCS_LICENSE table so that licensee and DBA information is available.
If a channel block was entered, the selection is named [Market code]_[Channel block]_PCS_FREQ, where [Market code] is the BTA or MTA code and [Channel block] is the channel block specified in the query.
If a channel block was not specified, the selection is named [Market code]_PCS_FREQ.
Frequency data
Frequency data is available only when a PCS market code (BTA or MTA) is specified in the query.