Attachment D
  
                        FILE FORMATS
  
  This attachment describes the formats for the round results files that will be uploaded to
  the FCC Internet site after each round of the auction.  There are three sets of results files.
  The first set of files is in Microsoft Access 97 mdb format and contains the data tables for
  the FCC Auction Tracking Tool. The other files are in dbf and txt format and contain the
  raw output of the auction data.
  
  
            A.   Locations of Uploaded Files
  The newest round results are uploaded to the Results directory based on type of file format: dbf,
  mdb (zip files), and txt.
  
  On the primary location, wtbwww01.fcc.gov:
  
          · http://wtbwww01.fcc.gov/MMB/CP3/Auction_28/Results/dbf/
          · http://wtbwww01.fcc.gov/MMB/CP3/Auction_28/Results/mdb/
          · http://wtbwww01.fcc.gov/MMB/CP3/Auction_28/Results/txt/
  
       Note: If you cannot access these files at the preceding primary location, you can
       access the same files at either of the following secondary locations:
       wtbwww13.fcc.gov or www.fcc.gov/wtb/auctions/.
       
  After every 50 rounds, files will be moved from the Results directory to archive
  directories.  The following listings show an example of the directory structure for an
  auction in round 102.  Note that the results for rounds 101 and 102 would be in the
  Results directories.
  
  On the primary location, wtbwww01.fcc.gov:
  
  Rounds 1-50       http://wtbwww01.fcc.gov/MMB/CP3/Auction_28/Results/dbf/D001_050
  Rounds 51-100     http://wtbwww01.fcc.gov/MMB/CP3/Auction_28/Results/dbf/D051_100
  Rounds 101-102   http://wtbwww01.fcc.gov/MMB/CP3/Auction_28/Results/dbf/
  
  Rounds 1-50       
  http://wtbwww01.fcc.gov/MMB/CP3/Auction_28/Results/mdb/M001_050
  Rounds 51-100     
  http://wtbwww01.fcc.gov/MMB/CP3/Auction_28/Results/mdb/M051_100
  Rounds 101-102    http://wtbwww01.fcc.gov/MMB/CP3/Auction_28/Results/mdb/
  
  Rounds 1-50        http://wtbwww01.fcc.gov/MMB/CP3/Auction_28/Results/txt/T001_050
  Rounds 51-100     
  http://wtbwww01.fcc.gov/MMB/CP3/Auction_28/Results/txt/T051_100
  Rounds 101-102    http://wtbwww01.fcc.gov/MMB/CP3/Auction_28/Results/txt/
  
       Note:  If you cannot access the files at the preceding primary location, you can
       access the same files at either of the following secondary locations:
       wtbwww13.fcc.gov or www.fcc.gov/wtb/auctions/.
  
  
            A.   Tracking the FCC Mock Auction
  
  Mock Auction round results and announcement files will be posted on the FCC Internet in
  the same location as the auction results.  The directory structure for the mock auction will
  be as follows:
  
  On the primary location, wtbwww01.fcc.gov:
  
          · http://wtbwww01.fcc.gov/MMB/CP3/Auction_28/Results/dbf/
          · http://wtbwww01.fcc.gov/MMB/CP3/Auction_28/Results/mdb/
          · http://wtbwww01.fcc.gov/MMB/CP3/Auction_28/Results/txt/
  
  If you cannot access the files at the preceding primary location, you can access the same
  files at either of the following secondary locations: wtbwww13.fcc.gov or
  www.fcc.gov/wtb/auctions/.
  
       Obtaining Round Results From a Touch-Tone Phone:  You can also obtain
       round results from a touch-tone phone, using our Automated Round Results
       System.  Just dial 800-432-2110 and follow the voice prompts.  You will need to
       know the name of the construction permit you want, such as SST 10.
  
          A.   Round Results Files
The round results files were used by the previous Excel based tracking tool produced by the FCC and are
still being distributed for those bidders who use them for their own tracking purposes. The following
layouts are for the dbf files.  The txt files will have character field types.

               1.   ALL_BIDS file
mx_group       char(6)
freq_block          char(2)
round_num      numeric
bid_amt        numeric
bidder_num          numeric
fcc_acct       char(10)
date           char(10)
time           char(14)
net_bid_amt         numeric
sort_col_1          numeric
sort_col_2          numeric
sub_market          numeric

               2.   HIGH_BIDS file
mx_group       char(6)
freq_block          char(2)
bid_round      numeric
bid_amt        numeric
bidder_num          numeric
fcc_acct       char(10)
date           char(10)
time           char(14)
net_bid_amt         numeric
min_accept          numeric
num_of_bids         numeric
sort_col_1          numeric
sort_col_2          numeric
sub_market          numeric

               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_activity    numeric

               4.   WITHDRAWALS file
mx_group       char(6)
freq_block          char(2)
bid_round      numeric
bid_amt        numeric
bidder_num          numeric
fcc_acct       char(10)
date           char(10)
time           char(14)
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
short_name          char(10)
bidder_num          numeric