aurora_standard.kronos20
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| empl_code | varchar(6) | YES | ||||
| rec_code | varchar(2) | YES | ||||
| div_no | varchar(3) | YES | ||||
| dept_no | varchar(4) | YES | ||||
| cost_ctr | varchar(3) | YES | ||||
| shift_code | varchar(1) | YES | ||||
| job_code | varchar(3) | YES | ||||
| earn_code | varchar(2) | YES | ||||
| hours | decimal(5,2) | YES | ||||
| earnings | varchar(6) | YES | ||||
| chs_rowID | bigint(20) unsigned | NO | PRI | auto_increment |