{ "currentVersion": 10.91, "id": 119, "name": "Backflow History", "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": "last_name", "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": "assetkey" }, { "name": "workorderid", "type": "esriFieldTypeString", "alias": "Workorder Key", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "workorderid" }, { "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": "workby" }, { "name": "comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "comments" }, { "name": "worktype", "type": "esriFieldTypeString", "alias": "Work Type", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "worktype" }, { "name": "attachment01", "type": "esriFieldTypeInteger", "alias": "AttachmentID1", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "attachment01" }, { "name": "attachment02", "type": "esriFieldTypeInteger", "alias": "AttachmentID2", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "attachment02" }, { "name": "inspector", "type": "esriFieldTypeString", "alias": "inspector", "domain": { "type": "codedValue", "name": "sedaInspector", "description": "", "codedValues": [ { "name": "Alex Gan", "code": "Alex Gan" }, { "name": "Ty Kuban", "code": "Ty Kuban" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 254, "defaultValue": null, "modelName": "inspector" }, { "name": "addr_care_", "type": "esriFieldTypeString", "alias": "addr_care_", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "business" }, { "name": "last_name", "type": "esriFieldTypeString", "alias": "last_name", "domain": null, "editable": true, "nullable": true, "length": 254, "defaultValue": null, "modelName": "last_name" }, { "name": "first_name", "type": "esriFieldTypeString", "alias": "first_name", "domain": null, "editable": true, "nullable": true, "length": 254, "defaultValue": null, "modelName": "first_name" }, { "name": "bus_phone", "type": "esriFieldTypeString", "alias": "bus_phone", "domain": null, "editable": true, "nullable": true, "length": 254, "defaultValue": null, "modelName": "bus_phone" }, { "name": "home_phone", "type": "esriFieldTypeString", "alias": "home_phone", "domain": null, "editable": true, "nullable": true, "length": 254, "defaultValue": null, "modelName": "home_phone" }, { "name": "email", "type": "esriFieldTypeString", "alias": "email", "domain": null, "editable": true, "nullable": true, "length": 254, "defaultValue": null, "modelName": "email" }, { "name": "prop_type", "type": "esriFieldTypeString", "alias": "prop_type", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "prop_type" }, { "name": "meter_size", "type": "esriFieldTypeString", "alias": "meter_size", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "meter_size" }, { "name": "meter_sn", "type": "esriFieldTypeString", "alias": "meter_sn", "domain": null, "editable": true, "nullable": true, "length": 254, "defaultValue": null, "modelName": "meter_sn" }, { "name": "lodesc", "type": "esriFieldTypeString", "alias": "lodesc", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "lodesc" }, { "name": "fulladdres", "type": "esriFieldTypeString", "alias": "fulladdres", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "fulladdres" }, { "name": "containment_exist", "type": "esriFieldTypeString", "alias": "containment_exist", "domain": { "type": "codedValue", "name": "sedaYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "containment_exist" }, { "name": "branch_count", "type": "esriFieldTypeInteger", "alias": "branch_count", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "branch_count" }, { "name": "bf_type", "type": "esriFieldTypeString", "alias": "bf_type", "domain": { "type": "codedValue", "name": "sedaBackflowType", "description": "", "codedValues": [ { "name": "RPZ", "code": "RPZ" }, { "name": "DC", "code": "DC" }, { "name": "PVB", "code": "PVB" }, { "name": "SBV", "code": "SVB" }, { "name": "DCDA", "code": "DCDA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "bf_type" }, { "name": "bf_manufacturer", "type": "esriFieldTypeString", "alias": "bf_manufacturer", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "bf_manufacturer" }, { "name": "bf_model", "type": "esriFieldTypeString", "alias": "bf_model", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "bf_model" }, { "name": "bf_size", "type": "esriFieldTypeString", "alias": "bf_size", "domain": { "type": "codedValue", "name": "sedaBackflowSize", "description": "", "codedValues": [ { "name": "0.75", "code": "0.75" }, { "name": "1.5", "code": "1.5" }, { "name": "0.25", "code": "0.25" }, { "name": "0.378", "code": "0.378" }, { "name": "0.5", "code": "0.5" }, { "name": "1.0", "code": "1.0" }, { "name": "1.25", "code": "1.25" }, { "name": "2.0", "code": "2.0" }, { "name": "3.0", "code": "3.0" }, { "name": "3.25", "code": "3.25" }, { "name": "4.0", "code": "4.0" }, { "name": "5.0", "code": "5.0" }, { "name": "6.0", "code": "6.0" }, { "name": "8.0", "code": "8.0" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "bf_size" }, { "name": "bf_sn", "type": "esriFieldTypeString", "alias": "bf_sn", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "bf_sn" }, { "name": "test_date", "type": "esriFieldTypeDate", "alias": "test_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "test_date" }, { "name": "outlet_ori", "type": "esriFieldTypeString", "alias": "outlet_ori", "domain": { "type": "codedValue", "name": "sedaOrientation", "description": "", "codedValues": [ { "name": "Horizontal", "code": "Horizontal" }, { "name": "Up", "code": "Up" }, { "name": "Down", "code": "Down" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "outlet_ori" }, { "name": "inlet_ori", "type": "esriFieldTypeString", "alias": "inlet ori", "domain": { "type": "codedValue", "name": "sedaOrientation", "description": "", "codedValues": [ { "name": "Horizontal", "code": "Horizontal" }, { "name": "Up", "code": "Up" }, { "name": "Down", "code": "Down" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "inlet_ori" }, { "name": "branch_type", "type": "esriFieldTypeString", "alias": "branch_type", "domain": { "type": "codedValue", "name": "sedaBranchType", "description": "", "codedValues": [ { "name": "Assembly", "code": "Assembly" }, { "name": "Air Gap", "code": "Air Gap" }, { "name": "None", "code": "None" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "branch_type" }, { "name": "branch_water_use", "type": "esriFieldTypeString", "alias": "branch_water_use", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "branch_water_use" } ], "indexes": [ { "name": "R401_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "Backflow History", "description": "", "prototype": { "attributes": { "branch_type": null, "branch_water_use": null, "assetkey": null, "workorderid": null, "workdate": null, "workby": null, "comments": null, "worktype": null, "attachment01": null, "attachment02": null, "inspector": null, "addr_care_": null, "last_name": null, "first_name": null, "bus_phone": null, "home_phone": null, "email": null, "prop_type": null, "meter_size": null, "meter_sn": null, "lodesc": null, "fulladdres": null, "containment_exist": null, "branch_count": null, "bf_type": null, "bf_manufacturer": null, "bf_model": null, "bf_size": null, "bf_sn": null, "test_date": null, "outlet_ori": null, "inlet_ori": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }