File: readme.html (for CDBS)
Update: 4/1/2008
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:21/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) last_change_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_change_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_change_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) last_change_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) 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_prefi char(10)
(33) post_tran_auth_app_arn char(12)
(34) post_tran_auth_not_yet_in 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_in 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) 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) 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
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
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
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) last_change_date datetime
ownership_capitalization
No. Column Name Type
------ ------------------------- ------------------------------
(1) ownership_capitalization_ 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
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
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_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)
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
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
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) 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) last_change_date datetime
User_type Storage_type Length
--------------- --------------- ------
address nvarchar 40
address varchar 40
arn char 12
arn nchar 12
callsign char 12
callsign nchar 12
city nvarchar 20
city varchar 20
country char 2
country nchar 2
county nvarchar 30
county varchar 30
email nvarchar 60
email varchar 60
file_number char 21
file_number nchar 21
file_prefix char 10
file_prefix nchar 10
form_number nvarchar 10
form_number varchar 10
ind char 1
ind nchar 1
name nvarchar 60
name varchar 60
percentage float 8
phone char 10
phone nchar 10
state char 2
state nchar 2
title nvarchar 60
title varchar 60
url nvarchar 255
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 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
----------------------------------------------------------------------
(Information for earlier dates not available.)