Name: UV_SLEEVE

Display Field: ASSETNAME

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 6c98ed6080204623a4903c5123106f4e

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
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: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• SMARTTAG ( type: esriFieldTypeString, alias: SMARTTag, length: 50 )
• LEGACYID ( type: esriFieldTypeString, alias: Legacy ID, length: 255 )
• ASSETNAME ( type: esriFieldTypeString, alias: Asset Name, length: 125 )
• ASSETDESCRIPTION ( type: esriFieldTypeString, alias: Asset Description, length: 125 )
• MANUFACTURER ( type: esriFieldTypeString, alias: Manufacturer, length: 100 , Coded Values: [UNKNOWN: UNKNOWN] , [ABB: ABB] , [AFTON PUMPS: AFTON PUMPS] , ...168 more... )
• MODELNUMBER ( type: esriFieldTypeString, alias: Model Number, length: 200 )
• SERIALNUMBER ( type: esriFieldTypeString, alias: Serial Number, length: 200 )
• ASSETSUBTYPE ( type: esriFieldTypeString, alias: Asset Sub Type, length: 125 , Coded Values: [AC_INDUCTION_MOTOR: AC_INDUCTION_MOTOR] , [AC_SYNCHRONOUS_MOTOR: AC_SYNCHRONOUS_MOTOR] , [AIR_RECEIVER: AIR_RECEIVER] , ...109 more... )
• ASSOCIATEDEQUIP ( type: esriFieldTypeString, alias: Associated Equipment, length: 200 )
• QUANTITY ( type: esriFieldTypeDouble, alias: Quantity )
• MATERIAL ( type: esriFieldTypeString, alias: Material, length: 50 , Coded Values: [STEEL: STEEL] , [CONCRETE: CONCRETE] , [ALUMINUM: ALUMINUM] , ...4 more... )
• SIZE1 ( type: esriFieldTypeString, alias: Size1, length: 25 )
• UNIT1 ( type: esriFieldTypeString, alias: Unit1, length: 25 , Coded Values: [AREA (SF): AREA (SF)] , [AVE DIA (IN): AVE DIA (IN)] , [CURRENT (AMP): CURRENT (AMP)] , ...27 more... )
• SIZE2 ( type: esriFieldTypeString, alias: Size2, length: 25 )
• UNIT2 ( type: esriFieldTypeString, alias: Unit2, length: 25 , Coded Values: [AREA (SF): AREA (SF)] , [AVE DIA (IN): AVE DIA (IN)] , [CURRENT (AMP): CURRENT (AMP)] , ...27 more... )
• SIZE3 ( type: esriFieldTypeString, alias: Size3, length: 25 )
• UNIT3 ( type: esriFieldTypeString, alias: Unit3, length: 25 , Coded Values: [AREA (SF): AREA (SF)] , [AVE DIA (IN): AVE DIA (IN)] , [CURRENT (AMP): CURRENT (AMP)] , ...27 more... )
• SIZE4 ( type: esriFieldTypeString, alias: Size4, length: 25 )
• UNIT4 ( type: esriFieldTypeString, alias: Unit4, length: 25 , Coded Values: [AREA (SF): AREA (SF)] , [AVE DIA (IN): AVE DIA (IN)] , [CURRENT (AMP): CURRENT (AMP)] , ...27 more... )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Installation Date, length: 8 )
• WARRANTYDATE ( type: esriFieldTypeDate, alias: Warranty Date, length: 8 )
• SITE ( type: esriFieldTypeString, alias: Site, length: 50 , Coded Values: [ADMN: ADMN] , [ANNX: ANNX] , [GRIP: GRIP] , ...79 more... )
• LOCATION ( type: esriFieldTypeString, alias: Location, length: 100 , Coded Values: [ADMIN & LEARNING CENTER: ADMIN & LEARNING CENTER] , [CHEMICAL FACILITIES: CHEMICAL FACILITIES] , [CONTROL BUILDING: CONTROL BUILDING] , ...85 more... )
• PROCESS ( type: esriFieldTypeString, alias: Process, length: 50 , Coded Values: [BUILDING FACILITIES: BUILDING FACILITIES] , [CHEMICAL FEED SYSTEMS: CHEMICAL FEED SYSTEMS] , [DRAINAGE AND WASTE DISPOSAL: DRAINAGE AND WASTE DISPOSAL] , ...9 more... )
• SUBPROCESS ( type: esriFieldTypeString, alias: Sub Process, length: 50 , Coded Values: [AQUA AMMONIA: AQUA AMMONIA] , [AUTO STRAINERS: AUTO STRAINERS] , [BACKWASH WASTE - UF - MF RECOVERY FEED: BACKWASH WASTE - UF - MF RECOVERY FEED] , ...159 more... )
• SYSTEM ( type: esriFieldTypeString, alias: System, length: 50 , Coded Values: [ARCHITECTURAL: ARCHITECTURAL] , [CIVIL: CIVIL] , [ELECTRICAL: ELECTRICAL] , ...11 more... )
• LOCATIONTYPE ( type: esriFieldTypeString, alias: Location Type, length: 50 , Coded Values: [EXTERIOR: EXTERIOR] , [EXTERIOR_INTERIOR: EXTERIOR_INTERIOR] , [EXTERIOR_SUBSURFACE: EXTERIOR_SUBSURFACE] , ...2 more... )
• USEFULLIFE_ACC ( type: esriFieldTypeDouble, alias: Useful Life )
• USEFULLIFE_AM ( type: esriFieldTypeDouble, alias: Service Life )
• CONDITION ( type: esriFieldTypeDouble, alias: Condition )
• TARGETCONDITION ( type: esriFieldTypeDouble, alias: Target Condition )
• CONDITIONCOMMENT ( type: esriFieldTypeString, alias: Condition Comment, length: 250 )
• CONDITIONDATE ( type: esriFieldTypeDate, alias: Condition Date, length: 8 )
• POF ( type: esriFieldTypeDouble, alias: Probability of Failure )
• COF ( type: esriFieldTypeDouble, alias: Consequence of Failure )
• BRE ( type: esriFieldTypeDouble, alias: Business Risk Exposure )
• REPLACEMENTCOST ( type: esriFieldTypeDouble, alias: Replacement Cost )
• REPLACEMENTCOSTVAR ( type: esriFieldTypeDouble, alias: Replacement Cost Adjustment )
• LASTREHABYEAR ( type: esriFieldTypeDouble, alias: Year Last Rehabbed )
• REHABFREQUENCY1 ( type: esriFieldTypeDouble, alias: Rehab Frequency 1 )
• REHABCOST1 ( type: esriFieldTypeDouble, alias: Rehab Cost 1 )
• REHABFREQUENCY2 ( type: esriFieldTypeDouble, alias: Rehab Frequency 2 )
• REHABCOST2 ( type: esriFieldTypeDouble, alias: Rehab Cost 2 )
• PERCENTCONSUMED ( type: esriFieldTypeDouble, alias: Percent Consumed )
• ANNUALDEPRECIATION ( type: esriFieldTypeDouble, alias: Annual Depreciation )
• ANNUALDEPRECIATIONRATE ( type: esriFieldTypeDouble, alias: Annual Depreciation Rate )
• LIFECYCLESTATUS ( type: esriFieldTypeString, alias: Lifecyle Status, length: 50 , Coded Values: [ABANDONED: ABANDONED] , [DISPOSED: DISPOSED] , [IN SERVICE: IN SERVICE] , ...3 more... )
• LASTUPDATED ( type: esriFieldTypeDate, alias: Last Updated, length: 8 )
• LASTEDITOR ( type: esriFieldTypeString, alias: LastEditor, length: 50 )
• COMMENTS ( type: esriFieldTypeString, alias: Comments, length: 250 )
• IMAGES ( type: esriFieldTypeString, alias: Image Path, length: 250 )
• FINANCIALTYPE ( type: esriFieldTypeString, alias: Financial Type, length: 50 , Coded Values: [0: 0] )
• FINANCIALSUBTYPE ( type: esriFieldTypeString, alias: Financial SubType, length: 50 , Coded Values: [0: 0] )
• SCADATAG ( type: esriFieldTypeString, alias: SCADA Tag, length: 200 )
• ASSETID ( type: esriFieldTypeString, alias: Asset ID, length: 100 )
• FLOORID ( type: esriFieldTypeString, alias: Relate ID - Floor ID, length: 50 )
• SUBPROCESSID ( type: esriFieldTypeString, alias: Relate ID - SubProcess ID, length: 50 )
• SYSTEMID ( type: esriFieldTypeString, alias: Relate ID - System ID, length: 50 )
• ROOMID ( type: esriFieldTypeString, alias: Relate ID - Room ID, length: 50 )
• PARENTASSETID ( type: esriFieldTypeString, alias: Relate ID - ParentAssetID, length: 50 )
• Proc_ID ( type: esriFieldTypeString, alias: Proc_ID, length: 4 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• Site_Proc_ID ( type: esriFieldTypeString, alias: Site_Proc_ID, length: 20 )

Relationships:

• UV_REACTOR (237) -- Related To: UV_REACTOR (38)
• FLOOR (218) -- Related To: FLOOR (28)
• SUB_PROCESS (163) -- Related To: SUB_PROCESS (26)
• SYSTEM (182) -- Related To: SYSTEM (27)

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

  Iteminfo   Thumbnail   Metadata