{ "currentVersion": 10.81, "id": 2, "name": "SR Table from Cityworks", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "PROBLEMCODE", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "REQUESTID_UNIQUE", "type": "esriFieldTypeOID", "alias": "REQUESTID_UNIQUE", "domain": null }, { "name": "PROBLEMCODE", "type": "esriFieldTypeString", "alias": "PROBLEMCODE", "length": 20, "domain": null }, { "name": "DESCRIPTION", "type": "esriFieldTypeString", "alias": "DESCRIPTION", "length": 50, "domain": null }, { "name": "REQCATEGORY", "type": "esriFieldTypeString", "alias": "REQCATEGORY", "length": 50, "domain": null }, { "name": "PROBLEM_ADDRESS", "type": "esriFieldTypeString", "alias": "PROBLEM_ADDRESS", "length": 100, "domain": null }, { "name": "PRIORITY", "type": "esriFieldTypeString", "alias": "PRIORITY", "length": 2, "domain": null }, { "name": "INITIATEDBY", "type": "esriFieldTypeString", "alias": "INITIATEDBY", "length": 50, "domain": null }, { "name": "DETAILS", "type": "esriFieldTypeString", "alias": "DETAILS", "length": 500, "domain": null }, { "name": "SUBMITTO", "type": "esriFieldTypeString", "alias": "SUBMITTO", "length": 50, "domain": null }, { "name": "DATETIMEINIT", "type": "esriFieldTypeDate", "alias": "DATETIMEINIT", "length": 8, "domain": null }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "length": 50, "domain": null }, { "name": "DATETIMECLOSED", "type": "esriFieldTypeDate", "alias": "DATETIMECLOSED", "length": 8, "domain": null }, { "name": "WO", "type": "esriFieldTypeString", "alias": "WO", "length": 60, "domain": null }, { "name": "CurrentDate", "type": "esriFieldTypeDate", "alias": "CurrentDate", "length": 8, "domain": null }, { "name": "HOURS_ELAPSED", "type": "esriFieldTypeDouble", "alias": "HOURS_ELAPSED", "domain": null }, { "name": "HOURS_ELAPSED_BUSINESS", "type": "esriFieldTypeDouble", "alias": "HOURS_ELAPSED_BUSINESS", "domain": null }, { "name": "LATEFLAG", "type": "esriFieldTypeInteger", "alias": "LATEFLAG", "domain": null }, { "name": "X_COORD", "type": "esriFieldTypeInteger", "alias": "X_COORD", "domain": null }, { "name": "Y_COORD", "type": "esriFieldTypeInteger", "alias": "Y_COORD", "domain": null }, { "name": "INITDATETEXT", "type": "esriFieldTypeString", "alias": "INITDATETEXT", "length": 30, "domain": null }, { "name": "CLOSEDDATETEXT", "type": "esriFieldTypeString", "alias": "CLOSEDDATETEXT", "length": 30, "domain": null }, { "name": "HOURS_SINCEINIT", "type": "esriFieldTypeDouble", "alias": "HOURS_SINCEINIT", "domain": null }, { "name": "UTCTIMEINIT", "type": "esriFieldTypeDate", "alias": "UTCTIMEINIT", "length": 8, "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": false, "advancedQueryCapabilities": { "useStandardizedQueries": false, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true } }