{ "currentVersion": 10.81, "id": 1, "name": "plwc_gis.LANE.TransformerUnit", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "CreationUser", "typeIdField": "SubtypeCode", "subtypeFieldName": "SubtypeCode", "subtypeField": "SubtypeCode", "defaultSubtypeCode": 1, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CreationUser", "type": "esriFieldTypeString", "alias": "Creation User", "length": 20, "domain": null }, { "name": "DateCreated", "type": "esriFieldTypeDate", "alias": "Date Created", "length": 8, "domain": null }, { "name": "DateModified", "type": "esriFieldTypeDate", "alias": "Date Modified", "length": 8, "domain": null }, { "name": "LastUser", "type": "esriFieldTypeString", "alias": "Last User", "length": 20, "domain": null }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "Unit Facility ID", "length": 15, "domain": null }, { "name": "PhasingCode", "type": "esriFieldTypeInteger", "alias": "Phasing Code", "domain": { "type": "codedValue", "name": "Phase Designation", "description": "", "codedValues": [ { "name": "A", "code": 4 }, { "name": "B", "code": 2 }, { "name": "C", "code": 1 }, { "name": "AB", "code": 6 }, { "name": "AC", "code": 5 }, { "name": "BC", "code": 3 }, { "name": "ABC", "code": 7 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "Serial Number", "length": 15, "domain": null }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 20, "domain": { "type": "codedValue", "name": "Transformer Unit Manufacturer", "description": "", "codedValues": [ { "name": "Central Maloney", "code": "CM" }, { "name": "Delta", "code": "D" }, { "name": "General Electric", "code": "GE" }, { "name": "Other", "code": "OTH" }, { "name": "ABB", "code": "ABB" }, { "name": "Westinghouse", "code": "WH" }, { "name": "Waukesha", "code": "WS" }, { "name": "Pauwells", "code": "PLS" }, { "name": "Cooper", "code": "CPR" }, { "name": "Howard", "code": "H" }, { "name": "Ermco", "code": "EMCO" }, { "name": "Solomon", "code": "SOL" }, { "name": "Allis Chalmer", "code": "AC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "RatedKVA", "type": "esriFieldTypeDouble", "alias": "Rated kVA", "domain": { "type": "codedValue", "name": "Transformer Unit KVA", "description": "", "codedValues": [ { "name": "47.5", "code": 47.5 }, { "name": "5", "code": 5 }, { "name": "200", "code": 200 }, { "name": "1.5", "code": 1.5 }, { "name": "40", "code": 40 }, { "name": "10", "code": 10 }, { "name": "15", "code": 15 }, { "name": "25", "code": 25 }, { "name": "37.5", "code": 37.5 }, { "name": "50", "code": 50 }, { "name": "75", "code": 75 }, { "name": "100", "code": 100 }, { "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": "35", "code": 35 }, { "name": "20", "code": 20 }, { "name": "65", "code": 65 }, { "name": "112.5", "code": 112.5 }, { "name": "7.5", "code": 7.5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "XfmrType", "type": "esriFieldTypeString", "alias": "Transformer Type", "length": 3, "domain": null }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Transformer Status", "length": 2, "domain": null }, { "name": "Impedance", "type": "esriFieldTypeDouble", "alias": "Impedance", "domain": null }, { "name": "NLLoss", "type": "esriFieldTypeDouble", "alias": "No Load Losses", "domain": null }, { "name": "FLLoss", "type": "esriFieldTypeDouble", "alias": "Full Load Losses", "domain": null }, { "name": "Price", "type": "esriFieldTypeDouble", "alias": "Purchase Price", "domain": null }, { "name": "MfgDate", "type": "esriFieldTypeDate", "alias": "Manufacture Date", "length": 8, "domain": null }, { "name": "PCBCode", "type": "esriFieldTypeString", "alias": "PCB Code", "length": 2, "domain": null }, { "name": "SubtypeCode", "type": "esriFieldTypeInteger", "alias": "Subtype", "domain": null }, { "name": "TransformerID", "type": "esriFieldTypeInteger", "alias": "Transformer Object ID", "domain": null }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "length": 20, "domain": null }, { "name": "CoolingType", "type": "esriFieldTypeString", "alias": "CoolingType", "length": 5, "domain": null }, { "name": "TapsType", "type": "esriFieldTypeString", "alias": "TapsType", "length": 5, "domain": null }, { "name": "ProtectionType", "type": "esriFieldTypeString", "alias": "ProtectionType", "length": 5, "domain": null }, { "name": "HighSideRatedVoltage", "type": "esriFieldTypeInteger", "alias": "HighSideRatedVoltage", "domain": null }, { "name": "LowSideRatedVoltage", "type": "esriFieldTypeInteger", "alias": "LowSideRatedVoltage", "domain": null } ], "indexes": [ { "name": "R560_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G891TransformerI", "fields": "TransformerID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "FacID", "fields": "FacilityID", "isAscending": true, "isUnique": false, "description": "" } ], "types": [ { "domains": { "PhasingCode": {"type": "inherited"}, "Manufacturer": {"type": "inherited"}, "RatedKVA": {"type": "inherited"}, "XfmrType": { "type": "codedValue", "name": "Transformer Type", "description": "", "codedValues": [ { "name": "Pad Mount", "code": "PDM" }, { "name": "Pole Mount", "code": "PLM" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "Status": { "type": "codedValue", "name": "Transformer Status", "description": "", "codedValues": [ { "name": "Active in Field", "code": "AF" }, { "name": "Junk", "code": "JK" }, { "name": "Stock", "code": "SK" }, { "name": "Returned", "code": "RP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "CoolingType": { "type": "codedValue", "name": "Transformer Unit Cooling Type", "description": "", "codedValues": [ { "name": "Radiator Forced Air", "code": "RFA" }, { "name": "Other", "code": "OTH" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "TapsType": { "type": "codedValue", "name": "Transformer Unit Taps Type", "description": "", "codedValues": [ { "name": "2 Above/2 Below", "code": "22" }, { "name": "4 Above", "code": "4A" }, { "name": "None", "code": "NN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "ProtectionType": { "type": "codedValue", "name": "Transformer Unit Protection Type", "description": "", "codedValues": [ { "name": "Bayonet Fused", "code": "BF" }, { "name": "Completely Self-Protected", "code": "CSP" }, { "name": "Conventional", "code": "CONV" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "HighSideRatedVoltage": { "type": "codedValue", "name": "Electric Line Voltage", "description": "", "codedValues": [ { "name": "7.62 kV", "code": 762 }, { "name": "161 kV", "code": 161 }, { "name": "13.2 kV Yg", "code": 230 }, { "name": "69 kV Delta", "code": 69 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "LowSideRatedVoltage": { "type": "codedValue", "name": "Secondary Nominal Voltage", "description": "", "codedValues": [ { "name": "120 Volts", "code": 10 }, { "name": "120/208 Volts", "code": 20 }, { "name": "120/240 Volts", "code": 30 }, { "name": "277/480 Volts", "code": 50 }, { "name": "480 Volts", "code": 60 }, { "name": "240/480 Volts", "code": 70 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, "id": 1, "name": "Transformer Unit" } ], "subtypes": [ { "domains": { "PhasingCode": {"type": "inherited"}, "Manufacturer": {"type": "inherited"}, "RatedKVA": {"type": "inherited"}, "XfmrType": { "type": "codedValue", "name": "Transformer Type", "description": "", "codedValues": [ { "name": "Pad Mount", "code": "PDM" }, { "name": "Pole Mount", "code": "PLM" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "Status": { "type": "codedValue", "name": "Transformer Status", "description": "", "codedValues": [ { "name": "Active in Field", "code": "AF" }, { "name": "Junk", "code": "JK" }, { "name": "Stock", "code": "SK" }, { "name": "Returned", "code": "RP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "CoolingType": { "type": "codedValue", "name": "Transformer Unit Cooling Type", "description": "", "codedValues": [ { "name": "Radiator Forced Air", "code": "RFA" }, { "name": "Other", "code": "OTH" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "TapsType": { "type": "codedValue", "name": "Transformer Unit Taps Type", "description": "", "codedValues": [ { "name": "2 Above/2 Below", "code": "22" }, { "name": "4 Above", "code": "4A" }, { "name": "None", "code": "NN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "ProtectionType": { "type": "codedValue", "name": "Transformer Unit Protection Type", "description": "", "codedValues": [ { "name": "Bayonet Fused", "code": "BF" }, { "name": "Completely Self-Protected", "code": "CSP" }, { "name": "Conventional", "code": "CONV" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "HighSideRatedVoltage": { "type": "codedValue", "name": "Electric Line Voltage", "description": "", "codedValues": [ { "name": "7.62 kV", "code": 762 }, { "name": "161 kV", "code": 161 }, { "name": "13.2 kV Yg", "code": 230 }, { "name": "69 kV Delta", "code": 69 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "LowSideRatedVoltage": { "type": "codedValue", "name": "Secondary Nominal Voltage", "description": "", "codedValues": [ { "name": "120 Volts", "code": 10 }, { "name": "120/208 Volts", "code": 20 }, { "name": "120/240 Volts", "code": 30 }, { "name": "277/480 Volts", "code": 50 }, { "name": "480 Volts", "code": 60 }, { "name": "240/480 Volts", "code": 70 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, "defaultValues": { "CreationUser": null, "DateCreated": null, "DateModified": null, "LastUser": null, "FacilityID": null, "PhasingCode": null, "SerialNumber": null, "Manufacturer": null, "RatedKVA": 25, "XfmrType": null, "Status": null, "Impedance": null, "NLLoss": null, "FLLoss": null, "Price": null, "MfgDate": null, "PCBCode": null, "SubtypeCode": 1, "TransformerID": null, "Model": null, "CoolingType": "RFA", "TapsType": "22", "ProtectionType": "BF", "HighSideRatedVoltage": 762, "LowSideRatedVoltage": 30 }, "code": 1, "name": "Transformer Unit" } ], "relationships": [ { "id": 0, "name": "plwc_gis.LANE.TransformerBank", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "TransformerID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }