...

...

...

Sandbox Practice Scenarios

Distribution

Chief Human Resource Officer

UVA HRMS Specialist

UVA HRMS Faculty/Staff Reviewer

Ownership

The Chief Human Resource Officer is responsible for ensuring that this document is necessary, reflects actual practice, and supports University policy.

Sandbox Practice Scenarios

Use the following scenarios to practice entering Human Resources data. 

These scenarios provide the data to enter into the fields.  However, they do not contain the step-by-step instructions.  Those instructions are found in the appropriate navigation instructions, indicated at the start of each scenario.

The scenarios include the following topics:

• Hire Salaried Faculty
• Hire Student Wage and Faculty Hourly Wage
• Hire GRA/GTA Faculty Wage (Goal Payment)

Scenario 1: Hire Salaried Faculty

Hire a salaried faculty member. 

Refer to Hire Salaried Faculty.

1. Change Effective Date to a day one week in the future.

2. Make up a name and the personal data for the faculty member.  Be sure not to use yourself or a person who is already an employee of the University.  Create information for the following sections:

People Form header information (i.e. Name, Gender, Type, SS#, etc.)

Alternate Regions:

• Personal Information (i.e. Birth Date, Mail To, Status, Email, Has Disability)
• Employment Information (i.e. Ethnic Origin, Veteran Status)
• Further Name Information (i.e. Preferred Name, Previous Last Name)
• Additional Personal Details Descriptive Flexfield (DFF)(i.e. Email Preferred)

Use the following information to complete the employee record.

3. Address:  Create two address records:

Home Address: 

• Make this the primary address. 
• 22440 Main Street, Charlottesville, VA 22901
• Publish Home Phone # & Address ?:  No

Messenger/Office: 

• PO Box 400805, 2400 Old Ivy Road, Charlottesville, VA 22904-4805

4. Foreign Address: 

• Style:  United Kingdom
• 15 Cheltenham Road, Birmingham, B34 6JT, United Kingdom
• Type:  Foreign Address

5. Phone Information:  Create two phone numbers.

• Home:  434-555-1213
• Work:   434-243-1111

6. Schools and Colleges Attended:  Create two schools.

• Georgetown University; 01-SEP-1990- 30-MAY-1996
• College of William and Mary; 01-SEP-1985- 30-MAY-1989.

7. Qualifications:  Enter two degrees.

First Degree:

• Type:  PhD-Doctor of Philosophy
• Start Date:  01-SEP-1990
• End Date:  30-MAY-1996
• Status:  Complete
• Establishment:  Georgetown University

Second Degree:

• Type:  BS-Bachelor of Science
• Start Date:  01-SEP-1985
• End Date:  30-MAY-1989
• Status:  Complete
• Establishment:  College of William and Mary

8. Contact:  Use the LOV to enter the contact name for the spouse of the faculty member.  If the contact name is not in the database, key in the contact name in the contact form.  Make up the contact name and other information for this lab.

9. Emp-Endowed Chair: 

• Name:  James Carroll Flippin Professorship in Medical Science
• Chair Type:  UVA Chair Type
• Title of Chairholder for BOV:  James Carroll Flippin Professor in Medical Science
• Effective Date:  Use Hire Date

10.    App-Work History:  Create 3 Work History records

First work history

• Start Date:  01-SEP-1990
• End Date:  31- AUG -1995
• Institutional Name:  University of Vermont
• Job Title:  Assistant Professor
• (Other fields are optional for faculty)

Second work history

• Start Date:  01-SEP-1996
• End Date:  31- AUG -1998
• Institutional Name:  Yale University
• Job Title:  Assistant Professor
• (Other fields are optional for faculty)

11.    Third work history

• Start Date:  01-SEP-1999
• End Date:  31-AUG-2001
• Institutional Name:  Brown University
• Job Title:  Professor
• (Other fields are optional for faculty)

12.    Emp-Administrative Appointment: Create one Administrative Appointment record.

• Start Date:  Use Hire Date
• Admin Appt Type:  Chair, Academic Dept
• Admin Appt Title:  Chair, Department of Biochemistry
• Expected End Date:  One year from hire date.

13.    Emp-Committee:  Create one Committee record.

• Start Date:  Use Hire Date
• Committee Name:  Law School, Promotion & Tenure
• Type of Committee:  School
• Committee Chair (Y/N):  No.
• Expected End Date:  If Applicable

14.    Emp-Directory Name:  Enter the full name to appear in the UVA telephone directory.

• Start Date:  Use Hire Date
• First Name
• Middle Name
• Last Name
• Suffix

15.    EMP-EOP Reference

• Start Date:  Use Hire Date
• EOP Reference Number: 1234

16.    EMP-HSF Information:  For SOM only (i.e. Physicians getting pay check from HSF)

• Start Date:  Enter the hire date.
• End Date:  Enter one year from the hire date.
• HSF Supplement:  25000 
• Total Compensation:  75000
• HSF PTAO1:  100006.101.SG00001.40400 
• HSF PTAO1%:  100
• Contract Name:  EA - Employment Agreement (LOV)
• Contract Begin Date:  Enter the hire date.
• Contract End Date:  Enter one year from the hire date.

17.    Assignment:

• Organization:  40400
• Job Type:  Faculty, HSF (LOV)
• Compensation Type:  Salaried (LOV)
• Employment Category:  Fulltime (LOV)
• Parttime FTE Percent:  Leave blank.
• Appointment Duration:  Greater than 6 mo (LOV)
• Job:  Professor.Professor
• Position:  40400.Professor of Biochemistry.Teaching and Research.F0002
• Grade:  Faculty.1
• Payroll:  Monthly
• Employment Category:  Fulltime-Regular

18.    Supervisor Alternate Region:

• Name:  Use the LOV to select your name.

19.    Standard Conditions Alternate Region: Verify that the following fields are correct -

• Working Hours:  40
• Frequency:  Week

20.    GRE's and Other Data Alternate Region:

• Government Reporting Entity:  A1000 Rector/Board of Visitors (LOV)
• Timecard Required:  No

21.    Miscellaneous Alternate Region:

• Primary:  Check this field.

22.    Salary Information Alternate Region:

• Salary Basis:  Annual Salary

23.    Additional Assignment Details (DFF):

• Assignment Change Reason:  New Hire (LOV)
• Formal Faculty Title:  Professor of Biochemistry (Free form)
• Appointment Start Date:  Use hire date.
• Appointment End Date:  Enter three years from date of hire.
• Number of Work Months:  Leave Blank

24.    Salary Administration Form:

• Change Date:  Enter the hire date.
• New Value:  75000
• Reason:  New Hire.

25.    Budget Values:

• Value:  1
• Unit:  Full Time Equivalent

26.    Tenure Track:

• Tenure Status:  Tenure Track (LOV)
• Track Type:  Academic Investigator (LOV)
• Original Tenure Eligibility Date:  Enter hire date.
• Projected Tenure Eligibility End Date:  Enter date 6 years from hire date.
• Organization:  40400

Scenario 2: Hire Student Wage and Faculty Hourly Wage

Hire a student. 

Refer to Hire Student Wage and Faculty Hourly Wage.

1. Change Effective Date to a day two days in the future.

2. Make up a name and the personal data for the student.  Be sure not to use yourself or a person who is already an employee of the University.  Create information for the following sections:

People Form header information (i.e. Name, Gender, Type, SS#, etc.)

Alternate Regions:

• Personal Information (i.e. Birth Date, Mail To, Status, Email, Has Disability)
• Employment Information (i.e. Ethnic Origin, Veteran Status)
• Further Name Information (i.e. Preferred Name, Previous Last Name)

Use the following information to complete the employee record.

3. Address:  Create a home address record:

Home Address: 

• Make this the primary address. 
• 22440 Main Street, Charlottesville, VA 22901

Messenger/Office: 

• PO Box 400805, 2400 Old Ivy Road, Charlottesville, VA 22904-4805

4. Foreign Address:  Do not enter a foreign address for this scenario.

5. Phone Information:  Create one phone number.

• Home:  434-555-1213

6. Schools and Colleges Attended:  Do not enter for this scenario.

7. Qualifications:  Do not enter for this scenario.

8. Assignment:

• Organization:  30000
• Job Type:  Wage-Other
• Compensation Type:  Wage
• Job:  Student Worker...89322
• Position:  30000.Student Worker..
• Grade:  Student Worker-UHR.1.
• Payroll:  Bi-Weekly
• Employment Category:  Parttime-Regular

9. Supervisor Alternate Region:

• Name:  Use the LOV to select your name.

10.    Standard Conditions Alternate Region:

• Working Hours:  20
• Frequency:  Week

11.    GRE's and Other Data Alternate Region:

• Government Reporting Entity:  A1000 Rector/Board of Visitors (LOV)
• Timecard Required:  Yes

12.    Miscellaneous Alternate Region:

• Primary:  Check this field.

13.    Salary Information Alternate Region:

• Salary Basis:  Hourly Rate

14.    Additional Assignment Details (DFF):

• Assignment Change Reason:  New Hire

15.    Salary Administration Form:

• Change Date:  Enter the hire date.
• New Value:  8
• Reason:  New Hire.

16.    Oracle Time Management:

• Autogen Hours: Yes
• Rotation Plan:  Wage
• Earnings Policy:  Wage Earnings Policy

Scenario 3: GRA/GTA or Faculty Wage (Goal Payment)

Hire a Graduate Instructor. 

Refer to Hire Student Wage and Faculty Hourly Wage.

1. Change Effective Date to today's date.

2. Make up a name and the personal data for the Graduate Teaching Assistant.  Be sure not to use yourself or a person who is already an employee of the University.  Create information for the following sections:

People Form header information (i.e. Name, Gender, Type, SS#, etc.)

Alternate Regions:

• Personal Information (i.e. Birth Date, Mail To, Status, Email, Has Disability)
• Employment Information (i.e. Ethnic Origin, Veteran Status)
• Further Name Information (i.e. Preferred Name, Previous Last Name)

Use the following information to complete the employee record.

3. Address:  Create a home address record:

Home Address: 

• Make this the primary address. 
• 22440 Main Street, Charlottesville, VA 22901

Messenger/Office: 

• PO Box 400805, 2400 Old Ivy Road, Charlottesville, VA 22904-4805

4. Foreign Address:  Do not enter for this Lab.

5. Phone Information:  Create one phone number.

• Home:  434-555-1213

6. Schools and Colleges Attended:  Create one school.

• College of William and Mary, 01-Sep-1996 - 30-MAY-2000.

7. Qualifications:  Enter one degree.

• Type:  BS-Bachelor of Science
• Start Date:  01-SEP-1996
• End Date:  30-MAY-2000
• Status:  Complete
• Establishment:  College of William and Mary

8. Assignment:

• Organization:  30000
• Job Type:  Grad Teaching Assistant
• Compensation Type:  Wage
• Job:  Graduate Instructor A.89175
• Position:  30000.Graduate Instructor A..
• Grade:  Student Worker-Provost.1
• Payroll:  Bi-Weekly
• Employment Category:  Parttime-Regular

9. Supervisor Alternate Region:

• Name:  Use the LOV to select your name.

10.    Standard Conditions Alternate Region:

• Working Hours:  20
• Frequency:  Week

11.    GRE's and Other Data Alternate Region:

• Government Reporting Entity:  A1000 Rector/Board of Visitors (LOV)

12.    Miscellaneous Alternate Region

• Primary Check Box:  Check this field

13.    Salary Information Alternate Region:

• Salary Basis:  Goal Payment

14.    Additional Assignment Details (DFF):

• Assignment Change Reason:  New Hire
• Number of Goal Pay Periods:  9

15.    Salary Administration Form:

• Change Date:  Enter the hire date.
• New Value:  10000
• Reason:  New Hire.

  Effective: 07/11/02

  Revision: 1

  ---

  Copyright 2004 University of Virginia and Oracle Corporation. All rights reserved.

  Oracle® Tutor   Copyright © 1997, 2004, Oracle. All rights reserved.