Name: TransformerUnit

Display Field: CREATIONUSER

Type: Table

Description:

Copyright Text:

Max Record Count: 10000

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)
• CREATIONUSER (type: esriFieldTypeString, alias: Creation User, SQL Type: sqlTypeOther, length: 50, 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: 50, nullable: true, editable: true)
• SUBTYPECD (type: esriFieldTypeInteger, alias: Subtype, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Overhead], [2: Underground])
• MODEL (type: esriFieldTypeString, alias: MODEL, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• SERIALNUMBER (type: esriFieldTypeString, alias: Serial Number, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• WORKORDERID (type: esriFieldTypeString, alias: Work Order ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• INSTALLATIONDATE (type: esriFieldTypeDate, alias: Installation Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• RATEDKVA (type: esriFieldTypeInteger, alias: Rated KVA, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1 kVA], [3: 3 kVA], [5: 5 kVA], ... 59 more ...)
• TRANSFORMEROBJECTID (type: esriFieldTypeInteger, alias: Transformer ObjectID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ARRESTORPRESENT (type: esriFieldTypeString, alias: ARRESTORPRESENT, SQL Type: sqlTypeOther, length: 50, nullable: false, editable: true)
• LUSNUMBER (type: esriFieldTypeString, alias: LUSNUMBER, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• PHASE (type: esriFieldTypeString, alias: Phase, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [1: A], [2: B], [3: C])
• SECVOLTAGE (type: esriFieldTypeInteger, alias: SecVoltage, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [10: 120 Volts], [20: 120/208 Volts], [30: 120/240 Volts], ... 9 more ...)
• MFG (type: esriFieldTypeString, alias: MFG, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [16: AB Chance], [1: ABB], [2: Allis Chambers], ... 39 more ...)
• COMMENTS (type: esriFieldTypeString, alias: COMMENTS, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• OLDOID (type: esriFieldTypeInteger, alias: OLDOID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SAVETRANSOID (type: esriFieldTypeInteger, alias: Saved Trans OID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PHASEDESIGNATION (type: esriFieldTypeInteger, alias: Phase Designation, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [4: A], [6: AB], [5: AC], ... 4 more ...)
• PRIVOLTAGE (type: esriFieldTypeInteger, alias: Primary Voltage, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [270: 13800/7970], [230: 13200/7620], [260: 13800 Delta], ... 2 more ...)
• PCBNOTE (type: esriFieldTypeString, alias: PCBNOTE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• PCBVALUE (type: esriFieldTypeDouble, alias: PCBVALUE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DATEMFG (type: esriFieldTypeDate, alias: Manufacture Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• IMPEDANCE (type: esriFieldTypeDouble, alias: Impedance %, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SRLNUMLINK (type: esriFieldTypeString, alias: SRLNUMLINK, SQL Type: sqlTypeOther, length: 125, nullable: true, editable: true)
• LOCATION (type: esriFieldTypeString, alias: LOCATION, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• STATUS (type: esriFieldTypeString, alias: STATUS, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [S: Stock], [IS: In Service], [REP: Send for Repair], ... 3 more ...)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)

Templates:

Name: TransformerUnit
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• ARRESTORPRESENT: N

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/11/2026 6:13:41 PM

Schema Last Edit Date: 3/11/2026 6:13:41 PM

Data Last Edit Date: 3/11/2026 6:13:41 PM

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