XNP — Number Portability
40 documented tables · 8 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
XNP_SERVICE_PROVIDERS |
Stores service provider definitions | hub |
XNP_MSG_TYPES_B |
Contains data dictionary for the message | hub |
XNP_GEO_AREAS_B |
Stores given geographic areas | hub |
XNP_ROUTING_NUMBERS |
Stores routing numbers which are used to deliver ported telephone numbers to the appropriate service provider | hub-leaning |
XNP_MSG_ELEMENTS |
Contains XML message elements | hub-leaning |
XNP_NUMBER_RANGES |
Stores information about the characteristics of a service provider's telephone number ranges | hub-leaning |
XNP_SV_STATUS_TYPES_B |
Subsription version status definition | hub-leaning |
XNP_SV_SOA |
Container object for a porting request on a single telephone number | satellite-leaning |
XNP_MSG_ELEMENT_ATTR |
Contains attributes of XML elements | satellite-leaning |
XNP_SV_AUDITS |
Stores all subscription audits issued from a service provider | satellite-leaning |
XNP_SV_SMS |
Container object for subscription versions downloaded to the network | satellite-leaning |
XNP_MSGS |
Stores the actual instance of a message that passes over a network association | satellite-leaning |
XNP_SERVED_NUM_RANGES |
Stores the mapping of number ranges served by network element for each feature type | link |
XNP_SP_FILTERS |
Stores the number ranges for which a service provider does not want to be informed of subscription broadcasts | link |
XNP_SV_STATUS_TYPES_TL |
Translation table to XNP_SV_STATUS_TYPES_B | satellite-leaning |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.