{ "currentVersion": 10.81, "id": 34, "name": "Transformer Unit", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "FeatureID", "typeIdField": "Subtype", "subtypeFieldName": "Subtype", "subtypeField": "Subtype", "defaultSubtypeCode": 1, "fields": [ { "name": "FeatureID", "type": "esriFieldTypeString", "alias": "Transformer ID", "length": 20, "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CreationUser", "type": "esriFieldTypeString", "alias": "Creation User", "length": 50, "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": 50, "domain": null }, { "name": "Subtype", "type": "esriFieldTypeInteger", "alias": "Subtype", "domain": null }, { "name": "PhaseDesignation", "type": "esriFieldTypeInteger", "alias": "Phase Designation", "domain": { "type": "codedValue", "name": "WS2_eTransformerUnitPhaseDesignation", "description": "", "codedValues": [ { "name": "A", "code": 4 }, { "name": "B", "code": 2 }, { "name": "C", "code": 1 }, { "name": "ABC", "code": 7 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "InstallationDate", "type": "esriFieldTypeDate", "alias": "Installation Date", "length": 8, "domain": { "type": "range", "name": "WS2_DateRange", "description": "", "range": [ -2208988800000, 4102444800000 ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "RatedKVA", "type": "esriFieldTypeInteger", "alias": "Rated kVA", "domain": { "type": "codedValue", "name": "WS2_eTransformerUnitKVA", "description": "", "codedValues": [ { "name": ".5 kva", "code": 1 }, { "name": "1.5 kva", "code": 2 }, { "name": "3 kva", "code": 3 }, { "name": "5 kva", "code": 5 }, { "name": "7.5 kva", "code": 8 }, { "name": "10 kva", "code": 10 }, { "name": "15 kva", "code": 15 }, { "name": "25 kva", "code": 25 }, { "name": "37.5 kva", "code": 38 }, { "name": "50 kva", "code": 50 }, { "name": "75 kva", "code": 75 }, { "name": "100 kva", "code": 100 }, { "name": "112 kva", "code": 112 }, { "name": "150 kva", "code": 150 }, { "name": "167 kva", "code": 167 }, { "name": "225 kva", "code": 225 }, { "name": "250 kva", "code": 250 }, { "name": "300 kva", "code": 300 }, { "name": "333 kva", "code": 333 }, { "name": "500 kva", "code": 500 }, { "name": "750 kva", "code": 750 }, { "name": "1000 kva", "code": 1000 }, { "name": "1500 kva", "code": 1500 }, { "name": "1667 kva", "code": 1667 }, { "name": "2000 kva", "code": 2000 }, { "name": "2500 kva", "code": 2500 }, { "name": "45 kVa", "code": 45 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "HighSideRatedVoltage", "type": "esriFieldTypeInteger", "alias": "High Side Rated Voltage", "domain": { "type": "codedValue", "name": "WS2_eTransformerUnitHighSideVoltage", "description": "", "codedValues": [ { "name": "12470/7200 Volts", "code": 220 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "LowSideRatedVoltage", "type": "esriFieldTypeInteger", "alias": "Low Side Rated Voltage", "domain": { "type": "codedValue", "name": "WS2_eTransformerUnitLowSideVoltage", "description": "", "codedValues": [ { "name": "120 Volts", "code": 10 }, { "name": "120/208 Volts", "code": 20 }, { "name": "120/240 Volts", "code": 30 }, { "name": "240/480 Volts", "code": 40 }, { "name": "277/480 Volts", "code": 50 }, { "name": "480 Volts", "code": 60 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "HighSideBIL", "type": "esriFieldTypeInteger", "alias": "High Side BIL", "domain": { "type": "codedValue", "name": "WS2_eBIL_Rating", "description": "", "codedValues": [ { "name": "95 BIL", "code": 95 }, { "name": "110 BIL", "code": 110 }, { "name": "125 BIL", "code": 125 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "LowSideBIL", "type": "esriFieldTypeInteger", "alias": "Low Side BIL", "domain": { "type": "codedValue", "name": "WS2_eBIL_Rating", "description": "", "codedValues": [ { "name": "95 BIL", "code": 95 }, { "name": "110 BIL", "code": 110 }, { "name": "125 BIL", "code": 125 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "AnimalGuard", "type": "esriFieldTypeString", "alias": "Animal Guard Indicator", "length": 1, "domain": { "type": "codedValue", "name": "WS2_Yes/No_Indicator", "description": "", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ArrestorType", "type": "esriFieldTypeString", "alias": "Arrestor Type", "length": 3, "domain": { "type": "codedValue", "name": "WS2_eTransformerUnitArrestorType", "description": "", "codedValues": [ { "name": "Separate Arrestor", "code": "SPS" }, { "name": "Elbow Arrestor", "code": "ELB" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CoolingType", "type": "esriFieldTypeString", "alias": "Cooling Type", "length": 3, "domain": { "type": "codedValue", "name": "WS2_eTransformerUnitCoolingType", "description": "", "codedValues": [ { "name": "Radiator", "code": "RAD" }, { "name": "Other", "code": "OTH" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "FluidType", "type": "esriFieldTypeString", "alias": "Fluid Type", "length": 20, "domain": null }, { "name": "FullLoadLosses", "type": "esriFieldTypeDouble", "alias": "Full Load Losses", "domain": null }, { "name": "NoLoadLosses", "type": "esriFieldTypeDouble", "alias": "No Load Losses", "domain": null }, { "name": "Impedance", "type": "esriFieldTypeDouble", "alias": "Impedance", "domain": null }, { "name": "ProtectionType", "type": "esriFieldTypeString", "alias": "Protection Type", "length": 4, "domain": { "type": "codedValue", "name": "WS2_eTransformerUnitProtectionType", "description": "", "codedValues": [ { "name": "Bayonet", "code": "BF" }, { "name": "Completely Self Protected", "code": "CSP" }, { "name": "Conventional", "code": "CONV" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "PrimaryWinding", "type": "esriFieldTypeString", "alias": "Primary Winding", "length": 2, "domain": { "type": "codedValue", "name": "WS2_eTransformerPrimaryWinding", "description": "", "codedValues": [ { "name": "Straight Wound", "code": "SW" }, { "name": "Dual Voltage", "code": "DV" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "TapsType", "type": "esriFieldTypeString", "alias": "Taps Type", "length": 2, "domain": { "type": "codedValue", "name": "WS2_eTransformerUnitTapsType", "description": "", "codedValues": [ { "name": "2 Above/2 Below", "code": "22" }, { "name": "4 Above", "code": "4A" }, { "name": "None", "code": "NN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "FluidAmount", "type": "esriFieldTypeDouble", "alias": "Fluid Amount", "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "Serial Number", "length": 20, "domain": null }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 3, "domain": { "type": "codedValue", "name": "WS2_eTransformerUnitManufacturer", "description": "", "codedValues": [ { "name": "ABB/Westinghouse", "code": "ABB" }, { "name": "Central Maloney", "code": "CM" }, { "name": "Cooper/McGraw Edison", "code": "CPR" }, { "name": "Delta", "code": "D" }, { "name": "General Electric", "code": "GE" }, { "name": "H.K. Potter", "code": "HKP" }, { "name": "Howard", "code": "HOW" }, { "name": "RTE", "code": "RTE" }, { "name": "TSS", "code": "TSS" }, { "name": "Arkansa Electric", "code": "ARK" }, { "name": "Kuuhlman", "code": "KUU" }, { "name": "Other", "code": "OTH" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "length": 20, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 50, "domain": null }, { "name": "TransformerObjectID", "type": "esriFieldTypeInteger", "alias": "TransformerObjectID", "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "Inventory_ID", "type": "esriFieldTypeString", "alias": "Inventory ID", "length": 50, "domain": null } ], "indexes": [ { "name": "R289_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "types": [ { "domains": { "DateCreated": { "type": "range", "name": "WS2_DateRange", "description": "", "range": [ -2208988800000, 4102444800000 ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "DateModified": { "type": "range", "name": "WS2_DateRange", "description": "", "range": [ -2208988800000, 4102444800000 ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "PhaseDesignation": {"type": "inherited"}, "InstallationDate": {"type": "inherited"}, "RatedKVA": {"type": "inherited"}, "HighSideRatedVoltage": {"type": "inherited"}, "LowSideRatedVoltage": {"type": "inherited"}, "HighSideBIL": {"type": "inherited"}, "LowSideBIL": {"type": "inherited"}, "AnimalGuard": {"type": "inherited"}, "ArrestorType": {"type": "inherited"}, "CoolingType": {"type": "inherited"}, "ProtectionType": {"type": "inherited"}, "PrimaryWinding": {"type": "inherited"}, "TapsType": {"type": "inherited"}, "Manufacturer": {"type": "inherited"} }, "id": 1, "name": "Distribution Transformer Unit" } ], "subtypes": [ { "domains": { "DateCreated": { "type": "range", "name": "WS2_DateRange", "description": "", "range": [ -2208988800000, 4102444800000 ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "DateModified": { "type": "range", "name": "WS2_DateRange", "description": "", "range": [ -2208988800000, 4102444800000 ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "PhaseDesignation": {"type": "inherited"}, "InstallationDate": {"type": "inherited"}, "RatedKVA": {"type": "inherited"}, "HighSideRatedVoltage": {"type": "inherited"}, "LowSideRatedVoltage": {"type": "inherited"}, "HighSideBIL": {"type": "inherited"}, "LowSideBIL": {"type": "inherited"}, "AnimalGuard": {"type": "inherited"}, "ArrestorType": {"type": "inherited"}, "CoolingType": {"type": "inherited"}, "ProtectionType": {"type": "inherited"}, "PrimaryWinding": {"type": "inherited"}, "TapsType": {"type": "inherited"}, "Manufacturer": {"type": "inherited"} }, "defaultValues": { "CreationUser": null, "DateCreated": null, "DateModified": null, "LastUser": null, "Subtype": 1, "FeatureID": "1", "PhaseDesignation": null, "InstallationDate": null, "RatedKVA": 25, "HighSideRatedVoltage": 220, "LowSideRatedVoltage": null, "HighSideBIL": 125, "LowSideBIL": 125, "AnimalGuard": "N", "ArrestorType": "ELB", "CoolingType": "RAD", "FluidType": null, "FullLoadLosses": null, "NoLoadLosses": null, "Impedance": null, "ProtectionType": "CSP", "PrimaryWinding": "DV", "TapsType": "22", "FluidAmount": null, "SerialNumber": null, "Manufacturer": null, "Model": null, "Comments": null, "TransformerObjectID": null, "created_user": null, "created_date": null, "last_edited_user": null, "last_edited_date": null, "Inventory_ID": null }, "code": 1, "name": "Distribution Transformer Unit" } ], "relationships": [ { "id": 8, "name": "Transformer", "relatedTableId": 7, "role": "esriRelRoleDestination", "keyField": "TransformerObjectID", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "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 }