-- example rooted, labeled tree taken from the administration of Gustavus,
-- https://gustavus.edu/general_catalog/current/admin_faculty_trustees_1415.pdf
insert into tree(id, parent, label) values
(1, NULL, 'Rebecca M. Bergman, BS, President'),
(2, 1, 'Jolene D. Christensen, BS, Assistant to the President and Secretary of the Board of Trustees'),
(3, 1, 'Siri C. Erickson, MDiv, Chaplain'),
(4, 1, 'Brian E. Konkol, MDiv, MTh, Chaplain'),
(5, 4, 'Chad Winterfeldt, DMA, Cantor'),
(6, 1, 'Barbara Larson Taylor, BA, Director of Center for Servant Leadership and Assistant to the President for Special Projects'),
(7, 6, 'Cynthia Favre, MS, Associate Director of Center for Servant Leadership and Director of Career Development and Career Management'),
(8, 7, 'Heather Banks, MS, Assistant Director of Career Development and Director for Health Professions Advising'),
(9, 7, 'Corrie Odland, MS, Assistant Director of Career Development and Career Counselor'),
(10, 7, 'Vincent A. Thomas, JD, Assistant Director of Career Development and Director for Internships'),
(11, 7, 'Amy R. Pehrson, BA, Director of Mentoring, Vocation, and Leadership'),
(12, 6, 'Jeffrey S. Rathlef, MA, Associate Director of Center for Servant Leadership and Director for Community-Based Service and Learning'),
(13, 12, 'David Newell, MA, Assistant Director for Community-Based Service and Learning and Director for Leadership and Community-Based Service'),
(14, 6, 'Grady I. St. Dennis, MDiv, Associate Director of Center for Servant Leadership, Director for Church Relations and Chaplain'),
(15, 14, 'Sara Masters, MA, Assistant Director for Church Relations and Community Engagement'),
(16, 1, 'Tom Brown, MS, Director of Intercollegiate Athletics and Facilities Manager of Lund Center'),
(17, 16, 'Jeff Annis, BS, Head Softball Coach'),
(18, 16, 'Dale Bahr, MS, Head Men''s and Women''s Cross Country Coach and Head Men''s and Women''s Track and Field Coach'),
(19, 16, 'Troy Banse, MS, Head Athletic Trainer and Director of Strength and Conditioning'),
(20, 19, 'Mitchell Bockenstedt, MEd, Assistant Athletic Trainer and Strength and Conditioning Coach'),
(21, 19, 'Mitchell Deets, BS, Assistant Athletic Trainer and Strength and Conditioning Coach'),
(22, 19, 'Matt Eberhardt, MS, Assistant Athletic Trainer and Strength and Conditioning Coach'),
(23, 16, 'Aryn Bell, MA, Head Gymnastics Coach'),
(24, 16, 'Laura Burnett-Kurie, BA, Head Women''s Soccer Coach and Health and Exercise Science Instructor'),
(25, 16, 'Jon Carlson, BA, Head Men''s and Women''s Swimming and Diving Coach and Head Women''s Tennis Coach'),
(26, 16, 'Mike Carroll, BS, Head Women''s Hockey Coach and Head Baseball Coach'),
(27, 16, 'Charlie Cosgrove, MS, Assistant Football Coach, Lund Information Desk Staff'),
(28, 16, 'Justin DeGrood, BA, Assistant Men''s Basketball Coach and DIrector of Intramurals'),
(29, 16, 'Kari Eckheart, MS, Assistant Athletics Director for Student-Athlete Services and Senior Women''s Administrator'),
(30, 16, 'Jenny Ewert, MBA, Assistant Volleyball Coach'),
(31, 16, 'Jed Friedrich, BS, Equipment Manager'),
(32, 16, 'Mark Hanson, MS, Head Men''s Basketball Coach and Health and Exercise Science Instructor'),
(33, 16, 'Peter Haugen, MA, Head Football Coach and Health and Exercise Science Instructor'),
(34, 16, 'Brenden Huber, BA, Assistant Men''s and Women''s Cross Country Coach, Assistant Men''s and Women''s Track and Field Coach, and Event ManagementSupervisor'),
(35, 16, 'Nathaniel Johnson, MS, Assistant Football Coach, and Assistant Baseball Coach'),
(36, 16, 'Laura Kelly, MS, Head Women''s Basketball Coach and Gustavus Health Promotion Program Coordinator'),
(37, 16, 'Alexander Lindstrom, BA, Assistant Men''s and Women''s Swimming and Diving Coach, Natatorium Supervisor'),
(38, 16, 'David Martinson, MEd, Assistant Men''s Hockey Coach and Assistant Ice Arena Manager'),
(39, 16, 'Michael Middleton, MS, Head Men''s Soccer Coach and Health and Exercise Science Instructor'),
(40, 16, 'Scott Moe, BA, Head Men''s and Women''s Golf Coach and Health and Exercise Science Instructor'),
(41, 16, 'Brett Petersen, MS, Head Men''s Hockey Coach, Ice Arena Manager, and Facility Scheduler'),
(42, 16, 'Jared Phillips, BA, Assistant Athletics Director and Director of Club Sports'),
(43, 16, 'Corey Shea, MS, Assistant Football Coach, Lund Information Desk Staff'),
(44, 16, 'Rachelle Sherden, BA, Head Volleyball Coach and Assistant for Student- Athlete Services'),
(45, 16, 'Carlin Shoemaker, BA, Assistant Football Coach and Event Management Supervisor'),
(46, 16, 'Amanda Trunzo, Assistant Women''s Hockey Coach and Lund Information Desk Staff'),
(47, 16, 'Tommy Valentini, MTh, Head Men''s Tennis Coach and Assistant Director for Student-Athlete Services'),
(48, 16, 'Daniel Wolfe, BS, Assistant Women''s Basketball Coach and Health and Exercise Science Instructor'),
(49, 16, 'Appointment Pending, Assistant Gymnastics Coach'),
(50, 1, 'Mark J. Braun, PhD, Provost and Dean of the College'),
(51, 50, 'Darrin Good, PhD, Associate Provost and Dean of Sciences and Education'),
(52, 50, 'Paula O''Loughlin, PhD, Associate Provost and Dean of Arts and Humanities'),
(53, 50, 'Bruce Aarsvold, BA, Director of Gustavus Technology Services'),
(54, 53, 'Joyce Aarsvold, MEd, Instructional Technology Coordinator'),
(55, 53, 'Joan Anderson, MS, Information Systems Development and Support Specialist'),
(56, 53, 'Tami Aune, BA, User Services Manager'),
(57, 56, 'Michael O''Brien, AAS, Computer and Electronics Technician'),
(58, 56, 'Evan Skucius, BS, Multimedia Classroom Support Specialist'),
(59, 56, 'Nicholas Sonsteby, BA, Technology Helpline Coordinator'),
(60, 56, 'Daniel Zimmerli, Macintosh Coordinator'),
(61, 53, 'Donna Hewitt, BS, Information Systems Development and Support Specialist'),
(62, 53, 'Appointment Pending, Network Engineer'),
(63, 53, 'David Maas, BS, Systems Operations Manager'),
(64, 53, 'Laura McCabe, Telecommunications Manager'),
(65, 53, 'Mary Milbradt, BS, Information Systems Development and Support Specialist'),
(66, 53, 'Jerry Nowell, BS, Director of Web Services'),
(67, 66, 'Nicholas Dobie, Web Developer'),
(68, 66, 'Billy Visto, BS, Lead Software Engineer'),
(69, 66, 'Appointment Pending, Web Application Programmer'),
(70, 53, 'Dan Oachs, BA, Associate Director of Core Services'),
(71, 53, 'Jessie Twaddle, BS, Associate Director of Core Services'),
(72, 71, 'Paul Hanson, BA, Unix Systems Administrator'),
(73, 50, 'Scott Bur, PhD, Director of the Nobel Conference'),
(74, 50, 'James Dontje, PhD, Director of the Johnson Center for Environmental Innovation'),
(75, 50, 'Margo Druschel, MEd, Director of the Academic Support Center'),
(76, 75, 'Kelly Hanson, MS, Disability Specialist'),
(77, 75, 'Jane Lalim, MS, Associate Director'),
(78, 75, 'Appointment Pending, Disability Services Coordinator'),
(79, 75, 'Appointment Pending, Multilingual/English Language Learners Academic Support Specialist'),
(80, 50, 'Daniel Mollner, MA, MS, Library Chair'),
(81, 80, 'Lynn Burg, BS, Cataloging Coordinator'),
(82, 80, 'Diane Christensen, Acquisition Coordinator'),
(83, 80, 'Amanda Moeller, MA, Serials Manager'),
(84, 80, 'Janice Nordstrom, Circulation Manager'),
(85, 80, 'Melissa Perron, BS, Collection Manager'),
(86, 80, 'Sonja Timmerman, MS, Interlibrary Loan Manager'),
(87, 50, 'Kristofer Kracht, MS, Director of Forensics and Director of Summer Academic Programs'),
(88, 87, 'Cadi Kadlecek, MS, Associate Director of Forensics and Summer Academic Programs'),
(89, 50, 'David A. Menk, BA, Director of Institutional Research'),
(90, 50, 'Scott Moeller, MS, Naturalist and Director, Linnaeus Arboretum'),
(91, 50, 'Daniel Moos, PhD, Assessment Director'),
(92, 50, 'Donald Myers, MA, Director of Hillstrom Museum'),
(93, 50, 'Shanon A. Nowell, BA, Assistant to the Provost'),
(94, 50, 'Carolyn O''Grady, EdD, Director of the Center for International and Cultural Education'),
(95, 94, 'Jeffrey Anderson, JD, International Student Services Coordinator'),
(96, 94, 'Jill Fischer, MS, Study Abroad Advisor'),
(97, 94, 'Linda Shaw, BS, Assistant Director and Coordinator of January and Off- Campus Study'),
(98, 50, 'Alisa Rosenthal, PhD, Director of the Kendall Center for Engaged Learning'),
(99, 50, 'Debra Sandquist, MS, Coordinator of Teacher Admission and Field Experiences'),
(100, 50, 'Kristianne Reinholtzen Westphal, MA, Registrar'),
(101, 100, 'Mary Gunderson, Assistant Registrar'),
(102, 50, 'Robert W. Weisenfeld, JD, Director of Government Grants and Sponsored Programs'),
(103, 1, 'Thomas Crady, PhD, Vice President for Enrollment Management'),
(104, 103, 'Richard Aune, BA, Associate Vice President and Dean of Admission'),
(105, 104, 'JJ Akin, BA, Admission Counselor and Coordinator of Marketing and Technology'),
(106, 104, 'Annabel Landaverde, BA, Admission Counselor and Coordinator of Multicultural Recruitment'),
(107, 104, 'Thomas McHugh, MS, Senior Associate Director of Admission'),
(108, 104, 'Alan Meier, BA, Senior Associate Director of Admission'),
(109, 104, 'Robert Neuman, BA, Senior Associate Dean of Admission'),
(110, 104, 'Lindsey Owens, MA, Associate Dean of Admission'),
(111, 104, 'Emily Thayer, BA, Admission Counselor and Coordinator of Marketing'),
(112, 104, 'Kyle Thomas, BA, Admission Counselor'),
(113, 104, 'Cynthia Yang, BA, Assistant Dean of Admission and Coordinator of Multicultural Recruitment'),
(114, 104, 'Appointment Pending, Assistant Dean of Admission'),
(115, 103, 'Douglas Minter, MDiv, Associate Vice President and Dean of Financial Aid'),
(116, 115, 'Kirk Carlson, MS, Associate Vice President for Enrollment Management'),
(117, 115, 'Jesus Hernandez Mejia, BS, Assistant Dean of Financial Aid'),
(118, 115, 'Sara Orth, BA, Director of Student Accounts248 ACADEMIC BULLETIN 2014–2015'),
(119, 1, 'Kenneth C. Westphal, BS, CPA, Vice President for Finance and Treasurer'),
(120, 119, 'Kirk Beyer, PhD, Director of Human Resources'),
(121, 120, 'Barb Lundgren, BS, Assistant Director of Human Resources'),
(122, 119, 'Neal Hagberg, MDiv, Director of Tennis and Life Camps'),
(123, 122, 'David Lachman, BA, Assistant Director, Tennis and Life Camps'),
(124, 119, 'Steven Kjellgren, BA, Director of Dining Services and Book Mark'),
(125, 124, 'Kevin Birr, BS, Assistant Director of Dining Service, Operations'),
(126, 124, 'Paul Jacobson, Assistant Director of Dining Service, Production and Purchasing, Executive Chef'),
(127, 124, 'Paul Matzke, BS, Assistant Director of Catering and Summer Programs'),
(128, 124, 'Margi Willmert, Assistant Director of Dining Service, Catering and Summer Programs'),
(129, 124, 'Molly Yunkers, BS, Manager of the Book Mark'),
(130, 119, 'Naomi Quiram, BA, Director of Print and Mail Services'),
(131, 119, 'Kelly Waldron, BA, CPA, Controller'),
(132, 131, 'Donna Loken, Student Loan Accounts Coordinator'),
(133, 131, 'Sandra Sukalski, BS, CPA, Assistant Controller'),
(134, 119, 'Warren Wunderlich, BArch, Director of Physical Plant'),
(135, 134, 'Lawrence Dvorak, Custodial Director'),
(136, 1, 'Thomas Young, BA, Vice President for Institutional Advancement'),
(137, 136, 'JackieLynn Peterson, BA, Associate Vice President for Advancement'),
(138, 137, 'Kari Clark, JD, Director, Gift Planning'),
(139, 137, 'Laurie Dietrich, BA, CPA, Planned Gifts, Marketing and Administration'),
(140, 137, 'Maggie Forster, MS, Donor Relations Manager'),
(141, 137, 'Lynne Johnson, BA, Director, Prospect Research'),
(142, 137, 'John Kupris, MDiv, EdS, Director, Gift Planning'),
(143, 137, 'Jim Rothschiller, MDiv, Director, Gift Planning'),
(144, 137, 'Cory Starkweather, BA, Director, Gift Planning'),
(145, 137, 'Randall Stuckey, BA, Director, Athletic Development and Engagement'),
(146, 137, 'Appointment Pending, Director, Gift Planning'),
(147, 137, 'Glen Lloyd, BA, Director, Alumni & Parent Engagement'),
(148, 147, 'Appointment Pending, Manager, The Gustavus Annual Fund'),
(149, 148, 'Chris Duhaime, BA, Assistant Director, The Gustavus Annual Fund'),
(150, 148, 'Appointment Pending, Engagement Coordinator'),
(151, 147, 'Ben Smith, BA, Assistant Director, Alumni and Parent Engagement, Reunion Programs'),
(152, 147, 'Robyn Rost, MA, Assistant Director, Alumni & Parent Engagement, Reunion Giving'),
(153, 137, 'Ann Johnson, BA, Director, Advancement Services'),
(154, 153, 'Ron Timmerman, BA, Associate Director, Advancement Services'),
(155, 1, 'Tim Kennedy, BA, Vice President for Marketing and Communication'),
(156, 155, 'Ethan Armstrong, MA, Director, Communication Services and Sports Information'),
(157, 155, 'Alan Behrends, BA, Director, Fine Arts Programs'),
(158, 155, 'Anna Deike, BFA, Graphic Designer/Production Manager'),
(159, 155, 'Neely Prenzlow, AA, Director, Design Services'),
(160, 159, 'Jennifer Kurth, AAS, Graphic Designer'),
(161, 155, 'Matthew Thomas, BA, Director, Media Relations and Internal Communications'),
(162, 155, 'Dean Wahlund, BA, Director, Communication Services and Special Events'),
(163, 155, 'Steve Waldhauser, MA, Director, Editorial Services'),
(164, 1, 'JoNes VanHecke, PhD, Vice President for Student Life and Dean of Students'),
(165, 164, 'Stephen Bennett, PsyD, LP, Associate Dean of Students'),
(166, 165, 'Heather Dale, MPA, Director of the Health Service, Physician''s Assistant'),
(167, 166, 'Nissa Fell, CNP, Certified Nurse Practitioner'),
(168, 166, 'Jessica Braun, CNP, Certified Nurse Practitioner'),
(169, 165, 'Meghan Krause, MA, MPH, Director of Wellbeing and the Wellbeing Center'),
(170, 165, 'Pearl Leonard-Rock, MA, Director of Multicultural Student Programs and Services and the Diversity Center'),
(171, 170, 'Katalina Traxler, MA, Assistant Director of Multicultural Student Programs and Services and the Diversity Center'),
(172, 164, 'Megan Ruble, MA, Assistant Dean of Students and Student Conduct Coordinator'),
(173, 172, 'Andrea Junso, MS, Director of Campus Activities'),
(174, 173, 'Matt Dobosenski, BA, Event Support Specialist'),
(175, 173, 'Scott Broady, MA, Assistant Director of Campus Activities'),
(176, 172, 'Kari Eckheart, MS, Assistant Director of Peer Education and Chemical Health'),
(177, 172, 'Carol Brewer, MA, Director of Campus Safety'),
(178, 177, 'Dale Plemmons, MPH, Assistant Director of Campus Safety and Manager of Environmental Health and Safety'),
(179, 164, 'Charlie Potts, MA, Director of Residential Life'),
(180, 179, 'Kyle Haiman, MEd, Assistant Director of Residential Life'),
(181, 180, 'Danielle Paris, MA, Area Coordinator'),
(182, 181, 'Glen Lloyd, BA, Faculty/Administrator in Residence for the Junior/ Senior-Year Experience'),
(183, 180, 'Jordan Zahrte, MA, Area Coordinator'),
(184, 180, 'Caitlin Herby, MA, Area Coordinator'),
(185, 184, 'Katherine Knutson, PhD, Faculty/Administrator in Residence for the First-Year Experience'),
(186, 180, 'Erik Heller, MA, Area Coordinator'),
(187, 186, 'Appointment pending, Faculty/Administrator in Residence for the Sophomore-Year Experience'),
(188, 164, 'Lisa Rinehart, MS, LMFT, Director of the Counseling Center'),
(189, 188, 'Jennifer Ehalt, PsyD, LP, Staff Psychologist'),
(190, 188, 'Hannah Godbout, PsyD, LP, Staff Psychologist')
;