Table | Name | Description |
W1_AST_DERMS_EVTCTL_CSTHIST* | Asset DERMS Event Control History | Used to store the control score history for an asset. |
W1_DESIGN_ELEMENT_CHKLST_TYP | Design Element Checklist Type | Used to store General and Permit Required Checklist Types against the Design Element to be created when a Template Construction Work Order creates a Construction Activity. |
W1_DESIGN_ELEMENT_DEP | Design Element Dependency | Used to store Construction Activity Dependencies against the Design Element to be created when a Template Construction Work Order creates a Construction Activity. The Dependencies would need to be within the Template Construction Activities of the same Template Construction Work Order. |
Table_Name | Column_Name | Data Type | Data Length |
W1_ASSET | CST_SCORE* | NUMBER | 22 |
W1_ASSET | CST_SCR_DTTM* | DATE | 7 |
W1_AST_DERMS_EVTCTL_CSTHIST | ASSET_ID* | CHAR | 48 |
W1_AST_DERMS_EVTCTL_CSTHIST | CST_SCORE* | NUMBER | 22 |
W1_AST_DERMS_EVTCTL_CSTHIST | VERSION* | NUMBER | 22 |
W1_AST_DERMS_EVTCTL_CSTHIST | W1_DYN_OPT_EVENT_ID* | CHAR | 56 |
W1_DESIGN_ELEMENT | ACT_TYPE_CD | VARCHAR2 | 120 |
W1_DESIGN_ELEMENT | PLANNER_CD | VARCHAR2 | 120 |
W1_DESIGN_ELEMENT | SERVICE_CLASS_CD | VARCHAR2 | 120 |
W1_DESIGN_ELEMENT | W1_CREW_ID | CHAR | 48 |
W1_DESIGN_ELEMENT | WORK_CATEGORY_CD | VARCHAR2 | 120 |
W1_DESIGN_ELEMENT | WORK_CLASS_CD | VARCHAR2 | 120 |
W1_DESIGN_ELEMENT | WORK_PRIORITY_FLG | CHAR | 16 |
W1_DESIGN_ELEMENT_CHKLST_TYP | CHECKLIST_TYPE_CD | VARCHAR2 | 120 |
W1_DESIGN_ELEMENT_CHKLST_TYP | DESIGN_ELEMENT_ID | CHAR | 48 |
W1_DESIGN_ELEMENT_CHKLST_TYP | VERSION | NUMBER | 22 |
W1_DESIGN_ELEMENT_DEP | DESIGN_ELEMENT_ID | CHAR | 48 |
W1_DESIGN_ELEMENT_DEP | PRED_DESIGN_ELEMENT_ID | CHAR | 48 |
W1_DESIGN_ELEMENT_DEP | RESOURCE_OPTION_FLG | CHAR | 16 |
W1_DESIGN_ELEMENT_DEP | TIMING_OPTION_FLG | CHAR | 16 |
W1_DESIGN_ELEMENT_DEP | VERSION | NUMBER | 22 |
W1_DESIGN_ELEMENT_DEP | W1_MAX_OFFSET | NUMBER | 22 |
W1_DESIGN_ELEMENT_DEP | W1_MIN_OFFSET | NUMBER | 22 |
W1_STOCK_ITEM_DTL | ORDER_ON_DEMAND_FLG | CHAR | 16 |
W1_SVC_HIST | W1_DYN_OPT_EVENT_ID* | CHAR | 56 |
W1_WORK_DESIGN | W1_CREW_ID | CHAR | 48 |
W1_WORK_DESIGN | WD_SUBCLASS_FLG | CHAR | 16 |
W1_WORK_DESIGN | WORK_CATEGORY_CD | VARCHAR2 | 120 |
W1_WORK_DESIGN | WORK_CLASS_CD | VARCHAR2 | 120 |
W1_WORK_DESIGN | WORK_PRIORITY_FLG | CHAR | 16 |
W1_WORK_DESIGN | WO_BUS_OBJ_CD | VARCHAR2 | 120 |
Table_Name | Index_Name | Column_Name |
W1_ACT_CONSTR_LOC | W1T780S1 | ACT_ID |
W1_APPROVAL_PROF | W1C556S1 | BUS_OBJ_CD |
W1_APPROVAL_PROF | W1C556S1 | MAINT_OBJ_CD |
W1_AST_DERMS_EVTCTL_CSTHIST | W1M967P0* | ASSET_ID |
W1_AST_DERMS_EVTCTL_CSTHIST | W1M967P0* | W1_DYN_OPT_EVENT_ID |
W1_DESIGN_ELEMENT_CHKLST_TYP | W1T966P0 | CHECKLIST_TYPE_CD |
W1_DESIGN_ELEMENT_CHKLST_TYP | W1T966P0 | DESIGN_ELEMENT_ID |
W1_DESIGN_ELEMENT_DEP | W1T965P0 | DESIGN_ELEMENT_ID |
W1_DESIGN_ELEMENT_DEP | W1T965P0 | PRED_DESIGN_ELEMENT_ID |
W1_EMPLOYEE | W1M500S5 | EMPLOYEE_USER_ID |
W1_EMPLOYEE | W1M500S6 | SUPERVISOR_ID |
W1_RR | W1T405S2 | STOCK_ITEM_DTL_ID |
W1_TIMEKEEPER | W1C948S1 | USER_ID |