|
id
|
int(10) unsigned
|
|
|
|
|
reference_no
|
varchar(30)
|
|
|
|
|
employee_id
|
int(10) unsigned
|
|
|
|
|
department_id
|
int(10) unsigned
|
|
|
|
|
employee_name
|
varchar(200)
|
|
|
|
|
overtime_date
|
date
|
|
|
|
|
day_type
|
enum
|
-- |
|
regular
|
|
scheduled_start
|
time
|
|
|
|
|
scheduled_end
|
time
|
|
|
|
|
time_in
|
datetime
|
|
|
|
|
time_out
|
datetime
|
|
|
|
|
break_minutes
|
int(11)
|
|
|
0
|
|
elapsed_minutes
|
int(11)
|
|
|
0
|
|
worked_minutes
|
int(11)
|
|
|
0
|
|
ot_minutes
|
int(11)
|
|
|
0
|
|
rule_id
|
int(10) unsigned
|
|
|
|
|
calc_notes
|
varchar(500)
|
|
|
|
|
needs_review
|
tinyint(1)
|
|
|
0
|
|
review_reason
|
varchar(500)
|
|
|
|
|
reason
|
varchar(500)
|
|
|
|
|
remarks
|
varchar(500)
|
|
|
|
|
status
|
enum
|
-- |
|
pending
|
|
source
|
enum
|
-- |
|
manual
|
|
batch_id
|
int(10) unsigned
|
|
|
Browse foreign values
|
|
encoded_by
|
int(10) unsigned
|
|
|
|
|
encoded_at
|
datetime
|
|
|
current_timestamp()
|
|
decided_by
|
int(10) unsigned
|
|
|
|
|
decided_at
|
datetime
|
|
|
|
|
decision_remarks
|
varchar(500)
|
|
|
|
|
updated_by
|
int(10) unsigned
|
|
|
|
|
updated_at
|
datetime
|
|
|
|
|
deleted_at
|
datetime
|
|
|
|
|
deleted_by
|
int(10) unsigned
|
|
|
|