Skip Navigation

Federal Communications Commission

English Display Options

Commission Document

Supplemental Request for Information Concerning Applications of AT&T Inc. and Deutsche Telekom AG

Download Options

Released: June 28, 2011

FEDERAL COMMUNICATIONS COMMISSION


Washington DC 20554




June 27, 2011




Via First Class Mail and E-mail

William R. Drexel
AT&T Inc.
208 South Akard Street, Room 3305
Dallas, TX 75202

Re: Supplemental Request for Information Concerning Applications of AT&T Inc. and Deutsche
Telekom AG for Consent To Transfer Control of the Licenses and Authorizations Held by T-
Mobile USA, Inc. and Its Subsidiaries (WT Docket No. 11-65)

Dear Mr. Drexel:

By letter dated May 27, 2011, we requested that you provide written responses in the above
entitled cases, as set forth in the Attachments to the May 27, 2011 letter. We are now revising that initial
request in the following respects:

 Attachment B: Add “Billing_Ports.csv” table; and
 Attachment D: New attachment, “Device_Sales.csv” table.

Attached are a revised Attachment B that incorporates the new “Billing_Ports.csv” table and the new
Attachment D identified above. As stated in the May 27, 2011 letter, your response will be treated as
confidential pursuant to Protective Orders issued in WT Docket No. 11-65.1 We would appreciate
receiving your response no later than July 7, 2011.

Your responses should be filed with Marlene H. Dortch, Secretary, Federal Communications
Commission, in WT Docket No. 11-65. In addition, the Comment Public Notice2 and the Protective
Orders require the submission of multiple copies of all ex parte and other filings submitted in this
proceeding.3 The Wireless Telecommunications Bureau also should receive, at a minimum, two copies of
all paper filings. If you submit information pursuant to the Protective Order, Second Protective Order, or

1 Applications of AT&T Inc. and Deutsche Telekom AG For Consent To Assign or Transfer Control of Licenses and
Authorizations, WT Docket No. 11-65, Protective Order, DA 11-674 (WTB rel. Apr. 14, 2011) (“Protective
Order”); Applications of AT&T Inc. and Deutsche Telekom AG For Consent To Assign or Transfer Control of
Licenses and Authorizations, WT Docket No. 11-65, Second Protective Order, DA 11-753 (WTB rel. Apr. 27,
2011) (“Second Protective Order”); Applications of AT&T Mobility Spectrum LLC and Qualcomm Incorporated
For Consent To Assign or Transfer Control of Licenses and Authorizations, WT Docket No. 11-65, Second
Protective Order (Revised)
, DA 11-1098 (WTB rel. June 22, 2011) (“Second Protective Order (Revised)).”
2 See AT&T Inc. and Deutsche Telekom AG Seek FCC Consent to the Transfer of Control of the Licenses and
Authorizations Held by T-Mobile USA, Inc. and Its Subsidiaries to AT&T Inc., WT Docket No. 11-65, Public
Notice
, DA 11-799 (rel. Apr. 28, 2011) (“Comment Public Notice”).
3 See Comment Public Notice at 4; Protective Order.


Second Protective Order (Revised) issued in this case, you should deliver to Kathy Harris of the Wireless
Telecommunications Bureau two copies of the unredacted documents appropriately marked and two
copies of the redacted documents marked “Redacted – For Public Inspection.”4 For any electronic filings
made using the Commission’s Electronic Comment Filing System (“ECFS”), parties also should serve the
documents via e-mail to Kathy Harris, kathy.harris@fcc.gov; Kate Matraves,
catherine.matraves@fcc.gov; and Jim Bird, jim.bird@fcc.gov.

If you have any questions regarding this matter, please contact Susan Singer, Wireless
Telecommunications Bureau, at (202) 418-1340, or Joel Rabinovitz, Office of General Counsel, at (202)
418-0689.






Sincerely,








Rick Kaplan
Chief,
Wireless
Telecommunications
Bureau





Attachment

cc:
Peter J. Schildkraut, Arnold & Porter LLP


4 See Protective Order at 2 ¶ 3.

2


Billing Data Instructions

Attachment A Instructions

For each month, beginning 01/01/08 and extending through 03/31/11, please provide all billing data requested in Attachment B for each mobile wireless price plan
offered by your company on a monthly basis, in each CMA of the United States. You should submit information on each mobile wireless price plan that
(a) was available to new subscribers at any time between 01/01/08 and 03/31/11, and/or (b) had at least one subscriber at any time between
01/01/08 and 03/31/11 in any CMA. A wireless plan is defined here as any unique combination of fields 2 through 32 in the "Billing_Plans.CSV" data below.
For example, if one plan has the call waiting feature and another is identical in every respect except that it does not include
this feature then it should be listed as a separate plan. If your firm offers an individual voice plan with 450 minutes, then this offering should
be a separate plan and have a separate line in the data and unique ID code for every possible combination of text and data plans that a consumers could pair
with this voice offering.
Please provide these files electronically in comma separated value (.csv) format. The format is indicated for the entries in each column/field
in the instructions below. All entries in text string fields must be in quotation marks (e.g. "AT&T"). Do not enter any text objects in numeric fields
(e.g. do not include $ in front of any dollar figures). Code any unlimited values numerically as 9999 and any values that are unknown as -1. Each Excel
sheet should be submitted as a separate .csv database. As a result, each carrier should produce three separate .csv files from its billing system data.
Every CSV database should include all variables listed in each sheet. All databases must contain the following four variables:
(1) the unique plan identifier; (2) the CMA code; (3) the month and; (4) the year. These four variables should uniquely define the observations in each
database so that the databases can be merged using these variables.
Page 1 of 13

Billing Data Instructions

Billing_Plans.CSV


Field Variable Name

Format

Field Label

Description

1
id
numeric
Unique ID code for plan
Provide a unique identifier for each plan as described in the instructions.
2
cma
numeric
CMA code
Provide the code for the Cellular Market Area (CMA) of the subscribers
3
month
2 digit numeric Month
Provide the billing month in numeric format: 01= January 12=December
4
year
4 digit numeric Year
Provide the four digit year of the billing month
5
bill_code
text string
Plan billing code
Provide the billing system code for the plan (not necessarily unique)
6
plan_name
text string
Plan name/ description
The name or description of the plan as used in the billing system
7
month_first
2 digit numeric Month first offered
The month the plan was first offered to new subscribers
8
year_first
4 digit numeric Year first offered
The year the plan was first offered to new subscribers
9
month_last
2 digit numeric Month last offered
The month the plan was last offered to new subscribers, if no longer available
10
year_last
4 digit numeric Year last offered
The year the plan was last offered to new subscribers, if no longer available
11
plan_type
1 digit numeric Plan type
The plan's subscriber type: 1=consumer/retail postpaid 2=consumer prepaid 3=consumer data-only plan 4=other consumer plans
(Note: Include small business subscribers but not MVNO, M2M or enterprise customers in any calculations or plan definitions)
12
plan_brand
1 digit numeric Plan branding/ marketing
Whether the plan is branded and market by the firm or an authorized reselled: 0=reseller 1=firm
13
contract
0/1 numeric
Contract required
Whether the plan requires new subscribers to sign a service contract: 1=contract required 0=no contract required
14
contract_length
numeric
Contract length in years
Number of years of service required by contract
15
etf
numeric
Early termination fee amount
The ETF fee typically required by the service contract (enter zero if no ETF)
16
etf_reduce
0/1 numeric
ETF reduction indicator
Indicator variable for whether the ETF declines over contract period
17
shared
0/1 numeric
Shared plan
Whether the minutes of the plan are shared across multiple lines (i.e. family plan): 0 = individual plan 1=shared plan
18
national
0/1 numeric
National calling plan
An indicator of whether the plan's home calling area is national or local/regional: 1=national 0=regional/local
19
min_any
numeric
Anytime minutes
The number of anytime minutes included in the plan. If unlimited code as 9999
20
min_peak
numeric
Peak minutes
The number of peak minutes inlcuded in the plan. If unlimited code as 9999
21
peak_hours
numeric
Daily hours in peak period
The number of hours per day that are billed as peak hours. If unlimited code as 9999
22
min_offpeak
numeric
Offpeak minutes
The number of off-peak (e.g. nights and weekends) minutes included in the plan. If unlimited code as 9999
23
min_mobmob
numeric
Mobile to mobile minutes
The number of mobile to mobile minutes included in the plan. If unlimited code as 9999
24
unlim_onnet
0/1 numeric
Unlimited on-network calling
An indicator for whether the plan offers unlimited calling to subscribers of the firm's wireless network: 0=No 1=Yes
25
unlim_friends
0/1 numeric
Unlimited family/ friends calling
An indicator for whether plan offers unlimited calling to some numbers chosen by the subscriber: 0=No 1=Yes
An indicator for whether or not all unused anytime/peak minutes are lost at the end of the billing cycle: 0=No 1=Yes
26
min_anylost
0/1 numeric
Unused minutes lost at end of billing cycle
27
min_roam
numeric
Voice roaming minutes
The number of voice roaming minutes included in the plan. If unlimited code as 9999
28
over_roam
numeric
Voice roaming per minute overage rate
The per-minute overage rate for roaming minutes in excess of the minutes included in the plan
29
data
numeric
Number of megabytes in plan
The number of megabytes included in the plan (if any). If unlimted code as 9999. If no plan code as 0 .
If throttled indicate at what value data is throttled. If "unlimited" but capped indicate the usage cap.
30
data_name
text string
Data plan name
The name or description of the data plan as used in the billing system
31
smart_data
0/1 numeric
Smartphone data plan
An indicator for whether the data plan is available to smartphone devices: 0=No 1=Yes
32
texts
numeric
Number of text messages in plan
The number of text messages included in the plan (if any). If unlimited code as 9999. If no plan, code as zero
33
text_name
text string
Text plan name
The name or description of the messaging plan as used in the billing system
34
charge_prime_access
numeric
Monthly charge for primary line
The monthly recurring access charge for the primary line
35
charge_primeline
numeric
Activation fee for primary line
The one time activation fee for the primary line
36
charge_add_access
numeric
Monthly charge per additional line
The monthly recurring access charge per additional line on the account
37
charge_addline
numeric
Activation fee per additional line
The one time activation fee per additional line on the account
38
over_any
numeric
Per-minute anytime overage rate
The per-minute overage rate for anytime minutes in excess of the minutes included in the plan
39
access_text
numeric
Monthly charge for text plan
The monthly recurring charge for the text messages included in the plan
40
over_text
numeric
Per text overage charge
The per-text overage rate for text messages in excess of the text messages included in the plan. If no plan provide a la carte rate
41
access_data
numeric
Monthly charge for data plan
The monthly recurring charge for the megabytes of data included in the plan
42
over_data
numeric
Per megabyte overage charge
The per-megabyte overage rate for data in excess of the megabytes included in the plan. If no plan provide a la carte rate
Page 2 of 13

Billing Data Instructions

Billing_Subs.CSV


Field Variable Name

Format

Field Label

Description

1
id
numeric
Unique ID code for plan
Provide a unique identifier for each plan as described in the instructions.
2
cma
numeric
CMA code
Provide the code for the Cellular Market Area (CMA) of the subscribers
3
month
2 digit numeric Month
Provide the billing month in numeric format: 1= January 12=December
4
year
4 digit numeric Year
Provide the four digit year of the billing month
5
lines_activeon
numeric
Active contract lines
The number of lines with an active status (as indicated in billing system) that are subject to a contract
6
lines_activeoff
numeric
Active off-contract lines
The number of lines with an active status (as indicated in billing system) that are not subject to a contract
7
lines_inactive
numeric
Inactive lines
The number of lines that have neither an active nor cancelled status but remain subscribers in the billing system
8
lines_iPhone
numeric
iPhone lines
The number of iPhone lines associated with iPhone devices
9
lines_othersmart
numeric
Smartphone lines
The number of active lines that are associated with other (non-iPhone) smartphone devices
10
gross_additions
numeric
Gross line additions
The number of gross new line additions by plan, month and CMA
11
disconnect_vol
numeric
Voluntary disconnects
The number of lines that were voluntarily terminated of all wireless services with the company.
(Note: Only subscribers who have terminated all wireless service with firm should be counted as disconnects.)
12
disconnect_invol
numeric
Involuntary disconnects
The number of lines that have been involuntarily terminated from all wireless services with the company
13
renewals
numeric
Total number of contract renewals
The number of lines on the plan that have renewed their contracts in the given month and CMA
14
avg_lines
numeric
Average number of lines per account
The average number of subscriber lines per active account under the plan
15
arpu
numeric
Average revenue per user
The average revenue per user/line (active) for the plan
16
arpu_data
numeric
Average data revenue per user
The average data revenue per user/line (active) for the plan
17
perc_smart
numeric
Percent smartphone users
The percentage of plan users with smartphone devices
18
perc_iphone
numeric
Percent iPhone users
The percentage of plan users with iPhone devices
Page 3 of 13

Billing Data Instructions

Billing_Additions.CSV - (Note: Data for these fields should be limited to new gross line additions in the given month and CMA)


Field Variable Name

Format

Field Label

Description

1
id
numeric
Unique ID code for plan
Provide a unique identifier for each plan as described in the instructions.
2
cma
numeric
CMA code
Provide the code for the Cellular Market Area (CMA) of the subscribers
3
month
2 digit numeric Month
Provide the billing month in numeric format: 1= January 12=December
4
year
4 digit numeric Year
Provide the four digit year of the billing month
5
cpga
numeric
Cost per gross subscriber addition
The total cost per gross subscriber addition to the plan
Marketing/advertising cost per gross
The total marketing/advertising costs incurred per gross subscriber/line addition to the plan
6
cpga_market
numeric
addition
Equipment/handset costs per gross
The total equipment/handset subsidy costs incurred per gross addition to the plan in the given month and CMA
7
cpga_equip
numeric
addition
Any other subsidy costs incurred by the firm per gross subscriber/line addition
8
cpga_sub
numeric
Other promotional costs per gross addition
9
cpga_other
numeric
Non-promotional costs per gross addition
All other non-promotional costs per gross addition
Total discounts/promotions per gross
10
total_discounts
numeric
addition
Provide the annual value of all discounts and promotions per gross addition to new subscribers of the plan.
These could include handset discounts, plan discounts, activation fee waivers or any service codes for
free/additional services among others. Do not include advertising/marketing costs in the calculation.
11
total_cost
numeric
Average first year total cost of ownership
Compute the total cost of ownership for all new subscribers of the plan for all services and equipment
12
new_bill
numeric
Average bill in first month of ownership
Provide the average first month bill of all new subscribers in the given month and CMA
13
new_accounts
numeric
The number of new accounts added
The number of new active accounts added for each plan in the given month and CMA
Provide the average activation fee per new primary line in the given month and CMA
14
new_charge_prime
numeric
Average primary activation fee per new line
Average activation fee per new additional Provide the average activation fee per new additional (non-primary) line in the given month and CMA
15
new_charge_add
numeric
line
16
fica
numeric
FICA score
Provide the average FICA credit score for new activations
17
new_nonsmart
numeric
Number of new non-smartphone users
The number of new subscribers that purchased non-smartphones
18
new_nonsmart_price
numeric
Average price paid for non-smartphone
The average price paid per new non-smartphone device for all new subscribers
19
new_iphones
numeric
Number of new iPhone users
The number of new subscribers that purchased iPhones
20
new_iphone_price
numeric
Average price paid for iPhone devices
The average price paid per iPhone device by new subscribers
Number of new other (non-iPhone)
The number of new subscribers that purchased other smartphones
21
new_othersmart
numeric
smartphone users
Average price paid for other smartphone
The average price paid per other (non-iPhone) smartphone device by new subscribers
22
new_othersmart_price numeric
devices
23
new_idevice
numeric
Number of new other internet devices
The number of new subscribers that purchased other internet devices
Average price paid for other internet
The average price paid per other internet device by new subscribers
24
new_idevice_price
numeric
devices
Page 4 of 13

Billing Data Instructions

Billing_Ports.CSV


1
id
numeric
Unique ID code for plan
Provide a unique identifier for each plan as described in the instructions.
2
cma
numeric
CMA code
Provide the code for the Cellular Market Area (CMA) of the subscribers
3
month
2 digit numeric Month
Provide the billing month in numeric format: 01= January 12=December
4
year
4 digit numeric Year
Provide the four digit year of the billing month
5
outports_att
numeric
Ports to ATT
Provide number of subscribers of billing plan that ported number to ATT
6
inports_att
numeric
Ports from ATT
Provide number of subscribers of billing plan that ported number from ATT
7
outports_tm
numeric
Ports to T-Mobile
Provide the number of subscribers of billing plan that ported number to T-Mobile
8
inports_tm
numeric
Ports from T-Mobile
Provide number of subscribers of billing plan that ported number from T-Mobile
9
outports_vz
numeric
Ports to Verizon
Provide number of subscribers of billing plan that ported number to Verizon
10
inports_vz
numeric
Ports from Verizon
Provide number of subscribers of billing plan that ported number from Verizon
11
outports_sprint
numeric
Ports to Sprint
Provide the number of subscribers of billing plan that ported number to Sprint
12
inports_sprint
numeric
Ports from Sprint
Provide number of subscribers of billing plan that ported number from Sprint
13
outports_usc
numeric
Ports to US Cellular
Provide number of subscribers of billing plan that ported number to US Cellular
14
inports_usc
numeric
Ports from US Cellular
Provide number of subscribers of billing plan that ported number from US Cellular
15
outports_metro
numeric
Ports to MetroPCS
Provide the number of subscribers of billing plan that ported number to MetroPCS
16
inports_metro
numeric
Ports from MetroPCS
Provide number of subscribers of billing plan that ported number from MetroPCS
13
outports_leap
numeric
Ports to Leap
Provide number of subscribers of billing plan that ported number to Leap
14
inports_leap
numeric
Ports from Leap
Provide number of subscribers of billing plan that ported number from Leap
15
outports_cs
numeric
Ports to CellSouth
Provide the number of subscribers of billing plan that ported number to CellSouth
16
inports_cs
numeric
Ports from CellSouth
Provide number of subscribers of billing plan that ported number from CellSouth
15
outports_other
numeric
Ports to other carriers
Provide the number of subscribers of billing plan that ported number to any other carrier
16
inports_other
numeric
Ports from other carriers
Provide number of subscribers of billing plan that ported number from any other carrier
Page 5 of 13

Billing_Plans
min_
bill_ plan_ month_ year_ month_ year_ plan_ plan_
contract_
etf_
min_ min_
peak_
min_
mob
id cma
month
year code
name
first
first
last
last
type
brand
contract
length
etf
reduce
shared
national
any
peak
hours
offpeak
mob
Page 6 of 13

Billing_Plans
min_
charge_ charge_
unlim_ unlim_
any
min_ over_
data_
smart_
text_
prime_
prime
charge_
charge_
over_ access_ over_
access_
over_
onnet
friends
lost
roam
roam
data
name
data
texts
name
access
line
add_ access
addline
any
text
text
data
data
Page 7 of 13

Billing_Subs
id
cma
month
year
lines_activeon
lines_activeoff
lines_inactive
lines_iPhone
lines_othersmart
gross_additions
disconnect_vol
Page 8 of 13

Billing_Subs
disconnect_invol
renewals
avg_lines
arpu
arpu_data
perc_smart
perc_iphone
Page 9 of 13

Billing_Additions
new_
new_
cpga_
cpga_ cpga_ cpga_
total_
total_ new_
new_
new_charge_
charge_
new_
nonsmart_
id cma
month
year
cpga
market
equip
sub
other
discounts
cost
bill
accounts
prime
add
fica
nonsmart
price
Page 10 of 13

Billing_Additions
new_iphone_
new_ other
new_ other smart_
new_idevice_
new_iphones
price
smart
price
new_idevice
price
Page 11 of 13

Billing_Ports
A
B
C
D
E
F
G
H
I
J
K
L
1
id
cma
month
year
outports_att
inports_att
outports_tm
inports_tm
outports_vz
inports_vz
outports_sprint
inports_sprint
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
Page 12 of 13

Billing_Ports
M
N
O
P
Q
R
S
T
U
V
outports_me inports_
outports_l inports_l
outports_ot inports_ot
1
outports_usc
inports_usc
tro
metro
eap
eap
outports_cs
inports_cs
her
her
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
Page 13 of 13

Attachment D Table - Device Sales

The following field descriptions apply to the columns of the "Device Sales" table. This table provides data by CMA and month on the
number and of all devices (inlcuding handsets, dongles, usb modems, tablets etc.) sold by model as well as the average price paid by the company and subscribers for each model.
For each month, beginning 01/01/07 and extending through 03/31/11, provide all the CMA level data requested below.
All data should be submitted in a .csv (comma-delimited) format. The Handset Prices worksheet provides a template for how the table should be designed.
The required format for the entries in each column/field is indicated in the instructions below.
All entries in Text fields must be in quotation marks (e.g. "AT&T").

Field # Variable Name

Format

Field Label

Description

1
month
2 digit numeric
Month
Provide the billing month in numeric format: 1= January 12=December
2
year
4 digit numeric
Year
Provide the four digit year of the billing month
3
cma
numeric
CMA name
Provide the CMA number to which the data applies
4
dev_manuf
string
Device manufacturer
Provide the device manufacturer for the handset
5
dev_model
string
Model number
Provide a unique model number for the handset
6
sold
numeric
Quantity sold
Provide the number of handsets sold in the CMA and month
7
revenues
numeric
Total revenues
Provide the total revenues from sales of the handset model in the CMA and month
8
price_cons
numeric
Average handset price
Provide the average price paid by consumers for each handset model in the month and CMA
9
price_wholesale
numeric
Average handset wholesale price
Provide the average wholesale price paid by your company for the handset model
10
promotion
0/1 numeric
Handset promotion indicator
Provide an indicator for whether handset model was promoted in CMA in given month 0=No
indicator
Promotion 1=Yes Promotion
Page 1 of 2

Device_Sales
month
year
cma
dev_man
dev_model
sold
revenues
price_cons
price_wholesale
promotion
Page 2 of 2

Document Outline

  • ATT-TMobile to ATT Supp Request Cover Letter Final 062711
  • ATT Attachment B Updated Data Request 06 24 11
  • ATT Attachment D Data Request 06 24 11

Note: We are currently transitioning our documents into web compatible formats for easier reading. We have done our best to supply this content to you in a presentable form, but there may be some formatting issues while we improve the technology. The original version of the document is available as a PDF, Word Document, or as plain text.

close
FCC

You are leaving the FCC website

You are about to leave the FCC website and visit a third-party, non-governmental website that the FCC does not maintain or control. The FCC does not endorse any product or service, and is not responsible for, nor can it guarantee the validity or timeliness of the content on the page you are about to visit. Additionally, the privacy policies of this third-party page may differ from those of the FCC.