DATABASE DIRECTORY
RAW_DATA_VIEWER // READ_ONLY_ACCESS
| ID | Name | Password | Address | Dept | Roles | Job Type | Status | Balance (Ann/Acc) | Dayoff | Experience | Salary | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Jack John | jack.john@guc.edu.eg | 123 | new cairo | MET | Teaching Assistant | full_time | active | 30 / 6 | Saturday | 0 | 40000.00 |
| 2 | Ahmed Zaki | ahmed.zaki@guc.edu.eg | 345 | New Giza | BI | Teaching Assistant | full_time | active | 27 / 0 | Saturday | 2 | 48000.00 |
| 3 | Sarah Sabry | sarah.sabry@guc.edu.eg | 567 | Korba | MET | Lecturer | full_time | active | 0 / 4 | Thursday | 5 | 72000.00 |
| 4 | Ahmed Helmy | ahmed.helmy@guc.edu.eg | 908 | new Cairo | HR | HR_Representative_BI | full_time | active | 8 / 4 | Thursday | 2 | 65000.00 |
| 5 | Menna Shalaby | menna.shalaby@guc.edu.eg | 670 | Heliopolis | HR | HR_Representative_MET | full_time | active | 6 / 2 | Saturday | 0 | 50000.00 |
| 6 | Mohamed Ahmed | mohamed.ahmedy@guc.edu.eg | 9087 | Nasr City | BI | Lecturer | part_time | active | / 6 | Saturday | 7 | 82800.00 |
| 7 | Esraa Ahmed | esraa.ahmedy@guc.edu.eg | 5690 | New Cairo | Medical | Medical Doctor | full_time | active | 36 / 6 | Saturday | 2 | 42000.00 |
| 8 | Magy Zaki | magy.zaki@guc.edu.eg | 3790 | 6th of October city | BI | Teaching Assistant | full_time | onleave | 0 / 6 | Thursday | 4 | 56000.00 |
| 9 | Amr Diab | amr.diab@guc.edu.eg | 8954 | Heliopolis | MET | Teaching Assistant | full_time | active | 10 / 10 | Saturday | 4 | 56000.00 |
| 10 | Marwan Khaled | marwan.Khaled@guc.edu.eg | 9023 | New Cairo | HR | HR Manager | full_time | active | / | Saturday | 12 | 189600.00 |
| 11 | Hazem Ali | hazem.ali@guc.edu.eg | h@123 | New Giza | MET | Dean, Lecturer | full_time | active | 55 / 25 | Saturday | 30 | 207000.00 |
| 12 | Hadeel Adel | hadeel.adel@guc.edu.eg | ha@123 | Korba | MET | Lecturer, Vice Dean | full_time | active | 3 / 12 | Saturday | 20 | 153000.00 |
| 13 | Ali Mohamed | ali.mohamed@guc.edu.eg | am@123 | New Cairo | - | Dean, Lecturer | full_time | active | / | Saturday | 35 | 234000.00 |
| 14 | Donia Tarek | donia.tarek@guc.edu.eg | dt@123 | New Cairo | - | Lecturer, Vice Dean | full_time | active | / | Saturday | 22 | 163800.00 |
| 15 | Karim Abdelaziz | karim.abdelaziz@guc.edu.eg | ka@123 | New Cairo | MET | President | full_time | resigned | 0 / 0 | Wednesday | 4 | 200000.00 |
| 16 | Ghada Adel | ghada.adel@guc.edu.eg | ga@123 | Korba | BI | Vice President | full_time | notice_period | 0 / 4 | Saturday | 2 | 105000.00 |
| Department Name | Number of Employees |
|---|---|
| BI | 4 |
| HR | 3 |
| Medical | 1 |
| MET | 6 |
| Role Name | Title | Rank | Base Salary | % YOE | % Overtime | Annual Bal | Accidental Bal |
|---|---|---|---|---|---|---|---|
| Dean | PHD Holder | 3 | 60000.00 | 18.00 | 18.00 | 40 | 12 |
| HR Manager | Manager | 3 | 60000.00 | 18.00 | 18.00 | 40 | 12 |
| HR_Representative_BI | Representative | 4 | 50000.00 | 15.00 | 15.00 | 35 | 12 |
| HR_Representative_MET | Representative | 4 | 50000.00 | 15.00 | 15.00 | 35 | 12 |
| Lecturer | PHD Holder | 5 | 45000.00 | 12.00 | 12.00 | 30 | 12 |
| Medical Doctor | Dr | 35000.00 | 10.00 | 10.00 | 30 | 6 | |
| President | Upper Board | 1 | 100000.00 | 25.00 | 25.00 | ||
| Teaching Assistant | Master Holder | 6 | 40000.00 | 10.00 | 10.00 | 30 | 6 |
| Vice Dean | PHD Holder | 4 | 55000.00 | 15.00 | 15.00 | 35 | 12 |
| Vice President | Upper Board | 2 | 75000.00 | 20.00 | 20.00 |
| ID | Date | Emp ID | In | Out | Duration | Status |
|---|---|---|---|---|---|---|
| 1 | 9/4/2025 | 3 | 8:30 AM | 5:30 PM | 540 | attended |
| 2 | 10/2/2025 | 8 | 8:30 AM | 4:30 PM | 480 | attended |
| 3 | 10/4/2025 | 1 | 8:30 AM | 2:30 PM | 360 | attended |
| 4 | 10/27/2025 | 1 | absent | |||
| 5 | 9/8/2025 | 1 | absent | |||
| 6 | 10/15/2025 | 1 | 8:30 AM | 4:00 PM | 450 | attended |
| Req ID | Emp ID | Replacement | Start | End | Days | Status |
|---|---|---|---|---|---|---|
| 1 | 8 | 2 | 10/26/2025 | 11/1/2025 | 7 | approved |
| 2 | 12 | 11 | 10/19/2025 | 10/30/2025 | 12 | approved |
| 3 | 3 | 10 | 10/28/2025 | 10/28/2025 | 1 | PENDING |
| 4 | 11 | 12 | 10/30/2025 | 11/1/2025 | 3 | pending |
| 5 | 5 | 4 | 10/28/2025 | 10/30/2025 | 3 | pending |
| Req ID | Emp ID | Start | End | Days | Status |
|---|---|---|---|---|---|
| 6 | 1 | 10/26/2025 | 10/26/2025 | 1 | pending |
| 8 | 3 | 10/22/2025 | 10/22/2025 | 1 | pending |
| Req ID | Emp ID | Type | Details | Start | End | Status |
|---|---|---|---|---|---|---|
| 10 | 3 | maternity | 11/21/2022 | 3/21/2023 | approved | |
| 11 | 3 | maternity | 2/13/2024 | 6/13/2024 | approved | |
| 12 | 3 | maternity | 11/13/2025 | 3/13/2026 | pending | |
| 21 | 8 | sick | 11/13/2025 | 3/13/2026 | rejected |
| Req ID | Emp ID | Start | End | Days | Status |
|---|---|---|---|---|---|
| 13 | 2 | 8/13/2025 | 9/9/2025 | 28 | approved |
| 14 | 1 | 11/2/2025 | 12/13/2025 | 42 | Pending |
| 15 | 2 | 11/27/2025 | 12/2/2025 | 6 | Pending |
| 16 | 8 | 11/20/2025 | 12/2/2025 | 13 | Pending |
| Req ID | Emp ID | Reason | Original Date | Leave Date | Status |
|---|---|---|---|---|---|
| 18 | 1 | proctoring | 10/4/2025 | 10/29/2025 | pending |
| 19 | 3 | Grading | 9/4/2025 | 11/3/2025 | pending |
| Emp ID | Date | Amount | Bonus | Deductions |
|---|---|---|---|---|
| 1 | 10/1/2025 | 38666.7 | 0.00 | 1333.33 |
| 2 | 9/1/2025 | 17600.0 | 0.00 | 30400.00 |
| 2 | 10/1/2025 | 33600.0 | 0.00 | 14400.00 |
| 9 | 10/1/2025 | 52733.3 | 0.00 | 3266.66 |
| 11 | 4/1/2025 | 276540.0 | 540.00 | 0.00 |
| Emp ID | Date | Amount | Type | Status |
|---|---|---|---|---|
| 1 | 10/1/2025 | 1333.33 | missing_days | finalized |
| 1 | 10/28/2025 | 1333.33 | missing_days | pending |
| 2 | 9/1/2025 | 30400.00 | unpaid | finalized |
| 2 | 10/1/2025 | 14400.00 | unpaid | finalized |
| 10 | 10/1/2025 | 3266.66 | missing_hours | finalized |
| ID | Emp ID | Semester | Rating | Comments |
|---|---|---|---|---|
| 1 | 2 | W24 | 4 | Very od |
| 2 | 2 | S25 | 3 | od |
| 3 | 10 | W24 | 4 | Very od |
| 4 | 10 | S25 | 5 | Excellent |
| ID | Name | From | To |
|---|---|---|---|
| No holidays found. | |||