Name: ValveHistory

Display Field: assetkey

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: System-maintained ObjectID )
• assetkey ( type: esriFieldTypeString, alias: Asset Key, editable: true, nullable: true, length: 20, defaultValue: null, modelName: assetkey )
• workorderid ( type: esriFieldTypeString, alias: Workorder Key, editable: true, nullable: true, length: 50, defaultValue: null, modelName: workorderid )
• workdate ( type: esriFieldTypeDate, alias: Work Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: workdate )
• workby ( type: esriFieldTypeString, alias: Work By, editable: true, nullable: true, length: 50, defaultValue: null, modelName: workby )
• turnstoclose ( type: esriFieldTypeDouble, alias: Turns to Close, editable: true, nullable: true, defaultValue: null, modelName: turnstoclose )
• hightorque ( type: esriFieldTypeSmallInteger, alias: HighTorque, editable: true, nullable: true, defaultValue: null, modelName: hightorque )
• worktype ( type: esriFieldTypeString, alias: Work Type, editable: true, nullable: true, length: 50, defaultValue: Valve Maintenance, modelName: worktype , Coded Values: [Valve Maintenance: Valve Maintenance] , [Valve Install/Review/Update: Valve Install/Review/Update] , [Valve Data Update: Valve Data Update] , ...1 more... )
• attachmentid ( type: esriFieldTypeInteger, alias: AttachmentID, editable: true, nullable: true, defaultValue: null, modelName: attachmentid )
• currentlyopen ( type: esriFieldTypeString, alias: CurrentlyOpen, editable: true, nullable: true, length: 10, defaultValue: null, modelName: currentlyopen )
• operable ( type: esriFieldTypeString, alias: Operable, editable: true, nullable: true, length: 10, defaultValue: null, modelName: operable )
• comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: comments )
• valveboxblown ( type: esriFieldTypeString, alias: Valve Box Blown, editable: true, nullable: true, length: 50, defaultValue: null, modelName: valveboxblown )
• statusbefore ( type: esriFieldTypeString, alias: Valve Status Before, editable: true, nullable: true, length: 50, defaultValue: null, modelName: statusbefore )
• operated ( type: esriFieldTypeString, alias: Valve Operated, editable: true, nullable: true, length: 50, defaultValue: null, modelName: operated , Coded Values: [Yes: Yes] , [No: No] , [Active Work: Active Work] )
• resistance ( type: esriFieldTypeString, alias: Turn Resistance, editable: true, nullable: true, length: 50, defaultValue: null, modelName: resistance , Coded Values: [Easy: Easy] , [Average: Average] , [Hard: Hard] , ...1 more... )
• leak ( type: esriFieldTypeString, alias: Leaks Present, editable: true, nullable: true, length: 50, defaultValue: null, modelName: leak )
• currentstatus ( type: esriFieldTypeString, alias: Valves Current Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: currentstatus )
• valvebox ( type: esriFieldTypeString, alias: Valve Box Condition, editable: true, nullable: true, length: 50, defaultValue: null, modelName: valvebox , Coded Values: [Good: Good] , [Repairs Made: Repairs Made] )
• nut ( type: esriFieldTypeString, alias: Nut Condition, editable: true, nullable: true, length: 50, defaultValue: null, modelName: nut , Coded Values: [Good: Good] , [Fair: Fair] , [Rounded: Rounded] , ...2 more... )
• repairreason ( type: esriFieldTypeString, alias: Repair Reason, editable: true, nullable: true, length: 250, defaultValue: null, modelName: repairreason )
• repairdescription ( type: esriFieldTypeString, alias: Repair Description, editable: true, nullable: true, length: 250, defaultValue: null, modelName: repairdescription , Coded Values: [Valve Replace: Valve Replace] , [Valve Box Reset-Replace: Vavle Box Reset-Replace] , [Valve Nut Missing/Rounded: Valve Nut Missing/Rounded] , ...2 more... )
• attachmentid2 ( type: esriFieldTypeInteger, alias: AttachmentID, editable: true, nullable: true, defaultValue: null, modelName: attachmentid2 )
• surface ( type: esriFieldTypeString, alias: Surface, editable: true, nullable: true, length: 50, defaultValue: null, modelName: surface )
• debris ( type: esriFieldTypeString, alias: Open Direction, editable: true, nullable: true, length: 50, defaultValue: null, modelName: debris )
• nutcomment ( type: esriFieldTypeString, alias: Debris, editable: true, nullable: true, length: 200, defaultValue: null, modelName: nutcomment )
• sounded ( type: esriFieldTypeString, alias: Nut Comment, editable: true, nullable: true, length: 50, defaultValue: null, modelName: sounded , Coded Values: [Yes: Yes] , [No: No] , [Active Work: Active Work] )
• resistancecomment ( type: esriFieldTypeString, alias: Sounded, editable: true, nullable: true, length: 200, defaultValue: null, modelName: resistancecomment )
• otherissue ( type: esriFieldTypeString, alias: Resistance Comment, editable: true, nullable: true, length: 200, defaultValue: null, modelName: otherissue )
• additionalwork ( type: esriFieldTypeString, alias: Other Issue, editable: true, nullable: true, length: 50, defaultValue: null, modelName: additionalwork , Coded Values: [No: No] , [Valve Replace: Valve Replace] , [Valve Box Replace: Valve Box Replace] , ...2 more... )
• reviewneeded ( type: esriFieldTypeString, alias: Status Returned, editable: true, nullable: true, length: 10, defaultValue: null, modelName: reviewneeded )
• valvecondition ( type: esriFieldTypeString, alias: Valve Condition, editable: true, nullable: true, length: 50, defaultValue: null, modelName: valvecondition )
• MeasureDown ( type: esriFieldTypeDouble, alias: MeasureDown, editable: true, nullable: true, defaultValue: null, modelName: MeasureDown )
• DataValidComment ( type: esriFieldTypeString, alias: Data Valid Comment, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DataValidComment )
• AttachmentID3 ( type: esriFieldTypeInteger, alias: AttachmentID3, editable: true, nullable: true, defaultValue: null, modelName: AttachmentID3 )
• WorkingHours ( type: esriFieldTypeInteger, alias: WorkingHours, editable: true, nullable: true, defaultValue: null, modelName: WorkingHours )
• Man_Hours_Breakdown ( type: esriFieldTypeString, alias: Man_Hours_Breakdown, editable: true, nullable: true, length: 500, defaultValue: null, modelName: Man_Hours_Breakdown )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• GUID ( type: esriFieldTypeGUID, alias: GUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: GUID )
• assetkey2 ( type: esriFieldTypeString, alias: assetkey2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: assetkey2 )
• DataValid_Comment ( type: esriFieldTypeString, alias: Data Valid Comment, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DataValid_Comment )
• DataValid ( type: esriFieldTypeString, alias: Data Valid, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DataValid , Coded Values: [Yes: Yes] , [No: No] , [Active Work: Active Work] )
• commentaddwork ( type: esriFieldTypeString, alias: Additional Work Comment, editable: true, nullable: true, length: 255, defaultValue: null, modelName: commentaddwork )
• outofservice ( type: esriFieldTypeString, alias: Out of Service, editable: true, nullable: true, length: 255, defaultValue: null, modelName: outofservice , Coded Values: [Yes: Yes] , [No: No] , [Active Work: Active Work] )

Templates:

• Name: ValveHistory
  Description:
  Prototype:
  commentaddwork: null
  DataValid: null
  assetkey: null
  workorderid: null
  workdate: null
  workby: null
  turnstoclose: null
  hightorque: null
  worktype: Valve Maintenance
  attachmentid: null
  currentlyopen: null
  operable: null
  comments: null
  valveboxblown: null
  statusbefore: null
  operated: null
  resistance: null
  leak: null
  currentstatus: null
  valvebox: null
  nut: null
  repairreason: null
  repairdescription: null
  attachmentid2: null
  surface: null
  debris: null
  nutcomment: null
  sounded: null
  resistancecomment: null
  otherissue: null
  additionalwork: null
  reviewneeded: null
  valvecondition: null
  MeasureDown: null
  DataValidComment: null
  AttachmentID3: null
  WorkingHours: null
  Man_Hours_Breakdown: null
  outofservice: null
  GUID: null
  assetkey2: null
  DataValid_Comment: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• GIS_PROD.GDB_ADMIN.wValves (0) -- Related To: Valves (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 ApplyEdits By Upload Id: true

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