ECL Calculator - Technical Documentation

flowchart TD A[User visits application] --> B{User authenticated?} B -->|No| C[Redirect to Login Page] B -->|Yes| D[Access Dashboard] C --> E[Enter credentials] E --> F{Valid credentials?} F -->|No| G[Show error message] F -->|Yes| H[Create session] G --> C H --> D D --> I{User role?} I -->|Admin| J[Admin Dashboard] I -->|Regular User| K[User Dashboard] J --> L[Manage Users/Companies] J --> M[View Audit Logs] J --> N[System Configuration] K --> O[Create ECL Process] K --> P[View Reports] K --> Q[Manage Templates] O --> R[Upload Data Files] R --> S[Configure Parameters] S --> T[Start ECL Calculation] T --> U[Monitor Progress] U --> V[View Results] V --> W[Generate Reports] W --> X[Save as Template]

flowchart TD A[Start ECL Process] --> B[Upload Required Files] B --> C{Files valid?} C -->|No| D[Show validation errors] C -->|Yes| E[Data Validation Step] D --> B E --> F[Asset Classification] F --> G[PD Calculation] G --> H[LGD Calculation] H --> I[EAD Calculation] I --> J[ECL Computation] J --> K[Report Generation] K --> L[Process Complete] subgraph "Data Files Required" M[Loan Data CSV] N[Collateral Data CSV] O[Market Variables CSV] P[Payment History CSV] Q[Previous Provisions CSV] end B --> M B --> N B --> O B --> P B --> Q subgraph "RBI Compliance Checks" R[Asset Classification per RBI norms] S[Standard Provision Rate validation] T[DPD-based categorization] end F --> R F --> S F --> T

flowchart TD A[Admin Login] --> B[Admin Dashboard] B --> C[User Management] B --> D[Company Management] B --> E[System Monitoring] B --> F[Audit Logs] C --> G[Create New User] C --> H[Edit User Details] C --> I[Deactivate User] C --> J[Reset Password] D --> K[Add Company] D --> L[Edit Company Info] D --> M[Toggle Company Status] E --> N[View System Health] E --> O[Monitor Performance] E --> P[Check Database Status] F --> Q[View User Activities] F --> R[Filter by Date/User] F --> S[Export Audit Data] G --> T{User creation valid?} T -->|Yes| U[Send credentials to user] T -->|No| V[Show validation errors] V --> G

erDiagram User { int id PK string username UK string email UK string password_hash boolean is_admin int company_id FK datetime created_at datetime last_login boolean active } Company { int id PK string name UK text address string contact_email string contact_phone datetime registration_date boolean active } ECLProcess { int id PK string name string status datetime start_time datetime end_time text result_data int user_id FK int company_id FK int template_id FK } ProcessStep { int id PK int ecl_process_id FK string step_name string status datetime start_time datetime end_time text input_data text output_data text error_message } DataFile { int id PK int ecl_process_id FK string file_name string file_type string file_path datetime upload_date int file_size int row_count boolean validated text validation_errors } Template { int id PK string name text description text configuration int user_id FK int company_id FK datetime created_at datetime last_used } Report { int id PK string report_name string report_type datetime generation_date int ecl_process_id FK int user_id FK int company_id FK text report_data string file_path } AuditLog { int id PK int user_id FK int company_id FK string action datetime timestamp string ip_address string user_agent string resource_type int resource_id text details } Company ||--o{ User : employs Company ||--o{ ECLProcess : owns Company ||--o{ Template : creates Company ||--o{ Report : generates Company ||--o{ AuditLog : logs User ||--o{ ECLProcess : creates User ||--o{ Template : designs User ||--o{ Report : generates User ||--o{ AuditLog : performs ECLProcess ||--o{ ProcessStep : contains ECLProcess ||--o{ DataFile : uses ECLProcess ||--o{ Report : produces ECLProcess }o--|| Template : based_on Template ||--o{ ECLProcess : spawns

graph TB subgraph "Frontend Layer" WEB[Traditional Web Interface] REACT[React SPA] end subgraph "API Gateway" NGINX[Nginx Reverse Proxy] end subgraph "Application Layer" FLASK[Flask Application] GUNICORN[Gunicorn WSGI Server] end subgraph "Business Logic Layer" AUTH[Authentication Module] ECL[ECL Engine] ADMIN[Admin Module] REPORTS[Reports Module] TEMPLATES[Templates Module] API[API Module] end subgraph "Data Access Layer" ORM[SQLAlchemy ORM] MODELS[Data Models] end subgraph "Infrastructure Layer" DB[(PostgreSQL Database)] FILES[File Storage System] LOGS[Logging System] end WEB --> NGINX REACT --> NGINX NGINX --> GUNICORN GUNICORN --> FLASK FLASK --> AUTH FLASK --> ECL FLASK --> ADMIN FLASK --> REPORTS FLASK --> TEMPLATES FLASK --> API AUTH --> ORM ECL --> ORM ADMIN --> ORM REPORTS --> ORM TEMPLATES --> ORM API --> ORM ORM --> MODELS MODELS --> DB ECL --> FILES FLASK --> LOGS

classDiagram class FlaskApp { +app: Flask +db: SQLAlchemy +login_manager: LoginManager +initialize_app() +register_blueprints() } class AuthModule { +login() +logout() +register() +profile() +reset_password() } class ECLEngine { +create_process() +upload_files() +execute_calculation() +get_results() +retry_process() } class AdminModule { +manage_users() +manage_companies() +view_audit_logs() +system_configuration() } class ReportsModule { +generate_summary_report() +generate_detailed_report() +comparison_analysis() +export_data() } class TemplatesModule { +save_template() +load_template() +execute_template() +delete_template() } class APIModule { +authentication_endpoints() +ecl_process_endpoints() +admin_endpoints() +report_endpoints() } class DataModels { +User +Company +ECLProcess +ProcessStep +DataFile +Template +Report +AuditLog } FlaskApp --> AuthModule FlaskApp --> ECLEngine FlaskApp --> AdminModule FlaskApp --> ReportsModule FlaskApp --> TemplatesModule FlaskApp --> APIModule AuthModule --> DataModels ECLEngine --> DataModels AdminModule --> DataModels ReportsModule --> DataModels TemplatesModule --> DataModels APIModule --> DataModels

graph TB subgraph "Load Balancer / CDN" LB[Load Balancer] CDN[Content Delivery Network] end subgraph "Web Tier" WEB1[Web Server 1 - Nginx] WEB2[Web Server 2 - Nginx] end subgraph "Application Tier" APP1[App Server 1 - Gunicorn] APP2[App Server 2 - Gunicorn] APP3[App Server 3 - Gunicorn] end subgraph "Database Tier" DB_MASTER[(PostgreSQL Master)] DB_REPLICA[(PostgreSQL Replica)] end subgraph "Storage Tier" FILES[File Storage] BACKUP[Backup Storage] end subgraph "Monitoring & Logging" MONITOR[Monitoring System] LOGS[Log Aggregation] end USERS[Users] --> LB USERS --> CDN LB --> WEB1 LB --> WEB2 WEB1 --> APP1 WEB1 --> APP2 WEB2 --> APP2 WEB2 --> APP3 APP1 --> DB_MASTER APP2 --> DB_MASTER APP3 --> DB_MASTER DB_MASTER --> DB_REPLICA APP1 --> FILES APP2 --> FILES APP3 --> FILES DB_MASTER --> BACKUP FILES --> BACKUP APP1 --> MONITOR APP2 --> MONITOR APP3 --> MONITOR WEB1 --> LOGS WEB2 --> LOGS

classDiagram class User { +id: int +username: str +email: str +password_hash: str +is_admin: bool +company_id: int +created_at: datetime +last_login: datetime +active: bool +set_password(password) +check_password(password) +get_id() } class Company { +id: int +name: str +address: str +contact_email: str +contact_phone: str +registration_date: datetime +active: bool } class ECLProcess { +id: int +name: str +status: str +start_time: datetime +end_time: datetime +result_data: str +user_id: int +company_id: int +template_id: int +get_results() +set_results(results) } class ProcessStep { +id: int +ecl_process_id: int +step_name: str +status: str +start_time: datetime +end_time: datetime +input_data: str +output_data: str +error_message: str +get_input_data() +set_input_data(data) +get_output_data() +set_output_data(data) } class DataFile { +id: int +ecl_process_id: int +file_name: str +file_type: str +file_path: str +upload_date: datetime +file_size: int +row_count: int +validated: bool +validation_errors: str +get_validation_errors() +set_validation_errors(errors) } class Template { +id: int +name: str +description: str +configuration: str +user_id: int +company_id: int +created_at: datetime +last_used: datetime +get_config() +set_config(config) } User }|--|| Company : belongs_to ECLProcess }|--|| User : created_by ECLProcess }|--|| Company : owned_by ECLProcess ||--o{ ProcessStep : has_many ECLProcess ||--o{ DataFile : uses_many ECLProcess }o--|| Template : based_on Template }|--|| User : created_by Template }|--|| Company : owned_by