{ "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 18, "name": "sde_wastewater.ARCFM.WWELECTRICPANEL", "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": "SUBTYPECD", "type": "esriFieldTypeInteger", "alias": "Subtype CD", "domain": null }, { "name": "NETWORKSTRUCTUREOBJECTID", "type": "esriFieldTypeInteger", "alias": "Network Structure ObjectID", "domain": null }, { "name": "EMERGENCYLIGHT", "type": "esriFieldTypeString", "alias": "EMERGENCYLIGHT", "length": 50, "domain": { "type": "codedValue", "name": "Yes No Indicator", "description": "", "codedValues": [ { "name": "No", "code": "N" }, { "name": "Yes", "code": "Y" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "EMERGENCYALARM", "type": "esriFieldTypeString", "alias": "EMERGENCYALARM", "length": 50, "domain": { "type": "codedValue", "name": "Yes No Indicator", "description": "", "codedValues": [ { "name": "No", "code": "N" }, { "name": "Yes", "code": "Y" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "MAINBREAKERSIZE", "type": "esriFieldTypeInteger", "alias": "MAINBREAKERSIZE", "domain": null }, { "name": "STARTERSIZE", "type": "esriFieldTypeInteger", "alias": "STARTERSIZE", "domain": null }, { "name": "HEATERSIZE", "type": "esriFieldTypeInteger", "alias": "HEATERSIZE", "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": "R95_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G47NETWORKSTRUCT", "fields": "NETWORKSTRUCTUREOBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_95", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_95", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G47wwLiftStation", "fields": "wwLiftStation_GlobalID", "isAscending": true, "isUnique": false, "description": "" } ], "types": [ { "domains": { "MANUFACTURER": {"type": "inherited"}, "LIFECYCLESTATUS": {"type": "inherited"} }, "id": 1, "name": "Electric Panel" } ], "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", "SUBTYPECD": 1, "NETWORKSTRUCTUREOBJECTID": null, "EMERGENCYLIGHT": null, "EMERGENCYALARM": null, "MAINBREAKERSIZE": null, "STARTERSIZE": null, "HEATERSIZE": null, "GlobalID": null, "wwLiftStation_GlobalID": null, "COMMENTS": null }, "code": 1, "name": "Electric Panel" } ], "relationships": [ { "id": 1, "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 } }