Release Notes for CDBS Engineering Files

This file contains a listing of the changes to files containing the dumps of CDBS engineering data.

Please see the updated documentation files for the description (and ordering) of these fields.

Version of 2/11/2005

The following tables (files) are new. The documentation was updated to reflect these additions.

Table

Fields Added

dtv_agreement_group

application_id

dtv_agreement_group_id

facility_id

fac_callsign

name

order_num

dtv_transition

app_arn_cer_a

application_id

dtv_cur_channel

dtv_cur_na

file_prefix_cer_a

file_prefix_cer_b

ntsc_cur_channel

ntsc_cur_na

rep_max_cert

alt_elected_channel

app_arn_cer_b

app_arn_cer_d

app_arn_cer_e

conflict_decision

cont_elected_channel

cont_election

data_cert_ind

elected_channel_a

elected_channel_b

election

file_prefix_cer_d

file_prefix_cer_e

intl_coord_ind

negot_agreemt_ind

reference_no

rep_max_cer_type

tech_eng_ind

tent_chan_status

tentative_channel

Version of 10/26/2004

The following table (file) had a field that was added. The documentation was updated to reflect these additions.

Table	Fields Added
facility	sat_tv
facility	frn

Version of 05/23/2003

The following table (file) had field(s) that were changed The expiration_data datatype has changed to varchar(15). The documentation was updated.

Table	Fields Changed
ownership_contract	expiration_date

Version of 03/10/2003

The following table (file) had field(s) that were added. In most cases, fields were added at the end of the existing data rows (or immediately preceding a "last_change_date" field). The documentation was updated to reflect these additions.

Table	Fields Added
app_tracking	tolling_code

Version of 12/03/2002

The following tables (files) had field(s) that were added. In most cases, fields were added at the end of the existing data rows (or immediately preceding a "last_change_date" field). The documentation was updated to reflect these additions.

Table	Fields Added
app_tracking	accepted_date
facility	digital_status

Version of 3/11/2002

The following tables (files) are new. The documentation was updated to reflect these additions.

Table	Fields
call_sign_history	begin_date callsign callsign_hist_id callsign_seq_id emp_userid facility_id record_change_date
ownership_capitalization	application_id authorized_shares class_of_stock issued_shares last_change_date ownership_capitalization_id treasury_shares unissued_shares voting_ind
ownership_contract	application_id contract_description contract_person execution_date expiration_date last_change_date ownership_contract_id
ownership_report	accurate_date application_id attributable_ind entity_control_ind exemption_ind last_change_date non_attributable_ind owner_type related_ind separate_form_ind
ownership_structure	active_ind application_id appointed_by citizenship equity_perc ethnicity_flg existing_interests gender_flg interest_perc last_change_date name_address occupation office_held ownership_structure_id positional_int race_flg votes_perc

The following table (file) had fields that were added. The documentation was updated to reflect these additions.

Table	Fields Added
app_tracking	amendment_stamped_date app_status_date

Version of 7/30/2001

The following table (file) had a field that was added. Note that the last field in the row is still "last_change_date" that contains the last date that the row in the table was changed. The new field was added before it.

Table	Fields Added
am_ant_sys	specified_hrs_range

Version of 5/17/2001

The following tables (files) had fields that were added. Note the new field "last_change_date" that contains the last date that the row in a table dump was changed (or nothing if never). The documentation was updated to reflect these additions.

Table	Fields Added
am_ant_sys	ant_dir_ind biased_lat biased_long grandfathered_ind power last_change_date
am_augs	last_change_date
am_eng_data	last_change_date
am_towers	tower_pl_codes last_change_date
ant_make	last_change_date
ant_pattern	last_change_date
app_party	application_id sig_name last_change_date
app_tracking	app_status dtv_checklist last_change_date
application	app_type paper_filed_ind last_change_date
dtv_allotment	last_change_date
dtv_facility	last_change_date
fac_party	last_change_date
facility	last_change_date
fm_app_indicators	last_change_date
fm_eng_data	erp_w transpower_output_w last_change_date
gen_app_indicators	last_change_date
intl_tracking	last_change_date
party	last_change_date
tv_app_indicators	last_change_date

The following files (tables) had fixes to the documentation.

facility - Removed incorrect dummy_record_indicator field.
am_ant_sys - Removed incorrect req_power field.

Version of 5/25/2000

The following files (tables) had fields that were added.

fm_app_indicators

- rule_73_215_req_ind

fm_eng_data

- min_horiz_erp