Difference between revisions of "M4 Local Number Portability"

From Kolmisoft Wiki
Jump to navigationJump to search
 
(13 intermediate revisions by 2 users not shown)
Line 20: Line 20:


== Selection ==
== Selection ==
OP CallerID is matched against the Routing Number:


# If the first digit does not match then INDETER
# If the first digit does not match then INDETER
# If the first digit matches and the 3 digits after it match, it means INTRA
# If the first digit matches and the 3 digits after it match, it means INTRA
# If the first digit matches and the 3 digits after it do not match, means INTER
# If the first digit matches and the 3 digits after it does not match, means INTER




<br><br>
<br><br>
= Work Flow =
= Work Flow =


Line 35: Line 38:
===Example===
===Example===


User dials number 123456789, this is 'callnumber'. The system looks by this number in the DB and let's say finds 'routingnumber': 123999999999. That means the system will match this 'routingnumber' with the inter/intra/indeter tariffs and bills the call accordingly based on the 'routingnumber'.
User dials number 123456789, this is 'callnumber'. The system looks by this number in the DB and let's say finds 'routingnumber': 123999999999. That means the system will match OP CallerID to this 'routingnumber', determines if the call is inter/intra/indeter, and will use the appropriate tariff to bill the call.


More information about Jurisdictional routing can be found in this [https://transnexus.com/whitepapers/jurisdictional-routing whitepaper].
More information about Jurisdictional routing can be found in this [https://transnexus.com/whitepapers/jurisdictional-routing whitepaper].




== Workflow ==
== Setup Step by step ==
 
To set up the system to support LNP, take these steps:
 
# Create a Database with a table that has 2 columns: CallerID and Routing Number (column names can be anything you like)
# Setup LNP DB connection in the [https://wiki.kolmisoft.com/index.php/M2-M4_Settings#Local_Number_Portability Configuration]
# Create 3 Tariffs: Inter, Intra, Indeter for TP and 3 for OP (or charge OP one rate, so have 1 Tariff for OP)
# Assign them to your TP (and OP)
# Upload CallNumber(Destination Number) - RoutingNumber data to the DB
# Test
 
<br><br>
== Where to get LNP data (CallNumber-RoutingNumber) ? ==


To setup the system to support LNP, take these steps:
Order it from LNP DB Providers. They will send one big data file, that should be imported to your DB. Later usually each day they will send delta files - small files with daily changes. These files also should be imported to the DB to keep it up-to-date.


1. Create 3 Tariffs: Inter, Intra, Indeter
Example: https://summitsystemsus.com/lrn-dipping-platform/
2. Assign them to your TP (OP is not supported)
3. Create Database with table which has 2 columns: CallerID and Routing Number (column names can be anything you like, setup correctly in the Configuration later)
4. Upload CallerID-RoutingNumber data to the DB
5. Test

Latest revision as of 12:29, 14 September 2022

M4 Local Number Portability allows to connect to Local Number Portability (LNP) database and retrieve information about destination number local portability status (routing number).

LNP DB should be MySQL compatible, required DB fields are described in M4 settings page.

Intra/Inter/Indeter

Jurisdictional routing is telephone call routing logic based upon the locations of the calling and called number and regulatory considerations. Jurisdictional routing can be divided into three main parts:

  • Intrastate routing (Intra) - calls within the same state.
  • Interstate routing (Inter) - calls from one state to the other.
  • Indeterminate routing (Indeter) - calls where origination information cannot be determined (for example, calling number is not a valid number).

Jurisdictional routing is activated (activated means it can be enabled/disabled) once LNP Database is configured in M4 settings page.

Once LNP DB is configured, Jurisdictional routing can be enabled in the Origination Point settings.



Jurisdictional routing m4.png

Here you can select the appropriate Tariff and Routing Group for Intra/Inter/Indeter routes.

Selection

OP CallerID is matched against the Routing Number:

  1. If the first digit does not match then INDETER
  2. If the first digit matches and the 3 digits after it match, it means INTRA
  3. If the first digit matches and the 3 digits after it does not match, means INTER




Work Flow

As you can see in the Configuration

The database should have 2 rows: key and value. In the example, these fields are named 'callnumber' and 'routingnumber'. You can name them as you like.

Example

User dials number 123456789, this is 'callnumber'. The system looks by this number in the DB and let's say finds 'routingnumber': 123999999999. That means the system will match OP CallerID to this 'routingnumber', determines if the call is inter/intra/indeter, and will use the appropriate tariff to bill the call.

More information about Jurisdictional routing can be found in this whitepaper.


Setup Step by step

To set up the system to support LNP, take these steps:

  1. Create a Database with a table that has 2 columns: CallerID and Routing Number (column names can be anything you like)
  2. Setup LNP DB connection in the Configuration
  3. Create 3 Tariffs: Inter, Intra, Indeter for TP and 3 for OP (or charge OP one rate, so have 1 Tariff for OP)
  4. Assign them to your TP (and OP)
  5. Upload CallNumber(Destination Number) - RoutingNumber data to the DB
  6. Test



Where to get LNP data (CallNumber-RoutingNumber) ?

Order it from LNP DB Providers. They will send one big data file, that should be imported to your DB. Later usually each day they will send delta files - small files with daily changes. These files also should be imported to the DB to keep it up-to-date.

Example: https://summitsystemsus.com/lrn-dipping-platform/