Name: WW_Pumps

Display Field: Asset_Number

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 3a39ae9db94f45d1837f5d2276c513a8

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

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
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Lift_Station ( type: esriFieldTypeString, alias: Lift_Station, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Lift_Station )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Status )
• Pump_Type ( type: esriFieldTypeString, alias: Pump_Type, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Pump_Type )
• Pump_Number ( type: esriFieldTypeString, alias: Pump_Number, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Pump_Number )
• Asset_Number ( type: esriFieldTypeString, alias: Asset_Number, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Asset_Number )
• Model_Number ( type: esriFieldTypeString, alias: Model_Number, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Model_Number )
• Serial_Number ( type: esriFieldTypeString, alias: Serial_Number, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Serial_Number )
• Drive_unit_number ( type: esriFieldTypeString, alias: Drive_unit_number, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Drive_unit_number )
• Impeller_Code ( type: esriFieldTypeString, alias: Impeller_Code, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Impeller_Code )
• Horsepower ( type: esriFieldTypeDouble, alias: Horsepower, editable: true, nullable: true, defaultValue: null, modelName: Horsepower )
• Volts ( type: esriFieldTypeInteger, alias: Volts, editable: true, nullable: true, defaultValue: null, modelName: Volts )
• Phase ( type: esriFieldTypeInteger, alias: Phase, editable: true, nullable: true, defaultValue: null, modelName: Phase )
• Full_load_amps ( type: esriFieldTypeDouble, alias: Full_load_amps, editable: true, nullable: true, defaultValue: null, modelName: Full_load_amps )
• RPM ( type: esriFieldTypeInteger, alias: RPM, editable: true, nullable: true, defaultValue: null, modelName: RPM )
• Weight ( type: esriFieldTypeString, alias: Weight, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Weight )
• Wiring_Order ( type: esriFieldTypeString, alias: Wiring_Order, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Wiring_Order )
• Rebuild_Kit ( type: esriFieldTypeString, alias: Rebuild_Kit, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Rebuild_Kit )
• Stator ( type: esriFieldTypeString, alias: Stator, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Stator )
• Rotor ( type: esriFieldTypeString, alias: Rotor, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Rotor )
• Impeller ( type: esriFieldTypeString, alias: Impeller, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Impeller )
• Impeller_part ( type: esriFieldTypeString, alias: Impeller_part, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Impeller_part )
• Impeller_part_oring ( type: esriFieldTypeString, alias: Impeller_part_oring, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Impeller_part_oring )
• Insert_ring ( type: esriFieldTypeString, alias: Insert_ring, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Insert_ring )
• Volute_oring ( type: esriFieldTypeString, alias: Volute_oring, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Volute_oring )
• Upper_seal ( type: esriFieldTypeString, alias: Upper_seal, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Upper_seal )
• Lower_seal ( type: esriFieldTypeString, alias: Lower_seal, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Lower_seal )
• Seal_Serial_num ( type: esriFieldTypeString, alias: Seal_Serial_num, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Seal_Serial_num )
• Inb_Bearing_lower ( type: esriFieldTypeString, alias: Inb_Bearing_lower, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Inb_Bearing_lower )
• Outb_Bearing_upr ( type: esriFieldTypeString, alias: Outb_Bearing_upr, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Outb_Bearing_upr )
• PT_100_sensor ( type: esriFieldTypeString, alias: PT_100_sensor, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: PT_100_sensor )
• Oil_type_Quantity ( type: esriFieldTypeString, alias: Oil_type_Quantity, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Oil_type_Quantity )
• Antifreeze_Info ( type: esriFieldTypeString, alias: Antifreeze_Info, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Antifreeze_Info )
• Stationary_wear_ring ( type: esriFieldTypeString, alias: Stationary_wear_ring, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Stationary_wear_ring )
• Lifting_handle ( type: esriFieldTypeString, alias: Lifting_handle, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Lifting_handle )
• Rotating_wear_ring ( type: esriFieldTypeString, alias: Rotating_wear_ring, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Rotating_wear_ring )
• Cable ( type: esriFieldTypeString, alias: Cable, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Cable )
• Guide_Claw ( type: esriFieldTypeString, alias: Guide_Claw, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Guide_Claw )
• Inpsection_screws ( type: esriFieldTypeString, alias: Inpsection_screws, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Inpsection_screws )
• Inpsection_screws_X ( type: esriFieldTypeDouble, alias: Inpsection_screws_X, editable: true, nullable: true, defaultValue: null, modelName: Inpsection_screws_X )
• Inpsection_screws_Y ( type: esriFieldTypeDouble, alias: Inpsection_screws_Y, editable: true, nullable: true, defaultValue: null, modelName: Inpsection_screws_Y )
• Location ( type: esriFieldTypeString, alias: Location Details, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Location )
• Address ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Address )
• Process ( type: esriFieldTypeString, alias: Process, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Process )
• Condition ( type: esriFieldTypeDouble, alias: Condition, editable: true, nullable: true, defaultValue: null, modelName: Condition )
• ConditionDate ( type: esriFieldTypeDate, alias: Condition Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ConditionDate )
• LifeExpectancy ( type: esriFieldTypeSmallInteger, alias: Life Expectancy, editable: true, nullable: true, defaultValue: null, modelName: LifeExpectancy )
• COF ( type: esriFieldTypeSmallInteger, alias: Consequence of Failure, editable: true, nullable: true, defaultValue: null, modelName: COF )
• POF ( type: esriFieldTypeSmallInteger, alias: Probability of Failure, editable: true, nullable: true, defaultValue: null, modelName: POF )
• BRE ( type: esriFieldTypeSmallInteger, alias: Business Risk of Failure, editable: true, nullable: true, defaultValue: null, modelName: BRE )
• Structure ( type: esriFieldTypeString, alias: Structure/Basin, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Structure )
• Room ( type: esriFieldTypeString, alias: Room, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Room )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )

Templates:

• Name: WW_Pumps
  Description:
  Prototype:
  Room: null
  Lift_Station: null
  Status: null
  Pump_Type: null
  Pump_Number: null
  Asset_Number: null
  Model_Number: null
  Serial_Number: null
  Drive_unit_number: null
  Impeller_Code: null
  Horsepower: null
  Volts: null
  Phase: null
  Full_load_amps: null
  RPM: null
  Weight: null
  Wiring_Order: null
  Rebuild_Kit: null
  Stator: null
  Rotor: null
  Impeller: null
  Impeller_part: null
  Impeller_part_oring: null
  Insert_ring: null
  Volute_oring: null
  Upper_seal: null
  Lower_seal: null
  Seal_Serial_num: null
  Inb_Bearing_lower: null
  Outb_Bearing_upr: null
  PT_100_sensor: null
  Oil_type_Quantity: null
  Antifreeze_Info: null
  Stationary_wear_ring: null
  Lifting_handle: null
  Rotating_wear_ring: null
  Cable: null
  Guide_Claw: null
  Inpsection_screws: null
  Inpsection_screws_X: null
  Inpsection_screws_Y: null
  Location: null
  Address: null
  Process: null
  Condition: null
  ConditionDate: null
  LifeExpectancy: null
  COF: null
  POF: null
  BRE: null
  Structure: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Lift_Station (2) -- Related To: Lift Station (3)

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Query Related Records   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata