Attachment F 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 System (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 new FCC Auction tracking tool. The other files are in dbf and txt format and contain the raw output of the auction data. Please note that the directory structure for the results files has been changed to the following and these file structures replace those described on page 123 of the VHF Public Coast Service Auction Bidder Information Package. The newest round results are uploaded to the Results directory based on type of file format: dbf, mdb, and txt. pub/Auctions/VPC/Auction_20/Results/dbf pub/Auctions/VPC/Auction_20/Results/mdb pub/Auctions/VPC/Auction_20/Results/txt 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 wtbwww01.fcc.gov: Rounds 1-50 pub/Auctions/VPC/Auction_20/Results/dbf/D001_050 Rounds 51-100 pub/Auctions/VPC/Auction_20/Results/dbf/D051_100 Rounds 101-102 pub/Auctions/VPC/Auction_20/Results/dbf Rounds 1-50 pub/Auctions/VPC/Auction_20/Results/mdb/M001_050 Rounds 51-100 pub/Auctions/VPC/Auction_20/Results/mdb/M051_100 Rounds 101-102 pub/Auctions/VPC/Auction_20/Results/mdb Rounds 1-50 pub/Auctions/VPC/Auction_20/Results/txt/T001_050 Rounds 51-100 pub/Auctions/VPC/Auction_20/Results/txt/T051_100 Rounds 101-102 pub/Auctions/VPC/Auction_20/Results/txt On www.fcc.gov: Rounds 1-50 pub/Auctions/VPC/Auction_20/Results/dbf/D001_050 Rounds 51-100 pub/Auctions/VPC/Auction_20/Results/dbf/D051_100 Rounds 101-102 pub/Auctions/VPC/Auction_20/Results/dbf Rounds 1-50 pub/Auctions/VPC/Auction_20/Results/mdb/M001_050 Rounds 51-100 pub/Auctions/VPC/Auction_20/Results/mdb/M051_100 Rounds 101-102 pub/Auctions/VPC/Auction_20/Results/mdb Rounds 1-50 pub/Auctions/VPC/Auction_20/Results/txt/T001_050 Rounds 51-100 pub/Auctions/VPC/Auction_20/Results/txt/T051_100 Rounds 101-102 pub/Auctions/VPC/Auction_20/Results/txt Tracking the FCC Mock Auction Mock Auction round results and announcement files will be posted on the FCC Internet and FCC Auction Bulletin Board System (BBS) in the same location as the auction results. The directory structure for the mock auction will be as follows: pub/Auctions/Mock/Auction_74/Results/dbf pub/Auctions/Mock/Auction_74/Results/mdb pub/Auctions/Mock/Auction_74/Results/txt 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. HIGH BIDS BY MARKET table Auction Id Long Integer Round Long Integer License Name Text (9) Major Grouping Text (6) Minor Grouping Text (6) Block Text (2) Market Name Text (50) Population Long Integer BUs Long Integer High Bidder Text (50) Round of High Bid Long Integer Gross Currency Bidding Credit Single Net Currency Bid Increments Long Integer Prev High Bidder Text (50) Round of Prev High Bid Long Integer Prev Gross Currency Prev Bidding Credit Single Prev Net Currency MARKET INFORMATION table Auction Id Long Integer Round Long Integer License Name Text (9) Major Grouping Text (6) Minor Grouping Text (6) Block Text (2) Market Name Text (50) Population Long Integer Bidding Units Long Integer Bids Long Integer Min Acceptable Bid Currency Selected Long Integer All Selected Long Integer WITHDRAWAL STATISTICS table Auction Id Long Integer Withdrawal Number Long Integer Bidder Text (50) Market Text (6) Block Text (2) Round Long Integer Gross Currency Net Currency Min Bid Currency New High Bidder Text (50) High Bid Round Long Integer Gross High Bid Currency Net High Bid Currency 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 AND BIDDERS table Auction Id Long Integer Round Long Integer Market Text (6) Block Text (2) Bidder Text (50) Bid Amount Currency Net Bid Amount Currency MISCELLANEOUS STATISTICS table Auction Id Long Integer Round Long Integer Eligible Bidders Long Integer Eligibility Ratio Single Pctg of BUs Covered Single Waivers Long Integer Bids Withdrawn Long Integer FCC Held Licenses Long Integer Pctg of Covered Pops Single Pctg of the 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 ACTIVITY OF BIDDERS table Auction Id Long Integer Round Long Integer Bidder Name Text (50) FCC Acct Text (10) Waiver Type Text (1) 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 Required Activity Long Integer ACTIVITY OF BIDDERS table (cont'd) Unused Elig from Prev Round Long Integer ELIGIBILITY OF BIDDERS table Auction Id Long Integer Round Long Integer Bidder Name Text (50) FCC Acct Text (10) Bidding Credit Single Initial Eligibility Long Integer Current Eligibility Long Integer Change in Eligibility Long Integer Waivers Remaining Long Integer Withdrawals Remaining Long Integer BIDDERS WHO REDUCED table Auction Id Long Integer Round Long Integer Bidder Who Reduced Text (50) Reduction Amt Long Integer Current Eligibility Long Integer REDUCTION STATISTICS table Auction Id Long Integer Round Long Integer Bidders Who Reduced Long Integer BUs Reduced Long Integer Bidders at Risk Long Integer Withdrawals 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 High Bids Currency Net High Bids Currency Dollar Change in Net High Bids Currency ROUND STATISTICS table (cont'd) Pctg Change in Net High Bids Single 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 date time char(8) net_bid_amt numeric sort_col_1 numeric sort_col_2 numeric HIGH_BIDS file market char(6) freq_block char(2) bid_round_num numeric bid_amt numeric bidder_num numeric fcc_acct char(10) date date time char(8) net_bid_amt numeric min_accept numeric num_of_bids numeric sort_col_1 numeric sort_col_2 numeric MAXIMUM_ELIGIBILITY file round_num numeric bidder_num numeric fcc_acct char(10) MAXIMUM_ELIGIBILITY file (cont'd) 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_num numeric bid_amt numeric bidder_num numeric fcc_acct char(10) date date time char(8) net_bid_amt numeric sort_col_1 numeric sort_col_2 numeric BIDDER_CROSS_REFERENCE file bidder_num numeric fcc_acct char(10) co_name char(50) bidding_credit_pctg numeric