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 new 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:
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
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
Rounds 51-100
Rounds 101-102
Rounds 1-50
Rounds 51-100
Rounds 101-102
Rounds 1-50
Rounds 51-100
Rounds 101-102
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 .
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:
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 .
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 IDLong Integer
RoundLong Integer
License NameText(9)
MarketText(6)
BlockText(2)
SubmarketInteger
BidderText(50)
Increments of BidLong Integer
Gross Bid AmountCurrency
Net Bid AmountCurrency
Bidders table
Auction IDLong Integer
RoundLong Integer
BidderText(50)
FCC AcctText(10)
Bidding CreditSingle
Initial EligibilityLong Integer
Current EligibilityLong Integer
Change in EligibilityLong Integer
Waiver TypeText(1)
New BidsLong Integer
Gross BidsCurrency
Net BidsCurrency
Total High BidsLong Integer
Gross High BidsCurrency
Net High BidsCurrency
Current ActivityLong Integer
Required ActivityLong Integer
Unused Elig from Prev RoundLong Integer
Waivers RemainingLong Integer
Withdrawals RemainingLong Integer
Bidders Raising Own High Bid table
Auction IDLong Integer
RoundLong Integer
License NameText(9)
Major GroupingText(6)
Minor GroupingText(6)
BlockText(2)
SubmarketInteger
BidderText(50)
Increments of BidLong Integer
Gross Bid AmountCurrency
Net Bid AmountCurrency
Bidders Who Reduced table
RoundLong Integer
Bidder Who ReducedText(50)
Reduction AmtLong Integer
Current EligibilityLong Integer
Increment Statistics table
Auction ID Long Integer
RoundLong Integer
1Long Integer
2Long Integer
3Long Integer
4Long Integer
5Long Integer
6Long Integer
7Long Integer
8Long Integer
9Long Integer
Markets table
Auction IDLong Integer
RoundLong Integer
License NameText(9)
Major GroupingText(6)
Minor GroupingText(6)
BlockText(2)
SubmarketInteger
License SizeDouble
Market NameText(50)
BUsLong Integer
PopulationLong Integer
Number of BidsLong Integer
High BidderText(50)
Round of High BidLong Integer
Increments of BidLong Integer
GrossCurrency
Bidding CreditSingle
NetCurrency
Min Acceptable BidCurrency
Bid IncrementCurrency
Prev High BidderText(50)
Round of Prev High BidLong Integer
Prev GrossCurrency
Prev Bidding CreditSingle
Prev NetCurrency
SelectedLong Integer
All SelectedLong Integer
Round Statistics table
Auction IDLong Integer
RoundLong Integer
Round DateDate/Time
StageLong Integer
New BidsLong Integer
Total High BidsLong Integer
Pctg of BUs for All BidsSingle
Pctg of BUs for High BidsSingle
Gross BidsCurrency
Net BidsCurrency
Dollar Change in Net BidsCurrency
Pctg Change in Net BidsSingle
Eligible BiddersLong Integer
Bidders At RiskLong Integer
Number ReducedLong Integer
BUs ReducedLong Integer
Eligibility RatioSingle
Pctg of Covered BUsSingle
WaiversLong Integer
WithdrawalsLong Integer
FCC Held LicensesLong Integer
Pctg of Covered PopsSingle
Pctg of the Pops with Bidding CreditSingle
Waiver Statistics table
Auction IDLong Integer
RoundLong Integer
BidderText(50)
Waiver TypeText(1)
Remaining WaiversLong Integer
Withdrawal Statistics table
Auction IDLong Integer
Withdrawal NumberLong Integer
BidderText(50)
License NameText(9)
MarketText(6)
BlockText(2)
SubmarketInteger
BUsLong Integer
PopulationLong Integer
RoundLong Integer
GrossCurrency
NetCurrency
Min BidCurrency
New High BidderText(50)
New High Bid RoundLong Integer
Gross High BidCurrency
Net High BidCurrency
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
marketchar(6)
freq_blockchar(2)
round_numnumeric
bid_amtnumeric
bidder_numnumeric
fcc_acctchar(10)
datedate
timechar(8)
net_bid_amtnumeric
sort_col_1numeric
sort_col_2numeric
sub_marketinteger
HIGH_BIDS file
marketchar(6)
freq_blockchar(2)
bid_roundnumeric
bid_amtnumeric
bidder_numnumeric
fcc_acctchar(10)
datedate
timechar(8)
net_bid_amtnumeric
min_acceptnumeric
num_of_bidsnumeric
sort_col_1numeric
sort_col_2numeric
sub_marketinteger
MAXIMUM_ELIGIBILITY file
round_numnumeric
bidder_numnumeric
fcc_acctchar(10)
max_elignumeric
rmng_waivrnumeric
waivr_indchar(1)
rmng_withdrawalsnumeric
required_actnumeric
current_activitynumeric
WITHDRAWALS file
marketchar(6)
freq_blockchar(2)
bid_roundnumeric
bid_amtnumeric
bidder_numnumeric
fcc_acctchar(10)
datedate
timechar(8)
net_bid_amtnumeric
sort_col_1numeric
sort_col_2numeric
sub_marketinteger
BIDDER_CROSS_REFERENCE file
bidder_numnumeric
fcc_acctchar(10)
co_namechar(50)
bidding_credit_pctgnumeric