Table Of Contents

Split Numbering Plan Area Provisioning

Split Numbering Plan Area Provisioning

---

Revised: July 24, 2009, OL-3743-42

The Split Numbering Plan Area (split-npa) table is used when the Call Agent is affected by a split Numbering Plan Area (NPA). A split-NPA occurs when an NXX of NPA-NXX moves from one NPA to another. In the following example, all directory numbers (DNs) under 214-671 move to the new NPA:

old nxx = 214-671

new nxx = 972-671 

---

Note In this chapter, an asterisk preceding a token name means the token is mandatory. A token without an asterisk is optional.

---

Table Name: SPLIT-NPA

Table Containment Area: Call Agent

Command Types

Show, add, change, and delete

Examples

show split-npa old-npa=214;

add split-npa old-npa=214-671; new-npa=972-671; start-date=2003-08-01; 
end-date=2004-01-31;

change split-npa old-npa=214-671; dup-records=y;

delete split-npa old-npa=214-671; 

Usage Guidelines

Primary Key Token(s): old-npa

Unique Key Token(s): new-npa

Add Rules:

•start-date is before end-date.

•old(nxx) = new(nxx).

Change Rules:

•start-date is before end-date.

•if update-ani and start-date £ today's date £ end-date.

•if cleanup, end-date must be less than or equal to today's date.

Delete Rules: None.

Syntax Description

* OLD-NPA	Primary key. Old NPA before split. VARCHAR(6): 1-6 ASCII characters in the format NPA-NXX.
* NEW-NPA	Unique key. New NPA after split. VARCHAR(6): 1-6 ASCII characters in the format NPA-NXX.
* START-DATE	Start date of the permissive dialing period. DATE: in the format yyyy-mm-dd, where: yyyy—year mm—01 to 12 (month) dd—01 to 31 (day)
* END-DATE	End date of the permissive dialing period. DATE: in the format yyyy-mm-dd, where: yyyy—year mm—01 to 12 (month) dd—01 to 31 (day)
AUTO-REFRESH	Specifies whether to display cached data on the screen. Valid only for the show command. CHAR(1): Y/N (Default = Y). Y—Queries the database for the most current data. N—Queries the database for the most current data only if the cached data is unavailable.
DISPLAY	Specifies what token information to display on the screen. Valid only for the show command. VARCHAR(1024): 1-1024 (Default = all tokens are displayed). Permitted values are any valid token that can be shown for this command. Multiple tokens can be entered by separating with a comma.
LIMIT	Specifies the number of rows to display on the screen. Valid only for the show command. INTEGER: 1-100000000 (Default = 100000000). Note The actual maximum number of rows displayed is currently lower than 100000000 due to software limitations.
ORDER	Specifies whether to display data on the screen in a sorted order. Valid only for the show command. VARCHAR(1024): 1-1024 (Default = all rows are displayed). Permitted values are any valid token that can be shown for this command. Multiple tokens can be entered by separating with a comma.
START-ROW	Specifies to begin displaying data on the screen at a specific row. Valid only for the show command. INTEGER: 1-100000000 (Default = 1).
DUP-RECORDS (EMS-only token)	Duplicate records. When set, dial-plan, office-code, ported-office-code tables are updated with the new NPA-NXX. CHAR(1): Y/N (Default = N).
DUP-RECORDS- STATUS (EMS-only token) (System generated)	Used internally by the EMS to keep track of the record duplication status. When a split-npa record is provisioned, the dup-records-status is initialized to pending. VARCHAR(11): 1-11 ASCII characters. Permitted values are: Pending (Default)—Records duplication pending. In-progress—Records duplication in progress. Completed—Records duplication completed.
UPDATE-ANI (EMS-only token)	Update automatic number identification (ANI) records. When set, subscriber directory numbers (DNs) are updated to the new NPA in the subscriber record. CHAR(1): Y/N (Default = N).
UPDATE-ANI- STATUS (EMS-only token) (System generated)	Used internally by EMS to keep track of the ANI update status. When a split-npa record is provisioned, the update-ani-status is initialized to pending. VARCHAR(11): 1-11 ASCII characters. Permitted values are: Pending (Default)—ANI update pending. In-progress—ANI update in progress. Completed—ANI update completed.
CLEANUP (EMS-only token)	Cleanup. When set, records pointing to the old NPA are removed. CHAR(1): Y/N (Default = N).
CLEANUP-status (EMS-only token) (System generated)	Used internally by EMS to keep track of the cleanup status. When a split-npa record is provisioned, the cleanup-status is initialized to pending. VARCHAR(11): 1-11 ASCII characters. Permitted values are: Pending (Default)—Cleanup pending. In-progress—Cleanup in progress. Completed—Cleanup completed.