{ "currentVersion": 10.71, "id": 105, "name": "sedaCustomerHistory", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "objectid", "globalIdField": "", "displayField": "customername", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "objectid" }, { "name": "assetkey", "type": "esriFieldTypeString", "alias": "assetkey", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "assetkey" }, { "name": "workorderid", "type": "esriFieldTypeString", "alias": "workorderid", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "workorderid" }, { "name": "workdate", "type": "esriFieldTypeDate", "alias": "workdate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "workdate" }, { "name": "worktype", "type": "esriFieldTypeString", "alias": "worktype", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "worktype" }, { "name": "workby", "type": "esriFieldTypeString", "alias": "workby", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "workby" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "metersize" }, { "name": "meternum_old", "type": "esriFieldTypeString", "alias": "meternum_old", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "meternum_old" }, { "name": "meternum_new", "type": "esriFieldTypeString", "alias": "meternum_new", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "meternum_new" }, { "name": "miu", "type": "esriFieldTypeString", "alias": "miu", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "miu" }, { "name": "mfg", "type": "esriFieldTypeString", "alias": "mfg", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "mfg" }, { "name": "model", "type": "esriFieldTypeString", "alias": "model", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "model" }, { "name": "location", "type": "esriFieldTypeString", "alias": "location", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "location" }, { "name": "meterread", "type": "esriFieldTypeDouble", "alias": "meterread", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "meterread" }, { "name": "meterread_last", "type": "esriFieldTypeDouble", "alias": "meterread_last", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "meterread_last" }, { "name": "arrival", "type": "esriFieldTypeDate", "alias": "arrival", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "arrival" }, { "name": "departure", "type": "esriFieldTypeDate", "alias": "departure", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "departure" }, { "name": "address", "type": "esriFieldTypeString", "alias": "address", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "address" }, { "name": "account", "type": "esriFieldTypeString", "alias": "account", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "account" }, { "name": "complaint", "type": "esriFieldTypeString", "alias": "complaint", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "complaint" }, { "name": "wodesc", "type": "esriFieldTypeString", "alias": "wodesc", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "wodesc" }, { "name": "wonotes", "type": "esriFieldTypeString", "alias": "wonotes", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "wonotes" }, { "name": "customername", "type": "esriFieldTypeString", "alias": "customername", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "customername" }, { "name": "contactinfo", "type": "esriFieldTypeString", "alias": "contactinfo", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "contactinfo" }, { "name": "conditionfound", "type": "esriFieldTypeString", "alias": "conditionfound", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "conditionfound" }, { "name": "waterusebkp", "type": "esriFieldTypeString", "alias": "waterusebkp", "domain": { "type": "codedValue", "name": "sedaYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "waterusebkp" }, { "name": "lateralproblem", "type": "esriFieldTypeString", "alias": "lateralproblem", "domain": { "type": "codedValue", "name": "sedaYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "lateralproblem" }, { "name": "ssmhchecked", "type": "esriFieldTypeString", "alias": "ssmhchecked", "domain": { "type": "codedValue", "name": "sedaYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "ssmhchecked" }, { "name": "surcharged", "type": "esriFieldTypeString", "alias": "surcharged", "domain": { "type": "codedValue", "name": "sedaYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "surcharged" }, { "name": "sewerflow", "type": "esriFieldTypeString", "alias": "sewerflow", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "sewerflow" }, { "name": "excavation", "type": "esriFieldTypeString", "alias": "excavation", "domain": { "type": "codedValue", "name": "sedaYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "excavation" }, { "name": "jettingconditions", "type": "esriFieldTypeString", "alias": "jettingconditions", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "jettingconditions" }, { "name": "videoinspected", "type": "esriFieldTypeString", "alias": "videoinspected", "domain": { "type": "codedValue", "name": "sedaYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "videoinspected" }, { "name": "videofindings", "type": "esriFieldTypeString", "alias": "videofindings", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "videofindings" }, { "name": "homedamage", "type": "esriFieldTypeString", "alias": "homedamage", "domain": { "type": "codedValue", "name": "sedaYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "homedamage" }, { "name": "homedamagedesc", "type": "esriFieldTypeString", "alias": "homedamagedesc", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "homedamagedesc" }, { "name": "supernotified", "type": "esriFieldTypeString", "alias": "supernotified", "domain": { "type": "codedValue", "name": "sedaYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "supernotified" }, { "name": "datenotified", "type": "esriFieldTypeDate", "alias": "datenotified", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "datenotified" }, { "name": "depnotified", "type": "esriFieldTypeDate", "alias": "depnotified", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "depnotified" }, { "name": "bypassreport", "type": "esriFieldTypeString", "alias": "bypassreport", "domain": { "type": "codedValue", "name": "sedaYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "bypassreport" }, { "name": "otheractions", "type": "esriFieldTypeString", "alias": "otheractions", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "otheractions" }, { "name": "upstreamcheck", "type": "esriFieldTypeString", "alias": "upstreamcheck", "domain": { "type": "codedValue", "name": "sedaYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "upstreamcheck" }, { "name": "upstreamflow", "type": "esriFieldTypeString", "alias": "upstreamflow", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "upstreamflow" }, { "name": "downstreamcheck", "type": "esriFieldTypeString", "alias": "downstreamcheck", "domain": { "type": "codedValue", "name": "sedaYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "downstreamcheck" }, { "name": "downstreamflow", "type": "esriFieldTypeString", "alias": "downstreamflow", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "downstreamflow" }, { "name": "onsiteactions", "type": "esriFieldTypeString", "alias": "onsiteactions", "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" }, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "onsiteactions" }, { "name": "blockageremoved", "type": "esriFieldTypeDate", "alias": "blockageremoved", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "blockageremoved" }, { "name": "estflowrate", "type": "esriFieldTypeDouble", "alias": "estflowrate", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "estflowrate" }, { "name": "overflowduration", "type": "esriFieldTypeDouble", "alias": "overflowduration", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "overflowduration" }, { "name": "sewagefate", "type": "esriFieldTypeString", "alias": "sewagefate", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "sewagefate" }, { "name": "contactperson", "type": "esriFieldTypeString", "alias": "contactperson", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "contactperson" }, { "name": "addressaffected", "type": "esriFieldTypeString", "alias": "addressaffected", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "addressaffected" }, { "name": "contactphone", "type": "esriFieldTypeString", "alias": "contactphone", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "contactphone" }, { "name": "deptrepnotified", "type": "esriFieldTypeString", "alias": "deptrepnotified", "domain": { "type": "codedValue", "name": "sedaYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "deptrepnotified" }, { "name": "deepreminder", "type": "esriFieldTypeDate", "alias": "DEEPreminder", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DEEPreminder" }, { "name": "supervisit", "type": "esriFieldTypeString", "alias": "supervisit", "domain": { "type": "codedValue", "name": "sedaYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "supervisit" }, { "name": "riskmgmtnotified", "type": "esriFieldTypeString", "alias": "riskmgmtnotified", "domain": { "type": "codedValue", "name": "sedaYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "riskmgmtnotified" }, { "name": "sewagecleanup", "type": "esriFieldTypeString", "alias": "sewagecleanup", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "sewagecleanup" }, { "name": "damagedesc", "type": "esriFieldTypeString", "alias": "damagedesc", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "damagedesc" }, { "name": "comments", "type": "esriFieldTypeString", "alias": "comments", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "comments" }, { "name": "attachmentid1", "type": "esriFieldTypeInteger", "alias": "attachmentid1", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "attachmentid1" }, { "name": "attachmentid2", "type": "esriFieldTypeInteger", "alias": "attachmentid2", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "attachmentid2" }, { "name": "attachmentid3", "type": "esriFieldTypeInteger", "alias": "attachmentid3", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "attachmentid3" }, { "name": "revisitnecessary", "type": "esriFieldTypeString", "alias": "revisitnecessary", "domain": { "type": "codedValue", "name": "sedaYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "revisitnecessary" }, { "name": "crewneeded", "type": "esriFieldTypeString", "alias": "crewneeded", "domain": { "type": "codedValue", "name": "sedaYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "crewneeded" }, { "name": "createdby", "type": "esriFieldTypeString", "alias": "createdby", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "createdby" }, { "name": "mainjetted", "type": "esriFieldTypeString", "alias": "mainjetted", "domain": { "type": "codedValue", "name": "sedaYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "mainjetted" }, { "name": "owneronsite", "type": "esriFieldTypeString", "alias": "owneronsite", "domain": { "type": "codedValue", "name": "sedaYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "owneronsite" }, { "name": "ssocause", "type": "esriFieldTypeString", "alias": "ssocause", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ssocause" }, { "name": "ssolocation", "type": "esriFieldTypeString", "alias": "ssolocation", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "ssolocation" }, { "name": "bypassfound", "type": "esriFieldTypeDate", "alias": "bypassfound", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "bypassfound" }, { "name": "bypassvolume", "type": "esriFieldTypeDouble", "alias": "bypassvolume", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "bypassvolume" }, { "name": "volumemethod", "type": "esriFieldTypeString", "alias": "volumemethod", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "volumemethod" }, { "name": "receivingwaters", "type": "esriFieldTypeString", "alias": "receivingwaters", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "receivingwaters" }, { "name": "areacleaned", "type": "esriFieldTypeString", "alias": "areacleaned", "domain": { "type": "codedValue", "name": "sedaYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "areacleaned" }, { "name": "overflowresult", "type": "esriFieldTypeString", "alias": "overflowresult", "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" }, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "overflowresult" }, { "name": "cleanmethod", "type": "esriFieldTypeString", "alias": "cleanmethod", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "cleanmethod" }, { "name": "stepstominimize", "type": "esriFieldTypeString", "alias": "stepstominimize", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "stepstominimize" }, { "name": "stepstoeliminate", "type": "esriFieldTypeString", "alias": "stepstoeliminate", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "stepstoeliminate" }, { "name": "preventrecurrence", "type": "esriFieldTypeString", "alias": "preventrecurrence", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "preventrecurrence" }, { "name": "supervisor", "type": "esriFieldTypeString", "alias": "supervisor", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "supervisor" }, { "name": "deptrepname", "type": "esriFieldTypeString", "alias": "deptrepname", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "deptrepname" }, { "name": "complaintfrom", "type": "esriFieldTypeString", "alias": "complaintfrom", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "complaintfrom" }, { "name": "street", "type": "esriFieldTypeString", "alias": "street", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "street" }, { "name": "crossstreet", "type": "esriFieldTypeString", "alias": "crossstreet", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "crossstreet" }, { "name": "qalert_problem", "type": "esriFieldTypeString", "alias": "qalert_problem", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "qalert_problem" }, { "name": "qalert_date", "type": "esriFieldTypeDate", "alias": "qalert_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "qalert_date" }, { "name": "qalert_response", "type": "esriFieldTypeString", "alias": "qalert_response", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "qalert_response" }, { "name": "subsection", "type": "esriFieldTypeString", "alias": "subsection", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "subsection" }, { "name": "qalert_number", "type": "esriFieldTypeString", "alias": "qalert_number", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "qalert_number" }, { "name": "qalert_status", "type": "esriFieldTypeString", "alias": "qalert_status", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "qalert_status" }, { "name": "investigatedby", "type": "esriFieldTypeString", "alias": "investigatedby", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "investigatedby" }, { "name": "wocomments", "type": "esriFieldTypeString", "alias": "wocomments", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "wocomments" }, { "name": "wodescription", "type": "esriFieldTypeString", "alias": "wodescription", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "wodescription" } ], "indexes": [ { "name": "R118_SDE_ROWID_UK", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "sedaCustomerHistory", "description": "", "prototype": { "attributes": { "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 } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 3000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 3000, "tileMaxRecordCount": 3000, "maxRecordCountFactor": 1 }