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 |
|