training

Currently, managing EV station setup activities lacks structured tracking, leading to delays and poor visibility on progress and bottlenecks.

We need to implement a step-wise station setup tracking system to monitor each stage of station deployment with clear ownership, status, and audit logs.

Objective:

Create a centralized system to track all station setup steps with:

Real-time status visibility
Ownership tracking
Delay identification
Historical audit logs
Scope of Work:
1. Station Setup Steps Tracking

Create a structured workflow to track below steps per station:

Electricity Connection
Civil Work / Foundation
Machine (Charger) Setup
Canopy Setup
Network Setup
Camera Setup
Fire & Safety Setup
Software Configuration
Testing & Commissioning
Final Go-Live

Each step should have:

Status: In Progress / On Hold / Completed
Assigned Owner
Dependency (optional)
Remarks (for delay/issues)
Follow-up Date
2. Database Design

Table: station_setup_steps

id (PK)
station_id (FK)
step_name
status
assigned_to
dependency
remark
follow_up_date
updated_by
updated_date

Table: station_setup_logs (Audit Trail)

id (PK)
station_setup_step_id (FK)
old_status
new_status
remark
assigned_to
updated_by
updated_date
3. Functional Requirements
Ability to update step status
Capture remarks for “On Hold” scenarios
Track ownership per step
Maintain history of all status changes
View all steps for a station in a single dashboard
4. Reporting / Dashboard
Station-wise progress tracking
Identify delayed steps
Highlight blockers (On Hold cases)
Completion percentage per station
Acceptance Criteria:
All station setup steps are configurable and trackable
Status updates reflect in real-time
Audit logs capture every change
Users can identify delays and responsible owners
Dashboard shows clear progress per station
Priority: High
Type: Feature / Enhancement
Business Impact:
Improves visibility on station setup progress
Reduces delays by identifying bottlenecks early
Ensures accountability across teams
Standardizes deployment process