Layer: Project_Database

View In: Map Viewer

Name: Project_Database_Form

Display Field: objectid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"labelingInfo":null,"renderer":{"description":"Survey Data Locations","label":"Project Database Form","symbol":{"angle":0,"color":[255,0,0,255],"outline":{"color":[255,255,0,255],"width":1},"size":8,"style":"esriSMSCircle","type":"esriSMS","xoffset":0,"yoffset":0},"type":"simple"},"transparency":0}
HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: objectid

Unique ID Field:

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)
project_id (type: esriFieldTypeString, alias: Project ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
program_ (type: esriFieldTypeString, alias: Program, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [COMMUNICATION & ADVOCACY: COMMUNICATION & ADVOCACY], [CSU: CSU], [KALIMANTAN & FOREST-FRESHWATER: KALIMANTAN & FOREST-FRESHWATER], ... 6 more ...)
agreement_no (type: esriFieldTypeString, alias: Agreement No., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
project_name (type: esriFieldTypeString, alias: Project Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
donor (type: esriFieldTypeString, alias: Donor, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
primary_donor (type: esriFieldTypeString, alias: Primary Donor, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
network_non (type: esriFieldTypeString, alias: Network/Non, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [WWF Network: WWF Network], [Non WWF Network: Non WWF Network])
gaa_via_network__direct (type: esriFieldTypeString, alias: GAA via Network/ Direct, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [GAA Direct: GAA Direct], [GAA via Network: GAA via Network], [GAA via Non WWF Network: GAA via Non WWF Network], ... 2 more ...)
funding_category (type: esriFieldTypeString, alias: Funding Category, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Corporate - Non WWF (Direct): Corporate - Non WWF (Direct)], [Corporate - WWF: Corporate - WWF], [PSP - Non WWF (Direct): PSP - Non WWF (Direct)], ... 4 more ...)
start_ (type: esriFieldTypeDate, alias: Start, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
end_ (type: esriFieldTypeDate, alias: End, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
contract_expiry__fy_ (type: esriFieldTypeDate, alias: Contract Expiry (FY), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
contract_expiry__q_ (type: esriFieldTypeDate, alias: Contract Expiry (Q), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [ACTIVE: ACTIVE], [CLOSED: CLOSED])
nce_status (type: esriFieldTypeString, alias: NCE Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
currency (type: esriFieldTypeString, alias: Currency, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [AUD: AUD], [CHF: CHF], [DKK: DKK], ... 8 more ...)
exchange_rate (type: esriFieldTypeDouble, alias: Exchange Rate, SQL Type: sqlTypeOther, nullable: true, editable: true)
amount__in_original_currency_ (type: esriFieldTypeDouble, alias: Amount (In Original Currency), SQL Type: sqlTypeOther, nullable: true, editable: true)
amount__in_idr (type: esriFieldTypeDouble, alias: Amount (In IDR), SQL Type: sqlTypeOther, nullable: true, editable: true)
amount__in_usd_ (type: esriFieldTypeDouble, alias: Amount (In USD), SQL Type: sqlTypeOther, nullable: true, editable: true)
name_of_main_project_lead (type: esriFieldTypeString, alias: Name of Main Project Lead (1 person), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
email_of_main_project_lead (type: esriFieldTypeString, alias: Email of Main Project Lead, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
relevant_po__if_any_ (type: esriFieldTypeString, alias: Relevant PO (if any), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
implementation_location (type: esriFieldTypeString, alias: Implementation Location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
project_desired_outcomes (type: esriFieldTypeString, alias: Project Desired Outcomes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
date_technical_report_smtr_1 (type: esriFieldTypeDate, alias: Date of Technical Report Deadline (Semester 1), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
date_technical_report_smtr_2 (type: esriFieldTypeDate, alias: Date of Technical Report Deadline (Semester 2), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
date_financial_report_smtr_1 (type: esriFieldTypeDate, alias: Date of Financial Report Deadline (Semester 1), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
date_financial_report_smtr_2 (type: esriFieldTypeDate, alias: Date of Financial Report Deadline (Semester 2), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
link_to_project_concept_note (type: esriFieldTypeString, alias: Link to Project Concept Note, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
project_proposal_documents_link (type: esriFieldTypeString, alias: Link to Project Proposal Documents, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
project_proposal_completeness (type: esriFieldTypeString, alias: Completeness of Project Proposal (Main Proposal, Maps, Workplan, Results Framework, Monitoring Plan, Budget Plan, Risk Asessment, HR Plan), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
link_to_project_contract (type: esriFieldTypeString, alias: Link to Project Contract, SQL Type: sqlTypeOther, length: 255, 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)

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/2/2020 3:56:23 AM

Schema Last Edit Date: 7/2/2020 3:56:23 AM

Data Last Edit Date: 7/2/2020 3:56:23 AM

Supported Operations: Query Query Pivot Query Top Features Query Analytic Query Bins Add Features Update Features Delete Features Apply Edits Calculate Generate Renderer Validate SQL Get Estimates ConvertFormat

Layer: Project_Database_Form (ID:0)