8b- 2025-2110MHz ENG Data Dictionary.pdf

ENG Data Dictionary

ENG

Column

ENG Column Name FCC Data Element (TableName.FieldName)

FCC Data Definition

Form Content

A Call Sign FR.Call_Sign Char(10) Send license call sign/serial # for all 601 and 605 application purposes except new (NE). Must be null for AA/TC Form 603 applications.

B Radio Service Code HD.Radio_Service_Code Char(2) Required, for application purposes AA and TC send as "AL' else send appropriate radio service code

C Granted HD.Grant_Date Char(10)

MM/DD/YYYY

Must be Null

D Expiration HD.Expired_Date Char(10)

MM/DD/YYYY

Must be Null

E Canceled HD.Cancellation_Date Char(10)

MM/DD/YYYY

Must be Null

F Effective HD.Effective_Date Char(10)

MM/DD/YYYY

Must be Null

ENG

Column

ENG Column Name

A Call Sign

B Radio Service Code

C Granted

D Expiration

E Canceled

F Effective

Form Reference Data Description

Main Form 601 box 5, Main Form 605 box 5

ULS call sign associated with each record. The combination of letters and numbers that identify an FCC license.

Main Form 601 box 1, Main Form 605 box 1

The name of the wireless service under which the Universal Licensing System (ULS) has issued the license.

The date on which the license term (usually 10 years) begins. This date also sets the timetable for any applicable construction or coverage deadlines.

The date after which a license ceases to be valid.

For example, a license with a 12/1/2004 expiration is no longer valid at 12:00am on 12/2/2004. In most cases wireless licenses have a 10-year license term, and the expiration date is the 10-year anniversary date of the original license grant date.

The date a call sign became inactive. The licensee may file an application to request cancellation. Licenses can become inactive when the license expires and is auto-deleted via ULS’s auto-expiration program. The FCC can also choose to terminate the license in the case where a licensee fails to meet its debt obligations to the U.S. government with respect to an auctioned license or for non-construction or discontinuance of operations.

The date on which a license becomes effective.

In most cases this is the same as the Grant Date.

For modifications, the original Grant Date of the license will remain the same, but the Effective Date will be the day the Modification becomes effective.

ENG

Column

ENG Column Name FCC Data Element (TableName.FieldName)

FCC Data Definition

Form Content

G Unique System ID HD.Unique_System_Identifier Numeric(9,0) Must be Null

H Licensee EN.Entity_Name Varchar(200)

For 601 applications, required if application purpose is NE or data is missing in the license record.

For 601 and 603 applications,required if entity type is "O".

For 603 applications, required if entity type is "L", "R" or "E" and entity is not an individual. Do not send entity name if the entity type is "L", "R" or "E" and the entity is an individual.

For 603 applications where the entity type is CL, CR, or CE, either (the individual name and attention line) or (the individual name and the company name) is required.

EN.PO_Box Varchar(20)

Required if Street Address is null. Do not send PO Box if entity type is "O".

Required if PO Box is null. Do not send Street Address if entity type is "O".

EN.Street_Address Varchar(60) Required if PO Box is null. Do not send Street Address if entity type is "O".

EN.City Varchar(20)

Required if application purpose is NE or data is missing in the license record. Required if entity type is "L", "R", "E", "CL", "CR" or "CE". Do not send City if entity type is "O"

EN.State Char(2)

Required if application purpose is NE or data is missing in the license record. Required if entity type is "L", "R", "E", "CL", "CR" or "CE". Do not send State if entity type is "O".

Licensee AddressI

ENG

Column

ENG Column Name

G Unique System ID

H Licensee

Licensee AddressI

Form Reference Data Description

Database-assigned ID for each location callsign and assign by the Commission Registration System (CORES). The unique entity identifier for everyone doing business with the Commission

Main Form 601 box 17,28,31 Main Form 603 box 20, 32, 45, 56, 69, 72, Main Form 605 box 12

Contains the “Entity Name” for all FCC records, and the Broadcast Callsign/Location for all SBE records, describes Ownership, Control or Corporate Structure

Main Form 601 box 19,33 Main Form 603 box 22, 34, 47, 58, 73, 85 Main Form 605 box 14

Main Form 601 box 20,34 Main Form 603 box 23, 35, 48, 59, 74, 86 Main Form 605 box 15

Main Form 601 box 21,35 Main Form 603 box 24, 36, 49, 60, 75, 87 Main Form 605 box 16

Main Form 601 box 22,36 Main Form 603 box 25, 37, 50, 61, 76, 88 Main Form 605 box 17

The address of the individual or business entity holding the license

ENG

Column

ENG Column Name FCC Data Element (TableName.FieldName)

FCC Data Definition

Form Content

EN.Zip_Code Char(9)

Required if application purpose is NE or data is missing in the license record. Required if entity type is "L", "R", "E", "CL", "CR" or "CE". Do not send Zip Code if entity type is "O".

J Tx Station Class FR.Class_Station_Code Char(4) Send if applicable based on application purpose, radio service code and action code above For valid codes, refer to the form and the instructions or to the ULS Code Definitions file.

K Tx Radius of Operation (km)

LO.Radius_of_operation Numeric(5,1)

Not required and do not send for fixed locations. Required for area locations if the Area of Operation Code is "A" or "P" and action is "A". If action is "M", send if this is a change from the license. Do not send if action is "D" or "U".

LO.Lat_Degrees LO.Lat_Minutes LO.Lat_Seconds LO.Lat_Dir

Integer Integer Numeric(3,1) Char(1)

LO.Long_Degrees LO.Long_Minutes LO.Long_Seconds LO.Long_Dir

Integer Integer Numeric(3,1) Char(1)

M Tx City LO.Location_City Char(20)

Required for fixed locations if action is "A". May be required for area locations if Area of Operation Code is "P" and action is "A" - Refer to Form 601 Instructions to determine when to send city. If action is "M", send if this is a change from the license. Do not send if action is "D" or "U"

N Tx State LO.Location_State Char(2)

Required for fixed locations if action is "A". Required for area locations if Area of OperationCode is "P", "C", "S" or "X" and action is "A". If action is "M", send if this is a change from the license. Do not send if action is "D" or "U".

L Tx Location

If action is "A", this item is required for fixed locations that do not provide an Antenna Structure Registration Number. If action is "A", this item is optional for fixed locations that do provide an Antenna Structure Registration Number. If action is "A", this item is required for area locations if the Area of OperationCode is "P" or "R". If action is "M", send this item if it is a change from the license. Do not send if

ENG

Column

ENG Column Name

J Tx Station Class

K Tx Radius of Operation (km)

M Tx City

N Tx State

L Tx Location

Form Reference Data Description

Main Form 601 box 23,37 Main Form 603 box 26, 38, 51, 62, 77, 89 Main Form 605 box 18

Form 601 Schedule H box 32, Form 601 Schedule J box 17, Form 601 Schedule M box 35

The three-letter code that identifies the microwave transmitter class and description.

Form 601 Schedule D box 18, Form 601 Schedule I Supplement 1 box 17

Radius of Operation in kilometers (km)

Form 601 Schedule D box 7, Form 601 Schedule I Supplement 1 box 7, Form 601 Schedule M box 5, 14

Form 601 Schedule D box 7, Form 601 Schedule I Supplement 1 box 7, Form 601 Schedule M box 5, 15

Form 601 Schedule D box 10, Form 601 Schedule I Supplement 1 box 10 Form 601 ScheduleM box 7

City where transmitter is located

Form 601 Schedule D box 11, Form 601 Schedule I Supplement 1 box 11 Form 601 ScheduleM box 9

State where transmitter is located

The Latitude, Longitude, and cardinal directions associated with this location are indicated. The coordinates are listed in degrees (e.g., 42º), minutes (e.g., 13'), and seconds (e.g., 10") and are referenced in NAD83 (North American Datum 1983).

ENG

Column

ENG Column Name FCC Data Element (TableName.FieldName)

FCC Data Definition

Form Content

O Tx Assigned Freq (MHz)

FR.Frequency_Assigned Numeric(16,8)

Send existing frequency data.

Note: If action performed is "M" and the existing frequency data needs to be changed, send the existing frequency data in FR11 - Frequency Assigned and the new frequency data in FR28 - New Frequency Assigned.

P Tx Upper Freq Band (MHz)

FR.Frequency_Upper_Band Numeric(16,8)

Send existing frequency data.

Note: If action performed is "M" and the existing frequency data needs to be changed, send the existing frequency upper band data in FR12 - Frequency Upper Band and the new frequency upper band data in

FR29

- New Frequency Upper Band.

Q home_channel N/A Char(255)

R Tx Freq Tolerance (%) FR.Tolerance Numeric(6.5) Send if applicable based on application purpose, radio service code and action code

S Tx Ant Type AN.Antenna_Type_Code Char(1) Send "T" for transmitter, "R" for final receiver, "P" for passive receiver.

Valid type codes are also listed in the ULS Code Definitions file.

T Tx Make FR.Transmitter_Make Varchar(25) Send if applicable based on application purpose, radio service code and action code

U Tx Model FR.Transmitter_Model Varchar(25) Send if applicable based on application purpose, radio service code and action code

V Tx Ant Tilt AN.Tilt Numeric(3,1) Send if applicable based on application purpose, radio service code and action code

ENG

Column

ENG Column Name

O Tx Assigned Freq (MHz)

P Tx Upper Freq Band (MHz)

Q home_channel

R Tx Freq Tolerance (%)

S Tx Ant Type

T Tx Make

U Tx Model

V Tx Ant Tilt

Form Reference Data Description

Form 601 Schedule G box 22a, 22b, Form 601 Schedule H box 31, Form 601 Schedule I Supplement 4 box 4, Form 601 Schedule J box 16, Form 601 ScheduleM box 36 Form 601 Schedule E (supplement - Site Specific Technical Data) box 15a

Assigned frequency in megahertz (MHz)

Form 601 Schedule G box 22a, 22b, Form 601 Schedule H box 31, Form 601 Schedule I Supplement 4 box 5 Form 60 1 Schedule E (supplement - Site Specific Technical Data) box 15b

Upper frequency in megahertz (MHz)

Provided with SBE data

Form 601 Schedule I Supplement 4 box 6 Defines the frequency stability of the transmitter

Antenna type code

Form 601 Schedule I Supplement 4 box 11 Form 601 ScheduleM box 31

Transmitter make

Form 601 Schedule I Supplement 4 box 12 Form 601 ScheduleM box 32

Transmitter model

Form 601 Schedule I Supplement 2 box 13 Form 601 Schedule M box 22, 30 Form 60 1 Schedule E (supplement - Site Specific Technical Data) box 11

Tilt of the antenna with respect to the horizon

ENG

Column

ENG Column Name FCC Data Element (TableName.FieldName)

FCC Data Definition

Form Content

W Tx Ant Height (m) AN.Height_to_Center_RAAT Numeric(5,1) Send if applicable based on application purpose, radio service code and action code

X Tx Ant Beamwidth (deg)

AN.Beamwidth Numeric(4,1) Send if applicable based on application purpose, radio service code and action code

Y Tx Ant Gain (dBi) AN.Gain Numeric(4,1) Send if applicable based on application purpose, radio service code and action code

Z Tx Ant Azimuth (deg) AN.Azimuth Numeric(4,1) Send if applicable based on application purpose, radio service code and action code

AA Rx Location Name LO.Location_Name Char(20)

This item is optional for Form 601 Schedule D and Form 601 Schedule M users. For Form 601 Schedule I users (microwave), this item is required if action is "A". If action is "M", send if this is a change from the license.

Do not send if action is "D" or "U".

ENG

Column

ENG Column Name

W Tx Ant Height (m)

X Tx Ant Beamwidth (deg)

Y Tx Ant Gain (dBi)

Z Tx Ant Azimuth (deg)

AA Rx Location Name

Form Reference Data Description

Form 601 Schedule I Supplement 2 box 7, 25, Form 601 Schedule I Supplement 3 box 9, Form 601 Schedule J box 9, Form 601 Schedule M box 20, 28

Centerline height of the transmitter antenna

Form 601 Schedule G box 17, 33, Form 601 Schedule H box 25, Form 601 Schedule I Supplement 2 box 8, 26, Form 601 Schedule J box 10 , Form 601 Schedule M box 19, 27 Form 60 1 Schedule E (supplement - Site Specific Technical Data) box 8

Width of the beam of the antenna at the half-power points

Form 601 Schedule G box 13, 35, Form 601 Schedule H box 27, Form 601 Schedule I Supplement 2 box 9, 27, Form 601 Schedule J box 11, Form 601 Schedule M box 18, 26 Form 60 1 Schedule E (supplement - Site Specific Technical Data) box 10

Gain of the antenna as measured with respect to an isotropic radiator

Form 601 Schedule G box 14, 32, Form 601 Schedule H box 24, Form 601 Schedule I Supplement 2 box 15, Form 601 Schedule I Supplement 3 box 14, Form 601 Schedule J box 12, Form 601 Schedule M box 21, 29 Form 60 1 Schedule E (supplement - Site Specific Technical Data) box 7

Pointing direction of the antenna.

Form 601 Schedule D box 5, Form 601 Schedule I Supplement 1 box 5, Form 601 Schedule M box 4

Name assigned to the receiver location

ENG

Column

ENG Column Name FCC Data Element (TableName.FieldName)

FCC Data Definition

Form Content

AB location_address N/A

AC Rx City LO.Location_City Varchar(20)

Required for fixed locations if action is "A". May be required for area locations if Area of Operation Code is "P" and action is "A" - Refer to Form 601 Instructions to determine when to send city. If action is "M", send if this is a change from the license. Do not send if action is "D" or "U"

AD RxLocState LO.Location_State Char(2)

Required for fixed locations if action is "A". Required for area locations if Area of OperationCode is "P", "C", "S" or "X" and action is "A". If action is "M", send if this is a change from the license. Do not send if

ENG

Column

ENG Column Name

AB location_address

AC Rx City

AD RxLocState

Form Reference Data Description

Provided with SBE data

Form 601 Schedule D box 10, Form 601 Schedule I Supplement 1 box 10 Form 601 ScheduleM box 7

City where receiver is located

Form 601 Schedule D box 11, Form 601 Schedule I Supplement 1 box 11 Form 601 ScheduleM box 9

State where receiver is located

ENG

Column

ENG Column Name FCC Data Element (TableName.FieldName)

FCC Data Definition

Form Content

LO.Lat_Degrees LO.Lat_Minutes LO.Lat_Seconds LO.Lat_Dir

Double Double Double Char(1)

LO.Long_Degrees LO.Long_Minutes LO.Long_Seconds LO.Long_Dir

Double Double Double Char(1)

AF RxLatDD N/A

AG RxLongDD N/A

AH Rx Ant Make AN.Antenna_Make Varchar(25) Send if applicable based on application purpose, radio service code and action code

AI Rx Ant Model AN.Antenna_Model Varchar(25) Send if applicable based on application purpose, radio service code and action code

AJ Rx Ant Tilt AN.Tilt Numeric(3,1) Send if applicable based on application purpose, radio service code and action code

AK RX_AntPolCde AN.Polarization_Code Char(5) Send if applicable based on application purpose, radio service code and action code

AE Rx Location

If action is "A", this item is required for fixed locations that do not provide an Antenna Structure Registration Number. If action is "A", this item is optional for fixed locations that do provide an Antenna Structure Registration Number. If action is "A", this item is required for area locations if the Area of OperationCode is "P" or "R". If action is "M", send this item if it is a change from the license. Do not send if

ENG

Column

ENG Column Name

AF RxLatDD

AG RxLongDD

AH Rx Ant Make

AI Rx Ant Model

AJ Rx Ant Tilt

AK RX_AntPolCde

AE Rx Location

Form Reference Data Description

Form 601 Schedule D box 7, Form 601 Schedule I Supplement 1 box 7, Form 601 Schedule M box 5, 14

Form 601 Schedule D box 7, Form 601 Schedule I Supplement 1 box 7, Form 601 Schedule M box 5, 15

System-calculated; Converstion of DMS coordinates to decimal degrees.

System-calculated; Converstion of DMS coordinates to decimal degrees.

Form 601 Schedule I Supplement 4 box 11 Form 601 ScheduleM box 31

Receiver make

Form 601 Schedule I Supplement 4 box 12 Form 601 ScheduleM box 32

Receiver model

Form 601 Schedule I Supplement 2 box 13 Form 601 ScheduleM box 22, 30 Form 601 Schedule E (Supplement - Site Specific Technical Data) box 11

Tilt of the antenna with respect to the horizon.

Form 601 Schedule G box 34, Form 601 Schedule H box 26, Form 601 Schedule I Supplement 2 box 14, Form 601 Schedule I Supplement 3 box 13 Form 601 ScheduleM box 23 Form 601 Schedule E (Supplement - Site Specific Technical Data) box 9

Polarization of the signal leaving the passive repeater

The Latitude, Longitude, and cardinal directions associated with this location are indicated. The coordinates are listed in degrees (e.g., 42º), minutes (e.g., 13'), and seconds (e.g., 10") and are referenced in NAD83 (North American Datum 1983).

ENG

Column

ENG Column Name FCC Data Element (TableName.FieldName)

FCC Data Definition

Form Content

AL

Rx Ant Beamwidth (deg)

AN.Beamwidth Numeric(4,1) Send if applicable based on application purpose, radio service code and action code

AM Rx Ant Gain (dBi) AN.Gain Numeric(4,1) Send if applicable based on application purpose, radio service code and action code

AN Rx HAAT (m) AN.Height_Above_Avg_Terrain Numeric(3,1) Send if applicable based on application purpose, radio service code and action code

AO RXAntHgt_AGL_m AN.Height_to_Center_RAAT Numeric(5,1) Send if applicable based on application purpose, radio service code and action code

AP Rx Ant Height AGL (m) N/A

AQ

Rx Site Elevation AMSL (m)

LO.Ground_Elevation Numeric(7,1) Not required and do not send for area locations. Required for fixed locations if action is "A". If action is "M", send if this is a change from the license. Do not send if action is "D" or "U".

ENG

Column

ENG Column Name

AL

Rx Ant Beamwidth (deg)

AM Rx Ant Gain (dBi)

AN Rx HAAT (m)

AO RXAntHgt_AGL_m

AP Rx Ant Height AGL (m)

AQ

Rx Site Elevation AMSL (m)

Form Reference Data Description

Form 601 Schedule G box 17, 33, Form 601 Schedule H box 25, Form 601 Schedule I Supplement 2 box 8, 26, Form 601 Schedule J box 10 , Form 601 ScheduleM box 19, 27 Form 601 Schedule E (supplement - Site Specific Technical Data) box 8

Width of the beam of the antenna measured at the half-power points

Form 601 Schedule G box 13, 35, Form 601 Schedule H box 25, Form 601 Schedule I Supplement 2 box 8, 26, Form 601 Schedule J box 11 , Form 601 ScheduleM box 18, 27 Form 601 Schedule E (supplement - Site Specific Technical Data) box 10

Gain of the antenna as measured with respect to an isotropic radiator

Form 601 Schedule H box 22 Receiver antenna height above average terrain (HAAT) in meters (m)

Form 601 Schedule I Supplement 2 box 7, 25, Form 601 Schedule I Supplement 3 box 9, Form 601 Schedule J box 9, Form 601 Schedule M box 20, 28

Centerline height of the receiver antenna

Provided with SBE data; Receiver antenna height above ground level (AGL) in meters (m)

Form 601 Schedule D box 13, Form 601 Schedule I Supplement 1 box 13 Form 601 Schedule M box 10

Receiver site elevation above mean sea level (AMSL) in meters (m)

ENG

Column

ENG Column Name FCC Data Element (TableName.FieldName)

FCC Data Definition

Form Content

AR

Rx Support Structure Height Without Appurtenances (m)

LO.Height_of_Support_Structure Numeric(7,1) Not required and do not send for area locations. Required for fixed locations if action is "A". If action is "M", send if this is a change from the license. Do not send if action is "D" or "U".

AS

Rx Structure Overall Height With Appurtenances (m)

LO.Overall_Height_of_Structure Numeric(7,1) Not required and do not send for area locations. Required for fixed locations if action is "A". If action is "M", send if this is a change from the license. Do not send if action is "D" or "U"

AT OrigSource N/A

ENG

Column

ENG Column Name

AR

Rx Support Structure Height Without Appurtenances (m)

AS

Rx Structure Overall Height With Appurtenances (m)

AT OrigSource

Form Reference Data Description

Form 601 Schedule D box 14, Form 601 Schedule I Supplement 1 box 14 Form 601 Schedule M box 11

Structure Height without Appurtenances in meters (m)

Form 601 Schedule D box 15, Form 601 Schedule I Supplement 1 box 15 Form 601 Schedule M box 12

Structure Height with Appurtenances in meters(m)

System-assigned (SBE/_FCC_/FCC) indicator of the source of the data in this row.

Note: _FCC_ entries identify corrected or manually entered FCC data

ENG Data Dictionary