February 15, 2024 - Updates to Field Definitions

ULS updated the Public Access Application documentation definitions and SQL to reflect the two new records EC and IF to reflect ECIP.

December 22, 2022 - Updates to Field Definitions

ULS updated the Public Access Application documentation definitions and SQL to better reflect the joins between the data files MP, MC and MF records.

MC position 6 was updated to Partition Area Id
MC position 7 was updated to Coordinate Sequence Id

MP position 10 was updated to Partition Area Id

* Note there are NO changes in file structure with this update.

August 18, 2022 - Additional PA Fields

ULS will be updating the Public Access Application file record format on 8/18/2022 to add two new positions to the PA record.

There will be two (2) additional fields added to the end of the existing PA record making the overall record length 24 fields. A value for the new fields will only be present for short-term temp-fixed Registered Link (RL) purpose applications for Radio Service Codes CT, CF, MG, and MW. These fields will be null for all other purposes and RSCs.

PA23 – New “Link Start Date” field.

PA24 – New “Link End Date” field.

April 19, 2022 – Updated CD and TA Records for Auction 110 603/608 filings

ULS implemented changes to the public access files to support changes to the CD and TA records for Auction 110 603/608 filings. The changes are listed below.

Additional positions to be added to the existing record definition CD:

CD11 - Aggregate Gross Revenue- Designated Entity – 3 year
CD12 - Aggregate Gross Revenue- Designated Entity – 5 year

Additional positions to be added to the existing record definition TA. The valid values are "Y" or null:

TA55 – Answer to the “Spectrum Aggregation Limit Certification(s)” for the PL certification 603/608
TA56 - Answer to the “Spectrum Aggregation Limit Certification(s)” for the PK certification 603/608

July 07, 2021 - Transaction Files URL Source Changing

On Wednesday July 07 2021, the daily and weekly public access files URLs for the data downloads located on the Daily & Weekly Transaction Files web page
https://www.fcc.gov/uls/transactions/daily-weekly  will be updated to a new source location.

This new host source location for the linked files will become https://data.fcc.gov/download/

 

Daily Updated Source URL Example:

All of the Daily file URLs will be updating to a similar URL source. For example, the Daily Tuesday Amateur Radio Service will be updating to
https://data.fcc.gov/download/pub/uls/daily/a_am_tue.zip

 

Weekly Updated Source URL Example:

All of the Weekly file URLs will be updating to a similar URL source. For example, the Weekly Private Land Mobile will be updating to
https://data.fcc.gov/download/pub/uls/complete/a_LMpriv.zip

May 27, 2021 - Updated HD Record for 900 MHz Filings

ULS implemented changes to the public access files to support changes to the HD record for 900 MHz filings. The changes are listed below.

Additional positions to be added to the existing record definition HD. The valid values are "Y" or null:

HD56 - 900 MHz Eligibility Certification
HD57 - 900 MHz Transition Plan Certification
HD58 - 900 MHz Return Spectrum Certification
HD59 - 900 MHz Payment Certification

December 22, 2020 - Additional positions added to Entity record type

ULS implemented changes to the public access files to support changes to the EN record for Auction 107. The changes are listed below.

Reference the field definitions and the SQL table definitions documents for the latest changes (updated 12/22/2020).

Additional positions to be added to existing record definition EN:

PUBACC_EN
position 28 lic_category_code char (1)
position 29 linked_license_id numeric (9,0)
position 30 linked_callsign char (10)

October 1, 2020 – Additional positions added to Header, Application Detail, Buildout, Buildout Frequency, and Buildout Location record types

ULS implemented changes to the public access files to support changes to the HD, AD, BO, BF, and BL records for new Renewal Reform requirements. The changes are listed below.

Reference the fields definitions and the SQL table definitions documents for the latest changes (updated 10/01/2020).

Additional positions to be added to existing record definitions

PUBACC_HD
position 52 additional_cert_choice            char(1)
position 53 additional_cert_answer           char(1)
position 54 discontinuation_ind                char(1)
position 55 regulatory_compliance_ind     char(1)

PUBACC_AD
position 31 use_of_service            char(1)

PUBACC_BO
position 9 discontinuance_date     char(10)

PUBACC_BF
position 13 discontinuance_date    char(10)

PUBACC_BL
position 10 discontinuance_date    char(10)

August 19, 2019 - Updates to Header and Market Partition record types

The ULS Public Access file structure for record types Header [HD] and Market Partition [MP] were updated Monday, August 19, 2019.

This update adds Whitespace Indicator as a new element in both record types. [HD] now has 51 positions and [MP] now has 15 positions.

Please reference the ULS Field Definitions and Public Access Database Definitions SQL on the documentation page.

August 16, 2018 - Updates to FREQUENCY and ADDITIONAL FREQUENCY record types

The ULS Public Access file structure for record types FREQUENCY [FR] and ADDITIONAL FREQUENCY INFORMATION [F2] was updated Thursday, August 16, 2018.

This update moves the data element Date First Used from the ADDITIONAL FREQUENCY INFORMATION [F2] record type to a new position within the FREQUENCY [FR] record type for both application and license data sets.

Please reference the fields definitions (PDF) and SQL table definitions (TXT) documents for the latest changes. See the summary of changes below.

Note:
The Date First Used data element references the Buildout First Use available under the Frequencies within ULS.


ADDITIONAL FREQUENCY INFORMATION [F2]

The total number of positions within the record decreased from 19 to 18.

*** Removed ***
Position 16 Date First Used mm/dd/yyyy

*** New Position Order ***
Position 16 Status Code char(1)
Position 17 Status Date mm/dd/yyyy
Position 18 Protocol Restricted or Unrestricted char(1)


FREQUENCY [FR]
The total number of positions within the record increased from 29 to 30.

*** Position Added ***
Position 30 Date First Used mm/dd/yyyy

March 8, 2018 - Additional positions added

ULS implemented changes to the public access files to support changes to the AN, UA, MK records and add a new ST record. The changes are listed below.

Reference the fields definitions and the SQL table definitions documents for the latest changes (updated 3/1/18).

Additional positions to be added to existing record definitions

PUBACC_AN

position 37 psd_nonpsd_methodology varchar(10)
position 38 maximum_erp numeric(15,3)

PUBACC_UA

position 11 claiming_unserved_area char(1)

PUBACC_MK

position 21 bidding_credit_type char(1)
position 22 claiming_unserved_area char(1)

*** NEW record definition to be created ***

PUBACC_ST

position 1 record_type = 'ST'
position 2 unique_system_identifier numeric(9 0)
position 3 uls_file_number char(14)
position 4 ebf_number = NULL
position 5 call_sign = NULL
position 6 sector_action_performed char(1)
position 7 sector_number int      
position 8 psd_nonpsd_methodology varchar(10)
position 9 maximum_erp numeric(15 3)
position 10 psd_attachment char(1)      
position 11 location_number int      
position 12 location_name varchar(20)      
position 13 status_code char(1)
position 14 status_date datetime

Updated:
Thursday, December 22, 2022