aurora_standard.chppersr
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| empl_code | varchar(6) | YES | UNI | |||
| maiden_name | varchar(15) | YES | ||||
| nick_name | varchar(15) | YES | ||||
| on_call_phone | varchar(14) | YES | ||||
| family_physician | varchar(20) | YES | ||||
| ethnic_code | varchar(1) | YES | ||||
| blood_type | varchar(2) | YES | ||||
| marital_stat | varchar(2) | YES | ||||
| ethnic_desc | varchar(30) | YES | ||||
| shift | varchar(15) | YES | ||||
| empl_status | varchar(6) | YES | ||||
| empl_desc | varchar(10) | YES | ||||
| job_code | varchar(15) | YES | ||||
| eeoc_code | varchar(6) | YES | ||||
| status_date | date | YES | ||||
| cell_phone | varchar(14) | YES | ||||
| eeo_job_cat | varchar(6) | YES | ||||
| supervisor | varchar(6) | YES | ||||
| alt_supervisor | varchar(6) | YES | ||||
| native_amer | varchar(1) | YES | ||||
| union_code | varchar(6) | YES | ||||
| all_niners | varchar(1) | YES | ||||
| aca_1095b | varchar(2) | YES | ||||
| empl_e_mail | varchar(68) | YES | ||||
| chs_rowID | bigint(20) unsigned | NO | PRI | auto_increment |