Name: sedaCustomerHistory

Display Field: customername

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 3000

Supported Query Formats: JSON, geoJSON

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

Templates:

• Name: sedaCustomerHistory
  Description:
  Prototype:
  wocomments: null
  wodescription: null
  assetkey: null
  workorderid: null
  workdate: null
  worktype: null
  workby: null
  metersize: null
  meternum_old: null
  meternum_new: null
  miu: null
  mfg: null
  model: null
  location: null
  meterread: null
  meterread_last: null
  arrival: null
  departure: null
  address: null
  account: null
  complaint: null
  wodesc: null
  wonotes: null
  customername: null
  contactinfo: null
  conditionfound: null
  waterusebkp: null
  lateralproblem: null
  ssmhchecked: null
  surcharged: null
  sewerflow: null
  excavation: null
  jettingconditions: null
  videoinspected: null
  videofindings: null
  homedamage: null
  homedamagedesc: null
  supernotified: null
  datenotified: null
  depnotified: null
  bypassreport: null
  otheractions: null
  upstreamcheck: null
  upstreamflow: null
  downstreamcheck: null
  downstreamflow: null
  onsiteactions: null
  blockageremoved: null
  estflowrate: null
  overflowduration: null
  sewagefate: null
  contactperson: null
  addressaffected: null
  contactphone: null
  deptrepnotified: null
  deepreminder: null
  supervisit: null
  riskmgmtnotified: null
  sewagecleanup: null
  damagedesc: null
  comments: null
  attachmentid1: null
  attachmentid2: null
  attachmentid3: null
  revisitnecessary: null
  crewneeded: null
  createdby: null
  mainjetted: null
  owneronsite: null
  ssocause: null
  ssolocation: null
  bypassfound: null
  bypassvolume: null
  volumemethod: null
  receivingwaters: null
  areacleaned: null
  overflowresult: null
  cleanmethod: null
  stepstominimize: null
  stepstoeliminate: null
  preventrecurrence: null
  supervisor: null
  deptrepname: null
  complaintfrom: null
  street: null
  crossstreet: null
  qalert_problem: null
  qalert_date: null
  qalert_response: null
  subsection: null
  qalert_number: null
  qalert_status: null
  investigatedby: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Attachments   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata