{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 2, "name": "All Open Tasks", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": false, "supportsASyncCalculate": false, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "extent": { "xmin": 2164084.249853326, "ymin": 1237109.498086967, "xmax": 2178215.9929099176, "ymax": 1252319.7237674224, "spatialReference": { "wkid": 102667, "latestWkid": 2240, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -16150100, "falseY": -43703500, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 4326, "latestWkid": 4326, "xyTolerance": 8.983152841195215E-9, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -400, "falseY": -400, "xyUnits": 9.999999999999999E8, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "5627b9efc8d9e4c042d4292cc6bbdd78", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABMAAAATCAYAAAByUDbMAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABtUlEQVQ4jb3UT0iTcRzH8feTz7O5odKmqQ8x/9DCKZuS9wmO1SKGeLFCT56ChEC6id66dFAQiQLttEsgHlS8KFN0QUx2KbdF5ApETVR0zGxNmeuwBnvqmW4hfW7f7xdefPn9+P1ELjHi/8QEoAmQgRiwBsQLxbRmmcdOK7edNuprKzAcHPN9OczG/AcCgQijwFY+mNHVwquxXtwlxegyzetGqmwmbvTdoX1kjlvjXgZjcfznYYLDysuJR3QVXVFfWRDgqRunWITm+TTd2RsqsPpKep494F4uKDtP7tK2GmFgKUifKtZmobPuGiUXU+kNHU3Yl4Lo+H0pCsxUgTkfKBO7BYsk0Xx6mj47BaaRKC0EK9Mj1RiQI7vpWoElTvhRCLZ9yNlOlEimVmCbB3wBrPli/s+sH58QVMW2o7zwfcRlb0R7EXT0E8KbeIGUKrbwnvlyPdM3Ze5XX80NJc9geJbQ1Cr92f2/XsCbdzyURLTuVjrsjQh/zjf2YWKR0E4cF5A4FwNSHh+dGomut5/olw00FIuUJVPE92J8/RZlxrPCkNrGOX+N14tMApO55gVh/5JLxX4BLvRyZ0YvpZkAAAAASUVORK5CYII=", "contentType": "image/png", "width": 14, "height": 14, "angle": 0, "xoffset": 0, "yoffset": 0 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "ESRI_OID", "globalIdField": "", "displayField": "CompletedByFirstName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "ServiceOrderDetailID", "type": "esriFieldTypeInteger", "alias": "ServiceOrderDetailID", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "ServiceOrderDetailID" }, { "name": "CreatedByID", "type": "esriFieldTypeInteger", "alias": "CreatedByID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CreatedByID" }, { "name": "DateCreated", "type": "esriFieldTypeDate", "alias": "DateCreated", "domain": null, "editable": true, "nullable": false, "length": 8, "defaultValue": null, "modelName": "DateCreated" }, { "name": "ScheduledStartDate", "type": "esriFieldTypeDate", "alias": "ScheduledStartDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ScheduledStartDate" }, { "name": "ScheduledEndDate", "type": "esriFieldTypeDate", "alias": "ScheduledEndDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ScheduledEndDate" }, { "name": "ActualStartDate", "type": "esriFieldTypeDate", "alias": "ActualStartDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ActualStartDate" }, { "name": "ActualEndDate", "type": "esriFieldTypeDate", "alias": "ActualEndDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ActualEndDate" }, { "name": "Priority", "type": "esriFieldTypeString", "alias": "Priority", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Priority" }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Status" }, { "name": "TaskType", "type": "esriFieldTypeString", "alias": "TaskType", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "TaskType" }, { "name": "Completed", "type": "esriFieldTypeSmallInteger", "alias": "Completed", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "Completed" }, { "name": "IsWorkItemType", "type": "esriFieldTypeSmallInteger", "alias": "IsWorkItemType", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "IsWorkItemType" }, { "name": "ServiceOrderNumber", "type": "esriFieldTypeString", "alias": "ServiceOrderNumber", "domain": null, "editable": true, "nullable": false, "length": 50, "defaultValue": null, "modelName": "ServiceOrderNumber" }, { "name": "ServiceOrderID", "type": "esriFieldTypeInteger", "alias": "ServiceOrderID", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "ServiceOrderID" }, { "name": "IsLocation", "type": "esriFieldTypeSmallInteger", "alias": "IsLocation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "IsLocation" }, { "name": "LocationID", "type": "esriFieldTypeString", "alias": "LocationID", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "LocationID" }, { "name": "LocationNo", "type": "esriFieldTypeString", "alias": "LocationNo", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LocationNo" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "Location" }, { "name": "IsCustomer", "type": "esriFieldTypeSmallInteger", "alias": "IsCustomer", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "IsCustomer" }, { "name": "CustomerID", "type": "esriFieldTypeString", "alias": "CustomerID", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "CustomerID" }, { "name": "CustomerNo", "type": "esriFieldTypeString", "alias": "CustomerNo", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CustomerNo" }, { "name": "Customer", "type": "esriFieldTypeString", "alias": "Customer", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "Customer" }, { "name": "IsService", "type": "esriFieldTypeSmallInteger", "alias": "IsService", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "IsService" }, { "name": "ServiceID", "type": "esriFieldTypeString", "alias": "ServiceID", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "ServiceID" }, { "name": "Service", "type": "esriFieldTypeString", "alias": "Service", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Service" }, { "name": "IsMeter", "type": "esriFieldTypeSmallInteger", "alias": "IsMeter", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "IsMeter" }, { "name": "MeterID", "type": "esriFieldTypeString", "alias": "MeterID", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "MeterID" }, { "name": "MeterNo", "type": "esriFieldTypeString", "alias": "MeterNo", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MeterNo" }, { "name": "IsGISAsset", "type": "esriFieldTypeSmallInteger", "alias": "IsGISAsset", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "IsGISAsset" }, { "name": "GISFileID", "type": "esriFieldTypeInteger", "alias": "GISFileID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "GISFileID" }, { "name": "GISLayer", "type": "esriFieldTypeString", "alias": "GISLayer", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "GISLayer" }, { "name": "IsAsset", "type": "esriFieldTypeSmallInteger", "alias": "IsAsset", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "IsAsset" }, { "name": "SchemaDocGuid", "type": "esriFieldTypeGUID", "alias": "SchemaDocGuid", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "SchemaDocGuid" }, { "name": "UtilityBillingServiceCodeTypeID", "type": "esriFieldTypeInteger", "alias": "UtilityBillingServiceCodeTypeID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "UtilityBillingServiceCodeTypeID" }, { "name": "IsUtilityBillingServiceOrder", "type": "esriFieldTypeSmallInteger", "alias": "IsUtilityBillingServiceOrder", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "IsUtilityBillingServiceOrder" }, { "name": "FeePosted", "type": "esriFieldTypeSmallInteger", "alias": "FeePosted", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FeePosted" }, { "name": "PriorityColor", "type": "esriFieldTypeString", "alias": "PriorityColor", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PriorityColor" }, { "name": "FeeAmount", "type": "esriFieldTypeDouble", "alias": "FeeAmount", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FeeAmount" }, { "name": "BillToAccount", "type": "esriFieldTypeString", "alias": "BillToAccount", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "BillToAccount" }, { "name": "CompletedByFirstName", "type": "esriFieldTypeString", "alias": "CompletedByFirstName", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CompletedByFirstName" }, { "name": "CompletedByLast", "type": "esriFieldTypeString", "alias": "CompletedByLast", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CompletedByLast" }, { "name": "LastModifiedByID", "type": "esriFieldTypeInteger", "alias": "LastModifiedByID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LastModifiedByID" }, { "name": "LastModified", "type": "esriFieldTypeDate", "alias": "LastModified", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LastModified" }, { "name": "PriorityID", "type": "esriFieldTypeInteger", "alias": "PriorityID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PriorityID" }, { "name": "StatusID", "type": "esriFieldTypeInteger", "alias": "StatusID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "StatusID" }, { "name": "TaskTypeID", "type": "esriFieldTypeInteger", "alias": "TaskTypeID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TaskTypeID" }, { "name": "ServiceOrderDetailTypeID", "type": "esriFieldTypeInteger", "alias": "ServiceOrderDetailTypeID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ServiceOrderDetailTypeID" }, { "name": "LOC_Address", "type": "esriFieldTypeString", "alias": "LOC_Address", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "LOC_Address" }, { "name": "LOC_City", "type": "esriFieldTypeString", "alias": "LOC_City", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "LOC_City" }, { "name": "CUST_Name", "type": "esriFieldTypeString", "alias": "CUST_Name", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "CUST_Name" }, { "name": "GIS_AssetTag", "type": "esriFieldTypeString", "alias": "GIS_AssetTag", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "GIS_AssetTag" }, { "name": "AssetNo", "type": "esriFieldTypeInteger", "alias": "AssetNo", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AssetNo" }, { "name": "ASSET_AssetTag", "type": "esriFieldTypeString", "alias": "ASSET_AssetTag", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "ASSET_AssetTag" }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "AssetID" }, { "name": "AssetLocation", "type": "esriFieldTypeString", "alias": "AssetLocation", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "AssetLocation" }, { "name": "AssetStatus", "type": "esriFieldTypeString", "alias": "AssetStatus", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "AssetStatus" }, { "name": "AssetType", "type": "esriFieldTypeString", "alias": "AssetType", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "AssetType" }, { "name": "TaskAssignmentCrews", "type": "esriFieldTypeString", "alias": "TaskAssignmentCrews", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "TaskAssignmentCrews" }, { "name": "TaskAssignmentUsers", "type": "esriFieldTypeString", "alias": "TaskAssignmentUsers", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "TaskAssignmentUsers" }, { "name": "TaskAssignmentContacts", "type": "esriFieldTypeString", "alias": "TaskAssignmentContacts", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "TaskAssignmentContacts" }, { "name": "GISAssetNo", "type": "esriFieldTypeString", "alias": "GISAssetNo", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "GISAssetNo" }, { "name": "DivisionID", "type": "esriFieldTypeInteger", "alias": "DivisionID", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "DivisionID" }, { "name": "Expr1", "type": "esriFieldTypeInteger", "alias": "Expr1", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Expr1" }, { "name": "NoteCount", "type": "esriFieldTypeInteger", "alias": "NoteCount", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "NoteCount" }, { "name": "Division", "type": "esriFieldTypeString", "alias": "Division", "domain": null, "editable": true, "nullable": false, "length": 250, "defaultValue": null, "modelName": "Division" }, { "name": "Problem", "type": "esriFieldTypeString", "alias": "Problem", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "Problem" }, { "name": "ResourcesCount", "type": "esriFieldTypeInteger", "alias": "ResourcesCount", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ResourcesCount" }, { "name": "ServiceOrderCategory", "type": "esriFieldTypeString", "alias": "ServiceOrderCategory", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ServiceOrderCategory" }, { "name": "ServiceOrderDescription", "type": "esriFieldTypeString", "alias": "ServiceOrderDescription", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "ServiceOrderDescription" }, { "name": "Type", "type": "esriFieldTypeString", "alias": "Type", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "Type" }, { "name": "Resolution", "type": "esriFieldTypeString", "alias": "Resolution", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "Resolution" }, { "name": "Total_Labor_Hours", "type": "esriFieldTypeDouble", "alias": "Total_Labor_Hours", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Total_Labor_Hours" }, { "name": "Total_Labor_Cost", "type": "esriFieldTypeDouble", "alias": "Total_Labor_Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Total_Labor_Cost" }, { "name": "Total_Inventory_fCost", "type": "esriFieldTypeDouble", "alias": "Total_Inventory_fCost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Total_Inventory_fCost" }, { "name": "TaskID", "type": "esriFieldTypeInteger", "alias": "TaskID", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "TaskID" }, { "name": "ESRI_OID", "type": "esriFieldTypeOID", "alias": "ESRI_OID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "ESRI_OID" } ], "geometryField": { "name": "GeoShape", "type": "esriFieldTypeGeometry", "alias": "GeoShape", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "GeoShape" }, "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "All Open Tasks", "description": "", "prototype": { "attributes": { "TaskID": 0, "ServiceOrderDetailID": 0, "CreatedByID": null, "DateCreated": -2209161600000, "ScheduledStartDate": null, "ScheduledEndDate": null, "ActualStartDate": null, "ActualEndDate": null, "Priority": null, "Status": null, "TaskType": null, "Completed": 0, "IsWorkItemType": null, "ServiceOrderNumber": " ", "ServiceOrderID": 0, "IsLocation": null, "LocationID": null, "LocationNo": null, "Location": null, "IsCustomer": null, "CustomerID": null, "CustomerNo": null, "Customer": null, "IsService": null, "ServiceID": null, "Service": null, "IsMeter": null, "MeterID": null, "MeterNo": null, "IsGISAsset": null, "GISFileID": null, "GISLayer": null, "IsAsset": null, "SchemaDocGuid": null, "UtilityBillingServiceCodeTypeID": null, "IsUtilityBillingServiceOrder": null, "FeePosted": null, "PriorityColor": null, "FeeAmount": null, "BillToAccount": null, "CompletedByFirstName": null, "CompletedByLast": null, "LastModifiedByID": null, "LastModified": null, "PriorityID": null, "StatusID": null, "TaskTypeID": null, "ServiceOrderDetailTypeID": null, "LOC_Address": null, "LOC_City": null, "CUST_Name": null, "GIS_AssetTag": null, "AssetNo": null, "ASSET_AssetTag": null, "AssetID": null, "AssetLocation": null, "AssetStatus": null, "AssetType": null, "TaskAssignmentCrews": null, "TaskAssignmentUsers": null, "TaskAssignmentContacts": null, "GISAssetNo": null, "DivisionID": 0, "Expr1": null, "NoteCount": null, "Division": " ", "Problem": null, "ResourcesCount": null, "ServiceOrderCategory": null, "ServiceOrderDescription": null, "Type": null, "Resolution": null, "Total_Labor_Hours": null, "Total_Labor_Cost": null, "Total_Inventory_fCost": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "8348677b4e5c4e8086fa667781164e82" }