Concordia International School Hanoi

Eliminated column count mismatches between the downloadable sample template and the operational staff export output.

• Standardized a 43-column structure with an exact 1-to-1 match between Download Sample CSV and Export Staff.
• Added PassportExpiry (Passport Expiration Date) at column 29, DependentsCount at column 42, and ReportsTo at column 43.
• The Export Staff output automatically resolves and displays the **Supervisor's Work Email** for each employee to provide immediate visibility into reporting lines.

Supports entering the direct supervisor's work email directly in the CSV template during bulk staff imports.

• Flexible Resolution: The ReportsTo column accepts either the **Supervisor's Work Email** (e.g., supervisor@concordiahanoi.edu) or their **StaffID**. Supported header aliases include: ReportsTo, Reports To, SupervisorEmail, Supervisor.
• Two-Pass Resolution Engine: Pass 1 creates/updates the primary employee records; Pass 2 links supervisor references across the entire dataset, even if the supervisor is listed after direct reports in the same file.
• Added clear contextual guidance directly inside the CSV Import modal in index.html.

Resolved an issue where supervisors could not view or approve historical pending requests after their work email was changed.

• Firestore Security Rules (firestore.rules): Updated request update permissions to check department supervisor status via isSupervisor(), removing reliance solely on legacy static email strings.
• Automated Synchronization (Cascade Sync & Auto-heal): Updating an employee's work email now automatically migrates all open Pending leave requests to the new email and updates the supervisorConfig mapping.

The database is already automatically backed up daily via Cloud Functions at 02:00 AM ICT, making the manual download reminder obsolete.

• Removed the red overdue reminder banner #backupReminderAlert from the Admin Dashboard.
• Full on-demand manual backup and JSON restoration remains accessible in Settings ➔ Backup & Restore.

Ensured direct reporting line priority is respected uniformly across all approval workflows.

• Leave Management: Checks reportsTo before falling back to department supervisor.
• Purchasing Module: Auto-populates approver details using reportsTo before department fallback.
• Professional Development (PD Module): Auto-populates approver details using reportsTo before department fallback.

Prevented unauthorized auto-approval when submitting on behalf for leave types flagged with "Approved by HOS" or unpaid leaves.

• Strict Status Assignment: Requests configured with approvedByHOS: true submitted on behalf are set to Pending and routed directly to the Head of School.
• Modal UI Preview: Dynamically displays "Will be reviewed by HOS: [HOS Name]" in primary blue styling instead of the auto-approved banner.
• Approval Guard: Restricted approval capability exclusively to the Head of School and System Administrators; shielded requests against auto-healing reassignment.