Meter-Related Database Changes
This chapter provides lists of meter-related database changes in the 22B release of Oracle Utilities cloud services. This includes:
New Tables
 
Table
Name
Description
D1_DYN_OPT_QUESTION*
Dynamic Option Questions
Used to store qualification questions for end customer enrollment into a program.
D1_DYN_OPT_RATE*
Dynamic Option Rates
Used to store the customer rates for utility service that are allowed for a given program.
D1_DYN_OPT_RULE*
Dynamic Option Rules
Used to store rules governing a customer’s participation in a program.
D1_DYN_OPT_SPECIFICATION*
Dynamic Option Specification
Used to store device specifications valid for a customer’s participation in a program.
D1_DYN_OPT_TYPE_REL*
Dynamic Option Type Relationship
Used to store the dynamic option (program) types that are applicable/related to another program type.
For example, a Home Energy Assessment Program that goes with a Thermostat Program. This is used by the enrollment process to present potential subscribers and a list of related programs that they might be interested in.
D1_EVT_PARTICIPATION*
Event Participation
Used to store a customer’s participation in a curtailment event associated with a program.
D1_EVT_PARTICIPATION_CHAR*
Event Participation Characteristics
Used to store codified attributes related a customer’s participation in an event.
D1_EVT_PARTICIPATION_K*
Event Participation Key
Key table related to the Event Participation table
D1_EVT_PARTICIPATION_LOG*
Event Participation Log
Used to store log entries as an Event Participation moves through its lifecycle.
D1_EVT_PARTICIPATION_LOG_PARM*
Event Participation Log Parameter
Used to store parameters related to the Event Participation Log
D1_RULE*
Rule
Used to store rules that can be applied to one or more programs.
D1_RULE_CHAR*
Rule Characteristic
Used to store codified attributes of a rule.
D1_RULE_L*
Rule Language
Language table related to the Rule table.
D1_US_TYPE_VALID_US_CHAR*
Usage Subscription Type - Valid US Characteristics
Used to store valid characteristics for a program subscription, typically used for checking program eligibility.
* Used by Digital Asset Cloud Service
New Indexes
 
Table_Name
Index_Name
D1_DYN_OPT_QUESTION
D1M646P0*
D1_DYN_OPT_RATE
D1M645P0*
D1_DYN_OPT_RULE
D1M647P0*
D1_DYN_OPT_SPECIFICATION
D1M638P0*
D1_DYN_OPT_TYPE_REL
D1M648P0*
D1_EVT_PARTICIPATION
D1T639P0*
D1_EVT_PARTICIPATION_CHAR
D1T641P0*
D1_EVT_PARTICIPATION_CHAR
D1T641S1*
D1_EVT_PARTICIPATION_K
D1T640P0*
D1_EVT_PARTICIPATION_LOG
D1T642P0*
D1_RULE
D1C649P0*
D1_RULE_CHAR
D1C651P0*
D1_RULE_L
D1C650P0*
D1_EVT_PARTICIPATION_LOG_PARM
D1T643P0*
D1_US_TYPE_VALID_US_CHAR
D1C644P0*
D1_US_TYPE_VALID_US_CHAR
D1C644S1*
* Used by Digital Asset Cloud Service
New Columns
 
Table_Name
Column_Name
Data Type
Data Length
D1_DYN_OPT
EXT_DYN_OPT_ID_VALUE*
VARCHAR2
120
D1_DYN_OPT
D1_INITIATIVE_CD*
VARCHAR2
30
D1_DYN_OPT
D1_APPROVAL_PROF_CD*
VARCHAR2
30
D1_DYN_OPT
DIVISION_CD*
VARCHAR2
30
D1_DYN_OPT
START_DT*
DATE
10
D1_DYN_OPT
END_DT*
DATE
10
D1_DYN_OPT
SUSPEND_FLG*
CHAR
4
D1_DYN_OPT_EVENT
DYN_OPT_EVENT_CAT_FLG*
CHAR
4
D1_DYN_OPT_TYPE
DYN_OPT_EVENT_BO_CD*
CHAR
30
D1_DYN_OPT_TYPE
D1_APPROVAL_PROF_CD*
VARCHAR2
30
D1_DYN_OPT_TYPE
EVENT_PARTICIPATION_BO_CD*
CHAR
30
D1_SP_EQPMN
SEQNO*
NUMBER
5
D1_SP_EQPMN
ACTIVE_INACTIVE_FLG*
CHAR
4
D1_SP_TYPE
SP_CLASS_FLG*
CHAR
4
D1_USAGE_PERIOD_SQ
D1_VARIABLE_NAME*
CHAR
20
D1_USAGE_PERIOD_SQ
D1_FORMULA*
VARCHAR2
50
D1_US_DYN_OPT
SEQNO*
NUMBER
5
D1_US_SP
SEQNO
NUMBER
5
* Used by Digital Asset Cloud Service