Name: stp_Instrument

Display Field: SITE_NAME

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 551ed99598bc4645bc48894460c82fc3

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

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• FACILITYID ( type: esriFieldTypeString, alias: Facility ID, length: 50 )
• LEGACY_ID ( type: esriFieldTypeString, alias: Legacy ID, length: 50 )
• CITY_ASSET_ID ( type: esriFieldTypeString, alias: City Asset ID, length: 50 )
• LOCATION ( type: esriFieldTypeString, alias: Location Description, length: 255 )
• PROJECT_NUMBER ( type: esriFieldTypeString, alias: Project Number, length: 50 )
• MANUFACTURER ( type: esriFieldTypeString, alias: Manufacturer, length: 50 )
• MODEL ( type: esriFieldTypeString, alias: Model, length: 50 )
• SERIAL_NUMBER ( type: esriFieldTypeString, alias: Serial Number, length: 50 )
• PURCHASE_DATE ( type: esriFieldTypeDate, alias: Purchase Date, length: 8 )
• INITIAL_COST ( type: esriFieldTypeInteger, alias: Initial Cost )
• INSTALLATION_DATE ( type: esriFieldTypeDate, alias: Installation Date, length: 8 )
• WARRANTYDATE ( type: esriFieldTypeDate, alias: Warranty Date, length: 8 )
• REPLACEMENT_COST ( type: esriFieldTypeInteger, alias: Replacement Cost )
• REMAINING_VALUE ( type: esriFieldTypeInteger, alias: Remaining Value )
• OWNED_BY ( type: esriFieldTypeString, alias: Owned By, length: 50 , Coded Values: [MyCodedValue: MyCodeName] , [HARRF_OPS: HARRF Operations] , [HARRF_PST: HARRF Plant Systems Technician] , ...7 more... )
• MAINTAINED_BY ( type: esriFieldTypeString, alias: Maintained By, length: 50 , Coded Values: [MyCodedValue: MyCodeName] , [HARRF_OPS: HARRF Operations] , [HARRF_PST: HARRF Plant Systems Technician] , ...7 more... )
• LIFECYCLE_STATUS ( type: esriFieldTypeString, alias: Lifecycle Status, length: 50 , Coded Values: [INSTALLED: Installed] , [UNINSTALLED: Uninstalled] , [ABANDONEDINPLACE: Abandoned-In-Place] , ...3 more... )
• CRITICAL ( type: esriFieldTypeString, alias: Critical?, length: 255 , Coded Values: [YES: Yes] , [NO: No] , [NA: Not Applicable] )
• CONDITION ( type: esriFieldTypeSmallInteger, alias: Condition )
• CONDITIONDATE ( type: esriFieldTypeDate, alias: Condition Date, length: 8 )
• YR_EXPECTED_END_PHYSICAL_LIFE ( type: esriFieldTypeSmallInteger, alias: Expected End of Physical Life )
• TYPICAL_YRS_FULLY_DEPRECIATE ( type: esriFieldTypeSmallInteger, alias: Typical Years to Fully Depreciate )
• DEPRECIATION_DETAILS ( type: esriFieldTypeString, alias: Depreciation Details, length: 50 )
• CONSEQUENCE_OF_FAILURE ( type: esriFieldTypeDouble, alias: Consequence of Failure (COF) )
• PROBABILITY_OF_FAILURE ( type: esriFieldTypeDouble, alias: Probability of Failure (POF) )
• BUSINESS_RISK_EXPOSURE ( type: esriFieldTypeDouble, alias: Business Risk Exposure (BRE) )
• DATE_CALCULATED ( type: esriFieldTypeDate, alias: COF, POF, and BRE Calculation, length: 8 )
• MAINTENANCE_DATE ( type: esriFieldTypeDate, alias: Maintenance Date, length: 8 )
• MAINTENANCE_COMMENTS ( type: esriFieldTypeString, alias: Maintenance Comments, length: 255 )
• IMAGE_URL ( type: esriFieldTypeString, alias: Image URL, length: 255 )
• COMMENTS ( type: esriFieldTypeString, alias: Comments, length: 255 )
• SITE_NAME ( type: esriFieldTypeString, alias: Site Name, length: 255 )
• PROCESS_NAME ( type: esriFieldTypeString, alias: System Name, length: 100 , Coded Values: [PRETREAT: Preliminary Treatment] , [PRIMTREAT: Primary Treatment] , [SECTREAT: Secondary Treatment] , ...13 more... )
• SUBPROCESS_NAME ( type: esriFieldTypeString, alias: Subsystem Name, length: 100 , Coded Values: [SCREENING: Screening] , [PUMPING: Pumping] , [GRITREMOVAL: Grit Removal] , ...48 more... )
• CIRCUIT_ID ( type: esriFieldTypeString, alias: Circuit ID, length: 50 )
• COMMUNICATION_PROTOCOL ( type: esriFieldTypeString, alias: Communication Protocol, length: 50 , Coded Values: [CURRENTLOOP: Current Loop (4 – 20 mA)] , [HART: HART] , [PROFIBUS: Profibus] , ...6 more... )
• INSTRUMENT_READING_TYPE ( type: esriFieldTypeString, alias: Instrument Reading Type, length: 50 , Coded Values: [DISCRETE: Discrete] , [ANALOG: Analog] )
• ELEMENT_FUNCTION ( type: esriFieldTypeString, alias: Element Function, length: 50 , Coded Values: [RESIDUALCHLORINE: Residual Chlorine] , [FREECHLORINE: Free Chlorine] , [TOTALCHLORINE: Total Chlorine] , ...45 more... )
• NEMA_ENCLOSURE ( type: esriFieldTypeString, alias: In NEMA Enclosure?, length: 3 , Coded Values: [YES: Yes] , [NO: No] , [NA: Not Applicable] )
• NEMA_RATING ( type: esriFieldTypeString, alias: NEMA Rating, length: 50 , Coded Values: [GENPURPOSE: 1 General Purpose Primarily Prevents Contact with Live Parts] , [DRIPTIGHT: 2 Drip Tight] , [WEATHERRESIST: 3/3S Weather Resistant] , ...11 more... )
• VOLTAGE ( type: esriFieldTypeString, alias: Voltage (Volts), length: 50 , Coded Values: [12DC: 12 (DC)] , [24DC: 24 (DC)] , [24VDCLOOPEDWRD: 24 VDC (Loop Powered)] , ...26 more... )
• MINIMUM_RANGE ( type: esriFieldTypeDouble, alias: Minimum Range )
• MAXIMUM_RANGE ( type: esriFieldTypeDouble, alias: Maximum Range )
• RANGE_UOM ( type: esriFieldTypeString, alias: Range Units of Measure, length: 50 , Coded Values: [PERCENTAGE: Percentage] , [PPM: Parts Per Million] , [PPB: Parts Per Billion] , ...20 more... )
• REGULATORY ( type: esriFieldTypeString, alias: Regulatory?, length: 3 , Coded Values: [YES: Yes] , [NO: No] , [NA: Not Applicable] )
• PORTABLE ( type: esriFieldTypeString, alias: Portable?, length: 3 , Coded Values: [YES: Yes] , [NO: No] , [NA: Not Applicable] )
• POINT_OF_INTEREST_ID ( type: esriFieldTypeString, alias: Position ID (Relate), length: 50 )
• 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 )
• LASTEDITOR ( type: esriFieldTypeString, alias: LASTEDITOR, length: 50 )
• LASTUPDATE ( type: esriFieldTypeDate, alias: LASTUPDATE, length: 8 )
• ASSETSTATUS ( type: esriFieldTypeString, alias: ASSETSTATUS, length: 1 , Coded Values: [C: Current] , [R: Retired] , [A: Abandoned] , ...5 more... )
• SCADA_INITIATED ( type: esriFieldTypeDouble, alias: SCADA_INITIATED )

Relationships:

• tp_PointsOfInterest (44) -- Related To: Position (127)

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

  Iteminfo   Thumbnail   Metadata