FCC Report 43-08, ARMIS Operating Report

0496_ARMISReport43-08_021207.pdf

ARMIS Operating Data Report, FCC Report 43-08

FCC Report 43-08, ARMIS Operating Report

OMB: 3060-0496

⚠️ Notice: This form may be outdated. More recent filings and information on OMB 3060-0496 can be found here:

Document [pdf]

Download: pdf | pdf

Report 43-08 - Automated Report Specifications

December 2006

Page 1 of 28

A. Introduction
This document contains the detailed automated data processing (ADP) specifications for the
automated report to be filed as FCC Report 43-08, the ARMIS Operating Data Report.
B. General Format
1. Electronically-Filed Data
a. For data reporting years 1990 and beyond, carriers must file their ARMIS Reports and
related documents electronically. Electronic submission of both is made through the
Internet by selecting the “Upload ARMIS Data” link on the EAFS Home Page, at
http://www.fcc.gov/wcb/eafs/.
b. All files must be coded in ASCII. Header records in the ARMIS Report data files must
include the report number, company, study area, period, COSA code, version, and
submission number. A higher number (2, 3, etc.) and a new data entry date must be used
each time a change occurs to denote a new submission.
c. A separate ASCII file must be prepared for each report. More than one ASCII file can
be included in the same electronic upload file – which is created by the data validation
program – as long as they are for the same report and cover the same period and version
(different submission numbers and multiple reasons for correcting data are allowed).
d. The electronic submission will serve as the carrier’s official filing.
2. ASCII File Name – each file has six components:
a. the four letter COSA code (CO = Company, SA = Study Area, see the COSA Code
Table for a list of companies and their respective COSAs)
b. the last two digits of the year which is covered by the data
c. the letters “OD”
d. a decimal point
e. the letter “P”, “C”, or “U” to indicate whether this is the Public version, the Confidential
version, or the Unrestricted version
f. two digits (zero filled) for the submission number: Submission 00 is for test data
purposes only; Submission 01 is for the first submission of a year’s data
For example, the file name for the Unrestricted Version of the initial Operating Data Report
data file to be submitted by Illinois Bell to cover the calendar year 2006 would be
LBIL06OD.U01:

Report 43-08 - Automated Report Specifications
LBIL
06
OD
.
U
01

December 2006

Page 2 of 28

COSA for Illinois Bell
Data for calendar year 2006
Operating Data Report data file
Decimal point
Unrestricted version
First submission of this year’s data

C. Filing Requirement
1. Proprietary Treatment: Carriers seeking proprietary treatment for some data must provide
two electronic versions of the automated report. The Confidential Version must contain all
the required information. Confidential Treatment Data Records must be provided to identify
confidential data but are not a substitute for applying for confidential treatment with this
Commission following established Commission procedures. The Public Version should
neither include data for which the carrier is seeking proprietary treatment nor Confidential
Treatment Data Records.
Carriers not seeking proprietary treatment for any data should provide only one electronic
version which should be identified as the Unrestricted Version.
2. Data Items That Are "Not Available," "Withheld," or Are “Irretrievable” – See
Sections B and C of the Reporting Procedures for a discussion of the Confidential Version,
the Public Version, and the Unrestricted Version of this report and for a definition and
discussion of data items that are “Not Available,” “Withheld,” or are “Irretrievable.”
3. Related Documents – These documents are required by Commission Order to be filed with
specific ARMIS reports. The electronic submission of these documents must be converted
to Adobe Acrobat’s Portable Document Format (PDF), prior to submitting the documents to
the Commission.
Document Conversion Requirements: Convert directly through a word-processing
application or through the use of a scanning device. Other than a letterhead graphic, the
documents to be converted should consist of text only—no graphics. Conversion of a
document to PDF should result in a black and white document with a resolution no greater
than 300 dpi, and having a file size no more than 40 to 50 Kb per page.
The related documents to be included in the electronic upload file for Report 43-08 are
described below:
a. Transmittal Letter – Each ARMIS report submission must be accompanied by a letter
of transmittal. When filing confidential data, a separate letter is required. These letters
must be on official company letterhead and be included in each electronic upload file.
The transmittal letter must list only COSAs included in the submission. See Section G.2
of the Reporting Procedures for a description of the information to be provided in the
transmittal letter.

Report 43-08 - Automated Report Specifications

December 2006

Page 3 of 28

b. Data Certification Statement – Carriers must certify the accuracy of the data submitted
in the ARMIS Reports by including one certification statement, signed by a corporate
officer, in each electronic upload file. The certification statement must list all COSAs
required for a specific ARMIS report. See Section G.3 of the Reporting Procedures for a
description of the information to be included in the statement.
4. Data Validation Programs
a. Each reporting carrier must validate its data by using the most recent edit check
program(s), provided by the Commission, for the reporting year. When an error is
detected, the carrier must correct the error prior to submitting the report to the
Commission.
b. The edit check program creates the electronic upload file to be used as the carrier’s
official filing. It will normally contain the following:
1
2.
3.
4.
5.

The ASCII file(s)
Text files that will be stored in the database
The edit check results (“the Discrepancy Report”)
The comparison utility results for roll-up comparisons (“the Detailed Error Report”)
Related documents – one each per upload file, when applicable – in PDF

5. Upload Comment Field: Enter the reason for the filing, which must include a brief
description of ALL data (including footnotes) that have been added, removed, or
modified since the previous submission. This description must agree with what is being
filed. The comments should not contain references to IATD letters. Maximum comment
length is 245 characters (including spaces). If comment length will exceed 245
characters, include in the comments a reference to the associated transmittal letter by its
date, for additional information.

D. Data Entry Conventions
1. Give each record a unique record number, beginning with 1001 and incrementing by one,
with no numbers skipped.
2. Begin each data record in column 1 and make each record the proper length as specified in
the record layouts. Commas are used as delimiters between fields. All numeric fields are
right justified and space filled, e.g. use 123, NOT 123. All non-numeric fields are
enclosed in double quotation marks and are left justified and space filled within these
quotation marks, e.g. use “John Doe ”.
3. If an entry is to be a subtraction, indicate so by placing a minus sign in the column
immediately preceding the numeric data, e.g. use -4, NOT - 4 or (4).
4. Do NOT include “$”, “%”, embedded commas, decimal points, quotes or other formatting
characters in any numeric data fields, except for row numbers and percentage fields, which

Report 43-08 - Automated Report Specifications

December 2006

Page 4 of 28

will include a decimal point but not a percent sign. Use the assigned row numbers and
associated state codes, not the state name, as shown on the State Row Numbers and Codes
Reference Table of the Report Definition for this report. State Codes are to be enclosed in
quotation marks, left justified and space filed.
5. In any numeric data field designated by N/A, enter -99999. In any text data field designated
by N/A, enter “N/A”. Enter -77777 in any numeric data and “I/R” in any text data field
which the reporting carrier designates as “Irretrievable” and footnote the reason for that entry
(including a cite to the waiver and a note as to its duration). If a “Public Version” is filed,
enter -88888 in any numeric data field and “W/H” in any text data field for which data are
“Withheld” to indicate that confidential treatment has been requested. These entries must be
formatted according to the format rules for the particular data field; e.g., in the percentage
fields, -99999 is entered as -99999.00 and text fields are enclosed in double quotation marks.
6. Do not override designated N/As. However, if a reporting carrier wishes to apply data to a
field containing a N/A, the carrier should enter as a footnote to the field, the amount(s) and
an explanation. The amount(s) must not be entered in the N/A field. All other fields must
be populated. If a data field equals the quantity zero, enter the numeral zero in that field.
This is the only proper use of zero in this report.
E. Rounding Conventions
1. To convert miles to kilometers, compute total miles, multiply by 1.6093, and then round to
the nearest whole number.
2. Internal calculations should retain, where applicable, at least 4 decimal places of accuracy;
compute totals and then round to the nearest whole number before applying weighting
factors.
3. Round final results (in kilometers) to the nearest whole number, but report any non-zero
entry that is less than 1 kilometer as 1 kilometer.
4. Round the number of equivalent telephone poles to the nearest whole number.
5. Round telephone calls and minutes to the nearest thousand, but report any non-zero entry
that is less than 1 (thousand) as 1 (thousand).
6. Report all other amounts in actual units.
F. Footnotes
1. General:
a. For initial (annual) filings, if any data for the current period differ materially from
those for the previous period and the difference is not self-explanatory but was
caused

Report 43-08 - Automated Report Specifications

December 2006

Page 5 of 28

by unusual circumstances, the carrier must include detailed footnote text to explain
the specific circumstances. For resubmission filings, footnotes must be provided for
all changed data, which includes changed footnotes. When a summary row value
changes because of changes to one or more of its detail rows, the summary row must
also be footnoted.
b. Footnotes should be filed for the entities to which they apply: a footnote might apply
to a holding company COSA only, to a study area COSA only, or to both entities.
(However, footnotes should not be submitted at the holding company level if they
apply only to a company’s study areas.)
c. If the reporting carrier does not follow the procedures described in the row and
column instructions of the applicable Report Definition, it must explain any
deviations from those procedures in an explanatory footnote. Such footnotes must
provide detailed explanations of the procedures actually used by the carrier and its
specific reasons for deviating from procedures prescribed by the Commission's Rules.
This provision should not be interpreted to mean that deviations from the prescribed
rules will automatically be approved by the Commission. See Section E of the
Reporting Procedures for examples of valid footnotes.
d. Footnote entries must provide detailed explanations for only those items reported in
the current submission. Footnotes from prior submissions should be included only if
they remain applicable. In other words, when a resubmission nullifies an existing
footnote, remove the footnote.
e. The footnote text must be included in the Footnote Text Records.
2. Mandatory: Certain items require accompanying footnotes and those items are specified
in the appropriate section of the Report Definitions for filing the reports. Such footnotes
are mandatory and must be entered in the Footnote Text Records.
3. Footnote Structure:
Observe the footnote specifications to the letter and strive for an efficient footnote structure.
Reduce the size and number of footnotes by using global and referring footnotes.
Global Footnotes
a. If a footnote applies to an entire table, its row number is 9999.0, and its column letter
is ZZ;
b. If a footnote applies to all columns within a single row, its column letter is ZZ;
c. If a footnote applies to a single column within all rows, its row number is 9999.0;

Report 43-08 - Automated Report Specifications

December 2006

Page 6 of 28

d. If a footnote applies to a majority of (but not all) columns within a single row, its
column letter is ZZ, and its text should include the identity of the columns to which
the footnote applies;
e. If a footnote applies to a single column within a majority of (but not all) rows, its
row number is 9999.0, and its text should include the identity of the rows to which
the footnote applies;
Referring (non-Global) Footnotes
f. If a footnote applies to more than one, but less than a majority of rows or columns,
use individual referring footnotes for the rows or columns to refer to a single
explanatory footnote. The referring footnote must include the explanatory footnote’s
number, row, and column;
g. Referring footnotes and the footnotes to which they refer should be in the same table.
Footnote Removal
h. For resubmissions, remove footnotes if they no longer apply, and renumber the
remaining footnotes.
i. When removing one or more footnotes from a table that were erroneously included in
a previous filing, provide a single explanatory footnote that includes a list of the
affected rows and columns. This footnote’s record number for the footnoted data is
9999 (field 4), its table number is ZZZZ, its row number is 9999.0, and its column
letters are ZZ.
G. Errata
1. Carriers are under a legal obligation to correct any erroneous data, which includes footnotes,
reported in ARMIS Reports. Thus, whenever there are changes in table data, footnotes are
added, footnotes are removed because they were erroneously-filed, or the text of an existing
footnote is changed, an erratum (and resubmission) is required. See Section B of the
Reporting Procedures for the use of submission numbers when an erratum occurs.
2. Submissions containing corrected data must include references to indicate which data items
were corrected since the previous submission. If the data items being corrected impact other
data items in the report, then those items must also be corrected and referenced. Erratum
references should reflect only those items corrected in the new submission. References from
prior submissions must not be included in the new submission.
3. Current errata references must be included in the Erratum Record(s).

Report 43-08 - Automated Report Specifications

December 2006

Page 7 of 28

4. Errata Structure:
Observe the errata record specifications to the letter, and strive for proper structure.
a. An errata record should reference more than one column, if multiple—but not all—
columns are affected for the same row. (Where all columns are affected use “ZZ” as
the column reference.)
b. When a footnote column field contains “ZZ” to indicate multiple—but not all—
columns, the errata record column field should not use “ZZ.” Instead, list the
columns affected in this field.
c. The errata record should reference the footnote number to which it applies.
d. For Submission Number 3 or higher, be careful to clear the errata table of entries
from previous filings, prior to adding new errata entries for the new submission.
e. When removing one or more footnotes from a table that were erroneously included in
a previous filing, the erratum record should refer to a single footnote explaining the
removed footnote(s). In the erratum record, use 9999 for the record number of the
corrected data (field 4), ZZZZ for the table number, 9999.0 for the row number, and
ZZ for the column letters.
H. Data Record Descriptions
The eleven data record types are described below. See pages 9 through 28 for record layouts. The
automated file will consist of the following record types:
1. Record Type H1 - Header Record
One Type H1 record per file. The first record of each file. Contains identifying data.
See page 9 for record layout.
2. Record Type L2 - Label Record
One Type L2 record per file. The second record of each file. Contains report number,
carrier classification, carrier name, study area name, etc. See page 10 for record layout.
3. Record Type K1 - (Table I.A) Outside Plant Statistics-Cable and Wire Facilities Data
Record
One Type K1 record for each row with data to be reported. Include one K1 record for
total company data, even if there is only one state row, as shown on pages 5 & 6 of the
Report Definition. Each record represents a state, district, or territory in which the
reporting company has cable and wire facilities. See pages 11 – 13 for record layout.

Report 43-08 - Automated Report Specifications

December 2006

Page 8 of 28

4. Record Type S1 - (Table I.B) Outside Plant Statistics-Other Data Record
One Type S1 record for each row with data to be reported. Include one S1 record for
total company data, even if there is only one state row, as shown on pages 6 & 7 of the
Report Definition. Each record represents a state, district, or territory in which the
reporting company has outside plant facilities. See pages 14 & 15 for record layout.
5. Record Type N1 - (Table II) Switched Access Lines In Service Data Record
One Type N1 record for each row with data to be reported. Include one N1 record for
total company data, even if there is only one state row, as shown on pages 7 & 8 of the
Report Definition. Each record represents a state, district, or territory in which the
reporting company has switched access lines. See pages 16 & 17 for record layout.
6. Record Type A2 - (Table III) Access Lines In Service By Customer Data Record
One Type A2 record for each row with data to be reported. Include one A2 record for
total company data, even if there is only one state row, as shown on pages 8 & 9 of the
Report Definition. Each record represents a state, district, or territory in which the
reporting company has access lines. See pages 18 & 19 for record layout.
7. Record Type P1 - (Table IV) Telephone Calls Data Record
One Type P1 record for each row with data to be reported. Include one P1 record for
total company data, even if there is only one state row, as shown on page 9 of the Report
Definition. Each record represents a state, district, or territory in which the reporting
company provides service. See pages 20 & 21 for record layout.
8. Record Type C3 – Confidential Treatment Record (Confidential Version only)
One or more Type C3 records per file. Contains information to identify the data for
which the carrier is seeking confidential treatment. Do not include this record type in
the Public or Unrestricted Versions of a report. See pages 22 & 23 for record layout.
9. Record Type F3 - Footnote Record
Optional. Zero or more Type F3 records per file. Contains explanatory footnote text.
Certain items require accompanying mandatory footnotes and those items are specified
in the appropriate section of the instructions for filing the 43-08. See pages 24 & 25 for
record layout.
10. Record Type E4 - Erratum Record
Zero Type E4 records in the first submission of a year’s data. One or more Type E4
records per file in revisions filed to correct that year’s submission. Each time an erratum
occurs, a carrier must use a new submission number. Contains information to identify
the data which was corrected in the submission. See pages 26 & 27 for record layout.
11. Record Type T1 - Trailer Record
One Type T1 record per file. The last record of each file. Contains contact person, etc.
See page 28 for record layout.

Report 43-08 - Automated Report Specifications

December 2006

Page 9 of 28

RECORD TYPE H1 - HEADER RECORD

Field

Item

Example

Position

Record Number

1001

1–4

The sequential number of this record within
this data file plus 1000.
Format: Right justified and space filled.

COSA

"LBIL"

6 – 11

The COSA code for the filing entity.
Format: Include quotation marks.

Record Type

"H1"

13 – 16

Always contains the letter H capitalized and the
number 1 with no space between them.
Format: Include quotation marks.

File Name

"LBIL06OD.U01"

18 – 31

The name of the ASCII file.
Format: See page 1, paragraph B.2. Include
quotation marks.

Year

2006

33 – 36

The year covered by the data.

Quarter #

Data Entry Date

20070315

40 – 47

The date on which the data were last entered or
revised.
Format: YYYYMMDD.

Version

"U"

49 – 51

The version letter U capitalized for
Unrestricted.
Format: Include quotation marks.

Submission #

53 – 54

00 for test data purposes only; 01 for first
submission of a year’s data. Higher numbers
(02, 03, etc.) are used each time a change
occurs to denote a new submission.
Format: Right justified.

End of Record Code

"XQ"

56 – 59

Always contains the letters XQ capitalized with
no space between them to indicate the end of
the record.
Format: Include quotation marks.

Description

Always contains the number 0 since this is an
annual data file.

Note: All fields are separated by commas.
1

12345678901234567890123456789012345678901234567890123456789
Sample record:
1001,"LBIL","H1","LBIL06OD.U01",2006,0,20070315,"U",01,"XQ"

Report 43-08 - Automated Report Specifications

December 2006

Page 10 of 28

RECORD TYPE L2 - LABEL RECORD

Field

Item

Example

Position

Record Number

1002

1–4

The sequential number of this record within
this data file plus 1000.
Format: Right justified and space filled.

COSA

"LBIL"

6 – 11

The COSA code for the filing entity.
Format: Include quotation marks.

Record Type

"L2"

13 – 16

Always contains the letter L capitalized and the
number 2 with no space between them.
Format: Include quotation marks.

Report Number

"FCC REPORT
43-08"

18 – 35

Always contains “FCC REPORT 43-08”
capitalized.
Format: Include quotation marks.

Account Filing Level

"A"

37 – 39

Account filing level (Class A or B) capitalized.
Format: Include quotation marks.

Carrier

"Illinois Bell "
(spaces until pos.
70)

41 - 71

Name of the carrier.
Format: Left justified and space filled. Include
quotation marks.

Study Area

"Illinois

73 - 95

Name of the study area.
Format: Left justified and space filled. Include
quotation marks.

Period Covered

"Jan 2006 to Dec
2006"

97 – 118

Period covered by the data.
Format: “mmm yyyy to mmm yyyy” Include
quotation marks.

End of Record Code

"XQ"

120 – 123

Always contains the letters XQ capitalized with
no space between them to indicate the end of
the record.
Format: Include quotation marks.

Description

Note: All fields are separated by commas.
1

12345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345
Sample record:
1002,"LBIL","L2","FCC REPORT 43-05","A","Illinois Bell
1

6789012345678901234567890123
Continuation of sample record:
,"Jan 2006 to Dec 2006","XQ"

","Illinois

Report 43-08 - Automated Report Specifications

December 2006

Page 11 of 28

RECORD TYPE K1 (Table I.A) - OUTSIDE PLANT STATISTICS-CABLE AND WIRE FACILITIES
DATA RECORD
Field

Item

Example

Position

Record Number

1003

1–4

The sequential number of this record within
this data file plus 1000.
Format: Right justified and space filled.

COSA

"LBIL"

6 – 11

The COSA code for the filing entity.
Format: Include quotation marks.

Record Type

"K1"

13 – 16

Always contains the letter K capitalized and the
number 1 with no space between them.
Format: Include quotation marks.

Row Number

0240.0

18 – 23

Row numbers as identified on the Report
Definition.
Valid range: 0110.0 to 0910.0
Format: Right justified and space filled, with
one decimal place. Since all applicable row
numbers are integers, append .0 to each row
number.

Column (b) data

"IL"

25 – 28

This field contains the data corresponding to
column (b) as shown on the Form Section of
the Report Definition. See the State Row
Numbers and Codes Reference Table for a list
of state codes.
Format: Left justified and space filled. Include
quotation marks.

Column (c) data

30 – 39

This field contains the data corresponding to
column (c) as shown on the Form Section of
the Report Definition. DO NOT override
designated N/As.
Format: Right justified and space filled. See
Sections D and E for data entry and rounding
conventions. All fields must be populated. If
there are no data applicable to an open field,
enter zero.

5432

Description

Report 43-08 - Automated Report Specifications

December 2006

Page 12 of 28

RECORD TYPE K1 (Table I.A) - OUTSIDE PLANT STATISTICS-CABLE AND WIRE FACILITIES
DATA RECORD (continued)
7

Column (d) data

5432

41 – 50

Column (d) data
Format: See Field 6 above.

Column (e) data

1358

52 – 61

Column (e) data
Format: See Field 6 above.

Column (f) data

1358

63 – 72

Column (f) data
Format: See Field 6 above.

Column (g) data

2716

74 – 83

Column (g) data
Format: See Field 6 above.

Column (h) data

1358

85 – 94

Column (h) data
Format: See Field 6 above.

Column (i) data

5432

96 – 105

Column (I) data
Format: See Field 6 above.

Column (n) data

5432

107 – 116

Column (n) data
Format: See Field 6 above.

Column (o) data

2716

118 – 127

Column (o) data
Format: See Field 6 above.

Column (p) data

13580

129 – 138

Column (p) data
Format: See Field 6 above.

Column (q) data

12222

140 – 149

Column (q) data
Format: See Field 6 above.

Column (r) data

1358

151 – 160

Column (r) data
Format: See Field 6 above.

Column (s) data

2716

162 – 171

Column (s) data
Format: See Field 6 above.

Column (t) data

20370

173 – 182

Column (t) data
Format: See Field 6 above.

Column (u) data

16296

184 – 193

Column (u) data
Format: See Field 6 above.

Column (v) data

25432

195 – 204

Column (v) data
Format: See Field 6 above.

Column (w) data

7431

206 – 215

Column (w) data
Format: See Field 6 above

Report 43-08 - Automated Report Specifications

December 2006

Page 13 of 28

RECORD TYPE K1 (Table I.A) - OUTSIDE PLANT STATISTICS-CABLE AND WIRE FACILITIES
DATA RECORD (continued)

Column (x) data

54320

217 – 226

Column (x) data
Format: See Field 6 above

End of Record Code

"XQ"

228 – 231

Always contains the letters XQ capitalized with
no space between them to indicate the end of
the record.
Format: Include quotation marks.

Notes: All fields are separated by commas.
Certain items require accompanying mandatory footnotes and must be entered in the Footnote Text record(s).
Record Type K1 requires mandatory footnotes for those data fields designated as “Irretrievable”

12345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345
Sample records:
1003,"LBIL","K1",0240.0,"IL",

5432,

1358,

2716,

1358,

1004,"LBIL","K1",0910.0,"TO",

5432,

1358,

2716,

1358,

6789012345678901234567890123456789012345678901234567890123456789012345678901234567890123
5432,

5432,

2716,

13580,

12222,

1358,

2716,

20370,

5432,

2716,

13580,

12222,

1358,

2716,

20370,

456789012345678901234567890123456789012345678901
Continuation of sample records:
16296,

25432,

7431,

54320,”XQ”

16296,

25432,

7431,

54320,’XQ”

Report 43-08 - Automated Report Specifications

December 2006

Page 14 of 28

RECORD TYPE S1 (Table I.B) - OUTSIDE PLANT STATISTICS-OTHER DATA RECORD
Field

Item

Example

Position

Description

Record Number

1005

1–4

The sequential number of this record within
this data file plus 1000.
Format: Right justified and space filled.

COSA

"LBIL"

6 – 11

The COSA code for the filing entity.
Format: Include quotation marks.

Record Type

"S1"

13 – 16

Always contains the letter S capitalized and the
number 1 with no space between them.
Format: Include quotation marks.

Row Number

0240.0

18 – 23

Column (bb) data

"IL"

25 – 28

This field contains the data corresponding to
column (bb) as shown on the Form Section of
the Report Definition. See the State Row
Numbers and Codes Reference Table for a list
of state codes.
Format: Left justified and space filled. Include
quotation marks.

Column (bc) data

5432

30 – 39

This field contains the data corresponding to
column (bc) as shown on the Form Section of
the Report Definition. DO NOT override
designated N/As.
Format: Right justified and space filled. See
Sections D and E for data entry and rounding
conventions. All fields must be populated. If
there are no data applicable to an open field,
enter zero.

Column (bd) data

35432

41 – 50

Column (bd) data
Format: See Field 6 above.

Column (bf) data

1358

52 – 61

Column (bf) data
Format: See Field 6 above.

Report 43-08 - Automated Report Specifications

December 2006

Page 15 of 28

RECORD TYPE S1 (Table I.B) - OUTSIDE PLANT STATISTICS-OTHER DATA RECORD (continued)
9

Column (bg) data

101358

63 – 72

Column (bg) data
Format: See Field 6 above.

Column (bh) data

72816

74 – 83

Column (bh) data
Format: See Field 6 above.

Column (bi) data

601358

85 – 94

Column (bi) data
Format: See Field 6 above.

Column (bk) data

405432

96 – 105

Column (bk) data
Format: See Field 6 above.

Column (bl) data

5432

107 – 116

End of Record Code

"XQ"

118 – 121

Column (bl) data
Format: See Field 6 above.
Always contains the letters XQ capitalized with
no space between them to indicate the end of
the record.
Format: Include quotation marks.

Notes: All fields are separated by commas.
Certain items require accompanying mandatory footnotes and must be entered in the Footnote Text record(s).
Record Type S1 requires mandatory footnotes for those data fields designated as “Irretrievable”.

12345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345
Sample records:
1005,"LBIL","S1",0240.0,"IL",

5432,

35432,

1358,

101358,

72816,

601358,

1006,"LBIL","S1",0910.0,"TO",

5432,

35432,

1358,

101358,

72816,

601358,

67890123456789012345678901
Continuation of sample records:
405432,

5432,”XQ”

405432,

5432,”XQ”

Report 43-08 - Automated Report Specifications

December 2006

Page 16 of 28

RECORD TYPE N1 (Table II) - SWITCHED ACCESS LINES IN SERVICE DATA RECORD
Field

Item

Example

Position

Description

Record Number

1007

1–4

The sequential number of this record within
this data file plus 1000.
Format: Right justified and space filled.

COSA

"LBIL"

6 – 11

The COSA code for the filing entity.
Format: Include quotation marks.

Record Type

"N1"

13 – 16

Always contains the letter N capitalized and the
number 1 with no space between them.
Format: Include quotation marks.

Row Number

0240.0

18 – 23

Column (cb) data

"IL"

25 – 28

This field contains the data corresponding to
column (cb) as shown on the Form Section of
the Report Definition. See the State Row
Numbers and Codes Reference Table for a list
of state codes.
Format: Left justified and space filled. Include
quotation marks.

Column (cc) data

5432

30 – 39

This field contains the data corresponding to
column (cc) as shown on the Form Section of
the Report Definition. DO NOT override
designated N/As.
Format: Right justified and space filled. See
Sections D and E for data entry and rounding
conventions. All fields must be populated. If
there are no data applicable to an open field,
enter zero.

Column (cd) data

5432

41 – 50

Column (cd) data
Format: See Field 6 above.

Column (ce) data

1358

52 – 61

Column (ce) data
Format: See Field 6 above.

Report 43-08 - Automated Report Specifications

December 2006

Page 17 of 28

RECORD TYPE N1 (Table II) - SWITCHED ACCESS LINES IN SERVICE DATA RECORD (continued)
9

Column (ci) data

1358

63 – 72

Column (ci) data
Format: See Field 6 above.

Column (cj) data

13580

74 – 83

Column (cj) data
Format: See Field 6 above.

Column (ck) data

1358

85 – 94

Column (ck) data
Format: See Field 6 above.

Column (cl) data

5432

96 – 105

Column (cl) data
Format: See Field 6 above.

Column (cm) data

3086

107 – 116

Column (cm) data
Format: See Field 6 above.

Column (cn) data

2716

118 – 127

Column (cn) data
Format: See Field 6 above.

Column (co) data

5432

129 – 138

End of Record Code

"XQ"

140 – 143

Column (co) data
Format: See Field 6 above.
Always contains the letters XQ capitalized with
no space between them to indicate the end of
the record.
Format: Include quotation marks.

Notes: All fields are separated by commas.
Certain items require accompanying mandatory footnotes and must be entered in the Footnote Text record(s).
Record Type N1 requires mandatory footnotes for those data fields designated as “Irretrievable”. In
addition, footnotes are required for any row/column data entry which contains UNE data. The footnotes
must identify the types of UNE’s (e.g., “UNE-P”) included in the data.
1

12345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345
Sample records:
1007,"LBIL","N1",0240.0,"IL",

5432,

1358,

13580,

1358,

1008,"LBIL","N1",0910.0,"TO",

5432,

1358,

13580,

1358,

678901234567890123456789012345678901234567890123
Continuation of sample records:
5432,

3086,

2716,

5432,”XQ”

5432,

3086,

2716,

5432,”XQ”

Report 43-08 - Automated Report Specifications

December 2006

Page 18 of 28

RECORD TYPE A2 (Table III) - ACCESS LINES IN SERVICE BY CUSTOMER DATA RECORD
Field

Item

Example

Position

Description

Record Number

1009

1–4

The sequential number of this record within
this data file plus 1000.
Format: Right justified and space filled.

COSA

"LBIL"

6 – 11

The COSA code for the filing entity.
Format: Include quotation marks.

Record Type

"A2"

13 – 16

Always contains the letter A capitalized and the
number 2 with no space between them.
Format: Include quotation marks.

Row Number

0240.0

18 – 23

Column (fb) data

"IL"

25 – 28

This field contains the data corresponding to
column (fb) as shown on the Form Section of
the Report Definition. See the State Row
Numbers and Codes Reference Table for a list
of state codes.
Format: Left justified and space filled. Include
quotation marks.

Column (fc) data

135894

30 – 39

This field contains the data corresponding to
column (fc) as shown on the Form Section of
the Report Definition. DO NOT override
designated N/As.
Format: Right justified and space filled. See
Sections D and E for data entry and rounding
conventions. All fields must be populated. If
there are no data applicable to an open field,
enter zero.

Column (fd) data

5432

41 – 50

Column (fd) data
Format: See Field 6 above.

Column (fe) data

4074

52 – 61

Column (fe) data
Format: See Field 6 above.

Report 43-08 - Automated Report Specifications

December 2006

Page 19 of 28

RECORD TYPE A2 (Table III) - ACCESS LINES IN SERVICE BY CUSTOMER DATA RECORD (continued)

Column (ff) data

1358

63 – 72

Column (ff) data
Format: See Field 6 above.

Column (fg) data

8148

74 – 83

Column (fg) data
Format: See Field 6 above.

Column (fh) data

1358

85 – 94

Column (fh) data
Format: See Field 6 above.

Column (fi) data

156264

96 – 105

Column (fi) data
Format: See Field 6 above.

Column (fj) data

3086

107 – 116

Column (fj) data
Format: See Field 6 above.

Column (fk) data

2716

118 – 127

Column (fk) data
Format: See Field 6 above.

Column (fl) data

162066

129 – 138

Column (fl) data
Format: See Field 6 above.

Column (fm) data

31274

140 – 149

Column (fm) data
Format: See Field 6 above.

End of Record Code

"XQ"

151 – 154

Always contains the letters XQ capitalized with
no space between them to indicate the end of
the record.
Format: Include quotation marks.

Notes: All fields are separated by commas.
Certain items require accompanying mandatory footnotes and must be entered in the Footnote Text record(s).
Record Type A2 requires mandatory footnotes for those data fields designated as “Irretrievable”. In
addition, footnotes are required for any row/column data entry which contains UNE data. The footnotes
must identify the types of UNE’s (e.g., “UNE-P”) included in the data.
1

12345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345
Sample records:
1009,"LBIL","A2",0240.0,"IL",

135894,

5432,

4074,

1358,

8148,

1358,

1010,"LBIL","A2",0910.0,"TO",

135894,

5432,

4074,

1358,

8148,

1358,

67890123456789012345678901234567890123456789012345678901234
Continuation of sample records:
156264,

3086,

2716,

162066,

31274,"XQ"

156264,

3086,

2716,

162066,

31274,"XQ"

Report 43-08 - Automated Report Specifications

December 2006

Page 20 of 28

RECORD TYPE P1 (Table IV) - TELEPHONE CALLS DATA RECORD
Field

Item

Example

Position

Description

Record Number

1011

1–4

The sequential number of this record within
this data file plus 1000.
Format: Right justified and space filled.

COSA

"LBIL"

6 – 11

The COSA code for the filing entity.
Format: Include quotation marks.

Record Type

"P1"

13 – 16

Always contains the letter P capitalized and the
number 1 with no space between them.
Format: Include quotation marks.

Row Number

0240.0

18 – 23

Column (eb) data

"IL"

25 – 28

This field contains the data corresponding to
column (eb) as shown on the Form Section of
the Report Definition. See the State Row
Numbers and Codes Reference Table for a list
of state codes.
Format: Left justified and space filled. Include
quotation marks.

Column (ec) data

5432

30 – 39

This field contains the data corresponding to
column (ec) as shown on the Form Section of
the Report Definition. DO NOT override
designated N/As.
Format: Right justified and space filled. See
Sections D and E for data entry and rounding
conventions. All fields must be populated. If
there are no data applicable to an open field,
enter zero.

Column (ed) data

5432

41 – 50

Column (ed) data
Format: See Field 6 above.

Column (ee) data

1358

52 – 61

Column (ee) data
Format: See Field 6 above.

Column (ef) data

1358

63 – 72

Column (ef) data
Format: See Field 6 above.

Report 43-08 - Automated Report Specifications

December 2006

Page 21 of 28

RECORD TYPE P1 (Table IV) - TELEPHONE CALLS DATA RECORD (continued)
Field

Item

Example

Position

Description

Column (eg) data

2716

74 – 83

Column (eg) data
Format: See Field 6 above.

Column (eh) data

13580

85 – 94

Column (eh) data
Format: See Field 6 above.

Column (ei) data

13580

96 – 105

Column (ei) data
Format: See Field 6 above.

Column (ej) data

27160

107 – 116

Column (ej) data
Format: See Field 6 above.

End of Record Code

"XQ"

118 – 121

Always contains the letters XQ capitalized with
no space between them to indicate the end of
the record.
Format: Include quotation marks.

Notes: All fields are separated by commas.
Certain items require accompanying mandatory footnotes and must be entered in the Footnote Text record(s).
Record Type P1 requires mandatory footnotes for those data fields designated as “Irretrievable”.

12345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345
Sample records:
1011,"LBIL","P1",0240.0,"IL",

5432,

1358,

2716,

13580,

1012,"LBIL","P1",0910.0,"TO",

5432,

1358,

2716,

13580,

67890123456789012345678901
Continuation of sample records:
13580,

27160,"XQ"

13580,

27160,"XQ"

Report 43-08 - Automated Report Specifications

December 2006

Page 22 of 28

RECORD TYPE C3 - CONFIDENTIAL TREATMENT RECORD

Field

Item

Example

Position

Description

Record Number
(for this record)

1013

1–4

The sequential number of this record within
this data file plus 1000.
Format: Right justified and space filled.

COSA

"LBIL"

6 – 11

The COSA code for the filing entity.
Format: Include quotation marks.

Record Type

"C3"

13 – 16

Always contains the letter C capitalized and the
number 3 with no space between them.
Format: Include quotation marks.

Record Number
(for the
confidential
data)

1003

18 – 21

This field contains the record number of the
record which contains the data for which the
carrier is seeking confidential treatment. If the
request is for the entire column(s) or the entire
submission, use 9999.
Format: Right justified and space filled.

Table Number

"I.A "

23 – 28

This field contains the table number (Roman
numerals) of the table in which the confidential
data appear. If the request is for the entire
submission, enter “ZZZZ.”
Format: Include quotation marks. Left justified
and space filled.

Row Number

0240.0

30 – 35

This field contains the row number of the row
which contains the confidential data as identified
in the Report Definition. If the request is for the
entire column(s), an entire table or the entire
submission, enter 9999.0.
Format: Right justified and space filled, with
one decimal place. Since all applicable row
numbers are integers, append .0 to each row
number.

Column Label

"C "

37 – 40

This field contains the column letter of the
confidential data as identified in the Report
Definition. If the request is for an entire row,
an entire table, or the entire submission, enter
“ZZ.” If the request is for more than one
column but less than the entire row, then
populate this field and as many as needed of
fields 8 through 26.
Format: Include quotation marks. Left
justified and space filled.

Report 43-08 - Automated Report Specifications

December 2006

Page 23 of 28

RECORD TYPE C3 - CONFIDENTIAL TREATMENT RECORD (continued)

Second Column
Label

"R "

42 – 45

Third Column
Label

" "

47 – 50

.
.
.
.
.
26
27

Fields 8 through 26 are similar to Field 7 and
are used when the request is for the same row
and more than one column.
Otherwise, enter “ ”.

Twentieth
Column Label
End of Record
Code

" "

132 – 135

"XQ"

137 – 140

Always contains the letters XQ capitalized with
no space between them to indicate the end of
the record.
Format: Include quotation marks.

Note: All fields are separated by commas.

123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456
Sample records:
1013,"LBIL","C3",1003,"I.A ",0240.0,"C ","R ","

","

1014,"LBIL","C3",1005,"I.B ",0240.0,"ZZ","

","

1015,"LBIL","C3",9999,"II

",9999.0,"CN","

","

1016,"LBIL","C3",9999,"ZZZZ",9999.0,"ZZ","

","

78901234567890123456789012345678901234567890
Continuation of sample records:
"

","

","XQ"

","

","XQ"

","

","XQ"

","

","XQ"

Report 43-08 - Automated Report Specifications

December 2006

Page 24 of 28

RECORD TYPE F3 - FOOTNOTE TEXT RECORD

Field

Item

Example

Position

Description

Record Number
(for this record)

1017

1–4

The sequential number of this record within
this data file plus 1000.
Format: Right justified and space filled.

COSA

"LBIL"

6 – 11

The COSA code for the filing entity.
Format: Include quotation marks.

Record Type

"F3"

13 – 16

Always contains the letter F capitalized and the
number 3 with no space between them.
Format: Include quotation marks.

Record Number
(for the footnoted
data)

1003

18 – 21

This field contains the record number of the
record which contains the footnoted data. See
Section F for Footnote structure guidelines.
Format: Right justified and space filled.

Table Number

"I.A "

23 – 28

This field contains the table number (Roman
numerals) of the table in which the footnoted
data appear. See Section F for Footnote
structure guidelines.
Format: Include quotation marks. Left justified
and space filled.

Row Number

0240.0

30 – 35

This field contains the row number of the row
which contains the footnoted data as identified
in the Report Definition. See Section F for
Footnote structure guidelines.
Format: Right justified and space filled, with
one decimal place. Since all applicable row
numbers are integers, append .0 to each row
number.

Column Label

"C "

37 – 40

This field contains the column letter(s) of the
footnoted data as identified in the Report
Definition. See Section F for Footnote structure
guidelines.
Format: Include quotation marks. Left justified
and space filled.

Footnote Number

42 – 44

The number of this particular footnote.
Valid range: 1 to 999.
Format: Right justified and space filled.

Report 43-08 - Automated Report Specifications

December 2006

Page 25 of 28

RECORD TYPE F3 - FOOTNOTE TEXT RECORD (continued)

Field

Item

Example

Position

Description

Sequence Number

46 – 47

The sequence number of the record within the
footnote. In other words, the order of the
specific record in the sequence of records which,
when combined, will provide the entire footnote.
Valid range: 1 to 99.
Format: Right justified and space filled.

Footnote Text

"Footnote text "
(Spaces until pos.
104)

49-105

The text of the footnote or of the continuation
line.
Format: Include quotation marks at the
beginning and end of this field and left justify
within these quotation marks.

End of Record Code

"XQ"

107 – 110

Always contains the letters XQ capitalized with
no space between them to indicate the end of
the record.
Format: Include quotation marks.

Notes: All fields are separated by commas.
Certain items require accompanying mandatory footnotes and must be entered in the Footnote Text record(s).
Such items are listed below and specified in the appropriate section of the instructions for filing this report:
Record Types N1 and A2 require footnotes for any row/column data entry which contains UNE data
See Section F for detailed footnote content and structure guidelines.

12345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890
Sample records:
1017,"LBIL","F3",1003,"I.A ",0240.0,"C ",

1, 1,"Footnote text for footnote 1

","XQ"

1018,"LBIL","F3",1003,"I.A ",0240.0,"C ",

1, 2,"continuation text for footnote 1

","XQ"

1019,"LBIL","F3",1003,"I.A ",0240.0,"C ",

1, 3,"last line of footnote 1.

","XQ"

1020,"LBIL","F3",1003,"I.A ",0240.0,"D ",

2, 1,"Footnote 2 pertains to col D of Table I.A row 240.0

","XQ"

1021,"LBIL","F3",1005,"I.B ",0240.0,"ZZ",

3, 1,"Footnote 3 pertains to all cols. of Table I.B row 240.0","XQ"

1022,"LBIL","F3",9999,"II

4, 1,"Footnote 4 pertains to all rows of Table II column CI

",9999.0,"CI",

","XQ"

Report 43-08 - Automated Report Specifications

December 2006

Page 26 of 28

RECORD TYPE E4 - ERRATUM RECORD

Field

Item

Example

Position

Description

Record Number
(for this record)

1023

1–4

The sequential number of this record within
this data file plus 1000.
Format: Right justified and space filled.

COSA

"LBIL"

6 – 11

The COSA code for the filing entity.
Format: Include quotation marks.

Record Type

"E4"

13 – 16

Always contains the letter E capitalized and the
number 4 with no space between them.
Format: Include quotation marks.

Record Number
(for the corrected
data)

1003

18 – 21

This field contains the record number of the
record which contains the data which were
corrected in this submission. See Section G for
Errata structure guidelines.
Format: Right justified and space filled.

Table Number

"I.A "

23 – 28

This field contains the table number (Roman
numerals) of the table in which the corrected
data appear. See Section G for Errata structure
guidelines.
Format: Include quotation marks. Left justified
and space filled.

Row Number

0240.0

30 – 35

This field contains the row number of the row
which contains the corrected data as identified
in the Report Definition. See Section G for
Errata structure guidelines.
Format: Right justified and space filled, with
one decimal place. Since all applicable row
numbers are integers, append .0 to each row
number.

Column Label

"C "

37 – 40

This field contains the column letter of the
corrected data as identified in the Report
Definition. See Section G for Errata structure
guidelines. If more than one column but less than
the entire row was corrected, then populate
this field and as many as needed of fields 8
through 26.
Format: Include quotation marks. Left
justified and space filled.

Report 43-08 - Automated Report Specifications

December 2006

Page 27 of 28

RECORD TYPE E4 - ERRATUM RECORD (continued)

Field

Item

Example

Position

Description

Second Column
Label

"D "

42 – 45

Third Column Label

" "

47 – 50

.
.
.
26

Twentieth Col. Label

" "

132 – 135

Footnote Number

137 – 139

This field contains the footnote number that
explains the correction.
Format: Right justified and space filled.

End of Record Code

"XQ"

141 – 144

Always contains the letters XQ capitalized with
no space between them to indicate the end of
the record.
Format: Include quotation marks.

Fields 8 thru 26 are similar to Field 7
and are used when the correction is in
the same row and more than one column.
Otherwise, enter “ ”.

Notes: All fields are separated by commas.
When an errata occurs, carriers must use higher submission numbers and a new data entry date to denote a
new submission.
See Section G for detailed Errata content and structure guidelines.

123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456
Sample records:
1023,"LBIL","E4",1003,"I.A ",0240.0,"C ","D ","

","

1024,"LBIL","E4",1005,"I.B ",0240.0,"ZZ","

","

1025,"LBIL","E4",9999,"II

","

",9999.0,"CI","

789012345678901234567890123456789012345678901234
Continuation of sample records:
"

","

1,"XQ"

","

3,"XQ"

","

4,"XQ"

Report 43-08 - Automated Report Specifications

December 2006

Page 28 of 28

RECORD TYPE T1 - TRAILER RECORD

Field

Item

Example

Position

Description

Record Number

1026

1–4

The sequential number of this record within
this data file plus 1000.
Format: Right justified and space filled.

COSA

"LBIL"

6 – 11

The COSA code for the filing entity.
Format: Include quotation marks.

Record Type

"T1"

13 – 16

Always contains the letter T capitalized and the
number 1 with no space between them.
Format: Include quotation marks.

Contact Person

"John Doe
"
(spaces until pos.
58)

18 – 59

The name of the person to contact if there are
questions about the report.
Format: Include quotation marks.

Telephone #

"(202) 555-1212
x123 "

61 – 82

End of Record Code

"XQ"

84 – 87

The Contact Person’s telephone number.
Format: Include quotation marks.
Always contains the letters XQ capitalized with
no space between them to indicate the end of
the record.
Format: Include quotation marks.

Note: All fields are separated by commas.

123456789012345678901234567890123456789012345678901234567890123456789012345678901234567
Sample record:
1026,"LBIL","T1","John Doe

","(202) 555-1212 x123 ","XQ"

File Type	application/pdf
File Title	untitled
File Modified	2006-12-28
File Created	2006-12-28