| SYSPK_afl |
decimal(10,0)
|
|
|
|
| afl_id |
int(11)
|
|
|
|
| afl_oa |
varchar(100)
|
latin1_swedish_ci
|
|
|
| afl_lname |
varchar(100)
|
latin1_swedish_ci
|
|
|
| afl_fname |
varchar(100)
|
latin1_swedish_ci
|
|
|
| afl_mname |
varchar(100)
|
latin1_swedish_ci
|
|
|
| afl_dateof |
date
|
|
|
|
| afl_position |
varchar(100)
|
latin1_swedish_ci
|
|
|
| afl_salary |
varchar(100)
|
latin1_swedish_ci
|
|
|
| afl_tolvacation |
varchar(100)
|
latin1_swedish_ci
|
|
|
| afl_toltsk |
varchar(100)
|
latin1_swedish_ci
|
|
|
| afl_tolothersy |
varchar(100)
|
latin1_swedish_ci
|
|
|
| afl_tolothersyreason |
varchar(100)
|
latin1_swedish_ci
|
|
|
| afl_tolsick |
varchar(100)
|
latin1_swedish_ci
|
|
|
| afl_tolmaternity |
varchar(100)
|
latin1_swedish_ci
|
|
|
| afl_tolother |
varchar(100)
|
latin1_swedish_ci
|
|
|
| afl_tolotherreason |
varchar(100)
|
latin1_swedish_ci
|
|
|
| afl_tolnoofwork |
varchar(100)
|
latin1_swedish_ci
|
|
|
| afl_tolinclusive1 |
varchar(100)
|
latin1_swedish_ci
|
|
|
| afl_tolinclusive2 |
varchar(100)
|
latin1_swedish_ci
|
|
|
| afl_wlwbsphil |
varchar(100)
|
latin1_swedish_ci
|
|
|
| afl_wlwbsphilwhere |
varchar(100)
|
latin1_swedish_ci
|
|
|
| afl_wlwbsabroad |
varchar(100)
|
latin1_swedish_ci
|
|
|
| afl_wlwbsabroudwhere |
varchar(100)
|
latin1_swedish_ci
|
|
|
| afl_wlwbshospital |
varchar(100)
|
latin1_swedish_ci
|
|
|
| afl_wlwbshospitalwhere |
varchar(100)
|
latin1_swedish_ci
|
|
|
| afl_wlwbspatient |
varchar(100)
|
latin1_swedish_ci
|
|
|
| afl_wlwbspatientwhere |
varchar(100)
|
latin1_swedish_ci
|
|
|
| afl_wlwbsreq |
varchar(100)
|
latin1_swedish_ci
|
|
|
| afl_wlwbsnotreq |
varchar(100)
|
latin1_swedish_ci
|
|
|
| afl_wlwbsappli |
varchar(100)
|
latin1_swedish_ci
|
|
|
| afl_clcasofdate |
date
|
|
|
|
| afl_clcv1 |
varchar(100)
|
latin1_swedish_ci
|
|
|
| afl_clcv2 |
varchar(100)
|
latin1_swedish_ci
|
|
|
| afl_clcv3 |
varchar(100)
|
latin1_swedish_ci
|
|
|
| afl_clcs1 |
varchar(100)
|
latin1_swedish_ci
|
|
|
| afl_clcs2 |
varchar(100)
|
latin1_swedish_ci
|
|
|
| afl_clcs3 |
varchar(100)
|
latin1_swedish_ci
|
|
|
| afl_clct1 |
varchar(100)
|
latin1_swedish_ci
|
|
|
| afl_clct2 |
varchar(100)
|
latin1_swedish_ci
|
|
|
| afl_clct3 |
varchar(100)
|
latin1_swedish_ci
|
|
|
| afl_clcpofficer |
varchar(100)
|
latin1_swedish_ci
|
|
|
| afl_rapprov |
varchar(100)
|
latin1_swedish_ci
|
|
|
| afl_rdisapprov |
varchar(100)
|
latin1_swedish_ci
|
|
|
| afl_rdisapprovreason |
varchar(100)
|
latin1_swedish_ci
|
|
|
| afl_rLBCMD |
varchar(100)
|
latin1_swedish_ci
|
|
|
| afl_afdwp |
varchar(100)
|
latin1_swedish_ci
|
|
|
| afl_afdwoutp |
varchar(100)
|
latin1_swedish_ci
|
|
|
| afl_afother |
varchar(100)
|
latin1_swedish_ci
|
|
|
| afl_ddt1 |
varchar(100)
|
latin1_swedish_ci
|
|
|
| afl_ddt2 |
varchar(100)
|
latin1_swedish_ci
|
|
|
