Name: SYSTEM_ASSETS

Display Field: ASSETNAME

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 8918931698a64729ae7646e260e20ae0

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
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• SMARTTAG ( type: esriFieldTypeString, alias: SMARTTag, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SMARTTAG )
• LEGACYID ( type: esriFieldTypeString, alias: Legacy ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LEGACYID )
• ASSETNAME ( type: esriFieldTypeString, alias: Asset Name, editable: true, nullable: true, length: 125, defaultValue: null, modelName: ASSETNAME )
• ASSETDESCRIPTION ( type: esriFieldTypeString, alias: Asset Description, editable: true, nullable: true, length: 125, defaultValue: null, modelName: ASSETDESCRIPTION )
• MANUFACTURER ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 100, defaultValue: null, modelName: MANUFACTURER )
• MODELNUMBER ( type: esriFieldTypeString, alias: Model Number, editable: true, nullable: true, length: 200, defaultValue: null, modelName: MODELNUMBER )
• SERIALNUMBER ( type: esriFieldTypeString, alias: Serial Number, editable: true, nullable: true, length: 200, defaultValue: null, modelName: SERIALNUMBER )
• ASSETSUBTYPE ( type: esriFieldTypeString, alias: Asset Sub Type, editable: true, nullable: true, length: 125, defaultValue: null, modelName: ASSETSUBTYPE )
• ASSOCIATEDEQUIP ( type: esriFieldTypeString, alias: Associated Equipment, editable: true, nullable: true, length: 200, defaultValue: null, modelName: ASSOCIATEDEQUIP )
• QUANTITY ( type: esriFieldTypeDouble, alias: Quantity, editable: true, nullable: true, defaultValue: null, modelName: QUANTITY )
• MATERIAL ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MATERIAL )
• SIZE1 ( type: esriFieldTypeString, alias: Size1, editable: true, nullable: true, length: 25, defaultValue: null, modelName: SIZE1 )
• UNIT1 ( type: esriFieldTypeString, alias: Unit1, editable: true, nullable: true, length: 25, defaultValue: null, modelName: UNIT1 )
• SIZE2 ( type: esriFieldTypeString, alias: Size2, editable: true, nullable: true, length: 25, defaultValue: null, modelName: SIZE2 )
• UNIT2 ( type: esriFieldTypeString, alias: Unit2, editable: true, nullable: true, length: 25, defaultValue: null, modelName: UNIT2 )
• SIZE3 ( type: esriFieldTypeString, alias: Size3, editable: true, nullable: true, length: 25, defaultValue: null, modelName: SIZE3 )
• UNIT3 ( type: esriFieldTypeString, alias: Unit3, editable: true, nullable: true, length: 25, defaultValue: null, modelName: UNIT3 )
• SIZE4 ( type: esriFieldTypeString, alias: Size4, editable: true, nullable: true, length: 25, defaultValue: null, modelName: SIZE4 )
• UNIT4 ( type: esriFieldTypeString, alias: Unit4, editable: true, nullable: true, length: 25, defaultValue: null, modelName: UNIT4 )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Installation Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• WARRANTYDATE ( type: esriFieldTypeDate, alias: Warranty Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WARRANTYDATE )
• SITE ( type: esriFieldTypeString, alias: Site, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SITE )
• LOCATION ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 100, defaultValue: null, modelName: LOCATION )
• PROCESS ( type: esriFieldTypeString, alias: Process, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PROCESS )
• SUBPROCESS ( type: esriFieldTypeString, alias: Sub Process, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SUBPROCESS )
• SYSTEM ( type: esriFieldTypeString, alias: System, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SYSTEM )
• LOCATIONTYPE ( type: esriFieldTypeString, alias: Location Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LOCATIONTYPE )
• USEFULLIFE_ACC ( type: esriFieldTypeDouble, alias: Useful Life, editable: true, nullable: true, defaultValue: null, modelName: USEFULLIFE_ACC )
• USEFULLIFE_AM ( type: esriFieldTypeDouble, alias: Service Life, editable: true, nullable: true, defaultValue: null, modelName: USEFULLIFE_AM )
• CONDITION ( type: esriFieldTypeDouble, alias: Condition, editable: true, nullable: true, defaultValue: null, modelName: CONDITION )
• TARGETCONDITION ( type: esriFieldTypeDouble, alias: Target Condition, editable: true, nullable: true, defaultValue: null, modelName: TARGETCONDITION )
• CONDITIONCOMMENT ( type: esriFieldTypeString, alias: Condition Comment, editable: true, nullable: true, length: 250, defaultValue: null, modelName: CONDITIONCOMMENT )
• CONDITIONDATE ( type: esriFieldTypeDate, alias: Condition Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CONDITIONDATE )
• POF ( type: esriFieldTypeDouble, alias: Probability of Failure, editable: true, nullable: true, defaultValue: null, modelName: POF )
• COF ( type: esriFieldTypeDouble, alias: Consequence of Failure, editable: true, nullable: true, defaultValue: null, modelName: COF )
• BRE ( type: esriFieldTypeDouble, alias: Business Risk Exposure, editable: true, nullable: true, defaultValue: null, modelName: BRE )
• REPLACEMENTCOST ( type: esriFieldTypeDouble, alias: Replacement Cost, editable: true, nullable: true, defaultValue: null, modelName: REPLACEMENTCOST )
• REPLACEMENTCOSTVAR ( type: esriFieldTypeDouble, alias: Replacement Cost Adjustment, editable: true, nullable: true, defaultValue: null, modelName: REPLACEMENTCOSTVAR )
• LASTREHABYEAR ( type: esriFieldTypeDouble, alias: Year Last Rehabbed, editable: true, nullable: true, defaultValue: null, modelName: LASTREHABYEAR )
• REHABFREQUENCY1 ( type: esriFieldTypeDouble, alias: Rehab Frequency 1, editable: true, nullable: true, defaultValue: null, modelName: REHABFREQUENCY1 )
• REHABCOST1 ( type: esriFieldTypeDouble, alias: Rehab Cost 1, editable: true, nullable: true, defaultValue: null, modelName: REHABCOST1 )
• REHABFREQUENCY2 ( type: esriFieldTypeDouble, alias: Rehab Frequency 2, editable: true, nullable: true, defaultValue: null, modelName: REHABFREQUENCY2 )
• REHABCOST2 ( type: esriFieldTypeDouble, alias: Rehab Cost 2, editable: true, nullable: true, defaultValue: null, modelName: REHABCOST2 )
• PERCENTCONSUMED ( type: esriFieldTypeDouble, alias: Percent Consumed, editable: true, nullable: true, defaultValue: null, modelName: PERCENTCONSUMED )
• ANNUALDEPRECIATION ( type: esriFieldTypeDouble, alias: Annual Depreciation, editable: true, nullable: true, defaultValue: null, modelName: ANNUALDEPRECIATION )
• ANNUALDEPRECIATIONRATE ( type: esriFieldTypeDouble, alias: Annual Depreciation Rate, editable: true, nullable: true, defaultValue: null, modelName: ANNUALDEPRECIATIONRATE )
• LIFECYCLESTATUS ( type: esriFieldTypeString, alias: Lifecyle Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LIFECYCLESTATUS )
• LASTUPDATED ( type: esriFieldTypeDate, alias: Last Updated, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTUPDATED )
• LASTEDITOR ( type: esriFieldTypeString, alias: LastEditor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LASTEDITOR )
• COMMENTS ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 250, defaultValue: null, modelName: COMMENTS )
• IMAGES ( type: esriFieldTypeString, alias: Image Path, editable: true, nullable: true, length: 250, defaultValue: null, modelName: IMAGES )
• FINANCIALTYPE ( type: esriFieldTypeString, alias: Financial Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FINANCIALTYPE )
• FINANCIALSUBTYPE ( type: esriFieldTypeString, alias: Financial SubType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FINANCIALSUBTYPE )
• SCADATAG ( type: esriFieldTypeString, alias: SCADA Tag, editable: true, nullable: true, length: 200, defaultValue: null, modelName: SCADATAG )
• ASSETID ( type: esriFieldTypeString, alias: Asset ID, editable: true, nullable: true, length: 100, defaultValue: null, modelName: ASSETID )
• FLOORID ( type: esriFieldTypeString, alias: Relate ID - Floor ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FLOORID )
• SUBPROCESSID ( type: esriFieldTypeString, alias: Relate ID - SubProcess ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SUBPROCESSID )
• SYSTEMID ( type: esriFieldTypeString, alias: Relate ID - System ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SYSTEMID )
• ROOMID ( type: esriFieldTypeString, alias: Relate ID - Room ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ROOMID )
• PARENTASSETID ( type: esriFieldTypeString, alias: Relate ID - ParentAssetID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PARENTASSETID )
• Proc_ID ( type: esriFieldTypeString, alias: Proc_ID, editable: true, nullable: true, length: 4, defaultValue: null, modelName: Proc_ID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• Site_Proc_ID ( type: esriFieldTypeString, alias: Site_Proc_ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Site_Proc_ID )

Templates:

• Name: SYSTEM_ASSETS
  Description:
  Prototype:
  Site_Proc_ID: null
  Proc_ID: null
  SMARTTAG: null
  LEGACYID: null
  ASSETNAME: null
  ASSETDESCRIPTION: null
  MANUFACTURER: null
  MODELNUMBER: null
  SERIALNUMBER: null
  ASSETSUBTYPE: null
  ASSOCIATEDEQUIP: null
  QUANTITY: null
  MATERIAL: null
  SIZE1: null
  UNIT1: null
  SIZE2: null
  UNIT2: null
  SIZE3: null
  UNIT3: null
  SIZE4: null
  UNIT4: null
  INSTALLDATE: null
  WARRANTYDATE: null
  SITE: null
  LOCATION: null
  PROCESS: null
  SUBPROCESS: null
  SYSTEM: null
  LOCATIONTYPE: null
  USEFULLIFE_ACC: null
  USEFULLIFE_AM: null
  CONDITION: null
  TARGETCONDITION: null
  CONDITIONCOMMENT: null
  CONDITIONDATE: null
  POF: null
  COF: null
  BRE: null
  REPLACEMENTCOST: null
  REPLACEMENTCOSTVAR: null
  LASTREHABYEAR: null
  REHABFREQUENCY1: null
  REHABCOST1: null
  REHABFREQUENCY2: null
  REHABCOST2: null
  PERCENTCONSUMED: null
  ANNUALDEPRECIATION: null
  ANNUALDEPRECIATIONRATE: null
  LIFECYCLESTATUS: null
  LASTUPDATED: null
  LASTEDITOR: null
  COMMENTS: null
  IMAGES: null
  FINANCIALTYPE: null
  FINANCIALSUBTYPE: null
  SCADATAG: null
  ASSETID: null
  FLOORID: null
  SUBPROCESSID: null
  SYSTEMID: null
  ROOMID: null
  PARENTASSETID: null
  
  Drawing Tool: esriFeatureEditToolNone

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 Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:   Field Groups   Contingent Values

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