Name: TransformerUnit

Display Field: CREATIONUSER

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

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: 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: 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)
• 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])
• UNITSIZE (type: esriFieldTypeInteger, alias: UnitSize, SQL Type: sqlTypeOther, nullable: true, editable: true)
• 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], ... 8 more ...)
• MFG (type: esriFieldTypeString, alias: MFG, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• 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 ...)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• 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

Relationships:

• Transformer (1) -- Related To: PCB Transformers (17)
• Transformer (5) -- Related To: Transformers (18)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/2/2026 5:57:27 PM

Schema Last Edit Date: 6/2/2026 5:56:49 PM

Data Last Edit Date: 6/23/2026 2:48:05 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat