|
id
|
int(10) unsigned
|
|
|
|
|
ref_no
|
varchar(20)
|
|
|
|
|
employee_id
|
int(10) unsigned
|
|
|
Browse foreign values
|
|
ot_date
|
date
|
|
|
|
|
time_in
|
time
|
|
|
|
|
time_out
|
time
|
|
|
|
|
start_dt
|
datetime
|
|
|
2026-11-19 14:40:19.000000
|
|
end_dt
|
datetime
|
|
|
2026-11-19 14:40:19.000000
|
|
break_minutes
|
int(11)
|
|
|
0
|
|
total_hours
|
decimal(6,2)
|
|
|
|
|
premium_hours
|
decimal(6,2)
|
|
|
0.00
|
|
excess_hours
|
decimal(6,2)
|
|
|
0.00
|
|
nd_hours
|
decimal(6,2)
|
|
|
0.00
|
|
day_type
|
varchar(10)
|
|
|
|
|
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)
|
|
|
|
|
reason
|
text
|
|
|
|
|
remarks
|
text
|
|
|
|
|
attachment_path
|
varchar(255)
|
|
|
|
|
attachment_name
|
varchar(255)
|
|
|
|
|
status
|
enum
|
-- |
|
draft
|
|
last_reason
|
text
|
|
|
|
|
flagged
|
tinyint(1)
|
|
|
0
|
|
flag_note
|
text
|
|
|
|
|
flagged_by
|
int(10) unsigned
|
|
|
|
|
flagged_at
|
datetime
|
|
|
|
|
cutoff_id
|
int(10) unsigned
|
|
|
|
|
encoded_by
|
int(10) unsigned
|
|
|
|
|
approved_by
|
int(10) unsigned
|
|
|
|
|
approved_at
|
datetime
|
|
|
|
|
verified_by
|
int(10) unsigned
|
|
|
|
|
verified_at
|
datetime
|
|
|
|
|
created_at
|
datetime
|
|
|
current_timestamp()
|
|
updated_at
|
datetime
|
|
|
|
|
deleted_at
|
datetime
|
|
|
|