create table dbo.PUBACC_UM_RD
(
      Record_Type                 char(2)            null,
      unique_system_identifier    numeric(9,0)       not null,
      uls_file_number             char(14)           null,         
      source                      char (1)           null, 
      appl_purpose_code           char(2)            null,
      appl_status_code            char(1)            null,
      radio_service_code          char(2)            null,
      waiver                      char(1)            null,
      a_min_dev_res_ind           char(1)            null, 
      a_min_dev_other_ind         char(1)            null,
      a_qualify_ind               char(1)            null, 
      a_min_addl_channels         int		     null,
      a_max_addl_channels         int		     null,
      a_max_wireless_microphones  int                null, 
      a_certifier_fname           varchar(20)        null,
      a_certifier_mi              char(1)            null,
      a_certifier_lname           varchar(20)        null,
      a_certifier_suffix          char(3)	     null,
      a_certifier_title           char(40)           null,
      appl_date_entered           datetime           null,      
      appl_date_receipt           datetime           null, 
      a_grant_date                datetime           null, 
      a_expired_date              datetime           null, 
      appl_date_action            datetime           null
) 

go 


create table dbo.PUBACC_UM_NA

(
      Record_Type                 char(2)            null,
      unique_system_identifier    numeric(9,0)       not null,
      uls_file_number             char(14)           null, 
      entity_type                 char(1)            null,    
      frn                         numeric(10,0)      null,            
      entity_name                 varchar(200)       null,      
      first_name                  varchar(20)        null,        
      mi                          char(1)            null, 
      last_name                   varchar(20)        null,        
      suffix                      char(3)            null,       
      attention_line              varchar(35)        null,    
      po_box                      varchar(20)        null,           
      street_address              varchar(60)        null,
      city                        varchar(20)        null, 
      state                       char(2)            null,         
      zip_code                    char(9)            null,       
      phone                       char(10)           null, 
      fax                         char(10)           null, 
      email                       varchar(50)        null
) 

go


create table dbo.PUBACC_UM_CH

(
      Record_Type                 char(2)            null,
      unique_system_identifier    numeric(9,0)       not null,
      uls_file_number             char(14)           null, 
      reserved_ind                char(1)            null, 
      a_channel_id                numeric(9,0)       null,   
      channel_number              varchar(3)         null, 
      a_channel_seq_id            int                null, 
      a_user_code                 char(1)            null,   
      a_user_seq_id               int                null,   
      a_other_user_name           varchar(50)        null, 
      a_num_devices               int                null  
) 

go



create table dbo.PUBACC_UM_VN 
(
      Record_Type                 char(2)            null,
      unique_system_identifier    numeric(9,0)       not null,
      uls_file_number             char(14)           null, 
      a_venue_name                varchar(255)       null,           
      a_venue_type_code           varchar(2)         null,     
      a_venue_description         varchar(255)       null,      
      a_venue_address1            varchar(80)        null,       
      a_venue_city                varchar(20)        null,           
      a_venue_county_code         varchar(5)         null,     
      a_venue_state               varchar(2)         null,            
      a_venue_zip                 varchar(9)         null,             
      a_venue_coordinate_code     char(1)            null
) 

go 


create table dbo.PUBACC_UM_L1
(
      Record_Type                 char(2)            null,
      unique_system_identifier    numeric(9,0)       not null,
      uls_file_number             char(14)           null,
      a_coord_seq_id              int                null, 
      a_lat_deg                   int                null, 
      a_lat_min                   int                null, 
      a_lat_sec                   numeric(3,1)       null, 
      a_lat_dir                   char(1)            null, 
      a_long_deg                  int                null, 
      a_long_min                  int                null, 
      a_long_sec                  numeric(3,1)       null, 
      a_long_dir                  char(1)            null 
) 

go 


create table dbo.PUBACC_UM_EV 
(
      Record_Type                 char(2)            null,
      unique_system_identifier    numeric(9,0)       not null,
      uls_file_number             char(14)           null,
      a_schedule_type             char(1)            null,  
      a_event_seq_id              int                null,    
      a_event_start_date          datetime           null, 
      a_event_end_date            datetime           null,  
      start_time                  datetime           null,       
      end_time                    datetime           null,       
      a_sunday_ind                char(1)            null,      
      a_monday_ind                char(1)            null,     
      a_tuesday_ind               char(1)            null,   
      a_wednesday_ind             char(1)            null,  
      a_thursday_ind              char(1)            null,   
      a_friday_ind                char(1)            null,   
      a_saturday_ind              char(1)            null
) 

go 


create table dbo.PUBACC_UM_C1

(
      Record_Type                 char(2)            null,
      unique_system_identifier    numeric(9,0)       not null,
      uls_file_number             char(14)           null,
      comment_date                datetime           null, 
      description                 varchar(255)       null,
      status_code                 char(1)            null,
      status_date                 datetime           null
) 

go


create table dbo.PUBACC_UM_A4
(
      Record_Type                 char(2)            null,
      unique_system_identifier    numeric(9,0)       not null,
      uls_file_number             char(14)           null,
      Attachment_Code             varchar(5)         null,
      Attachment_Description      varchar(60)	     null,
      Attachment_Date		  datetime	     null,
      Attachment_file_name        varchar(60)	     null,
      Attachment_action_performed char(1)	     null 
)

go