{ "currentVersion": 10.61, "id": 48, "name": "LeakRepair", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "RepairedDate", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "RelatedGuid", "type": "esriFieldTypeGUID", "alias": "RelatedGuid", "length": 38, "domain": null }, { "name": "LeakCause", "type": "esriFieldTypeString", "alias": "Leak Cause", "length": 30, "domain": { "type": "codedValue", "name": "LeakCause", "description": "Leak Cause", "codedValues": [ { "name": "Corrosion", "code": "CORR" }, { "name": "Natural Forces", "code": "NATFOR" }, { "name": "Excavation", "code": "EX" }, { "name": "Other Outside Force", "code": "OTHOUTFOR" }, { "name": "Material Or Welds", "code": "MATORWELD" }, { "name": "Equipment", "code": "EQUIP" }, { "name": "Operations", "code": "OPER" }, { "name": "Other", "code": "OTH" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "WorkOrderNumber", "type": "esriFieldTypeString", "alias": "Work Order Number", "length": 25, "domain": null }, { "name": "Component", "type": "esriFieldTypeString", "alias": "Component", "length": 30, "domain": { "type": "codedValue", "name": "Leak Component", "description": "", "codedValues": [ { "name": "Pipe", "code": "Pipe" }, { "name": "Valve", "code": "Valve" }, { "name": "Fitting", "code": "Fitting" }, { "name": "Drip", "code": "Drip" }, { "name": "Regulator", "code": "Regulator" }, { "name": "Tap Connection", "code": "Tap" }, { "name": "Other", "code": "OTH" }, { "name": "Unknown", "code": "UNK" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ConditionOfPipe", "type": "esriFieldTypeString", "alias": "Condition Of Adjoining Pipe", "length": 30, "domain": { "type": "codedValue", "name": "Condition", "description": "", "codedValues": [ { "name": "Needs to be Replaced", "code": "NR" }, { "name": "Not Applicable", "code": "NA" }, { "name": "Okay", "code": "OK" }, { "name": "Other", "code": "OTH" }, { "name": "Unknown", "code": "UNK" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PartOfSystem", "type": "esriFieldTypeString", "alias": "Part Of System", "length": 30, "domain": { "type": "codedValue", "name": "Leak Source", "description": "", "codedValues": [ { "name": "Main", "code": "MAIN" }, { "name": "Service", "code": "SERV" }, { "name": "Service Tap", "code": "SERVTAP" }, { "name": "Valve", "code": "VALVE" }, { "name": "Meter", "code": "METSET" }, { "name": "Regulator", "code": "REG" }, { "name": "Fitting", "code": "FITTING" }, { "name": "Other", "code": "OTH" }, { "name": "Unknown", "code": "UNK" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PipeSize", "type": "esriFieldTypeString", "alias": "Pipe Size", "length": 30, "domain": { "type": "codedValue", "name": "PipeSizeTxt", "description": "Pipe Sizes in Text", "codedValues": [ { "name": "5/8\"", "code": ".62" }, { "name": "3/4\"", "code": ".75" }, { "name": "1\"", "code": "1" }, { "name": "1-1/4\"", "code": "1.25" }, { "name": "1-1/2\"", "code": "1.5" }, { "name": "1-3/4\"", "code": "1.75" }, { "name": "2\"", "code": "2" }, { "name": "2-1/2\"", "code": "2.5" }, { "name": "3\"", "code": "3" }, { "name": "4\"", "code": "4" }, { "name": "6\"", "code": "6" }, { "name": "8\"", "code": "8" }, { "name": "10\"", "code": "10" }, { "name": "1/2\"", "code": "0.5" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PipeMaterial", "type": "esriFieldTypeString", "alias": "Pipe Material", "length": 30, "domain": { "type": "codedValue", "name": "LEAK PIPE MATERIAL", "description": "LEAK PIPE MATERIAL", "codedValues": [ { "name": "BARE STEEL", "code": "BARE STEEL" }, { "name": "COATED STEEL", "code": "COATED STEEL" }, { "name": "DUCTILE IRON", "code": "DUCTILE IRON" }, { "name": "OTHER", "code": "OTH" }, { "name": "UNKNOWN", "code": "UNK" }, { "name": "POLYETHYLENE", "code": "PLASTIC" }, { "name": "PE INSERTED", "code": "PLASTIC INSERTED" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "NumberLeaks", "type": "esriFieldTypeInteger", "alias": "Number of Leaks", "domain": null }, { "name": "RepairsMade", "type": "esriFieldTypeString", "alias": "Repairs Made", "length": 255, "domain": null }, { "name": "RepairedBy", "type": "esriFieldTypeString", "alias": "Repaired By", "length": 50, "domain": null }, { "name": "RepairedDate", "type": "esriFieldTypeDate", "alias": "Repaired Date", "length": 8, "domain": null }, { "name": "GasOff", "type": "esriFieldTypeString", "alias": "Gas Off", "length": 10, "domain": { "type": "codedValue", "name": "YES/NO", "description": "YES OR NO VALUES", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 255, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "Leak Number", "length": 38, "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "AtmoCorrosion", "type": "esriFieldTypeString", "alias": "Atmospheric Corrosion", "length": 50, "domain": { "type": "codedValue", "name": "Yes/No Indicator", "description": "", "codedValues": [ { "name": "Other", "code": "OTH" }, { "name": "Unknown", "code": "UNK" }, { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" }, { "name": "Yes", "code": "Yes" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "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 } ], "indexes": [ { "name": "R45_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_45", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G150RelatedGuid", "fields": "RelatedGuid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_45", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "Leak", "relatedTableId": 4, "role": "esriRelRoleDestination", "keyField": "RelatedGuid", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, AMF", "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 }