B MSS Database Tables Impacted by the Resolution Process

This appendix provides information on Oracle Communications MetaSolv Solution (MSS) database tables, which are impacted during the Address Correction Utility resolution process.

Table B-1 lists the impacted MSS database tables and the scenarios in which information is inserted, updated, or deleted in each database table after the resolution process is completed by the Address Correction utility.

Table B-1 MSS Database Tables Impacted After Resolution Process

Database Table Name Scenario 1Foot 1  Scenario 2Foot 2  Scenario 3Foot 3 

ASAP.ACCESS_BILLING_CIRCUIT_LOC

Update

Update

N/A

ASAP.CABLE

Update

N/A

Update

ASAP.CABLE_COMPLEMENT

Update

N/A

Update

ASAP.CIRCUIT

Update

N/A

Update

ASAP.CIRCUIT_LAYOUT_REPORT

N/A

Update

N/A

ASAP.CIRCUIT_XREF

Update

N/A

Update

ASAP.CUST_ACCT_LOCATIONS

Update/Delete

Update

Update/Delete

ASAP.DEDICATED_CROSSCONNECT

Update

N/A

Update

ASAP.DESIGN_LAYOUT_REPORT

Update

Update

Update

ASAP.DESIGN_LINE

Update

N/A

Update

ASAP.DESIGN_ORD_SUMM

N/A

Update

N/A

ASAP.DL_DLR_LINE_ISI

Update

N/A

Update

ASAP.DLR_CIRCUIT_DESIGN_LINE

Update

N/A

Update

ASAP.E911_EXTRACT

Delete

Update

Update

ASAP.EMP_APPT

Update

N/A

Update

ASAP.END_USER_LOCATION

Update/Delete

N/A

Delete

ASAP.END_USER_LOCATION_USAGE

Update/Delete

N/A

Update

ASAP.EQ_LOCN_STRUC_HIER

Update/Delete

N/A

Update/Delete

ASAP.EQUIPMENT

Update

N/A

Update

ASAP.EUL_LSO

Update/Delete

N/A

Update/Delete

ASAP.MSAG_ADDR_LOC

Delete

Delete

Delete

ASAP.NA_NET_LOC

Delete

N/A

Delete

ASAP.NET_LOC_ADDR

Update/Insert/Delete

Update/Insert/Delete

Update/Insert/Delete

ASAP.NET_LOC_ADDR_PR_ADDR

Update/Insert/Delete

Update/Insert/Delete

Update/Insert/Delete

ASAP.NET_LOC_REL

Delete

N/A

Delete

ASAP.NET_LOC_TERM_LOC

Update/Delete

N/A

Update/Delete

ASAP.NETLOC_CA_VALUE

Delete

N/A

Delete

ASAP.NETWORK_LOCATION

Delete

N/A

Delete

ASAP.NETWORK_LOCATION_USER_DATA

Delete

N/A

Delete

ASAP.NETWORK_NODE

Update

N/A

Update

ASAP.NETWORK_ROUTE

Update

N/A

Update

ASAP.NS_COMPONENT

Update

N/A

Update

ASAP.PARTY

Insert

Insert

Insert

ASAP.PARTY_ADDRESS

Insert

Insert

Insert

ASAP.PARTY_ROLE

Insert

Insert

Insert

ASAP.PARTY_ROLE_ADDRESS

Insert

Insert

Insert

ASAP.SI_LOC

Update

Update

Update

ASAP.SR_LOC

Update/Insert/Delete

Update/Insert/Delete

Update/Insert/Delete

ASAP.SRSI_SI_LOC

Update

N/A

N/A

SRSI_SR_LOC

N/A

N/A

Update

ASAP.TANDEM_TYPE

Delete

N/A

Delete

ASAP.USO_CIRCUIT_LOC

Update

N/A

Update

Footnote 1 Scenario 1: Multiple end user locations having the same address.

Footnote 2 Scenario 2: Multiple active addresses of same address format at the same end user location.

Footnote 3 Scenario 3: Multiple end user locations having the same address in MSAG and OBF structured formats.