Table: XNP_ROUTING_NUMBERS

Product:	XNP - Number Portability
Description:	Stores routing numbers which are used to deliver ported telephone numbers to the appropriate service provider
Implementation/DBA Data:	XNP.XNP_ROUTING_NUMBERS

Primary Key: XNP_ROUTING_NUMBERS_PK

1. ROUTING_NUMBER_ID

Primary Key: XNP_ROUTING_NUMBERS_UK1

1. SP_ID
2. ROUTING_NUMBER
3. INTERCONNECT_TYPE

Primary Key: XNP_ROUTING_NUMBERS_UK2

1. OBJECT_REFERENCE

Foreign Keys

Table		Foreign Table	Foreign Key Column
XNP_ROUTING_NUMBERS		XNP_SERVICE_PROVIDERS	XNP_ROUTING_NUMBERS.SP_ID
XNP_INTERCONNECT_AREAS		XNP_ROUTING_NUMBERS	XNP_INTERCONNECT_AREAS.ROUTING_NUMBER_ID
XNP_SV_SMS		XNP_ROUTING_NUMBERS	XNP_SV_SMS.ROUTING_NUMBER_ID
XNP_SV_SOA		XNP_ROUTING_NUMBERS	XNP_SV_SOA.ROUTING_NUMBER_ID
XNP_SV_SOA_JN		XNP_ROUTING_NUMBERS	XNP_SV_SOA_JN.ROUTING_NUMBER_ID