Name: PumpChangeOut

Display Field: LOCATIONNAME

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

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: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• LOCATIONNAME ( type: esriFieldTypeString, alias: Location Name, editable: true, nullable: true, length: 100, defaultValue: null, modelName: LOCATIONNAME )
• DISCIPLINE ( type: esriFieldTypeString, alias: Discipline, editable: true, nullable: true, length: 100, defaultValue: null, modelName: DISCIPLINE )
• ASSETTYPE ( type: esriFieldTypeString, alias: Asset Type, editable: true, nullable: true, length: 100, defaultValue: null, modelName: ASSETTYPE )
• ASSETNAME ( type: esriFieldTypeString, alias: Asset Name, editable: true, nullable: true, length: 100, defaultValue: null, modelName: ASSETNAME )
• ASSETID ( type: esriFieldTypeString, alias: Cityworks AssetID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: ASSETID )
• POWER ( type: esriFieldTypeString, alias: Power, editable: true, nullable: true, length: 25, defaultValue: null, modelName: POWER )
• CONDITIONSCOREDATE ( type: esriFieldTypeDate, alias: Condition Score Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CONDITIONSCOREDATE )
• CONDITIONMETHOD ( type: esriFieldTypeString, alias: Condition Method, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CONDITIONMETHOD )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• MANUFACTUREYR ( type: esriFieldTypeString, alias: Manufacture Year, editable: true, nullable: true, length: 4, defaultValue: null, modelName: MANUFACTUREYR )
• CRITICALSCORE ( type: esriFieldTypeSmallInteger, alias: Critical Score, editable: true, nullable: true, defaultValue: null, modelName: CRITICALSCORE )
• CRITICALSCOREDATE ( type: esriFieldTypeDate, alias: Critical Score Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CRITICALSCOREDATE )
• BRE ( type: esriFieldTypeString, alias: BRE, editable: true, nullable: true, length: 25, defaultValue: null, modelName: BRE )
• 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 )
• TYPE ( type: esriFieldTypeString, alias: Type, editable: true, nullable: true, length: 100, defaultValue: null, modelName: TYPE )
• SERIALNUM ( type: esriFieldTypeString, alias: Serial Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SERIALNUM )
• DIAMETER ( type: esriFieldTypeString, alias: Diameter, editable: true, nullable: true, length: 10, defaultValue: null, modelName: DIAMETER )
• MATERIAL ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 25, defaultValue: null, modelName: MATERIAL )
• OPERATORTYPE ( type: esriFieldTypeString, alias: Operator Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OPERATORTYPE )
• CAPACITY ( type: esriFieldTypeString, alias: Capacity, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CAPACITY )
• UNITS ( type: esriFieldTypeString, alias: Units, editable: true, nullable: true, length: 25, defaultValue: null, modelName: UNITS )
• PRESSURERATING ( type: esriFieldTypeString, alias: Pressure Rating, editable: true, nullable: true, length: 25, defaultValue: null, modelName: PRESSURERATING )
• LINKFIELD ( type: esriFieldTypeString, alias: Link Field, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LINKFIELD )
• INSTALLCOST ( type: esriFieldTypeDouble, alias: Install Cost, editable: true, nullable: true, defaultValue: null, modelName: INSTALLCOST )
• DEPRECATIONSTART ( type: esriFieldTypeString, alias: Deprecation Start, editable: true, nullable: true, length: 100, defaultValue: null, modelName: DEPRECATIONSTART )
• DEPRECATIONSCHEDULE ( type: esriFieldTypeString, alias: Deprecation Schedule, editable: true, nullable: true, length: 100, defaultValue: null, modelName: DEPRECATIONSCHEDULE )
• SCADATAG ( type: esriFieldTypeString, alias: SCADA Tag, editable: true, nullable: true, length: 100, defaultValue: null, modelName: SCADATAG )
• WARRANTYENDDATE ( type: esriFieldTypeDate, alias: Warranty End Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WARRANTYENDDATE )
• EUL ( type: esriFieldTypeString, alias: EUL, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EUL )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: true, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: true, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• PROBABILITY ( type: esriFieldTypeSmallInteger, alias: Probability, editable: true, nullable: true, defaultValue: null, modelName: PROBABILITY )
• CONSEQUENCE ( type: esriFieldTypeSmallInteger, alias: Consequence, editable: true, nullable: true, defaultValue: null, modelName: CONSEQUENCE )
• CRITICALITY ( type: esriFieldTypeSmallInteger, alias: Criticality, editable: true, nullable: true, defaultValue: null, modelName: CRITICALITY )
• LUBRICANTTYPE ( type: esriFieldTypeString, alias: Lubricant Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LUBRICANTTYPE )
• LUBRICANTCAPACITY ( type: esriFieldTypeString, alias: Lubricant Capacity (gal), editable: true, nullable: true, length: 50, defaultValue: null, modelName: LUBRICANTCAPACITY )
• OILFILTERPARTNUM ( type: esriFieldTypeString, alias: Oil Filter Part Number, editable: true, nullable: true, length: 25, defaultValue: null, modelName: OILFILTERPARTNUM )
• AIRFILTERPARTNUM ( type: esriFieldTypeString, alias: Air Filter Part Number, editable: true, nullable: true, length: 25, defaultValue: null, modelName: AIRFILTERPARTNUM )
• BRAKEPARTNUM ( type: esriFieldTypeString, alias: Brake Part Number, editable: true, nullable: true, length: 25, defaultValue: null, modelName: BRAKEPARTNUM )
• NEMARATING ( type: esriFieldTypeString, alias: NEMA Rating, editable: true, nullable: true, length: 25, defaultValue: null, modelName: NEMARATING )
• ASSETSTATUS ( type: esriFieldTypeString, alias: Asset Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ASSETSTATUS , Coded Values: [Production: Production] , [Repair: Repair] , [Abandoned: Abandoned] , ...2 more... )
• CONDITIONSCORES ( type: esriFieldTypeString, alias: Condition Scores, editable: true, nullable: true, length: 2, defaultValue: null, modelName: CONDITIONSCORES )
• PARENTASSETID ( type: esriFieldTypeString, alias: Parent Asset ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PARENTASSETID )
• ChangeOutDate ( type: esriFieldTypeDate, alias: Change Out Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ChangeOutDate )
• PreviousLocation ( type: esriFieldTypeString, alias: Previous Location, editable: true, nullable: true, length: 100, defaultValue: null, modelName: PreviousLocation )

Templates:

• Name: PumpChangeOut
  Description:
  Prototype:
  ChangeOutDate: null
  PARENTASSETID: null
  LOCATIONNAME: null
  DISCIPLINE: null
  ASSETTYPE: null
  ASSETNAME: null
  ASSETID: null
  POWER: null
  CONDITIONSCOREDATE: null
  CONDITIONMETHOD: null
  INSTALLDATE: null
  MANUFACTUREYR: null
  CRITICALSCORE: null
  CRITICALSCOREDATE: null
  BRE: null
  MAKE: null
  MODEL: null
  TYPE: null
  SERIALNUM: null
  DIAMETER: null
  MATERIAL: null
  OPERATORTYPE: null
  CAPACITY: null
  UNITS: null
  PRESSURERATING: null
  LINKFIELD: null
  INSTALLCOST: null
  DEPRECATIONSTART: null
  DEPRECATIONSCHEDULE: null
  SCADATAG: null
  WARRANTYENDDATE: null
  EUL: null
  PreviousLocation: null
  created_user: null
  created_date: null
  last_edited_user: null
  last_edited_date: null
  PROBABILITY: null
  CONSEQUENCE: null
  CRITICALITY: null
  LUBRICANTTYPE: null
  LUBRICANTCAPACITY: null
  OILFILTERPARTNUM: null
  AIRFILTERPARTNUM: null
  BRAKEPARTNUM: null
  NEMARATING: null
  ASSETSTATUS: null
  CONDITIONSCORES: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• PumpChangeOutLocation (0) -- Related To: PumpChangeOutLocation (0)

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

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