{ "currentVersion": 10.71, "id": 105, "name": "sedaCustomerHistory", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "customername", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "assetkey", "type": "esriFieldTypeString", "alias": "assetkey", "length": 20, "domain": null }, { "name": "workorderid", "type": "esriFieldTypeString", "alias": "workorderid", "length": 50, "domain": null }, { "name": "workdate", "type": "esriFieldTypeDate", "alias": "workdate", "length": 8, "domain": null }, { "name": "worktype", "type": "esriFieldTypeString", "alias": "worktype", "length": 50, "domain": null }, { "name": "workby", "type": "esriFieldTypeString", "alias": "workby", "length": 50, "domain": null }, { "name": "metersize", "type": "esriFieldTypeDouble", "alias": "metersize", "domain": { "type": "codedValue", "name": "sedaMeterSize", "description": "", "codedValues": [ { "name": "5/8\"", "code": 0.625 }, { "name": "3/4\"", "code": 0.75 }, { "name": "1''", "code": 1 }, { "name": "1.5''", "code": 1.5 }, { "name": "2''", "code": 2 }, { "name": "2.5''", "code": 2.5 }, { "name": "3''", "code": 3 }, { "name": "4''", "code": 4 }, { "name": "5''", "code": 5 }, { "name": "6''", "code": 6 }, { "name": "8''", "code": 8 }, { "name": "10''", "code": 10 }, { "name": "12''", "code": 12 }, { "name": "14''", "code": 14 }, { "name": "16''", "code": 16 }, { "name": "18''", "code": 18 }, { "name": "20''", "code": 20 }, { "name": "21''", "code": 21 }, { "name": "24''", "code": 24 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "meternum_old", "type": "esriFieldTypeString", "alias": "meternum_old", "length": 25, "domain": null }, { "name": "meternum_new", "type": "esriFieldTypeString", "alias": "meternum_new", "length": 25, "domain": null }, { "name": "miu", "type": "esriFieldTypeString", "alias": "miu", "length": 25, "domain": null }, { "name": "mfg", "type": "esriFieldTypeString", "alias": "mfg", "length": 50, "domain": null }, { "name": "model", "type": "esriFieldTypeString", "alias": "model", "length": 50, "domain": null }, { "name": "location", "type": "esriFieldTypeString", "alias": "location", "length": 250, "domain": null }, { "name": "meterread", "type": "esriFieldTypeDouble", "alias": "meterread", "domain": null }, { "name": "meterread_last", "type": "esriFieldTypeDouble", "alias": "meterread_last", "domain": null }, { "name": "arrival", "type": "esriFieldTypeDate", "alias": "arrival", "length": 8, "domain": null }, { "name": "departure", "type": "esriFieldTypeDate", "alias": "departure", "length": 8, "domain": null }, { "name": "address", "type": "esriFieldTypeString", "alias": "address", "length": 100, "domain": null }, { "name": "account", "type": "esriFieldTypeString", "alias": "account", "length": 20, "domain": null }, { "name": "complaint", "type": "esriFieldTypeString", "alias": "complaint", "length": 250, "domain": null }, { "name": "wodesc", "type": "esriFieldTypeString", "alias": "wodesc", "length": 250, "domain": null }, { "name": "wonotes", "type": "esriFieldTypeString", "alias": "wonotes", "length": 250, "domain": null }, { "name": "customername", "type": "esriFieldTypeString", "alias": "customername", "length": 50, "domain": null }, { "name": "contactinfo", "type": "esriFieldTypeString", "alias": "contactinfo", "length": 50, "domain": null }, { "name": "conditionfound", "type": "esriFieldTypeString", "alias": "conditionfound", "length": 100, "domain": null }, { "name": "waterusebkp", "type": "esriFieldTypeString", "alias": "waterusebkp", "length": 10, "domain": { "type": "codedValue", "name": "sedaYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "lateralproblem", "type": "esriFieldTypeString", "alias": "lateralproblem", "length": 10, "domain": { "type": "codedValue", "name": "sedaYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ssmhchecked", "type": "esriFieldTypeString", "alias": "ssmhchecked", "length": 10, "domain": { "type": "codedValue", "name": "sedaYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "surcharged", "type": "esriFieldTypeString", "alias": "surcharged", "length": 10, "domain": { "type": "codedValue", "name": "sedaYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "sewerflow", "type": "esriFieldTypeString", "alias": "sewerflow", "length": 20, "domain": { "type": "codedValue", "name": "sedaSewerFlow", "description": "", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Light", "code": "Light" }, { "name": "Medium", "code": "Medium" }, { "name": "Heavy", "code": "Heavy" }, { "name": "Surcharging", "code": "Surcharging" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "excavation", "type": "esriFieldTypeString", "alias": "excavation", "length": 10, "domain": { "type": "codedValue", "name": "sedaYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "jettingconditions", "type": "esriFieldTypeString", "alias": "jettingconditions", "length": 250, "domain": null }, { "name": "videoinspected", "type": "esriFieldTypeString", "alias": "videoinspected", "length": 10, "domain": { "type": "codedValue", "name": "sedaYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "videofindings", "type": "esriFieldTypeString", "alias": "videofindings", "length": 250, "domain": null }, { "name": "homedamage", "type": "esriFieldTypeString", "alias": "homedamage", "length": 10, "domain": { "type": "codedValue", "name": "sedaYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "homedamagedesc", "type": "esriFieldTypeString", "alias": "homedamagedesc", "length": 250, "domain": null }, { "name": "supernotified", "type": "esriFieldTypeString", "alias": "supernotified", "length": 10, "domain": { "type": "codedValue", "name": "sedaYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "datenotified", "type": "esriFieldTypeDate", "alias": "datenotified", "length": 8, "domain": null }, { "name": "depnotified", "type": "esriFieldTypeDate", "alias": "depnotified", "length": 8, "domain": null }, { "name": "bypassreport", "type": "esriFieldTypeString", "alias": "bypassreport", "length": 10, "domain": { "type": "codedValue", "name": "sedaYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "otheractions", "type": "esriFieldTypeString", "alias": "otheractions", "length": 250, "domain": null }, { "name": "upstreamcheck", "type": "esriFieldTypeString", "alias": "upstreamcheck", "length": 10, "domain": { "type": "codedValue", "name": "sedaYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "upstreamflow", "type": "esriFieldTypeString", "alias": "upstreamflow", "length": 20, "domain": { "type": "codedValue", "name": "sedaSewerFlow", "description": "", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Light", "code": "Light" }, { "name": "Medium", "code": "Medium" }, { "name": "Heavy", "code": "Heavy" }, { "name": "Surcharging", "code": "Surcharging" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "downstreamcheck", "type": "esriFieldTypeString", "alias": "downstreamcheck", "length": 10, "domain": { "type": "codedValue", "name": "sedaYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "downstreamflow", "type": "esriFieldTypeString", "alias": "downstreamflow", "length": 20, "domain": { "type": "codedValue", "name": "sedaSewerFlow", "description": "", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Light", "code": "Light" }, { "name": "Medium", "code": "Medium" }, { "name": "Heavy", "code": "Heavy" }, { "name": "Surcharging", "code": "Surcharging" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "onsiteactions", "type": "esriFieldTypeString", "alias": "onsiteactions", "length": 250, "domain": { "type": "codedValue", "name": "SewerSSOOnsiteActions", "description": "", "codedValues": [ { "name": "General", "code": "General" }, { "name": "Repaired/Replaced", "code": "Repaired/Replaced" }, { "name": "Jetted Line", "code": "Jetted Line" }, { "name": "Bypass Pumping", "code": "Bypass Pumping" }, { "name": "Septic Truck", "code": "Septic Truck" }, { "name": "Not Applicable", "code": "Not Applicable" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "blockageremoved", "type": "esriFieldTypeDate", "alias": "blockageremoved", "length": 8, "domain": null }, { "name": "estflowrate", "type": "esriFieldTypeDouble", "alias": "estflowrate", "domain": null }, { "name": "overflowduration", "type": "esriFieldTypeDouble", "alias": "overflowduration", "domain": null }, { "name": "sewagefate", "type": "esriFieldTypeString", "alias": "sewagefate", "length": 250, "domain": null }, { "name": "contactperson", "type": "esriFieldTypeString", "alias": "contactperson", "length": 100, "domain": null }, { "name": "addressaffected", "type": "esriFieldTypeString", "alias": "addressaffected", "length": 100, "domain": null }, { "name": "contactphone", "type": "esriFieldTypeString", "alias": "contactphone", "length": 30, "domain": null }, { "name": "deptrepnotified", "type": "esriFieldTypeString", "alias": "deptrepnotified", "length": 10, "domain": { "type": "codedValue", "name": "sedaYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "deepreminder", "type": "esriFieldTypeDate", "alias": "DEEPreminder", "length": 8, "domain": null }, { "name": "supervisit", "type": "esriFieldTypeString", "alias": "supervisit", "length": 10, "domain": { "type": "codedValue", "name": "sedaYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "riskmgmtnotified", "type": "esriFieldTypeString", "alias": "riskmgmtnotified", "length": 10, "domain": { "type": "codedValue", "name": "sedaYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "sewagecleanup", "type": "esriFieldTypeString", "alias": "sewagecleanup", "length": 250, "domain": null }, { "name": "damagedesc", "type": "esriFieldTypeString", "alias": "damagedesc", "length": 250, "domain": null }, { "name": "comments", "type": "esriFieldTypeString", "alias": "comments", "length": 1000, "domain": null }, { "name": "attachmentid1", "type": "esriFieldTypeInteger", "alias": "attachmentid1", "domain": null }, { "name": "attachmentid2", "type": "esriFieldTypeInteger", "alias": "attachmentid2", "domain": null }, { "name": "attachmentid3", "type": "esriFieldTypeInteger", "alias": "attachmentid3", "domain": null }, { "name": "revisitnecessary", "type": "esriFieldTypeString", "alias": "revisitnecessary", "length": 10, "domain": { "type": "codedValue", "name": "sedaYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "crewneeded", "type": "esriFieldTypeString", "alias": "crewneeded", "length": 10, "domain": { "type": "codedValue", "name": "sedaYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "createdby", "type": "esriFieldTypeString", "alias": "createdby", "length": 50, "domain": null }, { "name": "mainjetted", "type": "esriFieldTypeString", "alias": "mainjetted", "length": 10, "domain": { "type": "codedValue", "name": "sedaYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "owneronsite", "type": "esriFieldTypeString", "alias": "owneronsite", "length": 10, "domain": { "type": "codedValue", "name": "sedaYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ssocause", "type": "esriFieldTypeString", "alias": "ssocause", "length": 50, "domain": { "type": "codedValue", "name": "SewerSSOCause", "description": "", "codedValues": [ { "name": "General", "code": "General" }, { "name": "Mechanical Failure", "code": "Mechanical Failure" }, { "name": "Blockage", "code": "Blockage" }, { "name": "Collapsed Pipe", "code": "Collapsed Pipe" }, { "name": "Electrical Failure", "code": "Electrical Failure" }, { "name": "Hydraulic Overload", "code": "Hydraulic Overload" }, { "name": "Vandalism", "code": "Vandalism" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Broken Pipe", "code": "Broken Pipe" }, { "name": "Blockage-Grease", "code": "Blockage-Grease" }, { "name": "Blockage-Roots", "code": "Blockage-Roots" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ssolocation", "type": "esriFieldTypeString", "alias": "ssolocation", "length": 250, "domain": null }, { "name": "bypassfound", "type": "esriFieldTypeDate", "alias": "bypassfound", "length": 8, "domain": null }, { "name": "bypassvolume", "type": "esriFieldTypeDouble", "alias": "bypassvolume", "domain": null }, { "name": "volumemethod", "type": "esriFieldTypeString", "alias": "volumemethod", "length": 50, "domain": null }, { "name": "receivingwaters", "type": "esriFieldTypeString", "alias": "receivingwaters", "length": 50, "domain": { "type": "codedValue", "name": "ReceivingWaterBody", "description": "", "codedValues": [ { "name": "Connecticut River", "code": "Connecticut River" }, { "name": "Mattabessett River", "code": "Mattabessett River" }, { "name": "Coginchaug River", "code": "Coginchaug River" }, { "name": "Crystal Lake", "code": "Crystal Lake" }, { "name": "Miner Brook", "code": "Miner Brook" }, { "name": "Unnamed Intermittent Watercourse", "code": "Unnamed" }, { "name": "Not Applicable", "code": "Not Applicable" }, { "name": "Sumner Brook", "code": "Sumner Brook" }, { "name": "Basement", "code": "Basement" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "areacleaned", "type": "esriFieldTypeString", "alias": "areacleaned", "length": 10, "domain": { "type": "codedValue", "name": "sedaYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "overflowresult", "type": "esriFieldTypeString", "alias": "overflowresult", "length": 75, "domain": { "type": "codedValue", "name": "SewerSSOResult", "description": "", "codedValues": [ { "name": "Release to Ground", "code": "Release to Ground" }, { "name": "Release to Street", "code": "Release to Street" }, { "name": "Release to Basement", "code": "Release to Basement" }, { "name": "Release to Wooded Area", "code": "Release to Wooded Area" }, { "name": "Drainage Swale", "code": "Drainage Swale" }, { "name": "Released to Ground Adj to Wetlands", "code": "Released to Ground Adj to Wetlands" }, { "name": "Strorm Drain", "code": "Strorm Drain" }, { "name": "Not Applicable", "code": "Not Applicable" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "cleanmethod", "type": "esriFieldTypeString", "alias": "cleanmethod", "length": 50, "domain": { "type": "codedValue", "name": "SewerSSOCleanMethod", "description": "", "codedValues": [ { "name": "Wash Down", "code": "Wash Down" }, { "name": "Wash Down & Disinfect", "code": "Wash Down & Disinfect" }, { "name": "Contractor", "code": "Contractor" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "stepstominimize", "type": "esriFieldTypeString", "alias": "stepstominimize", "length": 100, "domain": null }, { "name": "stepstoeliminate", "type": "esriFieldTypeString", "alias": "stepstoeliminate", "length": 100, "domain": null }, { "name": "preventrecurrence", "type": "esriFieldTypeString", "alias": "preventrecurrence", "length": 100, "domain": null }, { "name": "supervisor", "type": "esriFieldTypeString", "alias": "supervisor", "length": 50, "domain": { "type": "codedValue", "name": "Supervisor", "description": "", "codedValues": [ { "name": "Tom Tetrault", "code": "Tom Tetrault" }, { "name": "Devin Darley", "code": "Devin Darley" }, { "name": "Brian Robillard", "code": "Brian Robillard" }, { "name": "Joe Fazzino", "code": "Joe Fazzino" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "deptrepname", "type": "esriFieldTypeString", "alias": "deptrepname", "length": 50, "domain": { "type": "codedValue", "name": "Supervisor", "description": "", "codedValues": [ { "name": "Tom Tetrault", "code": "Tom Tetrault" }, { "name": "Devin Darley", "code": "Devin Darley" }, { "name": "Brian Robillard", "code": "Brian Robillard" }, { "name": "Joe Fazzino", "code": "Joe Fazzino" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "complaintfrom", "type": "esriFieldTypeString", "alias": "complaintfrom", "length": 100, "domain": null }, { "name": "street", "type": "esriFieldTypeString", "alias": "street", "length": 50, "domain": null }, { "name": "crossstreet", "type": "esriFieldTypeString", "alias": "crossstreet", "length": 50, "domain": null }, { "name": "qalert_problem", "type": "esriFieldTypeString", "alias": "qalert_problem", "length": 50, "domain": { "type": "codedValue", "name": "sedaQAlert_Problem", "description": "", "codedValues": [ { "name": "Backup", "code": "Backup" }, { "name": "Odor", "code": "Odor" }, { "name": "Water in Street", "code": "Water in Street" }, { "name": "Curb Box Blockage", "code": "Curb Box Blockage" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "qalert_date", "type": "esriFieldTypeDate", "alias": "qalert_date", "length": 8, "domain": null }, { "name": "qalert_response", "type": "esriFieldTypeString", "alias": "qalert_response", "length": 100, "domain": null }, { "name": "subsection", "type": "esriFieldTypeString", "alias": "subsection", "length": 50, "domain": null }, { "name": "qalert_number", "type": "esriFieldTypeString", "alias": "qalert_number", "length": 20, "domain": null }, { "name": "qalert_status", "type": "esriFieldTypeString", "alias": "qalert_status", "length": 50, "domain": null }, { "name": "investigatedby", "type": "esriFieldTypeString", "alias": "investigatedby", "length": 50, "domain": null }, { "name": "wocomments", "type": "esriFieldTypeString", "alias": "wocomments", "length": 1000, "domain": null }, { "name": "wodescription", "type": "esriFieldTypeString", "alias": "wodescription", "length": 1000, "domain": null } ], "indexes": [ { "name": "R118_SDE_ROWID_UK", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 3000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }