Formatting Instructions -
Delivery Technology
Format of Data
The required format for the entries in each column/field is indicated in the instructions for each sheet.  
Data for all of the tables should be submitted on a periodic basis as specified in the instructions in individual tables.
All data should be submitted in a .csv (comma-delimited) format.  The sheets in the workbook provide a template for how 
the tables should be designed.
Column entries in bold red indicate that the party should enter only one of the possible entries listed for that column.  No 
other entries should be entered.
Availability and Subs
Delivery Technology
"Availability and Subscription by delivery technology and distribution area for March 2014"
Column Variable Name Format Possible Entries/
Example Entries 
Description
A cllida Text DLLSTXNM3372B The CLLI distribution area code
B tech Integer 1, 2, 3, 4, 5, 6 Technology code of the service (see Tech Table for the 6 technology types)
C residential Integer 1, 0 Location type - enter 1 if the location is residential and  0 if other (non-residential) 
location
D locs Integer 605 Number of customer locations where the Company offers the technology
E subs_MVPD Integer 158 Number of subscribers to MVPD Service only as of the end of the month 
F subs_IA Integer 210 Number of subscribers to Internet Access Service only as of the end of the month 
G subs_Tel Integer 28 Number of subscribers to Telephony Service only as of the end of the month 
H subs_MVPD_IA Integer 322 Number of subscribers to MVPD Service and Internet Access Service only as of the end of 
the month 
I subs_MVPD_Tel Integer 56 Number of subscribers to MVPD Service and Telephony Service only as of the end of the 
month 
J subs_IA_Tel Integer 98 Number of subscribers to Internet Access Services and Telephony Service only as of the 
end of the month 
K subs_MVPD_IA_Tel Integer 111 Number of subscribers to MVPD Service, Internet Access Service and Telephony Service 
as of the end of the month 
Notes:
A, B, C: Any variation in CLLI Distribution Area, Technology, or Location Type necessitates the creation of a new, unique record.
C, E: If any individual location can be served using multiple technologies, please record the location only under the observation with the largest technology code.
(For example, if a location can be served with both IPDSL and FTTP, include the location under the observation for technology code 6.)
For the month of March 2014, provide the availability and subscription data by distribution area and technology, separately for residential and 
other subscribers.
If multiple delivery technologies are used in a single distribution area, then multiple rows must be filled out for that distribution area, one for 
each delivery technology.
Template
Delivery Technology
cllida tech residential locs subs_MVPD subs_IA subs_Tel subs_MVPD_IA subs_MVPD_Tel subs_IA_Tel subs_MVPD_IA_Tel
DLLSTXNM3372B 4 1 605 158 210 28 322 56 98 111
Tech Table
Delivery Technology
Technology Codes for Availability, Subscribers and ARPU
Technology Code Description
1 Copper with no xDSL capability
2 xDSL
3 IPDSL
4 FTTN without capability to provide MVPD Service
5 FTTN with capability to provide MVPD Service
6 FTTP