Name: MaintenanceBlowoffHistory

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

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 )
• worktype ( type: esriFieldTypeString, alias: Work Type, editable: true, nullable: true, length: 50, defaultValue: Blowoff Flush, modelName: worktype )
• attachmentid ( type: esriFieldTypeInteger, alias: AttachmentID, editable: true, nullable: true, defaultValue: null, modelName: attachmentid )
• comments ( type: esriFieldTypeString, alias: comments, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: comments )
• diameter ( type: esriFieldTypeSmallInteger, alias: Diameter, editable: true, nullable: true, defaultValue: null, modelName: diameter , Coded Values: [1: 1"] , [2: 2"] , [3: 3"] , ...1 more... )
• teststart ( type: esriFieldTypeDate, alias: Test Start Time, editable: true, nullable: true, length: 8, defaultValue: null, modelName: teststart )
• beginturbidity ( type: esriFieldTypeDouble, alias: Beginning Turbidity, editable: true, nullable: true, defaultValue: null, modelName: beginturbidity )
• begincl2 ( type: esriFieldTypeDouble, alias: Beginning Chlorine, editable: true, nullable: true, defaultValue: null, modelName: begincl2 )
• beginwatertemp ( type: esriFieldTypeDouble, alias: Beginning Water Temp, editable: true, nullable: true, defaultValue: null, modelName: beginwatertemp )
• endturbidity ( type: esriFieldTypeDouble, alias: End Turbidity, editable: true, nullable: true, defaultValue: null, modelName: endturbidity )
• endcl2 ( type: esriFieldTypeDouble, alias: End Chlorine, editable: true, nullable: true, defaultValue: null, modelName: endcl2 )
• pitot ( type: esriFieldTypeDouble, alias: Pitot Gauge, editable: true, nullable: true, defaultValue: null, modelName: pitot )
• testend ( type: esriFieldTypeDate, alias: Test End Time, editable: true, nullable: true, length: 8, defaultValue: null, modelName: testend )
• testduration ( type: esriFieldTypeDouble, alias: Test Duration Time, editable: true, nullable: true, defaultValue: null, modelName: testduration )
• staticpressure ( type: esriFieldTypeDouble, alias: Static Pressure, editable: true, nullable: true, defaultValue: null, modelName: staticpressure )
• flow ( type: esriFieldTypeString, alias: Flow Rate, editable: true, nullable: true, length: 250, defaultValue: null, modelName: flow , Coded Values: [None: None] , [Light: Light] , [Medium: Medium] , ...1 more... )
• issue ( type: esriFieldTypeString, alias: Issue, editable: true, nullable: true, length: 250, defaultValue: null, modelName: issue )
• additionalwork ( type: esriFieldTypeString, alias: Additional Work, editable: true, nullable: true, length: 250, defaultValue: null, modelName: additionalwork , Coded Values: [No: No] , [Needs Replaced: Needs Replaced] , [Paved Over: Paved Over] , ...4 more... )
• flowrate ( type: esriFieldTypeDouble, alias: Flow Rate, editable: true, nullable: true, defaultValue: null, modelName: flowrate )
• waterloss ( type: esriFieldTypeDouble, alias: Water Loss, editable: true, nullable: true, defaultValue: null, modelName: waterloss )
• phreading ( type: esriFieldTypeDouble, alias: pH Reading, editable: true, nullable: true, defaultValue: null, modelName: phreading )
• ph ( type: esriFieldTypeDouble, alias: pH, editable: true, nullable: true, defaultValue: null, modelName: ph )
• attachmentid2 ( type: esriFieldTypeInteger, alias: AttachmentID2, editable: true, nullable: true, defaultValue: null, modelName: attachmentid2 )
• DepthofMain ( type: esriFieldTypeSingle, alias: Depth of Main, editable: true, nullable: true, defaultValue: 4.5, modelName: DepthofMain )
• MeasureDown ( type: esriFieldTypeInteger, alias: Measure Down, editable: true, nullable: true, defaultValue: null, modelName: MeasureDown )
• ValveBoxStatus ( type: esriFieldTypeString, alias: Valve Box Status, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ValveBoxStatus )
• ValveBoxCleaned ( type: esriFieldTypeString, alias: Valve Box Cleaned, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ValveBoxCleaned )
• OperatingNut ( type: esriFieldTypeString, alias: Operating Nut, editable: true, nullable: true, length: 255, defaultValue: null, modelName: OperatingNut )
• AdditionalWorkComment ( type: esriFieldTypeString, alias: AdditionalWorkComment, editable: true, nullable: true, length: 255, defaultValue: null, modelName: AdditionalWorkComment )
• AttatchmentID3 ( type: esriFieldTypeInteger, alias: AttatchmentID3, editable: true, nullable: true, defaultValue: null, modelName: AttatchmentID3 )
• 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 )
• BO_ValveType ( type: esriFieldTypeString, alias: Type of Valve, editable: true, nullable: true, length: 255, defaultValue: null, modelName: BO_ValveType , Coded Values: [Gate: Gate] , [Ball: Ball] )
• BO_ThreadType ( type: esriFieldTypeString, alias: ThreadType, editable: true, nullable: true, length: 255, defaultValue: null, modelName: BO_ThreadType , Coded Values: [Male: Male] , [Female: Female] )
• EndWaterTemp ( type: esriFieldTypeDouble, alias: End Water Temp, editable: true, nullable: true, defaultValue: null, modelName: EndWaterTemp )
• 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] )
• Data_Valid_Comment ( type: esriFieldTypeString, alias: Data Valid Comment, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Data_Valid_Comment )

Templates:

• Name: MaintenanceBlowoffHistory
  Description:
  Prototype:
  DataValid: null
  EndWaterTemp: null
  assetkey: null
  workorderid: null
  workdate: null
  workby: null
  turnstoclose: null
  worktype: Blowoff Flush
  attachmentid: null
  comments: null
  diameter: null
  teststart: null
  beginturbidity: null
  begincl2: null
  beginwatertemp: null
  endturbidity: null
  endcl2: null
  pitot: null
  testend: null
  testduration: null
  staticpressure: null
  flow: null
  issue: null
  additionalwork: null
  flowrate: null
  waterloss: null
  phreading: null
  ph: null
  attachmentid2: null
  DepthofMain: 4.5
  MeasureDown: null
  ValveBoxStatus: null
  ValveBoxCleaned: null
  OperatingNut: null
  AdditionalWorkComment: null
  AttatchmentID3: null
  WorkingHours: null
  Man_Hours_Breakdown: null
  Data_Valid_Comment: null
  GUID: null
  BO_ValveType: null
  BO_ThreadType: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• GIS_PROD.GDB_ADMIN.wBlowoff (0) -- Related To: Blow-off (15)

Capabilities: Query,Update,Uploads,Editing,Extract

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   Update Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata