{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 47, "name": "AssetTransformer", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "CoopNumber", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CoopNumber", "type": "esriFieldTypeString", "alias": "CoopNumber", "length": 50, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 50, "domain": null }, { "name": "Kva", "type": "esriFieldTypeDouble", "alias": "Kva", "domain": { "type": "codedValue", "name": "TransformerKva", "description": "", "codedValues": [ { "name": "1", "code": 1 }, { "name": "1.5", "code": 1.5 }, { "name": "3", "code": 3 }, { "name": "5", "code": 5 }, { "name": "7", "code": 7 }, { "name": "7.5", "code": 7.5 }, { "name": "10", "code": 10 }, { "name": "15", "code": 15 }, { "name": "25", "code": 25 }, { "name": "37.5", "code": 37.5 }, { "name": "45", "code": 45 }, { "name": "50", "code": 50 }, { "name": "75", "code": 75 }, { "name": "100", "code": 100 }, { "name": "112.5", "code": 112.5 }, { "name": "150", "code": 150 }, { "name": "167", "code": 167 }, { "name": "225", "code": 225 }, { "name": "250", "code": 250 }, { "name": "300", "code": 300 }, { "name": "333", "code": 333 }, { "name": "500", "code": 500 }, { "name": "750", "code": 750 }, { "name": "1000", "code": 1000 }, { "name": "1500", "code": 1500 }, { "name": "2000", "code": 2000 }, { "name": "2500", "code": 2500 }, { "name": "3000", "code": 3000 }, { "name": "3750", "code": 3750 }, { "name": "5000", "code": 5000 }, { "name": "999", "code": 999 } ], "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": "TransformerType", "type": "esriFieldTypeString", "alias": "TransformerType", "length": 50, "domain": { "type": "codedValue", "name": "AssetTransProtection", "description": "Conventional or CSP", "codedValues": [ { "name": "Conventional", "code": "Conv" }, { "name": "CSP", "code": "CSP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Placement", "type": "esriFieldTypeSmallInteger", "alias": "Placement", "domain": { "type": "codedValue", "name": "Placement", "description": "", "codedValues": [ { "name": "Overhead", "code": 1 }, { "name": "Underground", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 50, "domain": { "type": "codedValue", "name": "AssetManufacturer", "description": "", "codedValues": [ { "name": "Cooper", "code": "Cooper" }, { "name": "ABB", "code": "ABB" }, { "name": "Chance", "code": "Chance" }, { "name": "UUS", "code": "UUS" }, { "name": "Dowzer", "code": "Dowzer" }, { "name": "Heavy Duty", "code": "Heavy Duty" }, { "name": "Kentucky", "code": "Kentucky" }, { "name": "Line Material", "code": "Line Material" }, { "name": "Pole Star", "code": "Pole Star" }, { "name": "Allis-Chalmers", "code": "Allis-Chalmers" }, { "name": "GE", "code": "GE" }, { "name": "McGraw-Edison", "code": "McGraw-Edison" }, { "name": "Siemens", "code": "Siemens" }, { "name": "Westinghouse", "code": "Westinghouse" }, { "name": "ERMCO", "code": "ERMCO" }, { "name": "PROLEC", "code": "PROLEC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Phase", "type": "esriFieldTypeString", "alias": "Phase", "length": 20, "domain": { "type": "codedValue", "name": "AssetTransPhase", "description": "Single or Three Phase Equipment", "codedValues": [ { "name": "Single", "code": "Single" }, { "name": "Three", "code": "Three" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "VoltRating", "type": "esriFieldTypeString", "alias": "VoltRating", "length": 10, "domain": { "type": "codedValue", "name": "AssetTransVoltRating", "description": "Voltage Rating", "codedValues": [ { "name": "14.4/7.2", "code": "14.4/7.2" }, { "name": "14.4", "code": "14.4" }, { "name": "7.2", "code": "7.2" }, { "name": "12.47/7.2", "code": "12.47/7.2" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "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": "DateInstalled", "type": "esriFieldTypeDate", "alias": "DateInstalled", "length": 8, "domain": null }, { "name": "DateRemoved", "type": "esriFieldTypeDate", "alias": "DateRemoved", "length": 8, "domain": null }, { "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": "Impedance", "type": "esriFieldTypeString", "alias": "Impedance", "length": 50, "domain": null }, { "name": "WorkOrderNumber", "type": "esriFieldTypeString", "alias": "WorkOrderNumber", "length": 50, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "StructureMapNumber", "type": "esriFieldTypeString", "alias": "StructureMapNumber", "length": 50, "domain": null }, { "name": "FuturaGUID", "type": "esriFieldTypeString", "alias": "FuturaGUID", "length": 50, "domain": null }, { "name": "BankGUID", "type": "esriFieldTypeString", "alias": "BankGUID", "length": 50, "domain": null }, { "name": "Mapnumber", "type": "esriFieldTypeString", "alias": "Mapnumber", "length": 50, "domain": null }, { "name": "Prikey", "type": "esriFieldTypeInteger", "alias": "Prikey", "domain": null }, { "name": "EQUIPMENT_INFO_SERIALNUM", "type": "esriFieldTypeString", "alias": "EQUIPMENT_INFO_SERIALNUM", "length": 150, "domain": null }, { "name": "SecondaryVoltage", "type": "esriFieldTypeString", "alias": "SecondaryVoltage", "length": 50, "domain": { "type": "codedValue", "name": "MeterServiceVoltage", "description": "", "codedValues": [ { "name": "120/208", "code": "120/208" }, { "name": "240/480", "code": "240/480" }, { "name": "277/480", "code": "277/480" }, { "name": "Unk", "code": "Unk" }, { "name": "138/240", "code": "138/240" }, { "name": "120/240", "code": "120/240" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "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": "G84FuturaGUID", "fields": "FuturaGUID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G84BankGUID", "fields": "BankGUID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 37, "name": "AssetTransHistory", "relatedTableId": 48, "role": "esriRelRoleOrigin", "keyField": "FuturaGUID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 1, "name": "TransformerBank", "relatedTableId": 73, "role": "esriRelRoleDestination", "keyField": "BankGUID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "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, "supportsSqlFormat": false, "supportsQueryAnalytic": false }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }