Name: Plan2Farm.DBO.SixMonth

Display Field: IndDiscussGroupName

Type: Table

Geometry Type: N/A

Description:

Service Item Id: cd86edcf5e10476e889ee4128051e9d1

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• LandholderID ( type: esriFieldTypeGUID, alias: LandholderID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: LandholderID )
• CompletedBy ( type: esriFieldTypeString, alias: Assessment Completed By, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CompletedBy , Coded Values: [Bryony Fitzgerald: Bryony Fitzgerald] , [Carl Walters: Carl Walters] , [Charles Thompson: Charles Thompson] , ...42 more... )
• CompletedDate ( type: esriFieldTypeDate, alias: Response Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ResponseDate )
• PrimeFarmType ( type: esriFieldTypeString, alias: Primary Farm Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PrimeFarmType , Coded Values: [Annual Horticulture: Annual Horticulture] , [Cattle Beef: Cattle (Beef)] , [Dairy: Dairy] , ...9 more... )
• SecondFarmType ( type: esriFieldTypeString, alias: Secondary Farm Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SecondFarmType , Coded Values: [Annual Horticulture: Annual Horticulture] , [Cattle Beef: Cattle (Beef)] , [Dairy: Dairy] , ...9 more... )
• TertFarmType ( type: esriFieldTypeString, alias: Tertiary Farm Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TertFarmType , Coded Values: [Annual Horticulture: Annual Horticulture] , [Cattle Beef: Cattle (Beef)] , [Dairy: Dairy] , ...9 more... )
• WaterUsage ( type: esriFieldTypeString, alias: Current Water Usage, editable: true, nullable: true, length: 10, defaultValue: null, modelName: WaterUsage , Coded Values: [0_10: 0-10] , [10_50: 10-50] , [50_200: 50-200] , ...2 more... )
• FarmSizeHA ( type: esriFieldTypeString, alias: Farm Size in HA, editable: true, nullable: true, length: 10, defaultValue: null, modelName: FarmSizeHA , Coded Values: [0_20: 0-20] , [20_150: 20-150] , [150_400: 150-400] , ...1 more... )
• Employees ( type: esriFieldTypeString, alias: Number Of Employees, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Employees )
• ConnectionStat ( type: esriFieldTypeString, alias: Connection Status, editable: true, nullable: true, length: 15, defaultValue: null, modelName: ConnectionStat , Coded Values: [Completed: Completed] , [Not Applicable: Not Applicable] , [Not Completed: Not Completed] )
• FutureIrrigInt ( type: esriFieldTypeString, alias: FutureI rrigigation Intentions, editable: true, nullable: true, length: 15, defaultValue: null, modelName: FutureIrrigInt , Coded Values: [Cease: Cease] , [Decrease: Decrease] , [Increase: Increase] , ...3 more... )
• HaveFarmVision ( type: esriFieldTypeString, alias: Do you have future farm vision?, editable: true, nullable: true, length: 3, defaultValue: null, modelName: HaveFarmVision , Coded Values: [Yes: Yes] , [No: No] )
• WhatToAchieveVision ( type: esriFieldTypeString, alias: Do you know what it will take to achieve your vision?, editable: true, nullable: true, length: 15, defaultValue: null, modelName: WhatToAchieveVision , Coded Values: [Yes: Yes] , [No: No] , [NA: Not Applicable] )
• FarmingFuture ( type: esriFieldTypeString, alias: Do you intend to keep farming?, editable: true, nullable: true, length: 6, defaultValue: null, modelName: FarmingFuture , Coded Values: [Yes: Yes] , [No: No] , [Unsure: Unsure] )
• FutureReasons ( type: esriFieldTypeString, alias: Whye are you unsure/intend to cease farming?, editable: true, nullable: true, length: 600, defaultValue: null, modelName: FutureReasons )
• OnFarmEfficency ( type: esriFieldTypeString, alias: Participated in on farm efficency program, editable: true, nullable: true, length: 3, defaultValue: null, modelName: OnFarmEfficency , Coded Values: [Yes: Yes] , [No: No] )
• OFEType ( type: esriFieldTypeString, alias: Which On Farm Efficiency Program, editable: true, nullable: true, length: 125, defaultValue: null, modelName: OFEType )
• SuccessionPlan ( type: esriFieldTypeString, alias: Current Succession Plan, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SuccessionPlan , Coded Values: [Yes: Yes] , [Yes Need Updating: Yes- Needs Updating] , [No: No] )
• BusinessPlan ( type: esriFieldTypeString, alias: Current Business Plan, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BusinessPlan , Coded Values: [Yes: Yes] , [Yes Need Updating: Yes- Needs Updating] , [No: No] )
• FinancialPlanBudget ( type: esriFieldTypeString, alias: Current Financial Plan/Budget, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FinancialPlanBudget , Coded Values: [Yes: Yes] , [Yes Need Updating: Yes- Needs Updating] , [No: No] )
• WaterBudget ( type: esriFieldTypeString, alias: Current Water Budget, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WaterBudget , Coded Values: [Yes: Yes] , [Yes Need Updating: Yes- Needs Updating] , [No: No] )
• WFP ( type: esriFieldTypeString, alias: Current Whole Farm Plan, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WFP , Coded Values: [Yes: Yes] , [Yes Need Updating: Yes- Needs Updating] , [No: No] )
• TrackBusAnnualPerf ( type: esriFieldTypeString, alias: Do you track you business annual performance, editable: true, nullable: true, length: 3, defaultValue: null, modelName: TrackBusAnnualPerf , Coded Values: [Yes: Yes] , [No: No] )
• TrachBusBench ( type: esriFieldTypeString, alias: Do you track your business benchamarking, editable: true, nullable: true, length: 3, defaultValue: null, modelName: TrachBusBench , Coded Values: [Yes: Yes] , [No: No] )
• TrackCashflow ( type: esriFieldTypeString, alias: Do you track cash flow, editable: true, nullable: true, length: 3, defaultValue: null, modelName: TrackCashflow , Coded Values: [Yes: Yes] , [No: No] )
• IndDiscussGroup ( type: esriFieldTypeString, alias: Industry Discussion Group, editable: true, nullable: true, length: 10, defaultValue: null, modelName: IndDiscussGroup , Coded Values: [Currently: Currently] , [Never: Never] , [Previously: Previously] )
• IndDiscussGroupName ( type: esriFieldTypeString, alias: Industry Discussion Group Name, editable: true, nullable: true, length: 125, defaultValue: null, modelName: IndDiscussGroupName )
• TakingStock ( type: esriFieldTypeString, alias: Participated in taking stock, editable: true, nullable: true, length: 10, defaultValue: null, modelName: TakingStock , Coded Values: [Currently: Currently] , [Never: Never] , [Previously: Previously] )
• Landcare ( type: esriFieldTypeString, alias: Involved in Landcare, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Landcare , Coded Values: [Currently: Currently] , [Never: Never] , [Previously: Previously] )
• OtherGroup ( type: esriFieldTypeString, alias: Any Other Groups/Programs, editable: true, nullable: true, length: 125, defaultValue: null, modelName: OtherGroup )
• UseAnimalNut ( type: esriFieldTypeString, alias: Do you currently pay an Animal Nutritionist, editable: true, nullable: true, length: 3, defaultValue: null, modelName: UseAnimalNut , Coded Values: [Yes: Yes] , [No: No] )
• UseAgron ( type: esriFieldTypeString, alias: Do you currently pay an Agronomist, editable: true, nullable: true, length: 3, defaultValue: null, modelName: UseAgron , Coded Values: [Yes: Yes] , [No: No] )
• UseFarmBus ( type: esriFieldTypeString, alias: Do you currnetly pay a Financial Advisor, editable: true, nullable: true, length: 3, defaultValue: null, modelName: UseFarmBus , Coded Values: [Yes: Yes] , [No: No] )
• UseAccount ( type: esriFieldTypeString, alias: Do you currently pay an Accountant, editable: true, nullable: true, length: 3, defaultValue: null, modelName: UseAccount , Coded Values: [Yes: Yes] , [No: No] )
• UseOtherConsult ( type: esriFieldTypeString, alias: Do you currently pay any other consultants, editable: true, nullable: true, length: 3, defaultValue: null, modelName: UseOtherConsult , Coded Values: [Yes: Yes] , [No: No] )
• ListOtherConsult ( type: esriFieldTypeString, alias: List Other Consultants used, editable: true, nullable: true, length: 254, defaultValue: null, modelName: ListOtherConsult )
• OtherHelp ( type: esriFieldTypeString, alias: Other help required or multiple issues, editable: true, nullable: true, length: 254, defaultValue: null, modelName: OtherHelp )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• ActionSummUpdate ( type: esriFieldTypeString, alias: Summary of actions update, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ActionSummUpdate )
• Signposted1Up ( type: esriFieldTypeString, alias: Uptake of signposted program/incentive, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Signposted1Up , Coded Values: [Yes: Yes] , [No: No] )
• Signposted2Up ( type: esriFieldTypeString, alias: Uptake of signposted program/incentive, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Signposted2Up , Coded Values: [Yes: Yes] , [No: No] )
• Signposted3Up ( type: esriFieldTypeString, alias: Uptake of signposted program/incentive, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Signposted3Up , Coded Values: [Yes: Yes] , [No: No] )
• Signposted ( type: esriFieldTypeString, alias: Signposted to complimentary program/incentive, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Signposted , Coded Values: [Yes: Yes] , [No: No] )
• Signposted4 ( type: esriFieldTypeString, alias: Signposted program/incentive, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Signposted4 )
• Signposted5 ( type: esriFieldTypeString, alias: Signposted program/incentive, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Signposted5 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• SixMComplete ( type: esriFieldTypeString, alias: 6 month follow-up complete?, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SixMComplete , Coded Values: [Yes: Yes] , [No: No] )

Templates:

• Name: Plan2Farm.DBO.SixMonth
  Description:
  Prototype:
  Signposted5: null
  LandholderID: null
  CompletedBy: null
  CompletedDate: null
  PrimeFarmType: null
  SecondFarmType: null
  TertFarmType: null
  WaterUsage: null
  FarmSizeHA: null
  Employees: null
  ConnectionStat: null
  FutureIrrigInt: null
  HaveFarmVision: null
  WhatToAchieveVision: null
  FarmingFuture: null
  FutureReasons: null
  OnFarmEfficency: null
  OFEType: null
  SuccessionPlan: null
  BusinessPlan: null
  FinancialPlanBudget: null
  WaterBudget: null
  WFP: null
  TrackBusAnnualPerf: null
  TrachBusBench: null
  TrackCashflow: null
  IndDiscussGroup: null
  IndDiscussGroupName: null
  TakingStock: null
  Landcare: null
  OtherGroup: null
  UseAnimalNut: null
  UseAgron: null
  UseFarmBus: null
  UseAccount: null
  UseOtherConsult: null
  ListOtherConsult: null
  OtherHelp: null
  Signposted4: null
  Signposted: null
  Signposted3Up: null
  Signposted2Up: null
  SixMComplete: null
  ActionSummUpdate: null
  Signposted1Up: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Landholder Details (4) -- Related To: Farm - All (0)

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: true

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Attachments   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata