{ "currentVersion": 10.7, "id": 124, "name": "SOMASTER.SO_Maintenance_Schedule", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "LINE", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "LINE", "type": "esriFieldTypeString", "alias": "Sewer Pipe Id", "length": 17, "domain": null }, { "name": "YEAR_PLAND", "type": "esriFieldTypeString", "alias": "Maint. Planned For The Year", "length": 9, "domain": null }, { "name": "COMPLETED_STATUS", "type": "esriFieldTypeString", "alias": "Whether Maint. Activity Done", "length": 3, "domain": null }, { "name": "STARTED_BY", "type": "esriFieldTypeDate", "alias": "Maint. Activity Started By", "length": 8, "domain": null }, { "name": "COMPLETED_BY", "type": "esriFieldTypeDate", "alias": "Maint. Activity Completed By", "length": 8, "domain": null }, { "name": "EXECUTE_AGENCY", "type": "esriFieldTypeString", "alias": "Name of the Agency", "length": 100, "domain": null }, { "name": "REMARKS", "type": "esriFieldTypeString", "alias": "Remarks", "length": 255, "domain": null }, { "name": "SUBURB", "type": "esriFieldTypeString", "alias": "Suburbs", "length": 10, "domain": null }, { "name": "CREATED_USER", "type": "esriFieldTypeString", "alias": "CREATED_USER", "length": 255, "domain": null }, { "name": "CREATED_DATE", "type": "esriFieldTypeDate", "alias": "CREATED_DATE", "length": 8, "domain": null }, { "name": "LAST_EDITED_USER", "type": "esriFieldTypeString", "alias": "LAST_EDITED_USER", "length": 255, "domain": null }, { "name": "LAST_EDITED_DATE", "type": "esriFieldTypeDate", "alias": "LAST_EDITED_DATE", "length": 8, "domain": null }, { "name": "MACHINE", "type": "esriFieldTypeString", "alias": "Cleaning Machine Name", "length": 100, "domain": null }, { "name": "EDITOR", "type": "esriFieldTypeInteger", "alias": "Editor", "domain": null }, { "name": "EDITTIME", "type": "esriFieldTypeDate", "alias": "Edit Time", "length": 8, "domain": null }, { "name": "REVIEWER", "type": "esriFieldTypeInteger", "alias": "Reviewer", "domain": null }, { "name": "REVIEWTIME", "type": "esriFieldTypeDate", "alias": "Reviewed Time", "length": 8, "domain": null }, { "name": "NEW_LINE_ID", "type": "esriFieldTypeString", "alias": "NEW_LINE_ID", "length": 25, "domain": null }, { "name": "LENGTH", "type": "esriFieldTypeDouble", "alias": "LENGTH", "domain": null } ], "indexes": [ { "name": "R391583_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, AMF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }