Overview
The definition of attributes from a local University of Florida source of HR data and their transformation to elements in the VIVO ontology's schema. The University of Florida use PeopleSoft and an enterprise reporting data warehouse for storing and sharing human resource data.
Development Documents
- UF Directory Database Schema
- Primary Affiliation and Directory Affiliations
- UF General Accounting Chartfieds & Listing of UF Department ID
- XSLT Tutorial
- Xpath Tutorial
- XSL-FO Tutorial
HR Data to VIVO
UF Directory View Fields
- View 1 - Information
- I.UF_UUID
- P.UF_DISPLAY_NM
- P.UF_WORK_TITLE
- N.UF_NAME_TXT
- E.UF_EMAIL
- View 2 - Telephone
- T.UF_UUID
- UF_TYPE_CD
- UF_AREA_CD
- UF_PHONE_NO
- UF_PHON_EXTN
- View 3 - Address
- A.UF_UUID
- UF_TYPE_CD
- A.UF_ADDR_LINE1
- A.UF_ADDR_LINE2
- A.UF_ADDR_LINE3
- A.UF_CITY
- A.UF_STATE_CD
- A.UF_ZIP_CD
- A.UF_ZIP_BAR_CD
- View 4 - Name
- N.UF_UUID
- UF_TYPE_CD
- UF_NAME_TXT
- View 5 - UF Department Relationship
- R.UF_UUID1
- R.UF_TYPE_CD
- R.UF_BEGIN_TS
- R.UF_UUID2
- O.UF_DISPLAY_NM AS DEPT_NAME
- I.UF_IDENTIFIER
- View 6 - Historic UF Department Relationship
- R.UF_UUID1
- R.UF_TYPE_CD
- R.UF_BEGIN_TS
- R.UF_END_TS
- R.UF_UUID2
- O.UF_DISPLAY_NM AS DEPT_NAME
- I.UF_IDENTIFIER
- View 7 - Gatorlink Account
- OPRID
- USERIDALIAS
- View 8 - Job Title from Department
- UF_UUID
- UF_JOB_LONG [TITLE]
- UF_PS_DEPTID AS PRIMARY_DEPTID
VIVO | UF Directory |
---|---|
rdfs:label | |
bibo:prefixName | |
bibo:suffixName | |
foaf:firstName | |
foaf:lastName | |
core:middleName | |
ufl:gatorlink | view_7:useridalias |
core:workEmail | view_1:uf_email |
ufvivo:ufid | view_1:uf_identifier |
/vitro/0.7#moniker | view_1:uf_work_title |
core:workPhone | |
core:workFax | stu_2:uf_area_cd + |
type_cd= |
UF Directory Affiliation Type Translation
The following Affiliation Types are presented in the prioritized Category order reflected in the preceding table (i.e., Faculty through Pre–Applicant/Contact). Affiliations mapped and ingested into VIVO are identified with [VIVO].
Faculty (F):
Type 192: Faculty - [VIVO] (core:Faculty Member)
Human Resource Services - Members of UF Faculty Member pay plan.
Type 221: Consultant-Faculty - Not Included in VIVO
Any authorized UF unit may assign individuals to this affiliation for a Consultant who needs services similar to a Faculty Member of UF.
Staff (T):
Type 193: USPS Staff - Not Included in VIVO
Human Resource Services - Member of UF University Support Personnel System (USPS) pay plan.
Type 195 TEAMS Employee - [VIVO] (core:Non-Academic)
Human Resource Services - Members of UF Technical, Executive, Administrative & Managerial Support (TEAMS) pay plan.
Type 220: Consultant–Staff - Not Included in VIVO
Any authorized UF unit may assign individuals to this affiliation for a Consultant who needs services similar to a Staff Member of UF.
Student (S):
Type 191: Student - Not Included in VIVO
University Registrar - Registered for any UF college credit course regardless of the number of hours.
Type 214: DCE Student - Not Included in VIVO
University Registrar / Distance, Continuing & Executive Education (DCE) - A student, credit or not credit, taking courses through DCE. Name is required; additional identification may be provided.
Type 216: Not Registered Student - Not Included in VIVO
University Registrar - Not registered, degree–seeking.
Type 224: Newly Admitted Student - Not Included in VIVO
University Registrar - A recently admitted degree seeking student who has yet to attend or register for courses at UF.
Employee (E):
Type 194: OPS Employee - Not Included in VIVO
Other Personnel Services (OPS) - Temporary UF employees (Clinical Post Doc. Assoc/Intern, Fellowships, Federal Work Study Program, Graduate Assistant, House staff, OPS Faculty, OPS Regular, Student Assistant, Student Government & Housing) managed in the Human Resources Management System (HRMS) by Human Resource Services / Student Financial Affairs.
Type 213: Direct Support Organization Employee - Not Included in VIVO
Employee from the following Direct Support Organizations (DSO's): in UF Research Foundation, Florida 4H Club Foundation, Citrus Research & Education Foundation, Gator Boosters, and others.
Type 217: Athletic Assoc. Employee - Not Included in VIVO
UF Athletic Association Employee
Type 218: Foundation Employee - Not Included in VIVO
UF Foundation Employee
Type 219: Clinical Faculty - [VIVO] (core:Faculty Member)
(formerly AEF Base Employee) Faculty who are appointed to a clinical practice plan at the Health Science Center (HSC). Practice plans exist for Medicine, Dentistry, and Health Related Professions.
Type 236: Recent Employee - Not Included in VIVO
An individual who has formally separated from UF within the last 30 days. HRMS job actions will designate the separation.
Member (M):
Type 197: Courtesy Faculty - Not Included in VIVO
Courtesy Faculty appointments as defined and loaded from the Human Resources Management System (HRMS).
Type 198: Vendor - Not Included in VIVO
Vendor representatives who require UF services such as Gatorlink, parking, etc.
Type 200: Emeritus - [VIVO] (core:Professor Emeritus)
Faculty and other staff members who are current or retired with an Emeritus status.
Type 203: Departmental Associate - Not Included in VIVO
Any authorized UF unit may assign individuals to this affiliation to include former employees, friends of the department, and others that they routinely collaborate with and need UF services.
Type 204: Board of Trustee - Not Included in VIVO
Board of Trustee Member.
Type 205: UF Executive - Not Included in VIVO
Human Resource Services - Executive Management Employee.
Type 209: Shands Employee - Not Included in VIVO
Shands Hospital Employee
Type 237: Continuing Education Student - Not Included in VIVO
An individual who is taking a course with DCE, IFAS extension, or Academic Technology or any non-credit course, regardless of delivery method or technology or sponsoring area of UF. The activity may or may not offer CEU credits. No UF credit received for the student.
Alumni (A):
Type 208: Alumni - Not Included in VIVO
University Registrar - A UF earned degree recipient.
Affiliate (L):
Type 215: Former Student - Not Included in VIVO
University Registrar - Not registered degree seeking student who has not been enrolled for 5 terms. Specific action must be taken prior to re–admission.
Type 190: Student Applicant - Not Included in VIVO
University Registrar - A person who has submitted an admission application to a UF degree seeking program.
Type 202: Volunteer - Not Included in VIVO
Any authorized UF unit may define an individual as a volunteer.
Type 207: Library Patron - Not Included in VIVO
Any adult who does not otherwise have a university affiliation, which is eligible for using the Libraries; who properly fills out an application for access; who pays a fee; and who abides by Library rules.
Type 199: Retiree - Not Included in VIVO
Human Resource Services - Retired UF employee defined in the Human Resources Management System (HRMS).
Type 210: Campus Resident - Not Included in VIVO
Department of Housing and Residence Education Residents.
Type 222: Recent Attendee - Not Included in VIVO
A student not currently enrolled, but was enrolled within the last 2 – 5 terms.
Type 238: Former DCE Student - Not Included in VIVO
A student, credit or not credit, no longer taking continuing education courses at UF.
Type 239: Unaffiliated UF Payee - Not Included in VIVO
An individual, whose sole purpose is to receive reimbursement by UF as a guest speaker, job applicant, etc. No UF services will be provided.
Type 245: Library Workstation User - Not Included in VIVO
Provides a non-UF affiliate with access to public computer workstations operated by UF Libraries. The library will control access to services on workstations using this affiliation. This affiliation is to be used and managed solely by the university libraries.
Pre–Applicant/Contact (P):
Type 211: Pre–Applicant - Not Included in VIVO
University Registrar / Professional Colleges - A person who has begun the admission application process to a UF degree seeking program, but has not submitted an application. Examples of documents that may be used to begin the application process follow: application, transcript, letter of recommendation, financial aid application.
Type 244: Self Service User - Not Included in VIVO
An individual who needs access for any type of self-service offering of UF systems. Examples include: the Office of the Registrar wants to process transcript requests; former students needing information about student loans and payments; IFAS, and the Office of Academic Technology offering extension programming via E-Learning. These individuals are LOA1 users and identity is often self-serviced. A service provider may count on the holder of this affiliation having a one-year renewable GatorLink account subscription.