# Attachment D {#attachment-d .unnumbered}

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.

## 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/

```{=html}
<!-- -->
```
-   http://wtbwww01.fcc.gov/MMB/CP3/Auction_28/Results/mdb/

```{=html}
<!-- -->
```
-   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/***.

## 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/

```{=html}
<!-- -->
```
-   http://wtbwww01.fcc.gov/MMB/CP3/Auction_28/Results/mdb/

```{=html}
<!-- -->
```
-   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.

## 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

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

### 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

### 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

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

### 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