Module: Work Asset Analytics
Type: Dimension
ASSET_ORG_NODE_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| ASSET_ORG_NODE_ID | VARCHAR2 | 12 | True | Asset Location/Organization | |||
| SOURCE_RECORD_ID | VARCHAR2 | 12 | Source Record Id | ||||
| ADDRESS1 | VARCHAR2 | 254 | Address | ||||
| ADDRESS2 | VARCHAR2 | 254 | Address 2 | ||||
| ADDRESS3 | VARCHAR2 | 254 | Address 3 | ||||
| ADDRESS4 | VARCHAR2 | 254 | Address 4 | ||||
| ASSET_LOCATION_DESCR100 | VARCHAR2 | 100 | Asset Location Description | ||||
| BACK_LOG_GRP_FLG | VARCHAR2 | 4 | Backlog Group | ||||
| BUILDING | VARCHAR2 | 100 | Building | ||||
| BUYER_CD | VARCHAR2 | 30 | Buyer | ||||
| CITY | VARCHAR2 | 90 | City | ||||
| COUNTRY | VARCHAR2 | 3 | Country | ||||
| COUNTY | VARCHAR2 | 90 | County | ||||
| CRITICALITY_FLG | VARCHAR2 | 4 | Criticality | ||||
| GEO_CODE | VARCHAR2 | 11 | Geographical Code | ||||
| HOUSE_TYPE | VARCHAR2 | 2 | House Type | ||||
| INST_ASSET_REL_FLG | VARCHAR2 | 4 | Installed Asset Relationship | ||||
| IN_CITY_LIMIT | VARCHAR2 | 1 | In City Limit | ||||
| MAINTMGR_CD | VARCHAR2 | 30 | Maintenance Manager | ||||
| MAINT_MGR_STATUS_CD | VARCHAR2 | 12 | Maintenance Manager Status | ||||
| NODE_CLASS_FLG | VARCHAR2 | 4 | Asset Location/Organization Class | ||||
| NODE_DPOS_FLG | VARCHAR2 | 4 | Asset Location/Organization Disposition | ||||
| NODE_SUBCLASS_FLG | VARCHAR2 | 4 | Subclass | ||||
| NODE_TYPE_CD | VARCHAR2 | 30 | Location/Organization Type | ||||
| NOT_INST_ASSET_REL_FLG | VARCHAR2 | 4 | Not Installed Asset Relationship | ||||
| PARENT_NODE_ID | VARCHAR2 | 12 | Parent Location/Organization | ||||
| POSITION | VARCHAR2 | 30 | Position | ||||
| POSTAL | VARCHAR2 | 12 | Postal | ||||
| RCM_SYSTEM_FLG | VARCHAR2 | 4 | RCM System | ||||
| ROOM | VARCHAR2 | 30 | Room | ||||
| RUN_TO_FAILURE_FLG | VARCHAR2 | 4 | Run To Failure | ||||
| SERVICE_AREA_CD | VARCHAR2 | 30 | Service Area | ||||
| SERVICE_COND_FLG | VARCHAR2 | 254 | Service Condition | ||||
| STATE | VARCHAR2 | 6 | State | ||||
| W1_CROSS_STREET | VARCHAR2 | 64 | Cross Street | ||||
| W1_SUBURB | VARCHAR2 | 64 | Suburb | ||||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |