{ "currentVersion": 10.71, "id": 104, "name": "sedaSewerPumpHistory", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "objectid", "globalIdField": "", "displayField": "assetkey", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "assetkey", "type": "esriFieldTypeString", "alias": "Asset Key", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "AssetID" }, { "name": "workorderid", "type": "esriFieldTypeString", "alias": "Workorder Key", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "WorkActivity" }, { "name": "workdate", "type": "esriFieldTypeDate", "alias": "Work Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WorkDate" }, { "name": "workby", "type": "esriFieldTypeString", "alias": "Work By", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "WorkPerformedBy" }, { "name": "worktype", "type": "esriFieldTypeString", "alias": "Work Type", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MuvType" }, { "name": "attachmentid", "type": "esriFieldTypeInteger", "alias": "AttachmentID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AttachmentID" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "breakersexercised" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "valvesexercised" }, { "name": "gatevalvecondition", "type": "esriFieldTypeString", "alias": "gatevalvecondition", "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" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "gatevalvecondition" }, { "name": "checkvalvecondition", "type": "esriFieldTypeString", "alias": "checkvalvecondition", "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" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "checkvalvecondition" }, { "name": "leaksdeterioration", "type": "esriFieldTypeString", "alias": "leaksdeterioration", "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" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "leaksdeterioration" }, { "name": "motor1vl1l2", "type": "esriFieldTypeSmallInteger", "alias": "voltsl1l2", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "motor1vl1l2" }, { "name": "motor1vl2l3", "type": "esriFieldTypeSmallInteger", "alias": "voltsl2l3", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "motor1vl2l3" }, { "name": "motor1vl1l3", "type": "esriFieldTypeSmallInteger", "alias": "voltsl1l3", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "motor1vl1l3" }, { "name": "motor2vl1l2", "type": "esriFieldTypeSmallInteger", "alias": "motor2vl1l2", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "motor2vl1l2" }, { "name": "motor2vl2l3", "type": "esriFieldTypeSmallInteger", "alias": "motor2vl2l3", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "motor2vl2l3" }, { "name": "motor2vl1l3", "type": "esriFieldTypeSmallInteger", "alias": "motor2vl1l3", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "motor2vl1l3" }, { "name": "motor1ampsl1", "type": "esriFieldTypeSmallInteger", "alias": "motor1ampsl1", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "motor1ampsl1" }, { "name": "motor1ampsl2", "type": "esriFieldTypeSmallInteger", "alias": "motor1ampsl2", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "motor1ampsl2" }, { "name": "motor1ampsl3", "type": "esriFieldTypeSmallInteger", "alias": "motor1ampsl3", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "motor1ampsl3" }, { "name": "motor2ampsl1", "type": "esriFieldTypeSmallInteger", "alias": "motor2ampsl1", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "motor2ampsl1" }, { "name": "motor2ampsl2", "type": "esriFieldTypeSmallInteger", "alias": "motor2ampsl2", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "motor2ampsl2" }, { "name": "motor2ampsl3", "type": "esriFieldTypeSmallInteger", "alias": "motor2ampsl3", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "motor2ampsl3" }, { "name": "motor1megt1", "type": "esriFieldTypeDouble", "alias": "motor1megt1", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "motor1megt1" }, { "name": "motor1megt2", "type": "esriFieldTypeDouble", "alias": "motor1megt2", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "motor1megt2" }, { "name": "motor1megt3", "type": "esriFieldTypeDouble", "alias": "motor1megt3", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "motor1megt3" }, { "name": "motor2megt1", "type": "esriFieldTypeDouble", "alias": "motor2megt1", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "motor2megt1" }, { "name": "motor2megt2", "type": "esriFieldTypeDouble", "alias": "motor2megt2", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "motor2megt2" }, { "name": "motor2megt3", "type": "esriFieldTypeDouble", "alias": "motor2megt3", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "motor2megt3" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "airvalvecleaned" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "vaultinspected" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "holddownbolts" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ejectorpotscleaned" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "electrodescleaned" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "starter1insp" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "starter2insp" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "starter3insp" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "rotofloattested" }, { "name": "interiorcondition", "type": "esriFieldTypeString", "alias": "interiorcondtion", "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" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "interiorcondition" }, { "name": "exteriorcondition", "type": "esriFieldTypeString", "alias": "exteriorcondition", "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" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "exteriorcondition" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "flushwetwell" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "pumplinescleared" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "pumpsalternate" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "standbyoperate" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "sumpinspected" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "sumpholecleaned" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "generatorinspected" }, { "name": "pump1hours", "type": "esriFieldTypeInteger", "alias": "pump1hours", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "pump1hours" }, { "name": "pump2hours", "type": "esriFieldTypeInteger", "alias": "pump2hours", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "pump2hours" }, { "name": "pump3hours", "type": "esriFieldTypeInteger", "alias": "pump3hours", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "pump3hours" }, { "name": "pump4hours", "type": "esriFieldTypeInteger", "alias": "pump4hours", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "pump4hours" }, { "name": "comments", "type": "esriFieldTypeString", "alias": "comments", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "comments" }, { "name": "wocomments", "type": "esriFieldTypeString", "alias": "wocomments", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "wocomments" }, { "name": "wodescription", "type": "esriFieldTypeString", "alias": "wodescription", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "wodescription" } ], "indexes": [ { "name": "R125_SDE_ROWID_UK", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "sedaSewerPumpHistory", "description": "", "prototype": { "attributes": { "wocomments": null, "wodescription": null, "assetkey": null, "workorderid": null, "workdate": null, "workby": null, "worktype": null, "attachmentid": null, "breakersexercised": null, "valvesexercised": null, "gatevalvecondition": null, "checkvalvecondition": null, "leaksdeterioration": null, "motor1vl1l2": null, "motor1vl2l3": null, "motor1vl1l3": null, "motor2vl1l2": null, "motor2vl2l3": null, "motor2vl1l3": null, "motor1ampsl1": null, "motor1ampsl2": null, "motor1ampsl3": null, "motor2ampsl1": null, "motor2ampsl2": null, "motor2ampsl3": null, "motor1megt1": null, "motor1megt2": null, "motor1megt3": null, "motor2megt1": null, "motor2megt2": null, "motor2megt3": null, "airvalvecleaned": null, "vaultinspected": null, "holddownbolts": null, "ejectorpotscleaned": null, "electrodescleaned": null, "starter1insp": null, "starter2insp": null, "starter3insp": null, "rotofloattested": null, "interiorcondition": null, "exteriorcondition": null, "flushwetwell": null, "pumplinescleared": null, "pumpsalternate": null, "standbyoperate": null, "sumpinspected": null, "sumpholecleaned": null, "generatorinspected": null, "pump1hours": null, "pump2hours": null, "pump3hours": null, "pump4hours": null, "comments": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 3000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 3000, "tileMaxRecordCount": 3000, "maxRecordCountFactor": 1 }