Physicians/Providers


Neurology:
Roger Albin, M.D.
Kirk Frey, M.D., Ph.D.
Kelvin Chou, M.D.
Praveen Dayalu, M.D.
Matthew Lorincz, M.D., Ph.D.
Nicolaas Bohnen, M.D.
Henry Paulson, M.D., Ph.D.
Wayne Cornblath, M.D.
Sid Gilman, M.D.
John Fink, M.D.
 
Neurosurgery:
Parag Patil, M.D., Ph.D.
Oren Sagher, M.D.
 
Speech-Language Pathology:
Karen Kluin, M.S. CCC BC-NCD
 
Electrophysiology:
J. Wayne Aldridge, Ph.D.
Joshua Berke, Ph.D.
 
Neuropsychology:
Bruno Giordani, Ph.D.
Carol Persad, Ph.D.
 
Physical Medicine and Rehabilitation:
Lisa DiPonio, M.D.
Mark Ziadeh, M.D.
 
Program Coordinator:
Susan Grube, RN, M.S.N., CCRC


query [long version]
 INDIVIDUAL_IDMAIL_NAMEFIRST_NAMEMIDDLE_NAMELAST_NAMENAME_SUFFIXDEGREESSERVICE_NAMEUM_DEPARTMENTFELLOW_NAME_FLAG
Query Source:SQL Query
Datasource:PRMC-MARKETSCOPE
Query:SELECT DISTINCT ind.individual_id, mail_name, first_name, middle_name, last_name, name_suffix, degrees, clinical_specialty service_name, svcdept.um_department, fellow_name_flag FROM MS.INDIVIDUAL ind, MS.provider prov, pcd.clinical_faculty clinfac, pcd.view_guide_faculty_department facdept, pcd.GUIDE_FACULTY_CLIN_SVC facsvc, pcd.view_gd_svc_sec_div_name svcdept where ind.individual_id = prov.individual_id AND ind.individual_id = clinfac.individual_id AND clinfac.individual_id = facdept.individual_id AND clinfac.individual_id = facsvc.individual_id(+) AND facsvc.service_id = svcdept.service_id(+) AND svcdept.um_department='Neurology' AND svcdept.service_id = 279 ORDER BY last_name,first_name,service_name
Time:250 ms