[TELECOM] Do rate centers cross state lines? Excluding portability, do unique NPA/NXX combinations cross state or county boundaries?

Jul 28, 2010 5 Replies

Do rate centers cross state lines?



Excluding portability, do wired (not wireless) unique NPA/NXX combinations cross state or county boundaries?


Why? I'm working on a couple of databases used to send the right tech to the right location based on the callers NPA/NXX and zipcode, but if the NPA/NXX combo is used in other zipcodes besides the one the tech services, I have flag the call as going to the other tech. If NPA/NXX combinations do not cross state lines (or perhaps even county lines) it makes my coding alot easier. If NPA/NXX combos do cross state lines I have to compare the source data to 3.5 plus million possible combinations of NPA,NXX, and zipcodes.



Thanks Steve



73 de N2UBP

Portability still uses the original rate center as far as I know. Same with wireless. The # assigned has a specified ratecenter which is used to compute ld charges for wireline customers.

NPA/ratecenter:

select npa, ratecenter, count(state) from (select distinct npa, ratecenter, state from npa_nxx_company_ocn) as s group by npa, ratecenter having count(state) > 1;

npa | ratecenter | count

-----+------------+------- (0 rows)

My database shows that there are no cases of a npa/ratecenter that crosses state lines.

NPA only:

select npa, count(state) from (select distinct npa, state from npa_nxx_company_ocn) as s group by npa having count(state) > 1;

npa | count

-----+------- (0 rows)

No NPA crosses state lines either.

Thats what a database is for. Mine is kinda small (164,900 entries) 'cause it has only resolution to the lata at the NPA/NXX level. I suppose if I loaded a lata->zip table it would expand out to 3.5M.

My database doesn't have county so I can't verify that though a zip->county table (or lata->counties if it existed) could also handle that.

Thanks

I'm not sure if this helps but I seem to remember that in some rural border areas between Massachusetts and Rhode Island there were Rhode Island houses being assigned Massachusetts area codes and numbers due to their distance from Rhode Island phone exchanges.

You might need to contact the public service people who service those two states and see if they still have this or no longer do it.

Rate centers certainly cross county lines. My rate center Trumansburg NY (see prefix 607-387) covers parts of three different counties.

There certainly used to be rural places where a telco in one state picked up a few customers in another state, but I don't know if they still do that. Just to deal with the regulators it'd be a lot easier for the telcos to make them different rate centers, even if they're still wired from the other state.

R's, John

As others answered, rate centers certainly cross county boundaries and are NOT correlated with municipalities, postal names, nor zip codes.

As to assigning a worker based on a caller's NPA/NXX, keep in mind that callers for service work often are not calling from the location where service is desired. First, many people use their cellphone which may be assigned to a distant rate center. Secondly, many people call from their job location to request service work at their home.

Thanks to everyone for the great information.

The NPA/NXX data from ANI is being used to send service requests to sub groups of dispatchers. The dispatchers then send a trouble ticket to the tech who covers the customers specific area. They are using ANI to route calls to different dispatching groups.

Steve

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required