Layers:

Layer: apramed_survey (0)


Name: apramed_survey

Display Field: objectid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

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:

XMin: -180
YMin: -90
XMax: 180
YMax: 90
Spatial Reference: 4326 (4326)


Drawing Info:

{"labelingInfo":null,"renderer":{"description":"Survey Data Locations","label":"APRAMED","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:

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)
• nom_enqueteur (type: esriFieldTypeString, alias: Enumerator name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• date_enquete (type: esriFieldTypeDate, alias: Date of survey, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• email_enqueteur (type: esriFieldTypeString, alias: Enumerator's email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• telephone_enqueteur (type: esriFieldTypeString, alias: Enumerator's phone number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• nom_etablissement (type: esriFieldTypeString, alias: Facility name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• pays (type: esriFieldTypeString, alias: Country, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [angola: Angola], [benin: Benin], [botswana: Botswana], ... 43 more ...)
• district (type: esriFieldTypeString, alias: Town/City, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• facility_type (type: esriFieldTypeString, alias: Facility Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [public: Public], [private: Private])
• type_etablissement (type: esriFieldTypeString, alias: Facility Level, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [hospital_district: District Hospital], [hospital_regional: Regional Hospital], [hospital_national: National Hospital], ... 5 more ...)
• gratuit (type: esriFieldTypeString, alias: Are medicines provided for free to patients at this facility?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• monnaie_utilisee (type: esriFieldTypeString, alias: Currency in which prices collected, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [dzd: Algerian dinar (DZD)], [aoa: Angolan kwanza (AOA)], [bwp: Botswana pula (BWP)], ... 38 more ...)
• obstacles_stock (type: esriFieldTypeString, alias: Obstacles reported by the facility to maintain stock, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• obstacle_autre (type: esriFieldTypeString, alias: Other obstacles, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• review_message (type: esriFieldTypeString, alias: Please review your answers above. If you wish to make changes, go back to the relevant section. If all is correct, you can submit the form., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ready_to_submit (type: esriFieldTypeString, alias: Are you ready to submit this form?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• 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)
• titre_survey (type: esriFieldTypeString, alias: APRAMED-African prices and availability medicines platform, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• logo (type: esriFieldTypeString, alias: logo, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• explication_survey (type: esriFieldTypeString, alias: A regional survey to measure the availability and affordability of 108 essential medicines in the WHO African Region using harmonized methods and sentinel site reporting., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Templates:

Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:


Relationships:
• APRAMED_medicaments (1) -- Related To: medicaments (1)
Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/28/2025 1:44:42 PM

Schema Last Edit Date: 7/28/2025 1:44:42 PM

Data Last Edit Date: 7/28/2025 1:44:33 PM

Tables:

medicaments (1)


Name: medicaments

Display Field: objectid

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

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: 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)
• nom_medicament (type: esriFieldTypeString, alias: Medicine name (INN), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [category_cancer: 📘 CANCER], [doxorubicin_10_mg_(hydrochloride)_in_5_ml: Doxorubicin 10 mg (hydrochloride) in 5 mL vial – Injection – L01DB01], [docetaxel_20_mg/0.5_ml: Docetaxel 20 mg/0.5 mL – Injection – L01CD02], ... 118 more ...)
• ob_brand_name (type: esriFieldTypeString, alias: ob_brand_name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ob_display (type: esriFieldTypeString, alias: Originator Brand Brand:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• dispo_ob (type: esriFieldTypeString, alias: Availability - Originator Brand, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [na: Not applicable])
• prix_ob (type: esriFieldTypeDouble, alias: Price of Originator Brand pack, SQL Type: sqlTypeOther, nullable: true, editable: true)
• taille_ob (type: esriFieldTypeString, alias: Originator Brand pack size, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• fabricant_ob (type: esriFieldTypeString, alias: Originator Brand manufacturer, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• dispo_lpg (type: esriFieldTypeString, alias: Availability - Lowest Priced Generic, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• prix_lpg (type: esriFieldTypeDouble, alias: Price of Lowest Priced Generic pack, SQL Type: sqlTypeOther, nullable: true, editable: true)
• taille_lpg (type: esriFieldTypeDouble, alias: Lowest Priced Generic pack size, SQL Type: sqlTypeOther, nullable: true, editable: true)
• unit_price_lpg (type: esriFieldTypeString, alias: unit_price_lpg, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• unit_price_lpg_note (type: esriFieldTypeString, alias: Unit price (LPG):, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• fabricant_lpg (type: esriFieldTypeString, alias: Lowest Priced Generic manufacturer name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• rupture_stock (type: esriFieldTypeString, alias: Was this medicine out of stock in the last 6 months?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• stockout_duration_days (type: esriFieldTypeDouble, alias: How long was the product out of stock (in days)?, SQL Type: sqlTypeOther, 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:
• APRAMED_medicaments (1) -- Related To: apramed_survey (0)
Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/28/2025 1:44:42 PM

Schema Last Edit Date: 7/28/2025 1:44:42 PM

Data Last Edit Date: 7/28/2025 1:44:33 PM