The Local Calling Area Database (LCAD) can be used to quickly identify the jurisdictional relationship between any originating NPA NXX and terminating NPA NXX call combination. These relationships include determining whether the call is local, intraLATA, interLATA, intraStateintrastate, interStateinterstate, and for wireless to wireless or wireless to landline, whether the call is intraMTA or interMTA.
Compiled from current carrier sources, the NALENND® Local Calling Area Database The LCAD contains local calling area information to identify the basic and expanded local calling areas for telephone exchanges in the United States and Canada based on incumbent wireline carriers' calling area definitions. They can be used as an aid in calling plan design, traffic and least cost routing, or similar application that needs to distinguish between local and toll calls..
LCAD Local Cross Reference Table
NPA | NXX | BLOCK_ID | EXCHANGE |
201 | 200 | A | 34125730 |
201 | 202 | A | 34125580 |
201 | 203 | A | 34125580 |
201 | 203 | 0 | 34125580 |
201 | 203 | 1 | 34125580 |
201 | 203 | 2 | 34125580 |
201 | 203 | 3 | 34125580 |
201 | 203 | 4 | 34125580 |
201 | 203 | 5 | 34125580 |
201 | 203 | 6 | 34125580 |
201 | 203 | 7 | 34125580 |
201 | 203 | 8 | 34125580 |
201 | 203 | 9 | 34125580 |
… | … | … | … |
NPA - Numbering Plan Area (NPA) Code. An NPA, also known as a telephone area code, is the first three digits of a 10-digit North American Numbering Plan (NANP) telephone number in the form NXX-NXX-XXXX, where N represents any one of the numbers 2 through 9 and X represents any one of the numbers 0 through 9. Valid numeric range for NPA codes is 200 through 999.
NXX - Central Office Code (COC). The COC, commonly called the telephone exchange or prefix, is the second three digits (NXX) of a 10-digit NANP telephone number in the form NXX-NXX-XXXX, where N represents any one of the numbers 2 through 9 and X represents any one of the numbers 0 through 9. Valid numeric range for NXX codes is 200 through 999.
BLOCK_ID - Block identifier. Implies, represents, or identifies either the entire group of 10,000 numbers or a specific group of 1,000 numbers within the NPA NXX. An “A” record will be present for NPA NXX records that are “assigned” to the Code Holder per the Central Office Code Assignment Guidelines. For non-pooled numbers it identifies a 10,000-block level record and implies line assignments 0000 through 9999. For pooled numbers the “A” record is present for default routing purposes and identifies the LERG Assignee, numeric blocks must be referenced for actual carrier assignments. A numeric block (digits “0” through “9”) refers to those assignments made per Thousands Block Pooling Administrative Guidelines, it identifies a 1,000-block level record and refers to line assignments x000 through x999 where x=the block identifier.
EXCHANGE - Unique exchange index used to identify the NPA-NXX-BLOCK_ID combination.
LCAD Local Table
ORC_EXCHANGE | ORC_STATE | ORC_ABBR | ORC_LATA | ORC_MTA | TRC_EXCHANGE | TRC_STATE | TRC_ABBR | TRC_LATA | TRC_MTA | OCN | CALL_TYPE | RATE_STEP |
34124850 | NJ | ALLENTOWN | 222 | 1 | 34124850 | NJ | ALLENTOWN | 222 | 1 | 9206 | LCA | 1 |
34124850 | NJ | ALLENTOWN | 222 | 1 | 34125670 | NJ | HIGHTSTOWN | 222 | 9 | 9206 | EAS | 1 |
34124850 | NJ | ALLENTOWN | 222 | 1 | 34125970 | NJ | MERCERVL | 222 | 9 | 9206 | EAS | 1 |
34124850 | NJ | ALLENTOWN | 222 | 1 | 34126170 | NJ | NEW EGYPT | 222 | 1 | 9206 | EAS | 1 |
34124860 | NJ | ANDOVER | 224 | 1 | 34124860 | NJ | ANDOVER | 224 | 1 | 138 | LCA | 1 |
34124860 | NJ | ANDOVER | 224 | 1 | 34125770 | NJ | LAKEMOHAWK | 224 | 1 | 138 | EAS | 1 |
34124860 | NJ | ANDOVER | 224 | 1 | 34126200 | NJ | NEWTON | 224 | 1 | 138 | EAS | 1 |
34124860 | NJ | ANDOVER | 224 | 1 | 34126150 | NJ | NETCONG | 224 | 1 | 9206 | EAS | 1 |
34124860 | NJ | ANDOVER | 224 | 1 | 34125590 | NJ | HACKETTSTN | 224 | 1 | 9206 | EAS | 1 |
34124860 | NJ | ANDOVER | 224 | 1 | 34125080 | NJ | BRANCHVL | 224 | 1 | 138 | EAS | 1 |
… | … | … | … | … | … | … | … | … | … | … | … | … |
ORC_EXCHANGE - Unique originating exchange index within the Rate Center.
ORC_STATE - Originating Rate Center state, province, or territory abbreviation.
ORC_ABBR - Originating Rate Center standardized 10-character LERG abbreviation.
ORC_LATA - Originating Rate Center LATA number.
ORC_MTA - Originating Rate Center MTA number.
TRC_EXCHANGE - Unique terminating exchange index within the Rate Center.
TRC_STATE - Terminating Rate Center state, province, or territory abbreviation.
TRC_ABBR - Terminating Rate Center standardized 10-character LERG abbreviation.
TRC_LATA - Terminating Rate Center LATA number.
TRC_MTA - Terminating Rate Center MTA number.
OCN - When populated identifies the competitive local carrier who’s local calling area differs from the incumbent local exchange carrier.
CALL_TYPE - This free form field identifies terminating exchanges as local or expanded local in relationship to the originating Rate Center.
Possible values include:
LCA - Local Calling Area
EAS - Extended Area Service
ESA - Extended Service Area
EACS - Extended Area Calling Service
MELCS - Metropolitan Exchange Local Calling Service
ELC - Expanded Toll-Free Local Calling Service
HRC - Home Region Calling
Measured - Measured service
ECS - Extended Calling Service
ZUM1 - Zone Usage Measurement Zone 1
ZUM2 - Zone Usage Measurement Zone 2
ZUM3 - Zone Usage Measurement Zone 3
RATE_STEP - Rate Step Indicator. Identifies mileage based distance between originating and terminating exchanges within the local service area.
(1) 0-12 miles
(2) 13-16 miles
(3) 17-22 miles
(4) 23-30 miles
(5) 31-40 miles
(6) Greater than 40 miles