id | int(5) |
|
|
|
site | varchar(10) |
|
|
|
e_code | varchar(30) |
|
|
|
card_no | int(40) |
|
|
|
employee | int(10) |
|
|
|
shift_category | varchar(40) |
|
|
|
shift_start | time |
|
|
|
shiftstart_AMPM | varchar(5) |
|
|
|
shift_end | time |
|
|
|
shiftend_AMPM | varchar(5) |
|
|
|
time_in | varchar(10) |
|
|
|
timein_AMPM | varchar(5) |
|
|
|
time_out | time |
|
|
|
timeout_AMPM | varchar(5) |
|
|
|
late_arrival | time |
|
|
|
office_hours | time |
|
|
|
work_hrs | time |
|
|
|
ot_hrs | time |
|
|
|
leave_code | varchar(20) |
|
|
|
out_date | date |
|
|
|
attendance_date | date |
|
|
|
created_date | date |
|
|
|
attendance_day | varchar(5) |
|
|
|
attendance_month | varchar(5) |
|
|
|
attendance_year | varchar(5) |
|
|
|
pres_abs | varchar(50) |
|
|
|
others | text |
|
|
|
created_by | varchar(10) |
|
|
|
modified_date | date |
|
|
|
companyId | int(11) |
|
|
|
biometric_emp_id | int(11) |
|
|
|