Table | Name | Description |
W1_ASSET_TYPE_SPEC_ATTRIBUTE | Asset Type Specification Attribute | Used to capture attributes for asset type specifications. |
W1_NODE_ATTRIBUTE | Location Attribute | Used to capture attributes for locations. |
W1_NODE_TYPE_ATTRIBUTE | Location Type Attributes | Used to capture attributes for location types. |
W1_SPECIFICATION_ATTRIBUTE | Specification Attribute | Used to capture attributes for specifications. |
Table_Name | Column_Name | Data Type | Data Length |
W1_ACTIVITY | PERCENT_COMPLETE | NUMBER | 22 |
W1_ASSET | ADDITIONAL_COST | NUMBER | 22 |
W1_ASSET | ERP_PRJ_NUM | VARCHAR2 | 60 |
W1_ASSET | ERP_SUB_PRJ_NUM | VARCHAR2 | 60 |
W1_ASSET | MEMBER_ASSET_FLG | CHAR | 4 |
W1_ASSET_TYPE_SPEC_ATTRIBUTE | ASSET_TYPE_CD | VARCHAR2 | 30 |
W1_ASSET_TYPE_SPEC_ATTRIBUTE | CHAR_TYPE_CD | CHAR | 8 |
W1_ASSET_TYPE_SPEC_ATTRIBUTE | VERSION | NUMBER | 22 |
W1_NODE_ATTRIBUTE | ADHOC_CHAR_VAL | VARCHAR2 | 254 |
W1_NODE_ATTRIBUTE | CHAR_TYPE_CD | CHAR | 8 |
W1_NODE_ATTRIBUTE | CHAR_VAL | CHAR | 16 |
W1_NODE_ATTRIBUTE | CHAR_VAL_FK1 | VARCHAR2 | 50 |
W1_NODE_ATTRIBUTE | CHAR_VAL_FK2 | VARCHAR2 | 50 |
W1_NODE_ATTRIBUTE | CHAR_VAL_FK3 | VARCHAR2 | 50 |
W1_NODE_ATTRIBUTE | CHAR_VAL_FK4 | VARCHAR2 | 50 |
W1_NODE_ATTRIBUTE | CHAR_VAL_FK5 | VARCHAR2 | 50 |
W1_NODE_ATTRIBUTE | NODE_ID | CHAR | 12 |
W1_NODE_ATTRIBUTE | SEQ_NUM | NUMBER | 22 |
W1_NODE_ATTRIBUTE | SRCH_CHAR_VAL | VARCHAR2 | 50 |
W1_NODE_ATTRIBUTE | VERSION | NUMBER | 22 |
W1_NODE_TYPE_ATTRIBUTE | CHAR_TYPE_CD | CHAR | 8 |
W1_NODE_TYPE_ATTRIBUTE | NODE_TYPE_CD | VARCHAR2 | 30 |
W1_NODE_TYPE_ATTRIBUTE | VERSION | NUMBER | 22 |
W1_SPECIFICATION_ATTRIBUTE | ADHOC_CHAR_VAL | VARCHAR2 | 254 |
W1_SPECIFICATION_ATTRIBUTE | CHAR_TYPE_CD | CHAR | 8 |
W1_SPECIFICATION_ATTRIBUTE | CHAR_VAL | CHAR | 16 |
W1_SPECIFICATION_ATTRIBUTE | CHAR_VAL_FK1 | VARCHAR2 | 50 |
W1_SPECIFICATION_ATTRIBUTE | CHAR_VAL_FK2 | VARCHAR2 | 50 |
W1_SPECIFICATION_ATTRIBUTE | CHAR_VAL_FK3 | VARCHAR2 | 50 |
W1_SPECIFICATION_ATTRIBUTE | CHAR_VAL_FK4 | VARCHAR2 | 50 |
W1_SPECIFICATION_ATTRIBUTE | CHAR_VAL_FK5 | VARCHAR2 | 50 |
W1_SPECIFICATION_ATTRIBUTE | SEQ_NUM | NUMBER | 22 |
W1_SPECIFICATION_ATTRIBUTE | SPECIFICATION_CD | VARCHAR2 | 30 |
W1_SPECIFICATION_ATTRIBUTE | SRCH_CHAR_VAL | VARCHAR2 | 50 |
W1_SPECIFICATION_ATTRIBUTE | VERSION | NUMBER | 22 |
Table_Name | Index_Name |
W1_ASSET_TYPE_SPEC_ATTRIBUTE | W1C972P0 |
W1_ASSET_TYPE_SPEC_ATTRIBUTE | W1C972P0 |
W1_CREW_SHIFT_ACT_SCHED | W1T311S1 |
W1_CREW_SHIFT_ACT_SCHED | W1T311S1 |
W1_NODE_ATTRIBUTE | W1M975P0 |
W1_NODE_ATTRIBUTE | W1M975P0 |
W1_NODE_ATTRIBUTE | W1M975P0 |
W1_NODE_ATTRIBUTE | W1M975S1 |
W1_NODE_ATTRIBUTE | W1M975S2 |
W1_NODE_ATTRIBUTE | W1M975S3 |
W1_NODE_ATTRIBUTE | W1M975S3 |
W1_NODE_ATTRIBUTE | W1M975S4 |
W1_NODE_ATTRIBUTE | W1M975S4 |
W1_NODE_TYPE_ATTRIBUTE | W1C974P0 |
W1_NODE_TYPE_ATTRIBUTE | W1C974P0 |
W1_RESRC_TYPE | W1M555S2 |
W1_SPECIFICATION_ATTRIBUTE | W1C973P0 |
W1_SPECIFICATION_ATTRIBUTE | W1C973P0 |
W1_SPECIFICATION_ATTRIBUTE | W1C973P0 |
W1_SPECIFICATION_ATTRIBUTE | W1C973S1 |
W1_SPECIFICATION_ATTRIBUTE | W1C973S2 |
W1_SPECIFICATION_ATTRIBUTE | W1C973S3 |
W1_SPECIFICATION_ATTRIBUTE | W1C973S3 |
W1_SPECIFICATION_ATTRIBUTE | W1C973S4 |
W1_SPECIFICATION_ATTRIBUTE | W1C973S4 |