4 Work and Asset-Related Database Changes
This chapter provides lists of work and asset-related database changes in the 25.10 release of Oracle Utilities cloud services. This includes:
New Tables
| Table | Name | Description |
|---|---|---|
| W1_CU_REF_CU_SET | Compatible Unit Referenced CU Set | Used to capture relationships between compatible units and compatible unit sets |
| W1_NODE_NOTE | Node Note | Used to capture notes related to nodes |
| W1_RR_NOTE | Reorder Review Note | Used to capture notes related reorder reviews |
New Columns
| Table_Name | Column_Name | Data Type | Length |
|---|---|---|---|
| W1_CU_REF_CU_SET | CU_ID | CHAR | 12 |
| W1_CU_REF_CU_SET | CU_SET_CD | VARCHAR2 | 30 |
| W1_CU_REF_CU_SET | VERSION | NUMBER | 22 |
| W1_DESIGN_ELEMENT | PRJ_ID | CHAR | 12 |
| W1_NODE_NOTE | NODE_ID | CHAR | 12 |
| W1_NODE_NOTE | NOTE_DTTM | DATE | 7 |
| W1_NODE_NOTE | NOTE_TYPE_FLG | CHAR | 4 |
| W1_NODE_NOTE | NOTE_VALUE | VARCHAR2 | 4000 |
| W1_NODE_NOTE | SEQNO | NUMBER | 22 |
| W1_NODE_NOTE | USER_ID | CHAR | 8 |
| W1_NODE_NOTE | VERSION | NUMBER | 22 |
| W1_PARENT_ORG_MT_VW | NODE_ID | CHAR | 12 |
| W1_PARENT_ORG_MT_VW | PARENT_NODE_ID | CHAR | 12 |
| W1_RR_NOTE | NOTE_DTTM | DATE | 7 |
| W1_RR_NOTE | NOTE_TYPE_FLG | CHAR | 4 |
| W1_RR_NOTE | NOTE_VALUE | VARCHAR2 | 4000 |
| W1_RR_NOTE | RR_ID | CHAR | 14 |
| W1_RR_NOTE | SEQNO | NUMBER | 22 |
| W1_RR_NOTE | USER_ID | CHAR | 8 |
| W1_RR_NOTE | VERSION | NUMBER | 22 |
| W1_SVC_HIST_TYPE_QSTN | SVC_HIST_TYPE_QSTN_REQ_FLG | CHAR | 4 |
New Indexes
| Table_Name | Index_Name |
|---|---|
| W1_CU_REF_CU_SET | W1M979P0 |
| W1_CU_REF_CU_SET | W1M979P0 |
| W1_NODE_NOTE | W1M978P0 |
| W1_NODE_NOTE | W1M978P0 |
| W1_RR_NOTE | W1T977P0 |
| W1_RR_NOTE | W1T977P0 |