How to Hire Employees

Document Sample
How to Hire Employees Powered By Docstoc
					                                                  INSTRUCTIONS
                                           Resident Physicians and Dentists

  Before using this spreadsheet for the first time you must activate Excel's Add-Ins by selecting Tools on the menu bar,
                           choose Add-Ins, check the Analysis ToolPak box and click on OK.

Step 1: Enter employee information in the Employee Information worksheet

Begin by entering the employee's name, employee number, date of hire and agency into the Employee Information
worksheet. Next enter the employee's FTE and the carry-over balance of unused sick leave from the prior year for
continuing employees. For new hire employees, enter their FTE into the New Hire Faculty section of the worksheet.
The program will calculate the beginning leave based on their FTE. The information will auto fill the quarterly
worksheets.

Step 2: Begin entering leave on the quarterly worksheets

First enter the full-time leave accrual rate of 1.25 and the employee's FTE. FTE should be entered in percent (i.e. 50%,
100%). Earned leave is automatically calculated based on the full-time leave accrual rate and the FTE entered for the
employee.

Leave for full-time residents is used in increments of a half-day or a full-day. Record the leave by first finding the day
of the month in cells A8 through A38, then enter the portion of the day used (i.e. .5 or 1) in either the Sick, Family
Sick, Annual and Other column for the corresponding month. If the leave is "Other", enter the leave with the
corresponding leave type such as C for Civil; M for Military; OL for Other Paid Leave, such as Administrative or W
for Leave With Out Pay. (Example: 1-C)
A running balance for the quarter can be found in cells N7 through N9 for sick; Q7 through Q9 for annual and R6 for
family sick used. Leave balances for the quarter are automatically brought forward to the next quarter.

FMLA leave should be recorded both on the quarterly worksheets and on the FMLA worksheet. The FMLA worksheet
tracts the leave in hours so you will need to make that conversion. The worksheet will give you a summary of the
hours used and available hours remaining.
               RESIDENT PHYSICIANS AND RESIDENT DENTISTS LEAVE POLICIES
Annual leave of up to 15 days at full salary per fiscal year will be available starting July 1 of each year. If an employee
is less than full time, the days are prorated by their FTE. For example, if an employee is 50% fte they earn 7.5 days per
year. There is no carry-over of annual leave from one fiscal year to the next. Annual leave for full-time residents is used
in increments of a half-day or a full-day. Residents shall not be paid for any unused annual leave upon termination of
employment. Annual leave shall be taken at a time approved or directed by the supervisor.


Sick leave will be granted as required, up to 15 days at full salary, available at any time during the initial 12 months of
service. Beginning 12 months after the starting date of his or her contract, the Resident will begin to accrue additional
sick leave at a rate of 1-1/4 days per full month of service to add to any remaining balance of unused sick leave from the
first 12 months of service. Sick leave may be accrued from year to year not to exceed 15 work days at the last day of
each month. Residents shall not be paid for any unused sick leave upon termination of employment. Residents may use
accumulated sick leave for temporary disabilities, which includes child bearing. Unpaid child rearing leave may be
requested by either parent up to a maximum of one year. Request for child rearing leave must be accompanied by a
statement from a qualified professional source if there is a medical or psychological need for the parent to be given
leave. Residents are also entitled to the leave benefits provided in federal and state law including the Family and
Medical Leave Act of 1993.

Leave Policies can be found on the Human Resources website at:
http://www.unr.edu/vpaf/hr/benefits/leave.html#fac_alv
                           EMPLOYEE INFORMATION
                                          Name:
                                Employee Number:
                                       Hire Date:                                        12/30/1900
                                         Agency:


     FOR CONTINUING RESIDENTS, ENTER THE CARRY OVER
   SICK LEAVE BALANCE FROM THE PRIOR FISCAL YEAR AND
                  THE EMPLOYEE'S FTE

Enter carry-over or beginning Sick Leave:
                         Enter employee's FTE:
                       Beginning Annual Leave:


                              Leave Calculator for New hire Residents

                         Enter employee's FTE:
                          Beginning Sick Leave:                             DAYS




   ***Leave Keeping for New Hire Residents

   How to use this form: Use the leave calculator above by entering the new hire resident’s FTE.
   The Calculator will provide a beginning sick leave amount. Enter this amount in the carry-over or beginning sick l

   If the employee is showing sick leave as accruing at any rate, leave it blank.
   On the leave record tabs that follow, enter a zero or keep the Sick Leave Rate.
   By doing this, the spreadsheet will not calculate any new accrued sick leave for your new hire resident for the first
   By entering a hire date of July 1 of the current fiscal year, the spreadsheet will automatically stop the calculation o
   leave for the year.
dent’s FTE.
e carry-over or beginning sick leave box above.




r new hire resident for the first year.
matically stop the calculation of earned sick
                                                                                                July-Sept



                ATTENDANCE AND LEAVE RECORD 2010 - 2011                                                                   BEGINNING FISCAL YR         SICK
                                                                                                                            ANNUAL LEAVE &           ANNUAL
Employee:                                                                Hire Date:                                     CARRY-OVER SICK LEAVE
Employee Number:                                                         Sick Leave Rate:                                                                                  FAMILY SICK
Agency:                                                                            FTE:                                                                                    USED TO DT
                JULY                          AUGUST                          SEPTEMBER                                        SICK LEAVE            ANNUAL LEAVE
            Family                           Family                           Family
DAYS Sick    Sick    Annual   Other   Sick    Sick    Annual   Other   Sick    Sick    Annual     Other                 ERN'D       USED   BAL.     ERN'D USED BAL.
   1                                                                                                        7/31/2010
   2                                                                                                        8/31/2010
   3                                                                                                        9/30/2010
   4
   5
   6
   7
   8
   9                                                                                                                    Please sign below if you are in agreement and
  10                                                                                                                    return this form to your leave keeper. If you do
  11                                                                                                                    not agree with the balances above, please
  12                                                                                                                    notify your leave keeper as soon as possible.
  13
  14
  15
  16                                                                                                                    Signature
  17
  18
  19                                                                                                                    Date
  20
  21
  22
  23                                                                                                                    Signature of leave keeper
  24
  25
  26
  27
  28
  29
  30
  31


OTHER CODES: C-CIVIL M-MILITARY OL-OTHER PAID LEAVE W-WITHOUT PAY


                                                                                                 Page 6
                                                                                                                                                   Oct-Dec
                          ATTENDANCE AND LEAVE RECORD 2010 - 2011                                                      3RD QUARTER            SICK
                                                                                                                      LEAVE BALANCE          ANNUAL
Employee:                                                              Hire Date:
Employee Number:                                                       Sick Leave Rate:   1.25                                                                FAMILY SICK
Agency:                                                                            FTE: 100.0%                                                                USED TO DT
           OCTOBER                            NOVEMBER                        DECEMBER                                   SICK LEAVE          ANNUAL LEAVE
              Family            Othe          Family            Othe          Family
DAYS   Sick    Sick    Annual     r    Sick    Sick    Annual     r    Sick    Sick    Annual   Other                ERN'D USED BAL. ERN'D USED BAL.
   1                                                                                                    10/31/2010    1.25      1.25
   2                                                                                                    11/30/2010    1.25      2.50
   3                                                                                                    12/31/2010    1.25      3.75
   4
   5
   6
   7
   8                                                                                                                 Please sign below if you are in
   9                                                                                                                 agreement and return this form to your
  10                                                                                                                 leave keeper. If you do not agree with
  11                                                                                                                 the balances above, please notify your
  12                                                                                                                 leave keeper as soon as possible.
  13
  14
  15
  16                                                                                                                 Signature
  17
  18
  19                                                                                                                 Date
  20
  21
  22
  23                                                                                                                 Signature of leave keeper
  24
  25
  26
  27
  28
  29
  30
  31


OTHER CODES: C-CIVIL M-MILITARY OL-OTHER PAID LEAVE W-WITHOUT PAY




                                                                                                                                                    Page 7
                                                                                            Jan-March


                       ATTENDANCE AND LEAVE RECORD 2010 - 2011                                                                PRIOR YEAR             SICK           3.75
                                                                                                                         LEAVE BALANCE              ANNUAL
Employee:                                                                   Hire Date:
Employee Number:                                                             Sick Leave Rate:      1.25                                                                    FAMILY SICK
Agency:                                                                                 FTE:                                                                               USED TO DT
               JANUARY                           FEBRUARY                            MARCH                                    SICK LEAVE            ANNUAL LEAVE
              Family                            Family                           Family
DAYS   Sick    Sick     Annual   Other   Sick    Sick    Annual   Other   Sick    Sick    Annual   Other               ERN'D USED       BAL.      ERN'D USED     BAL.
   1                                                                                                       1/31/2011                       3.75
   2                                                                                                       2/28/2011                       3.75
   3                                                                                                       3/31/2011                       3.75
   4
   5
   6
   7
   8
   9                                                                                                                   Please sign below if you are in agreement and
  10                                                                                                                   return this form to your leave keeper. If you do
  11                                                                                                                   not agree with the balances above, please
  12                                                                                                                   notify your leave keeper as soon as possible.
  13
  14
  15
  16                                                                                                                   Signature
  17
  18
  19                                                                                                                   Date
  20
  21
  22
  23                                                                                                                   Signature of leave keeper
  24
  25
  26
  27
  28
  29
  30
  31


OTHER CODES: C-CIVIL M-MILITARY OL-OTHER PAID LEAVE W-WITHOUT PAY

                                                                                              Page 8
                                                                                                  April-June



                   ATTENDANCE AND LEAVE RECORD 2010 - 2011                                                                    1ST QUARTER               SICK            3.75
                                                                                                                            LEAVE BALANCE              ANNUAL
Employee:                                                                   Hire Date:
Employee Number:                                                             Sick Leave Rate:       1.25                                                                       FAMILY SICK
Agency:                                                                                 FTE:                                                                                   USED TO DT
             APRIL                                 MAY                               JUNE                                      SICK LEAVE              ANNUAL LEAVE
              Family                           Family                           Family
DAYS   Sick    Sick    Annual   Other   Sick    Sick    Annual   Other   Sick    Sick    Annual      Other                 ERN'D USED BAL.         ERN'D    USED      BAL.
   1                                                                                                           4/30/2011               3.75
   2                                                                                                           5/31/2011               3.75
   3                                                                                                           6/30/2011               3.75
   4
   5
   6
   7
   8
   9                                                                                                                       Please sign below if you are in agreement and
  10                                                                                                                       return this form to your leave keeper. If you do
  11                                                                                                                       not agree with the balances above, please
  12                                                                                                                       notify your leave keeper as soon as possible.
  13
  14
  15
  16                                                                                                                       Signature
  17
  18
  19                                                                                                                       Date
  20
  21
  22
  23                                                                                                                       Signature of leave keeper
  24
  25
  26
  27
  28
  29
  30
  31


OTHER CODES: C-CIVIL M-MILITARY OL-OTHER PAID LEAVE W-WITHOUT PAY



                                                                                                   Page 9
                                    2010/2011 FMLA Summary
                                                       Current Year
                                      Employee's FTE:     100%
        Regular FMLA Allowable hours according to FTE:     480

                                FMLA 1: Total hours used:                    0.00
                                FMLA 2: Total hours used:                    0.00
                                FMLA 3: Total hours used:                    0.00
                      Roll back hours from prior 12 months:                  0.00

                              Summary of hours used:
                             Regular FMLA hours used:   0.00
                   Military Caregiver FMLA hours used:  0.00
          Total combined (Reg & Military) hours used:   0.00
           Regular FMLA Remaining Hours Available: 480.00


    Military Caregiver Allowable hours according to FTE:                   1040.00
           Summary of Military Caregiver hours used:
                       *Military Caregiver FMLA Hours Used:     0.00
                 Military Roll back hours from prior 12 months: 0.00
             Military Caregiver Remaining Hours Available: 1040.00

*Military Caregivier leave is available during "a single 12 month period" during which an
eligible employee is entitled to a combined total of 26 weeks of all types of FMLA.
mary
           Previous Year



                0.00
                0.00
                0.00




       Equivalent to 26 weeks

                0.00
      Employee:                                                                                                            Total Roll back hours:                  (hours rolled back from previous year)
      Employee #:                                                       Enter carry-over hours:                (Carry over from previous year)
      Enter FMLA Start Date:                                            Total hours used YTD:                  (Current year)
                     Remaining hours available: 480.00                     FMLA #3 total used:                 (Carry-over hours + current year hours for 3rd FMLA event minus roll-back hours)
                   JULY                               AUGUST                              SEPTEMBER                                  OCTOBER                                    NOVEMBER                                  DECEMBER                             JANUARY                            FEBRUARY
                                    Roll                                  Roll                                  Roll                                        Roll                                          Roll                                Roll                                Roll                                Roll
DAY    Sick   Annual LWOP   Other   Back   Sick   Annual LWOP   Other     Back    Sick   Annual LWOP   Other    Back     Sick   Annual LWOP         Other   Back     Sick   Annual LWOP           Other   Back   Sick   Annual LWOP   Other   Back   Sick   Annual LWOP   Other   Back   Sick   Annual LWOP   Other   Back
  1
  2
  3
  4
  5
  6
  7
  8
  9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31



              Notes:
           MARCH                                APRIL                             MAY                              JUNE
                             Roll                              Roll          Annua              Roll          Annua              Roll
Sick   Annual LWOP   Other   Back   Sick   Annual LWOP Other   Back   Sick     l   LWOP Other   Back   Sick     l   LWOP Other   Back
       Employee:                                                                                                            Total Roll back hours:                  (hours rolled back from previous year)
       Employee #:                                                       Enter carry-over hours:                (Carry over from previous year)
       Enter FMLA Start Date:                                            Total hours used YTD:                  (Current year)
                      Remaining hours available: 480.00                     FMLA #3 total used:                 (Carry-over hours + current year hours for 3rd FMLA event minus roll-back hours)
                    JULY                               AUGUST                              SEPTEMBER                                  OCTOBER                                    NOVEMBER                                  DECEMBER                             JANUARY                             FEBRUARY
                                     Roll                                  Roll                                  Roll                                        Roll                                          Roll                                Roll                                Roll
DAY     Sick   Annual LWOP   Other   Back   Sick   Annual LWOP   Other     Back    Sick   Annual LWOP   Other    Back     Sick   Annual LWOP         Other   Back     Sick   Annual LWOP           Other   Back   Sick   Annual LWOP   Other   Back   Sick   Annual LWOP   Other   Back   Sick   Annual
   1
   2
   3
   4
   5
   6
   7
   8
   9
  10
  11
  12
  13
  14
  15
  16
  17
  18
  19
  20
  21
  22
  23
  24
  25
  26
  27
  28
  29
  30
  31



               Notes:
FEBRUARY                           MARCH                                APRIL                               MAY                                 JUNE
                 Roll                                Roll                                Roll                                Roll                                Roll
  LWOP   Other   Back   Sick   Annual LWOP   Other   Back   Sick   Annual LWOP   Other   Back   Sick   Annual LWOP   Other   Back   Sick   Annual LWOP   Other   Back
       Employee:                                                                                                             Total Roll back hours:                  (hours rolled back from previous year)
       Employee #:                                                       Enter carry-over hours:                (Carry over from previous year)
       Enter FMLA Start Date:                                            Total hours used YTD:                  (Current year)
                      Remaining hours available: 480.00                     FMLA #3 total used:                 (Carry-over hours + current year hours for 3rd FMLA event minus roll-back hours)
                    JULY                               AUGUST                               SEPTEMBER                                  OCTOBER                                   NOVEMBER                                  DECEMBER                             JANUARY                             FEBRUARY
                                     Roll                                  Roll                                  Roll                                         Roll                                         Roll                                Roll                                Roll
DAY     Sick   Annual LWOP   Other   Back   Sick   Annual LWOP   Other     Back    Sick   Annual LWOP   Other    Back      Sick   Annual LWOP         Other   Back     Sick   Annual LWOP          Other   Back   Sick   Annual LWOP   Other   Back   Sick   Annual LWOP   Other   Back   Sick   Annual
   1
   2
   3
   4
   5
   6
   7
   8
   9
  10
  11
  12
  13
  14
  15
  16
  17
  18
  19
  20
  21
  22
  23
  24
  25
  26
  27
  28
  29
  30
  31



               Notes:
FEBRUARY                           MARCH                                APRIL                               MAY                                 JUNE
                 Roll                                Roll                                Roll                                Roll                                Roll
  LWOP   Other   Back   Sick   Annual LWOP   Other   Back   Sick   Annual LWOP   Other   Back   Sick   Annual LWOP   Other   Back   Sick   Annual LWOP   Other   Back
       Employee:                                                                  Enter FTE:    100%                     Total Roll back hours:                   (hours rolled back from previous year)
       Employee #:                                                   Enter carry-over hours:                 (Carry over from previous year)
       Enter FMLA Start Date:                                         Total hours used YTD:                  (Current year)
                      Remaining hours available: 1040.00            Military FMLA total used:                (Carry-over hours + current year hours for Military FMLA event minus roll-back hours)


                    JULY                               AUGUST                           SEPTEMBER                                  OCTOBER                                    NOVEMBER                                DECEMBER                             JANUARY                             FEBRUARY
                                     Roll                                Roll                                 Roll                                        Roll                                        Roll                                Roll                                Roll
DAY     Sick   Annual LWOP   Other   Back   Sick   Annual LWOP   Other   Back   Sick   Annual LWOP   Other    Back     Sick   Annual LWOP         Other   Back      Sick   Annual LWOP        Other   Back   Sick   Annual LWOP   Other   Back   Sick   Annual LWOP   Other   Back   Sick   Annual
   1
   2
   3
   4
   5
   6
   7
   8
   9
  10
  11
  12
  13
  14
  15
  16
  17
  18
  19
  20
  21
  22
  23
  24
  25
  26
  27
  28
  29
  30
  31


               Notes:
FEBRUARY                           MARCH                                APRIL                               MAY                                 JUNE
                 Roll                                Roll                                Roll                                Roll                                Roll
  LWOP   Other   Back   Sick   Annual LWOP   Other   Back   Sick   Annual LWOP   Other   Back   Sick   Annual LWOP   Other   Back   Sick   Annual LWOP   Other   Back

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:5
posted:11/14/2010
language:English
pages:19
Description: How to Hire Employees document sample