Table | Name | Description |
W1_DESIGN_ELEMENT_PLAN_SH_TYPE | Design Element Planned Service History | Used to capture planned service histories for template construction work activities |
Table_Name | Column_Name | Data Type | Data Length |
W1_DESIGN_ELEMENT | ACT_DURATION | NUMBER | 22 |
W1_DESIGN_ELEMENT | UOT_FLG | CHAR | 4 |
W1_DESIGN_ELEMENT_PLAN_SH_TYPE | DESIGN_ELEMENT_ID | CHAR | 12 |
W1_DESIGN_ELEMENT_PLAN_SH_TYPE | SVC_HIST_TYPE_CD | VARCHAR2 | 30 |
W1_DESIGN_ELEMENT_PLAN_SH_TYPE | SVC_HIST_TYPE_REQ_FLG | CHAR | 4 |
W1_DESIGN_ELEMENT_PLAN_SH_TYPE | VERSION | NUMBER | 22 |
Table_Name | Index_Name | Column_Name |
W1_DESIGN_ELEMENT_PLAN_SH_TYPE | W1T971P0 | DESIGN_ELEMENT_ID |
W1_DESIGN_ELEMENT_PLAN_SH_TYPE | W1T971P0 | SVC_HIST_TYPE_CD |