{ "currentVersion": 10.91, "id": 13, "name": "Plan2Farm.DBO.AdditionalInteraction", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "CompletedBy", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "LandholderID", "type": "esriFieldTypeGUID", "alias": "LandholderID", "length": 38, "domain": null }, { "name": "CompletedBy", "type": "esriFieldTypeString", "alias": "Completed By", "length": 50, "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" } }, { "name": "CompletedDate", "type": "esriFieldTypeDate", "alias": "Completed Date", "length": 8, "domain": null }, { "name": "InitiatedBy", "type": "esriFieldTypeString", "alias": "Interaction Initiated By", "length": 50, "domain": { "type": "codedValue", "name": "domP2F_InitiatedBy", "description": "", "codedValues": [ { "name": "Consultant", "code": "Consultant" }, { "name": "Farmer", "code": "Farmer" }, { "name": "Project Manager/Officer", "code": "Project Manager Officer" }, { "name": "Workbook Advisor", "code": "Workbook Advisor" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InteractionSummary", "type": "esriFieldTypeString", "alias": "Summary of interactions", "length": 1073741822, "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null } ], "indexes": [ { "name": "GDB_45_Landholde", "fields": "LandholderID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_21", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "Landholder Details", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "LandholderID", "cardinality": "esriRelCardinalityOneToOne", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": false, "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, "serviceItemId": "c9de7dfeb5ce4804849b855bb063092d" }