Technical data

Guidelines for System Table Updates
C-6 Oracle Utilities Meter Data Management Database Administrator’s Guide
Algorithm
Application Security
Batch Control
Properties Description
Tables CI_ALG, CI_ALG_L, CI_ALG_PARM,
CI_ALG_VER
Standard Data Fields Algorithm (ALG_CD)
Customer Modification None
Properties Description
Tables SC_APP_SERVICE,
SC_APP_SERVICE_L,
CI_APP_SVC_ACC
Standard Data Fields Application Service ID (APP_SVC_ID).
Customer care and billing products prior to
version 2.0 will continue to use CI as a
prefix for the application service.
Customer Modification None
Properties Description
Tables CI_BATCH_CTRL, CI_BATCH_CTRL_L,
CI_BATCH_CTRL_P, CI_BATCH_CTRL_P_L
Standard Data Fields Batch Process (BATCH_CD), Program Name
(PROGRAM_NAME)
Customer Modification Next Batch Number (NEXT_BATCH_NBR), Last
Update Instance (LAST_UPDATE_INST), Last
Update Date time (LAST_UPDATE_DTTM) and
the batch process update these columns. Time
Interval (TIMER_INTERVAL), Thread Count
(BATCH_THREAD_CNT), Maximum Commit
Records (MAX_COMMIT_RECS), User
(USER_ID), Language (LANGUAGE_CD), Email
Address (EMAILID), Start program debug tracing
(TRC_PGM_STRT_SW), End Program Debug
trace (TRC_PGM_END_SW), SQL debug tracing
(TRC_SQL_SW) and Standard debug tracing
(TRC_STD_SW) on CI_BATCH_CTRL Table.
Batch Parameter Value (BATCH_PARM_VAL) on
Batch Control Parameters Table
(CI_BATCH_CTRL_P)