Name: AidData_ChineseFinancialPublicDiplomacyProjectDetails

Display Field:

Type: Table

Description:

Copyright Text:

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: ObjectId

Unique ID Field:

Name : ObjectId

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• type (type: esriFieldTypeString, alias: type, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• donor (type: esriFieldTypeString, alias: donor, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• recipient (type: esriFieldTypeString, alias: recipient, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• recipient_region (type: esriFieldTypeString, alias: recipient_region, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• commitment_year (type: esriFieldTypeInteger, alias: commitment_year, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• commitment_year_estimated (type: esriFieldTypeString, alias: commitment_year_estimated, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• implementation_start_year (type: esriFieldTypeInteger, alias: implementation_start_year, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• completion_year (type: esriFieldTypeInteger, alias: completion_year, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• title (type: esriFieldTypeString, alias: title, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• description (type: esriFieldTypeString, alias: description, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
• staff_comments (type: esriFieldTypeString, alias: staff_comments, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
• status (type: esriFieldTypeString, alias: status, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• intent (type: esriFieldTypeString, alias: intent, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• flow_type (type: esriFieldTypeString, alias: flow_type, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• concessional (type: esriFieldTypeString, alias: concessional, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• flow_class (type: esriFieldTypeString, alias: flow_class, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• sector_code (type: esriFieldTypeInteger, alias: sector_code, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• sector_name (type: esriFieldTypeString, alias: sector_name, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• funding_agencies (type: esriFieldTypeString, alias: funding_agencies, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• funding_agencies_type (type: esriFieldTypeString, alias: funding_agencies_type, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• cofinanced (type: esriFieldTypeString, alias: cofinanced, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• cofinancing_agencies (type: esriFieldTypeString, alias: cofinancing_agencies, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• cofinancing_agencies_type (type: esriFieldTypeString, alias: cofinancing_agencies_type, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• cofinancing_agencies_origin (type: esriFieldTypeString, alias: cofinancing_agencies_origin, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• receiving_agencies (type: esriFieldTypeString, alias: receiving_agencies, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• receiving_agencies_type (type: esriFieldTypeString, alias: receiving_agencies_type, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• receiving_agencies_origin (type: esriFieldTypeString, alias: receiving_agencies_origin, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• implementing_agencies (type: esriFieldTypeString, alias: implementing_agencies, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• implementing_agencies_type (type: esriFieldTypeString, alias: implementing_agencies_type, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• implementing_agencies_origin (type: esriFieldTypeString, alias: implementing_agencies_origin, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• accountable_agencies (type: esriFieldTypeString, alias: accountable_agencies, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• accountable_agencies_type (type: esriFieldTypeString, alias: accountable_agencies_type, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• accountable_agencies_origin (type: esriFieldTypeString, alias: accountable_agencies_origin, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• amount_original_currency (type: esriFieldTypeString, alias: amount_original_currency, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• original_currency (type: esriFieldTypeString, alias: original_currency, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• amount_constant_usd2017 (type: esriFieldTypeDouble, alias: amount_constant_usd2017, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• amount_nominal (type: esriFieldTypeDouble, alias: amount_nominal, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• planned_implementation_start_da (type: esriFieldTypeDate, alias: planned_implementation_start_date, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• planned_completion_date (type: esriFieldTypeDate, alias: planned_completion_date, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• actual_implementation_start_dat (type: esriFieldTypeDate, alias: actual_implementation_start_date, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• actual_completion_date (type: esriFieldTypeDate, alias: actual_completion_date, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• loan_type (type: esriFieldTypeString, alias: loan_type, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• maturity (type: esriFieldTypeDouble, alias: maturity, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• interest_rate (type: esriFieldTypeString, alias: interest_rate, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• grace_period (type: esriFieldTypeString, alias: grace_period, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• management_fee (type: esriFieldTypeDouble, alias: management_fee, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• commitment_fee (type: esriFieldTypeDouble, alias: commitment_fee, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• grant_element (type: esriFieldTypeDouble, alias: grant_element, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• guarantee_provided (type: esriFieldTypeString, alias: guarantee_provided, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• insurance_provided (type: esriFieldTypeString, alias: insurance_provided, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• collateralized_securitized (type: esriFieldTypeString, alias: collateralized_securitized, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• collateral (type: esriFieldTypeString, alias: collateral, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• official_source_count (type: esriFieldTypeInteger, alias: official_source_count, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• unofficial_source_count (type: esriFieldTypeInteger, alias: unofficial_source_count, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• source_urls (type: esriFieldTypeString, alias: source_urls, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
• source_titles (type: esriFieldTypeString, alias: source_titles, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
• source_publishers (type: esriFieldTypeString, alias: source_publishers, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• source_type (type: esriFieldTypeString, alias: source_type, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• location_details (type: esriFieldTypeString, alias: location_details, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
• geojson_url_viz (type: esriFieldTypeString, alias: geojson_url_viz, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• geojson_url_dl (type: esriFieldTypeString, alias: geojson_url_dl, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• contact_name (type: esriFieldTypeString, alias: contact_name, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• contact_position (type: esriFieldTypeString, alias: contact_position, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• oda_eligible_recipient (type: esriFieldTypeString, alias: oda_eligible_recipient, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• source_quality_score (type: esriFieldTypeInteger, alias: source_quality_score, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• data_completeness_score (type: esriFieldTypeInteger, alias: data_completeness_score, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• project_implementation_score (type: esriFieldTypeInteger, alias: project_implementation_score, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• loan_detail_score (type: esriFieldTypeInteger, alias: loan_detail_score, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/13/2023 4:55:18 PM

Schema Last Edit Date: 8/13/2023 4:55:18 PM

Data Last Edit Date: 8/13/2023 4:55:18 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat