{ "currentVersion": 10.61, "id": 69, "name": "TB_WRF_Motor", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "AssetID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "length": 50, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "length": 30, "domain": null }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Location", "length": 130, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location Details", "length": 256, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "length": 20, "domain": { "type": "codedValue", "name": "gStatus", "description": "Lifecycle Status", "codedValues": [ { "name": "Permitted", "code": "Permitted" }, { "name": "In Service", "code": "In Service" }, { "name": "Not In Service", "code": "Not In Service" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ProcessArea", "type": "esriFieldTypeString", "alias": "Process Area", "length": 3, "domain": { "type": "codedValue", "name": "gProcessArea_3", "description": "Process Area", "codedValues": [ { "name": "M00", "code": "M00" }, { "name": "M01", "code": "M01" }, { "name": "M02", "code": "M02" }, { "name": "M03", "code": "M03" }, { "name": "M04", "code": "M04" }, { "name": "M05", "code": "M05" }, { "name": "M06", "code": "M06" }, { "name": "M07", "code": "M07" }, { "name": "M08", "code": "M08" }, { "name": "M09", "code": "M09" }, { "name": "M10", "code": "M10" }, { "name": "M11", "code": "M11" }, { "name": "M12", "code": "M12" }, { "name": "M13", "code": "M13" }, { "name": "M14", "code": "M14" }, { "name": "M16", "code": "M16" }, { "name": "M17", "code": "M17" }, { "name": "M18", "code": "M18" }, { "name": "M19", "code": "M19" }, { "name": "M21", "code": "M21" }, { "name": "M22", "code": "M22" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Process", "type": "esriFieldTypeString", "alias": "Process", "length": 100, "domain": { "type": "codedValue", "name": "gProcess_3", "description": "Process", "codedValues": [ { "name": "M00 Preaeration Basins Odor Control", "code": "M00 Preaeration Basins Odor Control" }, { "name": "M01 Equalization Basins", "code": "M01 Equalization Basins" }, { "name": "M01 Fuel Unloading", "code": "M01 Fuel Unloading" }, { "name": "M01 Pretreatment", "code": "M01 Pretreatment" }, { "name": "M02 Primary Pump Station Primary Clarifiers 1 through 5", "code": "M02 Primary Pump Station Primary Clarifiers 1 through 5" }, { "name": "M03 Blower Building Aeration Basins", "code": "M03 Blower Building Aeration Basins" }, { "name": "M04 Secondary Clarifiers 1 through 9 Return Activated Sludge Pumping Stations 1 and 2", "code": "M04 Secondary Clarifiers 1 through 9 Return Activated Sludge Pumping Stations 1 and 2" }, { "name": "M05 Denitrification Filters 1 through 24", "code": "M05 Denitrification Filters 1 through 24" }, { "name": "M06 Administration Building Old", "code": "M06 Administration Building Old" }, { "name": "M07 Generator and Electrical Distribution", "code": "M07 Generator and Electrical Distribution" }, { "name": "M08 Lime Handling Lime Tower", "code": "M08 Lime Handling Lime Tower" }, { "name": "M09 Control and Process Building", "code": "M09 Control and Process Building" }, { "name": "M10 Plant Wastewater Pump Station", "code": "M10 Plant Wastewater Pump Station" }, { "name": "M11 Grubbs Admin and Lab", "code": "M11 Grubbs Admin and Lab" }, { "name": "M12 Thickeners 1 and 2 Thickened Sludge Pump Station 1", "code": "M12 Thickeners 1 and 2 Thickened Sludge Pump Station 1" }, { "name": "M12 Thickeners 3 and 4 Thickened Sludge Pump Station 2", "code": "M12 Thickeners 3 and 4 Thickened Sludge Pump Station 2" }, { "name": "M13 Outside of Process Areas", "code": "M13 Outside of Process Areas" }, { "name": "M14 Operations Support Facility Maintenance", "code": "M14 Operations Support Facility Maintenance" }, { "name": "M16 Incinerator", "code": "M16 Incinerator" }, { "name": "M17 Dewatering Equipment Solids Building", "code": "M17 Dewatering Equipment Solids Building" }, { "name": "M18 Sludge Holding Tanks 1 and 4", "code": "M18 Sludge Holding Tanks 1 and 4" }, { "name": "M19 Ash Settling Basins Ash Cover", "code": "M19 Ash Settling Basins Ash Cover" }, { "name": "M21 Methanol Building", "code": "M21 Methanol Building" }, { "name": "M22 Ultraviolet Disinfection Process Water Pumps Final Flow Meter Effluent Cascade", "code": "M22 Ultraviolet Disinfection Process Water Pumps Final Flow Meter Effluent Cascade" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ProjectNum", "type": "esriFieldTypeString", "alias": "Project Number", "length": 30, "domain": null }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 256, "domain": null }, { "name": "ParentID", "type": "esriFieldTypeString", "alias": "Parent ID", "length": 25, "domain": null }, { "name": "AssetCost", "type": "esriFieldTypeDouble", "alias": "Asset Cost", "domain": null }, { "name": "ReplaceCost", "type": "esriFieldTypeDouble", "alias": "Replacement Cost", "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "length": 8, "domain": null }, { "name": "RehabDate", "type": "esriFieldTypeDate", "alias": "Last Rehab Date", "length": 8, "domain": null }, { "name": "LifeExpectancy", "type": "esriFieldTypeSmallInteger", "alias": "Life Expectancy in Yrs", "domain": null }, { "name": "RemUseLife", "type": "esriFieldTypeSmallInteger", "alias": "Remaining Useful Life in Yrs", "domain": null }, { "name": "COF", "type": "esriFieldTypeDouble", "alias": "Consequence of Failure", "domain": null }, { "name": "POF", "type": "esriFieldTypeDouble", "alias": "Probability of Failure", "domain": null }, { "name": "BRE", "type": "esriFieldTypeDouble", "alias": "Business Risk Exposure", "domain": null }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 50, "domain": null }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "length": 25, "domain": null }, { "name": "ModelYear", "type": "esriFieldTypeSmallInteger", "alias": "Model Year", "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "Serial Number", "length": 25, "domain": null }, { "name": "LubeType", "type": "esriFieldTypeString", "alias": "Lubrication Type", "length": 20, "domain": { "type": "codedValue", "name": "gLubeType", "description": "Lubrication Type", "codedValues": [ { "name": "Food Grade Grease", "code": "Food Grade Grease" }, { "name": "Food Grade Oil", "code": "Food Grade Oil" }, { "name": "Grease", "code": "Grease" }, { "name": "Oil", "code": "Oil" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Speed", "type": "esriFieldTypeSmallInteger", "alias": "Speed in RPM", "domain": null }, { "name": "Efficiency", "type": "esriFieldTypeString", "alias": "Efficiency Class", "length": 3, "domain": { "type": "codedValue", "name": "gMotorEffClass", "description": "Motor Efficiency Class", "codedValues": [ { "name": "IE1", "code": "IE1" }, { "name": "IE2", "code": "IE2" }, { "name": "IE3", "code": "IE3" }, { "name": "IE4", "code": "IE4" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "NEMAType", "type": "esriFieldTypeString", "alias": "NEMA Type", "length": 68, "domain": { "type": "codedValue", "name": "gNEMARating", "description": "NEMA Rating", "codedValues": [ { "name": "1 General Purpose Primarily Prevents Contact with Live Parts", "code": "1 General Purpose Primarily Prevents Contact with Live Parts" }, { "name": "2 Drip Tight", "code": "2 Drip Tight" }, { "name": "5 Dust Tight", "code": "5 Dust Tight" }, { "name": "7 Hazardous Indoor Class I, Groups A, B, C, and D NEC", "code": "7 Hazardous Indoor Class I, Groups A, B, C, and D NEC" }, { "name": "8 Hazardous Indoor/Outdoor Class I, Groups A, B, C, and D NEC", "code": "8 Hazardous Indoor/Outdoor Class I, Groups A, B, C, and D NEC" }, { "name": "9 Hazardous Indoor/Outdoor Class II, Groups E, F, and G NEC", "code": "9 Hazardous Indoor/Outdoor Class II, Groups E, F, and G NEC" }, { "name": "11 General Purpose Indoor Corrosive Effects Liquids and Gases", "code": "11 General Purpose Indoor Corrosive Effects Liquids and Gases" }, { "name": "13 General Purpose Spraying Water, Oil, and Noncorrosive Coolants", "code": "13 General Purpose Spraying Water, Oil, and Noncorrosive Coolants" }, { "name": "12/12K General Purpose Indoor Noncorrosive Liquids", "code": "12/12K General Purpose Indoor Noncorrosive Liquids" }, { "name": "3/3S Weather Resistant", "code": "3/3S Weather Resistant" }, { "name": "3R Outdoor Use", "code": "3R Outdoor Use" }, { "name": "4/4X Watertight (Weatherproof)", "code": "4/4X Watertight (Weatherproof)" }, { "name": "6/6P Submersible", "code": "6/6P Submersible" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Volts", "type": "esriFieldTypeInteger", "alias": "Voltage", "domain": { "type": "codedValue", "name": "gVolts_3", "description": "Voltage", "codedValues": [ { "name": "6", "code": 6 }, { "name": "12", "code": 12 }, { "name": "24", "code": 24 }, { "name": "48", "code": 48 }, { "name": "90", "code": 90 }, { "name": "120", "code": 120 }, { "name": "208", "code": 208 }, { "name": "240", "code": 240 }, { "name": "480", "code": 480 }, { "name": "600", "code": 600 }, { "name": "1200", "code": 1200 }, { "name": "2300", "code": 2300 }, { "name": "2400", "code": 2400 }, { "name": "4160", "code": 4160 }, { "name": "7200", "code": 7200 }, { "name": "14400", "code": 14400 }, { "name": "15000", "code": 15000 }, { "name": "34500", "code": 34500 }, { "name": "69000", "code": 69000 }, { "name": "138000", "code": 138000 }, { "name": "460", "code": 460 }, { "name": "230/460", "code": 230460 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Amps", "type": "esriFieldTypeDouble", "alias": "Amperage", "domain": null }, { "name": "Hertz", "type": "esriFieldTypeSmallInteger", "alias": "Hertz", "domain": null }, { "name": "Phase", "type": "esriFieldTypeString", "alias": "Phase", "length": 12, "domain": { "type": "codedValue", "name": "gElecPhase", "description": "Electrical Phase", "codedValues": [ { "name": "Single Phase", "code": "Single Phase" }, { "name": "Three Phase", "code": "Three Phase" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "kVACode", "type": "esriFieldTypeString", "alias": "kVA Code", "length": 2, "domain": { "type": "codedValue", "name": "gkVACode", "description": "kVA Code", "codedValues": [ { "name": "A", "code": "A" }, { "name": "B", "code": "B" }, { "name": "C", "code": "C" }, { "name": "D", "code": "D" }, { "name": "E", "code": "E" }, { "name": "F", "code": "F" }, { "name": "G", "code": "G" }, { "name": "H", "code": "H" }, { "name": "I", "code": "I" }, { "name": "J", "code": "J" }, { "name": "K", "code": "K" }, { "name": "L", "code": "L" }, { "name": "M", "code": "M" }, { "name": "N", "code": "N" }, { "name": "O", "code": "O" }, { "name": "P", "code": "P" }, { "name": "Q", "code": "Q" }, { "name": "R", "code": "R" }, { "name": "S", "code": "S" }, { "name": "T", "code": "T" }, { "name": "U", "code": "U" }, { "name": "V", "code": "V" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Rotation", "type": "esriFieldTypeString", "alias": "Rotation", "length": 20, "domain": { "type": "codedValue", "name": "gRotation", "description": "Rotation", "codedValues": [ { "name": "Clockwise", "code": "Clockwise" }, { "name": "Counter-Clockwise", "code": "Counter-Clockwise" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Duty", "type": "esriFieldTypeString", "alias": "Duty", "length": 15, "domain": { "type": "codedValue", "name": "gMotorDuty", "description": "Motor Duty", "codedValues": [ { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InsClass", "type": "esriFieldTypeString", "alias": "Insulation Class", "length": 2, "domain": { "type": "codedValue", "name": "gMotorInsClass", "description": "Motor Insulation Class", "codedValues": [ { "name": "A", "code": "A" }, { "name": "B", "code": "B" }, { "name": "F", "code": "F" }, { "name": "H", "code": "H" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Orientation", "type": "esriFieldTypeString", "alias": "Orientation", "length": 15, "domain": { "type": "codedValue", "name": "gMotorOrientation", "description": "Motor Orientation", "codedValues": [ { "name": "Horizontal", "code": "Horizontal" }, { "name": "Vertical", "code": "Vertical" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Horsepower", "type": "esriFieldTypeSmallInteger", "alias": "Horsepower", "domain": null }, { "name": "ShaftDiam", "type": "esriFieldTypeSmallInteger", "alias": "Shaft Diameter", "domain": { "type": "range", "name": "gMotorShaftDiam", "description": "Motor Shaft Diameter", "range": [ 0, 12 ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FrameNum", "type": "esriFieldTypeString", "alias": "Frame Number", "length": 10, "domain": null }, { "name": "FrontBear", "type": "esriFieldTypeString", "alias": "Front Bearings", "length": 3, "domain": { "type": "codedValue", "name": "gYesNo", "description": "Yes/No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RearBear", "type": "esriFieldTypeString", "alias": "Rear Bearings", "length": 3, "domain": { "type": "codedValue", "name": "gYesNo", "description": "Yes/No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OilCapacity", "type": "esriFieldTypeDouble", "alias": "Oil Capacity in QTS", "domain": null }, { "name": "GreaseCapacity", "type": "esriFieldTypeDouble", "alias": "Grease Capacity in QTS", "domain": null }, { "name": "Submersible", "type": "esriFieldTypeString", "alias": "Submersible", "length": 3, "domain": { "type": "codedValue", "name": "gYesNo", "description": "Yes/No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "HollowShaft", "type": "esriFieldTypeString", "alias": "Hollow Shaft", "length": 3, "domain": { "type": "codedValue", "name": "gYesNo", "description": "Yes/No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DriveType", "type": "esriFieldTypeString", "alias": "Drive Type", "length": 17, "domain": { "type": "codedValue", "name": "gDriveType", "description": "Drive Type", "codedValues": [ { "name": "Belt", "code": "Belt" }, { "name": "Chain", "code": "Chain" }, { "name": "Direct Drive", "code": "Direct Drive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GearRatio", "type": "esriFieldTypeString", "alias": "Gear Ratio", "length": 5, "domain": null }, { "name": "Torque", "type": "esriFieldTypeSmallInteger", "alias": "Torque in FT-LBS", "domain": null }, { "name": "BeltSize", "type": "esriFieldTypeSmallInteger", "alias": "Belt Size", "domain": null }, { "name": "AssetName", "type": "esriFieldTypeString", "alias": "Asset Name (Equipment No.)", "length": 50, "domain": null }, { "name": "Image", "type": "esriFieldTypeString", "alias": "Image Name", "length": 100, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "CREATED_BY", "type": "esriFieldTypeString", "alias": "CREATED_BY", "length": 255, "domain": null }, { "name": "CREATED_DATE", "type": "esriFieldTypeDate", "alias": "CREATED_DATE", "length": 8, "domain": null }, { "name": "LAST_EDITED_BY", "type": "esriFieldTypeString", "alias": "LAST_EDITED_BY", "length": 255, "domain": null }, { "name": "LAST_EDITED_DATE", "type": "esriFieldTypeDate", "alias": "LAST_EDITED_DATE", "length": 8, "domain": null }, { "name": "Temp", "type": "esriFieldTypeString", "alias": "Temp", "length": 25, "domain": null } ], "indexes": [ { "name": "R522_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_522", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G1132ParentID", "fields": "ParentID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_522", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 67, "name": "TB_WRF_PositionPoint", "relatedTableId": 102, "role": "esriRelRoleDestination", "keyField": "ParentID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, AMF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }