Name: Pump

Display Field: AssetName

Type: Table

Geometry Type: N/A

Description:

Definition Expression: N/A

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, AMF, geoJSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID , alias: OBJECTID , editable: false , nullable: false )
• AssetID ( type: esriFieldTypeString , alias: Asset ID (Tag) , editable: true , nullable: false , length: 50 )
• AssetName ( type: esriFieldTypeString , alias: Asset Name , editable: true , nullable: true , length: 100 )
• FacilitySiteName ( type: esriFieldTypeString , alias: Facility Site Name , editable: true , nullable: true , length: 100 , Coded Values: [Main Facility: SLCWRRF - Main Facility] , [Influent Pump Station: SLCWRRF - Influent Pump Station] )
• ParentID ( type: esriFieldTypeString , alias: Parent ID , editable: true , nullable: true , length: 50 )
• OrigEquipNumber ( type: esriFieldTypeString , alias: Original Equipment Number , editable: true , nullable: true , length: 30 )
• Type ( type: esriFieldTypeString , alias: Type , editable: true , nullable: true , length: 30 , Coded Values: [Chopper: Chopper] , [Sump: Sump] , [Submersible: Submersible] , ...7 more... )
• Criticality ( type: esriFieldTypeInteger , alias: Criticality , editable: true , nullable: true , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• CriticalityComments ( type: esriFieldTypeString , alias: Criticality Comments , editable: true , nullable: true , length: 255 )
• Condition ( type: esriFieldTypeInteger , alias: Condition , editable: true , nullable: true , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• ConditionComments ( type: esriFieldTypeString , alias: Condition Comments , editable: true , nullable: true , length: 256 )
• StartUpDate ( type: esriFieldTypeDate , alias: Start Up Date , editable: true , nullable: true , length: 8 )
• Location ( type: esriFieldTypeString , alias: Location , editable: true , nullable: true , length: 200 )
• SerialNumber ( type: esriFieldTypeString , alias: Serial Number , editable: true , nullable: true , length: 50 )
• ModelNumber ( type: esriFieldTypeString , alias: Model Number , editable: true , nullable: true , length: 50 )
• Description ( type: esriFieldTypeString , alias: Description , editable: true , nullable: true , length: 255 )
• Manufacturer ( type: esriFieldTypeString , alias: Manufacturer , editable: true , nullable: true , length: 50 )
• Vendor ( type: esriFieldTypeString , alias: Vendor , editable: true , nullable: true , length: 50 )
• WarrantyDate ( type: esriFieldTypeDate , alias: Warranty Date , editable: true , nullable: true , length: 8 )
• OriginalCost ( type: esriFieldTypeDouble , alias: Original Cost , editable: true , nullable: true )
• ReplacementCost ( type: esriFieldTypeDouble , alias: Replacement Cost , editable: true , nullable: true )
• EstimatedLife ( type: esriFieldTypeSmallInteger , alias: Estimated Life , editable: true , nullable: true )
• Process ( type: esriFieldTypeString , alias: Process , editable: true , nullable: true , length: 50 , Coded Values: [Influent Screening: Influent Screening] , [Primary Settling: Primary Settling] , [Secondary Settling: Secondary Settling] , ...16 more... )
• O_MLink ( type: esriFieldTypeString , alias: O&M Link , editable: true , nullable: true , length: 255 )
• CIPName ( type: esriFieldTypeString , alias: CIP Name , editable: true , nullable: true , length: 100 )
• CIPNumber ( type: esriFieldTypeString , alias: CIP Number , editable: true , nullable: true , length: 20 )
• PurchaseDate ( type: esriFieldTypeDate , alias: Purchase Date , editable: true , nullable: true , length: 8 )
• Classification ( type: esriFieldTypeString , alias: Classification , editable: true , nullable: true , length: 50 , Coded Values: [Unclassified: Unclassified] , [Class 1 - Division 1: Class 1 - Division 1] , [Class 1 - Division 2: Class 1 - Division 2] )
• LifecycleStatus ( type: esriFieldTypeString , alias: Lifecycle Status , editable: true , nullable: true , length: 20 , Coded Values: [Active: Active] , [Retired: Retired] , [Removed: Removed] , ...1 more... )
• Service ( type: esriFieldTypeString , alias: Service , editable: true , nullable: true , length: 20 , Coded Values: [In Service: In Service] , [Out of Service: Out of Service] , [Retired: Retired] )
• FlowRate ( type: esriFieldTypeString , alias: Flow Rate (gpm) , editable: true , nullable: true , length: 20 )
• DischargeHead ( type: esriFieldTypeDouble , alias: Discharge Head (ft) , editable: true , nullable: true )
• RPM ( type: esriFieldTypeDouble , alias: RPM , editable: true , nullable: true )
• SuctionDiameter ( type: esriFieldTypeDouble , alias: Suction Diameter (in) , editable: true , nullable: true )
• DischargeDiameter ( type: esriFieldTypeDouble , alias: Discharge Diameter (in) , editable: true , nullable: true )
• SealType ( type: esriFieldTypeString , alias: Seal Type , editable: true , nullable: true , length: 10 , Coded Values: [Mechanical: Mechanical] , [Packing: Packing] )
• NumberStages ( type: esriFieldTypeSmallInteger , alias: Number of Stages , editable: true , nullable: true )
• Lubrication ( type: esriFieldTypeString , alias: Lubrication , editable: true , nullable: true , length: 6 , Coded Values: [Oil: Oil] , [Grease: Grease] )
• ImpellerDiameter ( type: esriFieldTypeDouble , alias: Impeller Diameter (in) , editable: true , nullable: true )
• ImpellerSleeveDiameter ( type: esriFieldTypeDouble , alias: Impeller Sleeve Diameter (in) , editable: true , nullable: true )
• NumberImpellerVanes ( type: esriFieldTypeSmallInteger , alias: Number of Impeller Vanes , editable: true , nullable: true )
• ImpellerMaterial ( type: esriFieldTypeString , alias: Impeller Material , editable: true , nullable: true , length: 20 )
• Rotation ( type: esriFieldTypeString , alias: Rotation , editable: true , nullable: true , length: 20 , Coded Values: [Clockwise: Clockwise] , [Counter-clockwise: Counter-clockwise] )
• InboardBearingPartNum ( type: esriFieldTypeString , alias: Inboard Bearing Part # , editable: true , nullable: true , length: 20 )
• OutboardBearingPartNum ( type: esriFieldTypeString , alias: Outboard Bearing Part # , editable: true , nullable: true , length: 20 )
• ThrustBearingPartNum ( type: esriFieldTypeString , alias: Thrust Bearing Part # , editable: true , nullable: true , length: 20 )
• Drive ( type: esriFieldTypeString , alias: Drive , editable: true , nullable: true , length: 8 , Coded Values: [Direct: Direct] , [Belt: Belt] , [Gearbox: Gearbox] , ...1 more... )
• CouplingType ( type: esriFieldTypeString , alias: Coupling Type , editable: true , nullable: true , length: 20 )
• CouplingSize ( type: esriFieldTypeDouble , alias: Coupling Size (in) , editable: true , nullable: true )
• BeltType ( type: esriFieldTypeString , alias: Belt Type , editable: true , nullable: true , length: 20 )
• BeltSize ( type: esriFieldTypeDouble , alias: Belt Size (in) , editable: true , nullable: true )
• DiaphragmSize ( type: esriFieldTypeString , alias: Diaphragm Size (in) , editable: true , nullable: true , length: 20 )
• DiaphragmType ( type: esriFieldTypeString , alias: Diaphragm Type , editable: true , nullable: true , length: 50 )
• Strokes ( type: esriFieldTypeString , alias: Strokes (per min) , editable: true , nullable: true , length: 20 )
• SuctionLift ( type: esriFieldTypeDouble , alias: Suction Lift (ft) , editable: true , nullable: true )
• AddlPumpInfo ( type: esriFieldTypeString , alias: Additional Pump Information , editable: true , nullable: true , length: 255 )
• AddlOperatorInfo ( type: esriFieldTypeString , alias: Additional Operator Information , editable: true , nullable: true , length: 255 )
• DCNewFields ( type: esriFieldTypeString , alias: DC_New Fields or Values , editable: true , nullable: true , length: 255 )
• DCAddlComments ( type: esriFieldTypeString , alias: DC_Additional Comments , editable: true , nullable: true , length: 255 )
• GlobalID ( type: esriFieldTypeGlobalID , alias: GlobalID , editable: false , nullable: false , length: 38 )
• PARENTGlobalID ( type: esriFieldTypeGUID , alias: PARENTGlobalID , editable: true , nullable: true , length: 38 )
• LOTO_Link ( type: esriFieldTypeString , alias: LOTO_Link , editable: true , nullable: true , length: 255 )
• LOF ( type: esriFieldTypeDouble , alias: LOF , editable: true , nullable: true )
• COF ( type: esriFieldTypeDouble , alias: COF , editable: true , nullable: true )
• BRE ( type: esriFieldTypeDouble , alias: BRE , editable: true , nullable: true )

Templates:

• Name: Pump
  Description:
  Prototype:
  COF: null
  BRE: null
  AssetID:
  AssetName: null
  FacilitySiteName: null
  ParentID: null
  OrigEquipNumber: null
  Type: null
  Criticality: null
  CriticalityComments: null
  Condition: null
  ConditionComments: null
  StartUpDate: null
  Location: null
  SerialNumber: null
  ModelNumber: null
  Description: null
  Manufacturer: null
  Vendor: null
  WarrantyDate: null
  OriginalCost: null
  ReplacementCost: null
  EstimatedLife: null
  Process: null
  O_MLink: null
  CIPName: null
  CIPNumber: null
  PurchaseDate: null
  Classification: null
  LifecycleStatus: null
  Service: null
  FlowRate: null
  DischargeHead: null
  RPM: null
  SuctionDiameter: null
  DischargeDiameter: null
  SealType: null
  NumberStages: null
  Lubrication: null
  ImpellerDiameter: null
  ImpellerSleeveDiameter: null
  NumberImpellerVanes: null
  ImpellerMaterial: null
  Rotation: null
  InboardBearingPartNum: null
  OutboardBearingPartNum: null
  ThrustBearingPartNum: null
  Drive: null
  CouplingType: null
  CouplingSize: null
  BeltType: null
  BeltSize: null
  DiaphragmSize: null
  DiaphragmType: null
  Strokes: null
  SuctionLift: null
  AddlPumpInfo: null
  AddlOperatorInfo: null
  DCNewFields: null
  DCAddlComments: null
  LOF: null
  PARENTGlobalID: null
  LOTO_Link: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Motor (394) -- Related To: Motor (72)
• Valve_Vault (5) -- Related To: Valve_Vault (4)
• PumpUnit (405) -- Related To: PumpUnit (80)
• OdorControlUnit (399) -- Related To: OdorControlUnit (74)
• MixingSystem (382) -- Related To: MixingSystem (70)
• Area (166) -- Related To: Area (18)
• Building (34) -- Related To: Building (8)

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata