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: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID , alias: OBJECTID , editable: false , nullable: false )
• ASSETID ( type: esriFieldTypeString , alias: Asset ID , editable: true , nullable: true , length: 100 )
• ASSETNAME ( type: esriFieldTypeString , alias: Asset Name , editable: true , nullable: true , length: 255 )
• ASSETTYPE ( type: esriFieldTypeString , alias: Asset Type , editable: true , nullable: true , length: 50 )
• ASSETOWNER ( type: esriFieldTypeString , alias: Asset Owner , editable: true , nullable: true , length: 50 , Coded Values: [Airports: Airports] , [HHSA: HHSA] , [Parks: Parks] , ...3 more... )
• LEGACYID ( type: esriFieldTypeString , alias: Legacy ID , editable: true , nullable: true , length: 50 )
• TAGNUMBER ( type: esriFieldTypeString , alias: Tag Number , editable: true , nullable: true , length: 50 )
• STATUS ( type: esriFieldTypeString , alias: Status , editable: true , nullable: true , length: 30 , Coded Values: [In Service: In Service] , [Out of Service: Out of Service] , [Spare: Spare] )
• PARENTID ( type: esriFieldTypeString , alias: Parent ID , editable: true , nullable: true , length: 100 )
• STARTUPDATE ( type: esriFieldTypeDate , alias: Startup Date , editable: true , nullable: true , length: 8 )
• WARRANTYDATE ( type: esriFieldTypeDate , alias: Warranty Date , editable: true , nullable: true , length: 8 )
• CONDITIONSCORE ( type: esriFieldTypeSmallInteger , alias: Condition Score , editable: true , nullable: true )
• CONDITIONDATE ( type: esriFieldTypeDate , alias: Condition Date , editable: true , nullable: true , length: 8 )
• ADDRESS ( type: esriFieldTypeString , alias: Address , editable: true , nullable: true , length: 255 )
• LOCATION ( type: esriFieldTypeString , alias: Location , editable: true , nullable: true , length: 255 )
• SITE ( type: esriFieldTypeString , alias: Site , editable: true , nullable: true , length: 30 , Coded Values: [JUWWTP0019: Heise Park WWTP] , [PVWWTP0007: Pine Valley WWTP] , [SVWWPS0010: Rancho San Diego PS] , ...39 more... )
• MANUFACTURER ( type: esriFieldTypeString , alias: Manufacturer , editable: true , nullable: true , length: 30 )
• MANPHONE ( type: esriFieldTypeString , alias: Manufacturer Phone # , editable: true , nullable: true , length: 16 )
• MANWEBSITE ( type: esriFieldTypeString , alias: Manufacturer Website , editable: true , nullable: true , length: 30 )
• MODEL ( type: esriFieldTypeString , alias: Model , editable: true , nullable: true , length: 30 )
• SERIALNO ( type: esriFieldTypeString , alias: Serial Number , editable: true , nullable: true , length: 30 )
• VENDOR ( type: esriFieldTypeString , alias: Vendor , editable: true , nullable: true , length: 30 )
• SPECLINK ( type: esriFieldTypeString , alias: Spec Link , editable: true , nullable: true , length: 64 )
• OMLINK ( type: esriFieldTypeString , alias: O&M Link , editable: true , nullable: true , length: 64 )
• SYSTEM ( type: esriFieldTypeString , alias: System Designator , editable: true , nullable: true , length: 40 , Coded Values: [Conveyance: Conveyance] , [Screening: Screening] , [Grit Removal: Grit Removal] , ...10 more... )
• LOF ( type: esriFieldTypeSmallInteger , alias: LoF Score , editable: true , nullable: true )
• COF ( type: esriFieldTypeSmallInteger , alias: CoF Score , editable: true , nullable: true )
• RISK ( type: esriFieldTypeSmallInteger , alias: Risk Score , editable: true , nullable: true )
• CRITICALITY ( type: esriFieldTypeString , alias: Criticality , editable: true , nullable: true , length: 16 , Coded Values: [High: High] , [Medium: Medium] , [Low: Low] )
• REPLACEVALUE ( type: esriFieldTypeDouble , alias: Replacement Value , editable: true , nullable: true )
• VALUEDATE ( type: esriFieldTypeDate , alias: Valuation Date , editable: true , nullable: true , length: 8 )
• NOTES ( type: esriFieldTypeString , alias: Notes , editable: true , nullable: true , length: 255 )
• CREATOR ( type: esriFieldTypeString , alias: Creator , editable: true , nullable: true , length: 30 )
• CREATEDATE ( type: esriFieldTypeDate , alias: Created , editable: true , nullable: true , length: 8 )
• EDITOR ( type: esriFieldTypeString , alias: Editor , editable: true , nullable: true , length: 30 )
• EDITDATE ( type: esriFieldTypeDate , alias: Edited , editable: true , nullable: true , length: 8 )
• PMPTYPE ( type: esriFieldTypeString , alias: Type , editable: true , nullable: true , length: 25 , Coded Values: [Chopper: Chopper] , [Scump: Scump] , [Submersible: Submersible] , ...8 more... )
• DISCHARGEHEAD ( type: esriFieldTypeSmallInteger , alias: Discharge Head , editable: true , nullable: true )
• STATICDISPRESS ( type: esriFieldTypeSmallInteger , alias: Static Discharge Pressure , editable: true , nullable: true )
• DYNDISPRESS ( type: esriFieldTypeSmallInteger , alias: Dynamic Discharge Pressure , editable: true , nullable: true )
• RPM ( type: esriFieldTypeSmallInteger , alias: Rotations per Minute , editable: true , nullable: true )
• SEALTYPE ( type: esriFieldTypeString , alias: Seal Type , editable: true , nullable: true , length: 10 , Coded Values: [Mechanical: Mechanical] , [Packing: Packing] )
• NUMSTAGES ( type: esriFieldTypeSmallInteger , alias: Number of Stages , editable: true , nullable: true )
• LUBEGREASE1 ( type: esriFieldTypeString , alias: Lubrication, Grease Primary , editable: true , nullable: true , length: 30 )
• LUBEGREASE2 ( type: esriFieldTypeString , alias: Lubrication, Grease Secondary , editable: true , nullable: true , length: 30 )
• LUBEOIL1 ( type: esriFieldTypeString , alias: Lubrication, Oil Primary , editable: true , nullable: true , length: 30 )
• LUBEOIL2 ( type: esriFieldTypeString , alias: Lubrication, Oil Secondary , editable: true , nullable: true , length: 30 )
• NUMIMPVANES ( type: esriFieldTypeSmallInteger , alias: Number of Impeller Vanes , editable: true , nullable: true )
• IMPELLERMAT ( type: esriFieldTypeString , alias: Impeller Material , editable: true , nullable: true , length: 30 )
• ROTATION ( type: esriFieldTypeString , alias: Rotation , editable: true , nullable: true , length: 20 , Coded Values: [Clockwise: Clockwise] , [Counter-Clockwise: Counter-Clockwise] )
• DRIVETYPE ( 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: 30 )
• COUPLINGMODEL ( type: esriFieldTypeString , alias: Coupling Model , editable: true , nullable: true , length: 30 )
• BELTTYPE ( type: esriFieldTypeString , alias: Belt Type , editable: true , nullable: true , length: 30 )
• DIAPHRAGMTYPE ( type: esriFieldTypeString , alias: Diaphragm Type , editable: true , nullable: true , length: 30 )
• SPM ( type: esriFieldTypeSmallInteger , alias: Strokes per Minute , editable: true , nullable: true )
• COUPLINGSIZE ( type: esriFieldTypeDouble , alias: COUPLINGSIZE , editable: true , nullable: true )
• BELTSIZE ( type: esriFieldTypeDouble , alias: BELTSIZE , editable: true , nullable: true )
• DISCHARGEDIAM ( type: esriFieldTypeDouble , alias: DISCHARGEDIAM , editable: true , nullable: true )
• IMPELLERDIAM ( type: esriFieldTypeDouble , alias: IMPELLERDIAM , editable: true , nullable: true )
• IMPSLEEVEDIAM ( type: esriFieldTypeDouble , alias: IMPSLEEVEDIAM , editable: true , nullable: true )
• SUCTIONDIAM ( type: esriFieldTypeDouble , alias: SUCTIONDIAM , editable: true , nullable: true )
• SERVICELIFE ( type: esriFieldTypeDouble , alias: SERVICELIFE , editable: true , nullable: true )
• FLOWRATE ( type: esriFieldTypeString , alias: FLOWRATE , editable: true , nullable: true , length: 50 )
• DIAPHRAGMSIZE ( type: esriFieldTypeDouble , alias: DIAPHRAGMSIZE , editable: true , nullable: true )
• SUCTIONLIFT ( type: esriFieldTypeDouble , alias: SUCTIONLIFT , editable: true , nullable: true )

Templates:

• Name: Pump
  Description:
  Prototype:
  DIAPHRAGMSIZE: null
  SUCTIONLIFT: null
  ASSETID: null
  ASSETNAME: null
  ASSETTYPE: null
  ASSETOWNER: null
  LEGACYID: null
  TAGNUMBER: null
  STATUS: null
  PARENTID: null
  STARTUPDATE: null
  WARRANTYDATE: null
  CONDITIONSCORE: null
  CONDITIONDATE: null
  ADDRESS: null
  LOCATION: null
  SITE: null
  MANUFACTURER: null
  MANPHONE: null
  MANWEBSITE: null
  MODEL: null
  SERIALNO: null
  VENDOR: null
  SPECLINK: null
  OMLINK: null
  SYSTEM: null
  LOF: null
  COF: null
  RISK: null
  CRITICALITY: null
  REPLACEVALUE: null
  VALUEDATE: null
  NOTES: null
  CREATOR: null
  CREATEDATE: null
  EDITOR: null
  EDITDATE: null
  PMPTYPE: null
  DISCHARGEHEAD: null
  STATICDISPRESS: null
  DYNDISPRESS: null
  RPM: null
  SEALTYPE: null
  NUMSTAGES: null
  LUBEGREASE1: null
  LUBEGREASE2: null
  LUBEOIL1: null
  LUBEOIL2: null
  NUMIMPVANES: null
  IMPELLERMAT: null
  ROTATION: null
  DRIVETYPE: null
  COUPLINGTYPE: null
  COUPLINGMODEL: null
  BELTTYPE: null
  DIAPHRAGMTYPE: null
  SPM: null
  COUPLINGSIZE: null
  BELTSIZE: null
  DISCHARGEDIAM: null
  IMPELLERDIAM: null
  IMPSLEEVEDIAM: null
  SUCTIONDIAM: null
  SERVICELIFE: null
  FLOWRATE: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Pump Unit (274) -- Related To: Pump Unit (73)

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

Sync Can Return Changes: false

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

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