Wholesale: Products & Services

Archived System CR SCR033009-3 Detail

CEMR Report Histories should be archived on the same schedule.

Status History

Project Meetings

8/19/09 Systems CMP Meeting

Denise Martinez-Qwest said we have looked into this and the functionality that drives this is WFA which is a Telecordia system. We looked at how we could handle this outside of having to make a system update since we know it would be very costly and timely. Qwest does not have a different schedule for archiving tickets. All repair tickets are maintained for a 60 day retention period and become eligible once billing forms are in a completed status. The archive run looks at any trouble ticket in a Closed or Canceled status and if that meets the archive setting, it becomes a candidate for archive. If the ticket has an associated billing form that is not in a Completed status, then that ticket is no longer an archive candidate until the billing form is in a Completed status. Denise said that based on the volumes provided to us we believe that we have a manual process that we can document that can handle those small volumes. Denise reviewed the proposed process as follows: In order to retrieve data once it is archived, a request must be made via email through Wholesale Service Management. The email request should be titled: OSSLOG Request It must contain at a minimum: • The trouble ticket number • CAC code • Completion date of the ticket NOTE: TN or circuit ID are NOT sufficient and could present hundreds of responses. The Service Manager will forward the email request to obtain the detail needed. The requested data will be provided in a few days turn around, in most cases.

Bonnie Johnson-Integra said that Qwest said the turnaround would be days. She said they have had multiple service managers having a hard time getting archived tickets out of WFA.

Denise Martinez-Qwest said we do have a group that can do this for us and we are looking at days for providing the information. Denise said this is based on the volumes that were given to us. Denise said that if the volumes are larger, we may have to reassess.

Bonnie Johnson-Integra said they are trying to verify Qwest billing and the problem is that the archiving process happens before they get a bill in some cases. Bonnie said if Qwest is going to bill, they should be able to verify that process. She said Integra will take this back to the group who most needs it and asked if Qwest would be sending out a proposed process.

Denise Martinez-Qwest said we can have the process documented in the October CEMR release. She said there should not be an issue if the CLECs can provide those 3 pieces of information to the service manager and said we believe we can get the information to them within a few days.

Bonnie Johnson-Integra said they would be willing to try the process but don’t want to withdraw the CR in the event it doesn’t meet their needs.

Kim Isaacs-Integra said that the biggest issue is with those tickets that don’t have the archiving billing associated with them. She gave an example of when they have 1 ticket they are being billed for and another ticket that is opened the following day that turns out to be a Qwest problem. She said that ticket is archived and they can’t see it but the billing ticket is still there.

Denise Martinez-Qwest said that she understood and if they were willing to try this manual process we would appreciate it. She said that we are being told that to do this mechanically would be $10M. We would like to find another way because with Telecordia we have no control and we don’t want to work with that price tag. She said if they are willing to work with us and if they have one that comes up before the October release we can use as a trial.

Susan Lorence-Qwest asked if that would work for them.

Bonnie Johnson-Integra said they were willing to give it a try.

Susan Lorence-Qwest said since this is a system CR and we already have an October release scheduled, we are proposing that the CEMR online help be updated with that October release.

Bonnie Johnson-Integra said that would work and asked that the status of this CR be changed to a deferred status. They also want another CR issued that outlines what Qwest is going to do.

Susan Lorence-Qwest said that we can look at whether it would be appropriate for Integra or Qwest to generate that CR. She said that we believe this process will assist in this solution.

Bonnie Johnson-Integra said they are willing to try but they don’t want to lose sight of this CR in the event this doesn’t work.

Susan Lorence-Qwest said that we will work with Kim to see what we need to do with the CR.

4/15/09 Systems CMP Meeting

Kim Isaacs-Integra said that Integra is seeing an increase of incidents in CEMR tickets that are opened on the same day for the same end user with different circuit IDs. Kim said that that are finding that one of the CEMR reports history/OSSLOG is being archived and the other is available. She said that they are requesting that the archiving of the report history be standardized so that all tickets are being archived at the same period of time. Kim said that that are asking that the report history be archived in a manner that allows them 2 months.

Bonnie Johnson-Integra asked that it be longer if possible.

4/6/09 Clarification Meeting

Attendees: Kim Isaacs-Integra, Bonnie Johnson-Integra, Denise Martinez-Qwest, Nicole James-Qwest, Rick Breeze-Qwest, Lisa Preble-Qwest, Linda Hughes-Qwest, Denise Conway-Qwest, Justin-Sewell-Qwest, Lynn Stecklein-Qwest

Lynn Stecklein-Qwest stated that the purpose of this call is to clarify SCR033009-3 Archiving of CEMR Report History/OSSLOG submitted by Integra. Lynn reviewed the decrisption of change as follows: Increasingly, Integra is finding that some tickets Report Histories/OSSLOGs are not available in CEMR because they have been archived. Integra is seeing that tickets Qwest has billed for are archived on a different schedule than tickets Qwest did not bill for. Example: 29/LXFU/371762/MS OC284049 dispatch date 12/17/08 NTF is available in CEMR but same customer, same location 29/LXFU/371761/MS OC284001 dispatch date 12/17/08 where Qwest changed carbons is not available in CEMR. Integra has a need to view all tickets opened on a given date. Qwest has 2 bill periods to apply charges associated with repair tickets. Qwest should wait at least 2 bill periods before the CEMR ticket is placed in archives. CEMR Report Histories should be archived on the same schedule.

Justin Sewell-Qwest asked in the case of when the OSS LOG wasn't available,what message did Integra get.

Kim Isaacs-Integra said that she got a circuit ID error.

RIck Breeze-Qwest said that particular ticket was not in WFA and that they don't get archived in CEMR.

Kim Isaacs-Integra said that she got the missing attribute - required data is either missing or has invalid value. Kim said that if you go to the circuit history you can see the ticket but when you go to the report history, there is nothing there. Kim said there are seeing this more and more.

Lynn Stecklein-Qwest said that Integra will be presenting this CR in the April 15th CMP meeting.

CenturyLink Response