Data and Information Request Template Overview and General Instructions This Data and Information Request Template provides a format that enables incumbent local exchange carriers to submit complete and uniform responses to certain data and information requested in the Tariff Investigation Order (Order). This template should be used for responding to questions in paragraphs 28, 29, 63, 64, 65, 69, 70, 71, 77, 81, 84, 90, and 100 in the Order, except for the narrative questions. The instructions for each table in the template cross-reference the relevant paragraph in the Order; the template also references Appendix A of the Order that lists the tariff pricing plans under investigation. Some questions in the template request narrative responses to supplement the related data request. Note that other questions in paragraphs 67, 68, 78, 80, 83, 101, and 105 of the Order, the supplementary narrative questions, are not included in the template because they consist only of narrative questions, although data may be part of the response. The responses to all narrative questions must be submitted in a Word document and follow the sequential order in which they appear in the Order. To ensure narrative responses are clearly identified in their submissions, incumbent LECs must provide the following information at the beginning of each response: the corresponding paragraph number in the Order, the question to be answered, the corresponding table number, and the variable identifier in the template, as applicable. For example: "Paragraph 77 of the Order. Narrative description of how the shortfall penalty was calculated for this shortfall. Table VI. Variable Identifier 8 (ii)." DS1 channel terminations and DS3 channel terminations here refer to all channel terminations that are not part of the transport function. Business data services other than DS1/DS3 channel terminations are referred to as “all other TDM business data services.” This category includes transport (which includes channel mileage and channel mileage termination). Introduction Page 1 Instructions for Completing Table I: Tariff Pricing Plan Data (See Order, Paragraphs 28, 63, 70, and 81) For each pricing plan in each tariff under investigation listed in Appendix A of the Designation Order, provide the data and information specified in the table. We define volume commitment as the quantity of business data services (in units, dollars, or other denominations, such as DS0 equivalents or DS1 equivalents) that the purchaser agrees to purchase from the ILEC upon subscribing to a pricing plan. For example, the volume commitment could be 10,000 DS1 channel terminations. We define percentage commitment as the minimum percentage of the volume commitment that the purchaser must purchase in order to avoid triggering a shortfall penalty. The percentage commitment is included in the tariff pricing plan, and is also reflected in the agreement between the ILEC and the purchaser. For example, the percentage commitment could be 90 percent. The quantity of business data services that a purchaser must purchase to avoid triggering a shortfall penalty (i.e., the purchase commitment) is the product of the volume commitment and the percentage commitment. In the above example, this quantity is 10,000 DS1 channel terminations multiplied by 90 percent, or 9,000 DS1 channel terminations. Note that DS1 channel terminations and DS3 channel terminations here refer to all channel terminations that are not part of the transport function. Business data services other than DS1/DS3 channel terminations are referred to as “all other TDM business data services.” This category includes transport (which includes channel mileage and channel mileage termination). Variable Identifier Variable Name Format Example Entries Description Paragraph 28 1 Tariff_Name Text Ameritech Operating Companies Tariff F.C.C. No. 2 The name of the tariff (from Appendix A). 2 Pricing_Plan_Name Text Discount Commitment Plan (DCP) The name of the pricing plan (from Appendix A) within the tariff listed above. 3 Section_Number Text 7.4.13 The section number or numbers (from Appendix A) for the pricing plan listed above. 4 (i) Percentage_Commit Excel Number 0, 1 Enter 1, if any customer electing the tariff pricing plan must agree to a percentage commitment. Enter 0, otherwise. 4 (ii) Percentage_Commit_Option Excel Number 0, 1 Enter 1, if any customer electing the tariff pricing plan is given an option to agree to a percentage commitment. Enter 0, otherwise. 5 All_Or_Nothing Excel Number 0, 1 Enter 1, if any customer electing the tariff pricing plan must make all of its purchases for the given business data services from the incumbent LEC under this plan. Enter 0, if the purchaser is permitted to make purchases for the given business data services under more than one of the incumbent LEC's pricing plans at the same time. Paragraph 63 1 Circuit_Portability_Mandated Excel Number 0, 1 Enter 1, if the tariff pricing plan mandates the allowance of substitution of one TDM-based dedicated service for another, with similar bandwidth and characteristics, to meet purchase commitments (sometimes called “circuit portability”). Enter 0 otherwise or if not applicable. Instructions for Table I Page 2 Variable Identifier Variable Name Format Example Entries Description 2 Circuit_Portability_Option Excel Number 0, 1 Enter 1, if the tariff pricing plan includes circuit portability as an option, outside of the tariff pricing plan. Enter 0, otherwise, i.e., enter 0 if the incumbent LEC includes circuit portability as part of the tariff pricing plan, or if it does not offer any circuit portability option, either inside or outside of the tariff pricing plan. 3 Circuit_Portability_Method_Expl Text Provide a narrative description of all circuit portability provisions in the tariff pricing plan, including any additional provisions pertaining to a circuit portability option included in the tariff pricing plan. In addition, provide the actual text of these provisions. This question calls for a narrative response that must be submitted in a Word document per the instructions in the Introduction of this data template. 4 (i) Cost_All Text If Percentage_Commit is reported as 1 and All_Or_Nothing is reported as 1, provide narrative description of any cost justification of the percentage commitment in the context of an all-or-nothing provision. This question calls for a narrative response that must be submitted in the Word document per the instructions in the Introduction of this data template. 4 (ii) Efficiency_All Text If Percentage_Commit is reported as 1 and All_Or_Nothing is reported as 1, provide narrative description of any efficiency justification for the percentage commitment in the context of an all-or-nothing provision. This question calls for a narrative response that must be submitted in the Word document per the instructions in the Introduction of this data template. 4 (iii) Cost_Port Text If Percentage_Commit is reported as 1 and EITHER Circuit_Portability_Mandated is reported as 1 OR Circuit_Portability_Option is reported as 1, provide a narrative description of any cost justification of the percentage commitment in the context of a circuit portability provision or option. This question calls for a narrative response that must be submitted in the Word document per the instructions in the Introduction of this data template. 4 (iv) Efficiency_Port Text If Percentage_Commit is reported as 1 and EITHER Circuit_Portability_Mandated is reported as 1 OR Circuit_Portability_Option is reported as 1, provide a narrative description of any efficiency justification for the percentage commitment in the context of a circuit portability provision or option. This question calls for a narrative response that must be submitted in the Word document per the instructions in the Introduction of this data template. Instructions for Table I Page 3 Variable Identifier Variable Name Format Example Entries Description 4 (v) Other_Business_Purpose Text If (1) Percentage_Commit is reported as 1, (2) All_Or_Nothing is reported as 1, and (3) EITHER Circuit_Portability_Mandated is reported as 1, OR Circuit_Portability_Option is reported as 1, then enter a narrative description of the business purpose of these provisions. Response must include detailed discussion of efficiency, cost, or other business purpose of predicating the availability of circuit portability on purchasers making a percentage commitment in the context of an all-or-nothing provision. This question calls for a narrative response that must be submitted in a Word document per the instructions in the Introduction of this data template. 5 (i) Percentage_Commit_DS1 Excel percent 90% Where applicable, provide the minimum percentage of the volume commitment for DS1 channel terminations that must be maintained in order to avoid incurring a shortfall penalty. 5 (ii) Percentage_Commit_DS3 Excel percent 90% Where applicable, provide the minimum percentage of the volume commitment for DS3 channel terminations that must be maintained in order to avoid incurring a shortfall penalty. 5 (iii) Percentage_Commit_Other Excel percent 90% Where applicable, provide the minimum percentage of the volume commitment for other TDM business data services that must be maintained in order to avoid incurring a shortfall penalty. 5 (iv) Percentage_Commit_Other_Desc Text Where applicable, provide a narrative description of the percentage commitment for other TDM business data services, including the types of other TDM business data services for which a percentage commitment applies, how these services are denominated, the relevant units of measure, and how each type of business data services counts toward this percentage commitment. This question calls for a narrative response that must be submitted in the Word document per the instructions in the Introduction of this data template. 6 (i) Max_Daily_Process Excel Number 50 The maximum number of circuits that the ILEC can migrate in one day, for that purchaser. Enter -9999 if not applicable. 6 (ii) Citation_FT_Max_Daily Text Provide citations and the full text (which may be a searchable PDF) of all provisions in the tariff that limit the number of circuits that the ILEC can migrate in one day, for a given customer. This question calls for a narrative response that must be submitted in the Word document per the instructions in the Introduction of this data template. 6 (iii) Circuit_Migration_Charge Excel dollar $ 1,000 The dollar amount charged for migrating a circuit. 6 (iv) Circuit_Migr_Chg_Expl Text Where applicable, provide a narrative description of the circuit migration charge, including the types of business data services circuits involved, and how they are charged. This question calls for a narrative response that must be submitted in the Word document per the instructions in the Introduction of this data template. Paragraph 70 Instructions for Table I Page 4 Variable Identifier Variable Name Format Example Entries Description 1 (i) Ethernet_DS1_Commit Excel number 0, 1 Enter 1, if any purchaser under the tariff pricing plan may count Ethernet purchases towards its percentage commitment for DS1 channel terminations. Enter 0, otherwise. Enter -9999, if not applicable. 1 (ii) Ethernet_DS3_Commit Excel number 0, 1 Enter 1, if any purchaser under the tariff pricing plan may count Ethernet purchases towards its percentage commitment for DS3 channel terminations. Enter 0, otherwise. Enter -9999, if not applicable. 1 (iii) Ethernet_Other_Commit Excel number 0, 1 Enter 1 if any purchaser under the tariff pricing plan may count Ethernet purchases towards its percentage commitment for other TDM business data services. Enter 0, otherwise. Enter -9999, if not applicable. 1 (iv) Ethernet_Other_Commit_Desc Text Where applicable, provide narrative description of the types of other TDM business data services referenced in Ethernet_Other_Commit and a description of how Ethernet services may be used to count toward this percentage commitment. This question calls for a narrative response that must be submitted in the Word document per the instructions in the Introduction of this data template. 2 (i) Citations_FT_DS1 Attached PDF or Text Where applicable, provide, using a searchable PDF or text format, the full text of all provisions in the tariff concerning how Ethernet purchases are eligible to count toward fulfillment of DS1 channel terminations purchase commitments (i.e., the product of the percentage commitment and the volume commitment), and include citations to those provisions. This question calls for a narrative response that must be submitted in the Word document per the instructions in the Introduction of this data template. 2 (ii) Citations_FT_DS3 Attached PDF or Text Where applicable, provide, using a searchable PDF or text format, the full text of all provisions in the tariff concerning how Ethernet purchases are eligible to count toward fulfillment of DS3 channel terminations purchase commitments (i.e., the product of the percentage commitment and the volume commitment), and include citations to those provisions. This question calls for a narrative response that must be submitted in the Word document per the instructions in the Introduction of this data template. 2 (iii) Citations_FT_Other Attached PDF or Text Where applicable, provide using a searchable PDF or text format, the full text of all provisions in the tariff concerning how Ethernet purchases are eligible to count toward fulfillment of purchase commitments (i.e. the product of the percentage commitment and the volume commitment), other than DS1 and DS3 channel terminations purchase commitments, and include citations to those provisions. This question calls for a narrative response that must be submitted in the Word document per the instructions in the Introduction of this data template. Instructions for Table I Page 5 Variable Identifier Variable Name Format Example Entries Description 2 (iv) Citations_Other_Desc Text Where applicable, provide narrative description of the types of other TDM business data services, other than DS1 channel terminations and DS3 channel terminations, whose percentage commitment may be fulfilled by Ethernet purchases. This question calls for a narrative response that must be submitted in the Word document per the instructions in the Introduction of this data template. 3 Business_Reason_Ethernet_Limit Text Provide a narrative description of the business rationale for each provision, condition, qualification, or limitation on technology migration, such as limitations on the counting of Ethernet purchases toward the fulfillment of applicable percentage commitments. This question calls for a narrative response that must be submitted in the Word document per the instructions in the Introduction of this data template. Paragraph 81 1 Upper_Percentage_Threshold 1, 0 Enter 1, if the tariff pricing plan has an upper percentage threshold, above which an overage penalty is triggered if a customer's purchases exceed that threshold. Enter 0, otherwise. 2 Citation_FT_UPT Attached PDF or Text If the tariff pricing plan has an upper percentage threshold, then provide the full text (which may be a searchable PDF) and a citation to the section number of the tariff pricing plan containing the upper percentage threshold provision. This question calls for a narrative response that must be submitted in the Word document per the instructions in the Introduction of this data template. 3 (i) Overage_Percent_Threshold_DS1 Excel Number 150% Where applicable, provide the maximum percentage of the volume commitment for DS1 channel terminations that a customer may purchase and maintain without incurring an overage penalty. 3 (ii) Overage_Percent_Threshold_DS3 Excel Number 150% Where applicable, provide the maximum percentage of the volume commitment for DS3 channel terminations that a customer may purchase and maintain without incurring an overage penalty. 3 (iii) Overage_Percent_Threshold_Other Excel Number 150% Where applicable, provide the maximum percentage of the volume commitment for other TDM business data services that a customer may purchase and maintain without incurring an overage penalty. 3 (iv) Overage_Pct_Thrs_Other_Desc Text If applicable, provide a narrative description of the other TDM business data services to which the Overage_Percent_Threshold_Other applies, including the type of business data services, how they are denominated, the relevant units of measure, and how each type of business data services counts toward the overage calculation. This question calls for a narrative response that must be submitted in the Word document per the instructions in the Introduction of this data template. 4 Auto_Increase_Overage Excel Number 0,1 An indicator of whether the pricing plan includes a provision for automatic increase of the volume commitment in the event of an overage. Instructions for Table I Page 6 Variable Identifier Variable Name Format Example Entries Description 5 Citation_FT_Auto_Incr_Overage Attached PDF or Text If the pricing plan requires an automatic increase of the volume commitment of a purchaser that exceeds an upper percentage threshold, provide the full text of the provision (which may be a searchable PDF) and a citation to the relevant section of the pricing plan. This question calls for a narrative response that must be submitted in the Word document per the instructions in the Introduction of this data template. Instructions for Table I Page 7 Tariff_Name Pricing_Plan_Name Section_Number Ameritech Operating Companies Tariff F.C.C. No. 2 Discount Commitment Plan (DCP) 7.4.13 … … … Table I - Tariff Plan Data Page 8 Percentage_Commit Percentage_Commit_Option All_Or_Nothing 0, 1 0, 1 0, 1 … … … Table I - Tariff Plan Data Page 9 Circuit_Portability_Mandated Circuit_Portability_Option Circuit_Portability_Method_Expl 0, 1 0, 1 … … … Table I - Tariff Plan Data Page 10 Cost_All Efficiency_All Cost_Port … … … Table I - Tariff Plan Data Page 11 Efficiency_Port Other_Business_Purpose Percentage_Commit_DS1 90% … … … Table I - Tariff Plan Data Page 12 Percentage_Commit_DS3 Percentage_Commit_Other Percentage_Commit_Other_Desc 90% 90% … … … Table I - Tariff Plan Data Page 13 Max_Daily_Process Citation_FT_Max_Daily Circuit_Migration_Charge 50 $ 1,000 … … … Table I - Tariff Plan Data Page 14 Circuit_Migr_Chg_Expl Ethernet_DS1_Commit Ethernet_DS3_Commit 0, 1 0, 1 … … … Table I - Tariff Plan Data Page 15 Ethernet_Other_Commit Ethernet_Other_Commit_Desc Citations_FT_DS1 0, 1 … … … Table I - Tariff Plan Data Page 16 Citations_FT_DS3 Citations_FT_Other Citations_Other_Desc … … … Table I - Tariff Plan Data Page 17 Business_Reason_Ethernet_Limit Upper_Percentage_Threshold Citation_FT_UPT … … … Table I - Tariff Plan Data Page 18 Overage_Percent_Threshold_DS1 Overage_Percent_Threshold_DS3 Overage_Percent_Threshold_Other 150% 150% 150% … … … Table I - Tariff Plan Data Page 19 Overage_Pct_Thrs_Other_Desc Auto_Increase_Overage Citation_FT_Auto_Incr_Overage 0,1 … … … Table I - Tariff Plan Data Page 20 Instructions for Completing Table IIA: Incidence of Discounted Purchases (See Order, Paragraph 65) For each pricing plan offered by the ILEC under each tariff under investigation (see Appendix A) and each calendar year from 2012 through 2014, provide quantity and revenue data requested below. Revenues from overage, shortfall, and early termination penalties should not be included in this table. Variable Identifier Variable Name Format Example Entries Description 1 Tariff_Name Text Ameritech Operating Companies Tariff F.C.C. No. 2 The name of the tariff (from Appendix A). 2 Pricing_Plan_Name Text Discount Commitment Plan (DCP) The name of the a pricing plan (from Appendix A) within the tariff listed above. 3 Section_Number Text 7.4.13 The section number or numbers (from Appendix A) that specifies a complete tariff pricing plan between an ILEC and a customer. 4 Year Excel Number 2012 The calendar year in which sales occurred. 5 (i) Discount_Quant_DS1 Excel Number 10,000 The average number of in-service DS1 channel terminations sold at a pricing under this tariff pricing plan during the relevant calendar year. 5 (ii) Discount_Quant_DS3 Excel Number 10,000 The average number of in-service DS3 channel terminations sold at a pricing under this tariff pricing plan during the relevant calendar year. 5 (iii) Discount_Quant_Other Excel Number 10,000 Using an equivalency unit of measure, provide the average quantity or number of all other TDM business data services, including transport (channel mileage and channel mileage termination), sold at a pricing under this tariff pricing plan during the relevant calendar year. 5 (iv) Discount_Quant_Other_Desc Text Provide a narrative explanation of the types of all other TDM business data services included in Discount_Quant_Other, how these are denominated, and the relevant units of measure. This question calls for a narrative response that must be submitted in the Word document per the instructions in the Introduction of this data template. 6 (i) Discount_Rev_DS1 Excel Dollar $1,500,000,000 The revenue for all DS1 channel terminations sold under this tariff pricing plan for the calendar year. 6 (ii) Discount_Rev_DS3 Excel Dollar $1,500,000,000 The revenue for all DS3 channel terminations sold under this tariff pricing plan for the calendar year. 6 (iii) Discount_Rev_Other Excel Dollar $500,000,000 The revenue for all other TDM business data services (e.g., transport, multiplexing, other features or functions) sold under this tariff pricing plan for the calendar year. 6 (iv) Discount_Rev_Total Excel Dollar $3,500,000,000 The revenue for all business data services sold at a pricing under this tariff pricing plan for the calendar year. Instructions for Table IIA Page 21 Tariff_Name Pricing_Plan_Name Section_Number Ameritech Operating Companies Tariff F.C.C. No. 2 Discount Commitment Plan (DCP) 7.4.13 … … … Table IIA - Discounted Purch Page 22 Year Discount_Quant_DS1 Discount_Quant_DS3 2012 10,000 10,000 … … … Table IIA - Discounted Purch Page 23 Discount_Quant_Other Discount_Quant_Other_Desc Discount_Rev_DS1 10,000 $1,500,000,000 … … … Table IIA - Discounted Purch Page 24 Discount_Rev_DS3 Discount_Rev_Other Discount_Rev_Total $1,500,000,000 $500,000,000 $3,500,000,000 … … … Table IIA - Discounted Purch Page 25 Instructions for Completing Table IIB: Incidence of Undiscounted Purchases (See Order, Paragraph 65) For each tariff under investigation (see Appendix A) and each calendar year from 2012 through 2014, provide quantity and revenue data requested below. Revenues from overage, shortfall, and early termination penalties should not be included in this table. Variable Identifier Variable Name Format Example Entries Description 1 Tariff_Name Text Ameritech Operating Companies Tariff F.C.C. No. 2 The name of the tariff (from Appendix A). 2 Year Excel Number 2012 The calendar year in which sales occurred. 3 (i) Undiscounted_Quant_DS1 Excel Number 10,000 The average number of in-service DS1 channel terminations sold at the regular undiscounted rate under this tariff during the relevant calendar year. 3 (ii) Undiscounted_Quant_DS3 Excel Number 10,000 The average number of in-service DS3 channel terminations sold at the regular undiscounted rate under this tariff during the relevant calendar year. 3 (iii) Undiscounted_Quant_Other Excel Number 10,000 The average quantity or number of all other TDM business data services sold at the regular undiscounted rate under this tariff during the relevant calendar year. 3 (iv) Undiscounted_Quant_Other_Desc Text Provide a narrative explanation of the types of all other TDM business data services included in Undiscounted_Quant_Other, how these are denominated, and the relevant units of measure. This question calls for a narrative response that must be submitted in the Word document per the instructions in the Introduction of this data template. 4 (i) Undiscounted_Rev_DS1 Excel Number $1,500,000,000 The revenue for all DS1 channel terminations sold at the regular undiscounted rate under this tariff during the relevant calendar year. 4 (ii) Undiscounted_Rev_DS3 Excel Number $1,500,000,000 The revenue for all DS3 channel terminations sold at the regular undiscounted rate under this tariff during the relevant calendar year. 4 (iii) Undiscounted_Rev_Other Excel Number $1,500,000,000 The revenue for all other TDM business data services sold at the regular undiscounted rate under this tariff during the relevant calendar year. 4 (iv) Undiscounted_Rev_Total Excel Number $4,500,000,000 The revenue for all business data services sold at the regular undiscounted rate under this tariff during the relevant calendar year. Instructions for Table IIB Page 26 Tariff_Name Year Undiscounted_Quant_DS1 Ameritech Operating Companies Tariff F.C.C. No. 2 2012 10,000 … … … Table IIB - Undiscounted Purch Page 27 Undiscounted_Quant_DS3 Undiscounted_Quant_Other Undiscounted_Quant_Other_Desc 10,000 10,000 … … … Table IIB - Undiscounted Purch Page 28 Undiscounted_Rev_DS1 Undiscounted_Rev_DS3 Undiscounted_Rev_Other $1,500,000,000 $1,500,000,000 $1,500,000,000 … … … Table IIB - Undiscounted Purch Page 29 Undiscounted_Rev_Total $4,500,000,000 … Table IIB - Undiscounted Purch Page 30 Instructions for Completing Table III: Purchase Agreements or Subscriptions to Tariff Pricing Plans (See Order, Paragraph 29) and Terms (See Order, Paragraph 64) For each agreement in effect during any part of calendar years 2012 through 2014, which include any competitive provider's or mobile wireless provider's purchases, provide purchase agreement and terms data requested below. For agreements under a tariff pricing plan that do not include purchases by competitive providers or mobile wireless providers (i.e, those that include only end-user purchases), incumbent LECs must provide this data and information for either the top 20 largest end-user customers (ranked by purchase revenue) or the customers with the greatest purchase revenue whose combined purchases constitute at least 80% of the incumbent LEC’s end-user (i.e., retail) sales, whichever includes fewer purchase agreements. Competitive provider means a competitive local exchange carrier (CLEC), interexchange carrier, cable operator, non-CMRS wireless provider or any other entity that is subject to the Commission’s jurisdiction under the Communications Act of 1934, as amended, and either provides a dedicated service or provides a connection over which a dedicated service could be provided. A competitive provider does not include an ILEC operating as an ILEC within its service territory. Mobile wireless provider means a CMRS carrier. We define volume commitment as the quantity of business data services (in units or in dollars) that the purchaser agrees to purchase from the ILEC. For example, the volume commitment could be 10,000 DS1 channel terminations. We define percentage commitment as the minimum percentage of the volume commitment that the purchaser must purchase in order to avoid triggering a shortfall penalty, as specified under the relevant tariff pricing plan. For example, the percentage commitment could be 90 percent. The purchase commitment is the quantity of business data services that a purchaser must purchase to avoid triggering a shortfall penalty and is the product of the volume commitment and the percentage commitment. In the above example, the purchase commitment is 10,000 DS1 channel terminations multiplied by 90 percent, or 9,000 DS1 channel terminations. Variable Identifier Variable Name Format Example Entries Description Purchase Agreement (Paragraph 29) 1 Agreement_ID Text 5496KB83 A unique 8-digit alphanumeric identifier designating an instance of an agreement between an ILEC and a purchaser to purchase business data services under a tariff pricing plan. The agreement ID must be unique to each combination of tariff name, pricing plan name, section number, start date, and customer ID. 2 Start_Date Excel Date 5/20/2011 The date that the agreement takes effect. Any agreement that commenced prior to 2012, which remained in effect during any part of calendar years 2012 through 2014, must be included. The start date may be before 2012. 3 End_Date Excel Date 5/20/2014 Expiration date of the agreement. If the agreement was extended, enter the expiration date of the extended agreement. 4 Tariff_Name Text Ameritech Operating Companies Tariff F.C.C. No. 2 The name of the tariff associated with the applicable Agreement ID. 5 Pricing_Plan_Name Text Discount Commitment Plan (DCP) The name of the pricing plan within the tariff listed above associated with the applicable Agreement ID. 6 Section_Number Text 7.4.13 The section number or numbers of the tariff that specifies the pricing plan associated with the applicable Agreement ID. 7 Purchaser_Name Text Windstream, Sprint, Level3, etc. Name of the purchaser associated with the Agreement ID. 8 (i) End_User_Purchaser Excel Number 0, 1 Enter 1, if the customer is an end user. Enter 0, otherwise. 8 (ii) Competitive_Provider_Purchaser Excel Number 0, 1 Enter 1, if the customer is a competitive provider. Enter 0, otherwise. 8 (iii) Mobile_Wireless_Purchaser Excel Number 0, 1 Enter 1, if the customer is a mobile wireless provider. Enter 0, otherwise. 9 Purchaser_ID Text 39STE212 A unique 8-digit alphanumeric identifier for a purchaser. For purchasers making more than one type of purchase, (i.e.. purchasing as a competitive provider, mobile wireless provider, or end user), the same Purchaser ID must be used for all types of purchases. Terms (Paragraph 64) 1 (i) Volume_Commit_DS1 Excel Number 10,000 Provide the number of DS1 channel terminations specified in the agreement as a volume commitment, as of the start date of the agreement, where purchase volumes falling below the volume commitment multiplied by the percentage commitment triggers a shortfall penalty. Enter -9999 if not applicable. 1 (ii) Volume_Commit_DS3 Excel Number 10,000 Provide the number of DS3 channel terminations specified in the agreement as a volume commitment, as of the start date of the agreement, where purchase volumes falling below the volume commitment multiplied by the percentage commitment triggers a shortfall penalty. Enter -9999 if not applicable. 1 (iii) Volume_Commit_Other Excel Number 20,000 Where applicable, using an equivalency unit of measure, provide the quantity of all other TDM business data services specified in the agreement as a volume commitment, as of the start date of the agreement, where purchase volumes falling below the volume commitment multiplied by the percentage commitment triggers a shortfall penalty. Enter -9999 if not applicable. Instructions for Table III Page 31 Variable Identifier Variable Name Format Example Entries Description 1 (iv) Volume_Cmt_Other_Expl Text Where applicable, provide narrative description of the types of business data services specified in Volume_Commit_Other, including a description of how the commitment is denominated and the relevant units of measure. This question calls for a narrative response that must be submitted in the Word document per the instructions in the Introduction of this data template. 2 (i) Basis_Volume_Commit Excel Number 0, 1 Enter 1, if any volume commitments are set equal to the quantity of purchases on the start date (i.e., the date of signing) of this agreement. Otherwise, enter 0. 2 (ii) Basis_Volume_Commit_Expl Text If Basis_Volume_Commit was set to 0, then provide narrative explanation of the basis for setting the volume commitment, including the date for which the quantity of business data services previously purchased may have been used to set the volume commitment. This question calls for a narrative response that must be submitted in the Word document per the instructions in the Introduction of this data template. 3 Basis_Change_Expl Text Where applicable, provide a narrative description of any change in policy during 2012 through 2014, regarding the basis for setting volume commitments. Provide detailed explanation for how the policy changed and the business justification for the change. This question calls for a narrative response that must be submitted in the Word document per the instructions in the Introduction of this data template. Instructions for Table III Page 32 Agreement_ID Start_Date End_Date 5496KB83 5/20/2011 5/20/2014 … … … Table III - Agreements Page 33 Tariff_Name Pricing_Plan_Name Section_Number Ameritech Operating Companies Tariff F.C.C. No. 2 Discount Commitment Plan (DCP) 7.4.13 … … … Table III - Agreements Page 34 Purchaser_Name End_User_Purchaser Competitive_Provider_Purchaser Windstream, Sprint, Level3, etc. 0, 1 0, 1 … … … Table III - Agreements Page 35 Mobile_Wireless_Purchaser Purchaser_ID Volume_Commit_DS1 0, 1 39STE212 10,000 … … … Table III - Agreements Page 36 Volume_Commit_DS3 Volume_Commit_Other Volume_Cmt_Other_Expl 10,000 20,000 … … … Table III - Agreements Page 37 Basis_Volume_Commit Basis_Volume_Commit_Expl Basis_Change_Expl 0, 1 … … … Table III - Agreements Page 38