a04p2Insurance.accdb
| EmployeeID | LastName | FirstName | Gender | Title | Salary | Location | Performance | HireDate |
| 1 | Lacher | Tom | M | T01 | 31200.0 | L01 | Good | 3/7/11 |
| 2 | Fantis | Laurie | F | T01 | 28000.0 | L01 | Good | 1/11/11 |
| 3 | Fleming | Karen | F | T01 | 41100.0 | L01 | Average | 12/15/09 |
| 4 | Mc Key | Boo | F | T01 | 39600.0 | L01 | Good | 7/29/12 |
| 5 | Daniels | Phil | M | T01 | 42600.0 | L01 | Good | 2/5/11 |
| 6 | Park | Johnny | M | T01 | 48400.0 | L01 | Excellent | 9/9/11 |
| 7 | Johnson | Debbie | F | T01 | 39700.0 | L01 | Excellent | 6/23/12 |
| 8 | Drubin | Lolly | F | T01 | 37000.0 | L01 | Good | 9/12/09 |
| 9 | Titley | David | M | T01 | 40200.0 | L01 | Good | 1/22/12 |
| 10 | Grippando | Joan | F | T01 | 26100.0 | L01 | Average | 8/30/10 |
| 11 | Block | Leonard | M | T01 | 26200.0 | L01 | Excellent | 12/13/10 |
| 12 | Mills | Jack | M | T01 | 44600.0 | L01 | Average | 11/6/08 |
| 13 | Nagel | Mimi | F | T01 | 46200.0 | L01 | Average | 12/29/10 |
| 14 | Rammos | Mitzi | F | T01 | 32500.0 | L01 | Excellent | 6/9/06 |
| 15 | Vieth | Paula | F | T01 | 40400.0 | L01 | Good | 5/17/12 |
| 16 | Novicheck | Deborah | F | T01 | 46800.0 | L01 | Good | 11/25/08 |
| 17 | Brumbaugh | Paige | F | T01 | 49300.0 | L01 | Average | 12/25/09 |
| 18 | Abrams | Wendy | F | T01 | 47500.0 | L01 | Good | 5/24/12 |
| 19 | Harrison | Jenifer | F | T01 | 44800.0 | L01 | Excellent | 10/19/12 |
| 20 | Gander | John | M | T01 | 38400.0 | L01 | Average | 12/31/08 |
| 21 | Sell | Mike | M | T01 | 43500.0 | L01 | Excellent | 10/10/06 |
| 22 | Smith | Denise | F | T01 | 45200.0 | L01 | Average | 1/22/11 |
| 23 | Pawley | Eleanor | F | T01 | 42700.0 | L01 | Excellent | 12/18/08 |
| 24 | Harris | Jennifer | F | T01 | 34900.0 | L02 | Average | 12/13/10 |
| 25 | North | Randy | M | T01 | 31700.0 | L02 | Excellent | 9/12/09 |
| 26 | Shuffield | Jan | F | T01 | 33700.0 | L02 | Good | 4/24/11 |
| 27 | Barnes | Jeb | M | T01 | 46900.0 | L02 | Excellent | 9/9/11 |
| 28 | Michael | Bea | F | T01 | 32000.0 | L02 | Poor | 3/26/12 |
| 29 | Strafaci | Betty | F | T01 | 44200.0 | L02 | Good | 3/4/08 |
| 30 | Edelman | Linda | F | T01 | 49000.0 | L02 | Good | 11/1/09 |
| 31 | Center | Michelle | F | T01 | 25200.0 | L02 | Excellent | 6/21/11 |
| 32 | Fishe | Karen | F | T01 | 25600.0 | L02 | Good | 11/7/09 |
| 33 | Parsley | Eileen | F | T01 | 25700.0 | L02 | Good | 4/1/09 |
| 34 | Brasington | Shelly | F | T01 | 27200.0 | L02 | Excellent | 8/7/02 |
| 35 | Park | Tiffany | F | T01 | 27200.0 | L02 | Average | 7/16/03 |
| 36 | Dill | Marjorie | F | T01 | 40600.0 | L02 | Excellent | 2/8/09 |
| 37 | Whiting | Kathy | F | T01 | 46900.0 | L02 | Good | 2/19/11 |
| 38 | Ronald | Margaret | F | T01 | 36900.0 | L02 | Excellent | 9/25/11 |
| 39 | Gonzalez | Frank | M | T01 | 44700.0 | L02 | Good | 11/28/03 |
| 40 | Freyre | Julianne | F | T01 | 44000.0 | L02 | Average | 9/7/01 |
| 41 | Morrison | Andrea | F | T01 | 42300.0 | L02 | Good | 6/9/05 |
| 42 | Jones | Hank | M | T01 | 42700.0 | L02 | Good | 10/14/11 |
| 43 | Vandalay | Susan | F | T01 | 48200.0 | L02 | Good | 10/5/12 |
| 44 | Powell | Monica | F | T01 | 43900.0 | L02 | Good | 5/2/11 |
| 45 | Holly | Gwen | F | T01 | 35200.0 | L02 | Good | 3/3/04 |
| 46 | Lykes | Caryn | F | T01 | 40900.0 | L02 | Average | 11/20/09 |
| 47 | Tobin | Yolanda | F | T01 | 38600.0 | L03 | Good | 10/23/09 |
| 48 | Buhler | Natalee | F | T01 | 46400.0 | L03 | Excellent | 3/25/01 |
| 49 | Bob | Susan | F | T01 | 31900.0 | L03 | Average | 11/9/06 |
| 50 | Mills | Marion | F | T01 | 44700.0 | L03 | Good | 4/23/04 |
| 51 | Flint | Arnold | M | T01 | 40000.0 | L03 | Average | 2/28/12 |
| 52 | Newcomm | Henry | M | T01 | 30900.0 | L03 | Average | 3/27/04 |
| 53 | Guilford | Jerry | M | T01 | 28800.0 | L03 | Average | 7/29/09 |
| 54 | Duffy | Liz | F | T01 | 27200.0 | L03 | Excellent | 2/15/00 |
| 55 | Aikman | Dino | M | T01 | 45200.0 | L03 | Average | 2/15/10 |
| 56 | Heatley | Jane | F | T01 | 27800.0 | L03 | Average | 7/29/03 |
| 57 | Payne | Joan | F | T01 | 38900.0 | L03 | Average | 6/5/05 |
| 58 | Rapee | Missy | F | T01 | 49000.0 | L03 | Excellent | 9/5/00 |
| 59 | Voell | Michelle | F | T01 | 32500.0 | L03 | Average | 12/13/10 |
| 60 | Park | Jack | M | T01 | 49200.0 | L03 | Excellent | 3/17/10 |
| 61 | Sheridan | Judy | F | T01 | 44300.0 | L03 | Excellent | 7/5/11 |
| 62 | Lane | Chris | F | T01 | 32800.0 | L03 | Good | 9/30/00 |
| 63 | Ogilby | Cheryl | F | T01 | 45000.0 | L03 | Excellent | 6/28/02 |
| 64 | George | Julia | F | T01 | 42200.0 | L03 | Excellent | 2/15/10 |
| 65 | Johnson | Jimmy | M | T01 | 44900.0 | L03 | Average | 12/19/04 |
| 66 | Fascfius | Ken | M | T01 | 39000.0 | L03 | Average | 11/1/09 |
| 67 | Snead | Crystal | F | T01 | 47900.0 | L03 | Excellent | 9/6/10 |
| 68 | McClain | Eleanor | F | T01 | 46900.0 | L03 | Average | 8/30/10 |
| 69 | Davidson | Mary | F | T01 | 45000.0 | L03 | Average | 2/19/10 |
| 70 | Ship | Joellen | F | T01 | 32800.0 | L04 | Average | 8/10/06 |
| 71 | Spillis | Steve | M | T01 | 49000.0 | L04 | Good | 6/21/00 |
| 72 | Anderson | Valerie | F | T01 | 49900.0 | L04 | Good | 4/23/02 |
| 73 | Payne | Reggie | M | T01 | 40700.0 | L04 | Good | 4/24/08 |
| 74 | Trane | Larry | M | T01 | 42900.0 | L04 | Average | 4/25/03 |
| 75 | Cambell | Morgan | F | T01 | 25100.0 | L04 | Average | 8/15/10 |
| 76 | Felsher | Laura | F | T01 | 25600.0 | L04 | Excellent | 1/17/00 |
| 77 | Mills | Barbara | F | T01 | 25800.0 | L04 | Average | 3/31/07 |
| 78 | Parker | Terri | F | T01 | 30300.0 | L04 | Average | 1/19/13 |
| 79 | Ray | Clay | M | T01 | 29400.0 | L04 | Excellent | 7/4/11 |
| 80 | Glasson | Cynthia | F | T01 | 33100.0 | L04 | Average | 2/28/00 |
| 81 | Ford | Julie | F | T01 | 38400.0 | L04 | Average | 4/25/07 |
| 82 | Guiterrez | Joan | F | T01 | 39000.0 | L04 | Average | 11/12/03 |
| 83 | Walker | Bob | M | T01 | 27600.0 | L04 | Average | 5/20/08 |
| 84 | Newman | Lynn | F | T01 | 33500.0 | L04 | Excellent | 6/14/10 |
| 85 | Bobbitt | Mike | M | T01 | 41300.0 | L04 | Excellent | 3/4/00 |
| 86 | Eckblom | Lisa | F | T01 | 37200.0 | L04 | Good | 6/30/01 |
| 87 | Herst | Heidi | F | T01 | 40600.0 | L04 | Average | 1/11/11 |
| 88 | De Maria | Oronzo | M | T01 | 43200.0 | L04 | Average | 11/27/09 |
| 89 | Mcdowell | George | M | T01 | 33000.0 | L04 | Average | 6/21/11 |
| 90 | O'Keefe | Barbara | F | T01 | 40200.0 | L04 | Average | 4/19/09 |
| 91 | Johnson | Michael | M | T01 | 49100.0 | L04 | Average | 6/15/10 |
| 92 | Lazarus | Kathleen | F | T01 | 48500.0 | L04 | Excellent | 3/17/10 |
| 93 | Bailey | Robert | M | T01 | 39900.0 | L05 | Excellent | 3/26/12 |
| 94 | Nichols | Kathy | F | T01 | 32000.0 | L05 | Excellent | 2/26/08 |
| 95 | Jones | Danette | F | T01 | 41800.0 | L05 | Good | 11/23/12 |
| 96 | Trice | Suzy | F | T01 | 47600.0 | L05 | Poor | 6/12/11 |
| 97 | Stack | Scott | M | T01 | 37900.0 | L05 | Poor | 10/19/04 |
| 98 | Hoffman | Heidi | F | T01 | 25200.0 | L05 | Average | 8/14/02 |
| 99 | Diamond | Gary | M | T01 | 26500.0 | L05 | Excellent | 11/7/11 |
| 100 | Fischler | Laura | F | T01 | 30500.0 | L05 | Good | 4/22/09 |
| 101 | Restery | Barney | M | T01 | 39600.0 | L05 | Excellent | 9/10/03 |
| 102 | Goldstein | Manny | M | T01 | 33100.0 | L05 | Good | 8/15/10 |
| 103 | Moran | Angela | F | T01 | 44200.0 | L05 | Average | 5/20/13 |
| 104 | Pearce | Ramsey | F | T01 | 41300.0 | L05 | Excellent | 11/5/02 |
| 105 | Carlo | Morgan | F | T01 | 28900.0 | L05 | Excellent | 1/26/09 |
| 106 | Parmenter | Robert | M | T01 | 35900.0 | L05 | Excellent | 6/16/09 |
| 107 | Freyer | Cynthia | F | T01 | 29900.0 | L05 | Poor | 6/17/10 |
| 108 | Bonds | Sofi | F | T01 | 40800.0 | L05 | Excellent | 2/27/00 |
| 109 | McGrath | Becky | F | T01 | 46100.0 | L05 | Excellent | 10/31/12 |
| 110 | Lazenby | Jeff | M | T01 | 32300.0 | L05 | Good | 1/7/06 |
| 111 | Eckblom | Linda | F | T01 | 41600.0 | L05 | Excellent | 6/1/05 |
| 112 | Shubin | Jan | F | T01 | 40100.0 | L05 | Excellent | 3/17/10 |
| 113 | Paige | Maryanne | F | T01 | 47300.0 | L05 | Excellent | 1/22/12 |
| 114 | Wharton | Jerry | M | T01 | 47100.0 | L05 | Excellent | 2/7/02 |
| 115 | Hagood | Jo Ellen | F | T01 | 41700.0 | L05 | Good | 3/25/04 |
| 116 | Bland | Jane | F | T01 | 38000.0 | L06 | Average | 12/26/10 |
| 117 | Thompson | Ashley | F | T01 | 43200.0 | L06 | Excellent | 11/27/09 |
| 118 | Krissel | Chriss | F | T01 | 36200.0 | L06 | Average | 5/26/06 |
| 119 | Vergaldi | Mark | M | T01 | 25100.0 | L06 | Excellent | 4/23/09 |
| 120 | Dowling | Marilyn | F | T01 | 32400.0 | L06 | Average | 5/6/09 |
| 121 | Mc Dougal | Bridget | F | T01 | 49300.0 | L06 | Excellent | 6/21/11 |
| 122 | Fairbairn | Ron | M | T01 | 49300.0 | L06 | Good | 12/26/10 |
| 123 | Wynperle | Betsy | F | T01 | 29500.0 | L06 | Average | 12/30/09 |
| 124 | Murphy | Paula | F | T01 | 45600.0 | L06 | Good | 10/22/09 |
| 125 | Smith | Jessica | F | T01 | 37200.0 | L06 | Good | 4/24/11 |
| 126 | Miller | Barbara | F | T01 | 41800.0 | L06 | Excellent | 8/19/09 |
| 127 | Cybert | Emit | M | T01 | 40600.0 | L06 | Average | 12/26/10 |
| 128 | Jenks | Jean | F | T01 | 44700.0 | L06 | Excellent | 5/9/09 |
| 129 | Scola | Kolleen | F | T01 | 31700.0 | L06 | Excellent | 3/1/08 |
| 130 | Brownell | Pat | F | T01 | 45300.0 | L06 | Good | 5/29/04 |
| 131 | Worley | Gary | M | T01 | 34500.0 | L07 | Average | 1/6/07 |
| 132 | Smith | Johnny | M | T01 | 46600.0 | L07 | Poor | 4/17/11 |
| 133 | Schultz | Judge | M | T01 | 29300.0 | L07 | Poor | 11/15/02 |
| 134 | Jefferson | Debbie | F | T01 | 36700.0 | L07 | Good | 3/18/12 |
| 135 | Everett | Kyle | M | T01 | 29300.0 | L07 | Excellent | 7/9/04 |
| 136 | Mason | Cara | F | T01 | 46600.0 | L07 | Good | 9/7/08 |
| 137 | Corlett | Meg | F | T01 | 27300.0 | L07 | Excellent | 3/16/00 |
| 138 | Kickman | George | M | T01 | 47600.0 | L07 | Excellent | 1/5/10 |
| 139 | Brown | Patsy | F | T01 | 45000.0 | L07 | Average | 9/13/07 |
| 140 | Munroe | Alexandra | F | T01 | 31400.0 | L07 | Average | 9/12/05 |
| 141 | Bianch | Arthur | M | T01 | 34500.0 | L07 | Average | 7/27/06 |
| 142 | Thomas | Kenny | M | T01 | 42400.0 | L07 | Excellent | 10/3/06 |
| 143 | Erpf | Dan | M | T01 | 41800.0 | L08 | Average | 3/18/12 |
| 144 | Tamer | Bill | M | T01 | 47800.0 | L08 | Average | 4/20/11 |
| 145 | Maragni | Cindy | F | T01 | 26000.0 | L08 | Average | 6/6/12 |
| 146 | Sade | Leslie | F | T01 | 27000.0 | L08 | Average | 12/15/09 |
| 147 | Kahn | Crystal | F | T01 | 46700.0 | L08 | Average | 12/25/09 |
| 148 | Mulva | Allison | F | T01 | 46500.0 | L08 | Average | 8/23/09 |
| 149 | Bell | Roni | M | T01 | 38400.0 | L08 | Average | 6/13/09 |
| 150 | Wood | Debby | F | T01 | 36800.0 | L08 | Good | 9/1/09 |
| 151 | Smith | Fred | M | T01 | 30300.0 | L08 | Good | 1/25/08 |
| 152 | Houtz | Frances | F | T01 | 45300.0 | L08 | Good | 1/31/08 |
| 153 | Brockhouse | Kevin | M | T01 | 42600.0 | L08 | Average | 10/4/11 |
| 154 | Cole | Melissa | F | T01 | 31800.0 | L08 | Excellent | 9/9/11 |
| 155 | Cooper | Rick | M | T01 | 26300.0 | L09 | Average | 10/20/05 |
| 156 | Martin | Carole | F | T01 | 27100.0 | L09 | Excellent | 4/9/09 |
| 157 | Smith | Deborah | F | T01 | 27100.0 | L09 | Average | 9/7/12 |
| 158 | Munroe | Agnes | F | T01 | 43200.0 | L09 | Average | 6/8/03 |
| 159 | Tarbe | Barbara | F | T01 | 33700.0 | L09 | Average | 12/10/11 |
| 160 | Sapp | Kristen | F | T01 | 39600.0 | L09 | Good | 4/22/11 |
| 161 | Bermont | William | M | T01 | 48200.0 | L09 | Average | 9/30/11 |
| 162 | Brooks | Patty | F | T01 | 49200.0 | L09 | Good | 10/1/10 |
| 163 | Kelly | Clara | F | T01 | 42500.0 | L09 | Good | 12/16/04 |
| 164 | Wood | Courtny | F | T01 | 45800.0 | L09 | Good | 8/30/10 |
| 165 | Evans | Lenore | F | T01 | 36800.0 | L09 | Average | 9/6/10 |
| 166 | Huling | Fran | F | T01 | 45000.0 | L09 | Excellent | 7/23/02 |
| 167 | Bartolini | Bart | M | T01 | 44200.0 | L10 | Excellent | 12/25/09 |
| 168 | Wilson | Holly | F | T01 | 25700.0 | L10 | Good | 4/22/11 |
| 169 | Justice | Dainey | F | T01 | 25800.0 | L10 | Good | 7/6/08 |
| 170 | Bray | Sarah | F | T01 | 26900.0 | L10 | Excellent | 4/28/11 |
| 171 | Edmunds | George | M | T01 | 49500.0 | L10 | Good | 10/10/11 |
| 172 | Magenheimer | Carolyn | F | T01 | 42600.0 | L10 | Average | 9/1/12 |
| 173 | Hood | Georgia | F | T01 | 27400.0 | L10 | Good | 2/22/04 |
| 174 | Strump | Betsy | F | T01 | 49000.0 | L10 | Excellent | 12/15/09 |
| 175 | Morteleo | Judson | M | T01 | 42700.0 | L10 | Average | 5/30/12 |
| 176 | Siegal | Jamie | F | T01 | 41300.0 | L10 | Average | 12/1/01 |
| 177 | Cleos | Michele | F | T01 | 29400.0 | L10 | Average | 5/2/11 |
| 178 | Ross | Bobby | M | T01 | 29600.0 | L10 | Good | 1/11/11 |
| 179 | Battle | Susannah | F | T01 | 43900.0 | L11 | Good | 7/20/00 |
| 180 | Edmunds | Jack | M | T01 | 46700.0 | L11 | Good | 4/20/11 |
| 181 | Cobb | Meredith | F | T01 | 30100.0 | L11 | Good | 5/2/11 |
| 182 | Skor | Jessica | F | T01 | 42400.0 | L11 | Average | 2/5/11 |
| 183 | Strump | Jay | M | T01 | 45600.0 | L11 | Average | 11/20/09 |
| 184 | Brickey | Sandra | F | T01 | 49600.0 | L11 | Average | 6/14/04 |
| 185 | Moss | Amy | F | T01 | 41100.0 | L11 | Excellent | 11/20/09 |
| 186 | Hopkins | Garth | F | T01 | 42200.0 | L11 | Good | 5/30/12 |
| 187 | Ruble | Troy | M | T01 | 45500.0 | L11 | Average | 12/1/04 |
| 188 | Winnick | Hildee | F | T01 | 31400.0 | L11 | Excellent | 4/9/10 |
| 189 | Kahl | Elian | M | T01 | 49000.0 | L11 | Excellent | 3/9/05 |
| 190 | Manning | Caroline | F | T01 | 27800.0 | L11 | Good | 10/23/09 |
| 191 | Wiggins | Kathy | F | T02 | 74200.0 | L01 | Excellent | 7/15/12 |
| 192 | Starke | John | M | T02 | 77100.0 | L02 | Good | 5/25/10 |
| 193 | Kollner | Christy | F | T02 | 84600.0 | L03 | Excellent | 5/24/06 |
| 194 | Brawner | Shari | F | T02 | 84400.0 | L03 | Good | 4/22/11 |
| 195 | Boss | Sissy | F | T02 | 76300.0 | L04 | Good | 9/10/11 |
| 196 | Munter | Bryan | M | T02 | 71500.0 | L04 | Excellent | 5/17/09 |
| 197 | Roberts | Margie | F | T02 | 70900.0 | L05 | Good | 8/24/04 |
| 198 | Figure | Laura | F | T02 | 95000.0 | L06 | Good | 2/20/09 |
| 199 | Chiavacci | Dan | M | T02 | 70000.0 | L07 | Excellent | 2/3/07 |
| 200 | Elway | Linda | F | T02 | 71800.0 | L08 | Average | 4/6/13 |
| 201 | Cole | Moe | M | T02 | 74500.0 | L09 | Excellent | 11/28/05 |
| 202 | Anderson | Vicki | F | T04 | 47900.0 | L01 | Excellent | 9/21/08 |
| 203 | McCammon | Johnny | M | T04 | 43100.0 | L01 | Average | 6/22/12 |
| 204 | Rudy | Libby | F | T04 | 40300.0 | L01 | Good | 4/23/12 |
| 205 | Bichette | Susan | F | T04 | 61500.0 | L01 | Good | 9/10/12 |
| 206 | Newman | Adam | M | T04 | 45000.0 | L01 | Average | 10/12/06 |
| 207 | Sosar | Wiliam | M | T04 | 51300.0 | L01 | Excellent | 6/19/09 |
| 208 | Imber | Elise | F | T04 | 63700.0 | L01 | Average | 1/22/11 |
| 209 | Valls | Susan | F | T04 | 57500.0 | L01 | Excellent | 4/28/11 |
| 210 | Davis | Martha | F | T04 | 51900.0 | L01 | Excellent | 6/14/10 |
| 211 | Williamson | Jo-Ann | F | T04 | 37100.0 | L01 | Average | 10/9/09 |
| 212 | Wilkinson | Jodi | F | T04 | 59500.0 | L02 | Average | 11/30/08 |
| 213 | Kelly | Burt | M | T04 | 63000.0 | L02 | Good | 9/16/00 |
| 214 | Fegin | Laurie | F | T04 | 44300.0 | L02 | Excellent | 2/20/12 |
| 215 | Alworth | Wendy | F | T04 | 56200.0 | L02 | Good | 3/3/06 |
| 216 | Smart | Diane | F | T04 | 35300.0 | L02 | Good | 12/29/10 |
| 217 | Battle | Susan | F | T04 | 37000.0 | L02 | Good | 8/20/05 |
| 218 | Moynahan | Allison | F | T04 | 35700.0 | L02 | Average | 12/14/01 |
| 219 | Tilghman | Arianne | F | T04 | 61900.0 | L02 | Excellent | 9/7/12 |
| 220 | Brett | Cameron | M | T04 | 41400.0 | L02 | Average | 11/13/05 |
| 221 | Pennekamp | Gary | M | T04 | 42600.0 | L02 | Excellent | 2/8/12 |
| 222 | McKinney | Becky | F | T04 | 62900.0 | L03 | Excellent | 7/2/11 |
| 223 | Billingslea | Susan | F | T04 | 54200.0 | L03 | Good | 2/25/09 |
| 224 | Noble | John | M | T04 | 39200.0 | L03 | Excellent | 11/10/10 |
| 225 | Drier | Lolly | F | T04 | 52600.0 | L03 | Poor | 1/3/11 |
| 226 | Armstrong | Ringo | M | T04 | 53500.0 | L03 | Excellent | 7/2/11 |
| 227 | Woods | Cherie | F | T04 | 41000.0 | L03 | Good | 12/29/10 |
| 228 | Adams | Bret | M | T04 | 56200.0 | L03 | Good | 9/6/10 |
| 229 | Isenbergh | Dinah | F | T04 | 57800.0 | L03 | Average | 2/8/05 |
| 230 | Spinale | Hunter | M | T04 | 37800.0 | L03 | Average | 8/10/09 |
| 231 | Schobelock | Kristen | F | T04 | 61400.0 | L03 | Excellent | 1/9/11 |
| 232 | Vieth | Mimi | F | T04 | 49800.0 | L03 | Average | 2/18/10 |
| 233 | Bocholis | Sue | F | T04 | 48500.0 | L04 | Good | 2/8/12 |
| 234 | Ashley | Tina | F | T04 | 51900.0 | L04 | Good | 6/16/05 |
| 235 | Adams | Ben | M | T04 | 45900.0 | L04 | Excellent | 3/4/07 |
| 236 | Jackson | John | M | T04 | 42600.0 | L04 | Good | 10/4/11 |
| 237 | Moll | Barbara | F | T04 | 52000.0 | L04 | Average | 2/5/11 |
| 238 | Dunes | David | M | T04 | 46000.0 | L04 | Good | 7/31/10 |
| 239 | Watson | Mary | F | T04 | 64500.0 | L04 | Average | 4/9/11 |
| 240 | Sharp | Judy | F | T04 | 62700.0 | L04 | Good | 2/28/12 |
| 241 | O'Donell | Criste | F | T04 | 57600.0 | L04 | Good | 1/18/10 |
| 242 | Sussman | Ryan | M | T04 | 58000.0 | L04 | Excellent | 4/24/11 |
| 243 | Woods | Claudia | F | T04 | 47500.0 | L04 | Average | 1/27/11 |
| 244 | Bogani | Sonia | F | T04 | 44600.0 | L05 | Good | 4/15/03 |
| 245 | Young | Beth | F | T04 | 43300.0 | L05 | Excellent | 2/20/11 |
| 246 | Watt | Jimmy | M | T04 | 60200.0 | L05 | Average | 9/13/06 |
| 247 | Afflord | Lance | M | T04 | 59100.0 | L05 | Average | 2/12/12 |
| 248 | Mosely | Ana Marie | F | T04 | 64800.0 | L05 | Good | 6/6/07 |
| 249 | Jamison | Diane | F | T04 | 53700.0 | L05 | Good | 5/24/02 |
| 250 | Bartolini | Suzie | F | T04 | 63000.0 | L05 | Average | 5/23/00 |
| 251 | Shindell | Johanna | F | T04 | 43800.0 | L05 | Average | 10/8/11 |
| 252 | Sywolski | Annette | F | T04 | 35600.0 | L05 | Good | 9/10/11 |
| 253 | Evans | Leann | F | T04 | 39300.0 | L05 | Excellent | 4/20/11 |
| 254 | Park | Terry | F | T04 | 46100.0 | L05 | Excellent | 7/2/11 |
| 255 | Houston | Galia | F | T04 | 43300.0 | L06 | Good | 7/4/10 |
| 256 | Mc Cammon | Cantillon | F | T04 | 45400.0 | L06 | Good | 7/25/09 |
| 257 | Rodriguez | Margaret | F | T04 | 45000.0 | L06 | Excellent | 6/14/10 |
| 258 | Munroe | Sylvia | F | T04 | 54400.0 | L06 | Excellent | 11/4/08 |
| 259 | Crowder | Mary | F | T04 | 60900.0 | L06 | Excellent | 10/31/09 |
| 260 | Lundeen | Cathy | F | T04 | 59500.0 | L07 | Average | 4/28/11 |
| 261 | Reid | Harold | M | T04 | 48500.0 | L07 | Good | 8/2/12 |
| 262 | Cookson | John | M | T04 | 43200.0 | L07 | Excellent | 10/17/01 |
| 263 | Hasty | Jeanne | F | T04 | 63800.0 | L07 | Average | 7/11/01 |
| 264 | Lederman | Eric | M | T04 | 40400.0 | L08 | Good | 6/27/09 |
| 265 | Ray | Brian | M | T04 | 58000.0 | L08 | Excellent | 3/6/10 |
| 266 | Glassman | Juli | F | T04 | 42300.0 | L08 | Excellent | 1/5/10 |
| 267 | Cambell | Nancy | F | T04 | 62000.0 | L08 | Good | 1/22/11 |
| 268 | Goyette | Alonzo | M | T04 | 49200.0 | L09 | Excellent | 9/19/08 |
| 269 | Reed | Maylou | F | T04 | 48200.0 | L09 | Good | 6/17/01 |
| 270 | Leslie | Cheryl | F | T04 | 42900.0 | L09 | Good | 5/15/11 |
| 271 | Collins | Megan | F | T04 | 42200.0 | L09 | Average | 3/30/01 |
| 272 | Felser | Laurie | F | T04 | 51000.0 | L10 | Average | 10/13/03 |
| 273 | Brinckerhoff | Ruth | F | T04 | 60100.0 | L10 | Good | 10/3/04 |
| 274 | Posten | Pauline | F | T04 | 60500.0 | L10 | Good | 8/2/09 |
| 275 | Kirsman | Cindy | F | T04 | 37300.0 | L10 | Average | 7/14/10 |
| 276 | Prider | Ben | M | T04 | 63200.0 | L11 | Average | 8/15/10 |
| 277 | Foerster | June | F | T04 | 45700.0 | L11 | Average | 6/12/11 |
| 278 | Knight | Cindy | F | T04 | 46300.0 | L11 | Good | 2/19/10 |
| 279 | Brockway | Jim | M | T04 | 55400.0 | L11 | Average | 9/10/11 |
| 280 | Brown | Patricia | F | T03 | 20100.0 | L01 | Excellent | 6/12/11 |
| 281 | Johnshon | Billy | M | T03 | 21800.0 | L01 | Average | 4/28/12 |
| 282 | Simon | Holly | F | T03 | 18500.0 | L01 | Average | 11/8/12 |
| 283 | Pfleger | Penny | F | T03 | 21800.0 | L02 | Average | 9/15/04 |
| 284 | Weber | Lorna | F | T03 | 21700.0 | L02 | Average | 3/10/09 |
| 285 | Cusak | Frank | M | T03 | 18700.0 | L02 | Excellent | 5/3/08 |
| 286 | Beamer | Brian | M | T03 | 20900.0 | L02 | Good | 8/30/08 |
| 287 | Smith | Denie | F | T03 | 19800.0 | L03 | Excellent | 1/5/10 |
| 288 | Liler | Mark | M | T03 | 22700.0 | L03 | Excellent | 2/12/02 |
| 289 | Bryan | Ofe | F | T03 | 18300.0 | L03 | Average | 5/27/09 |
| 290 | Sotolongo | Cristi | F | T03 | 21400.0 | L04 | Poor | 6/5/04 |
| 291 | Clarke | Michelle | F | T03 | 21500.0 | L04 | Average | 11/27/09 |
| 292 | Lobree | Celeste | F | T03 | 18200.0 | L04 | Good | 3/13/05 |
| 293 | Corlett | McClendon | F | T03 | 22000.0 | L05 | Average | 10/21/12 |
| 294 | Moore | Marion | F | T03 | 18700.0 | L05 | Average | 1/30/01 |
| 295 | Stieglitz | Cheryl | F | T03 | 20500.0 | L05 | Good | 2/15/10 |
| 296 | Halloway | Jill | F | T03 | 21800.0 | L06 | Good | 3/4/08 |
| 297 | Scott | Kelly | F | T03 | 18400.0 | L06 | Average | 4/14/10 |
| 298 | Granger | Gerry | M | T03 | 20500.0 | L07 | Poor | 12/30/08 |
| 299 | Sampieri | Jimmy | M | T03 | 21700.0 | L07 | Good | 8/26/07 |
| 300 | Robins | Tony | M | T03 | 21700.0 | L08 | Poor | 4/22/08 |
| 301 | Zachar | Anita | F | T03 | 19500.0 | L08 | Excellent | 2/20/12 |
| 302 | Eastcott | Lisa | F | T03 | 20500.0 | L08 | Good | 7/14/13 |
| 303 | Edelstein | Francis | M | T03 | 19200.0 | L09 | Excellent | 7/8/07 |
| 304 | Rodriguez | Kordell | M | T03 | 19300.0 | L09 | Excellent | 12/3/04 |
| 305 | Zaytown | Eleanor | F | T03 | 19900.0 | L09 | Good | 8/13/10 |
| 306 | Porter | Peggy | F | T03 | 20600.0 | L10 | Poor | 10/14/11 |
| 307 | Dellis | Phil | M | T03 | 19600.0 | L10 | Average | 10/7/09 |
| 308 | White | Leslie | F | T03 | 19600.0 | L10 | Excellent | 3/4/07 |
| 309 | Witherspoon | Nick | M | T03 | 21300.0 | L11 | Poor | 10/25/09 |
| 310 | Dorn | Marjorie | F | T03 | 18100.0 | L11 | Good | 2/19/10 |
| 311 | Quinton | Mike | M | T03 | 19200.0 | L11 | Excellent | 8/22/11 |
| LocationID | Location | Address | State | Zipcode | OfficePhone |
| L01 | Atlanta | 450 Peachtree Road | GA | 30316 | (555) 333-5555 |
| L02 | Boston | 3 Commons Blvd | MA | 02190 | (555) 123-4444 |
| L03 | Pittsburgh | 15 Forbes Avenue | PA | 15219 | (555) 555-1111 |
| L04 | Kansas City | 3750 River Road | MO | 64101 | (555) 555-9998 |
| L05 | New York | 3495 Fifth Avenue, Suite 33998 | NY | 10029 | (555) 555-6654 |
| L06 | San Francisco | 44 Montgomery Street | CA | 94102 | (555) 555-3737 |
| L07 | Chicago | 500 Loop Highway | IL | 60620 | (555) 444-6666 |
| L08 | Miami | 1417 NE 136th St | FL | 33018 | (555) 555-0098 |
| L09 | Phoenix | 4535 N. 23rd Ave | AZ | 85001 | (555) 555-0098 |
| L10 | Orlando | 1000 Kirkman Road | FL | 32801 | (555) 555-5555 |
| L11 | Los Angeles | 1000 Rodeo Drive | CA | 90210 | (555) 666-6666 |
| TitleID | Title | Description | EducationRequired | MinimumSalary | MaximumSalary | 2012Increase |
| T01 | Account Rep | A marketing position requiring a technical background. Employees begin with a fixed salary, then switch to a combination of salary and commission. | Four year degree | 25000 | 75000 | 0.03 |
| T02 | Manager | A supervisory position requiring at least 5 years in the company or an equivalent industrial experience. Primary responsibility is to help the Account Reps in a sales capacity. | Four year degree | 50000 | 150000 | 0.04 |
| T03 | Trainee | An entry-level position in which the employee interns at several functional areas in the corporation. The normal training period lasts approximately one year. | Two year degree | 18000 | 25000 | 0.05 |
| T04 | SeniorRep | A senior, non supervisory position | Four Year Degree | 45000 | 150000 | 0.04 |
SELECT Employees.Location, Employees.LastName, Employees.FirstName, Employees.HireDate, Employees.Salary, Titles.[2012Increase], [Salary]*[2012Increase] AS 2012Raise, DatePart("yyyy",[HireDate]) AS YearHired, DatePart("yyyy",Date())-[YearHired] AS YearsWorked
FROM Titles INNER JOIN Employees ON Titles.TitleID = Employees.Title;
Mo7ammedaziz 
