History Log

Description

Qwest provides several additional output reports that you can either choose to receive or will receive. These output reports are, but not limited to, the following:

• Station Message Detail Recording (SMDR) - provides call details on calls that originate from a Centrex Plus Common Block.
• Completion Reports - received when a service order is completed or cancelled in the Qwest Service Order Processing (SOP) system and impacts you.
• Loss Reports - received when a service order with outward line activity is completed or cancelled and impacts you.

SMDR
This file is sent in addition to any Daily Usage File (DUF) you receive, if you are providing services to a end-user who has Centrex Plus. You must request this report. You will receive this report in EMI Format and call detail is provided on the following types of calls:

• Originating intra/inter Local Access and Transport Area (LATA) toll
• Outward Wide Area Telecommunications Service (WATS)
• VoiceGrade/Foreign Exchange Channels
• Directory Assistance (DA) Calls

The call detail could include the following:

• Date of Call
• Time of Call
• Call Duration
• Station Line from which Call Originated
• Called Number
• Selected Carrier

Loss and Completion Reports
Loss and Completion Reports are generated for the following products:

• Unbundled Loop
• Unbundled Switch
• Resale
• Interim Number Portability
• Line Sharing
• Unbundled Network Elements Platform (UNE P)/ Qwest Platform Plus™ (QPP™)

Loss and Completion reports are generated on a daily positive basis, whether there is data to report or not. This prevents any question as to whether or not a file was made available on succeeding days. Exceptions to this include service orders that do not meet required report edits. These orders are manually corrected so that they may subsequently appear on the reports.

The Loss and Completion reports can be transmitted in five different ways. The transmission method is chosen when completing the New Customer Questionnaire with your Service Manager. A technical review will be conducted after the questionnaire has been completed to discuss these options. The review is held with a representative of the IT-Wholesale Systems Implementation and Deployment Group (WS/I&D) who can assist you with any technical questions about the Loss Report. A User Guide can be provided by the WS/I&D Client Representative.

The available transmission methods are:

NDM (dedicated circuit)

NDM (Network Data Mover) is a mainframe product that is used to transport a data file from one point to another. Connect Direct (dedicated) NDM uses transport circuitry from a secure node at a Qwest site to a secure node at your site, with security built into the transport mechanism.

Receipt of the Loss Report via NDM requires a dedicated circuit between your location and Qwest. The process for installing the circuit is handled by the WS/I&D Client Representative. Connect Direct software (can be purchased from Sterling Commerce - 800-311-9775; www.sterlingcommerce.com) is required to make this connection. Since this is a computer to computer transfer of information, an IP address that indicates the location of our NDM node, is provided to you. You provide your IP address to Qwest for gateway (firewall) access. A RACF Functional ID is also required and is provided to you by the WS/I&D Client Representative (takes about 4 days to establish).

Establishment of the dedicated circuit takes from 30 to 45 days.

The Loss and Completion reports are available in two formats:

• Flat File - This option gives you the Loss data in a report with headings and columns. It might be appropriate for large volumes of data that you can mechanically parse for use in your particular system.
• Report Layout - This option gives you the Loss data in a format that is similar to the ASCII format. It might be more useful for smaller volumes of data that will be handled manually.

NDM (dial up)

NDM (Network Data Mover) is a mainframe product that is used to transport a data file from one point to another. PC pick-up NDM transports from a secure Qwest site node to your secure node at the Qwest site. You can then pick up the data via secure ID dialup access. In order to receive the Completion Report via NDM dial-up, you will need a SecurID with Connect Direct Software (can be purchased from Sterling Commerce - 800-311-9775; www.sterlingcommerce.com) and a RACF Functional ID. The secure ID is provided by Qwest and allows you to access the records via modem. Since this is a computer to computer transfer of information, Connect Direct software is required to make this connection. A RACF Functional ID is also provided by the WS/I&D Client Representative.

The Loss and Completion reports are available in two formats:

• Flat File - This option gives you the Loss data in a report with headings and columns. It might be appropriate for large volumes of data that you can mechanically parse for use in your particular system.
• Report Layout - This option gives you the Loss data in a format that is similar to the ASCII format. It might be more useful for smaller volumes of data that will be handled manually.

Set up takes approximately 4 weeks.

FTP (dedicated circuit)

In order to receive the Loss Report via FTP (File Transfer Protocol), a dedicated circuit between your location and Qwest is required. The process for installing the circuit is handled by the WS/I&D Client Representative. Since this is a computer to computer transfer of information an IP address, which indicates the location of our NDM node, is provided to you. You will provide Qwest with your IP address for gateway (firewall) access. A RACF Functional ID is also required and is provided by the WS/I&D Client Representative.

The Loss and Completion reports are available in two formats:

• Flat File - This option gives you the Loss data in a report with headings and columns. It might be appropriate for large volumes of data that you can mechanically parse for use in your particular system.
• Report Layout - This option gives you the Loss data in a format that is similar to the ASCII format. It might be more useful for smaller volumes of data that will be handled manually.

Establishment of the dedicated circuit takes 6 to 8 weeks.

Web Access

An Internet connection and browser is needed to access the Qwest Protected Internet Delivery (QPID) which provides a secure communications mechanism for applications and data transfer on internal and external networks. Most users will be connected to an internal network that has a point of presence (POP) to the Internet that provides for online speeds of T1 or better and they will be using a Windows 95/98/2000/NT machine with either Netscape or Internet Explorer. In order to receive the Loss Report via the Web, you will need a VeriSign (digital) certificate which register's your PC and allows you access to the records. The digital certificate can be downloaded from the web at http://ecom.qwest.com. The digital certificate, provided by Qwest, requires a User ID and Password. This ID and password will be assigned to you by the WS/I&D Client Representative.

The Web User Guide, which details the procedures for obtaining the digital certificate and for accessing the usage report on the web, will be sent to you by the WS/I&D Client Representative.

The Loss and Completion reports are available in two formats:

• Flat File - This option gives you the Loss data in a report with headings and columns. It might be appropriate for large volumes of data that you can mechanically parse for use in your particular system.
• Report Layout - This option gives you the Loss data in a format that is similar to the ASCII format. It might be more useful for smaller volumes of data that will be handled manually.

Establishment of Web access takes approximately four weeks.

Electronic Fax

Receipt of the Loss and Completion reports by fax requires that you provide your fax number to Qwest. The reports are only provided in the Report Layout format which appears with columns and headings.

If you receive your report via the web, you will be able to access your report after initial distribution. Reports will be retained on the web for access and downloading for 30 days from the date the report is posted. However, once the Loss or Completion data has been retrieved, it cannot be downloaded again. In order to have the data retransmitted, a request must be made by calling the IT-Wholesale Systems Help Desk at 1-888-796-9102.

Completion Report
The Completion Report is sent to you when a service order is completed or cancelled in the Service Order Processing (SOP) system, impacting you. The order has been provisioned, but has not necessarily posted to the billing system. The Completion Report is generated for all order types that carry your identifying RSID and ZCID.

Note 1: Cancelled orders are distinguished by a CAN, CANC or CANP suffix to the service order number. For canceled orders in the Eastern region, the Completion Date field will reflect the current Due Date. In the Western and Central regions, the Completion Date field is populated with zeros. A cancelled order means that the provisioning work has been stopped and the order will never post to billing.

The completion date on the Completion Report is solely an informational notification which represents the date that the service order was completed. It may not reflect when the billing stopped. Dates will vary when an Effective Billing Date (EBD) is applied to the service order. EBD is used when the completion date is different than the effective billing date.

It is your responsibility to review your summary bill to determine the actual date Qwest stopped billing on a specific number.

Note 2: A Record Correction order may appear on the report. It will be identified with a RECCOR as the Purchase Order Number (PON). This is used to identify an order that was issued by Qwest to change information on the Customer Service Record. It can be a billing only order, or a provisioning order. It will depend on the situation. These types of orders take investigation to find why the order was issued.

Completion Reports are not available for LNP Services.

If you receive your report via the web, you will be able to access your report after initial distribution. Reports will be retained on the web for access and downloading for 30 days from the date the report is posted.

The record layout for the fixed file format of the Completion Report is as follows:

Header Record	Start Position	Characters	Description
Header Indicator	1	3	HDR=header record indicator
Dataset Name	4	15	Dataset name including RSID/ZCID code
CLEC Name	19	40	Name of CLEC translated from code
Create Date	59	8	mmddyyyy (year 2000 format)
Create Time	66	8	hhmmssss
Reserve	75	134	For Future Use
Proprietary	Start Position	Characters	Description
1st Proprietary Line	1	67	Statement - "This document is proprietary and confidential to the company named,"
CLEC Name	68	38	Translated RSID/ZCID to Co-Provider name
2nd Proprietary Line	106	91	Statement - "Distribution of this information is restricted to personnel designated by said company."
Reserve	197	12	Space Filler
Detail Record	Start Position	Characters	Description
RSID	1	3	CLECs RSID/ZCID code
TN or CKT Id	4	10	Telephone number or Circuit ID
Cus Code	14	3	Customer Code for account
Reserve	17	2	For Future Use
Order Type	19	1	Type of Order Completed
Order Number	20	8	Identifying order number
Order Suffix	28	11	Order Suffix information
Listed Name	39	35	Name in LIST section of account
Service Address	74	35	Service address (list addr if not present)
Location	109	35	Service address location (if present)
Completion Date	144	8	mmddyyyy (year 2000 format) See Note 1 above
Sales Code	152	10	Sales Code of Order Writing Rep
Purchase Order Number	162	30	CLECs Purchase Order Number Report will display "TIC" as the prefix on Qwest TIC orders e.g., TICXXXXXXXXXX Report will display "RECCOR" as the PON for Qwest Record Correction Orders. Qwest "Winback" orders will display "000015137896" or "Winback" as the PON.
Working TN or CKT Id	192	10	Working Telephone Number or Circuit ID
Working TN TER or DID	202	4	TER of Working TN or Circuit ID DID of Working TN
Reserve	206	3	For Future Use
Trailer Record	Start Position	Characters	Description
Trailer Indicator	1	3	TRL=Trailer Indicator
Detail Record Count	4	6	Total count of detail records
RSID of File	10	3	RSID/ZCID Code or ALL
Reserve	17	192	For Future Use

The following is an example of a faxed Completion Report when there are completions to report:

The following is an example of a faxed Completion Report when there are no completions to report:

Loss Report

The Loss Report indicates any change in your customer’s service that results in a loss to you (i.e., the customer changes service providers or disconnects a line). This information is included for each interconnect product that you provide. The file is sorted in NPA-telephone order.

The Loss Report is sent to you when a service order, that shows outward line activity, is completed or cancelled and impacts you. This can be accomplished on a D=Disconnect, C=Change or R=Record Order.

Note 1: Cancelled orders are distinguished by a CAN, CANC or CANP suffix to the service order number. For canceled orders in the Eastern region, the Completion Date field will reflect the current Due Date. In the Western and Central regions, the Completion Date field is populated with zeros. A cancelled order means that the provisioning work has been stopped and the order will never post to billing.

The completion date on the Loss Report is solely an informational notification which represents the date that the service order was completed. It may not reflect when the billing stopped. Dates will vary when an Effective Billing Date (EBD) is applied to the service order. EBD is used when the completion date is different than the effective billing date.

It is your responsibility to review your summary bill to determine the actual date Qwest stopped billing on a specific number.

Note 2: A Record Correction order may appear on the report. It will be identified with a RECCOR as the Purchase Order Number (PON). This is used to identify an order that was issued by Qwest to change information on the Customer Service Record. It can be a billing only order, or a provisioning order. It will depend on the situation. These types of orders take investigation to find why the order was issued.

Note 3: The report will exclude any activity requested by you. It will only be reporting a loss of a customer to another service provider that has not called you to disconnect their service. This does include possible losses as well since the report includes Cancelled Orders.

Loss Reports are not available for LNP Line Splitting and Loop Splitting Services.

If you receive your report via the web, you will be able to access your report after initial distribution. Reports will be retained on the web for access and downloading for 30 days from the date the report is posted.

To allow for you to identify lines lost to other providers, a loss type indicator is on the Loss Report. The indicator is as follows:

• E= External – identifies a line lost to another provider

The record layout for the fixed file format of the Loss Report is as follows:

Header Record	Start Position	Characters	Description
Header Indicator	1	3	HDR=header record indicator
Dataset Name	4	15	Dataset name including RSID/ZCID code
CLEC Name	19	40	Name of CLEC translated from code
Create Date	59	8	mmddyyyy (year 2000 format)
Create Time	66	8	hhmmssss
Reserve	75	134	For Future Use
Proprietary	Start Position	Characters	Description
1st Proprietary Line	1	67	Statement - "This document is proprietary and confidential to the company named"
CLEC Name	68	38	Translated RSID/ZCID to CLEC name
2nd Proprietary Line	106	91	Statement - "Distribution of this information is restricted to personnel designated by said company."
Reserve	197	12	Space Filler
Detail Record	Start Position	Characters	Description
RSID	1	3	CLECs RSID/ZCID code
TN or CKT Id	4	10	Telephone number or Circuit ID
Cus Code	14	3	Customer Code for account
External Indicator	17	1	Loss Report only E=External Loss
Order Type	19	1	Type of Order Completed
Order Number	20	8	Identifying order number
Order Suffix	28	11	Order Suffix information
Listed Name	39	35	Name in LIST section of account
Service Address	74	35	Service address(list addr if not present)
Location	109	35	Service address location (if present)
Completion Date	144	8	mmddyyyy (year 2000 format) See Note 1 above
Sales Code	152	10	Sales Code of Order Writing Rep
Purchase Order Number	162	30	Co-Provider's Purchase Order Number Report will display "RECCOR" as the PON for Qwest Record Correction Orders. Qwest "Winback" orders will display "000015137896" or "Winback" as the PON.
Working TN or CKT Id	192	10	Working Telephone Number or Circuit ID
Working TN TER	202	4	TER of Working TN or Circuit ID
Reserve	206	3	For Future Use
Trailer Record	Start Position	Characters	Description
Trailer Indicator	1	3	TRL=Trailer Indicator
Detail Record Count	4	6	Total count of detail records
RSID of File	10	3	RSID/ZCID Code or ALL *
Reserve	17	192	For Future Use

The following is an example of a faxed Loss Report when there are losses to report:

The following is an example of a faxed Loss Report when there are no losses to report:

Implementation

Ordering

Completion Report/Loss Report
You must supply the following information on the New Customer Questionnaire to receive both the Completion Report and the Loss Report:

• Contact
• Name
• Telephone Number
• Mailing Name
• Street Address
• City, State, Zip
  
  
• Type(s) of Service(s)
• Resale
• Unbundled Switch
• Line Sharing
• Commercial local exchange services products, e.g. Qwest Local Service Platform™ (QLSP™)
• Unbundled Loop



• Transfer Options
• Report Layout Format (Yes or No)
• Flat File Format (Yes or No)
• Network Data Mover (NDM) (Dedicated Circuit)
• WEB
• Dedicated Circuit ID
• Transmission Path/Nodes
  
  
• Fax:
• Fax Number
• Attention
  
  
• Data Set Name (DSN)/Remote ID
• NDM, One each service comma delimitated
• Technical Contact and Telephone Number

Training

Local Qwest 101 "Doing Business With Qwest"

• This introductory web-based training course is designed to teach the Local CLEC and Local Reseller how to do business with Qwest. It will provide a general overview of products and services, Qwest billing and support systems, processes for submitting service requests, reports, and web resource access information. Click here to learn more about this course and to register.

Click here for more detail and registration information.

View additional Qwest courses by clicking on Course Catalog.

Contacts

Qwest contact information is located in Wholesale Customer Contacts.

For additional information contact your Qwest Service Manager.

Frequently Asked Questions (FAQs)

1. What information does the Completion Report contain?
The Completion Report contains information when a service order is completed or cancelled at Qwest.

2. Does receipt of the Completion Report mean that the RSID should be displayed in the CSR?
A Completion Report means that the order has been provisioned. The CSR may not indicate an RSID for a short time after provisioning. After 21 days if the CSR still does not indicate a resold account, call the Interconnect Service Center and inquire about the status of the order.

3. What information does the Loss Report contain?
The Loss Report shows outward activity when a service order is completed or cancelled. The Loss Report will display indicators that allow you to distinguish lines lost to other providers from lines lost for other reasons.

4. When does Qwest require a local node for NDM Access?
Qwest needs to have you provide your local node in order to receive reports via NDM.

Last Update: January 4, 2008

Qwest Platform Plus™ and QPP™ are trademarks of Qwest Communications International Inc.