-
Notifications
You must be signed in to change notification settings - Fork 11
Latticegrid configuration
yoon edited this page Mar 25, 2013
·
1 revision
-- To Do --
- convert to consume Open Linked Data representation of organizational structure
Currently there are two organization files that are loaded. department_lookup.txt and divisions_lookup.txt
department_lookup.txt has the listing of institutions, schools, centers, etc that are part of your 'cloud' of investigators. The fields with some of our local data are shown below :
The names of these columns can be changed, but they match our internal faculty database at Northwestern. If you have column names you would prefer, we can easily extend the loader.
APPT_ENTITY_ABBR is the short name for the entity
APPT_ENTITY_ID is a unique id (it can be synthetic and I should probably allow it to be blank!) for the entity
APPT_ENTITY_NAME the long name for the entity
APPT_ENTITY_SCHOOL is the name of the school or highest level organization you want to show. Note that these can either be roots or used to show which organization the center/instittute belongs to. For a cancer center we have a very simple org file (this one is for U of Michigan)
APPT_ENTITY_ABBR APPT_ENTITY_ID APPT_ENTITY_NAME APPT_ENTITY_SCHOOL
UM 600000 University of Michigan UM
UMCCC 401000 University of Michigan Comprehensive Cancer Center UM
For the Northwestern medical school, we have 10 schools, several cross-organization entities, and then about 60 departments and 30 centers.
APPT_ENTITY_ABBR APPT_ENTITY_ID APPT_ENTITY_NAME APPT_ENTITY_SCHOOL
Feinberg 600000 Feinberg School of Medicine Feinberg
Dental School 601000 Dental School Dental
Kellogg 602000 Kellogg School of Management Kellogg
Law School 603000 School of Law Law
Medill 604000 Medill School of Journalism Medill
MEAS 605000 McCormick School of Engineering MEAS
SESP 606000 School of Education and Social Policy SESP
Communication 607000 School of Communication Communication
WCAS 608000 Weinberg College of Arts and Sciences WCAS
SCS 609000 School of Continuing Studies SCS
Provost's Office 610000 Provost's Office Provost's Office
IPR 612000 Institute for Policy Research IPR
Comprehensive Transplant 423000 Comprehensive Transplant Center Feinberg
Emergency Medicine 303000 Emergency Medicine Feinberg
Neurological Surgery 309000 Neurological Surgery Feinberg
Medical Social Sciences 323000 Medical Social Sciences Feinberg
Med Humanities Bioethics 503000 Medical Humanities and Bioethics Feinberg
OME & Faculty Dev. 502000 Medical Education and Faculty Development Feinberg
Administration 504000 Administration Feinberg
Physical Therapy 317000 Physical Therapy and Human Movement Sciences Feinberg
Buehler COA 406000 Buehler Center on Aging Feinberg
CM Biology 101000 Cell and Molecular Biology Feinberg
Pediatrics 316000 Pediatrics Feinberg
NUCATS 420000 Northwestern University Clinical and Translational Sciences Institute (NUCATS) Feinberg
IHS 404000 Institute for Healthcare Studies Feinberg
Otolaryngology 314000 Otolaryngology - Head and Neck Surgery Feinberg
Neurology 308000 Ken and Ruth Davee Department of Neurology Feinberg
Ctr for Genetic Medicine 402000 Center for Genetic Medicine Feinberg
Micro-Immunology 102000 Microbiology-Immunology Feinberg
NCCO 422000 Northwestern University Comprehensive Center on Obesity Feinberg
CNADC 403000 Cognitive Neurology and Alzheimer's Disease Center Feinberg
Immunobiology Center 408000 Interdepartmental Immunobiology Center Feinberg
Radiation Oncology 319500 Radiation Oncology Feinberg
NUIN 409000 Northwestern University Institute of Neuroscience (NUIN) Feinberg
Center for Global Health 424000 Center for Global Health Feinberg
Dermatology 302000 Dermatology Feinberg
Lurie Cancer Center 401000 Robert H. Lurie Comprehensive Cancer Center Feinberg
P M & R 315000 Physical Medicine and Rehabilitation Feinberg
Radiology 319000 Radiology Feinberg
Urology 321000 Urology Feinberg
Orthopaedic Surgery 313000 Orthopaedic Surgery Feinberg
MPBC 103000 Molecular Pharmacology and Biological Chemistry Feinberg
Anesthesiology 301000 Anesthesiology Feinberg
IBNAM 410000 Institute for Bioengineering and Nanoscience in Advanced Medicine (IBNAM) Feinberg
Physiology 104000 Physiology Feinberg
Center for AIDS Research 412000 Center for AIDS Research Feinberg
Inst. Women's Health Rsch 421000 Institute for Women's Health Research Feinberg
Center for Bioethics 419000 Center for Bioethics, Science and Society Feinberg
Ob/Gyn 310000 Obstetrics and Gynecology Feinberg
Surgery 320000 Surgery Feinberg
Preventive Medicine 202000 Preventive Medicine Feinberg
CMRC 413000 Children's Memorial Research Center (CMRC) Feinberg
Family Medicine 304000 Family and Community Medicine Feinberg
Feinberg Cardio Rsch 305000 Feinberg Cardiovascular Research Institute Feinberg
Pathology 201000 Pathology Feinberg
Psychiatry 318000 Psychiatry and Behavioral Sciences Feinberg
Asher Center 411000 Asher Center for the Study and Treatment of Depressive Orders Feinberg
Medicine 307000 Medicine Feinberg
Ophthalmology 312000 Ophthalmology Feinberg
The second file is 'divisions_lookup.txt' and is the list of departments, divisions, programs, etc. Here is the list for U of Michigan again for this file:
APPOINT_FLAG CENTER_FLAG DEPT_ID DIVISION_ID DV_ABBR DV_NAME DV_TYPE LABEL_NAME SEARCH_NAME
1 1 401000 401010 UMCCC University of Michigan Comprehensive Cancer Center Clinical University of Michigan Comprehensive Cancer Center University of Michigan Comprehensive Cancer Center
0 0 401000 1 CG Cancer Genetics Basic Science Cancer Genetics Cancer Genetics
0 0 401000 2 CCB Cancer Cell Biology Basic Science Cancer Cell Biology Cancer Cell Biology
0 0 401000 3 MT Molecular Therapeutics Basic Science Molecular Therapeutics Molecular Therapeutics
0 0 401000 4 RS Radiation Sciences Basic Science Radiation Sciences Radiation Sciences
0 0 401000 5 MI Molecular Imaging Basic Science Molecular Imaging Molecular Imaging
0 0 401000 6 TIHR Tumor Immunology & Host Response Basic Science Tumor Immunology & Host Response Tumor Immunology & Host Response
0 0 401000 7 BO Breast Oncology Clinical Science Breast Oncology Breast Oncology
0 0 401000 8 PC Prostate Cancer Clinical Science Prostate Cancer Prostate Cancer
0 0 401000 9 GO Gastrointestinal Oncology Clinical Science Gastrointestinal Oncology Gastrointestinal Oncology
0 0 401000 10 CC Childhood Cancers Developing Childhood Cancers Childhood Cancers
0 0 401000 11 HNO Head & Neck Oncology Clinical Science Head & Neck Oncology Head & Neck Oncology
0 0 401000 12 LLBMT Leukemia/Lymphoma - BMT Clinical Science Leukemia/Lymphoma - BMT Leukemia/Lymphoma - BMT
0 0 401000 13 SB Socio-Behavioral Cancer Prevention & Control Socio-Behavioral Socio-Behavioral
0 0 401000 14 BP Biomedical Prevention Cancer Prevention & Control Biomedical Prevention Biomedical Prevention
0 0 401000 15 T Thoracic Developing Thoracic Thoracic
0 0 401000 16 G Gynecologic Developing Gynecologic Gynecologic
0 0 401000 17 PO Psych-Oncology Developing Psych-Oncology Psych-Oncology
0 0 401000 18 CT Connective Tissue Developing Connective Tissue Connective Tissue
0 0 401000 19 CO Cutaneous Oncology Developing Cutaneous Oncology Cutaneous Oncology
0 0 401000 20 NO Neuro-Oncology Developing Neuro-Oncology Neuro-Oncology
APPOINT_FLAG shows if the organization can make faculty appointments (shows up in some of the menus differently if it can)
CENTER_FLAG should be 1 for the name of the center or institute,\
DEPT_ID should be the same as the APPT_ENTITY_ID for the 'owning' department /center/school in the department_lookup.txt file
DIVISION_ID is a synthetic unique identifier for the division/program
DV_ABBR is the short name for the unit
DV_NAME is the full name for the unit
DV_TYPE is the category and is not needed
LABEL_NAME defaults to DV_NAME if it is not available and is used in the reports for the name of the unit
Created 2010-Feb and Updated 2011-April WAKibbe
Here is the short list of the data elements you need to create the faculty list. For each faculty, the default pubmed search string is lastname firstinitial middleinitial
Unique identifiers: you need at least 1 for each member!
employee_id
username
email
You need to provide a first name and last name
last_name
first_name
You need to provide the name of the program or the program abbreviation id for using LatticeGrid in a cancer center or other organization where the association is not a faculty appointment. If an investigator belongs to multiple programs, create separate lines for each program
program
These are all optional
degrees Ph.D., M.D., etc
rank Professor, Associate Professor, Assistant Professor, Instructor, etc
campus campus location, useful for specifying the campus location of each faculty member
pubmed_search_name hand-crafted search string for finding publications in pubmed, like 'Kibbe WA or Kibbe Warren'
pubmed_limit_to_institution Y or N or blank. Limit this search to publications from this institution. See more config options in lib/pubmed_config.rb
faculty_interests short list of keywords or research interests for the faculty member
research_summary multiple sentences describing the faculty member's research
office_phone
era_comons_name This is the member's ERA Commons username. Useful if you want to look up grants in NIH Reporter, or if the NLM unique author name becomes a reality
home_phone
lab_phone
fax
pager
mailcode
address1
address2
city
state
postal_code
country