{ "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 5, "name": "Transformer Unit", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 0, "name": "NBUAssets.DBO.AssetPoints", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "assetid", "composite": false } ], "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, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "assetid", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "assetid", "type": "esriFieldTypeString", "alias": "AssetID", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "assetid" }, { "name": "UnitID", "type": "esriFieldTypeInteger", "alias": "UnitID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "UnitID" }, { "name": "Phase", "type": "esriFieldTypeString", "alias": "Phase", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Phase" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "KVA", "type": "esriFieldTypeString", "alias": "KVA", "domain": { "type": "codedValue", "name": "KVA", "description": "KVA values for Transformers", "codedValues": [ { "name": "1", "code": "1" }, { "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": "500", "code": "500" }, { "name": "750", "code": "750" }, { "name": "1000", "code": "1000" }, { "name": "1500", "code": "1500" }, { "name": "2000", "code": "2000" }, { "name": "2500", "code": "2500" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "KVA" }, { "name": "Manufacturer", "type": "esriFieldTypeInteger", "alias": "Manufacturer", "domain": { "type": "codedValue", "name": "Department_ID", "description": "Manufacturer", "codedValues": [ { "name": "ABB", "code": 7 }, { "name": "KUHLMAN", "code": 8 }, { "name": "HOWARD", "code": 9 }, { "name": "GRAYBAR", "code": 10 }, { "name": "ALLIS CHALMERS", "code": 11 }, { "name": "WEST/HOUSE", "code": 12 }, { "name": "MAGNETIC", "code": 13 }, { "name": "TEMPLE", "code": 14 }, { "name": "ALAMO TRANSFORMER", "code": 15 }, { "name": "ERMCO", "code": 16 }, { "name": "WAGNER", "code": 17 }, { "name": "LINE MATERIAL INDUSTRIES", "code": 19 }, { "name": "SOUTHWAY", "code": 20 }, { "name": "ARKANSAS ELECTRIC", "code": 22 }, { "name": "FAPCO", "code": 23 }, { "name": "ELECTRIC", "code": 25 }, { "name": "GE - PROLEC", "code": 28 }, { "name": "RTE", "code": 30 }, { "name": "PAUWEL CHANCE", "code": 31 }, { "name": "MOLONEY", "code": 32 }, { "name": "HIPER CORE", "code": 34 }, { "name": "CARTER", "code": 35 }, { "name": "GREENVILLE TRANSFORMER", "code": 36 }, { "name": "MID-CENT.", "code": 37 }, { "name": "SIEMENS", "code": 38 }, { "name": "CTE", "code": 39 }, { "name": "JFR", "code": 41 }, { "name": "AF", "code": 42 }, { "name": "HEVI DUTY ELECTRIC", "code": 43 }, { "name": "LEXINGTON", "code": 46 }, { "name": "SUNBELT SOLOMON", "code": 47 }, { "name": "DIST. TRANS.", "code": 48 }, { "name": "KYLE", "code": 49 }, { "name": "ATSCO", "code": 50 }, { "name": "EDISON", "code": 51 }, { "name": "VANTRAN ELECTRIC", "code": 52 }, { "name": "ZINCO", "code": 53 }, { "name": "VAN TRAN.", "code": 54 }, { "name": "H & I", "code": 55 }, { "name": "S I D", "code": 56 }, { "name": "DELTA STAR", "code": 57 }, { "name": "POLE STAR", "code": 59 }, { "name": "PENN", "code": 60 }, { "name": "CENTRAL TRAN CORP", "code": 61 }, { "name": "PRECISION", "code": 62 }, { "name": "AEC", "code": 63 }, { "name": "TEC", "code": 64 }, { "name": "CG POWER", "code": 65 }, { "name": "POWER PARTNER", "code": 66 }, { "name": "WEG TRANSF.", "code": 67 }, { "name": "UNITED TRS. ELECTRIC", "code": 68 }, { "name": "EMERALD TRANSFORMERS", "code": 69 }, { "name": "DELTA ELECTRIC", "code": 70 }, { "name": "MIDWEST TRANSF.", "code": 71 }, { "name": "TST", "code": 72 }, { "name": "MADDOX TRANSF.", "code": 73 }, { "name": "RYMEL", "code": 74 }, { "name": "DAELIM", "code": 75 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Manufacturer" }, { "name": "Serial_Num", "type": "esriFieldTypeString", "alias": "Serial_Num", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Serial_Num" }, { "name": "Secondary_Volt", "type": "esriFieldTypeString", "alias": "Secondary_Volt", "domain": { "type": "codedValue", "name": "Secondary_Voltage", "description": "Secondary Voltage for Transformers", "codedValues": [ { "name": "120/240", "code": "1" }, { "name": "120/208", "code": "2" }, { "name": "277/480", "code": "3" }, { "name": "280/477", "code": "4" }, { "name": "120", "code": "5" }, { "name": "240", "code": "6" }, { "name": "277", "code": "7" }, { "name": "120/240/208", "code": "8" }, { "name": "240/480", "code": "9" }, { "name": "240/480/15", "code": "10" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "Secondary_Volt" }, { "name": "trx_type", "type": "esriFieldTypeInteger", "alias": "trx_type", "domain": { "type": "codedValue", "name": "Asset_Category_ID", "description": "Asset_Category", "codedValues": [ { "name": "Conventional", "code": 5 }, { "name": "Pad Mount", "code": 6 }, { "name": "Recloser", "code": 9 }, { "name": "Regulator", "code": 10 }, { "name": "High Voltage", "code": 11 }, { "name": "Switch", "code": 12 }, { "name": "PD MT Stainless", "code": 14 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "trx_type" } ], "indexes": [ { "name": "R28_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_39_assetid", "fields": "assetid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_39_UnitID", "fields": "UnitID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_28", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_28", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "Transformer Unit", "description": "", "prototype": { "attributes": { "Secondary_Volt": null, "Serial_Num": null, "assetid": null, "UnitID": null, "Phase": null, "trx_type": null, "Manufacturer": null, "KVA": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query,Create,Update,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }