| id |
int(10)
|
|
|
|
| ref_no |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| employee_id |
int(10)
|
|
|
Browse foreign values
|
| ot_date |
date
|
|
|
|
| time_in |
time
|
|
|
|
| time_out |
time
|
|
|
|
| start_dt |
datetime
|
|
|
|
| end_dt |
datetime
|
|
|
|
| break_minutes |
int(11)
|
|
|
|
| total_hours |
decimal(6,2)
|
|
|
|
| premium_hours |
decimal(6,2)
|
|
|
|
| excess_hours |
decimal(6,2)
|
|
|
|
| nd_hours |
decimal(6,2)
|
|
|
|
| day_type |
varchar(10)
|
utf8mb4_unicode_ci
|
|
|
| rd_override |
tinyint(1)
|
|
|
|
| hourly_rate |
decimal(10,4)
|
|
|
|
| base_rate |
decimal(6,4)
|
|
|
|
| ot_rate |
decimal(6,4)
|
|
|
|
| nd_rate |
decimal(6,4)
|
|
|
|
| amount |
decimal(12,2)
|
|
|
|
| project |
varchar(120)
|
utf8mb4_unicode_ci
|
|
|
| reason |
text
|
utf8mb4_unicode_ci
|
|
|
| remarks |
text
|
utf8mb4_unicode_ci
|
|
|
| attachment_path |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| attachment_name |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| status |
enum('draft', 'submitted', 'approved', 'verified', 'rejected', 'returned', 'cancelled')
|
utf8mb4_unicode_ci
|
|
|
| last_reason |
text
|
utf8mb4_unicode_ci
|
|
|
| flagged |
tinyint(1)
|
|
|
|
| flag_note |
text
|
utf8mb4_unicode_ci
|
|
|
| flagged_by |
int(10)
|
|
|
|
| flagged_at |
datetime
|
|
|
|
| cutoff_id |
int(10)
|
|
|
|
| encoded_by |
int(10)
|
|
|
|
| approved_by |
int(10)
|
|
|
|
| approved_at |
datetime
|
|
|
|
| verified_by |
int(10)
|
|
|
|
| verified_at |
datetime
|
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|
| deleted_at |
datetime
|
|
|
|