
id : int(10) unsigned
|

ref_no : varchar(20)
|

employee_id : int(10) unsigned
|

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)
|

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
|

attachment_path : varchar(255)
|

attachment_name : varchar(255)
|

status : enum('draft','submitted','approved','verified','rejected','returned','cancelled')
|

last_reason : text
|

flagged : tinyint(1)
|

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
|

updated_at : datetime
|

deleted_at : datetime
|