Forecasted Asset Cost
Module: Work Asset Analytics
Type: Fact
ASSET_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| ASSET_ID | VARCHAR2 | 12 | True | Asset | DW_EWWA_X_EWDI_WACS_W1_ASSET_D | ASSET_ID | |
| SOURCE_RECORD_ID | VARCHAR2 | 12 | Source Record Id | ||||
| ACQUISITION_DT | NUMBER | 38 | 0 | Acquisition Date | |||
| ASSET_CNT | NUMBER | 38 | 0 | # Assets | |||
| ASSET_LOC_HIERARCHY_NODE_ID | VARCHAR2 | 38 | Asset Location Hierarchy | DW_EWWA_X_EWDI_WACS_W1_BI_NODE_HIERARCHY_D | LOC_ORG_NODE_ID | ||
| COST_NEXT_10_YRS | NUMBER | 38 | 2 | Forecasted PM Cost for next 10 years | |||
| COST_NEXT_2_YRS | NUMBER | 38 | 2 | Forecasted PM Cost for next 2 years | |||
| COST_NEXT_5_YRS | NUMBER | 38 | 2 | Forecasted PM Cost for next 5 years | |||
| COST_NEXT_YR | NUMBER | 38 | 2 | Forecasted PM Cost for next 1 year | |||
| COST_REMAIN_LIFE | NUMBER | 38 | 2 | Forecasted PM Cost for Asset's Remaining Life | |||
| EQUIP_COST_NEXT_10_YRS | NUMBER | 38 | 2 | Forecasted PM Equipment Costs for next 10 years | |||
| EQUIP_COST_NEXT_2_YRS | NUMBER | 38 | 2 | Forecasted PM Equipment Costs for next 2 years | |||
| EQUIP_COST_NEXT_5_YRS | NUMBER | 38 | 2 | Forecasted PM Equipment Costs for next 5 years | |||
| EQUIP_COST_NEXT_YR | NUMBER | 38 | 2 | Forecasted PM Equipment Costs for next 1 year | |||
| EQUIP_COST_REMAIN_LIFE | NUMBER | 38 | 2 | Forecasted PM Equipment Costs for Asset's Remaining Life | |||
| IN_SERVICE_DT | NUMBER | 38 | 0 | In Service Date | |||
| LABOR_COST_NEXT_10_YRS | NUMBER | 38 | 2 | Forecasted PM Labor Costs for next 10 years | |||
| LABOR_COST_NEXT_2_YRS | NUMBER | 38 | 2 | Forecasted PM Labor Costs for next 2 years | |||
| LABOR_COST_NEXT_5_YRS | NUMBER | 38 | 2 | Forecasted PM Labor Costs for next 5 years | |||
| LABOR_COST_NEXT_YR | NUMBER | 38 | 2 | Forecasted PM Labor Costs for next 1 year | |||
| LABOR_COST_REMAIN_LIFE | NUMBER | 38 | 2 | Forecasted PM Labor Costs for Asset's Remaining Life | |||
| MATL_COST_NEXT_10_YRS | NUMBER | 38 | 2 | Forecasted PM Material Costs for next 10 years | |||
| MATL_COST_NEXT_2_YRS | NUMBER | 38 | 2 | Forecasted PM Material Costs for next 2 years | |||
| MATL_COST_NEXT_5_YRS | NUMBER | 38 | 2 | Forecasted PM Material Costs for next 5 years | |||
| MATL_COST_NEXT_YR | NUMBER | 38 | 2 | Forecasted PM Material Costs for next 1 year | |||
| MATL_COST_REMAIN_LIFE | NUMBER | 38 | 2 | Forecasted PM Material Costs for Asset's Remaining Life | |||
| MISC_COST_NEXT_10_YRS | NUMBER | 38 | 2 | Forecasted PM Misc Costs for next 10 years | |||
| MISC_COST_NEXT_2_YRS | NUMBER | 38 | 2 | Forecasted PM Misc Costs for next 2 years | |||
| MISC_COST_NEXT_5_YRS | NUMBER | 38 | 2 | Forecasted PM Misc Costs for next 5 years | |||
| MISC_COST_NEXT_YR | NUMBER | 38 | 2 | Forecasted PM Misc Costs for next 1 year | |||
| MISC_COST_REMAIN_LIFE | NUMBER | 38 | 2 | Forecasted PM Misc Costs for Asset's Remaining Life | |||
| NODE_ID | VARCHAR2 | 38 | Asset Location | DW_EWWA_X_EWDI_WACS_W1_NODE_D | ASSET_ORG_NODE_ID | ||
| OWNING_ACCESS_GRP_CD | VARCHAR2 | 38 | Owning Organization | ||||
| PREDCTD_WEAR_OUT_DT | NUMBER | 38 | 0 | Predicted Wear Out Date | |||
| REMAIN_LIFE_YRS | NUMBER | 38 | 1 | Remaining Life | |||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |