aurora_standard.chpempir
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| empl_code | varchar(6) | YES | ||||
| company_no | smallint(6) | YES | ||||
| certif_no | varchar(20) | YES | ||||
| group_name | varchar(20) | YES | ||||
| group_no | varchar(20) | YES | ||||
| beginning_date | date | YES | ||||
| birthdate | date | YES | ||||
| release_info | varchar(1) | YES | ||||
| assign_benefits | varchar(1) | YES | ||||
| ending_date | date | YES | ||||
| on_cobra | varchar(1) | YES | ||||
| on_fmla | varchar(1) | YES | ||||
| policy_status | varchar(1) | YES | ||||
| fmla_begdate | date | YES | ||||
| fmla_enddate | date | YES | ||||
| pretax | varchar(1) | YES | ||||
| add_benefit | varchar(1) | YES | ||||
| employee_ded | decimal(16,2) | YES | ||||
| dependent_ded | decimal(16,2) | YES | ||||
| life_amount | decimal(16,2) | YES | ||||
| membership_type | varchar(1) | YES | ||||
| benefit_code | varchar(6) | YES | ||||
| chs_rowID | bigint(20) unsigned | NO | PRI | auto_increment |