*Pages 1--3 from  Microsoft Word - 12424.doc*
 A  -  1 
 ATTACHMENT  A 
 AUCTION  BIDDING  SYSTEM  FILE  DEFINITIONS 
 A.  Round  Results  File  Formats 
 The  following  layouts  are  for  the  dbf  files.  The  first  column  provides  the  name  of  each  field,  and  the 
 second  column  provides  the  corresponding  field  type.  The  txt  files  will  have  identical  fields  but  character 
 field  types. 


 1.  ALL_  BIDS  file 
 market  char(  6) 
 freq_  block  char(  2) 
 round_  num  numeric 
 bid_  amt  numeric 
 bidder_  num  numeric 
 fcc_  acct  char(  10) 
 date  char(  10) 
 net_  bid_  amt  numeric 
 sort_  col_  1  numeric 
 sort_  col_  2  numeric 
 sub_  market  numeric 
 random_  num  double 


 2.  HIGH_  BIDS  file 
 market  char(  6) 
 freq_  block  char(  2) 
 bid_  round  numeric 
 bid_  amt  numeric 
 bidder_  num  numeric 
 fcc_  acct  char(  10) 
 date  char(  10) 
 net_  bid_  amt  numeric 
 min_  accept  numeric 
 num_  of_  bids  numeric 
 min_  incr_  2  double 
 sort_  col_  1  numeric 
 sort_  col_  2  numeric 
 sub_  market  numeric 
1
 A  -  2 
 3.  MAXIMUM_  ELIGIBILITY  file 
 round_  num  numeric 
 bidder_  num  numeric 
 fcc_  acct  char(  10) 
 max_  elig  numeric 
 rmng_  waivr  numeric 
 waivr_  ind  char(  1) 
 rmng_  withdrawals  numeric 
 required_  act  numeric 
 current_  act  numeric 


 4.  WITHDRAWALS  file 
 market  char(  6) 
 freq_  block  char(  2) 
 bid_  round  numeric 
 bid_  amt  numeric 
 bidder_  num  numeric 
 fcc_  acct  char(  10) 
 date  char(  10) 
 net_  bid_  amt  numeric 
 sort_  col_  1  numeric 
 sort_  col_  2  numeric 
 sub_  market  numeric 


 5.  BIDDER_  CROSS_  REFERENCE  file 
 bidder_  num  numeric 
 fcc_  acct  char(  10) 
 co_  name  char(  50) 
 bidding_  credit_  pctg  numeric 


 6.  MARKET_  CROSS_  REFERENCE  file 
 license_  name  char(  15) 
 market  char(  6) 
 freq_  block  char(  2) 
 sub_  market  numeric 
 license  char(  11) 
 market_  Desc  char(  50) 
 bid_  units  int 
 population  int 
2
 A  -  3 
 B.  Results  Explorer  Export  File  Format 
 The  Results  Explorer  provides  an  option  to  export  a  comma-  delimited  text  file.  The  export  file  contains  the 
 following  fields: 


 market 
 block/  channel 
 default  bid  increment  (value  =  ‘1’) 
 round  number 
 company 
 standing  high  bid  amount 
 minimum  acceptable  bid  (for  the  round  after  the  selected  round  number) 
 bid  increment  amount  (for  the  round  after  the  selected  round  number) 
3