Name: Sewer Pipe Work Order

Display Field: WO_Date

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 6e0b5dee06df452bbbdfdb6dbe2cf17b

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:

• WO_Date ( type: esriFieldTypeDate, alias: Work Order Date, length: 8 )
• Street ( type: esriFieldTypeString, alias: Street, length: 50 )
• From_Manhole ( type: esriFieldTypeString, alias: From Manhole, length: 50 )
• To_Manhole ( type: esriFieldTypeString, alias: To Manhole, length: 50 )
• PipeSize ( type: esriFieldTypeString, alias: Pipe Size, length: 50 )
• TotalFeet ( type: esriFieldTypeString, alias: Total Feet, length: 50 )
• Remarks ( type: esriFieldTypeString, alias: Remarks, length: 50 )
• Contractor ( type: esriFieldTypeString, alias: Contractor, length: 50 , Coded Values: [Dukes: Dukes] )
• Type ( type: esriFieldTypeString, alias: Work Type, length: 50 , Coded Values: [Jetting: Jetting] , [TV: TV] , [Root Cutting: Root Cutting] , ...4 more... )
• System ( type: esriFieldTypeString, alias: System, length: 50 , Coded Values: [Storm: Storm] , [Sanitary: Sanitary] )
• GuarEnd ( type: esriFieldTypeString, alias: Guarantee End, length: 50 )
• CreatedBy ( type: esriFieldTypeString, alias: CreatedBy, length: 50 )
• CreatedDate ( type: esriFieldTypeDate, alias: CreatedDate, length: 8 )
• EditBy ( type: esriFieldTypeString, alias: Edit By, length: 50 )
• Edit_Date ( type: esriFieldTypeDate, alias: Edit Date, length: 8 )
• JobNumber ( type: esriFieldTypeString, alias: Job Number, length: 50 )
• GUID_Relation ( type: esriFieldTypeGUID, alias: GUID_Relation, length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• PipeID_2 ( type: esriFieldTypeString, alias: PipeID_2, length: 50 )
• WorkPerformedBy ( type: esriFieldTypeString, alias: Work Performed By, length: 50 )
• Length ( type: esriFieldTypeSingle, alias: Length(ft) )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• WorkStatus ( type: esriFieldTypeString, alias: Work Status, length: 255 , Coded Values: [OPEN: Open] , [CLOSED: Closed] )

Relationships:

• SewerPipes (2) -- Related To: Pipes (4)

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

  Iteminfo   Thumbnail   Metadata