{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 27, "name": "RoomsTableMap", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "FIRSTNAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "EMPLOYEEID", "type": "esriFieldTypeString", "alias": "EMPLOYEEID", "length": 50, "domain": null }, { "name": "FIRSTNAME", "type": "esriFieldTypeString", "alias": "FIRSTNAME", "length": 255, "domain": null }, { "name": "LASTNAME", "type": "esriFieldTypeString", "alias": "LASTNAME", "length": 255, "domain": null }, { "name": "LNAMEFNAME", "type": "esriFieldTypeString", "alias": "LNAMEFNAME", "length": 140, "domain": null }, { "name": "EMAIL", "type": "esriFieldTypeString", "alias": "EMAIL", "length": 255, "domain": null }, { "name": "DEPARTMENT", "type": "esriFieldTypeString", "alias": "DEPARTMENT", "length": 50, "domain": null }, { "name": "USERTYPE", "type": "esriFieldTypeString", "alias": "USERTYPE", "length": 255, "domain": null }, { "name": "LONGNAME", "type": "esriFieldTypeString", "alias": "LONGNAME", "length": 100, "domain": null }, { "name": "BUILDINGKEY", "type": "esriFieldTypeString", "alias": "BUILDINGKEY", "length": 50, "domain": null }, { "name": "UW_BLDG_CODE", "type": "esriFieldTypeString", "alias": "UW_BLDG_CODE", "length": 10, "domain": null }, { "name": "FLOOR", "type": "esriFieldTypeString", "alias": "FLOOR", "length": 5, "domain": null }, { "name": "SPACEID", "type": "esriFieldTypeString", "alias": "SPACEID", "length": 50, "domain": null }, { "name": "SHORTNAME", "type": "esriFieldTypeString", "alias": "SHORTNAME", "length": 25, "domain": null }, { "name": "ASSIGNMENTKEY", "type": "esriFieldTypeString", "alias": "ASSIGNMENTKEY", "length": 50, "domain": null }, { "name": "ORGANIZATIONID", "type": "esriFieldTypeString", "alias": "ORGANIZATIONID", "length": 50, "domain": null }, { "name": "ORGANIZATION", "type": "esriFieldTypeString", "alias": "ORGANIZATION", "length": 50, "domain": null }, { "name": "SECTIONID", "type": "esriFieldTypeString", "alias": "SECTIONID", "length": 50, "domain": null }, { "name": "SECTION", "type": "esriFieldTypeString", "alias": "SECTION", "length": 50, "domain": null }, { "name": "CAPACITY", "type": "esriFieldTypeInteger", "alias": "CAPACITY", "domain": null }, { "name": "PHYSICALCAPACITY", "type": "esriFieldTypeInteger", "alias": "PHYSICALCAPACITY", "domain": null }, { "name": "OCCUPANCY", "type": "esriFieldTypeSmallInteger", "alias": "OCCUPANCY", "domain": null }, { "name": "AVAILABILITY", "type": "esriFieldTypeString", "alias": "AVAILABILITY", "length": 50, "domain": null }, { "name": "VACANCY", "type": "esriFieldTypeSmallInteger", "alias": "VACANCY", "domain": null }, { "name": "NETAREA", "type": "esriFieldTypeDouble", "alias": "NETAREA", "domain": null }, { "name": "GROSSAREA", "type": "esriFieldTypeDouble", "alias": "GROSSAREA", "domain": null }, { "name": "DESCRIPTION", "type": "esriFieldTypeString", "alias": "DESCRIPTION", "length": 255, "domain": null }, { "name": "NOTES", "type": "esriFieldTypeString", "alias": "NOTES", "length": 255, "domain": null }, { "name": "SPACEUSECAT2KEY", "type": "esriFieldTypeString", "alias": "SPACEUSECAT2KEY", "length": 5, "domain": null }, { "name": "mapID", "type": "esriFieldTypeDouble", "alias": "mapID", "domain": null }, { "name": "EmployeeName", "type": "esriFieldTypeString", "alias": "EmployeeName", "length": 511, "domain": null }, { "name": "mapIDNew", "type": "esriFieldTypeOID", "alias": "mapIDNew", "domain": null }, { "name": "SPACETYPECAT1KEY", "type": "esriFieldTypeString", "alias": "SPACETYPECAT1KEY", "length": 5, "domain": null }, { "name": "SPACETYPECAT2KEY", "type": "esriFieldTypeString", "alias": "SPACETYPECAT2KEY", "length": 5, "domain": null }, { "name": "SPACEUSECAT1KEY", "type": "esriFieldTypeString", "alias": "SPACEUSECAT1KEY", "length": 5, "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "3a995cf04a1a41b5abd6ac83050bb53f" }