{ "currentVersion": 10.91, "id": 43, "name": "Metrics", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "BOUNDARYNAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "BOUNDARYNAME", "type": "esriFieldTypeString", "alias": "Boundary Name", "length": 255, "domain": null }, { "name": "REPORTDT", "type": "esriFieldTypeDate", "alias": "Date Reported", "length": 8, "domain": null }, { "name": "METRIC", "type": "esriFieldTypeString", "alias": "Metric", "length": 255, "domain": null }, { "name": "OUTCOME", "type": "esriFieldTypeString", "alias": "Outcome", "length": 255, "domain": null }, { "name": "ACTUAL", "type": "esriFieldTypeDouble", "alias": "Actual", "domain": null }, { "name": "TARGET", "type": "esriFieldTypeDouble", "alias": "Target", "domain": null }, { "name": "CREATIONDATE", "type": "esriFieldTypeDate", "alias": "CreationDate", "length": 8, "domain": null }, { "name": "CREATOR", "type": "esriFieldTypeString", "alias": "Creator", "length": 128, "domain": null }, { "name": "EDITDATE", "type": "esriFieldTypeDate", "alias": "EditDate", "length": 8, "domain": null }, { "name": "EDITOR", "type": "esriFieldTypeString", "alias": "Editor", "length": 128, "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "REPORTDT_INT", "type": "esriFieldTypeInteger", "alias": "Year Reported", "domain": null }, { "name": "STARTDT", "type": "esriFieldTypeDate", "alias": "Start Date", "length": 8, "domain": null }, { "name": "STARTMONTH", "type": "esriFieldTypeString", "alias": "Start Month", "length": 10, "domain": null }, { "name": "STARTYR", "type": "esriFieldTypeString", "alias": "Start Year", "length": 4, "domain": null }, { "name": "REPORTMONTH", "type": "esriFieldTypeString", "alias": "Month Reported", "length": 10, "domain": null }, { "name": "REPORTYR", "type": "esriFieldTypeString", "alias": "Year Reported", "length": 4, "domain": null }, { "name": "DATERANGE", "type": "esriFieldTypeString", "alias": "Date Range", "length": 20, "domain": null } ], "indexes": [ { "name": "R580_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_580", "fields": "GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G1277BOUNDARYNAM", "fields": "BOUNDARYNAME", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I1277CREATIONDAT", "fields": "CREATIONDATE", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I1277CREATOR", "fields": "CREATOR", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I1277EDITDATE", "fields": "EDITDATE", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I1277EDITOR", "fields": "EDITOR", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I1277METRIC", "fields": "METRIC", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "CelebrateOneDashboardAreas", "relatedTableId": 47, "role": "esriRelRoleDestination", "keyField": "boundaryname", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": false, "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": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true } }