Name: sedaCustomerHistory

Display Field: customername

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 3000

Supported Query Formats: JSON

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: assetkey, length: 20 )
• workorderid ( type: esriFieldTypeString, alias: workorderid, length: 50 )
• workdate ( type: esriFieldTypeDate, alias: workdate, length: 8 )
• worktype ( type: esriFieldTypeString, alias: worktype, length: 50 )
• workby ( type: esriFieldTypeString, alias: workby, length: 50 )
• metersize ( type: esriFieldTypeDouble, alias: metersize , Coded Values: [0.625: 5/8"] , [0.75: 3/4"] , [1: 1''] , ...16 more... )
• meternum_old ( type: esriFieldTypeString, alias: meternum_old, length: 25 )
• meternum_new ( type: esriFieldTypeString, alias: meternum_new, length: 25 )
• miu ( type: esriFieldTypeString, alias: miu, length: 25 )
• mfg ( type: esriFieldTypeString, alias: mfg, length: 50 )
• model ( type: esriFieldTypeString, alias: model, length: 50 )
• location ( type: esriFieldTypeString, alias: location, length: 250 )
• meterread ( type: esriFieldTypeDouble, alias: meterread )
• meterread_last ( type: esriFieldTypeDouble, alias: meterread_last )
• arrival ( type: esriFieldTypeDate, alias: arrival, length: 8 )
• departure ( type: esriFieldTypeDate, alias: departure, length: 8 )
• address ( type: esriFieldTypeString, alias: address, length: 100 )
• account ( type: esriFieldTypeString, alias: account, length: 20 )
• complaint ( type: esriFieldTypeString, alias: complaint, length: 250 )
• wodesc ( type: esriFieldTypeString, alias: wodesc, length: 250 )
• wonotes ( type: esriFieldTypeString, alias: wonotes, length: 250 )
• customername ( type: esriFieldTypeString, alias: customername, length: 50 )
• contactinfo ( type: esriFieldTypeString, alias: contactinfo, length: 50 )
• conditionfound ( type: esriFieldTypeString, alias: conditionfound, length: 100 )
• waterusebkp ( type: esriFieldTypeString, alias: waterusebkp, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• lateralproblem ( type: esriFieldTypeString, alias: lateralproblem, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• ssmhchecked ( type: esriFieldTypeString, alias: ssmhchecked, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• surcharged ( type: esriFieldTypeString, alias: surcharged, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• sewerflow ( type: esriFieldTypeString, alias: sewerflow, length: 20 , Coded Values: [None: None] , [Light: Light] , [Medium: Medium] , ...2 more... )
• excavation ( type: esriFieldTypeString, alias: excavation, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• jettingconditions ( type: esriFieldTypeString, alias: jettingconditions, length: 250 )
• videoinspected ( type: esriFieldTypeString, alias: videoinspected, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• videofindings ( type: esriFieldTypeString, alias: videofindings, length: 250 )
• homedamage ( type: esriFieldTypeString, alias: homedamage, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• homedamagedesc ( type: esriFieldTypeString, alias: homedamagedesc, length: 250 )
• supernotified ( type: esriFieldTypeString, alias: supernotified, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• datenotified ( type: esriFieldTypeDate, alias: datenotified, length: 8 )
• depnotified ( type: esriFieldTypeDate, alias: depnotified, length: 8 )
• bypassreport ( type: esriFieldTypeString, alias: bypassreport, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• otheractions ( type: esriFieldTypeString, alias: otheractions, length: 250 )
• upstreamcheck ( type: esriFieldTypeString, alias: upstreamcheck, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• upstreamflow ( type: esriFieldTypeString, alias: upstreamflow, length: 20 , Coded Values: [None: None] , [Light: Light] , [Medium: Medium] , ...2 more... )
• downstreamcheck ( type: esriFieldTypeString, alias: downstreamcheck, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• downstreamflow ( type: esriFieldTypeString, alias: downstreamflow, length: 20 , Coded Values: [None: None] , [Light: Light] , [Medium: Medium] , ...2 more... )
• onsiteactions ( type: esriFieldTypeString, alias: onsiteactions, length: 250 , Coded Values: [General: General] , [Repaired/Replaced: Repaired/Replaced] , [Jetted Line: Jetted Line] , ...3 more... )
• blockageremoved ( type: esriFieldTypeDate, alias: blockageremoved, length: 8 )
• estflowrate ( type: esriFieldTypeDouble, alias: estflowrate )
• overflowduration ( type: esriFieldTypeDouble, alias: overflowduration )
• sewagefate ( type: esriFieldTypeString, alias: sewagefate, length: 250 )
• contactperson ( type: esriFieldTypeString, alias: contactperson, length: 100 )
• addressaffected ( type: esriFieldTypeString, alias: addressaffected, length: 100 )
• contactphone ( type: esriFieldTypeString, alias: contactphone, length: 30 )
• deptrepnotified ( type: esriFieldTypeString, alias: deptrepnotified, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• deepreminder ( type: esriFieldTypeDate, alias: DEEPreminder, length: 8 )
• supervisit ( type: esriFieldTypeString, alias: supervisit, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• riskmgmtnotified ( type: esriFieldTypeString, alias: riskmgmtnotified, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• sewagecleanup ( type: esriFieldTypeString, alias: sewagecleanup, length: 250 )
• damagedesc ( type: esriFieldTypeString, alias: damagedesc, length: 250 )
• comments ( type: esriFieldTypeString, alias: comments, length: 1000 )
• attachmentid1 ( type: esriFieldTypeInteger, alias: attachmentid1 )
• attachmentid2 ( type: esriFieldTypeInteger, alias: attachmentid2 )
• attachmentid3 ( type: esriFieldTypeInteger, alias: attachmentid3 )
• revisitnecessary ( type: esriFieldTypeString, alias: revisitnecessary, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• crewneeded ( type: esriFieldTypeString, alias: crewneeded, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• createdby ( type: esriFieldTypeString, alias: createdby, length: 50 )
• mainjetted ( type: esriFieldTypeString, alias: mainjetted, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• owneronsite ( type: esriFieldTypeString, alias: owneronsite, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• ssocause ( type: esriFieldTypeString, alias: ssocause, length: 50 , Coded Values: [General: General] , [Mechanical Failure: Mechanical Failure] , [Blockage: Blockage] , ...8 more... )
• ssolocation ( type: esriFieldTypeString, alias: ssolocation, length: 250 )
• bypassfound ( type: esriFieldTypeDate, alias: bypassfound, length: 8 )
• bypassvolume ( type: esriFieldTypeDouble, alias: bypassvolume )
• volumemethod ( type: esriFieldTypeString, alias: volumemethod, length: 50 )
• receivingwaters ( type: esriFieldTypeString, alias: receivingwaters, length: 50 , Coded Values: [Connecticut River: Connecticut River] , [Mattabessett River: Mattabessett River] , [Coginchaug River: Coginchaug River] , ...6 more... )
• areacleaned ( type: esriFieldTypeString, alias: areacleaned, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• overflowresult ( type: esriFieldTypeString, alias: overflowresult, length: 75 , Coded Values: [Release to Ground: Release to Ground] , [Release to Street: Release to Street] , [Release to Basement: Release to Basement] , ...5 more... )
• cleanmethod ( type: esriFieldTypeString, alias: cleanmethod, length: 50 , Coded Values: [Wash Down: Wash Down] , [Wash Down & Disinfect: Wash Down & Disinfect] , [Contractor: Contractor] )
• stepstominimize ( type: esriFieldTypeString, alias: stepstominimize, length: 100 )
• stepstoeliminate ( type: esriFieldTypeString, alias: stepstoeliminate, length: 100 )
• preventrecurrence ( type: esriFieldTypeString, alias: preventrecurrence, length: 100 )
• supervisor ( type: esriFieldTypeString, alias: supervisor, length: 50 , Coded Values: [Tom Tetrault: Tom Tetrault] , [Devin Darley: Devin Darley] , [Brian Robillard: Brian Robillard] , ...1 more... )
• deptrepname ( type: esriFieldTypeString, alias: deptrepname, length: 50 , Coded Values: [Tom Tetrault: Tom Tetrault] , [Devin Darley: Devin Darley] , [Brian Robillard: Brian Robillard] , ...1 more... )
• complaintfrom ( type: esriFieldTypeString, alias: complaintfrom, length: 100 )
• street ( type: esriFieldTypeString, alias: street, length: 50 )
• crossstreet ( type: esriFieldTypeString, alias: crossstreet, length: 50 )
• qalert_problem ( type: esriFieldTypeString, alias: qalert_problem, length: 50 , Coded Values: [Backup: Backup] , [Odor: Odor] , [Water in Street: Water in Street] , ...2 more... )
• qalert_date ( type: esriFieldTypeDate, alias: qalert_date, length: 8 )
• qalert_response ( type: esriFieldTypeString, alias: qalert_response, length: 100 )
• subsection ( type: esriFieldTypeString, alias: subsection, length: 50 )
• qalert_number ( type: esriFieldTypeString, alias: qalert_number, length: 20 )
• qalert_status ( type: esriFieldTypeString, alias: qalert_status, length: 50 )
• investigatedby ( type: esriFieldTypeString, alias: investigatedby, length: 50 )
• wocomments ( type: esriFieldTypeString, alias: wocomments, length: 1000 )
• wodescription ( type: esriFieldTypeString, alias: wodescription, length: 1000 )

Supported Operations:   Query   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata