{ "currentVersion": 10.81, "id": 15, "name": "dashboard.VALVE_STATUS", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "TAG", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "TAG", "type": "esriFieldTypeString", "alias": "TAG", "length": 50, "domain": null }, { "name": "VALVE_USE", "type": "esriFieldTypeString", "alias": "VALVE_USE", "length": 15, "domain": null }, { "name": "WACHS_VALVE_USE", "type": "esriFieldTypeString", "alias": "WACHS_VALVE_USE", "length": 25, "domain": null }, { "name": "VALVE_ID", "type": "esriFieldTypeString", "alias": "VALVE_ID", "length": 15, "domain": null }, { "name": "LAST_EDITED_BY", "type": "esriFieldTypeString", "alias": "LAST_EDITED_BY", "length": 100, "domain": null }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "COMMENTS", "length": 2147483647, "domain": null }, { "name": "DATE_COMMENTS", "type": "esriFieldTypeDate", "alias": "DATE_COMMENTS", "length": 8, "domain": null }, { "name": "POSITION_LEFT", "type": "esriFieldTypeString", "alias": "POSITION_LEFT", "length": 25, "domain": null }, { "name": "POSITION_FOUND", "type": "esriFieldTypeString", "alias": "POSITION_FOUND", "length": 25, "domain": null }, { "name": "POSITION_TRACE", "type": "esriFieldTypeString", "alias": "POSITION_TRACE", "length": 1, "domain": null }, { "name": "TURNS_POSITION_CHANGE", "type": "esriFieldTypeDouble", "alias": "TURNS_POSITION_CHANGE", "domain": null }, { "name": "DATE_POSITION_CHANGE", "type": "esriFieldTypeDate", "alias": "DATE_POSITION_CHANGE", "length": 8, "domain": null }, { "name": "CONDITION", "type": "esriFieldTypeString", "alias": "CONDITION", "length": 15, "domain": null }, { "name": "DATE_CONDITION", "type": "esriFieldTypeDate", "alias": "DATE_CONDITION", "length": 8, "domain": null }, { "name": "EXERCISED", "type": "esriFieldTypeString", "alias": "EXERCISED", "length": 25, "domain": null }, { "name": "TURNS_EXERCISED", "type": "esriFieldTypeDouble", "alias": "TURNS_EXERCISED", "domain": null }, { "name": "DATE_EXERCISED", "type": "esriFieldTypeDate", "alias": "DATE_EXERCISED", "length": 8, "domain": null }, { "name": "INITIAL_TORQUE_MAX", "type": "esriFieldTypeDouble", "alias": "INITIAL_TORQUE_MAX", "domain": null }, { "name": "INITIAL_TORQUE_MIN", "type": "esriFieldTypeDouble", "alias": "INITIAL_TORQUE_MIN", "domain": null }, { "name": "FINAL_TORQUE_MAX", "type": "esriFieldTypeDouble", "alias": "FINAL_TORQUE_MAX", "domain": null }, { "name": "FINAL_TORQUE_MIN", "type": "esriFieldTypeDouble", "alias": "FINAL_TORQUE_MIN", "domain": null }, { "name": "BYP_CONDITION", "type": "esriFieldTypeString", "alias": "BYP_CONDITION", "length": 50, "domain": null }, { "name": "BYP_POSITION_FOUND", "type": "esriFieldTypeString", "alias": "BYP_POSITION_FOUND", "length": 50, "domain": null }, { "name": "BYP_POSITION_LEFT", "type": "esriFieldTypeString", "alias": "BYP_POSITION_LEFT", "length": 50, "domain": null }, { "name": "DATE_BYP_POSITION_CHG", "type": "esriFieldTypeDate", "alias": "DATE_BYP_POSITION_CHG", "length": 8, "domain": null }, { "name": "BYPASS_COMMENTS", "type": "esriFieldTypeString", "alias": "BYPASS_COMMENTS", "length": 2147483647, "domain": null }, { "name": "BYP_TURNS_ACTUAL", "type": "esriFieldTypeDouble", "alias": "BYP_TURNS_ACTUAL", "domain": null }, { "name": "VALVE_ACCESS", "type": "esriFieldTypeString", "alias": "VALVE_ACCESS", "length": 255, "domain": null }, { "name": "VALVE_PROBLEM", "type": "esriFieldTypeString", "alias": "VALVE_PROBLEM", "length": 255, "domain": null }, { "name": "CONDITION_TRACE", "type": "esriFieldTypeString", "alias": "CONDITION_TRACE", "length": 4, "domain": null }, { "name": "VALVE_STATUS", "type": "esriFieldTypeString", "alias": "VALVE_STATUS", "length": 15, "domain": null }, { "name": "IN_GIS_NETWORK_YN", "type": "esriFieldTypeString", "alias": "IN_GIS_NETWORK_YN", "length": 1, "domain": null }, { "name": "IN_WACHS_TABLE", "type": "esriFieldTypeString", "alias": "IN_WACHS_TABLE", "length": 1, "domain": null }, { "name": "DIFFERS_FROM_WACHS_YN", "type": "esriFieldTypeString", "alias": "DIFFERS_FROM_WACHS_YN", "length": 1, "domain": null }, { "name": "REASON_FOR_DIFF", "type": "esriFieldTypeString", "alias": "REASON_FOR_DIFF", "length": 2147483647, "domain": null }, { "name": "DIFFERENCE_COMMENT", "type": "esriFieldTypeString", "alias": "DIFFERENCE_COMMENT", "length": 2147483647, "domain": null }, { "name": "WO_NEEDED", "type": "esriFieldTypeString", "alias": "WO_NEEDED", "length": 50, "domain": null }, { "name": "WO_NUM", "type": "esriFieldTypeString", "alias": "WO_NUM", "length": 20, "domain": null }, { "name": "ESRI_OID", "type": "esriFieldTypeOID", "alias": "ESRI_OID", "domain": null } ], "indexes": [ { "name": "PK__VALVE_STATUS", "fields": "TAG", "isAscending": true, "isUnique": true, "description": "" }, { "name": "IX_VALVE_STATUS", "fields": "CONDITION_TRACE", "isAscending": true, "isUnique": false, "description": "" }, { "name": "IX_VALVE_STATUS_1", "fields": "POSITION_TRACE", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": false, "advancedQueryCapabilities": { "useStandardizedQueries": false, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }