{ "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 22, "name": "sde_wastewater.ARCFM.WWVALVEVAULT", "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": "LOCATION", "type": "esriFieldTypeString", "alias": "Location ", "length": 255, "domain": null }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "WARRANTYDATE", "length": 8, "domain": null }, { "name": "CONDITION", "type": "esriFieldTypeString", "alias": "CONDITION", "length": 20, "domain": null }, { "name": "CONDITIONDATE", "type": "esriFieldTypeDate", "alias": "CONDITIONDATE", "length": 8, "domain": null }, { "name": "SUBTYPECD", "type": "esriFieldTypeInteger", "alias": "Subtype CD", "domain": null }, { "name": "ELEVATION", "type": "esriFieldTypeDouble", "alias": "Elevation ", "domain": null }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "INSTALLDATE", "length": 8, "domain": null }, { "name": "WORKORDERID", "type": "esriFieldTypeString", "alias": "Work Order ID", "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": "LOCATIONDESCRIPTION", "type": "esriFieldTypeString", "alias": "Location Description", "length": 255, "domain": null }, { "name": "COVERMATERIAL", "type": "esriFieldTypeString", "alias": "Cover Material", "length": 5, "domain": { "type": "codedValue", "name": "Valve Vault Cover Material", "description": "", "codedValues": [ { "name": "Aluminum", "code": "AL" }, { "name": "Iron", "code": "IRON" }, { "name": "Steel", "code": "STL" }, { "name": "Other", "code": "OTH" }, { "name": "Unknown", "code": "UNK" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COVERTYPE", "type": "esriFieldTypeString", "alias": "Cover Type", "length": 5, "domain": { "type": "codedValue", "name": "Valve Vault Cover Type", "description": "", "codedValues": [ { "name": "Hand", "code": "HAND" }, { "name": "Lid", "code": "LID" }, { "name": "Manhole Cover", "code": "MC" }, { "name": "Other", "code": "OTH" }, { "name": "Unknown", "code": "UNK" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DEPTH", "type": "esriFieldTypeDouble", "alias": "Depth ", "domain": null }, { "name": "FRAMEMATERIAL", "type": "esriFieldTypeString", "alias": "Frame Material", "length": 5, "domain": { "type": "codedValue", "name": "Valve Vault Cover Material", "description": "", "codedValues": [ { "name": "Aluminum", "code": "AL" }, { "name": "Iron", "code": "IRON" }, { "name": "Steel", "code": "STL" }, { "name": "Other", "code": "OTH" }, { "name": "Unknown", "code": "UNK" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FRAMETYPE", "type": "esriFieldTypeString", "alias": "Frame Type", "length": 20, "domain": null }, { "name": "INVERTELEVATION", "type": "esriFieldTypeDouble", "alias": "Invert Elevation", "domain": null }, { "name": "VALVEVAULTLENGTH", "type": "esriFieldTypeInteger", "alias": "VALVEVAULTLENGTH", "domain": null }, { "name": "VALVEVAULTWIDTH", "type": "esriFieldTypeInteger", "alias": "VALVEVAULTWIDTH", "domain": null }, { "name": "VALVEVAULTHEIGHT", "type": "esriFieldTypeInteger", "alias": "VALVEVAULTHEIGHT", "domain": null }, { "name": "NETWORKSTRUCTUREOBJECTID", "type": "esriFieldTypeInteger", "alias": "NETWORKSTRUCTUREOBJECTID", "domain": null }, { "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": "R96_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G48NETWORKSTRUCT", "fields": "NETWORKSTRUCTUREOBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_96", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_96", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G48wwLiftStation", "fields": "wwLiftStation_GlobalID", "isAscending": true, "isUnique": false, "description": "" } ], "types": [ { "domains": { "LIFECYCLESTATUS": {"type": "inherited"}, "COVERMATERIAL": {"type": "inherited"}, "COVERTYPE": {"type": "inherited"}, "FRAMEMATERIAL": {"type": "inherited"} }, "id": 1, "name": "ValveVault" } ], "subtypes": [ { "domains": { "LIFECYCLESTATUS": {"type": "inherited"}, "COVERMATERIAL": {"type": "inherited"}, "COVERTYPE": {"type": "inherited"}, "FRAMEMATERIAL": {"type": "inherited"} }, "defaultValues": { "CREATIONUSER": null, "DATECREATED": null, "DATEMODIFIED": null, "LASTUSER": null, "LOCATION": null, "WARRANTYDATE": null, "CONDITION": null, "CONDITIONDATE": null, "SUBTYPECD": 1, "ELEVATION": null, "INSTALLDATE": null, "WORKORDERID": null, "LIFECYCLESTATUS": "ACT", "LOCATIONDESCRIPTION": null, "COVERMATERIAL": "STL", "COVERTYPE": "MC", "DEPTH": null, "FRAMEMATERIAL": "STL", "FRAMETYPE": null, "INVERTELEVATION": null, "VALVEVAULTLENGTH": null, "VALVEVAULTWIDTH": null, "VALVEVAULTHEIGHT": null, "NETWORKSTRUCTUREOBJECTID": null, "GlobalID": null, "wwLiftStation_GlobalID": null, "COMMENTS": null }, "code": 1, "name": "ValveVault" } ], "relationships": [ { "id": 4, "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 } }