{
 "currentVersion": 10.61,
 "id": 97,
 "name": "TB_WRF_Valve",
 "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": "ValveType",
   "type": "esriFieldTypeString",
   "alias": "Valve Type",
   "length": 22,
   "domain": {
    "type": "codedValue",
    "name": "gValveType_3",
    "description": "Valve Type",
    "codedValues": [
     {
      "name": "3-Way",
      "code": "3-Way"
     },
     {
      "name": "Air Relief",
      "code": "Air Relief"
     },
     {
      "name": "Altitude",
      "code": "Altitude"
     },
     {
      "name": "Ball",
      "code": "Ball"
     },
     {
      "name": "Butterfly",
      "code": "Butterfly"
     },
     {
      "name": "Check",
      "code": "Check"
     },
     {
      "name": "Cone",
      "code": "Cone"
     },
     {
      "name": "Corporation Stop",
      "code": "Corporation Stop"
     },
     {
      "name": "Diverter",
      "code": "Diverter"
     },
     {
      "name": "Double Check",
      "code": "Double Check"
     },
     {
      "name": "Draw-Off",
      "code": "Draw-Off"
     },
     {
      "name": "Eccentric Plug",
      "code": "Eccentric Plug"
     },
     {
      "name": "Flange",
      "code": "Flange"
     },
     {
      "name": "Float",
      "code": "Float"
     },
     {
      "name": "Gate",
      "code": "Gate"
     },
     {
      "name": "Globe",
      "code": "Globe"
     },
     {
      "name": "Knife",
      "code": "Knife"
     },
     {
      "name": "Mud",
      "code": "Mud"
     },
     {
      "name": "Pinch",
      "code": "Pinch"
     },
     {
      "name": "Plug",
      "code": "Plug"
     },
     {
      "name": "Post Indicator",
      "code": "Post Indicator"
     },
     {
      "name": "Pressure Reducing",
      "code": "Pressure Reducing"
     },
     {
      "name": "Pressure Regulating",
      "code": "Pressure Regulating"
     },
     {
      "name": "Rotary Air Lock",
      "code": "Rotary Air Lock"
     },
     {
      "name": "Surge Relief",
      "code": "Surge Relief"
     },
     {
      "name": "Yard Hydrant",
      "code": "Yard Hydrant"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "ValveFunction",
   "type": "esriFieldTypeString",
   "alias": "Valve Function",
   "length": 18,
   "domain": {
    "type": "codedValue",
    "name": "gValveFunc_2",
    "description": "Valve Function",
    "codedValues": [
     {
      "name": "Blow-Off",
      "code": "Blow-Off"
     },
     {
      "name": "By-Pass",
      "code": "By-Pass"
     },
     {
      "name": "Back Wash",
      "code": "Back Wash"
     },
     {
      "name": "Drain",
      "code": "Drain"
     },
     {
      "name": "Flow Control",
      "code": "Flow Control"
     },
     {
      "name": "Filter to Waste",
      "code": "Filter to Waste"
     },
     {
      "name": "Isolation",
      "code": "Isolation"
     },
     {
      "name": "Level Control",
      "code": "Level Control"
     },
     {
      "name": "Pressure Zone",
      "code": "Pressure Zone"
     },
     {
      "name": "Relief",
      "code": "Relief"
     },
     {
      "name": "Hydrant",
      "code": "Hydrant"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Diameter",
   "type": "esriFieldTypeDouble",
   "alias": "Diameter in IN",
   "domain": null
  },
  {
   "name": "OpenDirec",
   "type": "esriFieldTypeString",
   "alias": "Operational Direction",
   "length": 14,
   "domain": {
    "type": "codedValue",
    "name": "gValveOpDir",
    "description": "Valve Operational Direction",
    "codedValues": [
     {
      "name": "Open Left",
      "code": "Open Left"
     },
     {
      "name": "Open Right",
      "code": "Open Right"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "TurnsReq",
   "type": "esriFieldTypeDouble",
   "alias": "Turns Required",
   "domain": null
  },
  {
   "name": "OperStatus",
   "type": "esriFieldTypeString",
   "alias": "Operational Status",
   "length": 18,
   "domain": {
    "type": "codedValue",
    "name": "gValveOpStatus",
    "description": "Valve Normal Operational Status",
    "codedValues": [
     {
      "name": "Normally Closed",
      "code": "Normally Closed"
     },
     {
      "name": "Modulated",
      "code": "Modulated"
     },
     {
      "name": "Normally Open",
      "code": "Normally Open"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Actuated",
   "type": "esriFieldTypeString",
   "alias": "Actuated?",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "gYesNo",
    "description": "Yes/No",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "CutInPress",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Cut In Pressure in PSI",
   "domain": null
  },
  {
   "name": "CutOutPress",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Cut Out Pressure in PSI",
   "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": "ActAssetID",
   "type": "esriFieldTypeString",
   "alias": "Actuator Asset ID",
   "length": 50,
   "domain": null
  },
  {
   "name": "ActLegacyID",
   "type": "esriFieldTypeString",
   "alias": "Actuator Legacy ID",
   "length": 30,
   "domain": null
  },
  {
   "name": "ActInstallDate",
   "type": "esriFieldTypeDate",
   "alias": "Actuator Install Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "ActWarrantyDate",
   "type": "esriFieldTypeDate",
   "alias": "Actuator Warranty Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "ActStatus",
   "type": "esriFieldTypeString",
   "alias": "Actuator Lifecycle Status",
   "length": 20,
   "domain": null
  },
  {
   "name": "ActProjectNum",
   "type": "esriFieldTypeString",
   "alias": "Actuator Project Number",
   "length": 30,
   "domain": null
  },
  {
   "name": "ActNotes",
   "type": "esriFieldTypeString",
   "alias": "Actuator Notes",
   "length": 256,
   "domain": null
  },
  {
   "name": "ActAssetCost",
   "type": "esriFieldTypeDouble",
   "alias": "Actuator Asset Cost",
   "domain": null
  },
  {
   "name": "ActReplaceCost",
   "type": "esriFieldTypeDouble",
   "alias": "Actuator Replacement Cost",
   "domain": null
  },
  {
   "name": "ActCondition",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Actuator Condition",
   "domain": null
  },
  {
   "name": "ActConditionDate",
   "type": "esriFieldTypeDate",
   "alias": "Actuator Condition Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "ActRehabDate",
   "type": "esriFieldTypeDate",
   "alias": "Actuator Last Rehab Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "ActLifeExpectancy",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Actuator Life Expectancy in Yrs",
   "domain": null
  },
  {
   "name": "ActRemUseLife",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Actuator Remaining Useful Life in Yrs",
   "domain": null
  },
  {
   "name": "ActCOF",
   "type": "esriFieldTypeDouble",
   "alias": "Actuator Consequence of Failure",
   "domain": null
  },
  {
   "name": "ActPOF",
   "type": "esriFieldTypeDouble",
   "alias": "Actuator Probability of Failure",
   "domain": null
  },
  {
   "name": "ActBRE",
   "type": "esriFieldTypeDouble",
   "alias": "Actuator Business Risk Exposure",
   "domain": null
  },
  {
   "name": "ActManufacturer",
   "type": "esriFieldTypeString",
   "alias": "Actuator Manufacturer",
   "length": 50,
   "domain": null
  },
  {
   "name": "ActModel",
   "type": "esriFieldTypeString",
   "alias": "Actuator Model",
   "length": 25,
   "domain": null
  },
  {
   "name": "ActModelYear",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Actuator Model Year",
   "domain": null
  },
  {
   "name": "ActSerialNumber",
   "type": "esriFieldTypeString",
   "alias": "Actuator Serial Number",
   "length": 25,
   "domain": null
  },
  {
   "name": "ActuatorType",
   "type": "esriFieldTypeString",
   "alias": "Actuator Actuator Type",
   "length": 18,
   "domain": null
  },
  {
   "name": "MotorSpeed",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Actuator Motor Speed in RPM",
   "domain": null
  },
  {
   "name": "OpSpeed",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Actuator Operating Speed in Seconds",
   "domain": null
  },
  {
   "name": "Volts",
   "type": "esriFieldTypeInteger",
   "alias": "Actuator Voltage",
   "domain": null
  },
  {
   "name": "Amps",
   "type": "esriFieldTypeDouble",
   "alias": "Actuator Amperage",
   "domain": null
  },
  {
   "name": "Weight",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Actuator Weight in LB",
   "domain": null
  },
  {
   "name": "ShaftDiam",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Actuator Shaft Diameter",
   "domain": null
  },
  {
   "name": "FrameNum",
   "type": "esriFieldTypeString",
   "alias": "Actuator Frame Number",
   "length": 10,
   "domain": null
  },
  {
   "name": "Torque",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Actuator Torque in FT - LBS",
   "domain": null
  },
  {
   "name": "ActAssetName",
   "type": "esriFieldTypeString",
   "alias": "Actuator Asset Name (Equipment No.)",
   "length": 50,
   "domain": null
  },
  {
   "name": "ActImage",
   "type": "esriFieldTypeString",
   "alias": "Actuator 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
  }
 ],
 "indexes": [
  {
   "name": "R551_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "UUID_551",
   "fields": "GlobalID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "G1161ParentID",
   "fields": "ParentID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "UUID_OID_551",
   "fields": "GlobalID,OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 93,
   "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
}