Name: Pump

Display Field: AssetName

Type: Table

Geometry Type: N/A

Description: null

Definition Expression: N/A

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, AMF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

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

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

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

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)

Supported Operations:   Query   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata