Technical data

System Table List
C-20 Oracle Utilities Meter Data Management Database Administrator’s Guide
System Table List
This section contains names of system tables, upgrade actions, and a brief description of tables.
The upgrade actions are explained below.
Keep (KP): The data in the table in the customer's database is kept untouched. No insert or
delete is performed to this table by the upgrade process. The initial installation will add necessary
data for the system
Merge (MG): The non-base product data in the table in the database is kept untouched. If the
data belongs to the base product, any changes pertaining to the new version of the software are
performed.
Refresh (RF): The existing data in the table is replaced with the data from the base product table.
Note. New product data is also inserted into tables marked as 'Merge'. If
implementers add rows for a customer specific enhancement, it can cause
duplication when the system data gets upgraded to the next version. We
strongly recommend following the guidelines on how to use designated range
of values or prefixes to segregate the implementation data from the base
product data.
Table Name Upgrade Action Description
CI_ALG MG Algorithm
CI_ALG_L MG Algorithm Language
CI_ALG_PARM MG Algorithm Parameters
CI_ALG_TYPE MG Algorithm Type
CI_ALG_TYPE_L MG Algorithm Type Language
CI_ALG_TYPE_PRM MG Algorithm Type Parameter
CI_ALG_TYPE_PRM_L MG Algorithm Type Parameter
Language
CI_ALG_VER MG Algorithm Version
CI_APP_SVC_ACC MG Application Service Access Mode
CI_BATCH_CTRL MG Batch Control
CI_BATCH_CTRL_ALG KP Batch Control Algorithm
CI_BATCH_CTRL_L MG Batch Control Language
CI_BATCH_CTRL_P MG Batch Control Parameters
CI_BATCH_CTRL_P_L MG Batch Control Parameters
Language
CI_CHAR_ENTITY MG Characteristic Type Entity
CI_CHAR_TYPE MG Characteristic Type
CI_CHAR_TYPE_L MG Characteristic Type Language
CI_CHAR_VAL MG Characteristic Type Value
CI_CHAR_VAL_L MG Characteristic Type Value
Language