Spreadsheet: 139171d1328113966-vlookup-help-prior_class_flags_011612-vlookup-example
Sheet: OH Vlookup

Date Added | Lawson Company # | Market | PG CEO | Hospital Affiliation | Dept Grp# | Dept Group Description | MGMA NUMERIC SPECIALTY CODE | MGMA Specialty | Provider Dept # | Dept Type | FY11 Budget | FULL-NAME | Plus provider Nbr | [NAME] | [NAME] Job Code Description | HIRE TYPE | Hire Date | Class | Primary - Specialty | Termed | Termed Date | New or Existing in Market | Captive | Allocation OH Dept # | [NAME] | Planning Provider Dept Description | Planning Practice Dept # | Planning Practice Dept Description | Ancillary Dept | Comments | Count Lawson Characters | Speciality Listing |  |  |  |  |  |  | Concatenate with _
2011-08-22 00:00:00 | 5300 | TX | [NAME] | ORMC | 705 | Family Practice | 154 | PA: Family Practice (w/o OB) | 497 | NEW | N | KEMP, MELISSA |  | PHX | Physician's Assistant | EMPLOYED | 2011-10-01 00:00:00 | 2011 | Primary | N |  | N | Y | 7020 | KEMP, MEL-ORMC-Urgent Care | 0497 - KEMP, MELISSA - ORMC - URGENT CARE CLINIC - PA | 7020T | ORMC Urgent Care Clinic |  |  | 26 | P700_OH |  |  |  | OH - Anesthiology | S712_OH |  | 7020_T
2010-09-14 00:00:00 | 5275 | AZ | [NAME] | SL | 700A | General Hospitalists | 27 | Hospitalist: Family Practice | 55 | NEW | N | NOORI,NAZAR | NULL | PHY | Physician | EMPLOYED | 2010-09-15 00:00:00 | 2010 | Primary | N |  | N | Y | 7000 | NOORI, NAZ-SL-Hospitalist | [NAME], NAZAR - SL/TSL - Hospitalist | 7000A | Dr. [NAME]/TSL Hospitalist |  |  | 25 | S703_OH |  |  |  |  |  |  | 7000_A
2009-10-15 00:00:00 | 3160 | TX | [NAME] | SET | 700A | General Hospitalists | 28 | Hospitalist: Internal Medicine | 29 | GL ONLY | NA | SHEPARD | NULL | PHY | Physician | CONTRACT | NA - Contract | NA - Contract | Primary | Y |  | E | N | 7000 | SHEPARD-SET-Hospitalist | 0029  - TERMED 11/10 - SHEPARD - SET - Hospitalist - Contract | 7000M | Dr. [NAME] Hospitalist |  | GL ONLY | 23 | S703_OH |  |  |  |  |  |  | 7000_M
2009-10-15 00:00:00 | 3160 | TX | [NAME] | SET | 700A | General Hospitalists | 28 | Hospitalist: Internal Medicine | 30 | GL ONLY | NA | NOORI | NULL | PHY | Physician | CONTRACT | NA - Contract | NA - Contract | Primary | Y |  | E | N/A | 7000 | NOORI-SET-Hospitalist | 0030 - TERMED 09/10 - NOORI - SET - Hospitalist - Contract | 7000M | Dr. [NAME] |  | GL ONLY | 21 | S703_OH |  |  |  |  |  |  | 7000_M
2009-10-15 00:00:00 | 5300 | TX | [NAME] | SET | 700A | General Hospitalists | 28 | Hospitalist: Internal Medicine | 30 | GL ONLY | NA | NOORI | NULL | PHY | Physician | CONTRACT | 2009-10-01 00:00:00 | 2009 | Primary | Y | 2010-09-01 00:00:00 | E | N/A | 7000 | NOORI-SET-Hospitalist | 0030 - TERMED 09/10 - NOORI - SET - Hospitalist - Contract | 7000T | Dr. [NAME] |  | GL ONLY | 21 | S703_OH |  |  |  |  |  |  | 7000_T
2009-10-15 00:00:00 | 5300 | TX | [NAME] | SET | 700A | General Hospitalists | 28 | Hospitalist: Internal Medicine | 29 | GL ONLY | NA | SHEPARD | NULL | PHY | Physician | CONTRACT | 2009-10-01 00:00:00 | 2009 | Primary | Y | 2010-11-01 00:00:00 | E | N | 7000 | SHEPARD-SET-Hospitalist | 0029  - TERMED 11/10 - SHEPARD - SET - Hospitalist - Contract | 7000T | Dr. [NAME] Hospitalist |  | GL ONLY | 23 | S703_OH |  |  |  |  |  |  | 7000_T
2009-09-23 00:00:00 | 5231 | UT | [NAME] | JV | 700A | General Hospitalists | 28 | Hospitalist: Internal Medicine | 8 | EXISTING | NA | MORRISON,LYNN | NULL | PHX | Nurse Practitioner | EMPLOYED | 2004-03-30 00:00:00 | 2004 | Primary | Y | 2009-11-30 00:00:00 | NA | N | 7000 | MORRISON, LYN-JV-Hosp | 0008 - MORRISON, LYNN - JV - Hospitalist - NP | 7000U | Jordan Valley Hospitalists |  |  | 21 | S703_OH |  |  |  |  |  |  | 7000_U
2009-09-23 00:00:00 | 5231 | UT | [NAME] | JV | 700A | General Hospitalists | 28 | Hospitalist: Internal Medicine | 3 | EXISTING | NA | HOLLINGSWORTH,HELEN | 4660 | PHY | Physician | EMPLOYED | 2006-01-04 00:00:00 | 2006 | Primary | Y | 2010-05-31 00:00:00 | NA | N | 7000 | HOLLINGSWORTH, HEL-JV-Hosp | 0003 - HOLLINGSWORTH, HELEN - JV - Hospitalist | 7000U | Jordan Valley Hospitalists |  |  | 26 | S703_OH |  |  |  |  |  |  | 7000_U
2009-09-23 00:00:00 | 5231 | UT | [NAME] | PV | 700A | General Hospitalists | 28 | Hospitalist: Internal Medicine | 9 | EXISTING | Y | SAIDI,[NAME] | 10172 | PHY | Physician | EMPLOYED | 2006-09-04 00:00:00 | 2006 | Primary | Y | 2010-11-01 00:00:00 | N | N | 7001 | SAIDI, ABD-PV-Hosp | 0009 - SAIDI, [NAME] | 7000U | Jordan Valley Hospitalists |  |  | 18 | S703_OH |  |  |  |  |  |  | 7000_U
2009-09-23 00:00:00 | 5231 | UT | [NAME] | JV | 700A | General Hospitalists | 28 | Hospitalist: Internal Medicine | 5 | EXISTING | NA | CHAMBERLAIN,BRUCE | 10184 | PHY | Physician | EMPLOYED | 2006-12-01 00:00:00 | 2007 | Primary | Y | 2010-05-31 00:00:00 | NA | N | 7000 | CHAMBERLAIN, BRU-JV-Hosp | 0005 - CHAMBERLAIN, BRUCE - JV - Hospitalist | 7000U | Jordan Valley Hospitalists |  |  | 24 | S703_OH |  |  |  |  |  |  | 7000_U
2009-09-23 00:00:00 | 5231 | UT | [NAME] | JV | 700A | General Hospitalists | 28 | Hospitalist: Internal Medicine | 7 | EXISTING | Y | DEVANEY,[NAME] | 10624 | PHX | Nurse Practitioner | EMPLOYED | 2008-03-01 00:00:00 | 2008 | Primary | Y | 2010-11-01 00:00:00 | E | N | 7000 | DEVANEY, JEF-JV-Hosp | 0007 - DEVANEY, [NAME] - JV - Hospitalist - NP | 7000U | Jordan Valley Hospitalists |  |  | 20 | S703_OH |  |  |  |  |  |  | 7000_U
2009-09-23 00:00:00 | 5231 | UT | [NAME] | JV | 700A | General Hospitalists | 28 | Hospitalist: Internal Medicine | 2 | EXISTING | Y | AGRESTA,MATTHEW D | 3373 | PHY | Physician | EMPLOYED | 2009-07-01 00:00:00 | 2009 | Primary | Y | 2010-11-01 00:00:00 | E | N | 7000 | AGRESTA, MAT-JV-Hosp | 0002 - AGRESTA, [NAME] | 7000U | Jordan Valley Hospitalists |  |  | 20 | S703_OH |  |  |  |  |  |  | 7000_U
2010-01-05 00:00:00 | 5231 | UT | [NAME] | JV | 700A | General Hospitalists | 31 | Infectious Disease | 50 | GL ONLY | N | HORANI,JAMAL | 5085 | PHY | Physician | EMPLOYED | 2009-07-01 00:00:00 | 2009 | Primary | Y | 2011-01-11 00:00:00 | E | N | 7000 | HORANI, JAM-JV-Hosp | 0050 - HORANI, JAMAL - JV - Hospitalist | 7000U | Jordan Valley Hospitalists |  | Primary Payroll Dept #1954 | 19 | S703_OH |  |  |  |  |  |  | 7000_U
2009-09-23 00:00:00 | 5231 | UT | [NAME] | JV | 700A | General Hospitalists | 28 | Hospitalist: Internal Medicine | 1 | EXISTING | NA | JUNEJO,NAZIA | 10011 | PHY | Physician | EMPLOYED | 2009-07-15 00:00:00 | 2009 | Primary | Y | 2010-03-31 00:00:00 | NA | N | 7000 | JUNEJO, NAZ-JV-Hosp | 0001 - JUNEJO, NAZIA - JV - Hospitalist | 7000U | Jordan Valley Hospitalists |  |  | 19 | S703_OH |  |  |  |  |  |  | 7000_U
2009-09-23 00:00:00 | 5231 | UT | [NAME] | JV | 700A | General Hospitalists | 28 | Hospitalist: Internal Medicine | 6 | EXISTING | Y | GUNDERSEN,NANCY | 11186 | PHY | Physician | EMPLOYED | 2009-08-24 00:00:00 | 2009 | Primary | Y | 2010-11-01 00:00:00 | N | N | 7000 | GUNDERSEN, NAN-JV-Hosp | 0006 - GUNDERSEN, NANCY - JV - Hospitalist | 7000U | Jordan Valley Hospitalists |  |  | 22 | S703_OH |  |  |  |  |  |  | 7000_U
2009-12-04 00:00:00 | 5231 | UT | [NAME] | JV | 700A | General Hospitalists | 28 | Hospitalist: Internal Medicine | 37 | GL ONLY | N | BORT,ERMITA | 11195 | PHY | Physician | EMPLOYED | 2009-09-28 00:00:00 | 2009 | Primary | Y | 2010-11-01 00:00:00 | N | N | 7000 | BORT, ERM-JV-Hosp | 0037 - BORT, ERMITA - JV - Hospitalist | 7000U | Jordan Valley Hospitalists |  | Primary Payroll Dept #0032 | 17 | S703_OH |  |  |  |  |  |  | 7000_U
2010-01-22 00:00:00 | 5231 | UT | [NAME] | JV | 700A | General Hospitalists | 28 | Hospitalist: Internal Medicine | 51 | EXISTING | Y | PILGRAM,PAUL | 131 | PHY | Physician | EMPLOYED | 2010-02-01 00:00:00 | 2010 | Primary | Y | 2010-11-01 00:00:00 | E | N | 7000 | PILGRAM, PAUL-JV-Hosp | 0051 - PILGRAM, PAUL - JV - Hospitalist | 7000U | Jordan Valley Hospitalists |  |  | 21 | S703_OH |  |  |  |  |  |  | 7000_U
2009-09-23 00:00:00 | 5231 | UT | [NAME] | JV | 700A | General Hospitalists | 28 | Hospitalist: Internal Medicine | 25 | EXISTING | NA | Contract Physicians | NULL | PHY | Physician | CONTRACT | 2010-04-01 00:00:00 | 2010 | Primary | Y | 2010-12-01 00:00:00 | NA | N/A | 7000 | JV-Hosp-Contract | 0025 - JV - Hospitalist - Contract | 7000U | Jordan Valley Hospitalists |  |  | 16 | S703_OH |  |  |  |  |  |  | 7000_U
2010-06-14 00:00:00 | 5231 | UT | [NAME] | JV | 700A | General Hospitalists | 28 | Hospitalist: Internal Medicine | 42 | EXISTING | N | THOMPSON,DONNA | NULL | PHX | Nurse Practitioner | EMPLOYED | 2010-06-12 00:00:00 | 2010 | Primary | Y | 2010-11-01 00:00:00 | E | N | 7000 | THOMPSON, DON-JV-Hosp | 0042 - THOMPSON, DONNA - JV - Hospitalist | 7000U | Jordan Valley Hospitalists |  |  | 21 | S703_OH |  |  |  |  |  |  | 7000_U