{ "currentVersion": 10.91, "id": 4, "name": "Request for Service", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 0, "name": "Parcels", "relatedTableId": 3, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "RELGlobalID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": false, "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": true, "supportsAttachmentsByUploadId": true, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "RequestorsName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "RequestorsName", "type": "esriFieldTypeString", "alias": "Requestor's Name", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "RequestorsName" }, { "name": "Location_Address", "type": "esriFieldTypeString", "alias": "Location/Address", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Location_Address" }, { "name": "HomePhone", "type": "esriFieldTypeString", "alias": "Home Phone", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "HomePhone" }, { "name": "WorkPhone", "type": "esriFieldTypeString", "alias": "Work Phone", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "WorkPhone" }, { "name": "CellPhone", "type": "esriFieldTypeString", "alias": "Cell Phone", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CellPhone" }, { "name": "Date", "type": "esriFieldTypeDate", "alias": "Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Date" }, { "name": "Time", "type": "esriFieldTypeString", "alias": "Time", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Time" }, { "name": "CallReceiver", "type": "esriFieldTypeString", "alias": "Call Received By", "domain": { "type": "codedValue", "name": "Service_CallReceiver", "description": "Call Receiver", "codedValues": [ { "name": "Lisa Guillerault", "code": "Lisa Guillerault" }, { "name": "Mike Dudek", "code": "Mike Dudek" }, { "name": "Kevin Shlatz", "code": "Kevin Shlatz" }, { "name": "Dan Parisi", "code": "Dan Parisi" }, { "name": "Harold Eastwood", "code": "Harold Eastwood" }, { "name": "James Waibel", "code": "James Waibel" }, { "name": "Eric Lopez", "code": "Eric Lopez" }, { "name": "Nick Gamache", "code": "Nick Gamache" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "CallReceiver" }, { "name": "OperatorAssigned", "type": "esriFieldTypeString", "alias": "Operator Assigned", "domain": { "type": "codedValue", "name": "Service_Operator", "description": "Operator", "codedValues": [ { "name": "Adam Bajoris", "code": "Adam Bajoris" }, { "name": "Mike Dudek", "code": "Mike Dudek" }, { "name": "Jean Dumais", "code": "Jean Dumais" }, { "name": "Harold Eastwood", "code": "Harold Eastwood" }, { "name": "Nick Gamache", "code": "Nick Gamache" }, { "name": "Dave Langevin", "code": "Dave Langevin" }, { "name": "Eric Lopez", "code": "Eric Lopez" }, { "name": "Dan Parisi", "code": "Dan Parisi" }, { "name": "James Waibel", "code": "James Waibel" }, { "name": "Kevin Kelly", "code": "Kevin Kelly" }, { "name": "Ken DePoutot", "code": "Ken DePoutot" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "OperatorAssigned" }, { "name": "IssueType", "type": "esriFieldTypeString", "alias": "Type of Issue", "domain": { "type": "codedValue", "name": "Service_IssueType", "description": "Issue Type", "codedValues": [ { "name": "Odor", "code": "Odor" }, { "name": "Manhole cover", "code": "Manhole cover" }, { "name": "Sewer backup main line", "code": "Sewer backup main line" }, { "name": "Sewer backup private lateral", "code": "Sewer backup private lateral" }, { "name": "Am I connected to sewer?", "code": "Am I connected to sewer?" }, { "name": "Slow moving building drain", "code": "Slow moving building drain" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "IssueType" }, { "name": "Request", "type": "esriFieldTypeString", "alias": "Request", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "Request" }, { "name": "ArrivedOnSite", "type": "esriFieldTypeString", "alias": "Arrived on Site", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ArrivedOnSite" }, { "name": "FinishTime", "type": "esriFieldTypeString", "alias": "Finish Time", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "FinishTime" }, { "name": "CrewLeaderOnSite", "type": "esriFieldTypeString", "alias": "Crew Leader on Site", "domain": { "type": "codedValue", "name": "Service_CrewLeader", "description": "Crew Leader", "codedValues": [ { "name": "Adam Bajoris", "code": "Adam Bajoris" }, { "name": "Mike Dudek", "code": "Mike Dudek" }, { "name": "Jean Dumais", "code": "Jean Dumais" }, { "name": "Harold Eastwood", "code": "Harold Eastwood" }, { "name": "Nick Gamache", "code": "Nick Gamache" }, { "name": "Dave Langevin", "code": "Dave Langevin" }, { "name": "Eric Lopez", "code": "Eric Lopez" }, { "name": "Tony Manfre", "code": "Tony Manfre" }, { "name": "Dan Parisi", "code": "Dan Parisi" }, { "name": "Frank Tobey III", "code": "Frank Tobey III" }, { "name": "James Waibel", "code": "James Waibel" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "CrewLeaderOnSite" }, { "name": "BackupCause", "type": "esriFieldTypeString", "alias": "If Backup, what was the cause?", "domain": { "type": "codedValue", "name": "Service_Backup", "description": "Backup", "codedValues": [ { "name": "Grease", "code": "Grease" }, { "name": "Roots", "code": "Roots" }, { "name": "Rags/wipes", "code": "Rags/wipes" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "BackupCause" }, { "name": "BlockageLocation", "type": "esriFieldTypeString", "alias": "Was Blockage in the main or Private Lateral", "domain": { "type": "codedValue", "name": "Service_Blockage", "description": "Blockage", "codedValues": [ { "name": "Main line", "code": "Main line" }, { "name": "Private lateral", "code": "Private lateral" }, { "name": "Not sure", "code": "Not sure" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "BlockageLocation" }, { "name": "NumberAffected", "type": "esriFieldTypeInteger", "alias": "NumberAffected", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "NumberAffected" }, { "name": "BlockageHouseNumber1", "type": "esriFieldTypeString", "alias": "Blockage from House Number", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "BlockageHouseNumber1" }, { "name": "BlockageHouseNumber2", "type": "esriFieldTypeString", "alias": "Blockage to House Number", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "BlockageHouseNumber2" }, { "name": "TotalFeetCleaned", "type": "esriFieldTypeDouble", "alias": "Total Feet Cleaned", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TotalFeetCleaned" }, { "name": "EquipmentUsed", "type": "esriFieldTypeString", "alias": "Equipment Used", "domain": { "type": "codedValue", "name": "Service_EquipmentUsed", "description": "Equipment Used", "codedValues": [ { "name": "Jetter", "code": "Jetter" }, { "name": "Root Saw", "code": "Root Saw" }, { "name": "Grease Head", "code": "Grease Head" }, { "name": "Sand Nozzle", "code": "Sand Nozzle" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "EquipmentUsed" }, { "name": "AgeLinesInvolved", "type": "esriFieldTypeString", "alias": "Age of Lines Involved in Incident", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "AgeLinesInvolved" }, { "name": "SizeLinesInvolved", "type": "esriFieldTypeString", "alias": "SizeLinesInvolved", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SizeLinesInvolved" }, { "name": "DescriptionWorkPerformed", "type": "esriFieldTypeString", "alias": "Description of Work Performed", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "DescriptionWorkPerformed" }, { "name": "DamageObservedAtProperty", "type": "esriFieldTypeString", "alias": "Damage Observed at Property", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "DamageObservedAtProperty" }, { "name": "ProblemArea", "type": "esriFieldTypeString", "alias": "Is Area Deemed to be a Problem Area", "domain": { "type": "codedValue", "name": "YesNo_1", "description": "Yes No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ProblemArea" }, { "name": "CombinedSystem", "type": "esriFieldTypeString", "alias": "Is this a combined system", "domain": { "type": "codedValue", "name": "YesNo_1", "description": "Yes No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CombinedSystem" }, { "name": "WeatherConditions", "type": "esriFieldTypeString", "alias": "Weather Conditions", "domain": { "type": "codedValue", "name": "ServiceWeatherConditions", "description": "Weather Conditions", "codedValues": [ { "name": "Dry", "code": "Dry" }, { "name": "Drizzle", "code": "Drizzle" }, { "name": "Rain", "code": "Rain" }, { "name": "Heavy Rain", "code": "Heavy Rain" }, { "name": "Hurricane", "code": "Hurricane" }, { "name": "Snow", "code": "Snow" }, { "name": "Snow Melt", "code": "Snow Melt" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "WeatherConditions" }, { "name": "Resolution", "type": "esriFieldTypeString", "alias": "Resolution", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "Resolution" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "RELGlobalID", "type": "esriFieldTypeGUID", "alias": "RELGlobalID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "RELGlobalID" } ], "indexes": [ { "name": "R341_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_341", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_1601_RELGlob", "fields": "RELGlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_341", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "Request for Service", "description": "", "prototype": { "attributes": { "RELGlobalID": null, "Resolution": null, "RequestorsName": null, "Location_Address": null, "HomePhone": null, "WorkPhone": null, "CellPhone": null, "Date": null, "Time": null, "CallReceiver": null, "OperatorAssigned": null, "IssueType": null, "Request": null, "ArrivedOnSite": null, "FinishTime": null, "CrewLeaderOnSite": null, "BackupCause": null, "BlockageLocation": null, "NumberAffected": null, "BlockageHouseNumber1": null, "BlockageHouseNumber2": null, "TotalFeetCleaned": null, "EquipmentUsed": null, "AgeLinesInvolved": null, "SizeLinesInvolved": null, "DescriptionWorkPerformed": null, "DamageObservedAtProperty": null, "ProblemArea": null, "CombinedSystem": null, "WeatherConditions": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 5000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 5000, "maxRecordCountFactor": 1, "serviceItemId": "5086307d7a7145bea736659cf4785948" }