{ "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 23, "name": "sde_wastewater.ARCFM.WWVALVEVAULTEQUIPMENT", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "CREATIONUSER", "typeIdField": "SUBTYPECD", "subtypeFieldName": "SUBTYPECD", "subtypeField": "SUBTYPECD", "defaultSubtypeCode": 1, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CREATIONUSER", "type": "esriFieldTypeString", "alias": "Created By", "length": 20, "domain": null }, { "name": "DATECREATED", "type": "esriFieldTypeDate", "alias": "DATECREATED", "length": 8, "domain": null }, { "name": "DATEMODIFIED", "type": "esriFieldTypeDate", "alias": "DATEMODIFIED", "length": 8, "domain": null }, { "name": "LASTUSER", "type": "esriFieldTypeString", "alias": "Last User", "length": 20, "domain": null }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "INSTALLDATE", "length": 8, "domain": null }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "Manufacturer ", "length": 5, "domain": { "type": "codedValue", "name": "Cover Manufacturer", "description": "", "codedValues": [ { "name": "John Smith", "code": "JS" }, { "name": "McManus", "code": "MC" }, { "name": "John Foundry", "code": "JF" }, { "name": "Unknown", "code": "UNK" }, { "name": "Other", "code": "OTH" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "Model ", "length": 20, "domain": null }, { "name": "SERIALNUMBER", "type": "esriFieldTypeString", "alias": "Serial Number", "length": 20, "domain": null }, { "name": "LIFECYCLESTATUS", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "length": 5, "domain": { "type": "codedValue", "name": "Lifecycle Status", "description": "", "codedValues": [ { "name": "Proposed", "code": "PROP" }, { "name": "Active", "code": "ACT" }, { "name": "Abandoned", "code": "ABN" }, { "name": "Removed", "code": "REM" }, { "name": "Inactive", "code": "INACT" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SUBTYPECD", "type": "esriFieldTypeInteger", "alias": "Subtype CD", "domain": null }, { "name": "NETWORKSTRUCTUREOBJECTID", "type": "esriFieldTypeInteger", "alias": "Network Structure ObjectID", "domain": null }, { "name": "NUMBERDISCHARGEPIPES", "type": "esriFieldTypeInteger", "alias": "NUMBERDISCHARGEPIPES", "domain": null }, { "name": "PIPESIZE", "type": "esriFieldTypeInteger", "alias": "PIPESIZE", "domain": { "type": "codedValue", "name": "Gravity Main Diameter", "description": "", "codedValues": [ { "name": "Unknown", "code": 0 }, { "name": "Other", "code": -1 }, { "name": "4", "code": 4 }, { "name": "6", "code": 6 }, { "name": "8", "code": 8 }, { "name": "10", "code": 10 }, { "name": "12", "code": 12 }, { "name": "14", "code": 14 }, { "name": "16", "code": 16 }, { "name": "18", "code": 18 }, { "name": "20", "code": 20 }, { "name": "24", "code": 24 }, { "name": "15", "code": 15 }, { "name": "21", "code": 21 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "EMERGENCYCAMLOCKSIZE", "type": "esriFieldTypeInteger", "alias": "EMERGENCYCAMLOCKSIZE", "domain": { "type": "codedValue", "name": "CamLockSize", "description": "", "codedValues": [ { "name": "3\"", "code": 3 }, { "name": "4\"", "code": 4 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CONTROLVALVETYPE", "type": "esriFieldTypeString", "alias": "CONTROLVALVETYPE", "length": 50, "domain": { "type": "codedValue", "name": "ControlValveType", "description": "", "codedValues": [ { "name": "Gate", "code": "GATE" }, { "name": "Plug", "code": "PLUG" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "PRESSUREGAUGE", "type": "esriFieldTypeString", "alias": "PRESSUREGAUGE", "length": 50, "domain": { "type": "codedValue", "name": "Yes No Indicator", "description": "", "codedValues": [ { "name": "No", "code": "N" }, { "name": "Yes", "code": "Y" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "wwLiftStation_GlobalID", "type": "esriFieldTypeGUID", "alias": "wwLiftStation_GlobalID", "length": 38, "domain": null }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "Comments", "length": 100, "domain": null } ], "indexes": [ { "name": "R97_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G49NETWORKSTRUCT", "fields": "NETWORKSTRUCTUREOBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_97", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_97", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G49wwLiftStation", "fields": "wwLiftStation_GlobalID", "isAscending": true, "isUnique": false, "description": "" } ], "types": [ { "domains": { "MANUFACTURER": {"type": "inherited"}, "LIFECYCLESTATUS": {"type": "inherited"}, "PIPESIZE": {"type": "inherited"}, "EMERGENCYCAMLOCKSIZE": {"type": "inherited"}, "CONTROLVALVETYPE": {"type": "inherited"}, "PRESSUREGAUGE": {"type": "inherited"} }, "id": 1, "name": "Valve Vault Equipment" } ], "subtypes": [ { "domains": { "MANUFACTURER": {"type": "inherited"}, "LIFECYCLESTATUS": {"type": "inherited"}, "PIPESIZE": {"type": "inherited"}, "EMERGENCYCAMLOCKSIZE": {"type": "inherited"}, "CONTROLVALVETYPE": {"type": "inherited"}, "PRESSUREGAUGE": {"type": "inherited"} }, "defaultValues": { "CREATIONUSER": null, "DATECREATED": null, "DATEMODIFIED": null, "LASTUSER": null, "INSTALLDATE": null, "MANUFACTURER": null, "MODEL": null, "SERIALNUMBER": null, "LIFECYCLESTATUS": "ACT", "SUBTYPECD": 1, "NETWORKSTRUCTUREOBJECTID": null, "NUMBERDISCHARGEPIPES": null, "PIPESIZE": null, "EMERGENCYCAMLOCKSIZE": null, "CONTROLVALVETYPE": null, "PRESSUREGAUGE": null, "GlobalID": null, "wwLiftStation_GlobalID": null, "COMMENTS": null }, "code": 1, "name": "Valve Vault Equipment" } ], "relationships": [ { "id": 3, "name": "wwLiftStation", "relatedTableId": 7, "role": "esriRelRoleDestination", "keyField": "wwLiftStation_GlobalID", "cardinality": "esriRelCardinalityOneToOne", "composite": true } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }