Wholesale: Products & Services

Open Product/Process CR PC070103-1 Detail

Description Of Change

MCI is requesting that Qwest implement a "Lines In Service Report". This report would result in what Qwest reflects as active UNE-P and Resale lines in service that belong to a given CLEC on the date the report is generated. MCI is requesting that the report be provided on a monthly basis via CD-ROM or equivalent media type. This report would provide needed insight to any discrepancies between CLEC customer data and Qwest data and assist with reconciliation efforts.

Information MCI requests on the report:

- CLEC Name

- ACNA - Access Customer Name Abbreviation

- BTN - Billing Telephone Number

- WTN - Working Telephone Number

- Service Delivery Method

- Original Migrate/Completion Date

- Date of snapshot extract

- Type of Service (Bus/Res)

- State

Expected Deliverable:

That Qwest provide a "lines in service report" for UNE-P and Resale lines on a monthly basis via CD-ROM or equivalent media type.

Project Meetings

-- 09/16/04 CMP Meeting Minutes Laura McGhghy reported that Qwest would like to leave this CR in Test for one more month. MCI is doing additional analysis and the intent is to have this ready to close next month and shift to the normal process involving the account manager. LeiLani Hines agreed and said that there was a conference call on Monday and due to some confusion when Liz Balvin left MCI we needed to get back on track. MCI will be submitting a new report and she is in agreement with leaving this in Test Status.

- 8/18/04 CMP Meeting Cindi Houston reported that Qwest had began an analysis of the items sent from MCI and requested clarification from MCI on some issues. She is currently awaiting MCI’s reply. Leilani Hines said she will check the status on the MCI side. The CR will remain in Test.

7/21/04 July CMP Meeting Liz Balvin, MCI said that MCI has been attempting to audit the report and have run into delays. She expected information from her MCI counterparts this week but has not received anything as yet. There are several issues and Liz is attempting to ascertain if the issues are MCI or Qwest. Liz will forward issues and examples to Doug Andreen when available. The CR will remain in Test.

6/28/04 9:00 a.m. To: 'liz.balvin@mci.com' From: Sanchez Steinke, Linda CR PC070103-1 Provide "Lines In Service Report" to CLECs

Hi Liz -

As a follow up to our discussion about this CR at the June CMP, has MCI been able to finish the audit and be able to close this CR mid-cycle?

Thank you

Linda Sanchez-Steinke Qwest CRPM 303-382-5768

06/16/04 June CMP Meeting Liz Balvin with MCI asked that the CR remain open for one more month until the audit is completed. If this is done before the next CMP, Liz will e-mail to close the CR. This CR will remain in CLEC Test status.

05/19/04 May CMP Meeting Laura McGhghy with Qwest said she had received additional requests for the reports and asked that the CR be closed. Liz Balvin asked that the CR remain open because they were supposed to have completed an audit but it has not been completed as of yet. This CR will remain in CLEC Test status.

04/21/04 April CMP Meeting Laura McGhghy with Qwest advised we are continuing to provide this report. Bonnie Johnson with Eschelon said she didn’t think Eschelon has the ability to get the report sooner than when the March data is available. Laura said that we are processing now for the March report. This CR will move to CLEC Test status.

03/17/04 March CMP Meeting Laura McGhghy with Qwest said she wanted to clear up any confusion regarding the lines in service report. The report is based on MR8 PID data and Qwest needs time to update tables and this report request follows the standard process for PID data reports. The CLEC should request the report prior to the first of the month and gave an example that if the request is received by the first of March, March results will be available at the end of April. Bonnie Johnson with Eschelon said that when the notice came out it said January data would be available at the end of February. Laura said that the notification was specific to MCI’s request, and, due to the timing of Eschelon’s report request, the Eschelon report will be ready at the end of April. This CR will remain in Development status.

- 02/18/04 February CMP Meeting Laura McGhghy with Qwest gave an update that 2/27/04 is targeted to provide the January data. In addition to the report, there will be a product code explanation file that provides a product code definition. Jennifer Arnold with U S Link asked how to get the report. Laura explained they should contact their service manager to request. This CR will remain in Development status.

01/21/04 January CMP Meeting Laura McGhghy with Qwest gave an update that January data will be provided at the end of February and that a notification will be sent. This CR will remain in Development status.

12/17/03 December CMP Meeting Laura McGhghy with Qwest gave an update on the CR. Laura said that during the ad hoc meeting she had an action item to determine if BTN would be available for non-design services. BTN will not be available for non-design services and will be available for design services. Laura added that the reports will be provided by state and each state will have one report for design services and one report for non-design services. Liz Balvin with MCI clarified that the reports will be state specific and will be broken down by design and non-design reports. This CR will remain in Development status.

11/19/03 November CMP Meeting Laura McGhghy with Qwest provided an update on this CR and said that Qwest is continuing development and expects to provide January results in the February timeframe. Liz Balvin with MCI asked how the CLECs would get the data. Laura said that the data will be available where the PID results are located. This CR will remain in Development Status.

Ad Hoc Meeting Minutes PC070103-1 Provide "Lines In Service Report" to CLECs CMP Product & Process October 29, 2003 1-877-572-8687, Conference ID 3393947# 9:00 a.m. - 10:00 a.m. Mountain Time

PURPOSE

At the October CMP Meeting, participants agreed to hold a conference call to review the format for the report. The following is the write-up of the discussion.

List of Attendees: Donna Osborne-Miller, AT&T Liz Balvin, MCI Kim Issaacs, Eschelon Kathy Stitcher, Eschelon Cedric Cox, MCI Ed Boehme, MCI Laura McGhghy, Qwest Dave Phillips, Qwest Jon Boisseau, Qwest Linda Sanchez-Steinke, Qwest

MEETING MINUTES

The meeting began with Qwest making introductions and welcoming all attendees.

Linda Sanchez-Steinke with Qwest explained that the purpose of the meeting was to review the draft report format. Laura McGhghy with Qwest reviewed the draft reports. Resale design products and non-design products will be available in two files. Design Products report will include; CLEC ID, ACNA, BTN, Circuit ID, Product Code, Extract date, and State. Non-Design Products report will include; CLEC ID, WTN, Product Code, Extract Date and State.

Liz Balvin with MCI asked for further definition of the product code. Laura McGhghy said that the product name, i.e., DS1 would mean resale DS1. Liz asked if the CLEC ID would be the RSID. Laura said yes.

Laura continued explaining the report and said that the original migration date is not something that is in our system and is unavailable for the reports.

Cedric Cox with MCI asked if the BTN is available on non-design and added that most ILECs normally want the BTN with the WTN for disputes. Dave Phillips said that BTN is not available in the data that will be provided with the current report design. Cedric asked if the customer has multiple lines, will the WTNs show on the report as belonging to the CLEC. Dave answered yes. Laura took an action item to find out if BTN is available on the non-design data.

Liz Balvin asked if the report was derived from PREMIS or CRIS, as PREMIS only has WTN data. Dave said that the non-design data is coming from LMOS, and the design data is from TIRKS.

Cedric asked if there was a dispute on a WTN would the CLEC have to provide the BTN. Dave Phillips answered that we would have to work through disputes with the data available.

Liz asked if the extract date is the date the data is pulled from LMOS. Dave and Laura responded that it is the date the data is pulled from either LMOS or TIRKS.

Cedric asked if there will be indication of Residence or Business. Laura said that Res or Bus will be in the product code. Laura and Dave committed to provide a list of the prodcd’s and their English names to MCI.

Liz asked if they could get valid values populated and what date the reports would be available. Laura said that when the data is pulled the extract date is a snapshot of the date it occurs. Dave will find out when the data will be pulled and get back to MCI.

Cedrick asked what the dispute process is if they have 1000 ANI’s that they believe do not belong to them. Jon Boisseau said there is the informal reconciliation process, the formal process through the PAP and Service Management can also take the dispute to regulatory reporting.

Kathy Stitcher with Eschelon asked if unbundled loop would be in the design file. Laura said that resale and any other design type products would be in the design file.

Linda asked if there were any questions. No questions were asked.

10/15/03 October CMP Meeting Laura McGhghy with Qwest provided an update on this CR. Qwest plans to have January data available in the month of February. Laura would like to hold an ad hoc meeting to discuss the draft format of the report. Linda Sanchez-Steinke will e-mail Liz with possible dates for the meeting. This CR will remain in Development Status.

09/17/03 September CMP Meeting Laura McGhghy with Qwest provided the Qwest draft response. Qwest will provide the report requested and target January 2004 for the data to be available. Liz Balvin said would like to see the data in a draft form as soon as available. Other CLECs would like to get the report as well and Laura said they should request the report through their service manager. This CR will move to Development Status.

08/20/03 August CMP Meeting Laura McGhghy with Qwest reviewed the draft response and said Qwest is investigating possible solutions for this CR and will have an updated response at the September meeting. This CR will be moved to Evaluation status.

07/16/03 July CMP Meeting Liz Balvin with MCI presented this CR. MCI would like a monthly report of UNE-P and Resale lines in service. This report would give the ability to sync up the lines in service with the CLEC and Qwest. Sue Kriebel asked for the name of the report provided for access lines and Liz will provide the information to Linda Sanchez-Steinke. Dusti Bastian asked what additional data fields would be included in the monthly report vs. the daily loss and completion report. Liz said this report will be on a specific month timeframe and will include lines in service Qwest identifies and tie back to losses, helping to track and resolve issues. Sue Kriebel asked how the monthly report would be different from the CSR report that identifies lines in service. Liz said they have to access the CSR. Sue said the CSR is received along with the bill, and when the bill is received you can see the TN that is being billed. Liz said that billing isn’t what Qwest identifies as the lines in service and there would also be timing issues with the CSR report. Sue asked if the monthly report would be pulled on a different day than the bill and Liz said MCI wants the report pulled on the 1st or the 31st of the month. Bonnie Johnson with Eschelon said that the loss and completion report received daily only identifies service order activity and not total lines in service. Liz would like to understand why the CR was unilaterally changed to a Product / Process CR and Kit Thomte with Qwest apologized that the CR was acknowledged as Product and Process without an explanation when MCI had requested it be a Systems CR.

CLEC Change Request Clarification Meeting

3:00 p.m. (MDT) / Friday, July 11, 2003

1-877-572-8687 3393947# PC070103-1 Provide "Lines In Service Report" to CLECs

Name/Company: Liz Balvin, MCI Cedric Cox, MCI Donna Lucio, Qwest Fred Howard, Qwest Kerri Waldner, Qwest Luke Von Hagen, Qwest Don Kerschner, Qwest Laurel Nolan, Qwest Linda Sanchez-Steinke, Qwest

Introduction of Attendees Introduction of participants on the conference call was made and the purpose of the call discussed.

Review Requested (Description of) Change MCI’s CR requests that Qwest implement a "Lines In Service Report". This report would result in what Qwest reflects as active UNE-P and Resale lines in service that belong to a given CLEC on the date the report is generated. MCI is requesting that the report be provided on a monthly basis via CD-ROM or equivalent media type. This report would provide needed insight to any discrepancies between CLEC customer data and Qwest data and assist with reconciliation efforts.

Information MCI requests on the report: - CLEC Name - ACNA - Access Customer Name Abbreviation - BTN - Billing Telephone Number - WTN - Working Telephone Number - Service Delivery Method - Original Migrate/Completion Date - Date of snapshot extract - Type of Service (Bus/Res) - State

Liz Balvin with MCI said that Qwest has a similar lines in service report on the Access side and this report allows a sync up with installed services and allows them to catch discrepancies sooner. Kerri Waldner with Qwest asked if the items requested are being provided in any other report. Liz said that she is not aware of any other report providing this information. Dusti Bastian asked for a definition of Service Delivery Method. Cedric said that is the product type, resale or UNE-P. Fred Howard asked if the report was requesting data for MCI only. Cedric answered yes, MCI only is what is requested. Dusti asked if this report would be for services billed or for services provisioned. Cedric said for those services provisioned.

Kerri asked if the report would be a snapshot in time with no accumulation. Cedric said that the report would be a snapshot in time. Donna Lucio asked about the timing of the report and if MCI would want the report at the first or the last of the month. Liz and Cedric said it didn’t matter what date the report is pulled and that they are looking for a monthly report. Cedric said that MCI would take the TN’s and bounce them against a database for telco billing and traffic data. This would give them line loses that they hadn’t been made aware of previously. Kerri asked if MCI wants to get this monthly, would it be a snap shot in time or a monthly compilation. Liz and Cedric answered they would like a snapshot in time and don’t need a cumulative report.

Liz said that she is concerned with the unilateral conversion process that this CR was moved to Product and process and would like an explanation why the CR was handled in this way.

Confirm Areas & Products Impacted Products impacted with this CR are UNE and Resale Lines.

Confirm Right Personnel Involved Qwest confirmed the correct personnel were on the call to resolve the CR.

Identify/Confirm CLEC’s Expectation MCI’s expectation is a monthly report for active UNE-P and Resale lines in service.

Identify any Dependent Systems Change Requests No systems change requests.

Establish Action Plan (Resolution Time Frame) MCI will present this CR at the July CMP meeting.

CenturyLink Response

September 9, 2003

Liz Balvin MCI

SUBJECT: Qwest’s Change Request Response - CR PC070103-1 "Provide 'Lines in Service Report' to CLECs".

As a follow up to the August 20, 2003 CMP Meeting, Qwest is willing to provide a monthly report of all MCI lines in service for all products currently reported in 271 reporting.

This report will be available to MCI from the secure website where MCI obtains all other PID reporting data. Qwest is beginning investigation and coding work at this time and expects to have the data available to MCI in January 2004.

Sincerely,

Laura McGhghy Lead Process Analyst Qwest

August 13, 2003

DRAFT RESPONSE For Review by the CLEC Community and Discussion at the August 20, 2003 CMP Meeting

Liz Balvin MCI

SUBJECT: Qwest’s Change Request Response - PC070103-1 Provide "Lines In Service Report" to CLECs

MCI’s CR requests that Qwest provide a report reflecting active UNE-P and Resale lines in service that belong to a given CLEC on the date the report is generated.

Qwest is investigating possible solutions to this change request and will provide an updated response at the September CMP meeting.

Sincerely,

Donna Lucio Sr. Process Analyst Qwest

Cc: Sue Burson, Qwest Sue Kriebel, Qwest