Technical data

Guidelines for System Table Updates
C-16 Oracle Utilities Meter Data Management Database Administrator’s Guide
Portal and Zone
Sequence
Schema
Properties Description
Tables CI_PORTAL, CI_PORTAL_L,
CI_PORTAL_ZONE, CI_ZONE,
CI_ZONE_L, CI_ZONE_PRM,
CI_ZONE_HDL, CI_ZONE_HDL_L,
CI_ZONE_HDL_PRM,
CI_ZONE_HDL_PRM_L,
CI_UI_ZONE
Standard Data Fields Portal Code (PORTAL_CD), Zone Code
(ZONE_CD), Zone Type Code
(ZONE_HDL_CD)
• A new Zone can be added to the
Product owned Portal Pages.
• The existing Zones cannot be
removed from the Product owned
Portal Pages.
Customer Modification Sort Sequence (SORT_SEQ) on Context
Sensitive Zone Table (CI_UI_ZONE).
Show on Portal Preferences
(USER_CONFIG_FLG) on Portal Table
(CI_PORTAL). Override Sequence
(SORT_SEQ_OVRD) on Portal Zone
Table (CI_PORTAL_ZONE). Customer
Specific Description
(DESCRLONG_OVRD) on Zone
Language Table (CI_ZONE_L). Override
Parameter Value
(ZONE_HDL_PARM_OVRD) on Zone
Type Parameters Table
(CI_ZONE_HDL_PRM). Override
Parameter Value
(ZONE_PARM_VAL_OVRD) on Zone
Parameters Table (CI_ZONE_PRM).
Properties Description
Tables CI_SEQ
Standard Data Fields Sequence Name (SEQ_NAME)
Customer Modification Sequence Number (SEQ_NBR)
This field is updated by the application
process and must be set to 1 initially.