aurora_standard.styoempr
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| fac_no | char(3) | YES | ||||
| tax_year | char(4) | YES | ||||
| empl_code | char(6) | YES | ||||
| empl_name | char(40) | YES | ||||
| soc_sec_num | char(11) | YES | ||||
| empl_add1 | char(60) | YES | ||||
| empl_city | char(40) | YES | ||||
| empl_state | char(2) | YES | ||||
| empl_zip | char(10) | YES | ||||
| empl_country | char(30) | YES | ||||
| cov_code_all | char(2) | YES | ||||
| cov_code_jan | char(2) | YES | ||||
| cov_code_feb | char(2) | YES | ||||
| cov_code_mar | char(2) | YES | ||||
| cov_code_apr | char(2) | YES | ||||
| cov_code_may | char(2) | YES | ||||
| cov_code_jun | char(2) | YES | ||||
| cov_code_jul | char(2) | YES | ||||
| cov_code_aug | char(2) | YES | ||||
| cov_code_sep | char(2) | YES | ||||
| cov_code_oct | char(2) | YES | ||||
| cov_code_nov | char(2) | YES | ||||
| cov_code_dec | char(2) | YES | ||||
| min_cost_all | decimal(10,2) | YES | ||||
| min_cost_jan | decimal(10,2) | YES | ||||
| min_cost_feb | decimal(10,2) | YES | ||||
| min_cost_mar | decimal(10,2) | YES | ||||
| min_cost_apr | decimal(10,2) | YES | ||||
| min_cost_may | decimal(10,2) | YES | ||||
| min_cost_jun | decimal(10,2) | YES | ||||
| min_cost_jul | decimal(10,2) | YES | ||||
| min_cost_aug | decimal(10,2) | YES | ||||
| min_cost_sep | decimal(10,2) | YES | ||||
| min_cost_oct | decimal(10,2) | YES | ||||
| min_cost_nov | decimal(10,2) | YES | ||||
| min_cost_dec | decimal(10,2) | YES | ||||
| code4980h_all | char(10) | YES | ||||
| code4980h_jan | char(10) | YES | ||||
| code4980h_feb | char(10) | YES | ||||
| code4980h_mar | char(10) | YES | ||||
| code4980h_apr | char(10) | YES | ||||
| code4980h_may | char(10) | YES | ||||
| code4980h_jun | char(10) | YES | ||||
| code4980h_jul | char(10) | YES | ||||
| code4980h_aug | char(10) | YES | ||||
| code4980h_sep | char(10) | YES | ||||
| code4980h_oct | char(10) | YES | ||||
| code4980h_nov | char(10) | YES | ||||
| code4980h_dec | char(10) | YES | ||||
| void_entry | char(1) | YES | ||||
| corrected_entry | char(1) | YES | ||||
| empl_lname | char(30) | YES | ||||
| empl_fname | char(20) | YES | ||||
| empl_mname | char(20) | YES | ||||
| empl_suffix | char(4) | YES | ||||
| chs_rowID | bigint(20) unsigned | NO | PRI | auto_increment | ||
| start_month_code | varchar(2) | NO | ||||
| is_corrected | int(1) | NO | 0 | |||
| corrected_record_id | varchar(200) | YES |