Leave Record Form 2010 by rew14037

VIEWS: 49 PAGES: 16

Leave Record Form 2010 document sample

More Info
									                           INSTRUCTIONS - EXCEL 2007
                                     Postdoctoral Fellows




Step 1: Enter employee information
Enter the employee's name, employee number, date of hire and agency on the Employee
Information worksheet. This worksheet is the only sheet that will allow you to enter employee
information. Next enter either the beginning balance or the unused balance of annual and sick
leave from the prior year. Postdocs are allowed to carry-over up to 15 days of annual and up to
15 days of sick leave from year to year. Full-time Postdocs begin their initial 12 months of hire
with 15 days of sick leave. Part-time Postdocs begin with a prorated amount of annual and sick
days based on their FTE. Use the Leave Calculator to determine the prorated days. No additional
sick leave is accrued for the first 12 months, therefore you will need to manually over ride the sick
leave earned columns for the first year with a 0 (zero) earned rate. The information entered will

Step 2: Begin entering leave
Begin recording leave on the 1st Quarter worksheet*. First enter the employee's FTE. FTE
should be entered in percentage (i.e. 50%,100%). Leave is calculated based on the full-time
accrual rate of 1.25 days per month and the employee's FTE. The prorated accrual rate for part-
time employees will automatically calculate.


*Note: If a Postdoc is hired in a quarter other than the 1st quarter, begin entering leave on the
month and quarter that they start work. Only enter the FTE on the quarterly worksheets for the
quarters that the employee worked . If the employee is hired or has an FTE change in either mid-
quarter or mid-month you can manually over ride the earned column with the correct accrual.

There are three columns of leave type in the row under the months in the quarter; Sick, Family
Sick and Annual. Enter leave taken in one of these columns.

Leave for full-time Postdocs 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 or Annual column for the corresponding month.
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.
               POSTDOCTORAL FELLOW LEAVE POLICIES

Annual leave with pay will be accrued at 1-1/4 working days per full month of continuous service.
Part-time Postdoctoral Fellows shall be granted a pro rata amount of annual leave. Annual leave
may be accumulated up to a maximum of 15 work days at the last day of each month. Earned
annual leave shall be taken at a time approved or directed by the supervisor. Annual leave for full-
time postdoctoral fellows is used in increments of a half-day or a full-day. Postdoctoral Fellows
shall not be paid for any unused annual leave upon termination of employment. Board of Regents
Handbook, Title 4, Chapter 7, Section 7.

Sick leave with pay 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 or his or her
contract, the Postdoctoral Fellow will begin to accrue additional sick leave at a rate of 1-1/4
working days per full month of service to add to any remaining balance of unused sick leave from
the first 12 months of service. Part-time Postdoctoral Fellows shall be granted a pro-rata amount
of sick leave. Sick leave may be accrued from year to year, not to exceed 15 work days at the last
day of each month. Postdoctoral Fellows shall not be paid for any unused sick leave upon
termination of employment. Board of Regents Handbook, Title 4, Chapter 7, Section 7.

Up to 15 days per contract year of earned sick leave may be used to care for or assist family
members within the third degree of relationship. Does not apply if the leave is approved under
FMLA. Board of Regents Handbook, Title 4, Chapter 3, Section 13, UNR Administrative Manual
2673 .

No payment for unused annual or sick leave at termination and no transfer of unused leave. No
exceptions will be granted.

Leave policies can be found on the Human Resources website at:
http://www.unr.edu/vpaf/hr/benefits/leave.html
          EMPLOYEE INFORMATION
                              *Required fields
                   Name:                                *
         Employee Number:                        *
           UNR Hire Date:                        *
                  Agency:

  BEGINNING OR PRIOR FISCAL YEAR LEAVE
                     Sick:
                   Annual:


BEGINNING SICK LEAVE CALCULATOR FOR NEW
              HIRE FACULTY

                Enter FTE:
      Beginning Sick Leave:                      DAYS
                                                                                            1ST QUARTER



                                    ATTENDANCE AND LEAVE RECORD 2010                                                                 BEGINNING OR                SICK
                                                                                                                                         PRIOR YEAR            ANNUAL
Employee:                                                                              Hire Date:                                  LEAVE BALANCES
Employee Number:                                                           Annual 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    H       H        H         H                                                                             1/31/2010
       2                                                                                                             2/28/2010
       3                                                                                                             3/31/2010
       4
       5                                                                                                                         Comments:
       6
    7
    8
    9
   10
   11
   12                                                                                                                            Please sign below if you are in agreement and return this form
   13                                                                                                                            to your leave keeper. If you do not agree with the balances
   14                                                                                                                            above, please notify your leave keeper as soon as possible.
   15                                         H       H        H       H
   16
   17
   18       H       H        H         H                                                                                         Signature
   19
   20
   21                                                                                                                            Date
   22
   23
   24
   25                                                                                                                            Signature of leave keeper
   26
   27
   28
   29
   30                                                                                                                            Signature of Supervisor
   31


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


                                                                                                   Page 4
                                                                                             2ND QUARTER




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


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




                                                                                                 Page 5
                                                                                         3RD QUARTER


                           ATTENDANCE AND LEAVE RECORD 2010                                                                  BEGINNING             SICK

                                                                                                                          FISCAL YEAR             ANNUAL
Employee:                                                                  Hire Date:                                   LEAVE BALANCE
Employee Number:                                                 Annual Leave Rate: 1.25                                                                              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      H     H          H     H                                                                                    Comments:
   6                                                                      H       H        H         H
   7
   8
   9
  10
  11
  12                                                                                                                  Please sign below if you are in agreement and return this form
  13                                                                                                                  to your leave keeper. If you do not agree with the balances
  14                                                                                                                  above, please notify your leave keeper as soon as possible.
  15
  16
  17
  18                                                                                                                  Signature
  19
  20
  21                                                                                                                  Date
  22
  23
  24
  25                                                                                                                  Signature of leave keeper
  26
  27
  28
  29
  30                                                                                                                  Signature of Supervisor
  31


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

                                                                                            Page 6
                                                                                              4TH QUARTER


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


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


                                                                                                 Page 7
                                           2010 FMLA Summary
                                                                         Current Year           Previous Year
                                     Employee's FTE:                        100%
       Regular FMLA Allowable hours according to FTE:                        480

                                FMLA 1: Total hours used:                     0.00                   0.00
                                FMLA 2: Total hours used:                     0.00                   0.00
                                FMLA 3: Total hours used:                     0.00                   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         Equivalent to 26 weeks
           Summary of Military Caregiver hours used:
                      *Military Caregiver FMLA Hours Used:       0.00                                 0.00
                Military Roll back hours from prior 12 months:   0.00
            Military Caregiver Remaining Hours Available: 1,040.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.
                                                                                                                   2010 - FMLA 1




       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: 480.00                        FMLA #1 total used:                    (Carry-over hours + current year hours for 1st FMLA event minus roll-back hours)


                     JANUARY                                FEBRUARY                                    MARCH                                      APRIL                                      MAY                                        JUNE
                                        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
   1     H       H         H     H       H
   2
   3
   4
   5
   6
   7
   8
   9
  10
  11
  12
  13
  14
  15                                            H       H       H      H        H
  16
  17
  18     H       H         H     H       H
  19
  20
  21
  22
  23
  24
  25
  26
  27
  28
  29
  30
  31                                                                                                                                                                           H        H       H          H         H



               Notes:




                                                                                                                    Page 9 of 16                                                                                                     printed: 6/30/2011 1:29 PM
                                                                                                              2010 - FMLA 1




                       JULY                                  AUGUST                            SEPTEMBER                                   OCTOBER                               NOVEMBER                              DECEMBER
                                      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
   1
   2
   3
   4
   5
   6                                                                                  H       H       H      H        H
   7
   8
   9
  10
  11                                                                                                                                                                 H       H       H      H       H
  12
  13
  14
  15
  16
  17
  18
  19
  20
  21
  22
  23
  24                                                                                                                                                                                                       H       H        H       H       H
  25                                                                                                                                                                 H       H       H      H       H
  26                                                                                                                                                                 H       H       H      H       H
  27
  28
  29                                                                                                                             H     H       H      H       H
  30
  31




                                                                                                                 Page 10 of 16                                                                                         printed: 6/30/2011 1:29 PM
                                                                                                                   2010 - FMLA 2




       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: 480.00                        FMLA #1 total used:                    (Carry-over hours + current year hours for 1st FMLA event minus roll-back hours)


                     JANUARY                                FEBRUARY                                    MARCH                                      APRIL                                      MAY                                        JUNE
                                        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
   1     H       H         H     H       H
   2
   3
   4
   5
   6
   7
   8
   9
  10
  11
  12
  13
  14
  15                                            H       H       H      H        H
  16
  17
  18     H       H         H     H       H
  19
  20
  21
  22
  23
  24
  25
  26
  27
  28
  29
  30
  31                                                                                                                                                                           H        H       H          H         H



               Notes:




                                                                                                                   Page 11 of 16                                                                                                     printed: 6/30/2011 1:29 PM
                                                                                                              2010 - FMLA 2




                       JULY                                  AUGUST                            SEPTEMBER                                   OCTOBER                               NOVEMBER                              DECEMBER
                                      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
   1
   2
   3
   4
   5
   6                                                                                  H       H       H      H        H
   7
   8
   9
  10
  11                                                                                                                                                                 H       H       H      H       H
  12
  13
  14
  15
  16
  17
  18
  19
  20
  21
  22
  23
  24                                                                                                                                                                                                       H       H       H        H       H
  25                                                                                                                                                                 H       H       H      H       H
  26                                                                                                                                                                 H       H       H      H       H
  27
  28
  29                                                                                                                             H     H       H      H       H
  30
  31




                                                                                                                 Page 12 of 16                                                                                         printed: 6/30/2011 1:29 PM
                                                                                                                   2010 - FMLA 3




       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: 480.00                        FMLA #1 total used:                    (Carry-over hours + current year hours for 1st FMLA event minus roll-back hours)


                     JANUARY                                FEBRUARY                                    MARCH                                      APRIL                                      MAY                                        JUNE
                                        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
   1     H       H         H     H       H
   2
   3
   4
   5
   6
   7
   8
   9
  10
  11
  12
  13
  14
  15                                            H       H       H      H        H
  16
  17
  18     H       H         H     H       H
  19
  20
  21
  22
  23
  24
  25
  26
  27
  28
  29
  30
  31                                                                                                                                                                           H        H       H          H         H



               Notes:




                                                                                                                   Page 13 of 16                                                                                                     printed: 6/30/2011 1:29 PM
                                                                                                              2010 - FMLA 3




                       JULY                                  AUGUST                            SEPTEMBER                                   OCTOBER                               NOVEMBER                              DECEMBER
                                      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
   1
   2
   3
   4
   5
   6                                                                                  H       H       H      H        H
   7
   8
   9
  10
  11                                                                                                                                                                 H       H       H      H       H
  12
  13
  14
  15
  16
  17
  18
  19
  20
  21
  22
  23
  24                                                                                                                                                                                                       H       H        H       H       H
  25                                                                                                                                                                 H       H       H      H       H
  26                                                                                                                                                                 H       H       H      H       H
  27
  28
  29                                                                                                                             H     H       H      H       H
  30
  31




                                                                                                                 Page 14 of 16                                                                                         printed: 6/30/2011 1:29 PM
                                                                                                       2010 FMLA - FMLA Military Caregiver




       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: 480.00                        FMLA #1 total used:                    (Carry-over hours + current year hours for 1st FMLA event minus roll-back hours)


                     JANUARY                                FEBRUARY                                    MARCH                                      APRIL                                      MAY                                        JUNE
                                        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
   1     H       H         H     H       H
   2
   3
   4
   5
   6
   7
   8
   9
  10
  11
  12
  13
  14
  15                                            H       H       H      H        H
  16
  17
  18     H       H         H     H       H
  19
  20
  21
  22
  23
  24
  25
  26
  27
  28
  29
  30
  31                                                                                                                                                                           H        H       H          H         H



               Notes:




                                                                                                                   Page 15 of 16                                                                                                     printed: 6/30/2011 1:29 PM
                                                                                                     2010 FMLA - FMLA Military Caregiver




                       JULY                                  AUGUST                            SEPTEMBER                                     OCTOBER                               NOVEMBER                              DECEMBER
                                      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
   1
   2
   3
   4
   5
   6                                                                                  H       H         H      H        H
   7
   8
   9
  10
  11                                                                                                                                                                   H       H       H      H       H
  12
  13
  14
  15
  16
  17
  18
  19
  20
  21
  22
  23
  24                                                                                                                                                                                                         H       H        H       H       H
  25                                                                                                                                                                   H       H       H      H       H
  26                                                                                                                                                                   H       H       H      H       H
  27
  28
  29                                                                                                                               H     H       H      H       H
  30
  31




                                                                                                                   Page 16 of 16                                                                                         printed: 6/30/2011 1:29 PM

								
To top