AMM Job Management Tables

A AMM Job Management Tables

This appendix describes the tables used for account migration in Oracle Communications Billing and Revenue Management (BRM).

Topics in this document:

Job management tables are created on your database schemas during installation and are populated with information about each migration job.

The AMM installer creates the tables listed in Table A-1 on your schemas:

Table A-1 AMM Job Management Tables

Table Name	Schema	Description	When Populated
AMT_ACCOUNT_BATCH_TABLE_T	Primary only	Stores the list of tables containing data to migrate for a particular batch.	Populated by the AMM Mover when it migrates a particular batch.
AMT_METADATA_T	All schemas	AMM data dictionary. This lists all default BRM tables as well as any custom tables you created. If you add any tables after you install AMM, you must refresh the AMM data dictionary. See "Configuring AMM for New Custom Tables".	During installation and when you run pin_amt_install.pl -m to refresh the AMM data dictionary.
AMT_POID_TYPE_MAP_T	All schemas	Maps the POID type to the table name. This table is static.	During installation and when you run pin_amt_install.pl -m to refresh the data dictionary.

Table Name

Schema

Description

When Populated

AMT_ACCOUNT_BATCH_TABLE_T

Primary only

Stores the list of tables containing data to migrate for a particular batch.

Populated by the AMM Mover when it migrates a particular batch.

AMT_METADATA_T

All schemas

AMM data dictionary. This lists all default BRM tables as well as any custom tables you created.

If you add any tables after you install AMM, you must refresh the AMM data dictionary. See "Configuring AMM for New Custom Tables".

During installation and when you run pin_amt_install.pl -m to refresh the AMM data dictionary.

AMT_POID_TYPE_MAP_T

All schemas

Maps the POID type to the table name. This table is static.

During installation and when you run pin_amt_install.pl -m to refresh the data dictionary.