DBA data
Retrieving PCS data selects all instances of the DBA name from the PCS_DBA table. The selection is named [DBA name]_PCS_DBA, where [DBA name] is the carrier name that corresponds to the DBA name specified in the query.
Retrieving cellular data selects all instances of the DBA name from the CELLULAR_DBA table. The selection is named [DBA name]_CELL_DBA, where [DBA name] is the carrier name that corresponds to the DBA name specified in the query.
License data
Retrieving PCS data selects all licenses from the PCS_LICENSE table that have the DBA name specified in the query. The selection is named [DBA name]_PCS_LIC, where [DBA name] is the carrier name that corresponding to the DBA name entered in the query.
Retrieving cellular data selects all license from the CELLULAR_LICENSE table that have the DBA name specified in the query. Results are joined with the CMA table and the resulting selection is named [DBA name]_CELL_LIC, where [DBA name] is the carrier name corresponding to the DBA name entered in the query. The geographic area for each license is represented by the entire CMA.
Frequency data
Available only when retrieving PCS data. The PCS_FREQUENCY table is joined to the PCS_LICENSE table and all licenses that have the specified DBA name are selected. The TotalBandWidth column is created using the following formula:
TotalBandWidth = (LowerBandMax – LowerBandMin) + (UpperBandMax –
UpperBandMin)
The selection is named [DBA name]_PCS_FREQ, where [DBA name] is the carrier name associated with the DBA name specified in the query.