aurora_standard.timetabl
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| empl_code | char(6) | YES | MUL | |||
| inc_code | char(6) | YES | ||||
| inc_number | decimal(6,3) | YES | ||||
| inc_hours | decimal(6,3) | YES | ||||
| department | char(3) | YES | ||||
| trans_date_in | date | YES | MUL | |||
| trans_time_in | datetime | YES | ||||
| trans_type_in | char(1) | YES | ||||
| trans_date_out | date | YES | ||||
| trans_time_out | datetime | YES | ||||
| trans_type_out | char(1) | YES | ||||
| trans_source | char(1) | YES | ||||
| shift | char(6) | YES | ||||
| function_type | char(1) | YES | ||||
| processed_date | date | YES | ||||
| ot_code | char(6) | YES | ||||
| lunch_taken | char(1) | YES | ||||
| fac_no | char(3) | YES | ||||
| paid_inc_code | char(6) | YES | ||||
| paid_diff_code | char(6) | YES | ||||
| actual_time_out | datetime | YES | ||||
| empl_type | char(6) | YES | ||||
| clockin_ip | char(20) | YES | ||||
| clockout_ip | char(20) | YES | ||||
| shift_diff_code | char(6) | YES | ||||
| which_day | smallint(6) | YES | ||||
| which_week | char(1) | YES |