4 Work and Asset-Related Database Changes
This chapter provides lists of work and asset-related database changes in the 26.4 release of Oracle Utilities cloud services. This includes:
New Tables
| Table | Name | Description |
|---|---|---|
| W1_USER_MISC_CHAR | User Miscellaneous Characteristic | Used to store characteristics associated with record in the User Miscellaneous table |
| W1_USER_MISC | User Miscellaneous | Used to capture configuration settings for the Insights zone on the Home Page |
| W1_SVC_HIST_TYPE_QSTN_COND | Service History Type Conditional Question | Used to capture conditional questions used with service history types |
New Indexes
| Table_Name | Index_Name |
|---|---|
| W1_ASSET_CHAR2 | W1T518S1 |
| W1_FT | W1T312S2 |
| W1_USER_MISC_CHAR | W1M982S4 |
| W1_USER_MISC_CHAR | W1M982S3 |
| W1_USER_MISC_CHAR | W1M982S2 |
| W1_USER_MISC_CHAR | W1M982S1 |
| W1_USER_MISC_CHAR | W1M982P0 |
| W1_USER_MISC | W1M981P0 |
| W1_SVC_HIST_TYPE_QSTN_COND | W1C980S2 |
| W1_SVC_HIST_TYPE_QSTN_COND | W1C980S1 |
| W1_SVC_HIST_TYPE_QSTN_COND | W1C980P0 |
Updated Indexes
| Table_Name | Index_Name |
|---|---|
| W1_INVOICE_LINE_IDENTIFIER | W1T527S2 |
| W1_PO_HEADER_IDENTIFIER | W1T525S1 |
| W1_INVOICE_HEADER_IDENTIFIER | W1T503S1 |
| W1_EXPEDITE_IDENTIFIER | W1T499S1 |
| W1_RCPT_HDR_IDENTIFIER | W1T462S1 |
| W1_MAT_DISP_IDENTIFIER | W1T459S1 |
| W1_PR_HDR_IDENTIFIER | W1T436S2 |
| W1_ACT_RESRC_REQMT_IDENTIFIER | W1T375S1 |
| W1_BC_HEADER_IDENTIFIER | W1T349S1 |
| W1_ODC_IDENTIFIER | W1T335S1 |
| W1_WORK_REQ_IDENTIFIER | W1T299S1 |
| W1_APPROVAL_REQ_IDENTIFIER | W1T294S1 |
| W1_ACTIVITY_IDENTIFIER | W1T247S1 |
| W1_WO_IDENTIFIER | W1T233S1 |
| W1_WORK_LOC_IDENTIFIER | W1M725S1 |
| W1_MAINT_EVENT_IDENTIFIER | W1M716S1 |
| W1_STOCK_ITEM_DTL_IDENTIFIER | W1M712S1 |
| W1_EXPENSE_CD_IDENTIFIER | W1M709S2 |
| W1_COST_CENTER_IDENTIFIER | W1M708S2 |
| W1_MAINT_TRIGGER_IDENTIFIER | W1M701S1 |
| W1_MAINT_SCHEDULE_IDENTIFIER | W1M655S1 |
| W1_VENDOR_LOC_IDENTIFIER | W1M639S2 |
| W1_VENDOR_IDENTIFIER | W1M635S2 |
| W1_TMPL_ACT_RSRC_IDENTIFIER | W1M629S1 |
| W1_TMPL_ACT_IDENTIFIER | W1M621S1 |
| W1_TMPL_WO_IDENTIFIER | W1M612S1 |
| W1_PROJECT_IDENTIFIER | W1M603S1 |
| W1_TIMESHEET_IDENTIFIER | W1M590S1 |
| W1_DOCUMENT_IDENTIFIER | W1M580S2 |
| W1_RESRC_TYPE_IDENTIFIER | W1M558S1 |
| W1_WARRANTY_IDENTIFIER | W1M525S1 |
| W1_CREW_IDENTIFIER | W1M519S1 |
| W1_EU_IDENTIFIER | W1M513S1 |
| W1_EMPLOYEE_IDENTIFIER | W1M505S1 |
| W1_CONFIG_RPT_IDENTIFIER | W1M494S1 |
| W1_CONFIG_IDENTIFIER | W1M487S1 |
| W1_SVC_HIST_IDENTIFIER | W1M280S1 |
| W1_ASSET_IDENTIFIER | W1M014S1 |
| W1_BUYER_IDENTIFIER | W1C677S1 |
| W1_APPROVAL_PROF_IDENTIFIER | W1C560S1 |
| W1_MEASUREMENT_TYPE_IDENTIFIER | W1C522S1 |
| W1_ACTIVITY_TYPE_IDENTIFIER | W1C242S1 |
| W1_SPECIFICATION_IDENTIFIER | W1C229S1 |
| W1_MANUFACTURER_IDENTIFIER | W1C225S1 |