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. |
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* |
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 |