Local Call

The Peeredge Orchestrator uses a three-step process to determine if a call (a SIP Invite received on a Termination Customer Trunk Group) is a local call.

Step 1. The LERG table is queried to determine if the NPANXXY for the ANI and DNIS are both in the LERG table. A successful query returns the company, ocn, lata, ratecenter and prefix_type. Specific to local call determination, these values are irrelevant, just the fact the LERG queries return a result is sufficient to move to Step 2. If either query fails to return a result than it is not a local call and the LCAD is not queried.

Example: ANI = +19139545738 NPA = 913, NXX = 954, Y=5

SELECT lerg.state, Lerg.company, Lerg.ocn, Lerg.lata, Lerg.ratecenter, Lerg.prefix_type FROM shared.lerg WHERE NPA='913' AND NXX='954' AND (Thousands='5' OR Thousands='') ORDER BY Thousands DESC LIMIT 1;

Query Results:

Example: DNIS = +19133154925 NPA = 913, NXX = 315, Y=4

SELECT lerg.state, Lerg.company, Lerg.ocn, Lerg.lata, Lerg.ratecenter, Lerg.prefix_type FROM shared.lerg WHERE NPA='913' AND NXX='315' AND (Thousands='4' OR Thousands='') ORDER BY Thousands DESC LIMIT 1;

Query Results:

Step 2. The Local Calling Area Database (LCAD) XREF Table is queried using the same NPANXXY as in Step 1 to identify which Exchange the NPANXXY is assigned to. Both queries must return a result (i.e. the Exchange the NPANXXY is assigned to) to move to Step 3.

Example: SELECT EXCHANGE FROM shared.local_xref WHERE NPA='913' AND NXX='954' AND (BLOCK_ID='5' OR BLOCK_ID='A') ORDER BY BLOCK_ID ASC LIMIT 1;

Query Results:

Example: SELECT EXCHANGE FROM shared.local_xref WHERE NPA='913' AND NXX='315' AND (BLOCK_ID='4' OR BLOCK_ID='A') ORDER BY BLOCK_ID ASC LIMIT 1;

Query Results:

Step 3. The LCAD Local Table is queried with the exchanges from Step 2. The ANI Exchange is Originating Ratecenter Exchange (ORC_EXCHANGE) and the DNIS Exchange is the Terminating Ratecenter Exhange (TRC_EXCHANGE). If the query returns data then the call is a local call otherwise it is a long-distance call.

Example: SELECT CALL_TYPE FROM shared.local WHERE (ORC_EXCHANGE='20064370' AND TRC_EXCHANGE='20064370');

Query Results:

Since the query returned a value this would be a local call.