Name: stp_Vault

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... )
• VAULT_TYPE ( type: esriFieldTypeString, alias: Vault Type, length: 50 , Coded Values: [VALVE: Valve] , [REGULATOR: Regulator] , [METER: Meter] , ...9 more... )
• VAULT_MATERIAL ( type: esriFieldTypeString, alias: Vault Material, length: 50 , Coded Values: [CONCRETE: Concrete] , [BRICK: Brick] , [BLOCK: Block] , ...3 more... )
• VAULT_LENGTH ( type: esriFieldTypeDouble, alias: Vault Length )
• VAULT_WIDTH ( type: esriFieldTypeDouble, alias: Vault Width )
• VAULTDEPTH ( type: esriFieldTypeDouble, alias: Vault Depth )
• VAULT_DIAMETER ( type: esriFieldTypeDouble, alias: Vault Diameter )
• VAULT_UOM ( type: esriFieldTypeString, alias: Vault Unit of Measure, length: 50 , Coded Values: [FEET: Feet] , [INCHES: Inches] )
• CONFINED_SPACE_ENTRY ( type: esriFieldTypeString, alias: Confined Space Entry?, length: 3 , Coded Values: [YES: Yes] , [NO: No] , [NA: Not Applicable] )
• LINING_MATERIAL ( type: esriFieldTypeString, alias: Lining Material, length: 50 , Coded Values: [EPOXY: Epoxy] , [PVC: PVC] , [FABRIC: Fabric] , ...2 more... )
• LOAD_BEARING ( type: esriFieldTypeString, alias: Load Bearing?, length: 3 , Coded Values: [YES: Yes] , [NO: No] , [NA: Not Applicable] )
• SUMP_PUMP ( type: esriFieldTypeString, alias: Sump Pump?, 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... )

Relationships:

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

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

  Iteminfo   Thumbnail   Metadata