{ "currentVersion": 10.91, "id": 4, "name": "Request for Service", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "RequestorsName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "RequestorsName", "type": "esriFieldTypeString", "alias": "Requestor's Name", "length": 200, "domain": null }, { "name": "Location_Address", "type": "esriFieldTypeString", "alias": "Location/Address", "length": 50, "domain": null }, { "name": "HomePhone", "type": "esriFieldTypeString", "alias": "Home Phone", "length": 50, "domain": null }, { "name": "WorkPhone", "type": "esriFieldTypeString", "alias": "Work Phone", "length": 50, "domain": null }, { "name": "CellPhone", "type": "esriFieldTypeString", "alias": "Cell Phone", "length": 50, "domain": null }, { "name": "Date", "type": "esriFieldTypeDate", "alias": "Date", "length": 8, "domain": null }, { "name": "Time", "type": "esriFieldTypeString", "alias": "Time", "length": 50, "domain": null }, { "name": "CallReceiver", "type": "esriFieldTypeString", "alias": "Call Received By", "length": 200, "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" } }, { "name": "OperatorAssigned", "type": "esriFieldTypeString", "alias": "Operator Assigned", "length": 200, "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" } }, { "name": "IssueType", "type": "esriFieldTypeString", "alias": "Type of Issue", "length": 200, "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" } }, { "name": "Request", "type": "esriFieldTypeString", "alias": "Request", "length": 1000, "domain": null }, { "name": "ArrivedOnSite", "type": "esriFieldTypeString", "alias": "Arrived on Site", "length": 50, "domain": null }, { "name": "FinishTime", "type": "esriFieldTypeString", "alias": "Finish Time", "length": 50, "domain": null }, { "name": "CrewLeaderOnSite", "type": "esriFieldTypeString", "alias": "Crew Leader on Site", "length": 200, "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" } }, { "name": "BackupCause", "type": "esriFieldTypeString", "alias": "If Backup, what was the cause?", "length": 200, "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" } }, { "name": "BlockageLocation", "type": "esriFieldTypeString", "alias": "Was Blockage in the main or Private Lateral", "length": 50, "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" } }, { "name": "NumberAffected", "type": "esriFieldTypeInteger", "alias": "NumberAffected", "domain": null }, { "name": "BlockageHouseNumber1", "type": "esriFieldTypeString", "alias": "Blockage from House Number", "length": 50, "domain": null }, { "name": "BlockageHouseNumber2", "type": "esriFieldTypeString", "alias": "Blockage to House Number", "length": 50, "domain": null }, { "name": "TotalFeetCleaned", "type": "esriFieldTypeDouble", "alias": "Total Feet Cleaned", "domain": null }, { "name": "EquipmentUsed", "type": "esriFieldTypeString", "alias": "Equipment Used", "length": 50, "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" } }, { "name": "AgeLinesInvolved", "type": "esriFieldTypeString", "alias": "Age of Lines Involved in Incident", "length": 50, "domain": null }, { "name": "SizeLinesInvolved", "type": "esriFieldTypeString", "alias": "SizeLinesInvolved", "length": 50, "domain": null }, { "name": "DescriptionWorkPerformed", "type": "esriFieldTypeString", "alias": "Description of Work Performed", "length": 1000, "domain": null }, { "name": "DamageObservedAtProperty", "type": "esriFieldTypeString", "alias": "Damage Observed at Property", "length": 1000, "domain": null }, { "name": "ProblemArea", "type": "esriFieldTypeString", "alias": "Is Area Deemed to be a Problem Area", "length": 50, "domain": { "type": "codedValue", "name": "YesNo_1", "description": "Yes No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CombinedSystem", "type": "esriFieldTypeString", "alias": "Is this a combined system", "length": 50, "domain": { "type": "codedValue", "name": "YesNo_1", "description": "Yes No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "WeatherConditions", "type": "esriFieldTypeString", "alias": "Weather Conditions", "length": 50, "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" } }, { "name": "Resolution", "type": "esriFieldTypeString", "alias": "Resolution", "length": 1000, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "RELGlobalID", "type": "esriFieldTypeGUID", "alias": "RELGlobalID", "length": 38, "domain": null } ], "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": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "Parcels", "relatedTableId": 3, "role": "esriRelRoleDestination", "keyField": "RELGlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 5000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "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, "serviceItemId": "0774474acfd549a88832ae40bf1150a7" }