Technical data

Guidelines for System Table Updates
C-12 Oracle Utilities Meter Data Management Database Administrator’s Guide
Meta Data - Table and Field
Customer Modification Override Description (DESCRLONG_OVRD),
Message Text Override
(MESSAGE_TEXT_OVRD)
Properties Description
Properties Description
Tables CI_MD_TBL, CI_MD_TBL_FLD,
CI_MD_TBL_L, CI_MD_TBL_FLD_L,
CI_MD_FLD, CI_MD_FLD_L,
F1_DB_OBJECTS_REPO
Standard Data Fields Table Name (TBL_NAME)
• Table names must match with the
physical table name or view name in
the database.
• Field Name (FLD_NAME)Field name
must match with the physical column
name in the database unless the field is
a work field. Field name does not have
to follow the prefixing standard unless
the field is a work field or customer
modification field.
• F1_DB_OBJECTS_REPO Table
stores information about Indexes,
Sequences, Triggers and other
database objects excluding Tables and
Fields (as they are already stored in the
other Metadata tables)
Customer Modification Audit Switches (AUDIT_INSERT_SW,
AUDIT_UPDATE_SW,
AUDIT_DELETE_SW), Override label
(OVRD_LABEL) on MD Table Field
Table (CI_MD_TBL_FLD). Audit
Program Name (AUDIT_PGM_NAME),
Audit Table Name
(AUDIT_TBL_NAME), Audit Program
Type (AUDIT_PGM_TYPE_FLG), Key
Validation (KEY_VALIDATION_FLG)
and Caching strategy (CACHE_FLG) on
MD Table (CI_MD_TBL). Override Label
(OVRD_LABEL) and Customer Specific
Description (DESCRLONG_OVRD) on
Field Table.