pdfjae.blogg.se

– out_note, store the reason of punch-out data – in_note, store the reason of punch-in data – punchout_time, store the punch-out time data – punchin_time, store the punch-in time data – employee_id, store the employee ID data, it associated with table ‘hs_hr_employee’ on field ‘emp_number’ – attendance_id, store the ID of time attendance log, it should be auto-increment, but we don’t know why it is not Let we explain one-by-one of those fields. | timestamp_diff | int(11) | NO | | NULL | | | out_note | varchar(250) | YES | | NULL | | | in_note | varchar(250) | YES | | NULL | | | punchout_time | datetime | YES | | NULL | |

| punchin_time | datetime | YES | | NULL | | | employee_id | int(11) | NO | | NULL | | | attendance_id | int(11) | NO | PRI | NULL | | | Field | Type | Null | Key | Default | Extra | By the way, we are using OrangeHRM version 2.5.0.2 by the time of this writing. Here is the structure of ‘hs_hr_attendance’ table. We will focus on how to import the data from fingerprint time attendance data ’1_attlog.dat’ to OrangeHRM database that store the time attendance data.