Name: FargoLiftStation.DBO.ssLiftStationControlPanel
Display Field: ControlPanelName
Type: Table
Geometry Type: N/A
Description: null
Copyright Text: N/A
Default Visibility: false
MaxRecordCount: 1000
Supported Query Formats: JSON, PBF
Supports Advanced Queries: true
Supports Statistics: true
Use Standardized Queries: true
Extent:
Drawing Info:
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:
-
LiftStationNumber
(
type: esriFieldTypeString, alias: Lift Station Number, length: 50
)
-
ConsequenceOfFailure
(
type: esriFieldTypeDouble, alias: ConsequenceOfFailure
)
-
ProbabilityOfFailure
(
type: esriFieldTypeDouble, alias: ProbabilityOfFailure
)
-
Mitigation
(
type: esriFieldTypeDouble, alias: Mitigation
)
-
Risk
(
type: esriFieldTypeDouble, alias: Risk
)
-
EstimatedLife
(
type: esriFieldTypeSmallInteger, alias: EstimatedLife
)
-
InstallationDate
(
type: esriFieldTypeDate, alias: InstallationDate, length: 8
)
-
Type
(
type: esriFieldTypeString, alias: Material, length: 100
)
-
ReplacementCost
(
type: esriFieldTypeDouble, alias: ReplacementCost
)
-
CostingDate
(
type: esriFieldTypeDate, alias: CostingDate, length: 8
)
-
Voltage
(
type: esriFieldTypeDouble, alias: Voltage
)
-
Phase
(
type: esriFieldTypeDouble, alias: Phase
)
-
Frequency
(
type: esriFieldTypeDouble, alias: Frequency
)
-
Manufacture
(
type: esriFieldTypeString, alias: Manufacture, length: 50
)
-
Model
(
type: esriFieldTypeString, alias: Model, length: 50
)
-
SerialNumber
(
type: esriFieldTypeString, alias: Serial Number, length: 50
)
-
GeneralContractor
(
type: esriFieldTypeString, alias: General Contractor, length: 50
)
-
EngProjectNumber
(
type: esriFieldTypeString, alias: Engineering Project Number, length: 50
)
-
USBManufacture
(
type: esriFieldTypeString, alias: USB Manufacture (May be with RTU), length: 50
)
-
USBInstallationDate
(
type: esriFieldTypeDate, alias: USB Installation Date (May be with RTU), length: 8
)
-
USBModel
(
type: esriFieldTypeString, alias: USB Model Number (May be with RTU), length: 50
)
-
USBSerialNumber
(
type: esriFieldTypeString, alias: USB Serial Number (May be with RTU), length: 50
)
-
MemoryBatteryManufacture
(
type: esriFieldTypeString, alias: Memory Battery Manufacture (May be with RTU), length: 50
)
-
MemoryBatteryModel
(
type: esriFieldTypeString, alias: Memory Battery Model Number (May be with RTU), length: 50
)
-
MemoryBatterySerialNumber
(
type: esriFieldTypeString, alias: Memory Battery Serial Number (May be with RTU), length: 50
)
-
MemoryBatteryInstallationDate
(
type: esriFieldTypeDate, alias: Installation Date of Memory Battery (May be with RTU), length: 8
)
-
USB_Battery
(
type: esriFieldTypeString, alias: USB Battery, length: 10
, Coded Values:
[Yes: Yes]
, [No: No]
)
-
MemoryBattery
(
type: esriFieldTypeString, alias: Memory Battery, length: 10
, Coded Values:
[Yes: Yes]
, [No: No]
)
-
MainBreakerManufacture
(
type: esriFieldTypeString, alias: Main Breaker Manufacture, length: 50
)
-
PumpBreakerManufacture
(
type: esriFieldTypeString, alias: Pump Breaker Manufacture, length: 50
)
-
GeneratorBreakerManufacture
(
type: esriFieldTypeString, alias: Generator Breakder Manufacture, length: 50
)
-
ControlPanelName
(
type: esriFieldTypeString, alias: ControlPanelName, length: 50
)
-
MainBreakerSize
(
type: esriFieldTypeDouble, alias: Main Breaker Size
)
-
PumpBreakerSize
(
type: esriFieldTypeDouble, alias: Pump Breaker Size
)
-
GeneratorBreakerSize
(
type: esriFieldTypeDouble, alias: Generator Breaker Size
)
-
Location
(
type: esriFieldTypeString, alias: Location, length: 200
)
-
Status
(
type: esriFieldTypeString, alias: Status, length: 50
, Coded Values:
[Planned: Planned]
, [Active: Active]
, [Abandoned: Abandoned]
, ...3 more...
)
-
Asset_ID
(
type: esriFieldTypeString, alias: Asset_ID, length: 20
)
-
Parent_ID
(
type: esriFieldTypeString, alias: Parent_ID, length: 50
)
-
OBJECTID
(
type: esriFieldTypeOID, alias: OBJECTID
)
-
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
)
-
OldParentID
(
type: esriFieldTypeString, alias: OldParentID, length: 50
)
Relationships:
Supported Operations:
Query
Query Attachments
Query Analytic
Query Related Records
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata