CCA-CF Survey Application
A web application for conducting Common Country Assessment (CCA) and Cooperation Framework (CF) surveys, designed for the United Nations' standardized assessment and planning processes.
Overview
The CCA-CF Survey Application is a Flask-based platform with Azure Cosmos DB database, providing a scalable and powerful solution for conducting standardized surveys related to UN development assessments. The application streamlines the process of collecting, managing, and reviewing assessment data for United Nations country planning initiatives.
Built specifically for UN workflows, the platform supports both Common Country Assessment (CCA) and Cooperation Framework (CF) survey types, with role-based access control, progress tracking, and scheduled review rounds for comprehensive country assessments. The system leverages OpenAI to generate country-level summary documents analyzing human rights issues from collected survey data.
Key Features
Authentication System
Secure user login/logout with role-based access control for admin and survey participants
Admin Portal
Comprehensive user and country management with system dashboard for oversight
Dual Survey System
Support for both CCA and CF survey types with section-based questionnaires
Progress Tracking
Automatic tracking of survey completion status across all sections
Review Rounds
Scheduled review periods with specific country and survey type configurations
Cosmos DB Storage
Azure Cosmos DB provides scalable NoSQL database for survey and user data management
AI-Powered Summaries
OpenAI integration generates comprehensive country-level summary documents analyzing human rights issues
Document Management
Comprehensive document management system with categorization and user-based access control stored in Azure Blob Storage
Azure Deployment
GitHub Actions workflow for automated deployment to Azure App Service
Survey Types
Common Country Assessment (CCA)
A comprehensive assessment of the country's human rights situation and development challenges for UN planning purposes. Evaluates social, economic, and environmental factors to inform strategic planning.
Cooperation Framework (CF)
An evaluation of the UN planning framework for cooperation with the country's development goals. Aligns UN activities with national priorities and Sustainable Development Goals.
Technical Architecture
The application is built on Flask with a modular architecture that separates authentication, surveys, and admin functionality. Azure Cosmos DB provides scalable NoSQL database storage for survey data, while Azure Blob Storage handles document management with secure, time-limited access links. OpenAI integration generates comprehensive country-level summaries from survey responses.
Core Components
- • Flask web framework with modular blueprints
- • Azure Cosmos DB for scalable data persistence
- • Role-based authentication and authorization
- • Section-based survey questionnaire system
Azure & AI Integration
- • Azure Cosmos DB for document storage
- • Azure Blob Storage for file management
- • OpenAI for human rights summary generation
- • GitHub Actions CI/CD pipeline
Application Workflow
1. User Authentication
Admin creates users with temporary passwords. Users login and access country-specific surveys based on their assigned roles.
2. Survey Access
Users select between CCA or CF survey types from the dashboard and begin completing section-based questionnaires.
3. Progress Tracking
System automatically tracks completion status for each section, providing visibility into survey progress.
4. Review & Submission
Completed surveys enter scheduled review rounds where admins can review submissions and provide feedback before finalization.
Document Management
The application features a comprehensive document management system with multiple categorization options and granular user-based access control. Documents are securely stored in Azure Blob Storage, with permissions managed at the user and role level to ensure appropriate access to sensitive assessment materials and country-specific documentation.