{ "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 26, "name": "Substation Maintenance", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Maint_Type", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Maint_Type", "type": "esriFieldTypeString", "alias": "Maintenance Type", "length": 255, "domain": { "type": "codedValue", "name": "MaintType_Substation", "description": "MaintType-Substation", "codedValues": [ { "name": "Clock", "code": "Clock" }, { "name": "Photo Eye", "code": "PhotoEye" }, { "name": "Transformer", "code": "Transformer" }, { "name": "Open Circuit Protector", "code": "OpenCircuitProtector" }, { "name": "Oil Switch", "code": "OilSwitch" }, { "name": "Conductor", "code": "Conductor" }, { "name": "Control Wiring", "code": "ControlWiring" }, { "name": "Circuit Wiring", "code": "CircuitWiring" }, { "name": "General Maintenance", "code": "MiscRepair" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DateRequested", "type": "esriFieldTypeDate", "alias": "Date Requested", "length": 8, "domain": null }, { "name": "DatePerformed", "type": "esriFieldTypeDate", "alias": "Date Performed", "length": 8, "domain": null }, { "name": "Comment", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset ID", "length": 255, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "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": "Circuit_ID", "type": "esriFieldTypeString", "alias": "Circuit_ID", "length": 255, "domain": { "type": "codedValue", "name": "LP_Circuit", "description": "LP_Circuit", "codedValues": [ { "name": "A3", "code": "A3" }, { "name": "AA", "code": "AA" }, { "name": "AB", "code": "AB" }, { "name": "AC", "code": "AC" }, { "name": "AD", "code": "AD" }, { "name": "AT", "code": "AT" }, { "name": "B1", "code": "B1" }, { "name": "B4", "code": "B4" }, { "name": "B5", "code": "B5" }, { "name": "BA", "code": "BA" }, { "name": "BB", "code": "BB" }, { "name": "BC", "code": "BC" }, { "name": "BD", "code": "BD" }, { "name": "BE", "code": "BE" }, { "name": "BPK", "code": "BPK" }, { "name": "BT", "code": "BT" }, { "name": "C1", "code": "C1" }, { "name": "C2", "code": "C2" }, { "name": "C3", "code": "C3" }, { "name": "CA", "code": "CA" }, { "name": "CB", "code": "CB" }, { "name": "CT", "code": "CT" }, { "name": "D1", "code": "D1" }, { "name": "D4", "code": "D4" }, { "name": "D5", "code": "D5" }, { "name": "D6", "code": "D6" }, { "name": "DA", "code": "DA" }, { "name": "DB", "code": "DB" }, { "name": "DC", "code": "DC" }, { "name": "DT", "code": "DT" }, { "name": "E1", "code": "E1" }, { "name": "E2", "code": "E2" }, { "name": "E3", "code": "E3" }, { "name": "EA", "code": "EA" }, { "name": "EB", "code": "EB" }, { "name": "EC", "code": "EC" }, { "name": "ED", "code": "ED" }, { "name": "EE", "code": "EE" }, { "name": "EM1", "code": "EM1" }, { "name": "EM2", "code": "EM2" }, { "name": "EM3", "code": "EM3" }, { "name": "EM4", "code": "EM4" }, { "name": "EM5", "code": "EM5" }, { "name": "ET", "code": "ET" }, { "name": "F3", "code": "F3" }, { "name": "F5", "code": "F5" }, { "name": "FA", "code": "FA" }, { "name": "FB", "code": "FB" }, { "name": "FC", "code": "FC" }, { "name": "FD", "code": "FD" }, { "name": "FE", "code": "FE" }, { "name": "FF", "code": "FF" }, { "name": "FG", "code": "FG" }, { "name": "FH", "code": "FH" }, { "name": "FM1", "code": "FM1" }, { "name": "FM2", "code": "FM2" }, { "name": "FM3", "code": "FM3" }, { "name": "FM4", "code": "FM4" }, { "name": "FM5", "code": "FM5" }, { "name": "FM6", "code": "FM6" }, { "name": "FM7", "code": "FM7" }, { "name": "FT", "code": "FT" }, { "name": "G1", "code": "G1" }, { "name": "G2", "code": "G2" }, { "name": "G3", "code": "G3" }, { "name": "G4", "code": "G4" }, { "name": "G5", "code": "G5" }, { "name": "GA", "code": "GA" }, { "name": "GT", "code": "GT" }, { "name": "H2", "code": "H2" }, { "name": "H3", "code": "H3" }, { "name": "H4", "code": "H4" }, { "name": "HA", "code": "HA" }, { "name": "J1", "code": "J1" }, { "name": "J2", "code": "J2" }, { "name": "K1", "code": "K1" }, { "name": "K2", "code": "K2" }, { "name": "K3", "code": "K3" }, { "name": "K4", "code": "K4" }, { "name": "K5", "code": "K5" }, { "name": "KA", "code": "KA" }, { "name": "KB", "code": "KB" }, { "name": "KT", "code": "KT" }, { "name": "L3", "code": "L3" }, { "name": "L4", "code": "L4" }, { "name": "L5", "code": "L5" }, { "name": "LA", "code": "LA" }, { "name": "LB", "code": "LB" }, { "name": "LC", "code": "LC" }, { "name": "LT", "code": "LT" }, { "name": "M1", "code": "M1" }, { "name": "M2", "code": "M2" }, { "name": "M3", "code": "M3" }, { "name": "M4", "code": "M4" }, { "name": "MA", "code": "MA" }, { "name": "MB", "code": "MB" }, { "name": "MC", "code": "MC" }, { "name": "N1", "code": "N1" }, { "name": "N3", "code": "N3" }, { "name": "N4", "code": "N4" }, { "name": "N5", "code": "N5" }, { "name": "NA", "code": "NA" }, { "name": "NB", "code": "NB" }, { "name": "NC", "code": "NC" }, { "name": "ND", "code": "ND" }, { "name": "O1", "code": "O1" }, { "name": "O2", "code": "O2" }, { "name": "O3", "code": "O3" }, { "name": "OA", "code": "OA" }, { "name": "OB", "code": "OB" }, { "name": "OT", "code": "OT" }, { "name": "P1", "code": "P1" }, { "name": "P2", "code": "P2" }, { "name": "P3", "code": "P3" }, { "name": "P4", "code": "P4" }, { "name": "PA", "code": "PA" }, { "name": "PT", "code": "PT" }, { "name": "Q2", "code": "Q2" }, { "name": "Q3", "code": "Q3" }, { "name": "QA", "code": "QA" }, { "name": "QB", "code": "QB" }, { "name": "R1", "code": "R1" }, { "name": "R2", "code": "R2" }, { "name": "R3", "code": "R3" }, { "name": "R4", "code": "R4" }, { "name": "S1", "code": "S1" }, { "name": "S2", "code": "S2" }, { "name": "T1", "code": "T1" }, { "name": "T2", "code": "T2" }, { "name": "T3", "code": "T3" }, { "name": "TT", "code": "TT" }, { "name": "U1", "code": "U1" }, { "name": "U2", "code": "U2" }, { "name": "U3", "code": "U3" }, { "name": "U4", "code": "U4" }, { "name": "U5", "code": "U5" }, { "name": "UA", "code": "UA" }, { "name": "UB", "code": "UB" }, { "name": "UC", "code": "UC" }, { "name": "UT", "code": "UT" }, { "name": "V1", "code": "V1" }, { "name": "V3", "code": "V3" }, { "name": "V4", "code": "V4" }, { "name": "VA", "code": "VA" }, { "name": "VB", "code": "VB" }, { "name": "VF", "code": "VF" }, { "name": "VS", "code": "VS" }, { "name": "VT", "code": "VT" }, { "name": "W1", "code": "W1" }, { "name": "W3", "code": "W3" }, { "name": "W4", "code": "W4" }, { "name": "W5", "code": "W5" }, { "name": "WA", "code": "WA" }, { "name": "WB", "code": "WB" }, { "name": "WC", "code": "WC" }, { "name": "X1", "code": "X1" }, { "name": "X2", "code": "X2" }, { "name": "X4", "code": "X4" }, { "name": "XA", "code": "XA" }, { "name": "XB", "code": "XB" }, { "name": "ZA", "code": "ZA" }, { "name": "ZB", "code": "ZB" }, { "name": "ZC", "code": "ZC" }, { "name": "ZD", "code": "ZD" }, { "name": "ZE", "code": "ZE" }, { "name": "ZF", "code": "ZF" }, { "name": "FJ", "code": "FJ" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R457_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_13075_Asset_", "fields": "Asset_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_457", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_457", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "GIS_CityUtilities.DBO.substation", "relatedTableId": 12, "role": "esriRelRoleDestination", "keyField": "Asset_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "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 }, "dateFieldsTimeReference": null, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "cbff6da2d8db4a0f8711770062569b21" }