{ "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 19, "name": "sde_wastewater.ARCFM.WWMOTOR", "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": "EQUIPMENTID", "type": "esriFieldTypeString", "alias": "Equipment ID", "length": 20, "domain": null }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "INSTALLDATE", "length": 8, "domain": null }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "Manufacturer ", "length": 5, "domain": null }, { "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": "AVERAGEPOWERUSAGE", "type": "esriFieldTypeString", "alias": "Average Power Usage", "length": 20, "domain": null }, { "name": "PEAKPOWERUSAGE", "type": "esriFieldTypeString", "alias": "Peak Power Usage", "length": 20, "domain": null }, { "name": "PHASES", "type": "esriFieldTypeString", "alias": "Phases ", "length": 20, "domain": null }, { "name": "RATEDPOWER", "type": "esriFieldTypeString", "alias": "Rated Power", "length": 20, "domain": null }, { "name": "RPM", "type": "esriFieldTypeInteger", "alias": "RPM", "domain": null }, { "name": "VARIABLESPEED", "type": "esriFieldTypeString", "alias": "Variable Speed", "length": 20, "domain": null }, { "name": "VOLTAGE", "type": "esriFieldTypeInteger", "alias": "Voltage ", "domain": null }, { "name": "SUBTYPECD", "type": "esriFieldTypeInteger", "alias": "Subtype CD", "domain": null }, { "name": "NETWORKSTRUCTUREOBJECTID", "type": "esriFieldTypeInteger", "alias": "Network Structure ObjectID", "domain": null }, { "name": "GPM", "type": "esriFieldTypeString", "alias": "GPM", "length": 50, "domain": null }, { "name": "MFG", "type": "esriFieldTypeString", "alias": "MFG", "length": 50, "domain": null }, { "name": "IMPELLERSIZE", "type": "esriFieldTypeString", "alias": "IMPELLERSIZE", "length": 100, "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": "R101_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_101", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_101", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "types": [ { "domains": { "MANUFACTURER": { "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" }, "LIFECYCLESTATUS": {"type": "inherited"} }, "id": 1, "name": "Motor" } ], "subtypes": [ { "domains": { "MANUFACTURER": { "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" }, "LIFECYCLESTATUS": {"type": "inherited"} }, "defaultValues": { "CREATIONUSER": null, "DATECREATED": null, "DATEMODIFIED": null, "LASTUSER": null, "EQUIPMENTID": null, "INSTALLDATE": null, "MANUFACTURER": null, "MODEL": null, "SERIALNUMBER": null, "LIFECYCLESTATUS": "ACT", "AVERAGEPOWERUSAGE": null, "PEAKPOWERUSAGE": null, "PHASES": null, "RATEDPOWER": null, "RPM": null, "VARIABLESPEED": null, "VOLTAGE": null, "SUBTYPECD": 1, "NETWORKSTRUCTUREOBJECTID": null, "GPM": null, "MFG": null, "IMPELLERSIZE": null, "GlobalID": null, "wwLiftStation_GlobalID": null, "COMMENTS": null }, "code": 1, "name": "Motor" } ], "relationships": [ { "id": 7, "name": "Network Structure", "relatedTableId": 7, "role": "esriRelRoleDestination", "keyField": "wwLiftStation_GlobalID", "cardinality": "esriRelCardinalityOneToMany", "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 } }