******************************************************** NOTICE ******************************************************** This document was converted from WordPerfect to ASCII Text format. Content from the original version of the document such as headers, footers, footnotes, endnotes, graphics, and page numbers will not show up in this text version. All text attributes such as bold, italic, underlining, etc. from the original document will not show up in this text version. Features of the original document layout such as columns, tables, line and letter spacing, pagination, and margins will not be preserved in the text version. If you need the complete document, download the WordPerfect version or Adobe Acrobat version, if available. ***************************************************************** Attachment B: The SQL for the Table definitions for Amateur, Aircraft, GMRS, Paging, Cellular, Microwave and Market-based Applications and Licenses File "pa_ddl.sql" /**************************************************************** ** Date & Time : September 16, 1999 at 10:48 AM */ go /****************************************************************************** ** Generated Script (CREATE): Tables ** ** ------------------------------------------------------------------------- ** ******************************************************************************/ go create table dbo.PUBACC_AD ( Record_Type char(2) null, unique_system_identifier numeric(9,0) not null, ULS_File_Number char(14) null, EBF_Number varchar(30) null, Application_Purpose char(2) null, Application_Status char(1) null, Application_Fee_Exempt char(1) null, Regulatory_Fee_Exempt char(1) null, Source char(1) null, requested_expiration_date_mmdd char(4) null, Receipt_Date char(10) null, Notification_Code char(1) null, Notification_date char(10) null, Expanding_Area_or_Contour char(1) null, Change_Type char(1) null, Original_Application_Purpose char(2) null, Requesting_A_Waiver char(1) null, How_Many_Waivers_Requested int null, Any_Attachments char(1) null, Number_of_Requested_SIDs int null, fee_control_num char(16) null, date_entered char(10) null, reason varchar(255) null, frequency_coordination_indicat char(1) null ) on 'default' go create table dbo.PUBACC_AM ( record_type char(2) not null, unique_system_identifier numeric(9,0) not null, uls_file_num char(14) null, ebf_number varchar(30) null, callsign char(10) null, operator_class char(1) null, group_code char(1) null, region_code tinyint null, trustee_callsign char(10) null, trustee_indicator char(1) null, physician_certification char(1) null, ve_signature char(1) null, systematic_callsign_change char(1) null, vanity_callsign_change char(1) null, vanity_relationship char(12) null, previous_callsign char(10) null, previous_operator_class char(1) null, trustee_name varchar(50) null ) on 'default' go create table dbo.PUBACC_AN ( record_type char(2) null, unique_system_identifier numeric(9,0) not null, uls_file_number char(14) null, ebf_number varchar(30) null, call_sign char(10) null, antenna_action_performed char(1) null, antenna_number int null, location_number int null, receive_zone_code char(6) null, antenna_type_code char(1) null, height_to_tip numeric(5,1) null, height_to_center_raat numeric(5,1) null, antenna_make varchar(25) null, antenna_model varchar(25) null, tilt numeric(3,1) null, polarization_code char(5) null, beamwidth numeric(4,1) null, gain numeric(4,1) null, azimuth numeric(4,1) null, height_above_avg_terrain numeric(5,1) null, diversity_height numeric(5,1) null, diversity_gain numeric(4,1) null, diversity_beam numeric(4,1) null, reflector_height numeric(5,1) null, reflector_width numeric(4,1) null, reflector_separation numeric(5,1) null, repeater_seq_num int null, back_to_back_tx_dish_gain numeric(4,1) null, back_to_back_rx_dish_gain numeric(4,1) null, location_name varchar(20) null, passive_repeater_id int null, alternative_cgsa_method char(1) null, path_number int null ) on 'default' go create table dbo.PUBACC_AT ( Record_Type char(2) null, unique_system_identifier numeric(9,0) not null, ULS_File_Number char(14) null, EBF_Number varchar(30) null, Attachment_Code char(1) null, Attachment_Description varchar(60) null, Attachment_Date char(10) null, attachment_file_name varchar(60) null ) on 'default' go create table dbo.PUBACC_AV ( record_type char(2) null, unique_system_identifier numeric(9,0) not null, uls_file_number char(14) null, ebf_number varchar(30) null, call_sign char(10) null, aircraft_count int null, type_of_carrier char(1) null, portable_indicator char(1) null, fleet_indicator char(1) null, n_number char(10) null ) on 'default' go create table dbo.PUBACC_BC ( record_type char(2) not null, unique_system_identifier numeric(9,0) not null, uls_file_number char(14) null, ebf_number varchar(30) null, callsign char(10) null, broadcast_callsign char(10) null, broadcast_city char(20) null, broadcast_state char(2) null, parent_facility_id int null, parent_class_code char(2) null ) on 'default' go create table dbo.PUBACC_BF ( record_type char(2) null, unique_system_identifier numeric(9,0) not null, call_sign char(10) null, location_number int null, antenna_number int null, frequency_assigned numeric(16,8) null, buildout_code int null, buildout_deadline char(10) null, buildout_date char(10) null ) on 'default' go create table dbo.PUBACC_BL ( record_type char(2) null, unique_system_identifier numeric(9,0) not null, call_sign char(10) null, location int null, buildout_code int null, buildout_deadline char(10) null, buildout_date char(10) null ) on 'default' go create table dbo.PUBACC_BO ( record_type char(2) null, unique_system_identifier numeric(9,0) not null, call_sign char(10) null, buildout_code int null, buildout_deadline char(10) null, buildout_date char(10) null ) on 'default' go create table dbo.PUBACC_CF ( Record_Type char(2) null, unique_system_identifier numeric(9,0) not null, ULS_File_Number char(14) null, EBF_Number varchar(30) null, Item_Type_Indicator char(1) null, Item_Type char(14) null, Constructed char(1) null, Location_Number int null, Path_Number int null, Frequency_Assigned numeric(16,8) null, Frequency_Upper_Band numeric(16,8) null, number_of_mobiles int null ) on 'default' go create table dbo.PUBACC_CO ( record_type char(2) not null, unique_system_identifier numeric(9,0) not null, uls_file_num char(14) null, callsign char(10) null, date char(10) null, description varchar(255) null ) on 'default' go create table dbo.PUBACC_CP ( record_type char(2) null, unique_system_identifier numeric(9,0) not null, uls_file_number char(14) null, ebf_number varchar(30) null, call_sign char(10) null, control_point_action_performed char(1) null, control_point_number int null, control_address varchar(80) null, control_city char(20) null, state_code char(2) null, control_phone char(10) null, control_county char(5) null ) on 'default' go create table dbo.PUBACC_CS ( record_type char(2) null, unique_system_identifier numeric(9,0) not null, uls_file_number char(14) null, call_sign char(10) null, location_number int null, antenna_number int null, frequency_assigned numeric(16,8) null, coser_result char(5) null ) on 'default' go create table dbo.PUBACC_EM ( record_type char(2) null, unique_system_identifier numeric(9,0) not null, uls_file_number char(14) null, ebf_number varchar(30) null, call_sign char(10) null, location_number int null, antenna_number int null, frequency_assigned numeric(16,8) null, emission_action_performed char(1) null, emission_code char(10) null, digital_mod_rate numeric(8,4) null, digital_mod_type char(6) null ) on 'default' go create table dbo.PUBACC_EN ( record_type char(2) not null, unique_system_identifier numeric(9,0) not null, uls_file_number char(14) null, ebf_number varchar(30) null, call_sign char(10) null, entity_type char(2) null, licensee_id char(9) null, entity_name varchar(200) null, first_name varchar(20) null, mi char(1) null, last_name varchar(20) null, suffix char(3) null, phone char(10) null, fax char(10) null, email varchar(50) null, street_address varchar(60) null, city varchar(20) null, state char(2) null, zip_code char(9) null, po_box varchar(20) null, attention_line varchar(35) null ) on 'default' go create table dbo.PUBACC_FC ( record_type char(2) null, unique_system_identifier numeric(9,0) not null, uls_file_number char(14) null, ebf_number varchar(30) null, coordination_number char(25) null, coordinator_name varchar(40) null, coordinator_phone char(10) null ) on 'default' go create table dbo.PUBACC_FR ( record_type char(2) null, unique_system_identifier numeric(9,0) not null, uls_file_number char(14) null, ebf_number varchar(30) null, call_sign char(10) null, frequency_action_performed char(1) null, location_number int null, antenna_number int null, class_station_code char(4) null, op_altitude_code char(2) null, frequency_assigned numeric(16,8) null, frequency_upper_band numeric(16,8) null, frequency_carrier numeric(16,8) null, time_begin_operations int null, time_end_operations int null, power_output numeric(7,3) null, power_erp numeric(7,3) null, tolerance numeric(6,5) null, frequency_ind char(1) null, status char(1) null, eirp numeric(7,1) null, transmitter_make varchar(25) null, transmitter_model varchar(25) null, auto_transmitter_power_control char(1) null ) on 'default' go create table dbo.PUBACC_FS ( record_type char(2) null, unique_system_identifier numeric(9,0) not null, call_sign char(10) null, location_number int null, antenna_number int null, frequency numeric(16,8) null, special_condition_code char(1) null, special_condition_desc_1 varchar(255) null, special_condition_desc_2 varchar(255) null, special_condition_desc_3 varchar(255) null, special_condition_desc_4 varchar(255) null, special_condition_desc_5 varchar(255) null ) on 'default' go create table dbo.PUBACC_HD ( record_type char(2) not null, unique_system_identifier numeric(9,0) not null, uls_file_number char(14) null, ebf_number varchar(30) null, call_sign char(10) null, license_status char(1) null, radio_service_code char(2) null, grant_date char(10) null, expired_date char(10) null, cancellation_date char(10) null, eligibility_rule_num char(10) null, applicant_type_code char(1) null, alien char(1) null, alien_government char(1) null, alien_corporation char(1) null, alien_officer char(1) null, alien_control char(1) null, revoked char(1) null, convicted char(1) null, adjudged char(1) null, involved char(1) null, common_carrier char(1) null, non_common_carrier char(1) null, private_comm char(1) null, fixed char(1) null, mobile char(1) null, radiolocation char(1) null, satellite char(1) null, developmental_or_sta char(1) null, interconnected_service char(1) null, certifier_first_name varchar(20) null, certifier_mi char(1) null, certifier_last_name varchar(20) null, certifier_suffix char(3) null, certifier_title char(40) null, gender char(1) null, african_american char(1) null, native_american char(1) null, hawaiian char(1) null, asian char(1) null, white char(1) null, ethnicity char(1) null, effective_date char(10) null, last_action_date char(10) null, auction_id numeric(9,0) null ) on 'default' go create table dbo.PUBACC_HS ( record_type char(2) not null, unique_system_identifier numeric(9,0) not null, uls_file_number char(14) null, callsign char(10) null, date char(10) null, code char(6) null ) on 'default' go create table dbo.PUBACC_IR ( record_type char(2) null, unique_system_identifier numeric(9,0) not null, uls_file_number char(14) null, call_sign char(10) null, location_number int null, antenna_number int null, frequency_assigned numeric(16,8) null, irac_result char(2) null ) on 'default' go create table dbo.PUBACC_LO ( record_type char(2) not null, unique_system_identifier numeric(9,0) not null, uls_file_number char(14) null, ebf_number varchar(30) null, call_sign char(10) null, location_action_performed char(1) null, location_type_code char(1) null, location_class_code char(1) null, location_number int null, site_status char(1) null, corresponding_fixed_location numeric(9,0) null, location_address varchar(80) null, location_city char(20) null, location_county varchar(60) null, location_state char(2) null, radius_of_operation numeric(5,1) null, area_of_operation_code char(1) null, clearance_indicator char(1) null, ground_elevation numeric(7,1) null, lat_degrees int null, lat_minutes int null, lat_seconds numeric(3,1) null, lat_direction char(1) null, long_degrees int null, long_minutes int null, long_seconds numeric(3,1) null, long_direction char(1) null, max_lat_degrees int null, max_lat_minutes int null, max_lat_seconds numeric(3,1) null, max_lat_direction char(1) null, max_long_degrees int null, max_long_minutes int null, max_long_seconds numeric(3,1) null, max_long_direction char(1) null, nepa char(1) null, quiet_zone_notification_date char(10) null, tower_registration_number char(10) null, height_of_support_structure numeric(7,1) null, overall_height_of_structure numeric(7,1) null, structure_type char(6) null, airport_id char(4) null, location_name char(20) null ) on 'default' go create table dbo.PUBACC_LS ( record_type char(2) null, unique_system_identifier numeric(9,0) not null, call_sign char(10) null, location_number int null, special_condition_type char(1) null, special_condition_desc_1 varchar(255) null, special_condition_desc_2 varchar(255) null, special_condition_desc_3 varchar(255) null, special_condition_desc_4 varchar(255) null, special_condition_desc_5 varchar(255) null ) on 'default' go create table dbo.PUBACC_MC ( record_type char(2) null, unique_system_identifier numeric(9,0) not null, uls_file_number char(14) null, ebf_number varchar(30) null, call_sign char(10) null, undefined_partitioned_area int null, partition_sequence_number int null, partition_lat_degrees int null, partition_lat_minutes int null, partition_lat_seconds numeric(3,1) null, partition_lat_direction char(1) null, partition_long_degrees int null, partition_long_minutes int null, partition_long_seconds numeric(3,1) null, partition_long_direction char(1) null ) on 'default' go create table dbo.PUBACC_MF ( record_type char(2) null, unique_system_identifier numeric(9,0) not null, uls_file_number char(14) null, ebf_number varchar(30) null, call_sign char(10) null, defined_partition_area char(6) null, lower_frequency numeric(16,8) null, upper_frequency numeric(16,8) null ) on 'default' go create table dbo.PUBACC_MK ( record_type char(2) null, unique_system_identifier numeric(9,0) not null, uls_file_number char(14) null, ebf_number varchar(30) null, call_sign char(10) null, market_code char(6) null, channel_block char(4) null, submarket_code int null, market_name char(30) null, coverage_partitioning char(1) null, coverage_dissagregation char(1) null, cellular_phase_id smallint null, population numeric(9,0) null ) on 'default' go create table dbo.PUBACC_MP ( record_type char(2) null, unique_system_identifier numeric(9,0) not null, uls_file_number char(14) null, ebf_number varchar(30) null, call_sign char(10) null, market_partition_code char(6) null, defined_partition_area varchar(60) null, defined_area_population numeric(9,0) null, include_exclude_ind char(1) null, undefined_partitioned_area numeric(9,0) null ) on 'default' go create table dbo.PUBACC_MW ( record_type char(2) not null, unique_system_identifier numeric(9,0) not null, uls_file_number char(14) null, ebf_number varchar(30) null, call_sign char(10) null, pack_indicator char(1) null, pack_registration_num int null, pack_name varchar(50) null, type_of_operation varchar(45) null, smsa_code char(6) null, station_class char(4) null, cum_effect_is_major char(1) null ) on 'default' go create table dbo.PUBACC_OP ( record_type char(2) not null, unique_system_identifier numeric(9,0) not null, uls_file_number char(14) null, ebf_number varchar(30) null, callsign char(10) null, location_number int null, area_text_sequence_num int null, area_of_operation varchar(255) null ) on 'default' go create table dbo.PUBACC_PA ( record_type char(2) null, unique_system_identifier numeric(9,0) not null, uls_file_number char(14) null, ebf_number varchar(30) null, callsign char(10) null, path_action_performed char(1) null, path_number int null, transmit_location_number numeric(9,0) null, transmit_antenna_number numeric(9,0) null, receiver_location_number numeric(9,0) null, receiver_antenna_number numeric(9,0) null, mas_dems_subtype char(2) null, path_type_code char(2) null, passive_receiver_indicator char(1) null, country_code char(3) null, interference_to_gso char(1) null, receiver_callsign varchar(10) null ) on 'default' go create table dbo.PUBACC_PC ( record_type char(2) null, unique_system_identifier numeric(9,0) not null, uls_file_number char(14) null, ebf_number varchar(30) null, call_sign char(10) null, action_performed char(1) null, location_number int null, antenna_number int null, frequency numeric(16,8) null, subscriber_call_sign char(10) null, city varchar(20) null, state char(2) null, north_latitude char(12) null, west_longitude char(13) null, point_of_com_frequency numeric(16,8) null ) on 'default' go create table dbo.PUBACC_RA ( record_type char(2) null, unique_system_identifier numeric(9,0) not null, uls_file_number char(14) null, ebf_number varchar(30) null, call_sign char(10) null, radial_action_performed char(1) null, location_number int null, antenna_number int null, frequency numeric(16,8) null, radial_direction numeric(3,0) null, radial_haat numeric(5,1) null, radial_erp numeric(7,3) null, dist_to_sab numeric(4,1) null, dist_to_cgsa numeric(4,1) null ) on 'default' go create table dbo.PUBACC_SC ( record_type char(2) null, unique_system_identifier numeric(9,0) not null, call_sign char(10) null, special_condition_type char(1) null, special_condition_desc1 varchar(255) null, special_condition_desc2 varchar(255) null, special_condition_desc3 varchar(255) null, special_condition_desc4 varchar(255) null, special_condition_desc5 varchar(255) null ) on 'default' go create table dbo.PUBACC_SG ( record_type char(2) null, unique_system_identifier numeric(9,0) not null, uls_file_number char(14) null, ebf_number varchar(30) null, call_sign char(10) null, segment_action_performed char(1) null, path_number int null, transmit_location int null, transmit_antenna int null, receiver_location int null, receiver_antenna int null, segment_number int null, segment_length numeric(6,1) null ) on 'default' go create table dbo.PUBACC_SI ( record_type char(2) null, unique_system_identifier numeric(9,0) not null, uls_file_number char(14) null, ebf_number varchar(30) null, call_sign char(14) null, sid char(4) null, action_performed char(1) null ) on 'default' go create table dbo.PUBACC_TA ( Record_Type char(2) null, unique_system_identifier numeric(9,0) not null, uls_file_number char(14) null, ebf_number varchar(30) null, pro_forma char(1) null, full_assignment char(1) null, method_of_accomplishment char(1) null, method_other_description varchar(30) null, voluntary_involuntary char(1) null, assignor_certifier_first_name varchar(20) null, assignor_certifier_mi varchar(1) null, assignor_certifier_last_name char(20) null, assignor_certifier_suffix varchar(3) null, assignor_certifier_title varchar(20) null, gross_revenue_year_1 money null, gross_revenue_year_2 money null, gross_revenue_year_3 money null, total_assets money null, same_small_category char(1) null, applying_for_installments char(1) null, notification_of_forebearance char(1) null, wireless_need_approval char(1) null, non_wireless_need_approval char(1) null, male_or_female char(1) null, african_american char(1) null, native_american char(1) null, native_pacific_islander char(1) null, asian char(1) null, white char(1) null, ethnicity char(1) null, consent_date char(10) null, consummation_date char(10) null, consummation_deadline char(10) null ) on 'default' go create table dbo.PUBACC_VC ( record_type char(2) null, unique_system_identifier numeric(9,0) not null, uls_file_number char(14) null, ebf_number varchar(30) null, request_sequence int null, callsign_requested char(10) null ) on 'default' go