DW_EWWA_X_EWDI_WACS_W1_BI_ASSETCOST_F

Asset Cost

Details

Module: Work Asset Analytics

Type: Fact

Key Columns

ASSET_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
ACQUISITION_DT NUMBER 38 0 Acquisition Date
ASSET_COUNT NUMBER 38 0 # Assets
ASSET_ID VARCHAR2 12 True Asset DW_EWWA_X_EWDI_WACS_W1_ASSET_D ASSET_ID
ASSET_LIFE_TO_DT_COST NUMBER 38 2 Asset Life to Date Cost
ASSET_LOC_HIERARCHY_NODE_ID VARCHAR2 38 Asset Location Hierarchy DW_EWWA_X_EWDI_WACS_W1_BI_NODE_HIERARCHY_D LOC_ORG_NODE_ID
AVG_FAIL_REPR_COST NUMBER 38 2 Average Failure Repair Cost
AVG_OUT_REPR_COST NUMBER 38 3 Average Outage Repair Cost
AVG_PAST_3YEARS_COST NUMBER 38 2 Average Annual Asset Maintenance Cost for last 3 years
CORE_CHRG_EXP_DT NUMBER 38 0 Core Charge Expiration Date
IN_SERVICE_DT NUMBER 38 0 In Service Date
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
PAST_12MONTHS_COST NUMBER 38 2 Cost to Maintain Asset Past 12 Months
PAST_13_24MONTHS_COST NUMBER 38 2 Cost to Maintain Asset Past 13-24 Months
PAST_25_36MONTHS_COST NUMBER 38 2 Cost to Maintain Asset Past 25-36 Months
PAST_3YEARS_COST NUMBER 38 2 Cost to Maintain Asset - Past 3 Years
PERCENT_PURCHASE NUMBER 38 2 % Purchase
PREDCTD_WEAR_OUT_DT NUMBER 38 0 Predicted Wear Out Date
TOTAL_CM_MAINT_COST NUMBER 38 2 Total Corrective Maintenance Cost
TOTAL_FAILURE_COUNT NUMBER Total Failure Count
TOTAL_FAIL_REPR_COST NUMBER 38 2 Total Failure Repair Cost
TOTAL_MAINTENANCE_COST NUMBER 38 2 Total Maintenance Cost
TOTAL_PM_MAINT_COST NUMBER 38 2 Total Preventive Maintenance Cost
TOTAL_RENEWAL_COST NUMBER 38 2 Total Renewal Cost
W1_BI_TOTAL_COST NUMBER 38 3 Total Cost