Module: Work Asset Analytics
Type: Dimension
ASSET_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| ASSET_ID | VARCHAR2 | 12 | True | Asset | |||
| SOURCE_RECORD_ID | VARCHAR2 | 12 | Source Record Id | ||||
| ACQUISITION_COST | NUMBER | 17 | 3 | Acquisition Cost | |||
| ACQUISITION_DT | DATE | 0 | Acquisition Date | ||||
| ASSET_CAT_FLG | VARCHAR2 | 4 | Asset Category | ||||
| ASSET_CLASS_FLG | VARCHAR2 | 4 | Asset Class | ||||
| ASSET_COND_FLG | VARCHAR2 | 4 | Asset Condition | ||||
| ASSET_DESCRLONG | VARCHAR2 | 4000 | Asset Detailed Description | ||||
| ASSET_OWNERSHIP_FLG | VARCHAR2 | 4 | Asset Ownership | ||||
| ASSET_TYPE_CD | VARCHAR2 | 30 | Asset Type | ||||
| ASTTYPE_AVG_OUT_REPR_COST | NUMBER | 17 | 3 | Asttype Avg Out Repr Cost | |||
| ASTTYPE_DISPOSAL_COST | NUMBER | 17 | 3 | Asttype Disposal Cost | |||
| ASTTYPE_HOURLY_OUT_COST | NUMBER | 17 | 3 | Asttype Hourly Out Cost | |||
| ASTTYPE_REPLACEMENT_COST | NUMBER | 17 | 3 | Asttype Replacement Cost | |||
| ASTTYPE_SALVAGE_COST | NUMBER | 17 | 3 | Asttype Salvage Cost | |||
| AST_AVG_OUT_REPR_COST | NUMBER | 17 | 3 | Ast Avg Out Repr Cost | |||
| AST_DISPOSAL_COST | NUMBER | 17 | 3 | Ast Disposal Cost | |||
| AST_HOURLY_OUT_COST | NUMBER | 17 | 3 | Ast Hourly Out Cost | |||
| AST_REPLACEMENT_COST | NUMBER | 17 | 3 | Ast Replacement Cost | |||
| AST_SALVAGE_COST | NUMBER | 17 | 3 | ||||
| BOOK_VALUE | NUMBER | 17 | 3 | Book Value | |||
| BO_STATUS_CD | VARCHAR2 | 12 | Status | ||||
| BO_STATUS_REASON_CD | VARCHAR2 | 30 | Status Reason | ||||
| COMPONENT_REL_FLG | VARCHAR2 | 4 | Component Relationship | ||||
| CONDITION_RATING | NUMBER | 12 | 2 | Condition Rating | |||
| CONFIDENCE_RATING | NUMBER | 3 | 2 | Confidence Rating | |||
| CONTRIBUTED_FLG | VARCHAR2 | 4 | Contributed | ||||
| CORE_CHARGE | NUMBER | 17 | 3 | Core Charge | |||
| CORE_CHRG_EXP_DT | DATE | 0 | Core Charge Expiration Date | ||||
| ECO_LIFE | NUMBER | 4 | 1 | Economic Life (Years) | |||
| IN_SERVICE_DT | DATE | 0 | In Service Date | ||||
| PREDCTD_WEAR_OUT_DT | DATE | 0 | Predicted Wear Out Date | ||||
| PROPERTY_UNIT_CD | VARCHAR2 | 30 | Property Unit | ||||
| SERIAL_NO | VARCHAR2 | 60 | Serial Number | ||||
| SPECIFICATION_CD | VARCHAR2 | 30 | Specification | ||||
| SPEC_ASSET_REL_FLG | VARCHAR2 | 4 | Specification Asset Relationship | ||||
| SPEC_CLASS_FLG | VARCHAR2 | 4 | Specification Class | ||||
| UNIT_PRICE | NUMBER | 18 | 7 | Unit Price | |||
| USEFUL_LIFE | NUMBER | 4 | 1 | Useful Life (Years) | |||
| W1_BI_ID_VALUE | VARCHAR2 | 60 | Badge Number | ||||
| W1_BI_MODEL | VARCHAR2 | 60 | Model Number | ||||
| W1_MANUFACTURER_CD | VARCHAR2 | 30 | Manufacturer | ||||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |