
create table PA_AD
(
	record_type                       char(2)         not null,
	unique_system_identifier          numeric(9,0)    not null,
	tuls_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                      datetime        null,
	notification_code                 char(1)         null,
	notification_date                 datetime        null,
	expanding_area_or_contour         char(1)         null,
	major_minor_indicator             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_number                varchar(16)     null,
	date_entered                      datetime        null,
	unused                            varchar(255)    null,
	frequency_coordination_indicat    char(1)         null,
	emergency_sta                     char(1)         null,
	overall_change_type               char(1)         null,
	extended_implementation_plan      char(1)         null,
	previous_waiver                   char(1)         null,
	non_commercial_educational        char(1)         null,
	status_date                       datetime        null,
	commission_action_date            datetime        null
)
go

create table PA_AN
(
	record_type               char(2)              not null,
	unique_system_identifier  numeric(9,0)         not null,
	tuls_file_number          char(14)             null,
	ebf_number                varchar(30)          null,
	call_sign                 char(12)             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(5,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,
	line_loss                 numeric(3,1)         null,
	rcamsl                    numeric(5,1)         null,
	directional_type          char(1)              null,
	rcagl                     numeric(5,1)         null
)
go

create table PA_AS
(
	record_type               char(2)              not null,
	unique_system_identifier  numeric(9,0)         not null,
	tuls_file_number          char(14)             null,
	ebf_number                varchar(30)          null,
	call_sign                 char(12)             null,
	associated_callsign       char(12)             null,
	lead_indicator            char(1)              null
)
go

create table PA_AT
(
	record_type               char(2)              not null,
	unique_system_identifier  numeric(9,0)         not null,
	tuls_file_number          char(14)             null,
	ebf_number                varchar(30)          null,
	call_sign                 char(12)             null,
	attachment_code           char(1)              null,
	attachment_description    varchar(255)         null,
	attachment_date           datetime             null,
	attachment_file_name      varchar(255)         null,
	attachment_action_performed char(1)            null
)
go

create table PA_BF
(
	record_type               char(2)              not null,
	unique_system_identifier  numeric(9,0)         not null,
	call_sign                 char(12)             null,
	location_number           int                  null,
	antenna_number            int                  null,
	frequency_assigned        numeric(16,8)        null,
	buildout_code             int                  null,
	buildout_deadline         datetime             null,
	buildout_date             datetime             null
)
go

create table PA_CO
(
	record_type               char(2)              not null,
	unique_system_identifier  numeric(9,0)         not null,
	tuls_file_number          char(14)             null,
	call_sign                 char(12)             null,
	comment_date              datetime             null,
	description_seq_num       int                  null,
	description               varchar(255)         null
)
go

create table PA_EM
(
	record_type               char(2)              not null,
	unique_system_identifier  numeric(9,0)         not null,
	tuls_file_number          char(14)             null,
	ebf_number                varchar(30)          null,
	call_sign                 char(12)             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,1)         null,
	digital_mod_type          char(7)              null,
	frequency_number          int                  null,
	emission_number           int                  null,
	emisison_type             char(1)              null
)
go

create table PA_EN
(
	record_type               char(2)              not null,
	unique_system_identifier  numeric(9,0)         not null,
	tuls_file_number          char(14)             null,
	ebf_number                varchar(30)          null,
	call_sign                 char(12)             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,
	sgin                      char(3)              null,
	frn                       char(10)             null
)
go

create table PA_FR
(
	record_type               char(2)              not null,
	unique_system_identifier  numeric(9,0)         not null,
	tuls_file_number          char(14)             null,
	ebf_number                varchar(30)          null,
	call_sign                 char(12)             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(15,3)        null,
	power_erp                 numeric(15,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,
	cnt_mobile_units          int                  null,
	cnt_mob_pagers            int                  null,
	freq_seq_id               int                  null,
	channel                   char(3)              null,
	offset                    int                  null
)
go

create table PA_HD
(
	record_type               char(2)              not null,
	unique_system_identifier  numeric(9,0)         not null,
	tuls_file_number          char(14)             null,
	ebf_number                varchar(30)          null,
	call_sign                 char(12)             null,
	license_status            char(1)              null,
	radio_service_code        char(2)              null,
	grant_date                datetime             null,
	expired_date              datetime             null,
	cancellation_date         datetime             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            datetime             null,
	last_action_date          datetime             null,
	auction_id                int                  null,
	reg_stat_broad_serv       char(1)              null,
	band_manager              char(1)              null,
	type_serv_broad_serv      char(1)              null,
	engineering_file_number   char(12)             null,
	facility_type             char(4)              null,
	facility_id               int                  null
)
go

create table PA_HS
(
	record_type               char(2)              not null,
	unique_system_identifier  numeric(9,0)         not null,
	tuls_file_number          char(14)             null,
	call_sign                 char(12)             null,
	history_date              datetime             null,
	code                      char(6)              null
)
go

create table PA_LO
(
	record_type               char(2)              not null,
	unique_system_identifier  numeric(9,0)         not null,
	tuls_file_number          char(14)             null,
	ebf_number                varchar(30)          null,
	call_sign                 char(12)             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 int               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 datetime          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,
	units_hand_held           int                  null,
	units_mobile              int                  null,
	units_temp_fixed          int                  null,
	units_aircraft            int                  null,
	units_itinerant           int                  null,
	authorization_type_indicator char(3)           null,
	nad_code                  char(1)              null
)
go

create table PA_MK
(
	record_type               char(2)              not null,
	unique_system_identifier  numeric(9,0)         not null,
	tuls_file_number          char(14)             null,
	ebf_number                varchar(30)          null,
	call_sign                 char(12)             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,
	tribal_credit_indicator   char(1)              null,
	tribal_credit_calculation money                null,
	additional_credit_requested money              null,
	tribal_credit_awarded     money                null,
	additional_credit_awarded money                null,
	authorization_type_indicator char(3)           null,
	psa_comment_sequence_no   integer              null,
	psa_comment               varchar(255)         null
)
go

create table PA_PS
(
	record_type               char(2)              not null,
	unique_system_identifier  numeric(9,0)         not null,
	tuls_file_number          char(14)             null,
	ebf_number                varchar(30)          null,
	call_sign                 char(12)             null,
	action_performed          char(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,
	nad_code                  char(1)              null
)
go

create table PA_RS
(
	record_type               char(2)              not null,
	unique_system_identifier  numeric(9,0)         not null,
	tuls_file_number          char(14)             null,
	ebf_number                varchar(30)          null,
	call_sign                 char(12)             null,
	antenna_action_performed  char(1)              null,
	receive_site_number       int                  null,
	antenna_make              varchar(25)          null,
	antenna_model             varchar(25)          null,
	nad_code                  char(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,
	polarization_code         char(5)              null,
	directional_type          char(1)              null
)
go

create table PA_SC
(
	record_type               char(2)              not null,
	unique_system_identifier  numeric(9,0)         not null,
	call_sign                 char(12)             null,
	special_condition_type    char(1)              null,
	special_condition_code    int                  null
)
go

create table PA_SF
(
	record_type               char(2)              not null,
	unique_system_identifier  numeric(9,0)         not null,
	call_sign                 char(12)             null,
	license_free_form_type    char(1)              null,
	unique_license_free_form_id numeric(9,0)       null,
	sequence_number           int                  null,
	license_free_form_condition varchar(255)       null
)
go

