Name: stp_Breaker

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... )
• BREAKER_TYPE ( type: esriFieldTypeString, alias: Breaker Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BREAKER_TYPE , Coded Values: [DRAWOUT: Drawout] , [MOLDEDCASE: Molded Case] )
• 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... )
• UNDER_VOLTAGE ( type: esriFieldTypeDouble, alias: Under Voltage (% of Volts), editable: true, nullable: true, defaultValue: null, modelName: UNDER_VOLTAGE )
• OVER_VOLTAGE ( type: esriFieldTypeDouble, alias: Over Voltage (% Volts), editable: true, nullable: true, defaultValue: null, modelName: OVER_VOLTAGE )
• FRAME_AMPS ( type: esriFieldTypeDouble, alias: Frame Amperage (Amps), editable: true, nullable: true, defaultValue: null, modelName: FRAME_AMPS )
• AMPS_PLUG ( type: esriFieldTypeDouble, alias: Amps Plug (Amps), editable: true, nullable: true, defaultValue: null, modelName: AMPS_PLUG )
• INSTANTANEOUS ( type: esriFieldTypeDouble, alias: Instantaneous (Current Amps), editable: true, nullable: true, defaultValue: null, modelName: INSTANTANEOUS )
• LONG_TIME_PICKUP ( type: esriFieldTypeDouble, alias: Long Time Pickup (Current Amps), editable: true, nullable: true, defaultValue: null, modelName: LONG_TIME_PICKUP )
• SHORT_TIME_PICKUP ( type: esriFieldTypeDouble, alias: Short Time Pickup (Current Amps), editable: true, nullable: true, defaultValue: null, modelName: SHORT_TIME_PICKUP )
• GROUND_FAULT ( type: esriFieldTypeDouble, alias: Ground Fault (Current Amps), editable: true, nullable: true, defaultValue: null, modelName: GROUNF_FAULT )
• NEUTRAL_OVERLOAD ( type: esriFieldTypeDouble, alias: Neutral Overload (Current Amps), editable: true, nullable: true, defaultValue: null, modelName: NEUTRAL_OVERLOAD )
• POWER_PHASE ( type: esriFieldTypeString, alias: Power Phase, editable: true, nullable: true, length: 50, defaultValue: null, modelName: POWER_PHASE , Coded Values: [SINGLE: Single] , [THREE: Three] )
• PHASE_LOSS ( type: esriFieldTypeString, alias: Phase Loss?, editable: true, nullable: true, length: 3, defaultValue: null, modelName: PHASE_LOSS , Coded Values: [YES: Yes] , [NO: No] , [NA: Not Applicable] )
• QUICK_TRIP ( type: esriFieldTypeString, alias: Quick Trip?, editable: true, nullable: true, length: 3, defaultValue: null, modelName: QUICK_TRIP , Coded Values: [YES: Yes] , [NO: No] , [NA: Not Applicable] )
• CURRENT_RATING ( type: esriFieldTypeDouble, alias: Current Rating (AIC), editable: true, nullable: true, defaultValue: null, modelName: CURRENT_RATING )
• ARC_FLASH_RATING ( type: esriFieldTypeSmallInteger, alias: Arc Flash Rating, editable: true, nullable: true, defaultValue: null, modelName: ARC_FLASH_RATING )
• BUS_RATING ( type: esriFieldTypeString, alias: Bus Rating, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BUS_RATING , Coded Values: [400: 400] , [600: 600] , [800: 800] , ...10 more... )
• WIRE_RATING ( type: esriFieldTypeString, alias: Wire Rating, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WIRE_RATING , Coded Values: [600A: 600A] , [3WIRE: 3-Wire] , [4WIRE: 4-Wire] )
• MANF_FO_NUMBER ( type: esriFieldTypeString, alias: Manufacturer FO Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MANF_FO_NUMBER )
• 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_Breaker
  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
  BREAKER_TYPE: null
  VOLTAGE: null
  UNDER_VOLTAGE: null
  OVER_VOLTAGE: null
  FRAME_AMPS: null
  AMPS_PLUG: null
  INSTANTANEOUS: null
  LONG_TIME_PICKUP: null
  SHORT_TIME_PICKUP: null
  GROUND_FAULT: null
  NEUTRAL_OVERLOAD: null
  POWER_PHASE: null
  PHASE_LOSS: null
  QUICK_TRIP: null
  CURRENT_RATING: null
  ARC_FLASH_RATING: null
  BUS_RATING: null
  WIRE_RATING: null
  MANF_FO_NUMBER: null
  POINT_OF_INTEREST_ID: null
  ASSETSTATUS: C
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• tp_PointsOfInterest (58) -- 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