Name: Transformers

Display Field: AssetDescription

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

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

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• AssetID ( type: esriFieldTypeInteger, alias: AssetID )
• AssetDescription ( type: esriFieldTypeString, alias: KVA, length: 255 , Coded Values: [1: 1] , [15: 15] , [25: 25] , ...17 more... )
• Make ( type: esriFieldTypeString, alias: Make, length: 50 )
• Model ( type: esriFieldTypeString, alias: Model, length: 50 )
• PrimaryVoltage ( type: esriFieldTypeString, alias: PrimaryVoltage, length: 50 , Coded Values: [1: 7200] , [2: 7200/12400] , [3: 7200/12470] , ...2 more... )
• SerialNumber ( type: esriFieldTypeString, alias: SerialNumber, length: 50 )
• SecondaryVoltage ( type: esriFieldTypeString, alias: SecondaryVoltage, length: 30 , Coded Values: [1: 120/240] , [2: 120/208] , [3: 277/480] , ...7 more... )
• DateAcquired ( type: esriFieldTypeDate, alias: DateAcquired, length: 8 )
• DateSold ( type: esriFieldTypeDate, alias: DateSold, length: 8 )
• PurchasePrice ( type: esriFieldTypeDouble, alias: PurchasePrice )
• DepreciationMethod ( type: esriFieldTypeString, alias: DepreciationMethod, length: 50 )
• DepreciableLife ( type: esriFieldTypeDouble, alias: DepreciableLife )
• SalvageValue ( type: esriFieldTypeDouble, alias: SalvageValue )
• CurrentValue ( type: esriFieldTypeDouble, alias: CurrentValue )
• Description ( type: esriFieldTypeString, alias: Description, length: 255 )
• NextSchedMaint ( type: esriFieldTypeDate, alias: NextSchedMaint, length: 8 )
• Phase ( type: esriFieldTypeString, alias: Phase, length: 50 )
• PhasingCode ( type: esriFieldTypeString, alias: PhasingCode, length: 10 )
• WorkOrderNumber ( type: esriFieldTypeInteger, alias: WorkOrderNumber )
• AssetCategoryID ( type: esriFieldTypeInteger, alias: AssetCategoryID , Coded Values: [5: Conventional] , [6: Pad Mount] , [9: Recloser] , ...4 more... )
• AssetType ( type: esriFieldTypeString, alias: AssetType, length: 25 , Coded Values: [TFX: Transformer] , [SGC: Switch Gear Cabinet] )
• Status ( type: esriFieldTypeInteger, alias: Status , Coded Values: [2: Warehouse] , [6: In Service] , [7: Repair] , ...3 more... )
• Manufacturer ( type: esriFieldTypeInteger, alias: Manufacturer , Coded Values: [7: ABB] , [8: KUHLMAN] , [9: HOWARD] , ...58 more... )
• Vendor ( type: esriFieldTypeInteger, alias: Vendor , Coded Values: [1: SUNBELT SOLOMON] , [3: Priester Supply] , [4: KBS] , ...62 more... )
• Location ( type: esriFieldTypeString, alias: Location, length: 255 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• 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 )
• ReceivedBy ( type: esriFieldTypeString, alias: ReceivedBy, length: 50 )
• Notes ( type: esriFieldTypeString, alias: Notes, length: 50 )
• DateCreated ( type: esriFieldTypeDate, alias: DateCreated, length: 8 )
• OldAssetID ( type: esriFieldTypeInteger, alias: OldAssetID )
• PurchaseOrderNumber ( type: esriFieldTypeInteger, alias: PurchaseOrderNumber )

Supported Operations:   Query   Query Attachments   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata