LNP Database Tables and Fields

The Query Server database consists of replicated copies of the LSMS LNP database tables listed in Table 1, Table 2, and Table 3.

Note: In the table below, names of regional LNP database tables and fields may be split between lines. This does not imply a space in the name of the table or field.

Table 1. Regional Database Tables and Fields
Regional (<Region>) DB) LNP Database Tables	Fields
SubscriptionVersion	versionID	tn	lrn	newCurrentSp
	classDPC	classSSN	lidbDPC	lidbSSN
	isvmDPC	isvmSSN	cnamDPC	cnamSSN
	wsmscDPC	wsmscSSN	LnpType	billingId
	endUserLocation Value	endUserLocation Type	activation Timestamp	downloadReason
	SVType	alternativeSPID
NumberPoolBlock	blockId	npanxx_x	lrn	newCurrentSP
	classDPC	classSSN	lidbDPC	lidbSSN
	isvmDPC	isvmSSN	cnamDPC	cnamSSN
	wsmscDPC	wsmscSSN	activationTimestamp	downloadReason
	SVType	alternativeSPID
ServiceProvLRN	serviceProviderId	id	lrn	creationTimeStamp
ServiceProvLRN	downloadReason
ServiceProv NPA_NXX	serviceProviderId	id	npanxx	creationTimeStamp
ServiceProv NPA_NXX	effectiveTimeStamp	downloadReason
ServiceProv NPA_NXX_X	serviceProviderId	id	npanxx_x	creationTimeStamp
ServiceProv NPA_NXX_X	effectiveTimeStamp	modifiedTime Stamp	downloadReason
ServiceProvNetwork	serviceProvId	serviceProvName	serviceProvType
Where <Region> is one of the following:	Canada	MidAtlantic	Midwest	Northeast
Where <Region> is one of the following:	Southeast	Southwest	WestCoast	Western

Table 2. Supplemental Database Tables and Fields (Part 1)
Supplemental (supDB) LNP Database Tables	Fields
DefaultGtt	groupName	npanxx	spid
	ain_set	ain_tt	ain_dpc	ain_ssn
	ain_xlat	ain_ri	ain_ngt	ain_rgta
	in_set	in_tt	in_dpc	in_ssn
	in_xlat	in_ri	in_ngt	in_rgta
	class_set	class_tt	class_dpc	class_ssn
	class_xlat	class_ri	class_ngt	class_rgta
	lidb_set	lidb_tt	lidb_dpc	lidb_ssn
	lidb_xlat	lidb_ri	lidb_ngt	lidb_rgta
	isvm_set	isvm_tt	isvm_dpc	isvm_ssn
	isvm_xlat	isvm_ri	isvm_ngt	isvm_rgta
	cnam_set	cnam_tt	cnam_dpc	cnam_ssn
	cnam_xlat	cnam_ri	cnam_ngt	cnam_rgta
	wsmsc_set	wsmsc_tt	wsmsc_dpc	wsmsc_ssn
	wsmsc_xlat	wsmsc_ri	wsmsc_ngt	wsmsc_rgta
OverrideGtt	groupName	lrn	spid
	class_set	class_tt	class_dpc	class_ssn
	class_xlat	class_ri	class_ngt	class_rgta
	lidb_set	lidb_tt	lidb_dpc	lidb_ssn
	lidb_xlat	lidb_ri	lidb_ngt	lidb_rgta
	isvm_set	isvm_tt	isvm_dpc	isvm_ssn
	isvm_xlat	isvm_ri	isvm_ngt	isvm_rgta
	cnam_set	cnam_tt	cnam_dpc	cnam_ssn
	cnam_xlat	cnam_ri	cnam_ngt	cnam_rgta
	wsmsc_set	wsmsc_tt	wsmsc_dpc	wsmsc_ssn
	wsmsc_xlat	wsmsc_ri	wsmsc_ngt	wsmsc_rgta
NpaSplit	oldNpa	newNpa	nxx	startPDP
NpaSplit	endPDP	region	status
LsmsServiceProvider	spid	description	contactInfo

Table 3. Supplemental Database Tables and Fields (Part 2)
Supplemental (supDB) LNP Database Tables	Fields
GttGroup	name	description
	ain_set	ain_tt	ain_dpc	ain_ssn
	ain_xlat	ain_ri	ain_ngt	ain_rgta
	in_set	in_tt	in_dpc	in_ssn
	in_xlat	in_ri	in_ngt	in_rgta
	class_set	class_tt	class_dpc	class_ssn
	class_xlat	class_ri	class_ngt	class_rgta
	lidb_set	lidb_tt	lidb_dpc	lidb_ssn
	lidb_xlat	lidb_ri	lidb_ngt	lidb_rgta
	isvm_set	isvm_tt	isvm_dpc	isvm_ssn
	isvm_xlat	isvm_ri	isvm_ngt	isvm_rgta
	cnam_set	cnam_tt	cnam_dpc	cnam_ssn
	cnam_xlat	cnam_ri	cnam_ngt	cnam_rgta
	wsmsc_set	wsmsc_tt	wsmsc_dpc	wsmsc_ssn
	wsmsc_xlat	wsmsc_ri	wsmsc_ngt	wsmsc_rgta
EmsInterface	clli	emsType	primaryAddress	secondaryAddress
	mateClii	pointCode	matePointCode	capabilityPoint Code
	gttGroup	tnFilter	ownerSpid	componentInfo
	contactInfo	dcmAddress	retryinterval	retryCount
	pingMethod
TnFilter	spid	name	description	filterType
TnFilter	regions	npanxxType	npanxxs
NpacRegion	region	npacSmsName	lsmsPsel	lsmsSsel
	lsmsTsel	lsmsNsap	primaryNpacPsel	primaryNpacSsel
	primaryNpacTsel	primaryNpacNsap	primaryNpac FtpAddress	secondaryNpac Psel
	secondaryNpacSsel	secondaryNpacTsel	secondaryNpac Nsap	secondaryNpac FtpAddress
	active	componentInfo	contactInfo	lastChanged Timestamp
	currentNpac
<Region>Npac Measurements	yyyydddhh	Binds	SuccessOps	FailedOps
<Clii>Eagle Measurements	yyyydddhh
	updTnSuccess	updTnFail	DelTnSuccess	DelTnFail
	updDGttSuccess	updDGttFail	DelDGttSuccess	DelDGttFail
	updOGttSuccess	updOGttFail	DelOGttSuccess	DelOGttFail
	updSplitSuccess	updSplitFail	DelSplitSuccess	DelSplitFail
	Binds	LsmsRetries	NERetries
<Region>PublicKey	id	listId	keyId	status
<Region>PublicKey	exponent	modulus
<Region>PrivateKey	id	listId	keyId	status
<Region>PrivateKey	keyval
LsmsUser	name	golden	groupName	inactivityTimeout
LsmsUserSpid	lsmsUser	spid
Where <Region> is one of the following:	Canada	MidAtlantic	Midwest	Northeast
Where <Region> is one of the following:	Southeast	Southwest	WestCoast	Western
Where <Clii> is the Common Language Location Indicator of the EMS/EAGLE to which that LSMS is connected.

Note: In Table 3, by default, the following Supplemental (SupDB) LNPDatabase Tables are not replicated. To replicate these tables, refer to the Note in Step 1 of the topic, “MySQL Replication Configuration for Query Servers” in Appendix A of the Configuration Guide.

<Region>PublicKey
<Region>PrivateKey
LsmsUser
LsmsUserSpid
To replicate these tables, refer to the Note in Step 1 of the topic, “MySQL Replication Configuration for Query Servers” in Appendix A of the Configuration Guide.