Name: Solution

Display Field: objectid

Type: Table

Has Views: true

Source Schema Changes Allowed: false

Views

Description:

Copyright Text:

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: objectid

Unique ID Field:

Name : objectid

IsSystemMaintained : True

Global ID Field: globalid

Type ID Field:

Fields:

• objectid (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
• base_Solution_Name (type: esriFieldTypeString, alias: base_Solution_Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• base_Solution_Lab (type: esriFieldTypeString, alias: base_Solution_Lab, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• base_Solution_Year (type: esriFieldTypeString, alias: base_Solution_Year, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• base_Solution_Quarter (type: esriFieldTypeString, alias: base_Solution_Quarter, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• base_Solution_YearQuarter (type: esriFieldTypeString, alias: base_Solution_YearQuarter, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SolutionName (type: esriFieldTypeString, alias: Name of the Solution, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SolutionName1 (type: esriFieldTypeString, alias: Name of the Solution, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SolutionName2 (type: esriFieldTypeString, alias: Name of the Solution, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SolutionMerge (type: esriFieldTypeString, alias: SolutionMerge, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Report (type: esriFieldTypeString, alias: Is there anything to report for this solution this quarter?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No (There are no updates to the solution status, partner purpose, solution impacts, etc to report)])
• Reason (type: esriFieldTypeString, alias: Please specify why there is nothing to report on this solution, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [NothingQuarter: There are no new activities to report this quarter], [NotInvolved: Panda Labs is no longer involved with this solution])
• ChallengeTopic (type: esriFieldTypeString, alias: High Level Solution Topic, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ChalTopic (type: esriFieldTypeString, alias: High Level Solution Topic (KPI: # of linkages to WWF goals or priorities), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ChallengeStatement (type: esriFieldTypeString, alias: Solution Specific Challenge Statement, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• SolDesc (type: esriFieldTypeString, alias: Description, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• SolSource (type: esriFieldTypeString, alias: What was the source of your solution?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Hackathon: Hackathon], [GreenhouseSession: Greenhouse Session], [IdeationSessionwithExternals: Ideation Session with Externals (non hackathon or Greenhouse Session)], ... 3 more ...)
• Stage (type: esriFieldTypeString, alias: Solution Phase, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Create: Create (establishing an innovation ecosystem, gathering support, and identifying a potential solution)], [Experiment: Experiment (prototyping, refining, and validating solutions)], [Scale: Scale (solution is accelerating, growing, or expanding into a new context, and has already gone through prototyping and validation)], ... 1 more ...)
• Status (type: esriFieldTypeString, alias: Solution Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• FailDesc (type: esriFieldTypeString, alias: Please briefly describe why the solution failed, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• ScaleDesc (type: esriFieldTypeString, alias: Growth Description, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• WorkwithComm (type: esriFieldTypeString, alias: Does this solution involve working directly with local communities?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• UpholdStandards (type: esriFieldTypeString, alias: To the best of your knowledge, does this solution uphold the Panda Labs ethos of genuine co-creation, ESSF standards, other WWF social policies, and relevant local regulations?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• BusinessStage (type: esriFieldTypeString, alias: Stage of Business Model Development for this Solution, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [NotStarted: Not Started], [InDevelopment: In Development], [Finalized: Finalized], ... 1 more ...)
• Outcome (type: esriFieldTypeString, alias: What types of monitoring do you have to report?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Cons1 (type: esriFieldTypeString, alias: Conservation Outcome/Impact #1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Cons2 (type: esriFieldTypeString, alias: Conservation Outcome/Impact #2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ConTime (type: esriFieldTypeString, alias: Specify the time period the above information corresponds to, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Q: This quarter], [TD: To Date])
• Soc1 (type: esriFieldTypeString, alias: Social Outcome/Impact #1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Soc2 (type: esriFieldTypeString, alias: Social Outcome/Impact #2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SocTime (type: esriFieldTypeString, alias: Specify the time period the above information corresponds to, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Q1: This quarter], [TD1: To Date])
• Bus1 (type: esriFieldTypeString, alias: Economic Outcome/Impact #1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Bus2 (type: esriFieldTypeString, alias: Economic Outcome/Impact #2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• BusTime (type: esriFieldTypeString, alias: Specify the time period the above information corresponds to, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Q2: This quarter], [TD2: To Date])
• Plat1 (type: esriFieldTypeString, alias: Platform Outcome/Impact #1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Plat2 (type: esriFieldTypeString, alias: Platform Outcome/Impact #2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PlatTime (type: esriFieldTypeString, alias: Specify the time period the above information corresponds to, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Q2: This quarter], [TD2: To Date])
• Other1 (type: esriFieldTypeString, alias: Other Outcome/Impact #1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Other2 (type: esriFieldTypeString, alias: Other Outcome/Impact #2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OtherTime (type: esriFieldTypeString, alias: Specify the time period the above information corresponds to, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Q2: This quarter], [TD2: To Date])
• Notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• parentglobalid (type: esriFieldTypeGUID, alias: ParentGlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: true, editable: true)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)

Relationships:

• Panda_Labs_MEL_Reporting_Solution (3) -- Related To: Panda_Labs_MEL_Reporting (0)
• Solution_Partners (4) -- Related To: Partners (4)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 10/14/2021 2:08:45 AM

Schema Last Edit Date: 10/14/2021 2:08:45 AM

Data Last Edit Date: 10/14/2021 2:08:45 AM

Supported Operations:   Add Features   Apply Edits   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat