E911 Provisioning

1
E911 Provisioning

• Presented By
• Pramodh Vakati.
• Mentor Reddy Parlapalli.
• Company Telnet World Wide Inc.

2
Overview

• Introduction
• Existing System
• Purpose of the Project
• Software's used
• Flow chart
• Main modules of the Project
• Implementation of the system
• Design of Tables
• Conclusion

3
Introduction

• 911 Provisioning
• E911 Provisioning

4
Existing System

• Customers enter data into Telnet Site
• Customer Sales Representatives (CSR) enter these
  customer data into SBC(ATT) site.
• SBC then send the status of the files.
• Depending on status of the file further
  processing is done.

5
Disadvantages of the Existing System

• Much Human intervention is needed
• CSRs time is wasted
• Errors occurred due to manual entry
• More Processing time for an order is required.

6
Purpose of E911 Provisioning

• Automates the process of sending customers data
  from Telnet to SBC
• Can Reduce Manual intervention in sending
  customers data
• Can Reduce the time required for processing an
  order

7
Softwares Used

• Microsoft Visual Studio.NET 2003 Enterprise
  Edition
• Microsoft SQL Server 2000
• ASP.Net

8
Flow Chart
9
Main modules of the Project

• Extract Data From Compass
• This step involves exporting the E911 data
  
• in Compass to a file format that SBC
  desires.
• Submit Data to SBC
• This step involves sending the file
• generated in the earlier step to SBC.
• Receive Data from SBC
• Every file sent to SBC is processed and a
• new status file is sent back to
  Compass. The
• third step validates the data
  received from
• SBC and updates the status of
  information in
• Compass.

10
Implementation of the system

• Add/Change/Disconnect E911 Records.
• Confirm the Records.
• Check the Status of the Records.
• Manage the Rejected Records.

11
Add E911 Records.

• In the E911 Ordering Page there are two sections
  of phone numbers. The first section shows the
  phone numbers (E911 Records) for this order and
  the second section shows the unassigned phone
  numbers. The first time an order is placed all
  the phone numbers will be in the unassigned
  section and they will be gradually pushed into
  the E911 entries section.

12

• In order to add a single phone number as an E911
  Record into Compass the user can click the Add
  Button beside the phone number in the unassigned
  section. Once the phone number is added the
  Record will be shown in the E911 entries section
  with a status of Pending.
• In order to add multiple phone numbers select
  them by clicking the check boxes beside them and
  click the Add Button in the Header of the Data
  Grid.

13
(No Transcript)
14
Change E911 Records

• The Record that needs to be changed should be in
  the E911 entries section.
• Click the Edit button in the Data Grid. After
  making the changes click the update button. This
  will update the status of the Record to Pending

15
Disconnect E911 Records

• If the user wishes to exclusively remove the E911
  Record from an order Click the Delete Button and
  a disconnect Record is sent to SBC and the status
  is updated to Pending and the phone number is
  added to the available phone numbers bucket.

16

• In the Status Dropdown List select Pending and
  click the Go Button to see the list of E911
  Records which are Pending and are ready to be
  sent.
• If the above three steps(Add/Edit/Delete) have
  been carried successfully then the Record should
  be appearing in the Pending List of Records.
• If the Record appears in the list, it remains in
  the Pending status until the ISD is set. The
  column ISD should give an indication whether the
  order is closed or not.
• Once the ISD is set the Record will be sent
  within the same business day to SBC and the
  status of the Record will change to Submitted.
  The Sent Date (SDate) will be filled.

17
(No Transcript)
18
(No Transcript)
19
Check the Status of the Record

• The next business day (the day after the Record
  is sent) check the status of the Record Sent.
• If the status of the Record is Accepted then the
  process is successful.

20
(No Transcript)
21
Manage the Rejected Record

• A Record could be rejected for multiple reasons.
  The reason for rejection and the Error Code is
  specified in the Message column of the Data Grid.
• If the rejected Record was either add/change then
  click the phone number in the Data Grid and it
  will launch the E911 Ordering page.
• If the Error Code is 792 it means that the phone
  number is not yet released by the previous
  company and within 7 days SBC will update the
  status accordingly.

22
(No Transcript)
23
Error Codes Description

• Below are the some of error codes that are used
  to indicate the reason for which a particular
  order got rejected.
• 000 Record accepted
• 105 Name missing
• 107 House number is invalid
• 709 Street not found
• 999 Record has not been sent

24
Design of Database
25
Order_PhoneNumber_E911 Table Design
26
Order_PhoneNumber_E911_Cycle Table Design
27
Order_PhoneNumber_E911_ErrorCodes Table Design
28
ORDER_PHONENUMBER-E911 E911 ID - Unique key
which stores E911 number for a particular
order PID Phone ID FIRST NAME -
first name LASTNAME - last name ADRESS -
Address CITY - city ZIP
- zip code OIDSTART - Order Start
Date OIDEND - Order End Date RBOC
Field which denotes wire line
providers i.e. either SBC or Verizon.
ERRORCODE - can stores the error code
values. STATUS can store one of
the four values Accepted , Submitted,
Pending and Rejected LDATE -
Loaded Date SDATE- Submitted
Date ADATE Accepted Date
29
ORDER_PHONENUMBER-E911_CYCLE ID
- Cycle number CYCLE_SBC - stores
1 if cycle belongs to SBC else stores
0 CYCLE_VERIZON stores 1 if cycle belongs to
Verizon else
stores 0
30
ORDER_PHONENUMBER-E911_ERROR ID
Error Id ERROR CODE error code MESSAGE
Message corresponding to the error
code.
31
Conclusion

• In today's world productivity can be achieved
  from automation. Every task has to be done
  easily and effectively. Manual Intervention has
  to be reduced as much as possible.
• I have done E911 provisioning which automates
  sending customer data to SBC site. This
  automation of process saves lot of customers
  sales representatives time.

32

• Thank You