FND Design Data [Home] [Help]

Table: XNP_INTERCONNECT_AREAS

Product: XNP - Number Portability
Description: Stores geographic area covered by a routing number
Implementation/DBA Data: TableXNP.XNP_INTERCONNECT_AREAS
Primary Key: XNP_INTERCONNECT_AREAS_PK
  1. ColumnINTERCONNECT_AREA_ID
Primary Key: XNP_INTERCONNECT_AREAS_UK1
  1. ColumnROUTING_NUMBER_ID
  2. ColumnGEO_AREA_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
XNP_INTERCONNECT_AREAS FK Joins to TableXNP_GEO_AREAS_B XNP_INTERCONNECT_AREAS.GEO_AREA_ID
XNP_INTERCONNECT_AREAS FK Joins to TableXNP_ROUTING_NUMBERS XNP_INTERCONNECT_AREAS.ROUTING_NUMBER_ID