Open Product/Process CR 5432820 Detail |
| Title: Update SAG records to match LEC records | ||||||
| CR Number |
Current Status Date |
Area Impacted | Products Impacted | |||
|
|
||||||
| 5432820 |
Completed 9/19/2001 |
Pre-Ordering | Centrex, Unbundled Loop | |||
| Originator: Sprague, Michelle |
| Originator Company Name: Eschelon |
| Owner: Thompson, Jeff |
| Director: |
| CR PM: Esquibel-Reed, Peggy |
Description Of Change |
|
Not getting an appropriate match in SAG, during the address validation process. The LEC record address is being used in the attempt to validate against SAG, but the SAG records do not match the LEC records. Requesting that Qwest performs a mass update on the SAG files to correspond with the LEC records, or that the LEC records are revised to match the SAG address files.
|
| Date | Action | Description |
| 3/5/2001 | Received CR from Mark Routh – CICMP Manager – Systems | |
| 3/7/2001 | Status changed to New – To be Reviewed | |
| 3/7/2001 | Status changed to Reviewed – Under Consideration 3/07/01 – Discussed in March CR review meeting | |
| 3/7/2001 | Qwest is not able to modify the SAG and will not change the LEC. (JT) | |
| 3/21/2001 | Unable to close due to McLeod’s absence at the March CICMP meeting. (MR) | |
| 4/16/2001 | Unable to cancel CR due to Michelle Sprague’s absence from the April CICMP Industry Forum. (MR) | |
| 5/18/2001 | Unable to cancel CR due to Michelle Sprague’s absence from the April CICMP Industry Forum. (MR) | |
| 6/20/2001 | Unable to cancel CR due to Michelle Sprague’s absence from the April CICMP Industry Forum. (MR) | |
| 7/11/2001 | Email sent to Michelle Sprague to close CR – Clarification on response requested. | |
| 8/28/2001 | Response emailed to Michelle Sprague at McLeod USA | |
| 8/28/2001 | Walk through meeting held | |
| 8/29/2001 | Michelle Sprague closed CR via email to Qwest | |
| 9/19/2001 | Response Accepted at the 09/19/2001 CMP Forum | |
| 9/19/2001 | CR Closed at the 09/19/2001 CMP Forum |
Project Meetings |
| Email from Michelle Sprague, McLeod USA August 29, 2001 Concurs with the closing of CR5432820. Tuesday, August 28, 2001, Walk through Meeting Attendees: Michelle Spraque - McLeod, Peggy Esquibel-Reed, Todd Mead, and Irene Haskins/Qwest CLEC Expectations: McLeod would like Qwest to perform a mass update on the SAG files to correspond with the LEC records, or that the LEC records are revised to match the SAG address files. Mcleod agreed to close the CR and open another to address the following questions: During the address validation process via EDI, when performs an AVQ Hit, SAG address is returned. When performs a CSRQ Hit, the address from the CSR is returned. When the ISC gets an order from a CLEC, does the ISC use the address from the SAG or from the CSR? Which is the correct data source to use? Can the CLEC use just one of these data sources instead of both? Does the ISC use the SAG or the MSAG (911 address)? Which should be used? Wednesday, August 15, 2001, CLEC CMP Meeting Product & Process. Lynne Powers questioned how SAG records get updated. Jeff Thompson advised that he wasn't sure how Telcordia issues updates, but Qwest can't get Telcordia to utilize Qwest's database. Jeff indicated that he would do some research on finding out how to get updates to Telcordia for their database. Mcleod provided Michelle Sprague as their contact at 319-790-7402.
|
CenturyLink Response |
|
August 27, 2001 Michelle Sprague OSS Manager, McLeod USA This letter is in response to the following CLEC Product & Process Change Request Form #5432820. Request: Not getting an appropriate match in SAG, during the address validation process. The LEC record address is being used in the attempt to validate against SAG, but the SAG records do not match the LEC records. Requesting that Qwest performs a mass update on the SAG files to correspond with the LEC records, or that the LEC records are revised to match the SAG address files. Qwest agreed to investigate and report on what the process was for updating the SAG. Qwest Response: * SAG is a Telecordia product. * Qwest is not able to modify the SAG and will not change the LEC. * The CLEC SAG book is a hybrid, it’s a Telecordia product and is an extract of the PREMIS database. It is created monthly. The CLEC SAG takes the QWEST SAG and additional information is extracted from the database and concatenates the two. Items not appropriate are not extracted and an item such as an NPA wire center that isn’t in the regular SAG book is added. * Qwest process for updating the SAG: - The Address Management Center’s are responsible for the data in PREMIS. Any service order fall-out or addresses that need to be updated, they are the group that does the work. - Should the CLEC find an address range that is incorrect, the CLEC calls interconnect and give’s them that information. - Interconnect contacts the AMC. - The AMC verifies with the appropriate county to make sure is valid and if it is, they update the database. - The following months extract will contain the new information. - Data is only extracted or updated once a month. Jeffery L. Thompson Director, Information Technologies
|
Information Current as of 1/11/2021