Name: sMotor

Display Field: AssetID

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID , alias: OBJECTID )
• AssetID ( type: esriFieldTypeString , alias: AssetID , length: 30 )
• LegacyID ( type: esriFieldTypeString , alias: LegacyID , length: 30 )
• InstallDate ( type: esriFieldTypeDate , alias: InstallDate , length: 8 )
• MotorType ( type: esriFieldTypeString , alias: MotorType , length: 30 , Coded Values: [Jacketed: Jacketed] , [Totally Enclosed Fan Cooled: Totally Enclosed Fan Cooled] , [Submersible: Submersible] , ...1 more... )
• Status ( type: esriFieldTypeString , alias: Status , length: 20 , Coded Values: [Abandoned: Abandoned] , [Active: Active] , [Inactive: Inactive] , ...7 more... )
• WarrantyDate ( type: esriFieldTypeDate , alias: WarrantyDate , length: 8 )
• Condition ( type: esriFieldTypeString , alias: Condition , length: 10 , Coded Values: [Excellent: Excellent] , [Good: Good] , [Fair: Fair] , ...2 more... )
• ConditionDate ( type: esriFieldTypeDate , alias: ConditionDate , length: 8 )
• PrimaryImage ( type: esriFieldTypeString , alias: PrimaryImage , length: 250 )
• Manufacturer ( type: esriFieldTypeString , alias: Manufacturer , length: 20 , Coded Values: [ABB: Abb Motors] , [ABS: ABS] , [ACM: Allis Chalmers] , ...23 more... )
• Model ( type: esriFieldTypeString , alias: Model , length: 20 )
• Serial ( type: esriFieldTypeString , alias: Serial , length: 20 )
• Phase ( type: esriFieldTypeString , alias: Phase , length: 20 , Coded Values: [S: Single] , [T: Three] )
• RPM ( type: esriFieldTypeInteger , alias: RPM , Range: [500, 5000] )
• Voltage ( type: esriFieldTypeInteger , alias: Voltage , Coded Values: [120: 120] , [208: 208] , [240: 240] , ...4 more... )
• HP ( type: esriFieldTypeDouble , alias: HP )
• Frame ( type: esriFieldTypeString , alias: Frame , length: 10 )
• DEVICE_UID ( type: esriFieldTypeString , alias: DEVICE_UID , length: 30 )
• DEVICE_SID ( type: esriFieldTypeString , alias: DEVICE_SID , length: 10 )
• FEATURE_ID ( type: esriFieldTypeString , alias: FEATURE_ID , length: 10 )
• GlobalID ( type: esriFieldTypeGlobalID , alias: GlobalID , length: 38 )
• StationFacilityID ( type: esriFieldTypeString , alias: StationFacilityID , length: 75 )
• Description ( type: esriFieldTypeString , alias: Description , length: 50 )
• FLA ( type: esriFieldTypeDouble , alias: FLA )

Relationships:

• sPump (7) -- Related To: sPump (36)

Supported Operations:   Query   Query Related Records   Generate Renderer   Return Updates