{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 25, "name": "PROCESS", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 143, "name": "WRD_CMMS_GIS_DEV.DBO.SUB_PROCESS", "relatedTableId": 26, "cardinality": "esriRelCardinalityManyToMany", "role": "esriRelRoleOrigin", "keyField": "PROCESSID", "composite": false, "catalogID": "{9551A685-F3F2-480E-AE80-582741405A7E}", "relationshipTableId": 30, "keyFieldInRelationshipTable": "PROCESSID" } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "System-maintained ObjectID" }, { "name": "PROCESSID", "type": "esriFieldTypeString", "alias": "ProcessID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PROCESSID" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "Name", "domain": { "type": "codedValue", "name": "DomProcess", "description": "Process", "codedValues": [ { "name": "BUILDING FACILITIES", "code": "BUILDING FACILITIES" }, { "name": "CHEMICAL FEED SYSTEMS", "code": "CHEMICAL FEED SYSTEMS" }, { "name": "DRAINAGE AND WASTE DISPOSAL", "code": "DRAINAGE AND WASTE DISPOSAL" }, { "name": "ELECTRICAL & CONTROL SYSTEM", "code": "ELECTRICAL & CONTROL SYSTEM" }, { "name": "INFLUENT_SOURCE WATER", "code": "INFLUENT_SOURCE WATER" }, { "name": "PRODUCT WATER SYSTEM", "code": "PRODUCT WATER SYSTEM" }, { "name": "REVERSE OSMOSIS SYSTEM", "code": "REVERSE OSMOSIS SYSTEM" }, { "name": "ULTRAFILTRATION_MICROFILTRATION SYSTEM", "code": "ULTRAFILTRATION_MICROFILTRATION SYSTEM" }, { "name": "UNASSIGNED", "code": "UNASSIGNED" }, { "name": "UV AND POST TREATMENT SYSTEM", "code": "UV AND POST TREATMENT SYSTEM" }, { "name": "WRD WELL", "code": "WRD WELL" }, { "name": "PRODUCTION WELLS", "code": "PRODUCTION WELLS" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "NAME" }, { "name": "SITEID", "type": "esriFieldTypeString", "alias": "SiteID", "domain": { "type": "codedValue", "name": "DomSiteID", "description": "SiteID", "codedValues": [ { "name": "GRIP", "code": "GRIP" }, { "name": "ADMN", "code": "ADMN" }, { "name": "ANNX", "code": "ANNX" }, { "name": "RWGD", "code": "RWGD" }, { "name": "LJVL", "code": "LJVL" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LOCATIONID" }, { "name": "LASTUPDATED", "type": "esriFieldTypeDate", "alias": "Last Updated", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LASTUPDATED" }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "LastEditor", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LASTEDITOR" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "indexes": [ { "name": "R51_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "I63SITEID", "fields": "SITEID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G63PROCESSID", "fields": "PROCESSID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_51", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_51", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "PROCESS", "description": "", "prototype": { "attributes": { "LASTEDITOR": null, "LASTUPDATED": null, "PROCESSID": null, "NAME": null, "SITEID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "8918931698a64729ae7646e260e20ae0" }