# Ant_rpatterns

Antenna propagation patterns for receivers.

No. Column Name Type

\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--

\(1\) make char(20)

\(2\) model char(20)

\(3\) flag_cross_plane char(1)

\(4\) bearing int

\(5\) gain float

# 

# Ant_tpatterns

Antenna propagation patterns for transmitters.

No. Column Name Type

\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--

\(1\) make char(20)

\(2\) model char(20)

\(3\) bearing int

\(4\) radiation float

# 

# App_address

Transmitter location address.

No. Column Name Type

\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--

\(1\) id_app_num int

\(2\) code char(12)

\(3\) address varchar(180)

\(4\) city varchar(60)

\(5\) county varchar(60)

\(6\) name varchar(60)

\(7\) state char(2)

# 

# App_amend

Relational table: amendment to application amended.

No. Column Name Type

\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--

\(1\) id_app_num int

\(2\) amended_app_num int

# App_main

Main application data table.

No. Column Name Type

\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--

\(1\) id_app_num int

\(2\) act_rpt_num int

\(3\) app_code int

\(4\) app_rpt_num int

\(5\) att_code int

\(6\) cp_app_arn char(12)

\(7\) cp_id_app_num int

\(8\) date_disposed datetime

\(9\) date_received datetime

\(10\) eng_code int

\(11\) file_prefix char(8)

\(12\) flag_current char(1)

\(13\) flag_hold char(1)

\(14\) flag_major char(1)

\(15\) flag_mx char(1)

\(16\) form_id int

\(17\) id_fac_num int

\(18\) id_srv char(2)

\(19\) months_to_construct int

\(20\) new_app_arn char(12)

\(21\) record_status char(5)

\(22\) rep_code int

\(23\) new_app_type char(5)

\(24\) ref_app_arn char(12)

\(25\) ref_id_app_num int

\(26\) callsign char(12)

\(27\) fac_type char(4)

\(28\) flag_cc char(1)

\(29\) date_accepted datetime

\(30\) flag_audit char(1)

# 

# App_mx

Relational table: application to mutually exclusive application group.

No. Column Name Type

\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--

\(1\) id_app_num int

\(2\) group_id int

# 

# App_purp

List of application purpose codes.

No. Column Name Type

\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--

\(1\) id_app_num int

\(2\) app_purp char(2)

# 

# 

# App_spec_cond

List of application's special conditions.

No. Column Name Type

\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--

\(1\) id_app_num int

\(2\) code char(12)

\(3\) seq_num int

\(4\) flag_uq char(1)

# 

# Assoc_callsign

Call Signs associated with a two-way application.

No. Column Name Type

\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--

\(1\) seq_num int

\(2\) id_app_num int

\(3\) id_fac_num int

**Booster**

Relational table: booster facility to facility boosted.

No. Column Name Type

\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--

\(1\) booster_fac_num int

\(2\) main_fac_num int

\(3\) id_app_num int

\(4\) seq_num int

# 

# Border

Border points for Canada and Mexico, and coordinates of other locations.

No. Column Name Type

\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--

\(1\) country char(10)

\(2\) latitude real

\(3\) longitude real

# 

# Bta_county

List of counties by BTA number.

No. Column Name Type

\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--

\(1\) id_bta_num int

\(2\) bta_county varchar(60)

\(3\) bta_state char(2)

#  

# Bta_list

Information for a specific BTA, by number.

No. Column Name Type

\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--

\(1\) id_bta_num int

\(2\) app_code int

\(3\) bta_city varchar(60)

\(4\) bta_state char(2)

\(5\) date_bta_exp datetime

\(6\) flag_pbta char(1)

\(7\) id_app_num_304 int

\(8\) id_app_num_soi int

**Callsign_suffix**

Table to track suffixes used for a call sign.

No. Column Name Type

\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--

\(1\) callsign char(12)

\(2\) b_count int

\(3\) h_count int

\(4\) i_count int

# 

# Chan_adjacent_list

Relational table: channel to adjacent channels.

No. Column Name Type

\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--

\(1\) channel char(3)

\(2\) id_srv char(2)

\(3\) chan_adj char(3)

# 

# Chan_freq_list

Frequency range for a channel.

No. Column Name Type

\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--

\(1\) channel char(3)

\(2\) id_srv char(2)

\(3\) freq_lower char(17)

\(4\) freq_upper char(17)

\(5\) channel_grp char(3)

\(6\) flag_active char(1)

# 

# Channel_group

Relational table: channel to channel group.

No. Column Name Type

\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--

\(1\) group_name char(2)

\(2\) channel char(2)

**Eng_ant**t

Antenna data for an application.

No. Column Name Type

\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--

\(1\) id_app_num int

\(2\) flag_tx_rx char(1)

\(3\) tower_num int

\(4\) ant_num int

\(5\) azimuth float

\(6\) beam_tilt float

\(7\) beam_width float

\(8\) eirp float

\(9\) emission char(1)

\(10\) flag_omni char(1)

\(11\) hgt_rcamsl float

\(12\) make char(3)

\(13\) model varchar(20)

\(14\) polar char(1)

# 

# Eng_chan

List of application's channels.

No. Column Name Type

\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--

\(1\) id_app_num int

\(2\) tower_num int

\(3\) ant_num int

\(4\) channel char(3)

\(5\) offset char(1)

# Eng_coords

Coordinates of an applications transmitters/receivers, and center of
protected service area.

No. Column Name Type

\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--

\(1\) id_app_num int

\(2\) flag_tx_rx char(1)

\(3\) tower_num int

\(4\) flag_27_83 char(1)

\(5\) flag_loc_pro char(1)

\(6\) date_updated datetime

\(7\) latdir char(1)

\(8\) latdeg int

\(9\) latmin int

\(10\) latsec int

\(11\) londir char(1)

\(12\) londeg int

\(13\) lonmin int

\(14\) lonsec int

#  

# Eng_emission

Emission data for application.

No. Column Name Type

\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--

\(1\) id_app_num int

\(2\) tower_num int

\(3\) ant_num int

\(4\) flag_emission char(1)

\(5\) emission_aural varchar(10)

\(6\) emission_visual varchar(10)

\(7\) modulation_type varchar(20)

# Eng_location

Location and additional engineering data.

No. Column Name Type

\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--

\(1\) id_app_num int

\(2\) flag_tx_rx char(1)

\(3\) tower_num int

\(4\) flag_pre83 char(1)

\(5\) flag_protect char(1)

\(6\) grd_elev float

\(7\) hgt_struct float

\(8\) id_fac_num int

\(9\) pro_area char(40

\(10\) tower_id int

# 

# Fac_bta_pbta

Identifies the facilities BTA.

No. Column Name Type

\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--

\(1\) id_fac_num int

\(2\) id_app_num int

\(3\) flag_bta_pbta char(1)

\(4\) id_bta_num int

# Fac_main

Main data table for a facility.

No. Column Name Type

\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--

\(1\) id_fac_num int

\(2\) callsign char(12)

\(3\) date_record_status datetime

\(4\) fac_type char(4)

\(5\) flag_cc char(1)

\(6\) id_srv char(2)

\(7\) lic_code int

\(8\) record_status char(5)

\(9\) sta_class char(3)

\(10\) fac_id_num int

# Personal_info

Personal information table, used to identify licensees, attorneys,
engineers, etc.

No. Column Name Type

\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--

\(1\) pit_code int

\(2\) atten varchar(60)

\(3\) business varchar(60)

\(4\) city varchar(60)

\(5\) county varchar(60)

\(6\) country varchar(60)

\(7\) email varchar(60)

\(8\) fax char(10)

\(9\) flag_job char(1)

\(10\) name varchar(60)

\(11\) phone varchar(20)

\(12\) state char(2)

\(13\) street_address1 varchar(60)

\(14\) street_address2 varchar(60)

\(15\) title varchar(60)

\(16\) zip1 char(5)

\(17\) zip2 char(4)

# Pub_not

List of applications for Public Notice.

No. Column Name Type

\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--

\(1\) id_app_num int

\(2\) amended_app_num int

\(3\) app_rpt_num int

\(4\) act_rpt_num int

\(5\) app_record_status char(5)

\(6\) app_sort char(4)

\(7\) callsign char(12)

\(8\) date_status_eff datetime

\(9\) date_last_pn datetime

\(10\) date_pn_released datetime

\(11\) fac_record_status char(5)

\(12\) flag_app_act char(1)

\(13\) flag_renewal char(1)

\(14\) flag_sent char(1)

\(15\) id_fac_num int

# 

#  

# Pub_not_hist

Archived list of applications for Public Notice.

No. Column Name Type

\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--

\(1\) id_app_num int

\(2\) date_pn_released datetime

\(3\) amended_app_num int

\(4\) app_rpt_num int

\(5\) act_rpt_num int

\(6\) app_record_status char(5)

\(7\) app_sort char(4)

\(8\) callsign char(12)

\(9\) date_status_eff datetime

\(10\) date_last_pn datetime

\(11\) fac_record_status char(5)

\(12\) flag_app_act char(1)

\(13\) flag_renewal char(1)

\(14\) flag_sent char(1)

\(15\) id_fac_num int

# Status

List of events, actions, dates, etc. that affect an application.

No. Column Name Type

\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--

\(1\) id_fac_num int

\(2\) id_app_num int

\(3\) action_num int

\(4\) code_type char(5)

\(5\) code char(5)

\(6\) date_code_eff datetime

\(7\) date_code_end datetime

\(8\) date_target_exp datetime

\(9\) old_content varchar(60)

\(10\) new_content varchar(60)

# Transfer_ctrl

List of facilities involved in an assignment or transfer of control.

No. Column Name Type

\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--

\(1\) id_app_num int

\(2\) id_fac_num int

\(3\) record_status char(5)

\(5\) fm_att_id int

\(6\) fm_pit_id int

\(8\) to_att_id int

\(9\) to_pit_id int

# Txt_list

Standard text referenced by various other tables and processes.

No. Column Name Type

\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--

\(1\) code_type char(5)

\(2\) code char(12)

\(3\) line_seq int

\(4\) id_srv char(2)

\(5\) code_txt varchar(70)

\(6\) uq_txt char(1)

# Uq_txt_list

Unique text referenced by various other tables and processes.

No. Column Name Type

\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--
\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--

\(1\) code_type char(5)

\(2\) code char(12)

\(3\) id_app_num int

\(4\) line_seq int

\(5\) code_txt varchar(70)