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.