{ "currentVersion": 10.81, "id": 225, "name": "tp_Process", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "PROCESS_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PROCESS_ID", "type": "esriFieldTypeString", "alias": "Process ID", "length": 50, "domain": null }, { "name": "PROCESS_NAME", "type": "esriFieldTypeString", "alias": "Process Name", "length": 100, "domain": { "type": "codedValue", "name": "tp_Process_Name", "description": "Process Name", "codedValues": [ { "name": "Preliminary Treatment", "code": "PRETREAT" }, { "name": "Primary Treatment", "code": "PRIMTREAT" }, { "name": "Secondary Treatment", "code": "SECTREAT" }, { "name": "Tertiary Treatment", "code": "TERTREAT" }, { "name": "Reclaimed Water Storage and Pumping", "code": "RCWSTOREPUMP" }, { "name": "Solids Handling", "code": "SOLIDSHANDLING" }, { "name": "Raw Water Supply", "code": "RAWSUPPLY" }, { "name": "Chemical", "code": "CHEMICAL" }, { "name": "Microfiltration", "code": "MICROFILTRATION" }, { "name": "Reverse Osmosis", "code": "REVERSEOSMOSIS" }, { "name": "Odor Control", "code": "ODORCNTRL" }, { "name": "Stormwater Bypass", "code": "SWBYPASS" }, { "name": "Facility Support", "code": "FACILITYSUPPORT" }, { "name": "Electrical", "code": "ELECTRICAL" }, { "name": "Life Safety", "code": "LIFESAFETY" }, { "name": "Recycled Water", "code": "RECYCLEWATER" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SITE_ID", "type": "esriFieldTypeString", "alias": "Site ID (Relate)", "length": 50, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "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 }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "LASTEDITOR", "length": 50, "domain": null }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "LASTUPDATE", "length": 8, "domain": null }, { "name": "ASSETSTATUS", "type": "esriFieldTypeString", "alias": "ASSETSTATUS", "length": 1, "domain": { "type": "codedValue", "name": "AssetStatus", "description": "Current, Retired or Abandoned - Instead of deleting assets they are retired (replaced wholly or partly by new features) or abandoned (blocked and left in ground).", "codedValues": [ { "name": "Current", "code": "C" }, { "name": "Retired", "code": "R" }, { "name": "Abandoned", "code": "A" }, { "name": "Geometric Network Only", "code": "G" }, { "name": "Proposed", "code": "P" }, { "name": "Needs Review", "code": "N" }, { "name": "to Delete", "code": "D" }, { "name": "Transposed", "code": "T" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R705_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_705", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G2907PROCESS_ID", "fields": "PROCESS_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G2907SITE_ID", "fields": "SITE_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 86, "name": "tp_Subprocess", "relatedTableId": 229, "role": "esriRelRoleOrigin", "keyField": "PROCESS_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 85, "name": "tp_Sites", "relatedTableId": 18, "role": "esriRelRoleDestination", "keyField": "SITE_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "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, "serviceItemId": "551ed99598bc4645bc48894460c82fc3" }