QMT_STAFF Table

EMPID LNAME FNAME DEPARTMENT JOB YEARS SALARY COMMISSION
110 SIMPSON MIKE 120 MGR 7 18,380.15 000500.00
120 PETREE STEVE 120 SALES 8 18,193.90 01,664.73
130 MILES LISA 138 MGR 5 17,529.00  
145 BACON CARL 138 SALES 2 15,000.00 01,008.66
150 HANSON KATHY 115 MGR 10 20,682.45  
165 MYERS ROGER 138 SALES 3 16,830.00 01,102.23
170 RODMAN CHUCK 115 SALES 7 16,525.48 02,204.28
180 JASON JOHN 120 CLERK   13,527.25 01,180.48
190 BEAGLE HUTCH 142 SALES 6 18,024.40 02,438.98
200 WENTZ STEVEEN 142 MGR 7 18,375.45  
210 ARNA ISMETT 115 CLERK 5 12,530.85 01,258.88
225 MACKEY DONNA 138 CLERK 1 12,077.00 000139.28
230 YAMAGUCHI KATRINA 142 CLERK 6 10,528.55 01,127.88
240 FRITZE MARY ANN 151 MGR 6 21,172.65  
250 WILLIAMS DOUG 151 SALES 6 19,479.15 01,689.93
260 MOLITOR MITCH 110 MGR 7 22,981.85 01,500.00
270 KERMIT JASON 115 CLERK 4 12,281.15 01,162.38
280 ABLE OTTO 138 CLERK 3 12,032.00 01,288.78
290 SNEAD XIAOLIN 120 CLERK 8 14,275.40 01,178.78
300 SCOTT ARLENE 142 CLERK   11,531.25 01,136.48
310 KUANG CHUNG 110 MGR 10 20,032.65  
320 SMITHERS JOHN 151 SALES 7 17,677.15 02,045.08
330 LILLY CRAIG 151 CLERK 3 13,392.45 01,241.93
340 DAVISON DAJUN 110 MGR 5 19,282.90  
350 WHITEHURS MIKE 151 CLERK 6 14,482.65 01,565.58
360 JANNET JIM 110 MGR 12 21,256.65  
370 STROM RAYMOND 166 MGR 9 18,578.15  
380 WILLIAMS ROBERT 166 SALES 9 18,697.15 01,863.78
390 QUILT CHRISTINE 184 MGR 10 19,840.65  
400 DAVIDSON STORM 184 SALES 5 15,477.15 01,858.38
410 GRASON BILLY 166 SALES 13 21,022.65 01,252.58
420 GONZALES RENEA 166 SALES 4 16,880.85 01,896.28
430 BURRELS RUSTY 166 CLERK 1 11,010.65 01,107.78
440 EDEN EDDIE 184 SALES 7 17,866.65 02,337.28
450 GAGNEY GREG 184 CLERK 5 13,053.15 01,240.28
140 BROOKS DAVID 138 SALES 6 25,000.00 02,008.66
160 MISSON STEVEN 138 SALES 3 16,800.00 01,900.23
220 MASSON STEFANIE 138 CLERK 5 22,077.00 02,139.28
142 STANCEL WILLIAM 138 SALES   12,000.00 000088.66
133 ELDER NANCY 138 MGR 2 16,529.00  
255 KENNER CAL 151 SALES 2 13,479.15 01,000.00