{ "currentVersion": 10.81, "id": 229, "name": "tp_Subprocess", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "SUBPROCESS_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SUBPROCESS_ID", "type": "esriFieldTypeString", "alias": "Subprocess ID", "length": 50, "domain": null }, { "name": "SUBPROCESS_NAME", "type": "esriFieldTypeString", "alias": "Subprocess Name", "length": 100, "domain": { "type": "codedValue", "name": "tp_Subprocess_Name", "description": "Subprocess Name", "codedValues": [ { "name": "Screening", "code": "SCREENING" }, { "name": "Pumping", "code": "PUMPING" }, { "name": "Grit Removal", "code": "GRITREMOVAL" }, { "name": "Scum Collection", "code": "SCUMCOLLECT" }, { "name": "Clarification", "code": "CLARIFICATION" }, { "name": "Air Supply", "code": "AIRSUPPLY" }, { "name": "Difffusion", "code": "DIFFUSION" }, { "name": "Return Activated Sludge", "code": "RETACTSLUDGE" }, { "name": "Waste Activated Sludge", "code": "WASTEACTSLUDGE" }, { "name": "Effluent", "code": "EFFLUENT" }, { "name": "Secondary Effluent", "code": "SECEFFLUENT" }, { "name": "Agricultural Water", "code": "AGWATER" }, { "name": "Storage", "code": "STORAGE" }, { "name": "Filtration", "code": "FILTRATION" }, { "name": "Disinfection", "code": "DISINFECTION" }, { "name": "Chlorination", "code": "CHLORINATION" }, { "name": "Neutralization", "code": "NEUTRALIZATION" }, { "name": "Primary Digestion", "code": "PRIMDIGESTION" }, { "name": "Secondary Digestion", "code": "SECDIGESTION" }, { "name": "Sludge Thickening", "code": "SLUDGETHICK" }, { "name": "Dewatering", "code": "DEWATER" }, { "name": "Piping", "code": "PIPING" }, { "name": "Coagulation", "code": "COAGULATION" }, { "name": "Flocculation", "code": "FLOCCULATION" }, { "name": "Feed", "code": "FEED" }, { "name": "Clean In Place (CIP)", "code": "CIP" }, { "name": "Backwash", "code": "BACKWASH" }, { "name": "Reverse Osmosis", "code": "REVOSMOSIS" }, { "name": "Odor Collection", "code": "ODORCOLLECT" }, { "name": "Nutrient Feed System", "code": "NUTFEEDSYS" }, { "name": "Air Scrubbing", "code": "AIRSCRUBBING" }, { "name": "Pressure Reduction", "code": "PRESSREDUCTION" }, { "name": "Security Access Control", "code": "SECACCESSCNTRL" }, { "name": "HVAC", "code": "HVAC" }, { "name": "Plumbing", "code": "PLUMBING" }, { "name": "Building Electrical", "code": "BLDGELECTRICAL" }, { "name": "Building Structural Maintenance", "code": "BLDGSTRUCTMAINT" }, { "name": "Generation", "code": "GENERATION" }, { "name": "Transfer", "code": "TRANSFER" }, { "name": "Distribution", "code": "DISTRIBUTION" }, { "name": "Grounding/Lightning Protection", "code": "GRNDLIGHTPROTECT" }, { "name": "Fire Suppression", "code": "FIRESUPPRESS" }, { "name": "Personal Protection", "code": "PERSONALPROTECT" }, { "name": "Fire Alarm", "code": "FIREALARM" }, { "name": "Recycle Water Chlorination", "code": "DECHLORINATION" }, { "name": "Brine", "code": "BRINE" }, { "name": "Sodium Hypochlorite", "code": "SODIUM_HYPOCHLORITE" }, { "name": "Ferric", "code": "FERRIC" }, { "name": "Coagulant", "code": "COAGULANT" }, { "name": "Polymer", "code": "POLYMER" }, { "name": "Supervisory Control and Data Acquisition", "code": "SCADA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "PROCESS_ID", "type": "esriFieldTypeString", "alias": "Process 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": "R706_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_706", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G2908PROCESS_ID", "fields": "PROCESS_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G2908SUBPROCESS_", "fields": "SUBPROCESS_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 74, "name": "tp_GroundingGrid", "relatedTableId": 13, "role": "esriRelRoleOrigin", "keyField": "SUBPROCESS_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 83, "name": "tp_Greenspace", "relatedTableId": 16, "role": "esriRelRoleOrigin", "keyField": "SUBPROCESS_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 72, "name": "tp_NetworkCabling", "relatedTableId": 11, "role": "esriRelRoleOrigin", "keyField": "SUBPROCESS_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 66, "name": "YardLighting", "relatedTableId": 9, "role": "esriRelRoleOrigin", "keyField": "SUBPROCESS_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 81, "name": "tp_Hardscape", "relatedTableId": 15, "role": "esriRelRoleOrigin", "keyField": "SUBPROCESS_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 73, "name": "tp_YardElectrical", "relatedTableId": 12, "role": "esriRelRoleOrigin", "keyField": "SUBPROCESS_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 71, "name": "tp_AccessGate", "relatedTableId": 10, "role": "esriRelRoleOrigin", "keyField": "SUBPROCESS_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 79, "name": "stp_Tank", "relatedTableId": 45, "role": "esriRelRoleOrigin", "keyField": "SUBPROCESS_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 65, "name": "stp_Generator", "relatedTableId": 43, "role": "esriRelRoleOrigin", "keyField": "SUBPROCESS_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 67, "name": "stp_PumpStation", "relatedTableId": 132, "role": "esriRelRoleOrigin", "keyField": "SUBPROCESS_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 68, "name": "stp_Well", "relatedTableId": 49, "role": "esriRelRoleOrigin", "keyField": "SUBPROCESS_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 84, "name": "stp_Basin", "relatedTableId": 47, "role": "esriRelRoleOrigin", "keyField": "SUBPROCESS_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 70, "name": "stp_YardPiping", "relatedTableId": 50, "role": "esriRelRoleOrigin", "keyField": "SUBPROCESS_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 69, "name": "stp_YardValve", "relatedTableId": 51, "role": "esriRelRoleOrigin", "keyField": "SUBPROCESS_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 63, "name": "tp_PointsOfInterest", "relatedTableId": 127, "role": "esriRelRoleOrigin", "keyField": "SUBPROCESS_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 86, "name": "tp_Process", "relatedTableId": 225, "role": "esriRelRoleDestination", "keyField": "PROCESS_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" }