{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 61, "name": "CCC_UPS", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "BuildingID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "BuildingID", "type": "esriFieldTypeString", "alias": "BuildingID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "BuildingID" }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "AssetID" }, { "name": "UPSID", "type": "esriFieldTypeDouble", "alias": "UPSID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "UPSID" }, { "name": "Serial", "type": "esriFieldTypeString", "alias": "Serial", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Serial" }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Model" }, { "name": "Make", "type": "esriFieldTypeString", "alias": "Make", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Make" }, { "name": "KVA", "type": "esriFieldTypeDouble", "alias": "KVA", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "KVA" }, { "name": "Amp", "type": "esriFieldTypeDouble", "alias": "Amp", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Amp" }, { "name": "Purchased", "type": "esriFieldTypeDate", "alias": "Purchased", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Purchased" }, { "name": "Building", "type": "esriFieldTypeString", "alias": "Building", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Building" }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Address" }, { "name": "IDF", "type": "esriFieldTypeString", "alias": "IDF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "IDF" }, { "name": "IDFLocation", "type": "esriFieldTypeString", "alias": "IDFLocation", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "IDFLocation" }, { "name": "Comment", "type": "esriFieldTypeString", "alias": "Comment", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Comment" }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Status" }, { "name": "OwnedBy", "type": "esriFieldTypeString", "alias": "OwnedBy", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OwnedBy" }, { "name": "BatteryModel", "type": "esriFieldTypeString", "alias": "BatteryModel", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "BatteryModel" }, { "name": "BatterySerial", "type": "esriFieldTypeString", "alias": "BatterySerial", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "BatterySerial" }, { "name": "BatteryMake", "type": "esriFieldTypeString", "alias": "BatteryMake", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "BatteryMake" }, { "name": "BatteryInstalled", "type": "esriFieldTypeDate", "alias": "BatteryInstalled", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "BatteryInstalled" }, { "name": "BatteryExpiration", "type": "esriFieldTypeDate", "alias": "BatteryExpiration", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "BatteryExpiration" }, { "name": "BatteryVoltage", "type": "esriFieldTypeString", "alias": "BatteryVoltage", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "BatteryVoltage" }, { "name": "BAtteryAmp", "type": "esriFieldTypeString", "alias": "BAtteryAmp", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "BAtteryAmp" }, { "name": "WarrantyInfo", "type": "esriFieldTypeString", "alias": "WarrantyInfo", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "WarrantyInfo" }, { "name": "BuildingID1", "type": "esriFieldTypeDouble", "alias": "BuildingID1", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BuildingID1" }, { "name": "Asset", "type": "esriFieldTypeString", "alias": "Asset", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Asset" }, { "name": "IDFID", "type": "esriFieldTypeDouble", "alias": "IDFID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "IDFID" }, { "name": "FloorType", "type": "esriFieldTypeString", "alias": "FloorType", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FloorType" }, { "name": "Cost", "type": "esriFieldTypeString", "alias": "Cost", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Cost" }, { "name": "Link1", "type": "esriFieldTypeString", "alias": "Link1", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Link1" }, { "name": "Serial1", "type": "esriFieldTypeString", "alias": "Serial1", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Serial1" }, { "name": "Model1", "type": "esriFieldTypeString", "alias": "Model1", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Model1" }, { "name": "Make1", "type": "esriFieldTypeString", "alias": "Make1", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Make1" }, { "name": "KVA1", "type": "esriFieldTypeDouble", "alias": "KVA1", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "KVA1" }, { "name": "Amp1", "type": "esriFieldTypeDouble", "alias": "Amp1", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Amp1" }, { "name": "Purchased1", "type": "esriFieldTypeDate", "alias": "Purchased1", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Purchased1" }, { "name": "Building1", "type": "esriFieldTypeString", "alias": "Building1", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Building1" }, { "name": "Address1", "type": "esriFieldTypeString", "alias": "Address1", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Address1" }, { "name": "IDF1", "type": "esriFieldTypeString", "alias": "IDF1", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "IDF1" }, { "name": "IDFLocation1", "type": "esriFieldTypeString", "alias": "IDFLocation1", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "IDFLocation1" }, { "name": "Comment1", "type": "esriFieldTypeString", "alias": "Comment1", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Comment1" }, { "name": "Status1", "type": "esriFieldTypeString", "alias": "Status1", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Status1" }, { "name": "OwnedBy1", "type": "esriFieldTypeString", "alias": "OwnedBy1", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OwnedBy1" }, { "name": "BatteryModel1", "type": "esriFieldTypeString", "alias": "BatteryModel1", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "BatteryModel1" }, { "name": "BatterySerial1", "type": "esriFieldTypeString", "alias": "BatterySerial1", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "BatterySerial1" }, { "name": "BatteryMake1", "type": "esriFieldTypeString", "alias": "BatteryMake1", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "BatteryMake1" }, { "name": "BatteryInstalled1", "type": "esriFieldTypeDate", "alias": "BatteryInstalled1", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "BatteryInstalled1" }, { "name": "BatteryExpiration1", "type": "esriFieldTypeDate", "alias": "BatteryExpiration1", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "BatteryExpiration1" }, { "name": "BatteryVoltage1", "type": "esriFieldTypeString", "alias": "BatteryVoltage1", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "BatteryVoltage1" }, { "name": "BAtteryAmp1", "type": "esriFieldTypeString", "alias": "BAtteryAmp1", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "BAtteryAmp1" }, { "name": "WarrantyInfo1", "type": "esriFieldTypeString", "alias": "WarrantyInfo1", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "WarrantyInfo1" }, { "name": "BuildingID2", "type": "esriFieldTypeDouble", "alias": "BuildingID2", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BuildingID2" }, { "name": "Asset1", "type": "esriFieldTypeString", "alias": "Asset1", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Asset1" }, { "name": "IDFID1", "type": "esriFieldTypeDouble", "alias": "IDFID1", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "IDFID1" }, { "name": "FloorType1", "type": "esriFieldTypeString", "alias": "FloorType1", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FloorType1" }, { "name": "Cost1", "type": "esriFieldTypeString", "alias": "Cost1", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Cost1" }, { "name": "Link11", "type": "esriFieldTypeString", "alias": "Link11", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Link11" } ], "indexes": [ { "name": "R880_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_17042_Buildi", "fields": "BuildingID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "CCC_UPS", "description": "", "prototype": { "attributes": { "Cost1": null, "Link11": null, "BuildingID": null, "AssetID": null, "UPSID": null, "Serial": null, "Model": null, "Make": null, "KVA": null, "Amp": null, "Purchased": null, "Building": null, "Address": null, "IDF": null, "IDFLocation": null, "Comment": null, "Status": null, "OwnedBy": null, "BatteryModel": null, "BatterySerial": null, "BatteryMake": null, "BatteryInstalled": null, "BatteryExpiration": null, "BatteryVoltage": null, "BAtteryAmp": null, "WarrantyInfo": null, "BuildingID1": null, "Asset": null, "IDFID": null, "FloorType": null, "Cost": null, "Link1": null, "Serial1": null, "Model1": null, "Make1": null, "KVA1": null, "Amp1": null, "Purchased1": null, "Building1": null, "Address1": null, "IDF1": null, "IDFLocation1": null, "Comment1": null, "Status1": null, "OwnedBy1": null, "BatteryModel1": null, "BatterySerial1": null, "BatteryMake1": null, "BatteryInstalled1": null, "BatteryExpiration1": null, "BatteryVoltage1": null, "BAtteryAmp1": null, "WarrantyInfo1": null, "BuildingID2": null, "Asset1": null, "IDFID1": null, "FloorType1": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "e9e16de0a1ea40ac94ef04560ddedf68" }