aurora_standard.hhtclokd
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| empl_code | varchar(6) | YES | MUL | |||
| inc_code | varchar(6) | YES | ||||
| inc_number | time | YES | ||||
| inc_hours | time | YES | ||||
| department | varchar(3) | YES | MUL | |||
| trans_date_in | date | YES | MUL | |||
| trans_time_in | time | YES | ||||
| trans_type_in | varchar(1) | YES | ||||
| trans_date_out | date | YES | ||||
| trans_time_out | time | YES | ||||
| trans_type_out | varchar(1) | YES | ||||
| trans_source | varchar(1) | YES | ||||
| shift | varchar(6) | YES | ||||
| function_type | varchar(1) | YES | ||||
| processed_date | date | YES | ||||
| ot_code | varchar(6) | YES | ||||
| lunch_taken | varchar(1) | YES | ||||
| fac_no | varchar(3) | YES | ||||
| paid_inc_code | varchar(6) | YES | ||||
| paid_diff_code | varchar(6) | YES | ||||
| actual_time_out | time | YES | ||||
| actual_time_in | time | YES | ||||
| empl_type | varchar(6) | YES | ||||
| clockin_ip | varchar(20) | YES | ||||
| clockout_ip | varchar(20) | YES | ||||
| shift_diff_code | varchar(6) | YES | ||||
| invoice_num | varchar(15) | YES | ||||
| invoice_date | date | YES | ||||
| inv_reconciled | varchar(1) | YES | ||||
| inv_vendor_code | varchar(6) | YES | ||||
| chs_rowID | bigint(20) unsigned | NO | PRI | auto_increment |