Name: BlowoffHistory

Display Field: assetkey

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• assetkey ( type: esriFieldTypeString, alias: Asset Key, length: 20 )
• workorderid ( type: esriFieldTypeString, alias: Workorder Key, length: 50 )
• workdate ( type: esriFieldTypeDate, alias: Work Date, length: 8 )
• workby ( type: esriFieldTypeString, alias: Work By, length: 50 )
• turnstoclose ( type: esriFieldTypeDouble, alias: Turns to Close )
• worktype ( type: esriFieldTypeString, alias: Work Type, length: 50 )
• attachmentid ( type: esriFieldTypeInteger, alias: AttachmentID )
• comments ( type: esriFieldTypeString, alias: comments, length: 1000 )
• diameter ( type: esriFieldTypeSmallInteger, alias: Diameter , Coded Values: [1: 1"] , [2: 2"] , [3: 3"] , ...1 more... )
• teststart ( type: esriFieldTypeDate, alias: Test Start Time, length: 8 )
• beginturbidity ( type: esriFieldTypeDouble, alias: Beginning Turbidity )
• begincl2 ( type: esriFieldTypeDouble, alias: Beginning Chlorine )
• beginwatertemp ( type: esriFieldTypeDouble, alias: Beginning Water Temp )
• endturbidity ( type: esriFieldTypeDouble, alias: End Turbidity )
• endcl2 ( type: esriFieldTypeDouble, alias: End Chlorine )
• pitot ( type: esriFieldTypeDouble, alias: Pitot Gauge )
• testend ( type: esriFieldTypeDate, alias: Test End Time, length: 8 )
• testduration ( type: esriFieldTypeDouble, alias: Test Duration Time )
• staticpressure ( type: esriFieldTypeDouble, alias: Static Pressure )
• flow ( type: esriFieldTypeString, alias: Flow Rate, length: 250 , Coded Values: [None: None] , [Light: Light] , [Medium: Medium] , ...1 more... )
• issue ( type: esriFieldTypeString, alias: Issue, length: 250 )
• additionalwork ( type: esriFieldTypeString, alias: Additional Work, length: 250 , Coded Values: [No: No] , [Needs Replaced: Needs Replaced] , [Paved Over: Paved Over] , ...4 more... )
• flowrate ( type: esriFieldTypeDouble, alias: Flow Rate )
• waterloss ( type: esriFieldTypeDouble, alias: Water Loss )
• phreading ( type: esriFieldTypeDouble, alias: pH Reading )
• ph ( type: esriFieldTypeDouble, alias: pH )
• attachmentid2 ( type: esriFieldTypeInteger, alias: AttachmentID2 )
• DepthofMain ( type: esriFieldTypeSingle, alias: Depth of Main )
• MeasureDown ( type: esriFieldTypeInteger, alias: Measure Down )
• ValveBoxStatus ( type: esriFieldTypeString, alias: Valve Box Status, length: 255 )
• ValveBoxCleaned ( type: esriFieldTypeString, alias: Valve Box Cleaned, length: 255 )
• OperatingNut ( type: esriFieldTypeString, alias: Operating Nut, length: 255 )
• AdditionalWorkComment ( type: esriFieldTypeString, alias: AdditionalWorkComment, length: 255 )
• AttatchmentID3 ( type: esriFieldTypeInteger, alias: AttatchmentID3 )
• WorkingHours ( type: esriFieldTypeInteger, alias: WorkingHours )
• Man_Hours_Breakdown ( type: esriFieldTypeString, alias: Man_Hours_Breakdown, length: 500 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• GUID ( type: esriFieldTypeGUID, alias: GUID, length: 38 )
• BO_ValveType ( type: esriFieldTypeString, alias: Type of Valve, length: 255 , Coded Values: [Gate: Gate] , [Ball: Ball] )
• BO_ThreadType ( type: esriFieldTypeString, alias: ThreadType, length: 255 , Coded Values: [Male: Male] , [Female: Female] )
• EndWaterTemp ( type: esriFieldTypeDouble, alias: End Water Temp )
• DataValid ( type: esriFieldTypeString, alias: Data Valid, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [Active Work: Active Work] )
• Data_Valid_Comment ( type: esriFieldTypeString, alias: Data Valid Comment, length: 255 )

Relationships:

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

Supported Operations:   Query   Query Attachments   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata