Name: OH_Transformers_On_Pole

Display Field: CreationUser

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Max Record Count: 20000

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: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• CreationUser (type: esriFieldTypeString, alias: Creation User, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• DateCreated (type: esriFieldTypeDate, alias: Date Created, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DateModified (type: esriFieldTypeDate, alias: Date Modified, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LastUser (type: esriFieldTypeString, alias: Last User, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• FacilityID (type: esriFieldTypeString, alias: Facility ID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• PhasingCode (type: esriFieldTypeInteger, alias: Phasing Code, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [4: A], [2: B], [1: C], ... 4 more ...)
• SerialNumber (type: esriFieldTypeString, alias: Serial Number, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• Manufacturer (type: esriFieldTypeString, alias: Manufacturer, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [ABB Power: ABB Power], [Allis Chalmers: Allis Chalmers], [Central Moloney: Central Moloney], ... 15 more ...)
• RatedKVA (type: esriFieldTypeDouble, alias: Rated kVA, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1 kVa], [5: 5 kVa], [10: 10 kVa], ... 20 more ...)
• XfmrType (type: esriFieldTypeString, alias: Transformer Type, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• Status (type: esriFieldTypeString, alias: Transformer Status, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• Impedance (type: esriFieldTypeDouble, alias: Impedance, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NLLoss (type: esriFieldTypeDouble, alias: No Load Losses, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FLLoss (type: esriFieldTypeDouble, alias: Full Load Losses, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Price (type: esriFieldTypeDouble, alias: Purchase Price, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MfgDate (type: esriFieldTypeDate, alias: Manufacture Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PCBCode (type: esriFieldTypeString, alias: PCB Code, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• SubtypeCode (type: esriFieldTypeInteger, alias: Subtype, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TransformerID (type: esriFieldTypeInteger, alias: Transformer Object ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TransformerBankID (type: esriFieldTypeString, alias: TransformerBankID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• MOBILEUSER (type: esriFieldTypeString, alias: MOBILEUSER, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• MOBILEDATE (type: esriFieldTypeDate, alias: MOBILEDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• RF_TransformerNumber (type: esriFieldTypeString, alias: Transformer Number, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• RF_Installer (type: esriFieldTypeString, alias: Installer, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• RF_Weight (type: esriFieldTypeString, alias: Weight, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• RF_GallonsOil (type: esriFieldTypeString, alias: Gallons of Oil, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• RF_Energized (type: esriFieldTypeDate, alias: Date Energized, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• RF_DeEnergized (type: esriFieldTypeDate, alias: Date De-Energized, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• RF_TransfStatus (type: esriFieldTypeInteger, alias: Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: New], [2: Used])
• RF_PCBSticker (type: esriFieldTypeInteger, alias: PCB Oil Sticker, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [0: No])
• RF_Voltage (type: esriFieldTypeInteger, alias: Voltage, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [160: 4.16/7.2 kV], [210: 7.2/12.4 kV], [230: 7.6/13.2 kV], ... 3 more ...)
• PoleID (type: esriFieldTypeString, alias: PoleID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• RF_StockNo (type: esriFieldTypeString, alias: RF_StockNo, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• RF_Substation (type: esriFieldTypeSmallInteger, alias: RF_Substation, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: AVA], [2: CEN], [3: 14S])
• RF_Feeder (type: esriFieldTypeString, alias: RF_Feeder, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [1: 1], [2: 2], [3: 3], ... 1 more ...)
• RF_Sub (type: esriFieldTypeString, alias: RF_Sub, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [1: AVA], [2: CEN], [3: 14S])
• MapPage (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• GridNumber (type: esriFieldTypeString, alias: GridNumber, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SecVolt (type: esriFieldTypeString, alias: SecVolt, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [120240: 120-240], [120208: 120-208], [240480: 240-480], ... 1 more ...)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• GlobalID_Pole (type: esriFieldTypeGUID, alias: GlobalID_Pole, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)

Templates:

Name: OH_Transformers_On_Pole
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• RatedKVA: 25
• SubtypeCode: 1

Relationships:

• ElectricPoles (2) -- Related To: Poles (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/22/2025 3:16:42 PM

Schema Last Edit Date: 7/22/2025 3:16:42 PM

Data Last Edit Date: 7/22/2025 3:16:42 PM

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