Wholesale: Products & Services

Archived System CR SCR111501-1 Detail

 
Title: TRAK DCR RS FID Edit to Reduce Omissions from the Loss Report
CR Number Current Status
Date
Level of
Effort
Interface/
Release No.
Area
Impacted
Products
Impacted

SCR111501-1 Completed
8/21/2003
500 - 700   13/ LNP - Port Out
Originator: Johnson, Bonnie
Originator Company Name: Eschelon
Owner: Winston, Connie
Director:
CR PM: Esquibel-Reed, Peggy
Description Of Change
This CR is created by Qwest on behalf of Eschelon to address changes that had been in process as part of CMP Action Item #357/360. It is related to CR # 5522887 but is fixing a different root cause problem.

As part of AI357/360, Qwest agreed to implement system changes to correct a problem that is causing losses to be omitted from the Loss Report. It has been determined that included in this system fix, must be a requirement that on LNP Port Out orders on accounts that have RSIDs or ZCIDs on them, that we must have a edit built into the SOPS that creates an error if the Centers do not use on Partial ports the TRAK DCR RS fid behind the specific TN being ported or on full conversions the DCR RS must be required in the Bill section. The TRAK FID drives the order information to the Loss and Completion Reports used by both Qwest and the CLEC to track customer movement. Omitting the TRAK FID results in billing errors, as well as unnecessary calls to the Interconnect Service Centers. Using the DCR RS is the current process when porting out TNs on a Resold account, however because there are no edits in place, Qwest mistakingly uses a TRAK DCR CO fid which will not drive the information to the Loss report.

Upon implementation of this CR if the incorrect DCR code is placed on an issued order, that an error message will give the SDC an opportunity to correct the DCR code prior to the order processing down stream and order completion. This will assist in reporting the loss to the Resale Provider on their Loss report. Currently, flow through is programmed that if the account has an RSID or ZCID on it, that it will use the TRAK FID of DCR RS, the manual process should mirror this, and the edit will help to ensure that it does.

Status History

Date Action Description
10/2/2001 Action Item Created Eschelon sent spreadsheet examples to Qwest to investigate hidden columns; AI 357 created 
10/18/2001 Discussed at Monthly CMP Meeting Action formally submitted at Oct CMP meeting 
11/2/2001 Clarification Meeting Held Qwest holds clarification meeting with Eschelon; Qwest also reviewed response with Kathy and Bonnie at Eschelon. Eschelon accepted the response and agrees that it satisfies this action item. 
11/5/2001 Info Received From CLEC Eschelon sent an additional spreadsheet with examples of losses missing from the Loss Report. 
12/6/2001 Record Update Research on AI # 357 has revealed that some records do not carry the TRAK DCR RS FID when they should. Qwest is researching the feasibility of adding a system edit to validate the existence of this FID on partial loss service orders. 
12/14/2001 Discussed at Monthly CMP Meeting AI # 357 discussed at December Systems CMP Meeting; CLECs agreed to collapse AI #357 into AI #360; Qwest will report Loss & Completion results/status at each monthly Systems CMP Meeting 
1/17/2002 Discussed at Monthly CMP Meeting TRAK DCR FID issues discussed as part of Item #1 in Loss & Completions Matrix (Attachment F); corrective measures are "In Definition" 
2/21/2002 Discussed at Monthly CMP Meeting TRAK DCR FID issues discussed as part of Item #1 in Loss & Completions Matrix (Attachment H); corrective measures are "In Definition" 
3/21/2002 Discussed at Monthly CMP Meeting TRAK DCR FID issues discussed as part of Item #1 in Loss & Completions Matrix (Attachment H); corrective measures are "In Definition" 
4/18/2002 Discussed at Monthly CMP Meeting TRAK DCR FID issues discussed as part of Item #1 in Loss & Completions Matrix (Attachment H); corrective measures are "In Definition"; Qwest internal user request created 
4/22/2002 CR Submitted Change Request created on behalf of Eschelon to provide CLEC visibility to change being pursued for ensuring that partial loss orders carry the TRAK DCR RS FID 
4/22/2002 Status Changed Status changed from 'Submitted' to 'Clarification'; CR is following non-standard process b/c it started as an Action Item in the Oct/Nov timeframe; no Clarification call is being held for CR as Clarification calls were held for AI in November 
5/2/2002 Info Sent to CLEC Emailed copy of CR to Bonnie Johnson, Eschelon 
5/6/2002 Info Received From CLEC Received email from Bonnie Johnson/Eschelon: agree with the CR on their behalf. 
5/16/2002 Discussed at Monthly CMP Meeting SCR111501-01 discussed at May Systems CMP Monthly meeting; please see Systems CMP Distribution Package May CMP - Attachment B 
5/20/2002 Record Update Title changed From: More effective & accurate loss/completion reports (Part 2), To: TRAK DCR RS FID Edit to Reduce Omissions from the Loss Report. 
5/22/2003 Discussed at Monthly CMP Meeting  
6/19/2003 Discussed at Monthly CMP Meeting Discussed at the June Systems CMP Monthly meeting; please see June Systems CMP Distribution Package, Attachment G 
7/17/2003 Discussed at Monthly CMP Meeting Discussed at July Systems CMP Monthly Meeting; please see July Systems CMP Distribution Package -- Attachment G 
8/21/2003 Discussed at Monthly CMP Meeting Discussed at the August Systems CMP Monthly Meeting; please see August Systems CMP Distribution Package, Attachment G 

Project Meetings

August 21, 2003 Systems CMP Meeting Discussion: Bonnie Johnson/Eschelon stated that this CR is okay to close. There were no additional comments or questions.

-- July 17, 2003 Systems CMP Meeting Discussion: Connie Winston/Qwest stated that she believes that Eschelon is still validating. Bonnie Johnson/Eschelon asked what exactly was the edit. Connie Winston/Qwest stated that it was to add line level and ensure that the DCR was correct. Bonnie Johnson/Eschelon asked if it was for C or D orders. Connie Winston/Qwest stated that the C order edit deployed in June in a back end system and was at the order level. Connie stated that the edit for this CR is at the line level. Bonnie Johnson/Eschelon stated that she is still researching. This Change Request remains in CLEC Test.

- June 19, 2003 Systems CMP Meeting Discussion: Connie Winston/Qwest stated that an edit was implemented in April and asked if Eschelon has validated this. Bonnie Johnson/Eschelon stated that she would like this CR to remain open until she can validate. Bonnie asked if this has to do with the edit on C orders. Connie Winston/Qwest stated that this is for the line level. Connie stated that for the C orders, is later in the packet, is for the account level, and is targeted for July. Bonnie Johnson/Eschelon stated that she would look at it when she returns to the office. There were no additional questions or comments. This CR remains in CLEC Test.

-- May 22, 2003 Systems CMP Meeting Discussion Regarding SCR012802-1 Loss and Completions Reports, TNs should appear on both reports for the same date: Connie Winston/Qwest said that we implemented edits further up in our process to deal with this. We also put in an edit for the TRAK DCR FID CR. Bonnie Johnson/Eschelon said that she sent one day's data to 'CMPCR' and that Unbundled Loop was ok, but UNE-P and resale were not. Connie Winston/Qwest said thank you for the feedback. We will leave the CR open and continue to review the data. Bonnie Johnson/Eschelon said that if Qwest wanted Eschelon to send in another day of data to let her know. She sent the previous data about three weeks ago.

-- May 16, 2002 Systems CMP Meeting Discussion: Michael Buck/Qwest noted that we are closing the Loss &Completion Matrix. This CR was created in order to maintain visibility to the item after the Loss & Completion Matrix is closed. Michael Buck/Qwest asked if Bonnie Johnson/Eschelon had anything she wanted to add? Bonnie Johnson/Eschelon replied no. Qwest will be revising the title to better reflect the item. The status of this CR will be changed to presented.

CenturyLink Response

May 2, 2002: The level of effort for this request is 500 - 700 hours.

Information Current as of 5/4/2020