2 Customer-Related Database Changes
This chapter provides lists of customer-related database changes in the 26.10 release of Oracle Utilities cloud services. This includes:
New Tables
| Table | Name | Description |
|---|---|---|
| C1_CUST_PROF | Customer Profile | Used to define and capture customer profiles |
| C1_CUST_PROF_ATTR | Customer Profile Attribute | Used to capture attributes associated with a customer profile |
| C1_CUST_PROF_ATTR_REL_OBJ | Customer Profile Attribute Related Object | Used to store objects related to customer profile attributes |
| C1_CUST_PROF_ATTR_TYPE | Customer Profile Attribute Type | Used to capture attribute types associated with a customer profile |
| C1_CUST_PROF_ATTR_TYPE_L | Customer Profile Attribute Type Language | Used to store labels for the Customer Profile Attribute Type table |
| C1_CUST_PROF_ATTR_TYPE_REL_OBJ | Customer Profile Attribute Type Related Object | Used to store objects related to customer profile attribute types |
| C1_CUST_PROF_K | Customer Profile Key | Used to capture the relationship between customer profiles and an environment |
| C1_CUST_PROF_LOG | Customer Profile Log | Used to capture log details for customer profiles |
| C1_CUST_PROF_LOG_PARM | Customer Profile Log Parameters | Used to capture log parameters for customer profiles |
| C1_CUST_PROF_TYPE | Customer Profile Type | Used to define types of customer profiles |
| C1_CUST_PROF_TYPE_ATTR | Customer Profile Type Valid Attribute | Used to define valid attributes for a customer profile type |
| C1_CUST_PROF_TYPE_L | Customer Profile Type Language | Used to store labels for the Customer Profile Type table |
New Columns
| Table_Name | Column_Name | Data Type | Length |
|---|---|---|---|
| C1_CALC_RULE_CRT | EFF_DATE_SRCE_FLG | CHAR | 4 |
| C1_CUST_PROF | ACCT_ID | CHAR | 10 |
| C1_CUST_PROF | BO_STATUS_CD | CHAR | 12 |
| C1_CUST_PROF | BO_STATUS_REASON_CD | VARCHAR | 30 |
| C1_CUST_PROF | BO_XML_DATA_AREA | XML | 1073741824 |
| C1_CUST_PROF | BUS_OBJ_CD | CHAR | 30 |
| C1_CUST_PROF | CRE_DTTM | DTTM | 26 |
| C1_CUST_PROF | CUST_PROF_ID | CHAR | 12 |
| C1_CUST_PROF | CUST_PROF_TYPE_CD | CHAR | 12 |
| C1_CUST_PROF | STATUS_UPD_DTTM | DTTM | 26 |
| C1_CUST_PROF | VERSION | NUMBER | 5,0 |
| C1_CUST_PROF_ATTR | BO_XML_DATA_AREA | XML | 1073741824 |
| C1_CUST_PROF_ATTR | CRE_DTTM | DTTM | 26 |
| C1_CUST_PROF_ATTR | CUST_PROF_ATTR_TYPE_CD | CHAR | 30 |
| C1_CUST_PROF_ATTR | CUST_PROF_ATTR_VAL | VARCHAR | 254 |
| C1_CUST_PROF_ATTR | CUST_PROF_ID | CHAR | 12 |
| C1_CUST_PROF_ATTR | LAST_UPDATE_DTTM | DTTM | 26 |
| C1_CUST_PROF_ATTR | SEQNO | NUMBER | 5,0 |
| C1_CUST_PROF_ATTR | VERSION | NUMBER | 5,0 |
| C1_CUST_PROF_ATTR_REL_OBJ | CUST_PROF_ATTR_REL_OBJ_SEQ | NUMBER | 5,0 |
| C1_CUST_PROF_ATTR_REL_OBJ | CUST_PROF_ATTR_REL_OBJ_TYP_FLG | CHAR | 4 |
| C1_CUST_PROF_ATTR_REL_OBJ | CUST_PROF_ATTR_TYPE_CD | CHAR | 30 |
| C1_CUST_PROF_ATTR_REL_OBJ | CUST_PROF_ID | CHAR | 12 |
| C1_CUST_PROF_ATTR_REL_OBJ | MAINT_OBJ_CD | CHAR | 12 |
| C1_CUST_PROF_ATTR_REL_OBJ | PK_VALUE1 | VARCHAR | 254 |
| C1_CUST_PROF_ATTR_REL_OBJ | PK_VALUE2 | VARCHAR | 254 |
| C1_CUST_PROF_ATTR_REL_OBJ | PK_VALUE3 | VARCHAR | 254 |
| C1_CUST_PROF_ATTR_REL_OBJ | PK_VALUE4 | VARCHAR | 254 |
| C1_CUST_PROF_ATTR_REL_OBJ | PK_VALUE5 | VARCHAR | 254 |
| C1_CUST_PROF_ATTR_REL_OBJ | SEQNO | NUMBER | 5,0 |
| C1_CUST_PROF_ATTR_REL_OBJ | VERSION | NUMBER | 5,0 |
| C1_CUST_PROF_ATTR_TYPE | BO_XML_DATA_AREA | XML | 1073741824 |
| C1_CUST_PROF_ATTR_TYPE | BUS_OBJ_CD | CHAR | 30 |
| C1_CUST_PROF_ATTR_TYPE | CUST_PROF_ATTR_OCCUR_FLG | CHAR | 4 |
| C1_CUST_PROF_ATTR_TYPE | CUST_PROF_ATTR_STAT_FLG | CHAR | 4 |
| C1_CUST_PROF_ATTR_TYPE | CUST_PROF_ATTR_TYPE_CD | CHAR | 30 |
| C1_CUST_PROF_ATTR_TYPE | FLD_NAME | CHAR | 30 |
| C1_CUST_PROF_ATTR_TYPE | VERSION | NUMBER | 5,0 |
| C1_CUST_PROF_ATTR_TYPE_L | CUST_PROF_ATTR_TYPE_CD | CHAR | 30 |
| C1_CUST_PROF_ATTR_TYPE_L | DESCR100 | VARCHAR | 100 |
| C1_CUST_PROF_ATTR_TYPE_L | DESCRLONG | VARCHAR | 4000 |
| C1_CUST_PROF_ATTR_TYPE_L | LANGUAGE_CD | CHAR | 3 |
| C1_CUST_PROF_ATTR_TYPE_L | VERSION | NUMBER | 5,0 |
| C1_CUST_PROF_ATTR_TYPE_REL_OBJ | CUST_PROF_ATTR_REL_OBJ_TYP_FLG | CHAR | 4 |
| C1_CUST_PROF_ATTR_TYPE_REL_OBJ | CUST_PROF_ATTR_TYPE_CD | CHAR | 30 |
| C1_CUST_PROF_ATTR_TYPE_REL_OBJ | MAINT_OBJ_CD | CHAR | 12 |
| C1_CUST_PROF_ATTR_TYPE_REL_OBJ | VERSION | NUMBER | 5,0 |
| C1_CUST_PROF_K | CUST_PROF_ID | CHAR | 12 |
| C1_CUST_PROF_K | ENV_ID | NUMBER | 6,0 |
| C1_CUST_PROF_LOG | ADHOC_CHAR_VAL | VARCHAR | 254 |
| C1_CUST_PROF_LOG | BO_STATUS_CD | CHAR | 12 |
| C1_CUST_PROF_LOG | BO_STATUS_REASON_CD | VARCHAR | 30 |
| C1_CUST_PROF_LOG | CHAR_TYPE_CD | CHAR | 8 |
| C1_CUST_PROF_LOG | CHAR_VAL | CHAR | 16 |
| C1_CUST_PROF_LOG | CHAR_VAL_FK1 | VARCHAR | 50 |
| C1_CUST_PROF_LOG | CHAR_VAL_FK2 | VARCHAR | 50 |
| C1_CUST_PROF_LOG | CHAR_VAL_FK3 | VARCHAR | 50 |
| C1_CUST_PROF_LOG | CHAR_VAL_FK4 | VARCHAR | 50 |
| C1_CUST_PROF_LOG | CHAR_VAL_FK5 | VARCHAR | 50 |
| C1_CUST_PROF_LOG | CUST_PROF_ID | CHAR | 12 |
| C1_CUST_PROF_LOG | DESCRLONG | VARCHAR | 4000 |
| C1_CUST_PROF_LOG | LOG_DTTM | DTTM | 26 |
| C1_CUST_PROF_LOG | LOG_ENTRY_TYPE_FLG | CHAR | 4 |
| C1_CUST_PROF_LOG | MESSAGE_CAT_NBR | NUMBER | 5,0 |
| C1_CUST_PROF_LOG | MESSAGE_NBR | NUMBER | 5,0 |
| C1_CUST_PROF_LOG | SEQNO | NUMBER | 5,0 |
| C1_CUST_PROF_LOG | USER_ID | CHAR | 8 |
| C1_CUST_PROF_LOG | VERSION | NUMBER | 5,0 |
| C1_CUST_PROF_LOG_PARM | CUST_PROF_ID | CHAR | 12 |
| C1_CUST_PROF_LOG_PARM | MSG_PARM_TYP_FLG | CHAR | 4 |
| C1_CUST_PROF_LOG_PARM | MSG_PARM_VAL | VARCHAR | 2000 |
| C1_CUST_PROF_LOG_PARM | PARM_SEQ | NUMBER | 3,0 |
| C1_CUST_PROF_LOG_PARM | SEQNO | NUMBER | 5,0 |
| C1_CUST_PROF_LOG_PARM | VERSION | NUMBER | 5,0 |
| C1_CUST_PROF_TYPE | BO_XML_DATA_AREA | XML | 1073741824 |
| C1_CUST_PROF_TYPE | BUS_OBJ_CD | CHAR | 30 |
| C1_CUST_PROF_TYPE | CUST_PROF_TYPE_CD | CHAR | 12 |
| C1_CUST_PROF_TYPE | CUST_PROF_TYPE_STAT_FLG | CHAR | 4 |
| C1_CUST_PROF_TYPE | TRANS_BUS_OBJ_CD | CHAR | 30 |
| C1_CUST_PROF_TYPE | VERSION | NUMBER | 5,0 |
| C1_CUST_PROF_TYPE_ATTR | CUST_PROF_ATTR_TYPE_CD | CHAR | 30 |
| C1_CUST_PROF_TYPE_ATTR | CUST_PROF_TYPE_CD | CHAR | 12 |
| C1_CUST_PROF_TYPE_ATTR | VERSION | NUMBER | 5,0 |
| C1_CUST_PROF_TYPE_L | CUST_PROF_TYPE_CD | CHAR | 12 |
| C1_CUST_PROF_TYPE_L | DESCR100 | VARCHAR | 100 |
| C1_CUST_PROF_TYPE_L | DESCRLONG | VARCHAR | 4000 |
| C1_CUST_PROF_TYPE_L | LANGUAGE_CD | CHAR | 3 |
| C1_CUST_PROF_TYPE_L | VERSION | NUMBER | 5,0 |
| C1_NTF_PREF_SA | SP_ID | CHAR | 10 |
| CI_CC | NTF_PREF_SA_ID | CHAR | 14 |
Dropped Columns
| Table_Name | Column_Name |
|---|---|
| C1_NTF_PREF_SA | SP_ID |
New Indexes
| Table_Name | Index_Name |
|---|---|
| C1_CUST_PROF | C1T177P0 |
| C1_CUST_PROF | C1T177S1 |
| C1_CUST_PROF | C1T177S2 |
| C1_CUST_PROF | C1T177S3 |
| C1_CUST_PROF | C1T177S4 |
| C1_CUST_PROF_ATTR | C1T179P0 |
| C1_CUST_PROF_ATTR | C1T179S1 |
| C1_CUST_PROF_ATTR | C1T179S2 |
| C1_CUST_PROF_ATTR_REL_OBJ | C1T180P0 |
| C1_CUST_PROF_ATTR_REL_OBJ | C1T180S1 |
| C1_CUST_PROF_ATTR_REL_OBJ | C1T180S2 |
| C1_CUST_PROF_ATTR_TYPE | C1C177P0 |
| C1_CUST_PROF_ATTR_TYPE | C1C177S1 |
| C1_CUST_PROF_ATTR_TYPE_L | C1C178P0 |
| C1_CUST_PROF_ATTR_TYPE_REL_OBJ | C1C179P0 |
| C1_CUST_PROF_K | C1T178P0 |
| C1_CUST_PROF_LOG | C1T181P0 |
| C1_CUST_PROF_LOG | C1T181S1 |
| C1_CUST_PROF_LOG | C1T181S2 |
| C1_CUST_PROF_LOG_PARM | C1T182P0 |
| C1_CUST_PROF_TYPE | C1C174P0 |
| C1_CUST_PROF_TYPE | C1C174S1 |
| C1_CUST_PROF_TYPE | C1C174S2 |
| C1_CUST_PROF_TYPE_ATTR | C1C176P0 |
| C1_CUST_PROF_TYPE_L | C1C175P0 |
| C1_PER_CONTDET | C1T009S5 |
| CI_ADJ | XT012S5 |
| CI_BSEG | XT048S5 |
| CI_BSEG | XT048S6 |
| CI_BILL_ROUTING | XT075S2 |
| CI_FT_GL | XT113S2 |
| CI_PAY_SEG | XT165S3 |
Deleted Indexes
| Table_Name | Index_Name |
|---|---|
| C1_NTF_PREF_SA | C1T172S2 |