{ "currentVersion": 10.71, "id": 104, "name": "sedaSewerPumpHistory", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "assetkey", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "assetkey", "type": "esriFieldTypeString", "alias": "Asset Key", "length": 20, "domain": null }, { "name": "workorderid", "type": "esriFieldTypeString", "alias": "Workorder Key", "length": 50, "domain": null }, { "name": "workdate", "type": "esriFieldTypeDate", "alias": "Work Date", "length": 8, "domain": null }, { "name": "workby", "type": "esriFieldTypeString", "alias": "Work By", "length": 50, "domain": null }, { "name": "worktype", "type": "esriFieldTypeString", "alias": "Work Type", "length": 50, "domain": null }, { "name": "attachmentid", "type": "esriFieldTypeInteger", "alias": "AttachmentID", "domain": null }, { "name": "breakersexercised", "type": "esriFieldTypeSmallInteger", "alias": "breakersexercised", "domain": { "type": "codedValue", "name": "sedaYesNoBoolean", "description": "", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "valvesexercised", "type": "esriFieldTypeSmallInteger", "alias": "valvesexercised", "domain": { "type": "codedValue", "name": "sedaYesNoBoolean", "description": "", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "gatevalvecondition", "type": "esriFieldTypeString", "alias": "gatevalvecondition", "length": 10, "domain": { "type": "codedValue", "name": "dmnCondition", "description": "Condition of the Asset", "codedValues": [ { "name": "New", "code": "NEW" }, { "name": "Good", "code": "GOOD" }, { "name": "Fair", "code": "FAIR" }, { "name": "Poor", "code": "POOR" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "checkvalvecondition", "type": "esriFieldTypeString", "alias": "checkvalvecondition", "length": 10, "domain": { "type": "codedValue", "name": "dmnCondition", "description": "Condition of the Asset", "codedValues": [ { "name": "New", "code": "NEW" }, { "name": "Good", "code": "GOOD" }, { "name": "Fair", "code": "FAIR" }, { "name": "Poor", "code": "POOR" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "leaksdeterioration", "type": "esriFieldTypeString", "alias": "leaksdeterioration", "length": 10, "domain": { "type": "codedValue", "name": "dmnQuantity", "description": "Quantity Description", "codedValues": [ { "name": "None", "code": "NONE" }, { "name": "Light", "code": "LGHT" }, { "name": "Medium", "code": "MED" }, { "name": "Heavy", "code": "HVY" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "motor1vl1l2", "type": "esriFieldTypeSmallInteger", "alias": "voltsl1l2", "domain": null }, { "name": "motor1vl2l3", "type": "esriFieldTypeSmallInteger", "alias": "voltsl2l3", "domain": null }, { "name": "motor1vl1l3", "type": "esriFieldTypeSmallInteger", "alias": "voltsl1l3", "domain": null }, { "name": "motor2vl1l2", "type": "esriFieldTypeSmallInteger", "alias": "motor2vl1l2", "domain": null }, { "name": "motor2vl2l3", "type": "esriFieldTypeSmallInteger", "alias": "motor2vl2l3", "domain": null }, { "name": "motor2vl1l3", "type": "esriFieldTypeSmallInteger", "alias": "motor2vl1l3", "domain": null }, { "name": "motor1ampsl1", "type": "esriFieldTypeSmallInteger", "alias": "motor1ampsl1", "domain": null }, { "name": "motor1ampsl2", "type": "esriFieldTypeSmallInteger", "alias": "motor1ampsl2", "domain": null }, { "name": "motor1ampsl3", "type": "esriFieldTypeSmallInteger", "alias": "motor1ampsl3", "domain": null }, { "name": "motor2ampsl1", "type": "esriFieldTypeSmallInteger", "alias": "motor2ampsl1", "domain": null }, { "name": "motor2ampsl2", "type": "esriFieldTypeSmallInteger", "alias": "motor2ampsl2", "domain": null }, { "name": "motor2ampsl3", "type": "esriFieldTypeSmallInteger", "alias": "motor2ampsl3", "domain": null }, { "name": "motor1megt1", "type": "esriFieldTypeDouble", "alias": "motor1megt1", "domain": null }, { "name": "motor1megt2", "type": "esriFieldTypeDouble", "alias": "motor1megt2", "domain": null }, { "name": "motor1megt3", "type": "esriFieldTypeDouble", "alias": "motor1megt3", "domain": null }, { "name": "motor2megt1", "type": "esriFieldTypeDouble", "alias": "motor2megt1", "domain": null }, { "name": "motor2megt2", "type": "esriFieldTypeDouble", "alias": "motor2megt2", "domain": null }, { "name": "motor2megt3", "type": "esriFieldTypeDouble", "alias": "motor2megt3", "domain": null }, { "name": "airvalvecleaned", "type": "esriFieldTypeSmallInteger", "alias": "airvalvecleaned", "domain": { "type": "codedValue", "name": "sedaYesNoBoolean", "description": "", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "vaultinspected", "type": "esriFieldTypeSmallInteger", "alias": "vaultinspected", "domain": { "type": "codedValue", "name": "sedaYesNoBoolean", "description": "", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "holddownbolts", "type": "esriFieldTypeSmallInteger", "alias": "holddownbolts", "domain": { "type": "codedValue", "name": "sedaYesNoBoolean", "description": "", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ejectorpotscleaned", "type": "esriFieldTypeSmallInteger", "alias": "ejectorpotscleaned", "domain": { "type": "codedValue", "name": "sedaYesNoBoolean", "description": "", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "electrodescleaned", "type": "esriFieldTypeSmallInteger", "alias": "electrodescleaned", "domain": { "type": "codedValue", "name": "sedaYesNoBoolean", "description": "", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "starter1insp", "type": "esriFieldTypeSmallInteger", "alias": "starter1insp", "domain": { "type": "codedValue", "name": "sedaYesNoBoolean", "description": "", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "starter2insp", "type": "esriFieldTypeSmallInteger", "alias": "starter2insp", "domain": { "type": "codedValue", "name": "sedaYesNoBoolean", "description": "", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "starter3insp", "type": "esriFieldTypeSmallInteger", "alias": "starter3insp", "domain": { "type": "codedValue", "name": "sedaYesNoBoolean", "description": "", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "rotofloattested", "type": "esriFieldTypeSmallInteger", "alias": "rotofloattested", "domain": { "type": "codedValue", "name": "sedaYesNoBoolean", "description": "", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "interiorcondition", "type": "esriFieldTypeString", "alias": "interiorcondtion", "length": 10, "domain": { "type": "codedValue", "name": "dmnCondition", "description": "Condition of the Asset", "codedValues": [ { "name": "New", "code": "NEW" }, { "name": "Good", "code": "GOOD" }, { "name": "Fair", "code": "FAIR" }, { "name": "Poor", "code": "POOR" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "exteriorcondition", "type": "esriFieldTypeString", "alias": "exteriorcondition", "length": 10, "domain": { "type": "codedValue", "name": "dmnCondition", "description": "Condition of the Asset", "codedValues": [ { "name": "New", "code": "NEW" }, { "name": "Good", "code": "GOOD" }, { "name": "Fair", "code": "FAIR" }, { "name": "Poor", "code": "POOR" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "flushwetwell", "type": "esriFieldTypeSmallInteger", "alias": "flushwetwell", "domain": { "type": "codedValue", "name": "sedaYesNoBoolean", "description": "", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "pumplinescleared", "type": "esriFieldTypeSmallInteger", "alias": "pumplinecleared", "domain": { "type": "codedValue", "name": "sedaYesNoBoolean", "description": "", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "pumpsalternate", "type": "esriFieldTypeSmallInteger", "alias": "pumpsalternate", "domain": { "type": "codedValue", "name": "sedaYesNoBoolean", "description": "", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "standbyoperate", "type": "esriFieldTypeSmallInteger", "alias": "standbyoperate", "domain": { "type": "codedValue", "name": "sedaYesNoBoolean", "description": "", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "sumpinspected", "type": "esriFieldTypeSmallInteger", "alias": "sumpinspected", "domain": { "type": "codedValue", "name": "sedaYesNoBoolean", "description": "", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "sumpholecleaned", "type": "esriFieldTypeSmallInteger", "alias": "sumpholecleaned", "domain": { "type": "codedValue", "name": "sedaYesNoBoolean", "description": "", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "generatorinspected", "type": "esriFieldTypeSmallInteger", "alias": "generatorinspected", "domain": { "type": "codedValue", "name": "sedaYesNoBoolean", "description": "", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "pump1hours", "type": "esriFieldTypeInteger", "alias": "pump1hours", "domain": null }, { "name": "pump2hours", "type": "esriFieldTypeInteger", "alias": "pump2hours", "domain": null }, { "name": "pump3hours", "type": "esriFieldTypeInteger", "alias": "pump3hours", "domain": null }, { "name": "pump4hours", "type": "esriFieldTypeInteger", "alias": "pump4hours", "domain": null }, { "name": "comments", "type": "esriFieldTypeString", "alias": "comments", "length": 1000, "domain": null }, { "name": "wocomments", "type": "esriFieldTypeString", "alias": "wocomments", "length": 1073741822, "domain": null }, { "name": "wodescription", "type": "esriFieldTypeString", "alias": "wodescription", "length": 255, "domain": null } ], "indexes": [ { "name": "R125_SDE_ROWID_UK", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 3000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": false, "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 }