ATTACHMENT E FILE FORMATS This attachment describes the formats for the round results files that will be uploaded to the FCC Internet site and FCC Auction Bulletin Board Systems (BBS) 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. 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, wtbwww13.fcc.gov: ? http://wtbwww13.fcc.gov/Paging/Auction_26/Results/dbf/ ? http://wtbwww13.fcc.gov/Paging/Auction_26/Results/mdb/ ? http://wtbwww13.fcc.gov/Paging/Auction_26/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: wtbwww01.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, wtbwww13.fcc.gov: Rounds 1-50 http://wtbwww13.fcc.gov/Paging/Auction_26/Results/dbf/D001_050 Rounds 51-100 http://wtbwww13.fcc.gov/Paging/Auction_26/Results/dbf/D051_100 Rounds 101-102 http://wtbwww13.fcc.gov/Paging/Auction_26/Results/dbf/ Rounds 1-50 http://wtbwww13.fcc.gov/Paging/Auction_26/Results/mdb/M001_050 Rounds 51-100 http://wtbwww13.fcc.gov/Paging/Auction_26/Results/mdb/M051_100 Rounds 101-102 http://wtbwww13.fcc.gov/Paging/Auction_26/Results/mdb/ Rounds 1-50 http://wtbwww13.fcc.gov/Paging/Auction_26/Results/txt/T001_050 Rounds 51-100 http://wtbwww13.fcc.gov/Paging/Auction_26/Results/txt/T051_100 Rounds 101-102 http://wtbwww13.fcc.gov/Paging/Auction_26/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: wtbwww01.fcc.gov or www.fcc.gov/wtb/auctions/. Tracking the FCC Mock Auction Mock Auction round results and announcement files will be posted on the FCC Internet and FCC Auction Bulletin Board Systems (BBS) in the same location as the auction results. The directory structure for the mock auction will be as follows: On the primary location, wtbwww13.fcc.gov: ? http://wtbwww13.fcc.gov/Mock/Results/dbf/ ? http://wtbwww13.fcc.gov/Mock/Results/mdb/ ? http://wtbwww13.fcc.gov/Mock/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: wtbwww01.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 license you want, such as MEA001 A. Auction Tracking Tool File Format There will be a single Auction Tracking Tool file for each round of the auction. The following layout describes the tables and fields within the mdb round file. The mdb files are for use with the new FCC Auction Tracking Tool. All Bids table Auction ID Long Integer Round Long Integer License Name Text(15) Market Text(6) Block Text(2) Submarket Long Integer Bidder Text(50) Increments of Bid Long Integer Gross Bid Amount Currency Net Bid Amount Currency Bidders table Auction ID Long Integer Round Long Integer Bidder Text(50) FCC Acct Text(10) Bidding Credit Single Initial Eligibility Long Integer Current Eligibility Long Integer Change in Eligibility Long Integer Waiver Type Text(4) New Bids Long Integer Gross Bids Currency Net Bids Currency Total High Bids Long Integer Gross High Bids Currency Net High Bids Currency Current Activity Long Integer Additional Required Activity Long Integer Unused Elig Long Integer Waivers Remaining Long Integer Withdrawals Remaining Long Integer Bidders Raising Own High Bid table Auction ID Long Integer Round Long Integer License Name Text(15) Major Grouping Text(6) Minor Grouping Text(6) Block Text(2) Submarket Long Integer Bidder Text(50) Increments of Bid Long Integer Gross Bid Amount Currency Net Bid Amount Currency Bidders Who Reduced table Auction ID Long Integer Round Long Integer Bidder Who Reduced Text(50) Reduction Amt Long Integer Current Eligibility Long Integer Increment Statistics table Auction ID Long Integer Round Long Integer 1 Long Integer 2 Long Integer 3 Long Integer 4 Long Integer 5 Long Integer 6 Long Integer 7 Long Integer 8 Long Integer 9 Long Integer Markets table Auction ID Long Integer Round Long Integer License Name Text(15) Major Grouping Text(6) Minor Grouping Text(6) Block Text(2) Submarket Long Integer License Size Double Market Name Text(50) BUs Long Integer Population Long Integer Number of Bids Long Integer High Bidder Text(50) Round of High Bid Long Integer Increments of Bid Long Integer Gross Currency Bidding Credit Single Net Currency Min Acceptable Bid Currency Bid Increment Currency Prev High Bidder Text(50) Round of Prev High Bid Long Integer Prev Gross Currency Prev Bidding Credit Single Prev Net Currency Selected Long Integer All Selected Long Integer Round Statistics table Auction ID Long Integer Round Long Integer Round Date Date/Time Stage Long Integer New Bids Long Integer Total High Bids Long Integer Pctg of BUs for All Bids Single Pctg of BUs for High Bids Single Gross Bids Currency Net Bids Currency Dollar Change in Net Bids Currency Pctg Change in Net Bids Single Eligible Bidders Long Integer Bidders At Risk Long Integer Number Reduced Long Integer BUs Reduced Double Eligibility Ratio Single Pctg of Covered BUs Single Waivers Long Integer Withdrawals Long Integer FCC Held Licenses Long Integer Pctg of Covered Pops Single Pctg of the Covered Pops with Bidding Credit Single Waiver Statistics table Auction ID Long Integer Round Long Integer Bidder Text(50) Waiver Type Text(1) Remaining Waivers Long Integer Withdrawal Statistics table Auction ID Long Integer Withdrawal Number Long Integer Bidder Text(50) License Name Text(15) Market Text(6) Block Text(2) Submarket Long Integer BUs Long Integer Population Long Integer Round Long Integer Gross Currency Net Currency Min Bid Currency New High Bidder Text(50) New High Bid Round Long Integer Gross High Bid Currency Net High Bid Currency 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. 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) time char(14) net_bid_amt numeric sort_col_1 numeric sort_col_2 numeric sub_market numeric 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) 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 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 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) time char(14) net_bid_amt numeric sort_col_1 numeric sort_col_2 numeric sub_market numeric 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 1 E - 1