{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 102, "name": "AssetFuse", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Model", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "length": 50, "domain": { "type": "codedValue", "name": "FuseModel", "description": "Model", "codedValues": [ { "name": "100T", "code": "100T" }, { "name": "10T", "code": "10T" }, { "name": "12T", "code": "12T" }, { "name": "15-20T", "code": "15-20T" }, { "name": "20T", "code": "20T" }, { "name": "25T", "code": "25T" }, { "name": "30T", "code": "30T" }, { "name": "40T", "code": "40T" }, { "name": "65T", "code": "65T" }, { "name": "80T", "code": "80T" }, { "name": "15T", "code": "15T" }, { "name": "12K", "code": "12K" }, { "name": "20K", "code": "20K" }, { "name": "3T", "code": "3T" }, { "name": "3K", "code": "3K" }, { "name": "6T", "code": "6T" }, { "name": "6K", "code": "6K" }, { "name": "10K", "code": "10K" }, { "name": "15K", "code": "15K" }, { "name": "8T", "code": "8T" }, { "name": "50T", "code": "50T" }, { "name": "70T", "code": "70T" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PhaseCode", "type": "esriFieldTypeSmallInteger", "alias": "PhaseCode", "domain": { "type": "codedValue", "name": "PhaseCode", "description": "Present phases.", "codedValues": [ { "name": "A", "code": 129 }, { "name": "B", "code": 130 }, { "name": "AB", "code": 131 }, { "name": "C", "code": 132 }, { "name": "AC", "code": 133 }, { "name": "BC", "code": 134 }, { "name": "ABC", "code": 135 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "LinkRtg", "type": "esriFieldTypeDouble", "alias": "LinkRtg", "domain": null }, { "name": "Status", "type": "esriFieldTypeSmallInteger", "alias": "Status", "domain": { "type": "codedValue", "name": "Position", "description": "", "codedValues": [ { "name": "Open", "code": 0 }, { "name": "Closed", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DateCreated", "type": "esriFieldTypeDate", "alias": "DateCreated", "length": 8, "domain": null }, { "name": "DateModified", "type": "esriFieldTypeDate", "alias": "DateModified", "length": 8, "domain": null }, { "name": "LastModifiedBy", "type": "esriFieldTypeString", "alias": "LastModifiedBy", "length": 30, "domain": null }, { "name": "MaxContAmp", "type": "esriFieldTypeDouble", "alias": "MaxContAmp", "domain": null }, { "name": "MaxIntAmp", "type": "esriFieldTypeDouble", "alias": "MaxIntAmp", "domain": null }, { "name": "RatedVolt", "type": "esriFieldTypeDouble", "alias": "RatedVolt", "domain": { "type": "codedValue", "name": "KV", "description": "", "codedValues": [ { "name": "2.4", "code": 2.4 }, { "name": "7.2", "code": 7.2 }, { "name": "14.4", "code": 14.4 }, { "name": "19.9", "code": 19.9 }, { "name": "7.62", "code": 7.62 }, { "name": "12.5", "code": 12.5 }, { "name": "24.9", "code": 24.9 }, { "name": "34.5", "code": 34.5 }, { "name": "13.2", "code": 13.2 }, { "name": "69", "code": 69 }, { "name": "39.8", "code": 39.873 }, { "name": "66.395", "code": 66.395 }, { "name": "132.79", "code": 132.79 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "WorkOrderNumber", "type": "esriFieldTypeString", "alias": "WorkOrderNumber", "length": 50, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "FuturaGUID", "type": "esriFieldTypeString", "alias": "FuturaGUID", "length": 50, "domain": null }, { "name": "BankGUID", "type": "esriFieldTypeString", "alias": "BankGUID", "length": 50, "domain": null }, { "name": "CoopNumber", "type": "esriFieldTypeString", "alias": "CoopNumber", "length": 50, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 50, "domain": null }, { "name": "DateRemoved", "type": "esriFieldTypeDate", "alias": "DateRemoved", "length": 8, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": { "type": "codedValue", "name": "AssetLocation", "description": "Location of Asset", "codedValues": [ { "name": "Installed", "code": "Installed" }, { "name": "Warehouse", "code": "Warehouse" }, { "name": "Disposed", "code": "Disposed" }, { "name": "OffSiteService", "code": "OffSiteService" }, { "name": "InstallPending", "code": "InstallPending" }, { "name": "RetirePending", "code": "RetirePending" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MapNumber", "type": "esriFieldTypeString", "alias": "MapNumber", "length": 50, "domain": null }, { "name": "Prikey", "type": "esriFieldTypeInteger", "alias": "Prikey", "domain": null }, { "name": "DateInstalled", "type": "esriFieldTypeDate", "alias": "DateInstalled", "length": 8, "domain": null }, { "name": "EQUIPMENT_INFO_SERIALNUM", "type": "esriFieldTypeString", "alias": "EQUIPMENT_INFO_SERIALNUM", "length": 150, "domain": null }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 50, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "FDO_GlobalID", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G78BankGUID", "fields": "BankGUID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 29, "name": "AssetFuseHistory", "relatedTableId": 103, "role": "esriRelRoleOrigin", "keyField": "BankGUID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 22, "name": "FuseBank", "relatedTableId": 8, "role": "esriRelRoleDestination", "keyField": "BankGUID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Query,Map,Data", "maxRecordCount": 20000, "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, "supportsSqlFormat": false, "supportsQueryAnalytic": false }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }