{ "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 21, "name": "sde_wastewater.ARCFM.WWSTANDBYPOWER", "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": { "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": "PHASES", "type": "esriFieldTypeString", "alias": "Phases ", "length": 20, "domain": null }, { "name": "VOLTAGE", "type": "esriFieldTypeDouble", "alias": "Voltage ", "domain": null }, { "name": "AMPERAGE", "type": "esriFieldTypeDouble", "alias": "Amperage ", "domain": null }, { "name": "SUBTYPECD", "type": "esriFieldTypeInteger", "alias": "Subtype CD", "domain": null }, { "name": "NETWORKSTRUCTUREOBJECTID", "type": "esriFieldTypeInteger", "alias": "Network Structure ObjectID", "domain": null }, { "name": "KILOWATTS", "type": "esriFieldTypeInteger", "alias": "KILOWATTS", "domain": null }, { "name": "MOTORTYPE", "type": "esriFieldTypeString", "alias": "MOTORTYPE", "length": 50, "domain": null }, { "name": "MOTORFUEL", "type": "esriFieldTypeString", "alias": "MOTORFUEL", "length": 50, "domain": null }, { "name": "FUELTANKSIZE", "type": "esriFieldTypeString", "alias": "FUELTANKSIZE", "length": 50, "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": "R100_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_100", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_100", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "types": [ { "domains": { "MANUFACTURER": {"type": "inherited"}, "LIFECYCLESTATUS": {"type": "inherited"} }, "id": 1, "name": "Stand-by Power" } ], "subtypes": [ { "domains": { "MANUFACTURER": {"type": "inherited"}, "LIFECYCLESTATUS": {"type": "inherited"} }, "defaultValues": { "CREATIONUSER": null, "DATECREATED": null, "DATEMODIFIED": null, "LASTUSER": null, "EQUIPMENTID": null, "INSTALLDATE": null, "MANUFACTURER": null, "MODEL": null, "SERIALNUMBER": null, "LIFECYCLESTATUS": "ACT", "PHASES": null, "VOLTAGE": null, "AMPERAGE": null, "SUBTYPECD": 1, "NETWORKSTRUCTUREOBJECTID": null, "KILOWATTS": null, "MOTORTYPE": null, "MOTORFUEL": null, "FUELTANKSIZE": null, "GlobalID": null, "wwLiftStation_GlobalID": null, "COMMENTS": null }, "code": 1, "name": "Stand-by Power" } ], "relationships": [ { "id": 2, "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 } }