Faculty Profile Data Dictionary

Parent Element Child Element Description Data Type Length
Listing Contact information and uploaded portrait
Portrait_url The URL on faculty.utah.edu to retrieve the portrait Varchar 75
Listing > Listing_Data Some additional listing data
Name Preferred name Varchar 100
Web_address Preferred web page Varchar 2000
Email_address Preferred email address Varchar 100
Phone Preferred phone number Varchar 12
Listing > Office Contact information
Phone Office Phone Varchar 12
Fax Office Fax Varchar 12
Room Room number Varchar 25
Office > Building Building information
Name Readable name Varchar 100
Number Building number Integer 4
Abbreviation Building abbreviation Varchar 10
Building > Address Building mailing address
Street Varchar 60
City Varchar 20
State State abbreviation Varchar 2
Zipcode Integer 5
Appointments Appointments that this person previously or currently had
Appointment Utah_department Department if this appointment is at the University of Utah Varchar 100
Non_utah_department Department name if this appointment is NOT at the University of Utah Varchar 100
Title Appointment title Varchar 100
Institution Institution where the appointment is Varchar 250
Start_date Date the appointment began Date
End_date Date the appointment ended Date
CV Cv_url URL on faculty.utah.edu to retrieve the CV Varchar 75
Biosketch Bio_url URL on faculty.utah.edu to retrieve the Biosketch Varchar 75
Degrees Degrees this person has received
Degree Type The type of degree (B.S., Ph.D.) Varchar 100
Subject Degree subject Varchar 100
Institution Varchar 250
Title Project Title Varchar 400
Awards Awards/Accolades this person has received
Award Descrption Description of this award Varchar 1000
Organization Organization that granted this award Varchar 200
Received_date Date received Date
Global_Impact (See Global Impact)
Biography (text only) Person’s biography Rich Text
Affiliates Organizations this person is affiliated with
Affiliate Organization Name of the organization Varchar 100
Abbreviation Organization’s abbreviated name Varchar 20
Role Role this person played Varchar 100
Start_Date Date affiliation began Date
End_Date Date affiliation ended Date
Media_Exposures Instances that this person has been featured in the media
Media_Exposure Description Description of the media exposure Varchar 2000
URL Related URL Varchar 2000
Date Date occurred Date
Global_Impact (See Global Impact)
Entrepreneurial_Experiences Any significant entrepreneurial experiences
Entrepreneurial_Experience Organization The organization or company name Varchar 150
Revenue Monthly Revenue (in dollars) Float
Start_Date Date experience began Date
End_Date Date experience ended Date
Description Additional comments or description Varchar 2000
Global_Impact (See Global Impact)
Professional_Organizations Professional Organizations that the user is a member of
Professional_Organization Organization The name of the organization Varchar 250
Position The position that the user holds Varchar 100
Start_Date Date
End_Date Date
Global_Impact (See Global Impact)
Small_Group_Teaching Information about small groups the user has taught
Small_Group_Teaching Description A description of the course Varchar 4000
Hours The number of hours dedicated to this course, per the frequency Integer
Frequency The frequency applied to the number of hours. E.g. “30 hours per Week.” Varchar Day, Week, Month, Semester, Year, None
Start_Date Date
End_Date Date
Global_Impact (See Global Impact)
Bar_Admissions Bar Admission dates and description
Bar_Admission Description A description of the Admission Varchar 2000
Date The date of the Admission Date
Global_Impact (See Global Impact)
Languages Languages this person knows
Language Name Name of the language Varchar 150
Fluency Level of fluency Varchar 10
Regions_of_Interest Geographical regions of interest
Region_of_Interest Region Name of the region Varchar 500
Conferences International conferences attended
International_Work Region Location of the conference Varchar 500
Description Description of the conference Varchar 4000
Start_Date Date
End_Date Date
Global_Impact (See Global Impact)
Teaching_Abroad Teaching activities abroad
International_Work Region Location where this took place Varchar 500
Description Description of the activity Varchar 4000
Start_Date Date
End_Date Date
Global_Impact (See Global Impact)
International_Research Research conducted abroad
International_Work Region Location where research took place Varchar 500
Description Description of the research Varchar 4000
Start_Date Date
End_Date Date
Global_Impact (See Global Impact)
Otherdata_Biography Additional biographical information
Title The title of this section (self-entered, e.g. “About Me,” “Favorite Movies,” etc.) Varchar 30
Text Rich Text
Research_Summary Short summary of research activities Varchar 2000
Research_Statement Research Statement Rich Text
Research_Keywords Searchable keywords about research activities and interests
Research_Keyword Interest Interest level (1-5) Integer 5
Keyword Searchable keyword Varchar 500
Research_Equipment Equipment that this person is experienced with or has access to
Equipment Summary Summary of the equipment Varchar 2000
Patents Patents this person has filed
Patent Name Name of the patent Varchar 250
File_Date Date patent was filed Date
Issue_Date Date patent was issued Date
Status Status of the patent Varchar 40
Country Country it was issued in Varchar 40
Assignee Assignee of the patent Varchar 500
Inventors All inventors on the patent Varchar 2000
Global_Impact (See Global Impact)
Copyrights Copyrights this person holds
Copyright Title Title of the copyright Varchar 200
Date Date copyright was issued Date
Comments Any comments Varchar 4000
Global_Impact (See Global Impact)
Copyright > Holders People holding this copyright
Name Name of one copyright holder Varchar 200
Softwares Software this person has written
Software Title Title of the software Varchar 500
Release_Date Date released Date
Inventors People/companies who invented/wrote/worked on this software Varchar 2000
Description Description of the software Varchar 2000
Distribution Distribution information Varchar 2000
Global_Impact (See Global Impact)
Otherdata_Research Additional research information
Title The title of this section Varchar 30
Text Rich Text
Publications Works published by this person
Publication Citation Full citation of the publication Rich Text
Date Date it achieved the given status Date
Status Status of the publication (Published, In Progress) Varchar 15
URL Related URL Varchar 2000
Type Publication Type (Article, etc.) Varchar 75
Category Publication Category (School of Business) Varchar 150
Global_Impact (See Global Impact)
Presentations Presentations given by this person
Presentation Citation Full citation of the presentation Rich Text
Date Date it achieved the given status Date
Status Status of the presentation (Presented, In Progress) Varchar 15
URL Related URL Varchar 2000
Type Presentation Type (Lecture, etc.) Varchar 75
Global_Impact (See Global Impact)
Courses Courses currently being taught
Course ID The ID of the Course Integer
CourseTitle The title of the Course Varchar 30
CourseNumber The Course Number, made up of the Subject, Catalog Number, and Section. E.g. “CS 2100-001” Varchar 20
Semester The String description of the term Varchar 20
Term The Term ID when the course is taught Varchar 4
Teaching_Philosophy A statement of the user’s Teaching Philosophy Rich Text
Courses_Taught Courses this person teaches or has taught
Course_Taught Title Title of the course Varchar 50
Course_Number Course number Varchar 50
Description Description of course Rich Text
Teaching_Projects Teaching Projects this person works on
Teaching_Project Title Title of the project Varchar 200
Lead Project lead Varchar 100
Source_Of_Funds Source of funding for this project Varchar 200
Start_Date Date
End_Date Date
Global_Impact (See Global Impact)
Teaching_Project > Collaborators Collaborators on this project
Name Name of one collaborator Varchar 200
Professional_Education Professional Education classes taught by the user
Professional_Education Name The name of the class Varchar 255
Description A description of the class Varchar 2000
Num_Hours The length of the class Integer
Class_Type The type of class – chosen from a dropdown list Varchar Active Learning, Lecture, Simulation, Problem-Based Learning, Lab-Based Learning
Start_Date Date
End_Date Date
Global_Impact (See Global Impact)
Library_Instructions Course, Workshop, Seminar, and Learning Tools information
Instruction Title Title of Workshop/Tool
Coinstructiors Names of Co-Instructors Varchar 200
Comment Additional Comments Varchar 200
Far_Year The year the activity took place Integer
Num_Attendees Number of Attendees Integer
Num_Meetings Number of Meetings Integer
Start_Date Date
End_Date Date
Instruction > Type Type Type of Instruction – Chosen from a dropdown list Varchar Single-Section Course, Multi-Section Course, Library Workshop/Seminar, Learning Tools, Library Tour/Orientation, Other
Instruction > Student_Affiliations List of selected student affiliations
Student_Affiliations > Affiliation Selected (attribute) “True” or “False” if the entry was selected Varchar True/False
Type The Student Affiliation Varchar 25
Otherdata_Teaching Additional teaching information
Title The title of this section Varchar 30
Text Rich Text
Current_Students Current Graduate Students
Student Name Name of graduate student Varchar 200
Degree Degree being pursued Varchar 500
Grad_Date Planned graduation date Date
Non_Utah_Institution Institution, if not the University of Utah Varchar 200
Role Role on Graduate Committee (Chair or Member) Varchar 40
Project_Type Type of Graduate Project (Thesis, Project, Dissertation, Other) Varchar 40
Global_Impact (See Global Impact)
Former_Students Former Graduate Students
Student Name Name of graduate student Varchar 200
Degree Degree being pursued Varchar 500
Grad_Date Graduation date Date
Non_Utah_Institution Institution, if not the University of Utah Varchar 200
Role Role on Graduate Committee (Chair or Member) Varchar 40
Project_Type Type of Graduate Project (Thesis, Project, Dissertation, Other) Varchar 40
Global_Impact (See Global Impact)
Student_Projects Student projects in which this person plays a role
Student_Project Description Description of project Varchar 500
Start_Date Date
End_Date Date
Global_Impact (See Global Impact)
Student_Project > Students List of students on this project
Name Name of one student Varchar 200
Professional_Service Service this person has done on a professional level
Service Description Description of service Varchar 2000
Organization Organization service was performed with or performed for Varchar 250
Part_Played Part this person played Varchar 2000
Start_Date Date
End_Date Date
Global_Impact (See Global Impact)
Internal_Service Service this person has performed internally (i.e. within the University of Utah)
Service Description Description of service Varchar 2000
Organization Organization service was performed with or performed for Varchar 250
Part_Played Part this person played Varchar 2000
Start_Date Date
End_Date Date
Global_Impact (See Global Impact)
Outreach_Service “Community Outreach” service performed
Service Description Description of service Varchar 2000
Organization Organization service was performed with or performed for Varchar 250
Part_Played Part this person played Varchar 2000
Start_Date Date
End_Date Date
Global_Impact (See Global Impact)
Community_Partnership “Community Partnership” service performed
Service Description Description of service Varchar 2000
Organization Organization service was performed with or performed for Varchar 250
Part_Played Part this person played Varchar 2000
Start_Date Date
End_Date Date
Global_Impact (See Global Impact)
Mentoring_Service Mentoring service performed
Service Description Description of service Varchar 2000
Organization Organization service was performed with or performed for Varchar 250
Part_Played Part this person played Varchar 2000
Start_Date Date
End_Date Date
Global_Impact (See Global Impact)
Otherdata_Service Additional service information
Title The title of this section Varchar 30
Text Rich Text
Practice_Histories Practice history (Nursing)
Practice_History Description Description of the practice Varchar 4000
Date Date
URL Related URL Varchar 2000
Global_Impact (See Global Impact)
Patient_Satisfactions Patient satisfaction reports (Nursing)
Patient_Satisfaction Description Description of patient satisfaction report Varchar 4000
Date Date
URL Related URL Varchar 2000
Global_Impact (See Global Impact)
Mailing_Address Person’s mailing address (building)
Name Readable name Varchar 100
Number Building number Integer 4
Abbreviation Building abbreviation Varchar 10
Mailing_Address > Address Building mailing address
Street Varchar 60
City Varchar 20
State State abbreviation Varchar 2
Zipcode Integer 5
Social_Media_Links Links to Social Media
Social_Media_Link Type The Social Media site – Selected from dropdown list Varchar Facebook, LinkedIn, Twitter, Youtube
URL The URL provided Varchar 1000
More_Links Additional Links provided by the user
Link Title The title of the link Varchar 30
URL The URL provided Varchar 1000