ATTACHMENT A

AUCTION BIDDING SYSTEM FILE DEFINITIONS


A. Round Results File Formats
The following layouts are for the dbf files.  The first column provides the name of each field, and the 
second column provides the corresponding field type.  The txt files will have identical fields but 
character field types.


1. 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)
net_bid_amt		numeric
sort_col_1		numeric
sort_col_2		numeric
sub_market		numeric
random_num		double


2. 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)
net_bid_amt		numeric
min_accept		numeric
num_of_bids		numeric
min_incr_2		double
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_act		numeric


4. 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)
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


6. MARKET_CROSS_REFERENCE file
license_name		char(15)
market			char(6)
freq_block		char(2)
sub_market		numeric
license			char(11)
market_Desc		char(50)
bid_units			int
population			int

B. Results Explorer Export File Format
The Results Explorer provides an option to export a comma-delimited text file.  The export file contains 
the following fields:

market
block/channel
default bid increment (value = ‘1’)
round number
company 
standing high bid amount
minimum acceptable bid (for the round after the selected round number)
bid increment amount (for the round after the selected round number)

 

 
 


A - 1


 

PUBLIC NOTICE

		Federal Communications Commission
		445 12th St., S.W.
		Washington, D.C. 20554