Name: WTP Transformer

Display Field: AssetType

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• AssetType (type: esriFieldTypeString, alias: AssetType, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Aerator: Aerator], [Air Compressor: Air Compressor], [Air Handler: Air Handler], ... 63 more ...)
• Asset (type: esriFieldTypeString, alias: Asset, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Process (type: esriFieldTypeString, alias: Process, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Raw Water: Raw Water], [Residuals: Residuals], [Treated Water: Treated Water], ... 2 more ...)
• Subprocess (type: esriFieldTypeString, alias: Subprocess, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Chemical Bulk Tanks: Chemical Bulk Tanks], [Chemical System: Chemical System], [Drying Bed Pump Station: Drying Bed Pump Station], ... 35 more ...)
• Assembly (type: esriFieldTypeString, alias: Assembly, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Air Scour System: Air Scour System], [Ammonia: Ammonia], [Belt Filter Press System: Belt Filter Press System], ... 30 more ...)
• LegacyAssetID (type: esriFieldTypeString, alias: LegacyAssetID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Manufacturer (type: esriFieldTypeString, alias: Manufacturer, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ModelType (type: esriFieldTypeString, alias: ModelType, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SerialNumber (type: esriFieldTypeString, alias: SerialNumber, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ConditionRating (type: esriFieldTypeDouble, alias: ConditionRating, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• AssetID (type: esriFieldTypeString, alias: AssetID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DisplayID (type: esriFieldTypeString, alias: DisplayID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Plant (type: esriFieldTypeString, alias: Plant, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [TGB-WTP: Timothy G. Broome WTP], [CJCR-WWTP: Central Johnston County Regional WWTP])
• Status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Active: Active], [Inactive: Inactive], [Retired: Retired])
• Manual_Location (type: esriFieldTypeString, alias: Manual_Location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Hyperlink (type: esriFieldTypeString, alias: Hyperlink, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Voltage (type: esriFieldTypeString, alias: Voltage, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Power_kW (type: esriFieldTypeDouble, alias: Power_kW, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Range_ (type: esriFieldTypeString, alias: Range, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Horsepower (type: esriFieldTypeDouble, alias: Horsepower, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Flow_gpm (type: esriFieldTypeString, alias: Flow_gpm, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Head_ft (type: esriFieldTypeString, alias: Head_ft, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RotationalSpeed_rpm (type: esriFieldTypeString, alias: RotationalSpeed_rpm, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Power_kVA (type: esriFieldTypeDouble, alias: Power_kVA, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Size_in (type: esriFieldTypeDouble, alias: Size_in, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Pressure_psi (type: esriFieldTypeString, alias: Pressure_psi, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ParentAssetID (type: esriFieldTypeString, alias: ParentAssetID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Templates:

Name: WTP Transformer
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• TBG_Assemblies (31) -- Related To: TBG_Assemblies (0)
• TGB_Subprocesses (66) -- Related To: TGB_Subprocesses (1)
• TGB_Processes (101) -- Related To: TGB_Processes (2)
• Plants (301) -- Related To: Plants (6)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 11/13/2024 9:53:47 PM

Schema Last Edit Date: 11/13/2024 9:53:47 PM

Data Last Edit Date: 11/13/2024 9:53:47 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat