Docstoc

Salary Information Template

Document Sample
Salary Information Template Powered By Docstoc
					                      July 22, 2011




Salary Increase Process

    Import Employee
         Data
                                                                                               Salary Increase Spreadsheet



         A             B                   C            D            E          F          G             H                   I          J        K         L         M         N            O           P        Q
    Information


                       Delete Row
      Employee


                           Sort

                    Process Bonuses

                                                                  Employee   Effective                Action         Employee        Employee    Job               Rehire   Job Entry   Appointment
1                  Last Name           First Name   Employee ID   Record #     Date      Action       Reason        Classification    Status    Code   Hire Date    Date      Date       End Date   Department   Tub
2
3




     e401bbc5-4695-4b9b-aa61-818644c7524c.xls                                                          7/22/2011                                                                                            Page 2
                                                                                              Salary Increase Spreadsheet



     R       S       T          U              V            W            X           Y           Z           AA             AB        AC       AD        AE          AF          AG         AI        AJ




                                                                                                                                    Current
  Depart                                                              Grade Max   Grade Max   Grade Min   Grade Min                Full Time                      Salary                            Benefit
   ment Supervisor Union Compensation    Compensation                   Point -     Point -    Point -     Point -                 Equivalent Standard Comp    Administration   Salary              Eligible
1 Type    Name     Code   Rate Code         Rate        Annual Rate    Annual       Hourly     Annual      Hourly     Comp Ratio     (FTE)     Hours Frequency     Plan         Grade    Paygroup   Service
2
3




    e401bbc5-4695-4b9b-aa61-818644c7524c.xls                                                          7/22/2011                                                                                            Page 3
                                                                                            Salary Increase Spreadsheet



       AK          AL         AM         AN         AO         AP            AQ               AT                AU          AW        AX       AY        BD            BG          BH           BI        BJ




                                                                                                                                                                   Progression
    Structure
    Increase




                                                                                                                                                                     Increase
      Apply




                                                                                                                                                                       Apply
                                                                                                                                                         Apply
                                                                                                                                             Pay BIL Increase
                Increase                          Proposed   Proposed                                      New Actual                          as          for                   Increase
                Effective   Increase   Increase   Increase   Increase   Proposed Comp   New Compensation    Annual                          Additional Employee                  Effective   Increase   Increase
1                 Date       Action     Reason     Percent    Amount         Rate             Rate           Salary       Below Min   BIL     Pay?     on Leave?                   Date       Action     Reason
2
3




     e401bbc5-4695-4b9b-aa61-818644c7524c.xls                                                       7/22/2011                                                                                                Page 4
                                                                                         Salary Increase Spreadsheet



       BL             BO              BP           BQ          BR       BS       BT        BY         BZ




                                                                                           Apply
                                                                               Pay BIL Increase
    Proposed                       New Actual                                    as          for
    Increase   New Compensation     Annual                                    Additional Employee    Apply
1    Amount          Rate            Salary     Gross BIL   Below Min   BIL     Pay?     on Leave? Increase?
2
3




    e401bbc5-4695-4b9b-aa61-818644c7524c.xls                                                     7/22/2011             Page 5
                                                                                                      Bonus Spreadsheet



         A                 B                    C           D            E        F          G               I            X     Y      Z    AA       AB      AC      AD

                      Copy Row                                                 Select




                                                                                                                      Costing
    Additional
    Employee
                                                                              Earnings




                                                                                                                       Enter
                                                                               Code
          Pay




                                                                      Employee Earnings   Effective                                                          Sub-
1                      Last Name           First Name   Employee ID   Record #  Code        Date         BIL/Bonus              Tub   Org   Fund   Activity Activity Root
2
3
4                                      ;




     e401bbc5-4695-4b9b-aa61-818644c7524c.xls                                                             7/22/2011                                                         6
                                   HUCTW Progression Reference Tables




                                           CSV                                            Template
        Excel CSV File Layout             Column     Template Destination Layout           Column
                 Last Name                    1                   Last Name                   2
                 First Name                   2                   First Name                  3
                Employee ID                   3                  Employee ID                  4
           Employee Record #                  4             Employee Record #                 5
               Effective Date                 5                 Effective Date                6
                    Action                    6                      Action                   7
               Action Reason                  7                 Action Reason                 8
         Employee Classification              8           Employee Classification             9
             Employee Status                  9               Employee Status                10
                  Job Code                   10                    Job Code                  11
                  Hire Date                  11                    Hire Date                 12
                Rehire Date                  12                  Rehire Date                 13
               Job Entry Date                13                 Job Entry Date               14
          Appointment End Date               14            Appointment End Date              15
                Department                   15                  Department                  16
                     Tub                     16                       Tub                    17
            Department Type                  17              Department Type                 18
            Supervisor Name                  18              Supervisor Name                 19
                Union Code                   19                  Union Code                  20
        Compensation Rate Code               20          Compensation Rate Code              21
           Compensation Rate                 21             Compensation Rate                22
                Annual Rate                  22                  Annual Rate                 23
        Grade Max Point - Annual             23          Grade Max Point - Annual            24
        Grade Max Point - Hourly             24          Grade Max Point - Hourly            25
        Grade Min Point - Annual             25          Grade Min Point - Annual            26
         Grade Min Point - Hourly            26           Grade Min Point - Hourly           27
                Comp Ratio                   27                  Comp Ratio                  28
    Current Full Time Equivalent (FTE)       28      Current Full Time Equivalent (FTE)      29
             Standard Hours                  29               Standard Hours                 30
             Comp Frequency                  30               Comp Frequency                 31
        Salary Administration Plan           31          Salary Administration Plan          32
                Salary Grade                 32                  Salary Grade                33
        Salary Plan Effective Date           33          Salary Plan Effective Date          34
                  Paygroup                   34                    Paygroup                  35
                   DeptID                    35                     DeptID
                  Distrb %                   36                     Distrb %
                   Eff Date                  37                     Eff Date
                     Year                    38                       Year
                     Tub                     39                       Tub
                     Org                     40                       Org
                Object Code                  41                  Object Code
                    Fund                     42                      Fund
                   Activity                  43                     Activity
                Sub-Activity                 44                  Sub-Activity
                     Root                    45                       Root
         Benefit Eligible Service            46           Benefit Eligible Service           36
         Increase Effective Date             47           Increase Effective Date            38
              Increase Action                48                Increase Action



12/16/2002                                                                                           7
                                   HUCTW Progression Reference Tables


           Increase Reason                   49               Increase Reason
       Proposed Increase Percent             50         Proposed Increase Percent
       Proposed Increase Amount              51         Proposed Increase Amount
              New Salary                     52                  New Salary
           New Actual Salary                 53              New Actual Salary
                   BIL                       54                      BIL
                Pay BIL                      55                    Pay BIL
        Actual Increase Percent              56          Actual Increase Percent
        Actual Increase Amount               57          Actual Increase Amount
                                                      Apply Increase for Employee On
  Apply Increase for Employee On Leave       56                     Leave
               Extract Type                  59                 Extract Type           58
                                                                 Below Min




12/16/2002                                                                                  8
                     HUCTW Progression Reference Tables




                                                               Earnings
                                   Sort Columns                 Codes
    B        peoplesoft   (None)                               BIL
    C                     Last Name
    D                     First Name
    E                     Employee ID
    F                     Effective Date
    G                     Action
    H                     Employee Classification
    I                     Employee Status
    J                     Job Code
    K                     Department
    L                     Tub                                  BEX
   M                      Current Full Time Equivalent (FTE)   BIL
    N                     Standard Hours                       BPE
    O                     Compensation Rate Code               BPU
    P                     Compensation Rate                    BPV
    Q                     Department Type                      BRT
    R                     Appointment End Date                 BSN
    S                     Union Code                           BUN
    T                     Paygroup                             SMR
    U                     Salary Administration Plan
    V                     Salary Grade
   W                      Below Min
    X
    Y
    Z
   AA
   AB
   AC
   AD
   AE
   AF
   AG
   AH
   AI




   AJ
   AL




12/16/2002                                                                9
             HUCTW Progression Reference Tables




   BF
   AW




12/16/2002                                        10
                                HUCTW Progression Reference Tables




         Description                     HUCTW Progression Table
Bonus in Lieu of Increase     Grade-Plan Full Effective 6-12 Month Effective
                              47-CT35          0.45259                      0
                              47-CT37          0.45259                      0
                              47-CT40          0.45259                      0
                              48-CT35          0.48157                      0
                              48-CT37          0.48157                      0
                              48-CT40          0.48157                      0
                              49-CT35          0.49897                      0
                              49-CT37          0.49897                      0
                              49-CT40          0.49897                      0
Bonus Expected                50-CT35          0.53143                      0
Bonus in Lieu of Increase     50-CT37          0.53143                      0
Bonus Project Expected        50-CT40          0.53143                      0
Bonus Project Unexpected      51-CT35          0.56622                      0
Bonus Performance/ Variable   51-CT37          0.56622                      0
Bonus Retention               51-CT40          0.56622                      0
Bonus Sign On                 52-CT35          0.61337                      0
Bonus Unexpected/Spot         52-CT37          0.61337                      0
Summer Salary                 52-CT40          0.61337                      0
                              53-CT35          0.66593                      0
                              53-CT37          0.66593                      0
                              53-CT40          0.66593                      0
                              54-CT35          0.72198                      0
                              54-CT37          0.72198                      0
                              54-CT40          0.72198                      0
                              55-CT35          0.78343                      0
                              55-CT37          0.78343                      0
                              55-CT40          0.78343                      0
                              56-CT35            0.8489                     0
                              56-CT40            0.8489                     0




12/16/2002                                                                      11

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:48
posted:7/22/2011
language:English
pages:11
Description: Salary Information Template document sample