Table | Name | Description |
W1_CU_CU_USAGE | Compatible Unit CU Usage | Used to store configuration data related to compatible units usage |
Table_Name | Column_Name | Data Type | Data Length |
W1_ACTIVITY | ACT_DURATION | NUMBER | 22 |
W1_ACTIVITY | UOT_FLG | CHAR | 4 |
W1_ACTIVITY_TYPE | ACT_DURATION | NUMBER | 22 |
W1_ACTIVITY_TYPE | UOT_FLG | CHAR | 4 |
W1_ASSET | ASSET_AVAILABILITY_FLG* | CHAR | 1 |
W1_AST_DERMS_EVTCTL_CSTHIST | ASSET_AVAILABILITY_FLG* | CHAR | 1 |
W1_CU_CU_USAGE | CU_ID | CHAR | 12 |
W1_CU_CU_USAGE | CU_USAGE_CD | VARCHAR2 | 30 |
W1_CU_CU_USAGE | VERSION | NUMBER | 22 |
W1_OVERHEAD | ADJUSTMENT_TYPE_CD | VARCHAR2 | 30 |
W1_OVERHEAD_RESRC | ADJUSTMENT_TYPE_CD | VARCHAR2 | 30 |
W1_TMPL_ACT | ACT_DURATION | NUMBER | 22 |
W1_TMPL_ACT | UOT_FLG | CHAR | 4 |
Table_Name | Column_Name | New Data Type | Old Precision | New Precision |
W1_BC_LINE | PI_RATIO | NUMBER | 3 | 8 |
Table_Name | Index_Name | Column_Name |
W1_COMPLIANCE_TYPE_CHAR | W1C845S1 | SRCH_CHAR_VAL |
W1_CU | W1M746S3 | ASSET_TYPE_CD |
W1_CU_CU_USAGE | W1M968P0 | CU_ID |
W1_CU_CU_USAGE | W1M968P0 | CU_USAGE_CD |
W1_CU_SET | W1C757S1 | CU_SET_CD |
W1_CU_SET | W1C757S1 | EQUIP_GROUP_CD |
W1_DESIGN_ELEMENT_CHAR | W1M799S1 | SRCH_CHAR_VAL |
W1_DESIGN_ELEMENT_LOG | W1M801S1 | CHAR_TYPE_CD |
W1_DESIGN_ELEMENT_LOG | W1M801S1 | CHAR_VAL_FK1 |
W1_DESIGN_ELEMENT_LOG | W1M801S2 | CHAR_TYPE_CD |
W1_DESIGN_ELEMENT_LOG | W1M801S2 | CHAR_VAL |
W1_EQUIP_GROUP | W1C768S1 | CU_CATEGORY_CD |
W1_FT | W1T312S1 | ACT_ID |
W1_PR_HDR | W1T434S6 | BUYER_CD |
W1_WORK_DESIGN_CHAR | W1M790S1 | SRCH_CHAR_VAL |
W1_WORK_DESIGN_LOG | W1M792S1 | CHAR_TYPE_CD |
W1_WORK_DESIGN_LOG | W1M792S1 | CHAR_VAL_FK1 |
W1_WORK_DESIGN_LOG | W1M792S2 | CHAR_TYPE_CD |
W1_WORK_DESIGN_LOG | W1M792S2 | CHAR_VAL |