| Query Name | Description |
| LIC_10yr_BO_met_between | Finds records in the PCS_LICENSE table where _10yr_Buildout_Date is between the dates provided in the query |
| LIC_10yr_BO_not_met_and_Deadline_between | Returns records from the PCS_LICENSE table where the 10-year buildout deadline was not met and where _10yr_Buildout_Date is between the dates provided in the query |
| LIC_5yr_BO_met_between | Finds records in the PCS_LICENSE table where _5yr_Buildout_Date is between the dates specified in the query |
| LIC_5yr_BO_NOT_Met_and Deadline_after | Returns records from the PCS_LICENSE table where the 5-year buildout date was not met and where _5yr_Buildout_Deadline is after the date provided in the query |
| LIC_5yr_BO_NOT_Met_and_Deadline_before | Finds records in the PCS_LICENSE table where the 5-year buildout period was not met and where _5yr_Buildout_Deadline is before the date specified in the query |
| LIC_5yr_BO_NOT_Met_and_Deadline_between | Returns records from the PCS_LICENSE table where the 5-year buildout period was not met and where _5yr_Buildout_Deadline is between the dates provided in the query |
| LIC_For_DBA | Finds all records in the PCS_LICENSE table where the DBA name is similar to the name provided |
| LIC_For_DBA_FR | Returns records from the PCS_LICENSE table where the DBA name is similar to the name specified in the query and appends frequency information from the PCS_FREQUENCY table |
| MarketCode | Creates a list of MTAs and BTAs and their associated market codes from the PCS_LICENSE table |
| PCS_FREQUENCY_BandwidthTotal_with_LIC_info |
Joins information from the PCS_FREQUENCY table to the PCS_LICENSE table and calculates the total bandwidth for each record using the following formula:
Bandwidth is displayed in the TotalBandWidth column. |