Name: WTP FILTER

Display Field: Asset_Description

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 028674790fe844b292171de38dd248b7

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON

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
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: 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: 35 )
• Location ( type: esriFieldTypeString, alias: Location, length: 100 )
• Asset_Description ( type: esriFieldTypeString, alias: Asset_Description, length: 100 )
• Model_Number ( type: esriFieldTypeString, alias: Model_Number, length: 50 )
• Serial_Number ( type: esriFieldTypeString, alias: Serial_Number, length: 50 )
• Type ( type: esriFieldTypeString, alias: Type, length: 50 )
• Series ( type: esriFieldTypeString, alias: Series, length: 50 )
• Website ( type: esriFieldTypeString, alias: Website, length: 50 )
• Contact ( type: esriFieldTypeString, alias: Contact, length: 50 )
• Pitch ( type: esriFieldTypeString, alias: Pitch, length: 50 )
• Volts ( type: esriFieldTypeSmallInteger, alias: Volts , Coded Values: [480: 480] , [230: 230] , [460: 460] )
• AMP ( type: esriFieldTypeSmallInteger, alias: AMP )
• Num_Blades ( type: esriFieldTypeSmallInteger, alias: Num_Blades )
• RPM ( type: esriFieldTypeSmallInteger, alias: RPM )
• Frame ( type: esriFieldTypeString, alias: Frame, length: 50 )
• Duty ( type: esriFieldTypeString, alias: Duty, length: 50 )
• Phase ( type: esriFieldTypeSmallInteger, alias: Phase , Coded Values: [3: 3] , [2: 2] , [1: 1] )
• HZ ( type: esriFieldTypeSmallInteger, alias: HZ , Coded Values: [60: 60] )
• Service_Factor ( type: esriFieldTypeString, alias: Service_Factor, length: 50 )
• Code ( type: esriFieldTypeString, alias: Code, length: 50 )
• CFM ( type: esriFieldTypeString, alias: CFM, length: 50 )
• Insul_Class ( type: esriFieldTypeString, alias: Insul_Class, length: 50 )
• Rating ( type: esriFieldTypeString, alias: Rating, length: 50 )
• VFD ( type: esriFieldTypeString, alias: Plant_Date_MFG, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• Weight ( type: esriFieldTypeString, alias: SP, length: 50 )
• Speed ( type: esriFieldTypeString, alias: Speed, length: 50 )
• Max_Amb ( type: esriFieldTypeString, alias: Max_Amb, length: 50 )
• Enclosure ( type: esriFieldTypeString, alias: Enclosure, length: 50 )
• Gear_Ratio ( type: esriFieldTypeString, alias: Gear_Ratio, length: 50 )
• Power_Factor ( type: esriFieldTypeDouble, alias: Power_Factor )
• Upper_Oil ( type: esriFieldTypeString, alias: Upper_Oil, length: 50 )
• Nema_Design ( type: esriFieldTypeString, alias: Nema_Design, length: 50 )
• Guaranteed_Efficiency_Minutes ( type: esriFieldTypeString, alias: Guarenteed_Efficiency_Minutes, length: 50 )
• Form_Factor ( type: esriFieldTypeString, alias: Foam_Factor, length: 50 )
• Size_ ( type: esriFieldTypeString, alias: Size_, length: 50 )
• Stage ( type: esriFieldTypeSmallInteger, alias: Stage )
• Poles ( type: esriFieldTypeString, alias: Poles, length: 50 )
• Diameter ( type: esriFieldTypeString, alias: Diameter, length: 50 , Coded Values: [14 feet: 14 feet] , [Other: Other] )
• Gen_Ratio ( type: esriFieldTypeString, alias: Gen_Ratio, length: 50 )
• Additional_Information ( type: esriFieldTypeString, alias: Additional_Information, length: 255 )
• Warrantydate ( type: esriFieldTypeDate, alias: Warrantydate, length: 8 )
• Installdate ( type: esriFieldTypeDate, alias: Installdate, length: 8 )
• Condition ( type: esriFieldTypeString, alias: Condition, length: 10 , Coded Values: [Poor: Poor] , [Fair: Fair] , [Good: Good] , ...2 more... )
• ConditionDate ( type: esriFieldTypeDate, alias: ConditionDate, length: 8 , Coded Values: [Poor: Poor] , [Fair: Fair] , [Good: Good] , ...2 more... )
• DataEnteredBy ( type: esriFieldTypeString, alias: DataEnteredBy, length: 50 )
• DataModifiedBy ( type: esriFieldTypeString, alias: DataModifiedBy, length: 50 )
• WorkOrderID ( type: esriFieldTypeString, alias: WorkOrderID, length: 50 )
• FacilityID ( type: esriFieldTypeString, alias: FacilityID, length: 35 )
• Foreign_Key ( type: esriFieldTypeString, alias: Foreign_Key, length: 35 )
• LegacyID ( type: esriFieldTypeString, alias: LegacyID, length: 100 )
• Image_File ( type: esriFieldTypeString, alias: Image_File, length: 100 )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 100 )
• Comment ( type: esriFieldTypeString, alias: Comment, length: 200 )
• FLOOR ( type: esriFieldTypeString, alias: FLOOR, length: 5 , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...3 more... )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• CAP_ASSET_NO ( type: esriFieldTypeString, alias: CAP_ASSET_NO, length: 20 )

Relationships:

• wpHVAC (88) -- Related To: WTP HVAC (46)
• Part of wpSystem (117) -- Related To: SYSTEM & PROCESSES (56)

Supported Operations:   Query   Query Attachments   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata