Assignment1_tables.xlsx
Department
| Department |
| DNO | Dname | Address | City | State | Zip |
| 1 | Accounting | 762 Destiny way | Westlake | TX | 76062 |
| 2 | Finance | 762 Destiny way | Westlake | TX | 76062 |
| 3 | Sales | 850 Cambell Rd | Richardson | TX | 75080 |
| 4 | I.T. | 2210 Main St | Dallas | TX | 75023 |
| 5 | Marketing | 850 Cambell Rd | Richardson | TX | 75080 |
| 6 | HR | 762 Destiny way | Westlake | TX | 76062 |
| 7 | Legal | 2210 Main St | Dallas | TX | 75023 |
| 8 | Facility Mgmt | 762 Destiny way | Westlake | TX | 76062 |
Employee
| Emp ID | Name Prefix | First Name | Middle Initial | Last Name | Gender | EMail | DOB | HireDate | Salary | SSN | PhoneNo | UserName | Title | DNO |
| 677509 | Drs. | Lois | H | Walker | F | [email protected] | 3/29/81 | 11/24/03 | 168251 | 467-99-4677 | 303-572-8492 | lhwalker | Sr. Director | 5 |
| 940761 | Ms. | Brenda | S | Robinson | F | [email protected] | 7/31/70 | 7/27/08 | 51063 | 537-71-4566 | 225-945-4954 | bsrobinson | Accountant | 1 |
| 428945 | Dr. | Joe | W | Robinson | M | [email protected] | 6/16/63 | 8/3/16 | 50155 | 025-92-3584 | 219-904-2161 | jwrobinson | Accountant | 1 |
| 408351 | Drs. | Diane | I | Evans | F | [email protected] | 12/4/77 | 4/16/99 | 180294 | 314-35-9851 | 215-793-6791 | dievans | SVP Marketing | 5 |
| 193819 | Mr. | Benjamin | R | Russell | M | [email protected] | 4/17/77 | 7/25/13 | 117642 | 121-98-7248 | 262-404-2252 | brrussell | Sr. Manager | 4 |
| 499687 | Mr. | Patrick | F | Bailey | M | [email protected] | 9/27/82 | 7/22/05 | 72305 | 439-99-7721 | 319-812-6957 | pfbailey | Programmer | 4 |
| 539712 | Ms. | Nancy | T | Baker | F | [email protected] | 6/13/95 | 9/14/16 | 98189 | 641-29-2071 | 229-336-5117 | ntbaker | Project Manager | 4 |
| 380086 | Mrs. | Carol | V | Murphy | F | [email protected] | 6/30/58 | 1/28/83 | 60918 | 423-67-7023 | 216-336-0009 | cvmurphy | Marketing Analyst | 5 |
| 477616 | Hon. | Frances | B | Young | F | [email protected] | 6/9/59 | 4/27/94 | 121587 | 028-92-8912 | 210-819-9765 | fbyoung | Sr. Attornet | 7 |
| 162402 | Hon. | Diana | T | Peterson | F | [email protected] | 11/13/87 | 2/17/14 | 43010 | 512-33-6767 | 479-783-5656 | dtpeterson | Recruiter | 6 |
| 231469 | Mr. | Ralph | L | Flores | M | [email protected] | 2/5/75 | 4/14/09 | 118457 | 302-15-0130 | 316-280-2864 | rlflores | Sr. Attorney | 7 |
| 153989 | Prof. | Jack | C | Alexander | M | [email protected] | 5/19/95 | 1/5/17 | 82965 | 428-99-9413 | 702-603-3769 | jcalexander | HR Manager | 6 |
| 386158 | Mrs. | Melissa | Q | King | F | [email protected] | 2/24/72 | 11/24/15 | 166892 | 277-17-9106 | 216-605-3731 | mqking | SVP HR | 6 |
| 301576 | Hon. | Wayne | G | Watson | M | [email protected] | 6/26/96 | 7/19/17 | 92758 | 011-94-6649 | 701-231-9370 | wgwatson | Sr. Recruiter | 6 |
| 441771 | Mrs. | Cheryl | O | Scott | F | [email protected] | 2/23/58 | 11/26/90 | 92220 | 596-94-2279 | 215-288-9345 | coscott | Manager Funds | 2 |
| 528509 | Hon. | Paula | G | Diaz | F | [email protected] | 8/22/66 | 8/22/94 | 152654 | 234-57-7671 | 252-531-7641 | pgdiaz | Fund Director | 2 |
| 912990 | Mr. | Joshua | T | Stewart | M | [email protected] | 5/18/70 | 9/2/02 | 184896 | 755-07-3676 | 217-279-9342 | jtstewart | Finance Chair | 2 |
| 214352 | Ms. | Theresa | G | Lee | F | [email protected] | 12/5/92 | 1/19/15 | 197537 | 055-02-9969 | 319-553-8919 | tglee | CFO | 2 |
| 890290 | Hon. | Julia | S | Scott | F | [email protected] | 7/15/59 | 2/23/05 | 141518 | 251-99-1941 | 423-939-1010 | jsscott | Director Audit | 1 |
| 622406 | Mr. | Thomas | Q | Lewis | M | [email protected] | 10/4/67 | 6/7/98 | 73862 | 467-99-2604 | 314-679-3697 | tqlewis | Audit Analyst | 1 |
| 979607 | Ms. | Carol | J | Edwards | F | [email protected] | 12/14/94 | 4/25/16 | 93967 | 316-35-9870 | 225-283-4295 | cjedwards | Fraud Analyst | 2 |
| 969580 | Prof. | Matthew | L | Turner | M | [email protected] | 10/26/93 | 2/7/16 | 52237 | 598-92-1988 | 236-972-7624 | mlturner | Auditor I | 1 |
| 426038 | Hon. | Joan | C | Stewart | F | [email protected] | 11/20/72 | 12/30/09 | 111673 | 429-99-6443 | 216-637-6800 | jcstewart | Investment Advisor | 2 |
| 388642 | Mrs. | Ruby | R | Rogers | F | [email protected] | 5/1/80 | 8/30/13 | 160623 | 236-55-0172 | 423-231-6507 | rrrogers | Fund Rel. Mgr. | 2 |
| 560455 | Ms. | Carolyn | V | Hayes | F | [email protected] | 3/10/58 | 7/3/01 | 42005 | 730-28-1350 | 239-882-8784 | cvhayes | Admin Assistant | 1 |
| 477253 | Mrs. | Anne | L | Russell | F | [email protected] | 7/29/89 | 11/24/13 | 103160 | 456-99-5619 | 605-635-1306 | alrussell | Real Estate Fund Mgr. | 2 |
| 263480 | Hon. | Daniel | K | Cooper | M | [email protected] | 1/1/90 | 3/6/14 | 153790 | 181-86-2024 | 701-510-8162 | dkcooper | BioTech Fund Mgr. | 2 |
| 683826 | Mr. | Roger | L | Roberts | M | [email protected] | 7/7/69 | 1/29/09 | 129625 | 120-98-6493 | 206-497-3141 | rlroberts | Tech Fund Mgr. | 2 |
| 474599 | Drs. | Maria | W | Walker | F | [email protected] | 3/19/75 | 10/1/98 | 48944 | 447-27-3175 | 423-668-5506 | mwwalker | Mainframe Programmer | 4 |
| 335732 | Ms. | Brenda | M | Butler | F | [email protected] | 12/6/63 | 8/20/87 | 60508 | 282-15-6434 | 480-814-8284 | bmbutler | Programmer Analyst I | 4 |
| 329752 | Hon. | Lillian | X | Brown | F | [email protected] | 5/12/81 | 4/13/15 | 67251 | 249-99-8821 | 239-812-9041 | lxbrown | Sales Associate | 3 |
| 893212 | Ms. | Amy | B | Howard | F | [email protected] | 6/16/81 | 6/1/03 | 112715 | 686-24-2843 | 803-613-3168 | abhoward | Manager Portfolio Sales | 3 |
| 621833 | Mr. | Gregory | X | Edwards | M | [email protected] | 8/31/93 | 9/30/15 | 169245 | 010-94-6817 | 503-256-9654 | gxedwards | Director IRA Sales | 3 |
| 456747 | Mr. | Roy | Z | Griffin | M | [email protected] | 5/8/91 | 8/23/12 | 170895 | 358-08-7660 | 219-506-9378 | rzgriffin | Director Portfolio Sales | 3 |
| 278556 | Prof. | Richard | Y | Mitchell | M | [email protected] | 7/28/93 | 8/18/16 | 122226 | 013-94-5886 | 205-621-5884 | rymitchell | Manager IRA Sales | 3 |
| 333476 | Hon. | Mary | P | Wilson | F | [email protected] | 12/1/67 | 12/22/91 | 109394 | 198-84-0652 | 423-937-8660 | mpwilson | Sr. Sales Associate | 3 |
| 218791 | Mr. | Aaron | N | Price | M | [email protected] | 2/10/69 | 7/3/97 | 54402 | 491-29-5152 | 219-287-8926 | anprice | Marketing Analyst | 5 |
| 134841 | Ms. | Donna | R | Brown | F | [email protected] | 9/14/83 | 7/17/13 | 129836 | 544-81-5182 | 212-434-7910 | drbrown | Sr. Sales Associate | 3 |
| 726264 | Hon. | Carl | N | Collins | M | [email protected] | 12/22/73 | 6/9/07 | 162159 | 544-81-6171 | 479-740-7633 | cncollins | Director Brokerage Sales | 3 |
| 766610 | Ms. | Joyce | E | Jenkins | F | [email protected] | 8/22/61 | 5/14/10 | 119321 | 695-16-6506 | 262-455-4187 | jejenkins | Sr. Sales Associate | 3 |
| 923947 | Ms. | Mary | G | Bryant | F | [email protected] | 6/21/62 | 5/20/04 | 155442 | 491-29-7461 | 319-827-3516 | mgbryant | VP Budgets | 2 |
| 227922 | Hon. | Amanda | M | Hughes | F | [email protected] | 7/29/82 | 4/19/07 | 114257 | 311-35-2540 | 225-544-9700 | amhughes | Manager Budgets and Fin | 2 |
| 265813 | Hon. | Jack | E | Campbell | M | [email protected] | 1/4/85 | 7/29/07 | 186280 | 047-15-1537 | 316-499-5737 | jecampbell | SVP Infrastructure | 4 |
| 247137 | Mr. | Alan | E | Rivera | M | [email protected] | 12/11/78 | 6/7/06 | 154810 | 399-31-7149 | 423-277-6819 | aerivera | VP Storage and Computing | 4 |
| 407061 | Ms. | Elizabeth | Q | Jackson | F | [email protected] | 8/15/64 | 1/19/05 | 85420 | 660-24-4434 | 603-568-6118 | eqjackson | Sales Associate | 3 |
| 226714 | Drs. | Nancy | L | Davis | F | [email protected] | 11/14/83 | 8/25/12 | 94986 | 224-99-5928 | 219-610-3067 | nldavis | HR Compliance Manager | 6 |
| 702813 | Mr. | Ernest | D | Martinez | M | [email protected] | 11/9/89 | 1/24/16 | 172098 | 672-48-7749 | 479-951-4138 | edmartinez | Patent Attorney | 7 |
| 524896 | Ms. | Judy | Y | Hernandez | F | [email protected] | 3/25/61 | 12/27/11 | 133332 | 534-71-4481 | 316-736-6126 | jyhernandez | Director Insights | 4 |
| 363065 | Drs. | Nancy | L | Jones | F | [email protected] | 11/10/93 | 10/16/15 | 61924 | 681-24-3165 | 212-825-1930 | nljones | Accountant | 1 |
| 704709 | Dr. | Harold | Z | Nelson | M | [email protected] | 12/24/84 | 8/23/11 | 156194 | 456-99-2066 | 217-555-9216 | hznelson | Board Advisor |
| 461593 | Ms. | Nicole | O | Ward | F | [email protected] | 12/12/64 | 1/23/89 | 95673 | 196-84-2551 | 231-761-7861 | noward | Board Advisor |
| 392491 | Mrs. | Theresa | R | Murphy | F | [email protected] | 12/30/87 | 8/3/10 | 51015 | 249-99-8801 | 907-356-1555 | trmurphy | Admin Assistant BOD |
| 495141 | Drs. | Tammy | B | Young | F | [email protected] | 3/22/79 | 4/25/15 | 93650 | 771-02-7046 | 231-290-3075 | tbyoung | Board Advisor |