Name: Assets

Display Field: AssetDescription

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

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

Templates:

• Name: Assets
  Description:
  Prototype:
  OldAssetID: null
  DateCreated: null
  AssetID: null
  AssetDescription: null
  Make: null
  Model: null
  PrimaryVoltage: null
  SerialNumber: null
  SecondaryVoltage: null
  DateAcquired: null
  DateSold: null
  PurchasePrice: null
  DepreciationMethod: null
  DepreciableLife: null
  SalvageValue: null
  CurrentValue: null
  Description: null
  NextSchedMaint: null
  Phase: null
  PhasingCode: null
  WorkOrderNumber: null
  AssetCategoryID: null
  AssetType: null
  Status: null
  Manufacturer: null
  Vendor: null
  Location: null
  PurchaseOrderNumber: null
  Notes: null
  ReceivedBy: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• NBUAssets.DBO.AssetTable_DummyPoints (0) -- Related To: AssetTable_DummyPoints (13)

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Attachments   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata