Name: stp_ShopEquipment

Display Field: SITE_NAME

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 6aa3f52844c748d88820036a76e0ab74

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• FACILITYID ( type: esriFieldTypeString, alias: Facility ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FACILITYID )
• LEGACY_ID ( type: esriFieldTypeString, alias: Legacy ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LEGACY_ID )
• CITY_ASSET_ID ( type: esriFieldTypeString, alias: City Asset ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CITY_ASSET_ID )
• LOCATION ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LOCATION )
• PROJECT_NUMBER ( type: esriFieldTypeString, alias: Project Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PROJECT_NUMBER )
• MANUFACTURER ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MANUFACTURER )
• MODEL ( type: esriFieldTypeString, alias: Model, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MODEL )
• SERIAL_NUMBER ( type: esriFieldTypeString, alias: Serial Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SERIAL_NUMBER )
• PURCHASE_DATE ( type: esriFieldTypeDate, alias: Purchase Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PURCHASE_DATE )
• INITIAL_COST ( type: esriFieldTypeInteger, alias: Initial Cost, editable: true, nullable: true, defaultValue: null, modelName: INITIAL_COST )
• INSTALLATION_DATE ( type: esriFieldTypeDate, alias: Installation Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLATION_DATE )
• WARRANTYDATE ( type: esriFieldTypeDate, alias: Warranty Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WARRANTYDATE )
• REPLACEMENT_COST ( type: esriFieldTypeInteger, alias: Replacement Cost, editable: true, nullable: true, defaultValue: null, modelName: REPLACEMENT_COST )
• REMAINING_VALUE ( type: esriFieldTypeInteger, alias: Remaining Value, editable: true, nullable: true, defaultValue: null, modelName: REMAINING_VALUE )
• OWNED_BY ( type: esriFieldTypeString, alias: Owned By, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OWNED_BY , Coded Values: [MyCodedValue: MyCodeName] , [HARRF_OPS: HARRF Operations] , [HARRF_PST: HARRF Plant Systems Technician] , ...7 more... )
• MAINTAINED_BY ( type: esriFieldTypeString, alias: Maintained By, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MAINTAINED_BY , Coded Values: [MyCodedValue: MyCodeName] , [HARRF_OPS: HARRF Operations] , [HARRF_PST: HARRF Plant Systems Technician] , ...7 more... )
• LIFECYCLE_STATUS ( type: esriFieldTypeString, alias: Lifecycle Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LIFECYCLE_STATUS , Coded Values: [INSTALLED: Installed] , [UNINSTALLED: Uninstalled] , [ABANDONEDINPLACE: Abandoned-In-Place] , ...3 more... )
• CRITICAL ( type: esriFieldTypeString, alias: Critical?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CRITICAL , Coded Values: [YES: Yes] , [NO: No] , [NA: Not Applicable] )
• CONDITION ( type: esriFieldTypeSmallInteger, alias: Condition, editable: true, nullable: true, defaultValue: null, modelName: CONDITION )
• CONDITIONDATE ( type: esriFieldTypeDate, alias: Condition Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CONDITIONDATE )
• YR_EXPECTED_END_PHYSICAL_LIFE ( type: esriFieldTypeSmallInteger, alias: Expected End of Physical Life, editable: true, nullable: true, defaultValue: null, modelName: YR_EXPECTED_END_PHYSICAL_LIFE )
• TYPICAL_YRS_FULLY_DEPRECIATE ( type: esriFieldTypeSmallInteger, alias: Typical Years to Fully Depreciate, editable: true, nullable: true, defaultValue: null, modelName: TYPICAL_YRS_FULLY_DEPRECIATE )
• DEPRECIATION_DETAILS ( type: esriFieldTypeString, alias: Depreciation Details, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DEPRECIATION_DETAILS )
• CONSEQUENCE_OF_FAILURE ( type: esriFieldTypeDouble, alias: Consequence of Failure (COF), editable: true, nullable: true, defaultValue: null, modelName: CONSEQUENCE_OF_FAILURE )
• PROBABILITY_OF_FAILURE ( type: esriFieldTypeDouble, alias: Probability of Failure (POF), editable: true, nullable: true, defaultValue: null, modelName: PROBABILITY_OF_FAILURE )
• BUSINESS_RISK_EXPOSURE ( type: esriFieldTypeDouble, alias: Business Risk Exposure (BRE), editable: true, nullable: true, defaultValue: null, modelName: BUSINESS_RISK_EXPOSURE )
• DATE_CALCULATED ( type: esriFieldTypeDate, alias: COF, POF, and BRE Calculation, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATE_CALCULATED )
• MAINTENANCE_DATE ( type: esriFieldTypeDate, alias: Maintenance Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: MAINTENANCE_DATE )
• MAINTENANCE_COMMENTS ( type: esriFieldTypeString, alias: Maintenance Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MAINTENANCE_COMMENTS )
• IMAGE_URL ( type: esriFieldTypeString, alias: Image URL, editable: true, nullable: true, length: 255, defaultValue: null, modelName: IMAGE_URL )
• COMMENTS ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: COMMENTS )
• SITE_NAME ( type: esriFieldTypeString, alias: Site Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SITE_NAME )
• PROCESS_NAME ( type: esriFieldTypeString, alias: System Name, editable: true, nullable: true, length: 100, defaultValue: null, modelName: PROCESS_NAME , Coded Values: [PRETREAT: Preliminary Treatment] , [PRIMTREAT: Primary Treatment] , [SECTREAT: Secondary Treatment] , ...13 more... )
• SUBPROCESS_NAME ( type: esriFieldTypeString, alias: Subsystem Name, editable: true, nullable: true, length: 100, defaultValue: null, modelName: SUBPROCESS_NAME , Coded Values: [SCREENING: Screening] , [PUMPING: Pumping] , [GRITREMOVAL: Grit Removal] , ...48 more... )
• SHOP_EQUIPMENT_TYPE ( type: esriFieldTypeString, alias: Shop Equipment Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SHOP_EQUIPMENT_TYPE , Coded Values: [LATHE: Lathe] , [DRILLPRESS: Drill Press] , [PLASMACUTTER: Plasma Cutter] , ...40 more... )
• POWER_SOURCE ( type: esriFieldTypeString, alias: Power Source, editable: true, nullable: true, length: 50, defaultValue: null, modelName: POWER_SOURCE , Coded Values: [DIESEL: Diesel] , [GASOLINE: Gasoline] , [PROPANE: Propane] , ...6 more... )
• VOLTAGE ( type: esriFieldTypeString, alias: Voltage (Volts), editable: true, nullable: true, length: 50, defaultValue: null, modelName: VOLTAGE , Coded Values: [12DC: 12 (DC)] , [24DC: 24 (DC)] , [24VDCLOOPEDWRD: 24 VDC (Loop Powered)] , ...26 more... )
• AMPERAGE ( type: esriFieldTypeDouble, alias: Amperage (Amps), editable: true, nullable: true, defaultValue: null, modelName: AMPERAGE )
• POWER_UOM ( type: esriFieldTypeString, alias: Power Measurement, editable: true, nullable: true, length: 50, defaultValue: null, modelName: POWER_UOM , Coded Values: [WATTS: Watts] , [HORSEPOWER: Horsepower] )
• POINT_OF_INTEREST_ID ( type: esriFieldTypeString, alias: Position ID (Relate), editable: true, nullable: true, length: 50, defaultValue: null, modelName: POINT_OF_INTEREST_ID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• LASTEDITOR ( type: esriFieldTypeString, alias: LASTEDITOR, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LASTEDITOR )
• LASTUPDATE ( type: esriFieldTypeDate, alias: LASTUPDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTUPDATE )
• ASSETSTATUS ( type: esriFieldTypeString, alias: ASSETSTATUS, editable: true, nullable: true, length: 1, defaultValue: C, modelName: ASSETSTATUS , Coded Values: [C: Current] , [R: Retired] , [A: Abandoned] , ...5 more... )

Templates:

• Name: stp_ShopEquipment
  Description:
  Prototype:
  LASTUPDATE: null
  LASTEDITOR: null
  FACILITYID: null
  LEGACY_ID: null
  CITY_ASSET_ID: null
  LOCATION: null
  PROJECT_NUMBER: null
  MANUFACTURER: null
  MODEL: null
  SERIAL_NUMBER: null
  PURCHASE_DATE: null
  INITIAL_COST: null
  INSTALLATION_DATE: null
  WARRANTYDATE: null
  REPLACEMENT_COST: null
  REMAINING_VALUE: null
  OWNED_BY: null
  MAINTAINED_BY: null
  LIFECYCLE_STATUS: null
  CRITICAL: null
  CONDITION: null
  CONDITIONDATE: null
  YR_EXPECTED_END_PHYSICAL_LIFE: null
  TYPICAL_YRS_FULLY_DEPRECIATE: null
  DEPRECIATION_DETAILS: null
  CONSEQUENCE_OF_FAILURE: null
  PROBABILITY_OF_FAILURE: null
  BUSINESS_RISK_EXPOSURE: null
  DATE_CALCULATED: null
  MAINTENANCE_DATE: null
  MAINTENANCE_COMMENTS: null
  IMAGE_URL: null
  COMMENTS: null
  SITE_NAME: null
  PROCESS_NAME: null
  SUBPROCESS_NAME: null
  SHOP_EQUIPMENT_TYPE: null
  POWER_SOURCE: null
  VOLTAGE: null
  AMPERAGE: null
  POWER_UOM: null
  POINT_OF_INTEREST_ID: null
  ASSETSTATUS: C
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

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

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Attachments   Query Related Records   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata