+-------------+---------+--------------+------------------------------+
| #           | int     | app_main     | Action public notice report  |
| act_rpt_num |         |              | number.                      |
|             |         | pub_not      |                              |
|             |         |              |                              |
|             |         | pub_not_hist |                              |
+-------------+---------+--------------+------------------------------+
| **a         | int     | status       | Action number.               |
| ction_num** |         |              |                              |
+-------------+---------+--------------+------------------------------+
| **address** | varch   | app_address  | Transmitter location         |
|             | ar(180) |              | description.                 |
+-------------+---------+--------------+------------------------------+
| **amende    | int     | app_amend    | **id_app_num** of the        |
| d_app_num** |         |              | application to be amended.   |
|             |         | pub_not      |                              |
|             |         |              |                              |
|             |         | pub_not_hist |                              |
+-------------+---------+--------------+------------------------------+
| **ant_num** | int     | eng_ant      | Antenna number.              |
|             |         |              |                              |
|             |         | eng_chan     |                              |
|             |         |              |                              |
|             |         | eng_emission |                              |
+-------------+---------+--------------+------------------------------+
| *           | int     | app_main     | Applicant code. Reference to |
| *app_code** |         |              | **pit_code** in              |
|             |         | bta_list     | personal_info table. See     |
|             |         |              | Note #1.                     |
+-------------+---------+--------------+------------------------------+
| *           | char(2) | app_purp     | Application purpose code.    |
| *app_purp** |         |              |                              |
+-------------+---------+--------------+------------------------------+
| **app_reco  | char(5) | pub_not      | Application record status.   |
| rd_status** |         |              | See **record_status.**       |
|             |         | pub_not_hist |                              |
+-------------+---------+--------------+------------------------------+
| **ap        | int     | app_main     | Application public notice    |
| p_rpt_num** |         |              | report number.               |
|             |         | pub_not      |                              |
|             |         |              |                              |
|             |         | pub_not_hist |                              |
+-------------+---------+--------------+------------------------------+
| *           | char(4) | pub_not      | Public notice sort key.      |
| *app_sort** |         |              |                              |
|             |         | pub_not_hist |                              |
+-------------+---------+--------------+------------------------------+
| *           | int     | app_main     | Attorney code. Reference to  |
| *att_code** |         |              | **pit_code** in              |
|             |         |              | personal_info table. See     |
|             |         |              | Note #1.                     |
+-------------+---------+--------------+------------------------------+
| **atten**   | varc    | p            | Address "Attention" name.    |
|             | har(60) | ersonal_info |                              |
+-------------+---------+--------------+------------------------------+
| **azimuth** | float   | eng_ant      | The angle in the horizontal  |
|             |         |              | plane of the antenna main    |
|             |         |              | lobe in degrees, measured    |
|             |         |              | clockwise from true north.   |
+-------------+---------+--------------+------------------------------+
| **b_count** | int     | cal          | Count of boosters for this   |
|             |         | lsign_suffix | call sign.                   |
+-------------+---------+--------------+------------------------------+
| **          | float   | eng_ant      | Amount of non_standard beam  |
| beam_tilt** |         |              | tilt.                        |
+-------------+---------+--------------+------------------------------+
| **b         | float   | eng_ant      | The total angle measured in  |
| eam_width** |         |              | the horizontal plane of      |
|             |         |              | maximum radiation between    |
|             |         |              | which at least ½ the maximum |
|             |         |              | power can be measured.       |
+-------------+---------+--------------+------------------------------+
| **bearing** | int     | a            | The angle in the horizontal  |
|             |         | nt_rpatterns | plane of a specific element  |
|             |         |              | of the antenna pattern.      |
|             |         | a            |                              |
|             |         | nt_tpatterns |                              |
+-------------+---------+--------------+------------------------------+
| **booste    | int     | booster      | **id_fac_num** of the        |
| r_fac_num** |         |              | booster facility.            |
+-------------+---------+--------------+------------------------------+
| *           | varc    | bta_list     | City name of BTA.            |
| *bta_city** | hat(60) |              |                              |
+-------------+---------+--------------+------------------------------+
| **b         | varc    | bta_county   | County name of county in     |
| ta_county** | har(60) |              | BTA.                         |
+-------------+---------+--------------+------------------------------+
| **          | char(2) | bta_county   | State code of BTA.           |
| bta_state** |         |              |                              |
|             |         | bta_list     |                              |
+-------------+---------+--------------+------------------------------+
| *           | varc    | p            | Business name.               |
| *business** | har(60) | ersonal_info |                              |
+-------------+---------+--------------+------------------------------+
| *           | c       | app_main     | Call Sign of the facility or |
| *callsign** | har(12) |              | station                      |
|             |         | cal          |                              |
|             |         | lsign_suffix |                              |
|             |         |              |                              |
|             |         | fac_main     |                              |
|             |         |              |                              |
|             |         | pub_not      |                              |
|             |         |              |                              |
|             |         | pub_not_hist |                              |
+-------------+---------+--------------+------------------------------+
| *           | char(3) | chan_a       | Adjacent Channel.            |
| *chan_adj** |         | djacent_list |                              |
+-------------+---------+--------------+------------------------------+
| **channel** | char(3) | chan_a       | Channel.                     |
|             |         | djacent_list |                              |
|             |         |              |                              |
|             |         | ch           |                              |
|             |         | an_freq_list |                              |
|             |         |              |                              |
|             |         | c            |                              |
|             |         | hannel_group |                              |
|             |         |              |                              |
|             |         | eng_chan     |                              |
+-------------+---------+--------------+------------------------------+
| **ch        | char(3) | ch           | Group identifier of          |
| annel_grp** |         | an_freq_list | associated channels.         |
+-------------+---------+--------------+------------------------------+
| **city**    | varc    | app_address  | City used in mailing address |
|             | har(60) |              | (personal_info) or           |
|             |         | p            | transmitter location         |
|             |         | ersonal_info | (app_address).               |
+-------------+---------+--------------+------------------------------+
| **code**    | c       | app_address  | Used to indicate type of     |
|             | har(12) |              | address. The code for        |
|             |         |              | transmitter address is "TX". |
+-------------+---------+--------------+------------------------------+
|             |         | a            | Identifying code for text    |
|             |         | pp_spec_cond | tables.                      |
+-------------+---------+--------------+------------------------------+
|             | char(5) | status       | For **code_type** = "AC"     |
|             |         |              |                              |
|             |         |              | "ASSGN" -- Assignment of     |
|             |         |              | License                      |
|             |         |              |                              |
|             |         |              | "CMNTS" -- Comments added.   |
|             |         |              |                              |
|             |         |              | "PSTCD" -- Postcard sent.    |
|             |         |              |                              |
|             |         |              | "REPLC" -- Application       |
|             |         |              | replaced by major amendment. |
|             |         |              |                              |
|             |         |              | For **code_type** = "AS",    |
|             |         |              | new application status.      |
|             |         |              |                              |
|             |         |              | For **code_type** = "FS",    |
|             |         |              | new facility status. There   |
|             |         |              | is an additional status code |
|             |         |              | of "PRELI" which contains    |
|             |         |              | the eventual license         |
|             |         |              | expiration date for a        |
|             |         |              | conditional license.         |
|             |         |              |                              |
|             |         |              | For **code_type** = "HC",    |
|             |         |              | hold code applied.           |
|             |         |              |                              |
|             |         |              | For **code_type** = "PC",    |
|             |         |              | pleading code applied.       |
|             |         |              |                              |
|             |         |              | For **code_type** = "PN"     |
|             |         |              |                              |
|             |         |              | "ACT" -- Action public       |
|             |         |              | notice.                      |
|             |         |              |                              |
|             |         |              | "APP" -- Application public  |
|             |         |              | notice.                      |
|             |         |              |                              |
|             |         |              | For **code_type** = "TC"     |
|             |         |              |                              |
|             |         |              | "ENG" -- New FCC engineer.   |
|             |         |              |                              |
|             |         |              | "LAW" -- New FCC attorney.   |
|             |         |              |                              |
|             |         |              | For **code_type** = "UPD"    |
|             |         |              |                              |
|             |         |              | "CONDT" -- Consummation      |
|             |         |              | date.                        |
|             |         |              |                              |
|             |         |              | "CSIGN" -- New call sign.    |
|             |         |              |                              |
|             |         |              | "EXT" -- Extension of time.  |
+-------------+---------+--------------+------------------------------+
|             |         | txt_list     | Code that uniquely           |
|             |         |              | identifies text within       |
|             |         | uq_txt_list  | **code_type.**               |
+-------------+---------+--------------+------------------------------+
| *           | varc    | txt_list     | Line of text.                |
| *code_txt** | har(70) |              |                              |
|             |         | uq_txt_list  |                              |
+-------------+---------+--------------+------------------------------+
| **          | char(5) | status       | "AC" -- Action.              |
| code_type** |         |              |                              |
|             |         |              | "AS" -- Application status.  |
|             |         |              |                              |
|             |         |              | "FS" -- Facility status.     |
|             |         |              |                              |
|             |         |              | "HC" -- Hold code.           |
|             |         |              |                              |
|             |         |              | "PC" -- Plead code.          |
|             |         |              |                              |
|             |         |              | "PN" -- Public Notice.       |
|             |         |              |                              |
|             |         |              | "TC" -- Change of FCC        |
|             |         |              | processor.                   |
|             |         |              |                              |
|             |         |              | "UPD" -- Update.             |
+-------------+---------+--------------+------------------------------+
|             |         | txt_list     | "RPT" -- Canned report text. |
|             |         |              |                              |
|             |         | uq_txt_list  | "SCR" -- Special condition.  |
|             |         |              |                              |
|             |         |              | "SCU" -- Unique special      |
|             |         |              | condition.                   |
|             |         |              |                              |
|             |         |              | "TBL" -- Table description.  |
+-------------+---------+--------------+------------------------------+
| **country** | varc    | p            | Country of data.             |
|             | har(60) | ersonal_info |                              |
+-------------+---------+--------------+------------------------------+
|             | c       | border       | Identifier of data.          |
|             | har(10) |              |                              |
+-------------+---------+--------------+------------------------------+
| **county**  | varc    | app_address  | **Not used.**                |
|             | har(60) |              |                              |
|             |         | p            |                              |
|             |         | ersonal_info |                              |
+-------------+---------+--------------+------------------------------+
| **c         | c       | app_main     | Application reference number |
| p_app_arn** | har(12) |              | of the original construction |
|             |         |              | permit being covered or      |
|             |         |              | modified by a new            |
|             |         |              | application.                 |
+-------------+---------+--------------+------------------------------+
| **cp_i      | int     | app_main     | Id_app_num of the            |
| d_app_num** |         |              | construction permit.         |
+-------------+---------+--------------+------------------------------+
| **date      | d       | app_main     | Date an application is       |
| _accepted** | atetime |              | accepted for filing.         |
+-------------+---------+--------------+------------------------------+
| **dat       | d       | bta_list     | Expiration date of BTA.      |
| e_bta_exp** | atetime |              |                              |
+-------------+---------+--------------+------------------------------+
| **date      | d       | status       | Date on which the status     |
| _code_eff** | atetime |              | indicated became effective.  |
+-------------+---------+--------------+------------------------------+
| **date      | d       | status       | Date on which the status     |
| _code_end** | atetime |              | indicated was superceded.    |
+-------------+---------+--------------+------------------------------+
| **date      | d       | app_main     | Date the application was     |
| _disposed** | atetime |              | disposed.                    |
+-------------+---------+--------------+------------------------------+
| **dat       | d       | pub_not      | Date of last previous public |
| e_last_pn** | atetime |              | notice for this application. |
|             |         | pub_not_hist |                              |
+-------------+---------+--------------+------------------------------+
| **date_pn   | d       | pub_not      | Date on which the public     |
| _released** | atetime |              | notice was released.         |
|             |         | pub_not_hist |                              |
+-------------+---------+--------------+------------------------------+
| **date      | d       | app_main     | Date on which an application |
| _received** | atetime |              | was received by the FCC and  |
|             |         |              | on which the new file number |
|             |         |              | was assigned.                |
+-------------+---------+--------------+------------------------------+
| **date_reco | d       | fac_main     | Date on which the            |
| rd_status** | atetime |              | application/facility         |
|             |         |              | received its current status. |
+-------------+---------+--------------+------------------------------+
| **date_s    | d       | pub_not      | Date on which the            |
| tatus_eff** | atetime |              | application status became    |
|             |         | pub_not_hist | effective.                   |
+-------------+---------+--------------+------------------------------+
| **date_t    | d       | status       | Expiration date identified   |
| arget_exp** | atetime |              | by status.                   |
+-------------+---------+--------------+------------------------------+
| **eirp**    | float   | eng_ant      | Maximum effective            |
|             |         |              | isotropically radiated power |
|             |         |              | in the horizontal plane---in |
|             |         |              | dBw.                         |
+-------------+---------+--------------+------------------------------+
| **email**   | varc    | p            | E-mail address.              |
|             | har(60) | ersonal_info |                              |
+-------------+---------+--------------+------------------------------+
| *           | char(1) | eng_ant      | **Not used.**                |
| *emission** |         |              |                              |
+-------------+---------+--------------+------------------------------+
| **emiss     | varc    | eng_emission | Aural emission designator    |
| ion_aural** | har(10) |              | for the transmitter.         |
+-------------+---------+--------------+------------------------------+
| **emissi    | varc    | eng_emission | Visual emission designator   |
| on_visual** | har(10) |              | for the transmitter.         |
+-------------+---------+--------------+------------------------------+
| *           | int     | app_main     | Engineer code. Reference to  |
| *eng_code** |         |              | **pit_code** in              |
|             |         |              | personal_info table. See     |
|             |         |              | Note #1.                     |
+-------------+---------+--------------+------------------------------+
| **f         | int     | fac_main     | Facility Id Number           |
| ac_id_num** |         |              |                              |
+-------------+---------+--------------+------------------------------+
| **fac_reco  | char(5) | pub_not      | Status of facility. See      |
| rd_status** |         |              | **record_status.**           |
|             |         | pub_not_hist |                              |
+-------------+---------+--------------+------------------------------+
| *           | char(4) | app_main     | Type of facility within      |
| *fac_type** |         |              | service                      |
|             |         | fac_main     |                              |
|             |         |              | # ITFS                       |
|             |         |              |                              |
|             |         |              | "IF" -- Instructional        |
|             |         |              | television fixed service     |
|             |         |              |                              |
|             |         |              | "IFB" -- ITFS booster.       |
|             |         |              |                              |
|             |         |              | "IFC" -- ITFS response       |
|             |         |              | receiver.                    |
|             |         |              |                              |
|             |         |              | "IFD" -- ITFS developmental  |
|             |         |              |                              |
|             |         |              | "IFS" -- ITFS studio link.   |
|             |         |              |                              |
|             |         |              | # MDS                        |
|             |         |              |                              |
|             |         |              | "ICB" -- ITFS,ITFSX          |
|             |         |              | high-power booster.          |
|             |         |              |                              |
|             |         |              | "ICH" -- ITFS,ITFSX response |
|             |         |              | station hub                  |
|             |         |              |                              |
|             |         |              | "ICX" -- ITFS,ITFSX          |
|             |         |              | low-power booster.           |
|             |         |              |                              |
|             |         |              | "ICY" -- ITFS,ITFSX          |
|             |         |              | downstream I channel.        |
|             |         |              |                              |
|             |         |              | "IFB" -- ITFS high-power     |
|             |         |              | booster.                     |
|             |         |              |                              |
|             |         |              | "IFH" -- ITFS response       |
|             |         |              | station hub.                 |
|             |         |              |                              |
|             |         |              | "IFX" -- ITFS low-power      |
|             |         |              | booster.                     |
|             |         |              |                              |
|             |         |              | "IFY" -- ITFS downstream I   |
|             |         |              | channel.                     |
|             |         |              |                              |
|             |         |              | "MD" -- Multi-point          |
|             |         |              | distribution service.        |
|             |         |              |                              |
|             |         |              | "MDB" -- MDS booster.        |
|             |         |              |                              |
|             |         |              | "MDC" -- MDS commercial      |
|             |         |              | ITFS.                        |
|             |         |              |                              |
|             |         |              | "MDCB" -- MDS,ITFSX          |
|             |         |              | high-power booster.          |
|             |         |              |                              |
|             |         |              | "MDCH" -- MDS,ITFSX response |
|             |         |              | station hub.                 |
|             |         |              |                              |
|             |         |              | "MDCX" -- MDS,ITFSX          |
|             |         |              | low-power booster.           |
|             |         |              |                              |
|             |         |              | "MDCY" -- MDS,ITFSX          |
|             |         |              | downstream I channel.        |
|             |         |              |                              |
|             |         |              | "MDH" -- MDS response        |
|             |         |              | station hub.                 |
|             |         |              |                              |
|             |         |              | "MDIB" -- MDS,ITFS           |
|             |         |              | high-power booster.          |
|             |         |              |                              |
|             |         |              | "MDIH" -- MDS,ITFS response  |
|             |         |              | station hub.                 |
|             |         |              |                              |
|             |         |              | "MDIX" -- MDS,ITFS low-power |
|             |         |              | booster.                     |
|             |         |              |                              |
|             |         |              | "MDIY" -- MDS,ITFS           |
|             |         |              | downstream I channel.        |
|             |         |              |                              |
|             |         |              | "MDV" -- MDS developmental.  |
|             |         |              |                              |
|             |         |              | "MDX" -- MDS low-power       |
|             |         |              | booster.                     |
|             |         |              |                              |
|             |         |              | "MDY" -- MDS downstream I    |
|             |         |              | channel.                     |
|             |         |              |                              |
|             |         |              | "MICB" -- MDS,ITFS,ITFSX     |
|             |         |              | high-power booster.          |
|             |         |              |                              |
|             |         |              | "MICH" -- MDS,ITFS,ITFSX     |
|             |         |              | response station hub.        |
|             |         |              |                              |
|             |         |              | "MICX" -- MDS,ITFS,ITFSX     |
|             |         |              | low-power booster.           |
|             |         |              |                              |
|             |         |              | "MICY" -- MDS,ITFS,ITFSX     |
|             |         |              | downstream I channel.        |
+-------------+---------+--------------+------------------------------+
| **fax**     | c       | p            | Fax telephone number.        |
|             | har(10) | ersonal_info |                              |
+-------------+---------+--------------+------------------------------+
| **fi        | char(8) | app_main     | First 8 positions of the     |
| le_prefix** |         |              | file number: Derived from    |
|             |         |              | letter "B" + new_app_type +  |
|             |         |              | fac_type.                    |
+-------------+---------+--------------+------------------------------+
| **f         | char(1) | eng_coords   | "M" = Marker (NAD27) "S" =   |
| lag_27_83** |         |              | Satellite (NAD83)            |
+-------------+---------+--------------+------------------------------+
| **fl        | char(1) | ch           | Indicates if specific row is |
| ag_active** |         | an_freq_list | used.                        |
|             |         |              |                              |
|             |         | code_list    |                              |
+-------------+---------+--------------+------------------------------+
| **fla       | char(1) | pub_not      | "A" -- Application public    |
| g_app_act** |         |              | notice.                      |
|             |         | pub_not_hist |                              |
|             |         |              | "C" -- Action public notice. |
+-------------+---------+--------------+------------------------------+
| **f         | char(1) | app_main     | Flag indicating application  |
| lag_audit** |         |              | chosen for random audit.     |
+-------------+---------+--------------+------------------------------+
| **flag      | char(1) | fac_bta_pbta | Indicates whether row        |
| _bta_pbta** |         |              | represents a BTA or          |
|             |         |              | partitioned BTA.             |
+-------------+---------+--------------+------------------------------+
| **flag_cc** | char(1) | app_main     | Used to identify common      |
|             |         |              | carriers.                    |
|             |         | fac_main     |                              |
+-------------+---------+--------------+------------------------------+
| **flag_cr   | char(1) | a            | Indicator for receiver       |
| oss_plane** |         | nt_rpatterns | antenna patterns.            |
+-------------+---------+--------------+------------------------------+
| **fla       | char(1) | app_main     | Used to identify current     |
| g_current** |         |              | status of application        |
|             |         |              | relative to all applications |
|             |         |              | for facility. See Note #2.   |
|             |         |              |                              |
|             |         |              | "A" -- Archived (No current  |
|             |         |              | use).                        |
|             |         |              |                              |
|             |         |              | "C" -- Certified.            |
|             |         |              |                              |
|             |         |              | "M" -- Granted but not       |
|             |         |              | certified.                   |
|             |         |              |                              |
|             |         |              | "P" -- Pending.              |
|             |         |              |                              |
|             |         |              | "L" -- Current               |
|             |         |              | ceritfication.               |
+-------------+---------+--------------+------------------------------+
| **flag      | char(1) | eng_emission | "A" -- Analog.               |
| _emission** |         |              |                              |
|             |         |              | "D" -- Digital.              |
+-------------+---------+--------------+------------------------------+
| **          | char(1) | app_main     | Indicates application has    |
| flag_hold** |         |              | been placed on hold.         |
+-------------+---------+--------------+------------------------------+
| *           | char(1) | p            | "A" -- Attorney              |
| *flag_job** |         | ersonal_info |                              |
|             |         |              | "E" -- Engineer              |
|             |         |              |                              |
|             |         |              | "L" -- Licensee              |
|             |         |              |                              |
|             |         |              | "P" -- Permittee             |
|             |         |              |                              |
|             |         |              | "R" -- Contact               |
|             |         |              | Representative.              |
|             |         |              |                              |
|             |         |              | All other values are FCC     |
|             |         |              | internal.                    |
+-------------+---------+--------------+------------------------------+
| **fla       | char(1) | eng_coords   | "L" -- TX/RX site location   |
| g_loc_pro** |         |              | record.                      |
|             |         |              |                              |
|             |         |              | "P" -- Center of protected   |
|             |         |              | service area.                |
+-------------+---------+--------------+------------------------------+
| **f         | char(1) | app_main     | Indicates major              |
| lag_major** |         |              | modification.                |
+-------------+---------+--------------+------------------------------+
| **flag_mx** | char(1) | app_main     | Indicates application is     |
|             |         |              | mutually exclusive with one  |
|             |         |              | or more other applications.  |
+-------------+---------+--------------+------------------------------+
| **          | char(1) | eng_ant      | Indicates omni / directional |
| flag_omni** |         |              | antenna.                     |
+-------------+---------+--------------+------------------------------+
| **          | char(1) | bta_list     | Indicates if BTA is          |
| flag_pbta** |         |              | partitioned.                 |
+-------------+---------+--------------+------------------------------+
| **f         | char(1) | eng_location | **Not used.**                |
| lag_pre83** |         |              |                              |
+-------------+---------+--------------+------------------------------+
| **fla       | char(1) | eng_location | Indicates protected area.    |
| g_protect** |         |              |                              |
+-------------+---------+--------------+------------------------------+
| **fla       | char(1) | pub_not      | Indicates if application is  |
| g_renewal** |         |              | a renewal.                   |
|             |         | pub_not_hist |                              |
+-------------+---------+--------------+------------------------------+
| **          | char(1) | pub_not      | Indicates whether the        |
| flag_sent** |         |              | application/action is to     |
|             |         | pub_not_hist | appear on public notice.     |
+-------------+---------+--------------+------------------------------+
| **f         | char(1) | eng_ant      | "T" -- Transmitter site      |
| lag_tx_rx** |         |              |                              |
|             |         | eng_coords   | "R" -- Receiver site         |
|             |         |              |                              |
|             |         | eng_location | "X" -- Response site         |
+-------------+---------+--------------+------------------------------+
| **flag_uq** | char(1) | a            | Indicates whether condition  |
|             |         | pp_spec_cond | is unique to application or  |
|             |         |              | "canned."                    |
+-------------+---------+--------------+------------------------------+
| **          | int     | t            | From attorney --             |
| fm_att_id** |         | ransfer_ctrl | **pit_code.**                |
+-------------+---------+--------------+------------------------------+
| **          | int     | t            | From licensee --             |
| fm_pit_id** |         | ransfer_ctrl | **pit_code.**                |
+-------------+---------+--------------+------------------------------+
| **form_id** | int     | app_main     | Each type of form has a form |
|             |         |              | ID number assigned to it.    |
+-------------+---------+--------------+------------------------------+
| **f         | c       | ch           | Lower bound of frequency     |
| req_lower** | har(17) | an_freq_list | range.                       |
+-------------+---------+--------------+------------------------------+
| **f         | c       | ch           | Upper bound of frequency     |
| req_upper** | har(17) | an_freq_list | range.                       |
+-------------+---------+--------------+------------------------------+
| **gain**    | float   | a            | The ratio of output power to |
|             |         | nt_rpatterns | input power of the antenna,  |
|             |         |              | in dBi.                      |
+-------------+---------+--------------+------------------------------+
| *           | float   | eng_location | Ground elevation above mean  |
| *grd_elev** |         |              | sea level.                   |
+-------------+---------+--------------+------------------------------+
| *           | int     | app_mx       | Identifier of mutually       |
| *group_id** |         |              | exclusive group of           |
|             |         |              | applications.                |
+-------------+---------+--------------+------------------------------+
| **g         | char(2) | c            | Channel group identifier.    |
| roup_name** |         | hannel_group |                              |
+-------------+---------+--------------+------------------------------+
| **h_count** | int     | cal          | Count of hubs for this       |
|             |         | lsign_suffix | callsign                     |
+-------------+---------+--------------+------------------------------+
| **h         | float   | eng_ant      | Height of the antenna center |
| gt_rcamsl** |         |              | of radiation above mean sea  |
|             |         |              | level                        |
+-------------+---------+--------------+------------------------------+
| **h         | float   | eng_location | Overall height of antenna    |
| gt_struct** |         |              | structure.                   |
+-------------+---------+--------------+------------------------------+
| **i_count** | int     | cal          | Count of I channels for this |
|             |         | lsign_suffix | callsign.                    |
+-------------+---------+--------------+------------------------------+
| **i         | int     | app_amend    | System-generated key that    |
| d_app_num** |         |              | uniquely identifies an       |
|             |         | app_address  | application. This key is the |
|             |         |              | link to all tables           |
|             |         | app_main     | associated with              |
|             |         |              | applications.                |
|             |         | app_mx       |                              |
|             |         |              |                              |
|             |         | app_purp     |                              |
|             |         |              |                              |
|             |         | a            |                              |
|             |         | pp_spec_cond |                              |
|             |         |              |                              |
|             |         | as           |                              |
|             |         | soc_callsign |                              |
|             |         |              |                              |
|             |         | booster      |                              |
|             |         |              |                              |
|             |         | eng_ant      |                              |
|             |         |              |                              |
|             |         | eng_chan     |                              |
|             |         |              |                              |
|             |         | eng_coords   |                              |
|             |         |              |                              |
|             |         | eng_emission |                              |
|             |         |              |                              |
|             |         | eng_location |                              |
|             |         |              |                              |
|             |         | fac_bta_pbta |                              |
|             |         |              |                              |
|             |         | pub_not      |                              |
|             |         |              |                              |
|             |         | pub_not_hist |                              |
|             |         |              |                              |
|             |         | status       |                              |
|             |         |              |                              |
|             |         | t            |                              |
|             |         | ransfer_ctrl |                              |
|             |         |              |                              |
|             |         | uq_txt_list  |                              |
+-------------+---------+--------------+------------------------------+
| **id_ap     | int     | bta_list     | **id_app_num** of form 304.  |
| p_num_304** |         |              |                              |
+-------------+---------+--------------+------------------------------+
| **id_ap     | int     | bta_list     | **id_app_num** of Statement  |
| p_num_soi** |         |              | of Intention.                |
+-------------+---------+--------------+------------------------------+
| **i         | int     | bta_county   | BTA identifier.              |
| d_bta_num** |         |              |                              |
|             |         | bta_list     |                              |
|             |         |              |                              |
|             |         | fac_bta_pbta |                              |
+-------------+---------+--------------+------------------------------+
| **i         | int     | app_main     | System generated key that    |
| d_fac_num** |         |              | uniquely identifies a        |
|             |         | as           | facility.                    |
|             |         | soc_callsign |                              |
|             |         |              |                              |
|             |         | eng_location |                              |
|             |         |              |                              |
|             |         | fac_bta_pbta |                              |
|             |         |              |                              |
|             |         | fac_main     |                              |
|             |         |              |                              |
|             |         | pub_not      |                              |
|             |         |              |                              |
|             |         | pub_not_hist |                              |
|             |         |              |                              |
|             |         | status       |                              |
|             |         |              |                              |
|             |         | t            |                              |
|             |         | ransfer_ctrl |                              |
+-------------+---------+--------------+------------------------------+
| **id_srv**  | char(2) | a            | "MD" -- Multi-point          |
|             |         | nt_rpatterns | Distribution Service.        |
|             |         |              |                              |
|             |         | a            | "VX" -- Instructional        |
|             |         | nt_tpatterns | Television Fixed Service.    |
|             |         |              |                              |
|             |         | app_main     |                              |
|             |         |              |                              |
|             |         | chan_a       |                              |
|             |         | djacent_list |                              |
|             |         |              |                              |
|             |         | ch           |                              |
|             |         | an_freq_list |                              |
|             |         |              |                              |
|             |         | fac_main     |                              |
|             |         |              |                              |
|             |         | txt_list     |                              |
+-------------+---------+--------------+------------------------------+
| **latdeg**  | int     | eng_coords   | Reference point, latitude    |
|             |         |              | degrees.                     |
+-------------+---------+--------------+------------------------------+
| **latdir**  | char(1) | eng_coords   | Reference point, latitude    |
|             |         |              | hemisphere.                  |
+-------------+---------+--------------+------------------------------+
| *           | real    | border       | Reference point, latitude in |
| *latitude** |         |              | decimal seconds.             |
+-------------+---------+--------------+------------------------------+
| **latmin**  | int     | eng_coords   | Reference point, latitude    |
|             |         |              | minutes.                     |
+-------------+---------+--------------+------------------------------+
| **latsec**  | int     | eng_coords   | Reference point, latitude    |
|             |         |              | seconds.                     |
+-------------+---------+--------------+------------------------------+
| *           | int     | fac_main     | Licensee code. Reference to  |
| *lic_code** |         |              | **pit_code** in              |
|             |         |              | personal_info table. See     |
|             |         |              | Note #1.                     |
+-------------+---------+--------------+------------------------------+
| *           | int     | txt_list     | Sequential order of lines    |
| *line_seq** |         |              | within the body of a         |
|             |         | uq_txt_list  | comment.                     |
+-------------+---------+--------------+------------------------------+
| **londeg**  | int     | eng_coords   | Reference point, longitude   |
|             |         |              | degrees.                     |
+-------------+---------+--------------+------------------------------+
| **londir**  | char(1) | eng_coords   | Reference point, longitude   |
|             |         |              | hemisphere.                  |
+-------------+---------+--------------+------------------------------+
| **          | real    | border       | Reference point, longitude   |
| longitude** |         |              | in decimal seconds.          |
+-------------+---------+--------------+------------------------------+
| **lonmin**  | int     | eng_coords   | Reference point, longitude   |
|             |         |              | minutes.                     |
+-------------+---------+--------------+------------------------------+
| **lonsec**  | int     | eng_coords   | Reference point, longitude   |
|             |         |              | seconds.                     |
+-------------+---------+--------------+------------------------------+
| **mai       | int     | booster      | **id_fac_num** of the        |
| n_fac_num** |         |              | facility being boosted.      |
+-------------+---------+--------------+------------------------------+
| **make**    | c       | a            | The manufacturer of an       |
|             | har(20) | nt_rpatterns | antenna.                     |
|             |         |              |                              |
|             |         | a            |                              |
|             |         | nt_tpatterns |                              |
+-------------+---------+--------------+------------------------------+
|             | char(3) | eng_ant      | the manufacturer of an       |
|             |         |              | antenna                      |
+-------------+---------+--------------+------------------------------+
| **model**   | c       | a            | The model number of an       |
|             | har(20) | nt_rpatterns | antenna.                     |
|             |         |              |                              |
|             |         | a            |                              |
|             |         | nt_tpatterns |                              |
|             |         |              |                              |
|             |         | eng_ant      |                              |
+-------------+---------+--------------+------------------------------+
| **modula    | varc    | eng_emission | Modulation type.             |
| tion_type** | har(20) |              |                              |
+-------------+---------+--------------+------------------------------+
| *           | int     | app_main     | Number of months authorized  |
| *months_to_ |         |              | for construction.            |
| construct** |         |              |                              |
+-------------+---------+--------------+------------------------------+
| **name**    | varc    | app_address  | Mailing address name.        |
|             | har(60) |              |                              |
|             |         | p            |                              |
|             |         | ersonal_info |                              |
+-------------+---------+--------------+------------------------------+
| **ne        | c       | app_main     | Application Reference        |
| w_app_arn** | har(12) |              | Number.                      |
+-------------+---------+--------------+------------------------------+
| **new       | char(5) | app_main     | Types of applications:       |
| _app_type** |         |              |                              |
|             |         |              | "AL" -- Assignment of        |
|             |         |              | License.                     |
|             |         |              |                              |
|             |         |              | "AP" -- Assignment of        |
|             |         |              | Permit.                      |
|             |         |              |                              |
|             |         |              | "C" -- Initial certification |
|             |         |              | of license.                  |
|             |         |              |                              |
|             |         |              | "E" -- Extension of time     |
|             |         |              | request.                     |
|             |         |              |                              |
|             |         |              | "L" -- Initial certification |
|             |         |              | of license.                  |
|             |         |              |                              |
|             |         |              | "LMA" -- Major amendment to  |
|             |         |              | licensed facility.           |
|             |         |              |                              |
|             |         |              | "LNA" -- Minor amendment to  |
|             |         |              | licensed facility.           |
|             |         |              |                              |
|             |         |              | "LMP" -- Major modification  |
|             |         |              | to licensed facility.        |
|             |         |              |                              |
|             |         |              | "LNP" -- Minor modification  |
|             |         |              | to licensed facility.        |
|             |         |              |                              |
|             |         |              | "MA" -- Major amendment to   |
|             |         |              | pending permit.              |
|             |         |              |                              |
|             |         |              | "MC" -- Certification of     |
|             |         |              | license.                     |
|             |         |              |                              |
|             |         |              | "ML" -- Certification of     |
|             |         |              | license.                     |
|             |         |              |                              |
|             |         |              | "MP" -- Major modification   |
|             |         |              | of granted permit.           |
|             |         |              |                              |
|             |         |              | "NA" -- Minor amendment to   |
|             |         |              | pending permit.              |
|             |         |              |                              |
|             |         |              | "NP" -- Minor modification   |
|             |         |              | of granted permit.           |
|             |         |              |                              |
|             |         |              | "P" -- Construction Permit.  |
|             |         |              |                              |
|             |         |              | "R" -- Renewal of license.   |
|             |         |              |                              |
|             |         |              | "S" -- Statement of          |
|             |         |              | Intention.                   |
|             |         |              |                              |
|             |         |              | "STA" -- Special temporary   |
|             |         |              | authority."                  |
|             |         |              |                              |
|             |         |              | "TC" -- Transfer of control. |
+-------------+---------+--------------+------------------------------+
| **ne        | varc    | status       | Contents depend on           |
| w_content** | har(60) |              | **code_type/code**.          |
|             |         |              |                              |
|             |         |              | "AC/REPLC" -- **id_app_num** |
|             |         |              | of the amendment which       |
|             |         |              | replaced this application.   |
|             |         |              |                              |
|             |         |              | "AS/ACCPT" -- For amendments |
|             |         |              | only, previous application   |
|             |         |              | type.                        |
|             |         |              |                              |
|             |         |              | "PN/ACT" -- Action public    |
|             |         |              | notice report number.        |
|             |         |              |                              |
|             |         |              | "PN/APP" -- Application      |
|             |         |              | public notice report number. |
|             |         |              |                              |
|             |         |              | "TC/ENG" -- **pit_code** of  |
|             |         |              | new FCC engineer.            |
|             |         |              |                              |
|             |         |              | "TC/LAW" -- **pit_code** of  |
|             |         |              | new FCC attorney.            |
|             |         |              |                              |
|             |         |              | "UPD/CONDT" -- **pit_code**  |
|             |         |              | of new licensee.             |
|             |         |              |                              |
|             |         |              | "UPD/CSIGN" -- new call      |
|             |         |              | sign.                        |
+-------------+---------+--------------+------------------------------+
| **offset**  | char(1) | eng_chan     | Frequency offset expressed   |
|             |         |              | as plus, minus, or zero.     |
+-------------+---------+--------------+------------------------------+
| **ol        | varc    | status       | Contents depend on           |
| d_content** | har(60) |              | **code_type/code.**          |
|             |         |              |                              |
|             |         |              | "AS/ACCPT" -- For amendments |
|             |         |              | only. New application type.  |
|             |         |              |                              |
|             |         |              | "TC/ENG" -- **pit_code** of  |
|             |         |              | old FCC engineer.            |
|             |         |              |                              |
|             |         |              | "TC/LAW" -- **pit_code** of  |
|             |         |              | old FCC attorney.            |
|             |         |              |                              |
|             |         |              | "UPD/CONDT" -- **pit_code**  |
|             |         |              | of old licensee.             |
|             |         |              |                              |
|             |         |              | "UPD/CSIGN" -- old call      |
|             |         |              | sign.                        |
+-------------+---------+--------------+------------------------------+
| **phone**   | varc    | p            | Telephone number.            |
|             | har(20) | ersonal_info |                              |
+-------------+---------+--------------+------------------------------+
| *           | int     | p            | Personal_info table          |
| *pit_code** |         | ersonal_info | identifying code. See Note   |
|             |         |              | #1.                          |
+-------------+---------+--------------+------------------------------+
| **polar**   | char(1) | eng_ant      | The direction of the         |
|             |         |              | electrical field radiated    |
|             |         |              | from the antenna.            |
+-------------+---------+--------------+------------------------------+
| *           | char(4) | eng_location | Used to indicate type of     |
| *pro_area** |         |              | protected area:              |
|             |         |              |                              |
|             |         |              | "P35" -- 35 mile protected   |
|             |         |              | area.                        |
|             |         |              |                              |
|             |         |              | "BTA" -- Basic Trading Area. |
+-------------+---------+--------------+------------------------------+
| **          | float   | a            | Signal strength adjustment   |
| radiation** |         | nt_tpatterns | factor for specific azimuth. |
+-------------+---------+--------------+------------------------------+
| **reco      | char(5) | app_main     | Record status of the         |
| rd_status** |         |              | facility, application or     |
|             |         | fac_main     | amendment.                   |
|             |         |              |                              |
|             |         | t            | # Facility                   |
|             |         | ransfer_ctrl |                              |
|             |         |              | "APCAN" -- Original permit   |
|             |         |              | application cancelled.       |
|             |         |              |                              |
|             |         |              | "APDEN" -- Original permit   |
|             |         |              | application denied.          |
|             |         |              |                              |
|             |         |              | "APDIS" -- Original permit   |
|             |         |              | application dismissed.       |
|             |         |              |                              |
|             |         |              | "APRET" -- Original permit   |
|             |         |              | application returned.        |
|             |         |              |                              |
|             |         |              | "CONDL" -- Conditional       |
|             |         |              | license.                     |
|             |         |              |                              |
|             |         |              | "CPAPP" -- Construction      |
|             |         |              | permit applied for.          |
|             |         |              |                              |
|             |         |              | "LFORF" -- License           |
|             |         |              | forfeited.                   |
|             |         |              |                              |
|             |         |              | "LICAN" -- License           |
|             |         |              | cancelled.                   |
|             |         |              |                              |
|             |         |              | "LICEN" -- Licensed.         |
|             |         |              |                              |
|             |         |              | "PFORF" -- Permit forfeited. |
|             |         |              |                              |
|             |         |              | "PRCAN" -- Permit cancelled. |
|             |         |              |                              |
|             |         |              | # Application/Amendment      |
|             |         |              |                              |
|             |         |              | "ACCPT" -- Accepted.         |
|             |         |              |                              |
|             |         |              | "APCAN" -- Cancelled.        |
|             |         |              |                              |
|             |         |              | "APDEN" -- Denied.           |
|             |         |              |                              |
|             |         |              | "APDIS" -- Dismissed.        |
|             |         |              |                              |
|             |         |              | "APRET" -- Returned.         |
|             |         |              |                              |
|             |         |              | "GRANT" -- Granted.          |
|             |         |              |                              |
|             |         |              | "REPLC" -- Replaced (by an   |
|             |         |              | amendment).                  |
|             |         |              |                              |
|             |         |              | "TENDR" -- Tendered.         |
+-------------+---------+--------------+------------------------------+
| **re        | c       | app_main     | Application reference number |
| f_app_arn** | har(12) |              | of application referenced by |
|             |         |              | this amendment.              |
+-------------+---------+--------------+------------------------------+
| **ref_i     | int     | app_main     | Id_app_num of the            |
| d_app_num** |         |              | **ref_app_arn.**             |
+-------------+---------+--------------+------------------------------+
| *           | int     | app_main     | Application representative   |
| *rep_code** |         |              | code. Reference to           |
|             |         |              | **pit_code** in              |
|             |         |              | personal_info table. See     |
|             |         |              | Note #1.                     |
+-------------+---------+--------------+------------------------------+
| **seq_num** | int     | a            | Sequential order of          |
|             |         | pp_spec_cond | conditions.                  |
+-------------+---------+--------------+------------------------------+
|             |         | as           | Sequential order of          |
|             |         | soc_callsign | associated call signs. 1     |
|             |         |              | indicates lead call sign.    |
+-------------+---------+--------------+------------------------------+
|             |         | booster      | Sequential order of booster  |
|             |         |              | assignments.                 |
+-------------+---------+--------------+------------------------------+
| **          | char(3) | fac_main     | "BA", "BS" or null.          |
| sta_class** |         |              |                              |
+-------------+---------+--------------+------------------------------+
| **state**   | char(2) | app_address  | Address state.               |
|             |         |              |                              |
|             |         | p            |                              |
|             |         | ersonal_info |                              |
+-------------+---------+--------------+------------------------------+
| **street    | varc    | p            | Mailing address street       |
| _address1** | har(60) | ersonal_info | address line 1.              |
+-------------+---------+--------------+------------------------------+
| **street    | varc    | p            | Mailing address street       |
| _address2** | har(60) | ersonal_info | address line 2.              |
+-------------+---------+--------------+------------------------------+
| **title**   | varc    | p            | Title used with name.        |
|             | har(60) | ersonal_info |                              |
+-------------+---------+--------------+------------------------------+
| **          | int     | t            | To attorney -- **pit_code.** |
| to_att_id** |         | ransfer_ctrl |                              |
+-------------+---------+--------------+------------------------------+
| **          | int     | t            | To licensee -- **pit_code.** |
| to_pit_id** |         | ransfer_ctrl |                              |
+-------------+---------+--------------+------------------------------+
| *           | c       | eng_location | Antenna Site Registration    |
| *tower_id** | har(12) |              | number (ASRN).               |
+-------------+---------+--------------+------------------------------+
| **          | int     | eng_ant      | Numeric identifier of        |
| tower_num** |         |              | transmitter/receiver tower   |
|             |         | eng_chan     |                              |
|             |         |              |                              |
|             |         | eng_coords   |                              |
|             |         |              |                              |
|             |         | eng_emission |                              |
|             |         |              |                              |
|             |         | eng_location |                              |
+-------------+---------+--------------+------------------------------+
| **zip1**    | char(5) | p            | Mailing address zip code,    |
|             |         | ersonal_info | first 5 characters.          |
+-------------+---------+--------------+------------------------------+
| **zip2**    | char(4) | p            | Mailing address zip code,    |
|             |         | ersonal_info | last 4 characters.           |
+-------------+---------+--------------+------------------------------+

**NOTES:**

1.  The personal_info table contains entries for individual companies,
    firms and persons. Each entry contains the mailing address, phone,
    fax, e-mail address, etc. The entries are identified by a system
    generated number---**lic_code.** The pointers to this table identify
    the relationship (licensee, attorney, etc.) between the facility or
    application and the individual entries in this table. For example,
    the **app_code** column in the app_main table identifies the
    applicant by pointing to the appropriate **lic_code** in the
    personal_info table.

2.  The **current_flag** is used to determine the so-called "alpha"
    application for a facility. This application has associated with it
    (through the **id_app_num** column) the engineering information that
    is currently defined for that facility. The procedure is as follows:

```{=html}
<!-- -->
```
a.  The application with a **current_flag** of "C" is the "alpha"
    application.

b.  If there is no "C" application, the application with a
    **current_flag** of "M" is the "alpha" application.

c.  If there is neither a "C" or an "M" application, the "alpha"
    application is the pending permit.