{ "currentVersion": 10.91, "id": 12, "name": "Plan2Farm.DBO.ActionSummary", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 1, "name": "Landholder Details", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToOne", "role": "esriRelRoleDestination", "keyField": "LandholderID", "composite": false } ], "isDataVersioned": false, "isDataArchived": true, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1504668538000 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": false, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "CompletedBy", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "CompletedBy", "type": "esriFieldTypeString", "alias": "Completed By", "domain": { "type": "codedValue", "name": "domP2F_CompletedBy", "description": "", "codedValues": [ { "name": "Bryony Fitzgerald", "code": "Bryony Fitzgerald" }, { "name": "Carl Walters", "code": "Carl Walters" }, { "name": "Charles Thompson", "code": "Charles Thompson" }, { "name": "Daryl Poole", "code": "Daryl Poole" }, { "name": "Jacqui Knee", "code": "Jacqui Knee" }, { "name": "James Burkitt", "code": "James Burkitt" }, { "name": "James Whale", "code": "James Whale" }, { "name": "Jeff Parry", "code": "Jeff Parry" }, { "name": "Jim Shovelton", "code": "Jim Shovelton" }, { "name": "Kathy Long", "code": "Kathy Long" }, { "name": "Lachlan Barnes", "code": "Lachlan Barnes" }, { "name": "Lachlan Campbell", "code": "Lachlan Campbell" }, { "name": "Luke Rolley", "code": "Luke Rolley" }, { "name": "Matthew Hawken", "code": "Matthew Hawken" }, { "name": "Mike Stephens", "code": "Mike Stephens" }, { "name": "Paul Blackshaw", "code": "Paul Blackshaw" }, { "name": "Peter Forbes", "code": "Peter Forbes" }, { "name": "Phil Shannon", "code": "Phil Shannon" }, { "name": "Shari Rankin", "code": "Shari Rankin" }, { "name": "Suzanne Johnstone", "code": "Suzanne Johnstone" }, { "name": "Tammy Herne", "code": "Tammy Herne" }, { "name": "Tim Shanahan", "code": "Tim Shanahan" }, { "name": "Timothy Robinson", "code": "Timothy Robinson" }, { "name": "Tom Farran", "code": "Tom Farran" }, { "name": "Toni Radcliffe", "code": "Toni Radcliffe" }, { "name": "Dennis Watson", "code": "Dennis Watson" }, { "name": "Joel Pike", "code": "Joel Pike" }, { "name": "Rebecca Pike", "code": "Rebecca Pike" }, { "name": "Rabi Maskey", "code": "Rabi Maskey" }, { "name": "Neil McLeod", "code": "Neil McLeod" }, { "name": "Julie Engstrom", "code": "Julie Engstrom" }, { "name": "Lyndall Ash", "code": "Lyndall Ash" }, { "name": "John Bourchier", "code": "John Bourchier" }, { "name": "Nick O\u2019Halloran", "code": "Nick O\u2019Halloran" }, { "name": "Rob O\u2019Connor", "code": "Rob O\u2019Connor" }, { "name": "Glenn Thompson", "code": "Glenn Thompson" }, { "name": "Bruce Mathers", "code": "Bruce Mathers" }, { "name": "Jenny Spence", "code": "Jenny Spence" }, { "name": "Ross Read", "code": "Ross Read" }, { "name": "Lisa Menhenett", "code": "Lisa Menhenett" }, { "name": "Lisa Birrell", "code": "Lisa Birrell" }, { "name": "Sarah Thompson", "code": "Sarah Thompson" }, { "name": "Chris Saunders", "code": "Chris Saunders" }, { "name": "Ruby Barnes", "code": "Ruby Barnes" }, { "name": "Joe Braden", "code": "Joe Braden" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CompletedBy" }, { "name": "CompletedDate", "type": "esriFieldTypeDate", "alias": "Completed Date", "domain": null, "editable": true, "nullable": false, "length": 8, "defaultValue": null, "modelName": "CompletedDate" }, { "name": "ActionSummary", "type": "esriFieldTypeString", "alias": "Summary Of Actions", "domain": null, "editable": true, "nullable": false, "length": 1073741822, "defaultValue": null, "modelName": "ActionSummary" }, { "name": "Signposted", "type": "esriFieldTypeString", "alias": "Signposted to complimentary programs", "domain": { "type": "codedValue", "name": "domP2F_YN", "description": "Yes No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Signposted" }, { "name": "Signposted1", "type": "esriFieldTypeString", "alias": "Signposted program/incentive", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Signposted1" }, { "name": "Signposted2", "type": "esriFieldTypeString", "alias": "Signposted program/incentive", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Signposted2" }, { "name": "Signposted3", "type": "esriFieldTypeString", "alias": "Signposted program/incentiive", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Signposted3" }, { "name": "LandholderID", "type": "esriFieldTypeGUID", "alias": "LandholderID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "LandholderID" }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "SummComplete", "type": "esriFieldTypeString", "alias": "SummComplete", "domain": { "type": "codedValue", "name": "domP2F_YN", "description": "Yes No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "SummComplete" } ], "indexes": [ { "name": "GDB_37_Landholde", "fields": "LandholderID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_17", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "Plan2Farm.DBO.ActionSummary", "description": "", "prototype": { "attributes": { "SummComplete": null, "CompletedBy": null, "CompletedDate": -2209161600000, "ActionSummary": " ", "Signposted": null, "Signposted1": null, "Signposted2": null, "Signposted3": null, "LandholderID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1, "serviceItemId": "cd86edcf5e10476e889ee4128051e9d1" }