File: readme.html (for CDBS)

Update : 07/26/2013
Release Notes: See the end of this file.

This is readme file for the publicly released files under CDBS.
This file will be updated as needed.

CDBS is the Consolidated Database System for the FCC's Media Bureau.
CDBS is a relational database; the field application_id is the primary key
which associates data elements for many of the various tables.

The public files under CDBS are available at:
http://www.fcc.gov/mb/databases/cdbs/
Normally, these files will be updated daily.

Each file, and the data elements they contain, as ordered in the file,
are listed below. In this list, char indicates a character field with
exactly the specified number of characters; varchar indicates a character
field with up to the specified number of characters. In addition, there
are several user-defined field types. These are listed at the bottom
of this document.

A more descriptive listing of the data elements is in:
ftp://ftp.fcc.gov/pub/Bureaus/MB/Databases/cdbs/_Engineering_Data_Description.pdf
This PDF document describes the fields in each table in
alphabetical order, not the order as they appear in the data files.
The fields in each file are pipe-delimited ("|").

The files have been compressed on a Unix system with zip (-l option).
They can be unzipped on a PC using PKUNZIP, WINZip, or similar utilities.

The main table for FM engineering data is fm_eng_data.
The field eng_record_type can either be 'C' (current records) or
'A' (archived or superceded records). There is a similar marker for AM
data in table am_ant_sys. AM data are also located in am_eng_data.

Ownership information can be located through the party table. The app_party
and fac_party tables hold the associated party_id key.

Questions and corrections concerning the CDBS data should be directed to:

AM & FM Radio
Using CDBS data: Jorden Brinn, jorden.brinn@fcc.gov
Other CDBS questions: James Bradshaw, james.bradshaw@fcc.gov

TV
All CDBS questions: Hossein Hashemzadeh, hossein.hashemzadeh@fcc.gov


******************************************************************************
******************************************************************************
CDBS TABLES
*****************************************************************************
******************************************************************************

am_ant_sys
No.    Column Name               Type
 ------ ------------------------- ------------------------------
 (1)    ant_mode                  char(3)
 (2)    ant_sys_id                int, NOT NULL
 (3)    application_id            int, NOT NULL
 (4)    aug_count                 tinyint
 (5)    bad_data_switch           char(1)
 (6)    domestic_pattern          char(1)
 (7)    dummy_data_switch         char(1)
 (8)    efficiency_restricted     float()
 (9)    efficiency_theoretical    float()
 (10)   feed_circ_other           varchar(255)
 (11)   feed_circ_type            char(2)
 (12)   hours_operation           char(1), NOT NULL
 (13)   lat_deg                   int
 (14)   lat_dir                   char(1)
 (15)   lat_min                   int
 (16)   lat_sec                   float()
 (17)   lon_deg                   int
 (18)   lon_dir                   char(1)
 (19)   lon_min                   int
 (20)   lon_sec                   float()
 (21)   q_factor                  float()
 (22)   q_factor_custom_ind       ind
 (23)   power                     float()
 (24)   rms_augmented             float()
 (25)   rms_standard              float()
 (26)   rms_theoretical           float()
 (27)   tower_count               tinyint
 (28)   eng_record_type           char(1)
 (29)   biased_lat                float()
 (30)   biased_long               float()
 (31)   mainkey                   char(16)
 (32)   am_dom_status             char(1)
 (33)   lat_whole_secs            int
 (34)   lon_whole_secs            int
 (35)   ant_dir_ind               char(1)
 (36)   grandfathered_ind         char(1)
 (37)   specified_hrs_range       varchar(25)
 (38)   augmented_ind             char(1)
 (39)   last_update_date          datetime
 
am_augs
 No.    Column Name               Type
 ------ ------------------------- ------------------------------
 (1)    ant_sys_id                int, NOT NULL
 (2)    aug_id                    tinyint, NOT NULL
 (3)    azimuth_deg               float()
 (4)    radiation_aug             float()
 (5)    span_deg                  float()
 (6)    last_update_date          datetime
 
am_eng_data
 No.    Column Name               Type
 ------ ------------------------- ------------------------------
 (1)    ant_monitor               name
 (2)    application_id            int, NOT NULL
 (3)    broadcast_schedule        char(1)
 (4)    encl_fence_dist           float()
 (5)    facility_id               int, NOT NULL
 (6)    sampl_sys_ind             ind
 (7)    station_class             char(1)
 (8)    time_zone                 char(1)
 (9)    region_2_class            char(1)
 (10)   am_dom_status             char(1)
 (11)   old_station_class         char(2)
 (12)   specified_hours           varchar(255)
 (13)   feed_circ_other           varchar(255)
 (14)   feed_circ_type            varchar(2)
 (15)   last_update_date          datetime
 
am_towers
 No.    Column Name               Type
 ------ ------------------------- ------------------------------
 (1)    ant_sys_id                int, NOT NULL
 (2)    asrn_id                   int
 (3)    elec_hgt_deg              float()
 (4)    field_ratio               float()
 (5)    hag_no_obst               float()
 (6)    hgt_overall_mtr           float()
 (7)    hgt_rad_ab                float()
 (8)    hgt_radiator_mtr          float()
 (9)    orientation_deg           float()
 (10)   phasing_deg               float()
 (11)   rad_hgt_deg               float()
 (12)   spacing_deg               float()
 (13)   top_loaded_switch         char(1)
 (14)   topload_a                 float()
 (15)   topload_b                 float()
 (16)   topload_c                 float()
 (17)   topload_d                 float()
 (18)   tower_num                 tinyint, NOT NULL
 (19)   tower_pl_codes            varchar(40)
 (20)   tower_ref_switch          char(1)
 (21)   asrn_na_ind               ind
 (22)   topload_apparent_hgt      float()
 (23)   faa_notified_ind          ind
 (24)   tower_type                char(1)
 (25)   last_update_date          datetime
 
 
 
amcmnts
 No.    Column Name               Type
 ------ ------------------------- ------------------------------
 (1)    application_id            int
 (2)    comment_type              char(5)
 (3)    comment                   varchar()
 
ant_make
 No.    Column Name               Type
 ------ ------------------------- ------------------------------
 (1)    antenna_id                int, NOT NULL
 (2)    ant_make                  char(3), NOT NULL
 (3)    ant_model_num             char(60), NOT NULL
 (4)    app_service               char(2), NOT NULL
 (5)    standard_ind              char(1)
 (6)    last_change_date          datetime
 
ant_pattern
 No.    Column Name               Type
 ------ ------------------------- ------------------------------
 (1)    antenna_id                int, NOT NULL
 (2)    azimuth                   float(), NOT NULL
 (3)    field_value               float(), NOT NULL
 (4)    additional_az_num         smallint
 (5)    last_change_date          datetime
 
app_party
 No.    Column Name               Type
 ------ ------------------------- ------------------------------
 (1)    application_id            int, NOT NULL
 (2)    party_id                  int, NOT NULL
 (3)    party_type                char(5), NOT NULL
 (4)    cert_title                title
 (5)    cert_date                 datetime
 (6)    other_fcc_id              int
 (7)    party_notify_ind          ind
 (8)    party_relationship        varchar(255)
 (9)    sig_present_ind           ind
 (10)   sig_name                  varchar(60)
 (11)   last_change_date          datetime
 
app_tracking
 No.    Column Name               Type
 ------ ------------------------- ------------------------------
 (1)    application_id            int, NOT NULL
 (2)    app_status_date           datetime
 (3)    cutoff_date               datetime
 (4)    cutoff_type               char(1)
 (5)    cp_exp_date               datetime
 (6)    app_status                varchar(5)
 (7)    dtv_checklist             varchar(1)
 (8)    amendment_stamped_date    datetime
 (9)    accepted_date             datetime
 (10)   tolling_code              char(1)
 (11)   last_change_date          datetime
 
application
 No.    Column Name               Type
 ------ ------------------------- ------------------------------
 (1)    app_arn                   arn
 (2)    app_service               char(2), NOT NULL
 (3)    application_id            int, NOT NULL
 (4)    facility_id               int, NOT NULL
 (5)    file_prefix               file_prefix
 (6)    comm_city                 city
 (7)    comm_state                state
 (8)    fac_frequency             float()
 (9)    station_channel           int
 (10)   fac_callsign              callsign
 (11)   general_app_service       varchar(2)
 (12)   app_type                  varchar(4)
 (13)   paper_filed_ind           char(1)
 (14)   dtv_type                  varchar(8)
 (15)   frn                       varchar(10)
 (16)   shortform_app_arn         varchar(12)
 (17)   shortform_file_prefix     varchar(10)
 (18)   corresp_ind               char(1)
 (19)   assoc_facility_id         int
 (20)   network_affil             varchar(100)
 (21)   sat_tv_ind                char(1)
 (22)   comm_county               char(20)
 (23)   comm_zip1                 char(5)
 (24)   comm_zip2                 char(4)
 (25)   last_change_date          datetime
 
call_sign_history
 No.    Column Name               Type
 ------ ------------------------- ------------------------------
 (1)    begin_date                datetime
 (2)    callsign                  callsign
 (3)    callsign_hist_id          int
 (4)    callsign_seq_id           tinyint, NOT NULL
 (5)    facility_id               int, NOT NULL
 (6)    record_change_date        datetime
 
dtv_agreement_group
 No.    Column Name               Type
 ------ ------------------------- ------------------------------
 (1)    application_id            int, NOT NULL
 (2)    fac_callsign              callsign
 (3)    facility_id               int
 (4)    order_num                 int
 (5)    dtv_agreement_group_id    int, NOT NULL
 (6)    name                      varchar(60)
 (7)    last_change_date          datetime
 
dtv_allotment
 No.    Column Name               Type
 ------ ------------------------- ------------------------------
 (1)    state                     state, NOT NULL
 (2)    city                      city, NOT NULL
 (3)    analog_channel            int
 (4)    digital_channel           int, NOT NULL
 (5)    erp                       float()
 (6)    haat                      float()
 (7)    lat_deg                   int
 (8)    lat_dir                   char(1)
 (9)    lat_min                   int
 (10)   lat_sec                   int
 (11)   lon_deg                   int
 (12)   lon_dir                   char(1)
 (13)   lon_min                   int
 (14)   lon_sec                   int
 (15)   biased_lat                float()
 (16)   biased_long               float()
 (17)   last_change_date          datetime
 
 
dtv_channel_assignments
No.    Column Name                        Type
------ ----------------------------------- ------------------------------
(1)   facility_id                        int, NOT NULL 
(2)   state                              char(2)
(3)   city                               char(20)
(4)   ntsc_channel                       int
(5)   post_dtv_channel                   int
(6)   erp                                float()
(7)   haat                               float()
(8)   antenna_id                         int
(9)   latitude                           char(7)
(10)  longitude                          char(8)
(11)  rcamsl                             int
(12)  ref_azimuth                        smallint
(13)  da_ind                             char(1)
(14)  pre_dtv_channel                    int
(15)  callsign                           varchar(12)
 
 
dtv_facility
 No.    Column Name               Type
 ------ ------------------------- ------------------------------
 (1)    facility_id               int, NOT NULL
 (2)    dtv_fac_status            char(5)
 (3)    dtv_channel               int
 (4)    last_change_date          datetime
 
dtv_transition
 No.    Column Name               Type
 ------ ------------------------- ------------------------------
 (1)    dtv_cur_channel           int
 (2)    application_id            int, NOT NULL
 (3)    dtv_cur_na                ind
 (4)    ntsc_cur_channel          int
 (5)    ntsc_cur_na               ind
 (6)    rep_max_cert              char(1)
 (7)    file_prefix_cer_a         char(10)
 (8)    app_arn_cer_a             char(12)
 (9)    file_prefix_cer_b         char(10)
 (10)   app_arn_cer_b             char(12)
 (11)   file_prefix_cer_d         char(10)
 (12)   app_arn_cer_d             char(12)
 (13)   rep_max_cer_type          char(3)
 (14)   file_prefix_cer_e         char(10)
 (15)   app_arn_cer_e             char(12)
 (16)   data_cert_ind             ind
 (17)   election                  char(1)
 (18)   elected_channel_a         int
 (19)   elected_channel_b         int
 (20)   alt_elected_channel       int
 (21)   intl_coord_ind            ind
 (22)   cont_election             char(1)
 (23)   cont_elected_channel      int
 (24)   conflict_decision         char(1)
 (25)   reference_no              int
 (26)   negot_agreemt_ind         ind
 (27)   tech_eng_ind              ind
 (28)   tent_chan_status          char(1)
 (29)   tentative_channel         int
 (30)   post_tran_dtv_channel     int
 (31)   pre_tran_dtv_channel      int
 (32)   post_tran_auth_file_prefix char(10)
 (33)   post_tran_auth_app_arn    char(12)
 (34)   post_tran_auth_not_yet_ind char(1)
 (35)   construction_deadline_dat datetime
 (36)   post_tran_operating_ind   char(1)
 (37)   op_status                 char(3)
 (38)   op_expected_date          datetime
 (39)   op_power_level            float()
 (40)   op_population_perc        float()
 (41)   construction_complete_ind char(1)
 (42)   expect_cons_complete_date datetime
 (43)   const_not_begun           char(1)
 (44)   const_underway            char(1)
 (45)   const_addl_needed         char(1)
 (46)   cp_status_ind             char(1)
 (47)   cp_mod_needed_ind         char(1)
 (48)   cp_mod_filed_ind          char(1)
 (49)   cp_mod_file_prefix        char(10)
 (50)   cp_mod_app_arn            char(12)
 (51)   cp_mod_filed_date         datetime
 (52)   cp_mod_expected_date      datetime
 (53)   addl_fcc_action_ind       char(1)
 (54)   addl_fcc_action_app_arn   char(12)
 (55)   addl_fcc_action_file_pref char(10)
 (56)   addl_fcc_action_date      datetime
 (57)   addl_intl_ind             char(1)
 (58)   addl_faa_approval_ind     char(1)
 (59)   addl_local_approval_ind   char(1)
 (60)   addl_equip_ind            char(1)
 (61)   addl_equip_new_ant_ind    char(1)
 (62)   addl_equip_adj_ant_ind    char(1)
 (63)   addl_equip_switch_ant_ind char(1)
 (64)   addl_equip_new_trans_ind  char(1)
 (65)   addl_equip_adj_trans_ind  char(1)
 (66)   addl_equip_gen_install_ind char(1)
 (67)   addl_equip_other_ind      char(1)
 (68)   addl_tower_ind            char(1)
 (69)   addl_coord_ind            char(1)
 (70)   addl_other_ind            char(1)
 (71)   analog_service_status     varchar(12)
 (72)   analog_status_ind         char(1)
 (73)   dtv_transition_plan_ind   char(1)
 (74)   addl_steps_ind            char(1)
 (75)   analog_nightlight_ind     char(1)
 (76)   analog_turnoff_pn_compl_flg char(1)
 (77)   binding_termination_flg   varchar(5)
 (78)   termination_date_not_aff  datetime
 (79)   termination_date_aff      datetime
 (80)   aff_term_cert_flg         varchar(5)
 (81)   cont_analog_flg           varchar(5)
 (82)   phone_help_ctr_flg        varchar(5)
 (83)   walkin_help_ctr_flg       varchar(5)
 (84)   st_analog_nightlight_ind  char(1)
 (85)   st_analog_nightlight_end_ datetime
 (86)   inf_analog_nightlight_ind char(1)
 (87)   inf_analog_nightlight_end datetime
 (88)   early_term_withdraw_ind   char(1)
 (89)   termination_time_0612_flg varchar(5)
 (90)   termination_date_nce      datetime
 (91)   termination_time_nce_flg  varchar(5)
 (92)   termination_time_notaff_flg varchar(5)
 (93)   termination_time_aff_flg  varchar(5)
 (94)   nce_term_cert_flg         char(1)
 (95)   ref_contact_phone         char(10)
 (96)   ref_contact_hours         varchar(60)
 (97)   an_participation_notice_ind char(1)
 (98)   an_eligibility_showing_ind char(1)
 (99)   an_objection_to_elig_showg_ind char(1)
 (100)  an_objection_callsign     char(12)
 (101)  an_revocation_ind         char(1)
 (102)  last_update_date          datetime
 
 
 
elevation_ant_make
 No.    Column Name                         Type
 ------ ----------------------------------- ------------------------------
 (1)    ant_make                            char(3), NOT NULL
 (2)    ant_model_num                       char(60), NOT NULL
 (3)    elevation_antenna_id                int, NOT NULL
 (4)    ant_comment                         varchar(255)
 
 
elevation_pattern
 No.    Column Name                         Type
 ------ ----------------------------------- ------------------------------
 (1)    depression_angle                    float(), NOT NULL
 (2)    field_value                         float()
 (3)    field_value0                        float()
 (4)    field_value10                       float()
 (5)    field_value20                       float()
 (6)    field_value30                       float()
 (7)    field_value40                       float()
 (8)    field_value50                       float()
 (9)    field_value60                       float()
 (10)   field_value70                       float()
 (11)   field_value80                       float()
 (12)   field_value90                       float()
 (13)   field_value100                      float()
 (14)   field_value110                      float()
 (15)   field_value120                      float()
 (16)   field_value130                      float()
 (17)   field_value140                      float()
 (18)   field_value150                      float()
 (19)   field_value160                      float()
 (20)   field_value170                      float()
 (21)   field_value180                      float()
 (22)   field_value190                      float()
 (23)   field_value200                      float()
 (24)   field_value210                      float()
 (25)   field_value220                      float()
 (26)   field_value230                      float()
 (27)   field_value240                      float()
 (28)   field_value250                      float()
 (29)   field_value260                      float()
 (30)   field_value270                      float()
 (31)   field_value280                      float()
 (32)   field_value290                      float()
 (33)   field_value300                      float()
 (34)   field_value310                      float()
 (35)   field_value320                      float()
 (36)   field_value330                      float()
 (37)   field_value340                      float()
 (38)   field_value350                      float()
 (39)   elevation_antenna_id                int, NOT NULL
 (40)   last_update_date                    datetime
 
elevation_pattern_addl
No.    Column Name                         Type
 ------ ----------------------------------- ------------------------------
 (1)    site_number                         tinyint, NOT NULL
 (2)    depression_angle                    float(), NOT NULL
 (3)    azimuth                             float(), NOT NULL
 (4)    field_value                         float(), NOT NULL
 (5)    additional_az_num                   smallint
 (6)    elevation_antenna_id                int
 (7)    last_update_date                    datetime
 
fac_party
 No.    Column Name               Type
 ------ ------------------------- ------------------------------
 (1)    facility_id               int, NOT NULL
 (2)    party_id                  int, NOT NULL
 (3)    party_type                char(5), NOT NULL
 (4)    last_change_date          datetime
 
facility
 No.    Column Name               Type
 ------ ------------------------- ------------------------------
 (1)    comm_city                 city
 (2)    comm_state                state
 (3)    eeo_rpt_ind               ind
 (4)    fac_address1              address
 (5)    fac_address2              address
 (6)    fac_callsign              callsign
 (7)    fac_channel               int
 (8)    fac_city                  city
 (9)    fac_country               country
 (10)   fac_frequency             float()
 (11)   fac_service               char(2)
 (12)   fac_state                 state
 (13)   fac_status_date           datetime
 (14)   fac_type                  varchar(3)
 (15)   facility_id               int, NOT NULL
 (16)   lic_expiration_date       datetime
 (17)   fac_status                varchar(5)
 (18)   fac_zip1                  char(5)
 (19)   fac_zip2                  char(4)
 (20)   station_type              char(1)
 (21)   assoc_facility_id         int
 (22)   callsign_eff_date         datetime
 (23)   tsid_ntsc                 int
 (24)   tsid_dtv                  int
 (25)   digital_status            char(1)
 (26)   sat_tv                    char(1)
 (27)   network_affil             varchar(100)
 (28)   nielsen_dma               varchar(60)
 (29)   tv_virtual_channel        int
 (30)   last_change_date          datetime
 
fm_app_indicators
 No.    Column Name               Type
 ------ ------------------------- ------------------------------
 (1)    application_id            int, NOT NULL
 (2)    bt_ind                    ind
 (3)    da_ind                    ind
 (4)    no_rotation_ind           varchar(1)
 (5)    rule_73_215_req_ind       ind
 (6)    last_change_date          datetime
 
fm_eng_data
 No.    Column Name               Type
 ------ ------------------------- ------------------------------
 (1)    ant_input_pwr             float()
 (2)    ant_max_pwr_gain          float()
 (3)    ant_polarization          char(1)
 (4)    ant_rotation              float()
 (5)    antenna_id                int
 (6)    antenna_type              char(1)
 (7)    application_id            int, NOT NULL
 (8)    asd_service               char(2)
 (9)    asrn_na_ind               ind
 (10)   asrn                      int
 (11)   avg_horiz_pwr_gain        float()
 (12)   biased_lat                float()
 (13)   biased_long               float()
 (14)   border_code               char(1)
 (15)   border_dist               float()
 (16)   docket_num                varchar(20)
 (17)   effective_erp             float()
 (18)   elev_amsl                 float()
 (19)   elev_bldg_ag              float()
 (20)   eng_record_type           char(1)
 (21)   facility_id               int, NOT NULL
 (22)   fm_dom_status             varchar(6)
 (23)   gain_area                 float()
 (24)   haat_horiz_rc_mtr         float()
 (25)   haat_vert_rc_mtr          float()
 (26)   hag_horiz_rc_mtr          float()
 (27)   hag_overall_mtr           float()
 (28)   hag_vert_rc_mtr           float()
 (29)   horiz_bt_erp              float()
 (30)   horiz_erp                 float()
 (31)   lat_deg                   int
 (32)   lat_dir                   char(1)
 (33)   lat_min                   int
 (34)   lat_sec                   float()
 (35)   lon_deg                   int
 (36)   lon_dir                   char(1)
 (37)   lon_min                   int
 (38)   lon_sec                   float()
 (39)   loss_area                 float()
 (40)   max_ant_pwr_gain          float()
 (41)   max_haat                  float()
 (42)   max_horiz_erp             float()
 (43)   max_vert_erp              float()
 (44)   multiplexor_loss          float()
 (45)   power_output_vis_kw       float()
 (46)   predict_coverage_area     float()
 (47)   predict_pop               int
 (48)   rcamsl_horiz_mtr          float()
 (49)   rcamsl_vert_mtr           float()
 (50)   station_class             varchar(2)
 (51)   terrain_data_src          char(1)
 (52)   vert_bt_erp               float()
 (53)   vert_erp                  float()
 (54)   num_sections              int
 (55)   present_area              float()
 (56)   percent_change            float()
 (57)   spacing                   float()
 (58)   terrain_data_src_other    varchar(255)
 (59)   trans_power_output        float()
 (60)   mainkey                   char(16)
 (61)   lat_whole_secs            int
 (62)   lon_whole_secs            int
 (63)   station_channel           int
 (64)   lic_ant_make              varchar(3)
 (65)   lic_ant_model_num         varchar(60)
 (66)   min_horiz_erp             float()
 (67)   haat_horiz_calc_ind       char(1)
 (68)   erp_w                     int
 (69)   trans_power_output_w      int
 (70)   market_group_num          varchar(7)
 (71)   last_change_date          datetime
 
frn_history
 No.    Column Name               Type
 ------ ------------------------- ------------------------------
 (1)    frn_history_id            int, NOT NULL
 (2)    facility_id               int, NOT NULL
 (3)    frn                       varchar(10), NOT NULL
 (4)    application_id            int
 (5)    date_inserted             datetime
 (6)    valid_ind                 char(1)
 
fmcmnts
 No.    Column Name               Type
 ------ ------------------------- ------------------------------
 (1)    application_id            int
 (2)    comment_type              char(5)
 (3)    comment                   varchar()
 
gen_app_indicators
 No.    Column Name               Type
 ------ ------------------------- ------------------------------
 (1)    application_id            int, NOT NULL
 (2)    edu_comm_flg              char(1)
 (3)    last_change_date          datetime
 
if_notification
 No.    Column Name               Type
 ------ ------------------------- ------------------------------
 (1)    application_id            int, NOT NULL
 (2)    broadcast_date            datetime
 (3)    ibiquity_cert             char(1)
 (4)    tech_name                 varchar(60)
 (5)    tech_phone                varchar(20)
 (6)    combined_power            float()
 (7)    analog_power              float()
 (8)    digital_power             float()
 (9)    analog_remain_ind         char(1)
 (10)   env_excluded_ind          char(1)
 (11)   digital_power_reduced     float()
 (12)   digital_power_reduced_na  char(1)
 (13)   ref_file_prefix           char(10)
 (14)   ref_app_arn               char(12)
 (15)   test_date                 datetime
 (16)   resolved_date             datetime
 (17)   analog_erp                float()
 (18)   digital_erp               float()
 (19)   last_change_date          datetime
 
if_sta
 No.    Column Name               Type
 ------ ------------------------- ------------------------------
 (1)    application_id            int, NOT NULL
 (2)    lic_ant_sys_change        char(1)
 (3)    antenna_system            char(4)
 (4)    ref_app_arn               char(12)
 (5)    ref_file_prefix           char(10)
 (6)    cp_ant_sys_file_prefix    varchar(10)
 (7)    cp_ant_sys_app_arn        char(12)
 (8)    silent_since_date         datetime
 (9)    return_to_air_date        datetime
 
int_translator
 No.    Column Name               Type
 ------ ------------------------- ------------------------------
 (1)    application_id            int, NOT NULL
 (2)    delivery_method           char(1)
 (3)    prim_callsign             callsign
 (4)    prim_comm_city            city
 (5)    prim_comm_state           state
 (6)    prim_sta_out_channel      int
 (7)    primary_via               varchar(13)
 (8)    scnd_comm_city            city
 (9)    scnd_comm_state           state
 (10)   third_comm_city           city
 (11)   third_comm_state          state
 (12)   trans_input_channel       int
 (13)   prim_facility_id          int
 (14)   last_change_date          datetime
 
intl_tracking
 No.    Column Name               Type
 ------ ------------------------- ------------------------------
 (1)    accepted_date             datetime
 (2)    application_id            int, NOT NULL
 (3)    can_coord_status          char(1)
 (4)    change_list_date          datetime
 (5)    change_list_num           varchar(5)
 (6)    hours_operation           char(1)
 (7)    ifrb_date                 datetime
 (8)    ifrb_list_flg             char(1)
 (9)    ifrb_serial_num           char(9)
 (10)   intl_class                varchar(2)
 (11)   itu_coord_status          char(1)
 (12)   mex_coord_status          char(1)
 (13)   neg_allot_ind             varchar(4)
 (14)   notified_pattern          char(1)
 (15)   notified_status           char(1)
 (16)   proposed_date             datetime
 (17)   referred_date             datetime
 (18)   region_2_status           char(1)
 (19)   updating_agency           varchar(4)
 (20)   notified_date             datetime
 (21)   intl_status               char(6)
 (22)   last_change_date          datetime
 
lic_app_indicators
 No.    Column Name               Type
 ------ ------------------------- ------------------------------
 (1)    application_id            int, NOT NULL
 (2)    auth_retrans_ind          ind
 (3)    chng_transm_pwr_ind       ind
 (4)    cp_stmt_incorrect_ind     ind
 (5)    cp_terms_met_ind          ind
 (6)    da_inst_compl_ind         ind
 (7)    da_inst_correct_ind       ind
 (8)    decr_c_erp_ind            ind
 (9)    decr_nc_erp_ind           ind
 (10)   del_cntr_prot_ind         ind
 (11)   incr_erp_221_ind          ind
 (12)   incr_erp_dckt_ind         ind
 (13)   incr_erp_ind              ind
 (14)   incr_erp_ownr_ind         ind
 (15)   lic_app_service           char(2)
 (16)   lic_pta_ind               ind
 (17)   nce_to_comm_ind           ind
 (18)   no_intl_coord_ind         ind
 (19)   orig_cp_file_prefix       file_prefix
 (20)   orig_cp_app_arn           arn
 (21)   lic_file_prefix           file_prefix
 (22)   lic_app_arn               arn
 (23)   rad_astr_not_ind          ind
 (24)   repl_da_compl_ind         ind
 (25)   repl_da_ind               ind
 (26)   rule_73_1620a1_ind        ind
 (27)   rule_73_1675a3_ind        ind
 (28)   rule_73_1675a_ind         ind
 (29)   rule_73_1690c8i_ind       ind
 (30)   rule_73_1690c_ind         ind
 (31)   rule_73_1692_ind          ind
 (32)   rule_73_207_ind           ind
 (33)   rule_73_315ab_ind         ind
 (34)   rule_73_525a1_ind         ind
 (35)   rule_73_68_ind            ind
 (36)   spec_op_conds_ind         ind
 (37)   sta_id_rules_ind          ind
 (38)   stat_ready_ind            ind
 (39)   trans_auth_erp_ind        ind
 (40)   type_appr_stereo_ind      ind
 (41)   inst_ht_dif_ok_ind        ind
 (42)   rule_73_1590              ind
 (43)   rule_73_1660_ind          ind
 (44)   rule_73_1675c_1_ind       ind
 (45)   rule_73_1675c_ind         ind
 (46)   rule_73_1690c9_ind        ind
 (47)   rule_73_3555_ind          ind
 (48)   rule_73_685f_ind          ind
 (49)   rule_73_68d3_ind          ind
 (50)   sales_type_flg            char(1)
 (51)   conv_lptv_cp_arn          varchar(12)
 (52)   conv_lptv_cp_prefix       varchar(10)
 (53)   conv_lptv_lic_arn         varchar(12)
 (54)   conv_lptv_lic_prefix      varchar(10)
 (55)   displaced_cp_filed_date   datetime
 (56)   no_change_lp_cp_ind       char(1)
 (57)   rule_73_6011_ind          char(1)
 (58)   rule_73_6012_ind          char(1)
 (59)   rule_73_6013_ind          char(1)
 (60)   rule_73_6020_ind          char(1)
 (61)   no_change_to_classa_cp_in char(1)
 (62)   pta_type                  char(1)
 (63)   repl_trans_line_ind       char(1)
 (64)   rule_73_850b_ind          char(1)
 (65)   rule_73_1675a_nc_ind      char(1)
 (66)   rule_73_1675a_ax_ind      char(1)
 (67)   orig_cp_app_expiration_date datetime
 (68)   record_change_date        datetime
 
nce_factors
 No.    Column Name               Type
 ------ ------------------------- ------------------------------
 (1)    application_id            int, NOT NULL
 (2)    claimed_points            int
 (3)    existing_auths            int
 (4)    existing_cps              int
 (5)    existing_fillin_auths     int
 (6)    existing_fillin_cps       int
 (7)    fill_in_serv_ind          char(1)
 (8)    gain_area                 int
 (9)    population_served         int
 (10)   rule_73_313_c_ind         char(1)
 (11)   rule_73_3555_ind          char(1)
 (12)   rule_73_7000_ind          char(1)
 (13)   rule_73_7003_b_c_ind      char(1)
 (14)   technical_points          int
 (15)   total_points              int
 (16)   divers_own_ind            char(1)
 (17)   min_first_service_ind     char(1)
 (18)   min_sec_service_ind       char(1)
 (19)   supplement_date           datetime
 (20)   first_aural_service_ind   char(1)
 (21)   first_tribal_service_ind  char(1)
 (22)   last_change_date          datetime
 
ownership_capitalization
 No.    Column Name               Type
 ------ ------------------------- ------------------------------
 (1)    ownership_capitalization_id int, NOT NULL
 (2)    application_id            int, NOT NULL
 (3)    class_of_stock            varchar(60)
 (4)    voting_ind                char(1)
 (5)    authorized_shares         float()
 (6)    issued_shares             float()
 (7)    treasury_shares           float()
 (8)    unissued_shares           float()
 (9)    order_number              smallint
 (10)   class_of_stock_flg        char(1)
 (11)   class_of_stock_other      varchar(20)
 (12)   voting_flg                char(1)
 (13)   last_update_date          datetime
 
ownership_contract
 No.    Column Name               Type
 ------ ------------------------- ------------------------------
 (1)    ownership_contract_id     int, NOT NULL
 (2)    application_id            int, NOT NULL
 (3)    contract_description      varchar(255)
 (4)    contract_person           varchar(255)
 (5)    execution_date            datetime
 (6)    expiration_date           datetime
 (7)    order_number              smallint
 (8)    agreement_type_lma        char(1)
 (9)    agreement_type_naa        char(1)
 (10)   agreement_type_oth        char(1)
 (11)   execution_date_month      char(3)
 (12)   execution_date_year       smallint
 (13)   expiration_date_month     char(3)
 (14)   expiration_date_year      smallint
 (15)   expiration_date_na        char(1)
 (16)   last_update_date          datetime
 
ownership_exemptions
 No.    Column Name               Type
 ------ ------------------------- ------------------------------
 (1)    ownership_exemptions_id   int, NOT NULL
 (2)    application_id            int, NOT NULL
 (3)    order_number              smallint, NOT NULL
 (4)    name                      varchar(150)
 (5)    title                     varchar(60)
 (6)    last_update_date          datetime
 
ownership_group
 No.    Column Name               Type
 ------ ------------------------- ------------------------------
 (1)    ownership_group_id        int, NOT NULL
 (2)    main_application_id       int, NOT NULL
 (3)    fac_callsign              varchar(12)
 (4)    facility_id               int, NOT NULL
 (5)    fac_service               varchar(2)
 (6)    comm_city                 varchar(20)
 (7)    comm_state                varchar(2)
 (8)    fac_service_o             varchar(2)
 (9)    app_arn                   varchar(12)
 (10)   file_prefix               char(10)
 (11)   order_number              smallint
 (12)   last_update_date          datetime
 
ownership_interests
 No.    Column Name               Type
 ------ ------------------------- ------------------------------
 (1)    ownership_interests_id    int, NOT NULL
 (2)    application_id            int, NOT NULL
 (3)    order_number              smallint, NOT NULL
 (4)    frn                       varchar(10)
 (5)    name                      varchar(150)
 (6)    last_update_date          datetime
 
ownership_other_int
 No.    Column Name               Type
 ------ ------------------------- ------------------------------
 (1)    ownership_other_int_id    int, NOT NULL
 (2)    application_id            int, NOT NULL
 (3)    order_number              smallint, NOT NULL
 (4)    assets_perc               decimal(4,1)
 (5)    comm_city                 varchar(20)
 (6)    comm_state                char(2)
 (7)    entity_type               char(1)
 (8)    equity_perc               decimal(4,1)
 (9)    fac_callsign              varchar(12)
 (10)   facility_id               int
 (11)   name                      varchar(150)
 (12)   newspaper                 varchar(150)
 (13)   positional_int_off        char(1)
 (14)   positional_int_dir        char(1)
 (15)   positional_int_par        char(1)
 (16)   positional_int_lim        char(1)
 (17)   positional_int_stk        char(1)
 (18)   positional_int_own        char(1)
 (19)   positional_int_ent        char(1)
 (20)   positional_int_oth        char(1)
 (21)   positional_int_other_info varchar(20)
 (22)   votes_perc                decimal(4,1)
 (23)   last_update_date          datetime
 
ownership_other_int_xml_data
 No.    Column Name               Type
 ------ ------------------------- ------------------------------
 (1)    application_id            int, NOT NULL
 (2)    file_id                   int, NOT NULL
 (3)    order_number              smallint, NOT NULL
 (4)    assets_perc               decimal(4,1)
 (5)    comm_city                 varchar(20)
 (6)    comm_state                char(2)
 (7)    entity_type               char(1)
 (8)    equity_perc               decimal(4,1)
 (9)    fac_callsign              varchar(12)
 (10)   facility_id               int
 (11)   name                      varchar(150)
 (12)   newspaper                 varchar(150)
 (13)   positional_int_off        char(1)
 (14)   positional_int_dir        char(1)
 (15)   positional_int_par        char(1)
 (16)   positional_int_lim        char(1)
 (17)   positional_int_stk        char(1)
 (18)   positional_int_own        char(1)
 (19)   positional_int_ent        char(1)
 (20)   positional_int_oth        char(1)
 (21)   positional_int_other_info varchar(20)
 (22)   votes_perc                decimal(4,1)
 (23)   last_update_date          datetime
 
ownership_relationships
 No.    Column Name               Type
 ------ ------------------------- ------------------------------
 (1)    ownership_relationships_i int, NOT NULL
 (2)    application_id            int, NOT NULL
 (3)    order_number              smallint, NOT NULL
 (4)    names                     varchar(255)
 (5)    relationship_flg          char(2)
 (6)    last_update_date          datetime
 
ownership_report
 No.    Column Name               Type
 ------ ------------------------- ------------------------------
 (1)    application_id            int, NOT NULL
 (2)    accurate_date             datetime
 (3)    non_attributable_ind      char(1)
 (4)    attributable_ind          char(1)
 (5)    related_ind               char(1)
 (6)    exemption_ind             char(1)
 (7)    owner_type                varchar(5)
 (8)    entity_control_ind        char(1)
 (9)    separate_form_ind         char(1)
 (10)   attrib_exemption_ind      char(1)
 (11)   capitalization_na         char(1)
 (12)   contract_info_na          char(1)
 (13)   individuals_related_ind   char(1)
 (14)   lic_frn                   varchar(10)
 (15)   lic_name                  varchar(60)
 (16)   org_chart_na              char(1)
 (17)   respondent_nature_flg     char(3)
 (18)   resp_interests_na         char(1)
 (19)   last_update_date          datetime
 
 
ownership_structure
 No.    Column Name               Type
 ------ ------------------------- ------------------------------
 (1)    ownership_structure_id    int, NOT NULL
 (2)    application_id            int, NOT NULL
 (3)    name_address              varchar(255)
 (4)    gender_flg                char(1)
 (5)    ethnicity_flg             varchar(5)
 (6)    race_flg                  varchar(5)
 (7)    citizenship               char(2)
 (8)    positional_int            varchar(60)
 (9)    votes_perc                decimal(5,2)
 (10)   equity_perc               decimal(5,2)
 (11)   active_ind                char(1)
 (12)   office_held               varchar(60)
 (13)   interest_perc             decimal(5,2)
 (14)   occupation                varchar(60)
 (15)   appointed_by              varchar(60)
 (16)   existing_interests        varchar(255)
 (17)   order_number              smallint
 (18)   assets_perc               decimal(5,2)
 (19)   entity_exemption_ind      char(1)
 (20)   frn                       varchar(10)
 (21)   listing_type_flg          char(1)
 (22)   personal_info_na          char(1)
 (23)   positional_int_crd        char(1)
 (24)   positional_int_dir        char(1)
 (25)   positional_int_gen        char(1)
 (26)   positional_int_inv        char(1)
 (27)   positional_int_lim        char(1)
 (28)   positional_int_llc        char(1)
 (29)   positional_int_off        char(1)
 (30)   positional_int_oth        char(1)
 (31)   positional_int_own        char(1)
 (32)   positional_int_stk        char(1)
 (33)   positional_int_other_info varchar(20)
 (34)   relationship_flg          char(1)
 (35)   race_american_indian      char(1)
 (36)   race_asian                char(1)
 (37)   race_black                char(1)
 (38)   race_hawaiian             char(1)
 (39)   race_white                char(1)
 (40)   name                      varchar(150)
 (41)   city                      varchar(20)
 (42)   country                   varchar(20)
 (43)   state                     char(2)
 (44)   street_address1           varchar(60)
 (45)   street_address2           varchar(60)
 (46)   zip1                      char(5)
 (47)   zip2                      char(4)
 (48)   last_update_date          datetime
 
party
 No.    Column Name               Type
 ------ ------------------------- ------------------------------
 (1)    party_id                  int, NOT NULL
 (2)    party_address1            address
 (3)    party_address2            address
 (4)    party_citizenship         country
 (5)    party_city                city
 (6)    party_company             name
 (7)    party_country             country
 (8)    party_email               email
 (9)    party_fax                 phone
 (10)   party_legal_name          varchar(255)
 (11)   party_name                name
 (12)   party_phone               phone
 (13)   party_state               state
 (14)   party_zip1                char(5)
 (15)   party_zip2                char(4)
 (16)   last_change_date          datetime
 
positional_int
 No.    Column Name               Type
 ------ ------------------------- ------------------------------
 (1)    application_id            int, NOT NULL
 (2)    citizenship               country
 (3)    name_address              varchar(250), NOT NULL
 (4)    equity_perc               percentage
 (5)    votes_perc                percentage
 (6)    title                     name
 (7)    boardmember_ind           ind
 (8)    membership_perc           float()
 (9)    owner_perc                float()
 (10)   assets_perc               float()
 (11)   order_number              smallint
 (12)   last_update_date          datetime
 
supp_facility
No.    Column Name                         Type
 ------ ----------------------------------- ------------------------------
 (1)    parent_facility_id        int, NOT NULL
 (2)    supp_type                 varchar(5), NOT NULL
 (3)    supp_callsign             varchar(12), NOT NULL
 (4)    supp_fac_status           varchar(5)
 (5)    status_date               datetime
 (6)    site_number               tinyint, NOT NULL
 (7)    fac_channel               int
 (8)    comm_city                 char(20)
 (9)    comm_state                char(2)
 (10)   last_update_date          datetime
 
tv_app_indicators
 No.    Column Name                         Type
 ------ ----------------------------------- ------------------------------
 (1)    ant_struc_reqs_ind                  ind
 (2)    application_id                      int, NOT NULL
 (3)    bt_used_ind                         ind
 (4)    da_ind                              ind
 (5)    elec_bt_prop_ind                    ind
 (6)    int_compl_ind                       ind
 (7)    mech_bt_prop_ind                    ind
 (8)    rule_73_1660_ind                    ind
 (9)    rule_73_607_ind                     ind
 (10)   rule_73_610_ind                     ind
 (11)   rule_73_614_ind                     ind
 (12)   rule_73_685ab_ind                   ind
 (13)   coverage_exhibit_ind                ind
 (14)   rule_73_685dg_ind                   ind
 (15)   dummy_tx_flag                       char(1)
 (16)   da_exhibit_ind                      ind
 (17)   rule_74_705_ind                     ind
 (18)   rule_74_706_ind                     ind
 (19)   rule_74_707_ind                     ind
 (20)   rule_73_622_ind                     ind
 (21)   ant_5km_ind                         ind
 (22)   rule_73_62_ind                      ind
 (23)   rule_1_1307_ind                     ind
 (24)   rule_73_625_ind                     ind
 (25)   rad_astr_ind                        ind
 (26)   faa_notified_ind                    ind
 (27)   rule_73_623a_ind                    ind
 (28)   no_rotation_ind                     varchar(1)
 (29)   rel_field_values_na                 char(1)
 (30)   studio_in_comm_ind                  char(1)
 (31)   rule_73_1690c_3_ind                 char(1)
 (32)   rule_74_786d_ind                    char(1)
 (33)   no_suitable_incore_ind              char(1)
 (34)   rule_74_786e_wirels_ind             char(1)
 (35)   rule_74_786e_agr_ind                char(1)
 (36)   rule_74_786e_notif_ind              char(1)
 (37)   noise_limited_ind                   char(1)
 (38)   population_match_ind                char(1)
 (39)   maximization_ind                    char(1)
 (40)   site_number                         tinyint, NOT NULL
 (41)  interference_prot_ind               char(1)
 (42)  dts_covers_all_area_ind             char(1)
 (43)  dts_coverage_within_area_flg        varchar(2)
 (44)  dts_coverage_contiguous_ind         char(1)
 (45)  dts_principal_comm_cover_flg        varchar(2)
 (46)  dts_combined_interference_ind       char(1)
 (47)  dts_trans_within_area_ind           char(1)
 (48)  dts_elev_pattern_varies_ind         char(1)
 (49)  last_change_date                    datetime
 
tv_eng_data
 No.    Column Name               Type
 ------ ------------------------- ------------------------------
 (1)    ant_input_pwr             float(18)
 (2)    ant_max_pwr_gain          float(18)
 (3)    ant_polarization          char(1)
 (4)    antenna_id                int
 (5)    antenna_type              char(1)
 (6)    application_id            int, NOT NULL
 (7)    asrn_na_ind               varchar(1)
 (8)    asrn                      int
 (9)    aural_freq                float(18)
 (10)   avg_horiz_pwr_gain        float(18)
 (11)   biased_lat                float(18)
 (12)   biased_long               float(18)
 (13)   border_code               char(1)
 (14)   carrier_freq              float(18)
 (15)   docket_num                varchar(20)
 (16)   effective_erp             float(18)
 (17)   electrical_deg            float(18)
 (18)   elev_amsl                 float(18)
 (19)   elev_bldg_ag              float(18)
 (20)   eng_record_type           char(1)
 (21)   fac_zone                  varchar(3)
 (22)   facility_id               int, NOT NULL
 (23)   freq_offset               char(1)
 (24)   gain_area                 float(18)
 (25)   haat_rc_mtr               float(18)
 (26)   hag_overall_mtr           float(18)
 (27)   hag_rc_mtr                float(18)
 (28)   horiz_bt_erp              float(18)
 (29)   lat_deg                   int
 (30)   lat_dir                   char(1)
 (31)   lat_min                   int
 (32)   lat_sec                   float(18)
 (33)   lon_deg                   int
 (34)   lon_dir                   char(1)
 (35)   lon_min                   int
 (36)   lon_sec                   float(18)
 (37)   loss_area                 float(18)
 (38)   max_ant_pwr_gain          float(18)
 (39)   max_erp_dbk               float(18)
 (40)   max_erp_kw                float(18)
 (41)   max_haat                  float(18)
 (42)   mechanical_deg            float(18)
 (43)   multiplexor_loss          float(18)
 (44)   power_output_vis_dbk      float(18)
 (45)   power_output_vis_kw       float(18)
 (46)   predict_coverage_area     float(18)
 (47)   predict_pop               int
 (48)   terrain_data_src_other    varchar(255)
 (49)   terrain_data_src          char(3)
 (50)   tilt_towards_azimuth      float(18)
 (51)   true_deg                  float(18)
 (52)   tv_dom_status             varchar(6)
 (53)   upperband_freq            float(18)
 (54)   vert_bt_erp               float(18)
 (55)   visual_freq               float(18)
 (56)   vsd_service               char(2)
 (57)   rcamsl_horiz_mtr          float(18)
 (58)   ant_rotation              float(18)
 (59)   input_trans_line          float(18)
 (60)   max_erp_to_hor            float(18)
 (61)   trans_line_loss           float(18)
 (62)   lottery_group             int
 (63)   analog_channel            int
 (64)   lat_whole_secs            int
 (65)   lon_whole_secs            int
 (66)   max_erp_any_angle         float(18)
 (67)   station_channel           int
 (68)   lic_ant_make              varchar(3)
 (69)   lic_ant_model_num         varchar(60)
 (70)   dt_emission_mask          char(1)
 (71)   site_number               tinyint, NOT NULL
 (72)   elevation_antenna_id      int
 (73)   last_change_date          datetime
 
 
 User_type       Storage_type    Length
 --------------- --------------- ------
 address         varchar             40
 arn             char                12
 callsign        char                12
 city            varchar             20
 country         char                 2
 county          varchar             30
 email           varchar             60
 file_number     char                21
 file_prefix     char                10
 form_number     varchar             10
 ind             char                 1
 name            varchar             60
 percentage      float                8
 phone           char                10
 state           char                 2
 title           varchar             60
 url             varchar            255

 

******************************************************************************
******************************************************************************
Release Notes for CDBS Engineering Files
******************************************************************************
******************************************************************************

In most cases, new fields are added at the end of the existing
data rows. Please see the documentation file for a description of
these fields.

Changes 01/23/2012

The following table (file) has been added

if_sta

facility following field has been added

tv_virtual_channel

------------------------------------------------------------------------------------------------------------------------

Changes 12/1/2010

The following tables (files) have been modified

am_towers fields added and moved

Switched order of tower_type and last_change_date (now called last_update_date) (and fixed the documentation)

dtv_transition fields added

binding_termination_flg
termination_date_not_aff
termination_date_aff
aff_term_cert_flg
cont_analog_flg
phone_help_ctr_flg
walkin_help_ctr_flg
st_analog_nightlight_ind
st_analog_nightlight_end_date
inf_analog_nightlight_ind
inf_analog_nightlight_end_date
early_term_withdraw_ind
termination_time_0612_flg
termination_date_nce
termination_time_nce_flg
termination_time_notaff_flg
termination_time_aff_flg
nce_term_cert_flg
ref_contact_phone
ref_contact_hours
an_participation_notice_ind
an_eligibility_showing_ind
an_objection_to_elig_showg_ind
an_objection_callsign
an_revocation_ind

Also moved last_update_date (kept it as the last column)

facility

frn (removed incorrect column from Engineering Data Description)

nce_factors - fields added

first_aural_service_ind
first_tribal_service_ind

Also moved last_change_date (kept it as the last column)

ownership_capitalization - fields added (documentation change only)

class_of_stock_flg
class_of_stock_other
last_update_date
voting_flg

ownership_contract - fields added (documentation change only)

agreement_type_lma
agreement_type_naa
agreement_type_oth
execution_date_month
execution_date_year
expiration_date_month
expiration_date_year
expiration_date_na
last_update_date

ownership_report - fields added (documentation change only)

attrib_exemption_ind
capitalization_na
contract_info_na
individuals_related_ind
last_update_date
lic_frn
lic_name
org_chart_na
respondent_nature_flg
resp_interests_na

ownership_structure - fields added (documentation change only)

assets_perc
entity_exemption_ind
frn
last_update_date
listing_type_flg
personal_info_na
positional_int_crd
positional_int_dir
positional_int_gen
positional_int_inv
positional_int_lim
positional_int_llc
positional_int_off
positional_int_oth
positional_int_own
positional_int_stk
positional_int_other_info
relationship_flg
name
city
country
state
street_address1
street_address2
zip1
zip2

The following tables (files) are new:

frn_history
if_notification
int_translator
lic_app_indicators
ownership_exemptions
ownership_interests
ownership_other_int
ownership_other_int_xml_data
ownership_relationships

------------------------------------------------------------------------------------------------------------------------

Changes 6/24/2009

The following tables (files) have been modified.

supp_facility fields added

site_number (added to primary key)
fac_channel
comm_city
comm_state

Also moved last_update_date (kept it as the last column)

----------------------------------------------------------------------

Changes 3/24/2009

The following documentation was corrected:

tv_app_indicators

Corrected the order of columns 40 to 49 in the readme file to match the data.

----------------------------------------------------------------------

Changes 3/4/2009

The following tables (files) have been modified.

application fields added

frn
shortform_app_arn
shortform_file_prefix
corresp_ind
assoc_facility_id
network_affil
sat_tv_ind
comm_county
comm_zip1
comm_zip2

dtv_transition fields added

addl_steps_ind
analog_nightlight_ind
analog_turnoff_pn_compl_flg

facility fields added

network_affil
nielsen_dma

tv_app_indicators fields added

maximization_ind
site_number (added to primary key)
interference_prot_ind
dts_covers_all_area_ind
dts_coverage_within_area_flg
dts_coverage_contiguous_ind
dts_principal_comm_cover_flg
dts_combined_interference_ind
dts_trans_within_area_ind
dts_elev_pattern_varies_ind

tv_eng_data fields added

site_number (added to primary key)
elevation_antenna_id

The following tables (files) are new:

elevation_ant_make
elevation_pattern
elevation_pattern_addl
supp_facility

The following documentation was corrected:

am_ant_sys

augmented_ind  (added to readme file)
biased_long (added to Engineering Data Description)

am_eng_data

encl_fence_dist, feed_circ_other, feed_circ_type (added to Engineering Data Description)
biased_lat, biased_long  (removed from Engineering Data Description)

  ----------------------------------------------------------------------

Changes 3/24/2008
Corrections to 3/6/2008 release:
tv_app_indicators
Deleted displacement_type
dtv_transition
Deleted addl_steps_ind and last_change_update
----------------------------------------------------------------------
Changes 3/6/2008
File added
dtv_channel_assignments
Fields Added
application
dtv_type

tv_app_indicators

Entire table released, replacing existing fields:
application_id,bt_used_ind,da_ind,mech_bt_prop_ind,no_rotation_ind,last_change_date

dtv_transition
Entire table released, replacing existing fields:
dtv_cur_channel
application_id
dtv_cur_na
ntsc_cur_channel
ntsc_cur_na
rep_max_cert
file_prefix_cer_a
app_arn_cer_a
file_prefix_cer_b
app_arn_cer_b
file_prefix_cer_d
app_arn_cer_d
rep_max_cer_type
file_prefix_cer_e
app_arn_cer_e
data_cert_ind
election
elected_channel_a
elected_channel_b
alt_elected_channel
intl_coord_ind
cont_election
cont_elected_channel
conflict_decision
reference_no
negot_agreemt_ind
tech_eng_ind
tent_chan_status
tentative_channel
post_tran_dtv_channel
pre_tran_dtv_channel
post_tran_auth_file_prefix
post_tran_auth_app_arn
post_tran_auth_not_yet_ind
construction_deadline_dat
post_tran_operating_ind
op_status
op_expected_date
op_power_level
op_population_perc
construction_complete_ind
expect_cons_complete_date
const_not_begun
const_underway
const_addl_needed
cp_status_ind
cp_mod_needed_ind
cp_mod_filed_ind
cp_mod_file_prefix
cp_mod_app_arn
cp_mod_filed_date
cp_mod_expected_date
addl_fcc_action_ind
addl_fcc_action_app_arn
addl_fcc_action_file_pref
addl_fcc_action_date
addl_intl_ind
addl_faa_approval_ind
addl_local_approval_ind
addl_equip_ind
addl_equip_new_ant_ind
addl_equip_adj_ant_ind
addl_equip_switch_ant_ind
addl_equip_new_trans_ind
addl_equip_adj_trans_ind
addl_equip_gen_install_in
addl_equip_other_ind
addl_tower_ind
addl_coord_ind
addl_other_ind
analog_service_status
analog_status_ind
dtv_transition_plan_ind 
last_update_date
----------------------------------------------------------------------

Changes 4/1/2008

dtv_channel_assignments :

Fields added: rcamsl,ref_azimuth, da_ind , pre_dtv_channel, callsign
Fields removed: area, population, interference

Fields rename: post_dtv_channel

dtv_transition:

Fields removed: addl_steps_ind

Moved last_update_date to the end.

----------------------------------------------------------------------
Changes 11/21/2007
File added
nce_factors
----------------------------------------------------------------------
Changes 5/2/2007
amcmnts and fmcmnts redefined
----------------------------------------------------------------------
Changes 9/20/2006
Ownership Group table added
----------------------------------------------------------------------
Changes 4/24/2006
Fields Added
ownership_structure
order_number
ownership_capitalization
order_number
ownership_contract
order_number
----------------------------------------------------------------------
Changes 12/28/2005
Fields Added
tv_eng_data
dt_emission_mask
----------------------------------------------------------------------
Changes 02/17/2005
Files Added
dtv_agreement_group
dtv_transition
----------------------------------------------------------------------
Changes 11/18/2004
Fields Added
facility
sat_tv
----------------------------------------------------------------------
Changes 03/25/2003
Fields Added
app_tracking
tolling_code
----------------------------------------------------------------------
Changes 12/04/2002
Fields Added
facility
digital_status

app_tracking
accepted_date
----------------------------------------------------------------------
Changes 4/23/2002
Fields Added
facility
tsid_ntsc
tsid_dtv

fm_eng_data
market_group_num
----------------------------------------------------------------------
Changes 3/14/2002
Files Added
call_sign_history
ownership_capitalization
ownership_contract
ownership_report
ownership_structure
Fields Added
am_tracking
app_status_date
amendment_stamped_date
----------------------------------------------------------------------
Changes 8/8/2001
Files Added
amcmnts
fmcmnts
----------------------------------------------------------------------
Changes 7/31/2001
Fields Added
am_ant_sys
specified_hrs_range
----------------------------------------------------------------------
Changes 5/31/2001
Converted readme.txt to readme.html

Added linking file: _code_table

Fields Added
Added last_change_date as last field in all files

app_party
sig_name

app_tracking
app_status
dtv_checklist

application
app_type
paper_filed_ind

---------------------------------------------------------------------
Fields Added 2/13/2001
am_ant_sys
grandfathered_ind

fm_eng_data
haat_horiz_calc_ind
erp_w
trans_power_output_w

---------------------------------------------------------------------
Fields Added 5/25/2000

fm_app_indicators
rule_73_215_req_ind

fm_eng_data
min_horiz_erp

----------------------------------------------------------------------
Fields Added 7/26/2013

ownership_structure
race_american_indian
race_asian
race_black
race_hawaiian
race_white

----------------------------------------------------------------------
(Information for earlier dates not available.