Table: XNP_SERVICE_PROVIDERS

Product:	XNP - Number Portability
Description:	Stores service provider definitions
Implementation/DBA Data:	XNP.XNP_SERVICE_PROVIDERS

Primary Key: XNP_SERVICE_PROVIDERS_PK

1. SP_ID

Primary Key: XNP_SERVICE_PROVIDERS_UK1

1. CODE

Foreign Keys

Table		Foreign Table	Foreign Key Column
XNP_AUDIT_DISCREPANCIES		XNP_SERVICE_PROVIDERS	XNP_AUDIT_DISCREPANCIES.SP_ID
XNP_AUDIT_SMS_FAILURES		XNP_SERVICE_PROVIDERS	XNP_AUDIT_SMS_FAILURES.SP_ID
XNP_NUMBER_RANGES		XNP_SERVICE_PROVIDERS	XNP_NUMBER_RANGES.OWNING_SP_ID
XNP_NUMBER_RANGES		XNP_SERVICE_PROVIDERS	XNP_NUMBER_RANGES.ASSIGNED_SP_ID
XNP_ROUTING_NUMBERS		XNP_SERVICE_PROVIDERS	XNP_ROUTING_NUMBERS.SP_ID
XNP_SERVICE_AREAS		XNP_SERVICE_PROVIDERS	XNP_SERVICE_AREAS.SP_ID
XNP_SP_ADAPTERS		XNP_SERVICE_PROVIDERS	XNP_SP_ADAPTERS.SP_ID
XNP_SP_CONTACTS		XNP_SERVICE_PROVIDERS	XNP_SP_CONTACTS.SP_ID
XNP_SP_FILTERS		XNP_SERVICE_PROVIDERS	XNP_SP_FILTERS.SP_ID
XNP_SV_AUDITS		XNP_SERVICE_PROVIDERS	XNP_SV_AUDITS.FOR_SP_ID
XNP_SV_AUDITS		XNP_SERVICE_PROVIDERS	XNP_SV_AUDITS.SP_ID
XNP_SV_FAILURES		XNP_SERVICE_PROVIDERS	XNP_SV_FAILURES.SP_ID
XNP_SV_SMS		XNP_SERVICE_PROVIDERS	XNP_SV_SMS.MEDIATOR_SP_ID
XNP_SV_SOA		XNP_SERVICE_PROVIDERS	XNP_SV_SOA.DONOR_SP_ID
XNP_SV_SOA		XNP_SERVICE_PROVIDERS	XNP_SV_SOA.RECIPIENT_SP_ID
XNP_SV_SOA		XNP_SERVICE_PROVIDERS	XNP_SV_SOA.CREATED_BY_SP_ID
XNP_SV_SOA		XNP_SERVICE_PROVIDERS	XNP_SV_SOA.CHANGED_BY_SP_ID
XNP_SV_SOA		XNP_SERVICE_PROVIDERS	XNP_SV_SOA.MEDIATOR_SP_ID
XNP_SV_SOA_JN		XNP_SERVICE_PROVIDERS	XNP_SV_SOA_JN.CHANGED_BY_SP_ID
XNP_SV_SOA_JN		XNP_SERVICE_PROVIDERS	XNP_SV_SOA_JN.CREATED_BY_SP_ID
XNP_SV_SOA_JN		XNP_SERVICE_PROVIDERS	XNP_SV_SOA_JN.DONOR_SP_ID
XNP_SV_SOA_JN		XNP_SERVICE_PROVIDERS	XNP_SV_SOA_JN.RECIPIENT_SP_ID
XNP_SV_SOA_JN		XNP_SERVICE_PROVIDERS	XNP_SV_SOA_JN.MEDIATOR_SP_ID