{
"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"
}