document style templatedata.fcc.gov/download/license-view/fcc-license-view-data... · web...

i

FCC License ViewData Dictionary

Version 1.0

September 9, 2010

FCC License View Data Dictionary Table of Contents

Table of Contents

1. ABOUT THIS DATA DICTIONARY...................................................................................1

2. COLUMN DEFINITIONS......................................................................................................22.1. ant_make varchar2(25)..................................................................................................22.2. ant_model varchar2(25).................................................................................................22.3. ant_seq_id number.........................................................................................................22.4. ant_type_code varchar2(1).............................................................................................22.5. ant_type_desc varchar2(50)...........................................................................................22.6. antenna_id number(10)..................................................................................................22.7. asr_num varchar2(15)....................................................................................................22.8. azimuth number(4,1)......................................................................................................32.9. beamwidth number(4,1).................................................................................................32.10. callsign char(10).............................................................................................................32.11. cancellation_date date....................................................................................................32.12. channel_block varchar2(6).............................................................................................32.13. common_name varchar2(200).......................................................................................32.14. contact_address1 varchar2(60)......................................................................................32.15. contact_address2 varchar2(60)......................................................................................42.16. contact_city varchar2(20)..............................................................................................42.17. contact_company varchar2(100)....................................................................................42.18. contact_country varchar2(30)........................................................................................42.19. contact_email varchar2(100).........................................................................................42.20. contact_fax varchar2(30)...............................................................................................42.21. contact_name varchar2(50)............................................................................................42.22. contact_phone varchar2(30)...........................................................................................42.23. contact_state varchar2(2)...............................................................................................42.24. contact_title varchar2(25)..............................................................................................52.25. contact_zip varchar2(9).................................................................................................52.26. emission_code char(10).................................................................................................52.27. emission_id number(10)................................................................................................52.28. emission_seq_id number................................................................................................52.29. entity_type_code varchar2(10)......................................................................................52.30. entity_type_desc varchar2(100).....................................................................................62.31. expired_date date...........................................................................................................6

ii


2.32. facility_id number..........................................................................................................62.33. freq_class_station_code char(4).....................................................................................72.34. freq_class_station_desc varchar2(50)............................................................................72.35. freq_seq_id number.......................................................................................................72.36. frequency_assigned number(16,8).................................................................................72.37. frequency_id number(10)...............................................................................................72.38. frequency_upper_band number(16,8)............................................................................72.39. frn varchar2(200)..........................................................................................................72.40. grant_date date...............................................................................................................72.41. hgt_structure number(7,1)..............................................................................................82.42. last_action_date date......................................................................................................82.43. lic_address varchar2(60)................................................................................................82.44. lic_attention_line varchar2(35)......................................................................................82.45. lic_city varchar2(40)......................................................................................................82.46. lic_name varchar2 (255)................................................................................................82.47. lic_state char(2)..............................................................................................................82.48. lic_status_code char.......................................................................................................82.49. lic_status_code_desc varchar2(40)................................................................................92.50. lic_zip_code char(9).......................................................................................................92.51. license_id number(10)...................................................................................................92.52. loc_city varcahar2(20)...................................................................................................92.53. loc_id number(10)..........................................................................................................92.54. loc_county_code char(5)................................................................................................92.55. loc_county_name varchar2(60)...................................................................................102.56. loc_lat_deg number.....................................................................................................102.57. loc_lat_dir char............................................................................................................102.58. loc_lat_min number.....................................................................................................102.59. loc_lat_sec number(3,1)...............................................................................................102.60. loc_long_deg number...................................................................................................102.61. loc_long_dir char.........................................................................................................102.62. loc_long_min number..................................................................................................112.63. loc_long_sec number(3,1)............................................................................................112.64. loc_radius_op number(5,1)..........................................................................................112.65. loc_seq_id number.......................................................................................................112.66. loc_state char(2)...........................................................................................................112.67. market_code varchar2(10)...........................................................................................11

iii


2.68. market_desc varchar2(50)............................................................................................122.69. orig_id number(9)........................................................................................................122.70. polarization_code varchar2(15)...................................................................................122.71. power_erp number(15,3)..............................................................................................132.72. power_output number(15,3)........................................................................................132.73. radio_service_code char(2)..........................................................................................132.74. radio_service_desc char(255)......................................................................................132.75. rollup_category_desc varchar2(100)...........................................................................132.76. rollup_entity_code varchar2(5)....................................................................................162.77. rollup_entity_ desc varchar2(100)...............................................................................162.78. rollup_status_code varchar2(50)..................................................................................172.79. rollup_status_desc varchar2(100)................................................................................172.80. source_system varchar2(10).......................................................................................172.81. tolerance number(6,5)..................................................................................................182.82. unit_of_measure varchar2(5).......................................................................................18

iv

FCC License View Data Dictionary About This Data Dictionary

1. About This Data Dictionary

FCC License View is a single portal for information on the management of licenses. The data in License View can be used to conduct research and analysis on licenses in the FCC’s databases.

Typically, to be eligible for inclusion in License View, data elements had to exist in at least three of the following FCC Licensing Systems:

CDBS (Consolidated Database System)

COALS (Cable Operations and Licensing System).

ELS (Experimental Licensing System)

IBFS (International Bureau Filing System)

ULS (Universal Licensing System)

Exceptions are data elements market_code and market_desc, which only exist in ULS.

The data in License View is available for download. This data dictionary provides the definitions for the data elements included in the file. It also includes information for formatting each data element and specifies its allowable values.

1

FCC License View Data Dictionary Column Definitions

2. Column Definitions

2.1. ant_make varchar2(25)

This is the make of an antenna.

2.2. ant_model varchar2(25)

This is the model number of an antenna.

2.3. ant_seq_id number

This is the number that identifies a particular antenna in a group of antennas.

2.4. ant_type_code varchar2(1)

This code specifies the general classification of an antenna's use. Examples of valid values are H - Hub; P - Passive Repeater; R - Final Receiver; T - Transmitter.

2.5. ant_type_desc varchar2(50)

This text specifies the meaning of a given antenna type code.

2.6. antenna_id number(10)

This number is the unique system-generated identifier for each antenna record.

2.7. asr_num varchar2(15)

This number is the unique ASRN (Antenna Site Registration Number) assigned to a registered tower.

2


2.8. azimuth number(4,1)

This count measures the direction in which an antenna is pointing, relative to true north (0 degrees). The azimuth is expressed in degrees, is measured in a clockwise direction with respect to true north, and the value must be a positive number between 0.0 and 359.9.

2.9. beamwidth number(4,1)

This count measures the angle, measured in a horizontal plane, between the directions at which the intensity of an electromagnetic beam is one-half its maximum value. The antenna's beamwidth is expressed in degrees and is a positive number between 0 and 359.9.

2.10. callsign char(10)

The call sign identifies a specific authorization. A call sign consists of a combination of up to ten letters and numbers.

2.11. cancellation_date date

This is the date on which the authorization was cancelled by the licensee or the license was terminated by the Commission. The value in the lic_status_code column identifies which action was taken.

2.12. channel_block varchar2(6)

This is the frequency(ies) associated with the authorization.

2.13. common_name varchar2(200)

This is an entity that either wholly owns or has majority interest in the license; is the general partner of the limited partnership or manager of an LLC that holds the license; or is the name under which the service being provided via the license is marketed to the public. Currently, less than 10% of all licenses have a confirmed association with a common name.

2.14. contact_address1 varchar2(60)

This is the first line of the mailing address of a contact.

3


2.15. contact_address2 varchar2(60)

This is the second line of the mailing address of a contact.

2.16. contact_city varchar2(20)

This is the city in which the contact is located.

2.17. contact_company varchar2(100)

This is the company name of the contact.

2.18. contact_country varchar2(30)

This is the country of a contact.

2.19. contact_email varchar2(100)

This is the email address of a contact.

2.20. contact_fax varchar2(30)

This is the fax number of a contact.

2.21. contact_name varchar2(50)

This is the name of the individual who is serving as contact.

2.22. contact_phone varchar2(30)

This is the telephone number of a contact.

2.23. contact_state varchar2(2)

This uniquely identifies a specific state, possession, or territory within the United States of America of a contact.

4


2.24. contact_title varchar2(25)

This is the title of a contact.

2.25. contact_zip varchar2(9)

This is the Zip code of the contact. This can be a 5-character Zip or a 9-character extended Zip (without the hyphen.)

2.26. emission_code char(10)

This code represents the electromagnetic energy radiated from an antenna.

2.27. emission_id number(10)

This number is the unique system-generated identifier for each emission record.

2.28. emission_seq_id number

This number identifies a particular emission in a group of emissions.

2.29. entity_type_code varchar2(10)

This code specifies the entity type of the license holder.

The following table shows the existing entity type code values and descriptions as well as the code values and descriptions used in FCC License View.

Source System Actual Code Value Actual Code Description New Code DescriptionCDBS C For-Profit Corporation Business

CDBS EPrivate Not-for-profit Educational institution Business

CDBS F A limited liability company (LLC/LC) BusinessCDBS I Individual IndividualCDBS L Limited Partnership BusinessCDBS N Not-for-profit Corporation BusinessCDBS O Other OtherCDBS P General Partnership BusinessCDBS S Sole proprietorship BusinessCDBS T Government GovernmentCOALS A Association BusinessCOALS C Corporation BusinessCOALS G Governmental Entity GovernmentCOALS I Individual Individual

5


Source System Actual Code Value Actual Code Description New Code DescriptionCOALS O Other OtherCOALS P Partnership BusinessCOALS T Attorney BusinessELS A Association BusinessELS C Corporation BusinessELS I Individual IndividualELS O Other OtherELS P Partnership BusinessIBFS APP Applicant OtherIBFS ASE Assignee OtherIBFS ASR Assignor OtherIBFS COR Corporation BusinessIBFS GOV Governmental Entity GovernmentIBFS IND Individual IndividualIBFS LIC Licensee OtherIBFS OTH Other OtherIBFS PAR Partnership BusinessIBFS UNA Unincorporated Association BusinessULS B Amateur Club IndividualULS C Corporation BusinessULS D General Partnership BusinessULS E Limited Partnership BusinessULS F Limited Liability Partnership BusinessULS G Governmental Entity GovernmentULS H Other OtherULS I Individual IndividualULS J Joint Venture BusinessULS L Limited Liability Company BusinessULS M Military Recreation IndividualULS O Consortium BusinessULS P Partnership BusinessULS R RACES IndividualULS T Trust BusinessULS U Unincorporated Association Business

2.30. entity_type_desc varchar2(100)

This text specifies the meaning of a given entity type code.

2.31. expired_date date

This date signifies the point in time when the authorization has or will expire.

2.32. facility_id number

This number is the FCC-assigned identifier that uniquely identifies a facility.

6


2.33. freq_class_station_code char(4)

This is the code designated for the station class associated with the frequency.

2.34. freq_class_station_desc varchar2(50)

This text is the full description of the station class associated with the frequency.

2.35. freq_seq_id number

This number identifies a particular frequency in a group of frequencies.

2.36. frequency_assigned number(16,8)

This number is a specific frequency associated with an authorization. This field will be “null” for market-based licenses.

2.37. frequency_id number(10)

This number is the unique system-generated identifier for each frequency record.

2.38. frequency_upper_band number(16,8)

This number defines the upper range of a frequency block (where the lower end of the block is in the frequency assigned column).

2.39. frn varchar2(200)

This number is a registration number assigned to the entity or individual that holds an authorization. "FRN" stands for FCC Registration Number and is assigned to the party through CORES (COmmission REgistration System).

2.40. grant_date date

This is the date when the FCC granted the authorization.

7


2.41. ground_elevation number(15,7)

This is the ground elevation of the antenna structure.

2.42. hgt_structure number(7,1)

This is the height of the antenna structure, in meters.

2.43. last_action_date date

This is the date this record was last updated.

2.44. lic_address varchar2(60)

This is the mailing address of the licensee.

2.45. lic_attention_line varchar2(35)

This is the attention line in the mailing address.

2.46. lic_city varchar2(40)

This is the city of the mailing address for the authorization.

2.47. lic_name varchar2 (255)

This is the name of the license holder.

2.48. lic_state char(2)

This is the state of the mailing address for the authorization.

2.49. lic_status_code char

This code describes the current status of the license.

The following table shows the existing license status codes and descriptions as well as the code values and descriptions used in FCC License View.

8


Current Codes (used in existing systems) Current Code Description Rolled up Code Rolled up Code DescriptionLICAN LICENSE CANCELLED C CanceledLICSL LICENSED AND SILENT A ActiveLICEN LICENSED A Active

Current (based on completed date) A ActiveClosed (based on completed date) C Canceled

EGrant Expired Due to New License or Expired E Expired

G Granted A ActiveA Active A ActiveD Deleted C CancelledN Not Active C CancelledC Cancelled C CancelledT Terminated T Terminated

2.50. lic_status_code_desc varchar2(40)

This text describes the license status code.

2.51. lic_zip_code char(9)

This is the Zip code of the mailing address for the authorization.

2.52. license_id number(10)

This number is the FCC-assigned identifier for a license.

2.53. loc_city varcahar2(20)

The name specifies the city in which the location is physically situated.

2.54. loc_id number(10)

This number is the unique system-generated identifier for each location or facility record.

2.55. loc_county_code char(5)

This number is the code for the county in which the location is physically situated. The county code correlates to a county description.

9


2.56. loc_county_name varchar2(60)

This text is the county in which the location is physically situated. The county name provides a description of the county code.

2.57. loc_lat_deg number

This number specifies the count of degrees north or south of the earth's equator. A degree of latitude represents approximately 69 miles. The latitude degree column is an integer, and the valid values are between 0 (equator) and 90 (north/south pole).

2.58. loc_lat_dir char

This indicator specifies whether the latitude is in the northern or southern hemisphere. Valid values are N for North and S for South.

2.59. loc_lat_min number

This number specifies the count of the subdivisions of a degree of latitude north or south of the earth's equator. The latitude minute column is a positive integer, and the valid values are between 0 and 59.

2.60. loc_lat_sec number(3,1)

This number specifies the count of the subdivisions of a minute of latitude north or south of the earth's equator. The latitude second column is a positive number, and the valid values are between 0.0 and 59.9.

2.61. loc_long_deg number

This number specifies the number of degrees east or west of the prime meridian. A degree of longitude represents approximately 69 miles. The longitude degree column is a positive integer and the valid values are between 0 (Greenwich, England) and 180 (International Date Line).

2.62. loc_long_dir char

The indicator specifies whether the longitude is east or west of the prime meridian in Greenwich, England. Valid values are W for West and E for East.

10


2.63. loc_long_min number

This number specifies the count of subdivisions of a degree of longitude east or west of the prime meridian. The longitude minute column is a positive integer and the valid values are between 0 and 59.

2.64. loc_long_sec number(3,1)

This number specifies the count of the subdivisions of a minute of longitude east or west of the prime meridian. The longitude second is a positive number and the valid values are between 0.0 and 59.9.

2.65. loc_radius_op number(5,1)

This number is the radius of operation in kilometers for mobile locations operating around a fixed centerpoint.

2.66. loc_seq_id number

This number identifies a particular location in a group of locations.

2.67. loc_state char(2)

This uniquely identifies a specific state, possession, or territory within the United States of America for a location.

2.68. market_code varchar2(10)

This code identifies the designated market and is defined by a geographical area.

Examples of valid values are:

BEA121

BTA479

MEA031

CMA277

11


2.69. market_desc varchar2(50)

This text is the geographical area authorized under the license.

2.70. orig_id number(9)

This number is the value of the unique system-generated identifier for an authorization in the originating system. Which identifier is used depends on which system the data is coming from, as follows:

CDBS: fac_id

COALS: license_id

ELS: license_id

IBFS: filing_key

ULS: license_id

2.71. polarization_code varchar2(15)

This code describes the orientation of the electric field as radiated by the antenna.

Examples of valid values are:

A – Elliptic, Left

B – Elliptic, Right

D – Rotating

E – Elliptical

F – 45 degrees

H--Horizontal

J – Linear

L – Left Hand Circular

M – Oblique Angled, Left

N – Oblique Angled, Right

O – Oblique Angled, Crossed

R – Right Hand Circular

S – Horizontal and Vertical

T – Right and Left Hand Circular

V – Vertical

X – Other

12


2.72. power_erp number(15,3)

This number specifies the effective radiated power or the product of the power supplied to the antenna and the antenna gain in a given direction relative to the isotropic antenna. Power output is measured in watts.

2.73. power_output number(15,3)

This number specifies the maximum radio frequency power output capability (peak or average) of a transmitter, under optimum conditions of adjustment and operations, as specified by the manufacturer.

2.74. radio_service_code char(2)

The 2-character radio service code uniquely designates a telecommunication service licensed within the United States. For example, the CF radio service covers applications in Common Carrier Fixed Point to Point Microwave in the Microwave service.

2.75. radio_service_desc char(255)

This code is a description of the 2-character radio_service_code.

2.76. rollup_category_desc varchar2(100)

This text is the high-level service category description that appears on the FCC License View web page.

The following table shows the categories and category descriptions, as well as the radio service codes under which the categories falls.

Category Radio Service Code DescriptionSafety of Life AA Aviation Auxiliary GroupBroadcast Support AB Aural Microwave BoosterSafety of Life AC AircraftSafety of Life AF Aeronautical and FixedBroadcast Support AI Aural Intercity RelayBroadcast AM AM StationPersonal Use AR Aviation RadionavigationBroadcast Support AS Aural Studio Transmitter LinkMobile/Fixed Broadband AW AWS, 1710-1755/2110-2155 MHz bandsFixed Wireless BA 1390-1392 MHz Band, Market AreaFixed Wireless BB 1392-1395 and 1432-1435 MHz Bands, Market AreaFixed Wireless BC 1670-1675 MHz Band, Market Area

13


Category Radio Service Code DescriptionSatellite Earth Station BES Blanket Earth StationMobile/Fixed Broadband BR Broadband Radio ServiceBroadcast CA Class A TVMobile/Fixed Broadband CA Commercial Air-ground RadiotelephonePaging and Messaging CB BETRSPaging and Messaging CD Paging and RadiotelephoneFixed Wireless CE Digital Electronic Message Service - Common CarrierFixed Wireless CF Common Carrier Fixed Point to Point MicrowaveMobile/Fixed Broadband CG General Aviation Air-ground RadiotelephoneMobile/Fixed Broadband CJ Commercial Aviation Air-Ground Radiotelephone (800 MHz band)Mobile/Fixed Broadband CL CellularSafety of Life CM Commercial OperatorPaging and Messaging CN PCS NarrowbandPaging and Messaging CO Offshore RadiotelephonePaging and Messaging CP Part 22 VHF/UHF Paging (excluding 931MHz)Paging and Messaging CR Rural RadiotelephoneBroadcast Support CT Local Television TransmissionMobile/Fixed Broadband CW PCS BroadbandMobile/Fixed Broadband CY 1910-1915/1990-1995 MHz Bands, Market AreaPaging and Messaging CZ Part 22 931 MHZ PagingBroadcast DC Digital Class A TVBroadcast DT Digital TVFixed Wireless DV Multichannel Video Distribution AND Data ServiceMobile/Fixed Broadband ED Educational Broadband ServiceSatellite Earth Station ESV Earth Stations on-board VesselsBroadcast FB FM BoosterSatellite Earth Station FES Fixed Earth StationBroadcast FL Low Power FMSatellite Earth Station FLE Fixed Land Earth StationBroadcast FM FM StationBroadcast FX FM TranslatorLand Mobile Radio GB Business, 806-821/851-866 MHz, ConventionalPaging and Messaging GC 929-931 MHz Band, AuctionedSafety of Life GE PubSafty/SpecEmer/PubSaftyNtlPlan,806-817/851-862MHz,ConvSafety of Life GF Public Safety Ntl Plan, 821-824/866-869 MHz, Conv.Land Mobile Radio GI Other Indust/Land Transp, 896-901/935-940 MHz, Conv.Land Mobile Radio GJ Business/Industrial/Land Trans, 809-824/854-869 MHz, Conv.Land Mobile Radio GM 800 MHz Conventional SMR (SMR, Site-specific)Land Mobile Radio GO Other Indust/Land Transp, 806-821/851-866 MHz, Conv.Safety of Life GP Public Safety/Spec Emerg, 806-821/851-866 MHz, Conv.Land Mobile Radio GR SMR, 896-901/935-940 MHz, ConventionalPaging and Messaging GS Private Carrier Paging, 929-930 MHzLand Mobile Radio GU Business, 896-901/935-940 MHz, ConventionalLand Mobile Radio GX SMR, 806-821/851-866 MHz, ConventionalPersonal Use HA AmateurSatellite Earth Station HBT Temporary Fixed VSAT Hub StationSatellite Earth Station HUB VSAT Fixed Hub StationPersonal Use HV VanityLand Mobile Radio IG Industrial/Business Pool, ConventionalInternational Broadcast IHF International HF BroadcastLand Mobile Radio IK Industrial/Business Pool - Commercial, ConventionalSafety of Life IQ Intelligent Transportation Service (Public Safety)Broadcast LD Digital Translator or Digital LPTVFixed Wireless LD Local Multipoint Distribution ServicePaging and Messaging LN 902-928 MHz Location Narrowband (Non-multilateration)Broadcast Support LP Broadcast Auxiliary Low PowerPaging and Messaging LS Location and Monitoring Service, Multilateration (LMS)Broadcast Support LV Low Power Wireless Assist Video Devices

14


Category Radio Service Code DescriptionPaging and Messaging LW 902-928 MHz Location Wideband (Grandfathered AVM)Safety of Life MA Marine Auxiliary GroupSafety of Life MC Coastal GroupSatellite Earth Station MES Mobile Earth StationFixed Wireless MG Microwave Industrial/Business PoolSafety of Life MK Alaska GroupFixed Wireless MM Millimeter Wave 70/80/90 GHz ServiceRadar MR Marine Radiolocation LandFixed Wireless MS Multiple Address Service, AuctionedSafety of Life MW Microwave Public Safety PoolPaging and Messaging NC Nationwide Commercial 5 Channel, 220 MHzMobile/Fixed Broadband NN 3650-3700 MHzSatellite Earth Station OTH (catch all for anything that doesn't fit our categories)Safety of Life PA Public Safety 4940-4990 MHz BandSafety of Life PC Public Coast Stations, AuctionedFixed Wireless PE Digital Electronic Message Service - PrivateSafety of Life PW Public Safety Pool, ConventionalPaging and Messaging QA 220-222 MHz Band, AuctionedPaging and Messaging QD Non-Nationwide Data, 220 MHzPaging and Messaging QM Non-Nationwide Public Safety/Mutual Aid, 220 MHzPaging and Messaging QO Non-Nationwide Other, 220 MHzLand Mobile Radio QQ Intelligent Transportation Service (Non-Public Safety)Paging and Messaging QT Non-Nationwide 5 Channel Trunked, 220 MHzBroadcast Support RP Broadcast Auxiliary Remote PickupSafety of Life RR Restricted OperatorLand Mobile Radio RS Land Mobile RadiolocationSafety of Life SA Ship Recreational or Voluntarily EquippedSafety of Life SB Ship Compulsory EquippedSafety of Life SE Ship ExemptionSafety of Life SG Conventional Public Safety 700 MHzSafety of Life SL Public Safety 700 MHZ Band-State LicenseSafety of Life SP 700 MHz Public Safety Broadband Nationwide LicenseSatellite Space Station SSG Geostationary Space StationSatellite Space Station SSN Non-Geostationary Space StationSafety of Life SY Trunked Public Safety 700 MHzBroadcast Support TB TV Microwave BoosterSatellite Earth Station TFE Temporary Fixed Earth StationBroadcast Support TI TV Intercity RelayFixed Wireless TN 39 Ghz, AuctionedBroadcast Support TP TV PickupBroadcast Support TS TV Studio Transmitter LinkBroadcast Support TT TV Translator RelayBroadcast TV TelevisionBroadcast TX TV Translator or LPTV stationFixed Wireless TZ 24 GHz ServiceSatellite Earth Station VST VSAT NetworkSafety of Life WA Microwave AviationFixed Wireless WM Microwave MarineRadar WR Microwave RadiolocationMobile/Fixed Broadband WS Wireless Communications ServiceMobile/Fixed Broadband WU 700 MHz Upper Band (Block C)Mobile/Fixed Broadband WX 700 MHz Guard BandMobile/Fixed Broadband WY 700 MHz Lower Band (Blocks A, B, E)Mobile/Fixed Broadband WZ 700 MHz Lower Band (Blocks C, D)Experimental XC Experimental ContractExperimental XD Experimental DevelopmentalExperimental XE Experimental ExportExperimental XR Experimental Research

15


Category Radio Service Code DescriptionExperimental XT Experimental TestingLand Mobile Radio YB Business, 806-821/851-866 MHz, TrunkedMobile/Fixed Broadband YC SMR, 806-821/851-866 MHz, AuctionedMobile/Fixed Broadband YD SMR, 896-901/935-940 MHz, AuctionedSafety of Life YE PubSafty/SpecEmer/PubSaftyNtlPlan,806-817/851-862MHz,TrunkedSafety of Life YF Public Safety Ntl Plan, 821-824/866-869 MHz, TrunkedLand Mobile Radio YG Industrial/Business Pool, TrunkedMobile/Fixed Broadband YH SMR, 806-821/851-866 MHz, Auctioned (Rebanded YC license)Land Mobile Radio YI Other Indust/Land Transp. 896-901/935-940 MHz, TrunkedLand Mobile Radio YJ Business/Industrial/Land Trans, 809-824/854-869 MHz, TrunkedLand Mobile Radio YK Industrial/Business Pool - Commercial, TrunkedLand Mobile Radio YM 800 MHz Trunked SMR (SMR, Site-specific)Land Mobile Radio YO Other Indust/Land Transp. 806-821/851-866 MHz, TrunkedSafety of Life YP Public Safety/Spec Emerg, 806-821/851-866 MHz, TrunkedLand Mobile Radio YS SMR, 896-901/935-940 MHz, TrunkedLand Mobile Radio YU Business, 896-901/935-940 MHz, TrunkedSafety of Life YW Public Safety Pool, TrunkedLand Mobile Radio YX SMR, 806-821/851-866 MHz, TrunkedPersonal Use ZA General Mobile Radio (GMRS)Paging and Messaging ZV 218-219 MHz Service

2.77. rollup_entity_code varchar2(5)

This code is the high-level entity type code that appears on the FCC License View web page.

The following table shows the applicant type codes and descriptions.

Applicant Type Code Applicant Type DescriptionB BusinessG Governmental EntityI IndividualO Other

The “Other” option allows users to enter a free-form description.

2.78. rollup_entity_ desc varchar2(100)

This text is the high-level entity type description that appears on the FCC License View web page.

2.79. rollup_status_code varchar2(50)

This text is the high-level license status code that appears on the FCC License View web page.

The following table shows the existing license status codes and descriptions as well as the code values and descriptions used in FCC License View.

16


Current Codes (used in exiting systems) Current Code Description Rolled up Code Rolled up Code DescriptionLICAN LICENSE CANCELLED C CanceledLICSL LICENSED AND SILENT A ActiveLICEN LICENSED A Active

Current (based on completed date) A ActiveClosed (based on completed date) C Canceled

EGrant Expired Due to New License or Expired E Expired

G Granted A ActiveA Active A ActiveD Deleted C CancelledN Not Active C CancelledC Cancelled C CancelledT Terminated T Terminated

2.80. rollup_status_desc varchar2(100)

This text is the high-level license status description that appears on the FCC License View web page.

2.81. source_system varchar2(10)

This column identifies the FCC licensing system from which the data came, as follows:

Licensing Source System Code System DescriptionCDBS Consolidated Database SystemIBFS International Bureau Filing SystemELS Experimental Licensing System,ULS Universal Licensing SystemCOALS Cable Operations and Licensing System

2.82. tolerance number(6,5)

This number identifies the maximum allowable frequency deviation from a specified nominal frequency at ambient room temperature (25°C +/- 3°C). Frequency tolerance is expressed in percent (%).

2.83. unit_of_measure varchar2(5)

This is the unit of measurement for a frequency.

Values include:

17


Unit of MeasureKHz.MHz.

18

document style templatedata.fcc.gov/download/license-view/fcc-license-view-data... · web...

Documents