Docstoc

salary-increase-template

Document Sample
salary-increase-template Powered By Docstoc
					August 10, 2008

Salary Increase Process
Import Employee Data

Salary Increase Spreadsheet

A

B
Delete Row Sort Process Bonuses

C

D

E

F

G

H

I

J

K

L

M

N

O

P

Q

Employee Information

1 2

Last Name

First Name

Employee ID

Employee Record #

Effective Date

Action

Action Reason

Employee Classification

Employee Status

Job Code

Hire Date

Rehire Date

Job Entry Date

Appointment End Date Department

Tub

3b794b0e-eaf6-488d-8ccb-c0dfe7e44a38.xls

8/10/2008

Page 2

Salary Increase Spreadsheet

R

S

T

U

V

W

X

Y

Z

AA

AB

AC

AD

AE

AG

AH

AI

AJ

AK

Apply Structure Increase

Depart ment Supervisor Union Compensation Name Code Rate Code 1 Type 2

Compensation Rate

Annual Rate

Grade Max Point Annual

Grade Max Point Hourly

Comp Ratio

Current Full Time Salary Equivalent Standard Comp Administration (FTE) Hours Frequency Plan

Salary Grade

Paygroup

Benefit Eligible Service

Increase Effective Date

Increase Action

3b794b0e-eaf6-488d-8ccb-c0dfe7e44a38.xls

8/10/2008

Page 3

Salary Increase Spreadsheet

AL

AM

AN

AQ

AR

AT

AU

AZ

BC

BD

BE

BF

BH

BK

BL

BM

BN

Apply Progression Increase

1 2

Increase Reason

Proposed Increase Percent

Proposed Increase Amount

New Compensation Rate

New Actual Annual Salary

BIL

Apply Pay BIL Increase as for Additional Employee Pay? on Leave?

Increase Effective Date

Increase Action

Increase Reason

Proposed Increase Amount

New Compensation Rate

New Actual Annual Salary

Gross BIL

BIL

3b794b0e-eaf6-488d-8ccb-c0dfe7e44a38.xls

8/10/2008

Page 4

Salary Increase Spreadsheet

BO

BT

BU

1 2

Apply Pay BIL Increase as for Additional Employee Apply Pay? on Leave? Increase?

3b794b0e-eaf6-488d-8ccb-c0dfe7e44a38.xls

8/10/2008

Page 5

Bonus Spreadsheet

A

B
Copy Row

C

D

E

F
Select Earnings Code

G

I

X

Y

Z

AA

AB

AC

AD

Enter Costing

Employee Additional Pay

1

Last Name

First Name

Employee ID

Employee Earnings Record # Code

Effective Date

BIL/Bonus

Tub

Org

Fund

SubActivity Activity Root

3b794b0e-eaf6-488d-8ccb-c0dfe7e44a38.xls

8/10/2008

6

HUCTW Progression Reference Tables

Excel CSV File Layout
Last Name First Name Employee ID Employee Record # Effective Date Action Action Reason Employee Classification Employee Status Job Code Hire Date Rehire Date Job Entry Date Appointment End Date Department Tub Department Type Supervisor Name Union Code Compensation Rate Code Compensation Rate Annual Rate Grade Max Point - Annual Grade Max Point - Hourly Comp Ratio Current Full Time Equivalent (FTE) Standard Hours Comp Frequency Salary Administration Plan Salary Grade Salary Plan Effective Date Paygroup DeptID Distrb % Eff Date Year Tub Org Object Code Fund Activity Sub-Activity Root Benefit Eligible Service Increase Effective Date Increase Action Increase Reason Proposed Increase Percent

CSV Column
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 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48

Template Destination Layout
Last Name First Name Employee ID Employee Record # Effective Date Action Action Reason Employee Classification Employee Status Job Code Hire Date Rehire Date Job Entry Date Appointment End Date Department Tub Department Type Supervisor Name Union Code Compensation Rate Code Compensation Rate Annual Rate Grade Max Point - Annual Grade Max Point - Hourly Comp Ratio Current Full Time Equivalent (FTE) Standard Hours Comp Frequency Salary Administration Plan Salary Grade Salary Plan Effective Date Paygroup DeptID Distrb % Eff Date Year Tub Org Object Code Fund Activity Sub-Activity Root Benefit Eligible Service Increase Effective Date Increase Action Increase Reason Proposed Increase Percent

Template Column
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 32 33

34 36

12/16/2002

7

HUCTW Progression Reference Tables

Proposed Increase Amount New Salary New Actual Salary BIL Pay BIL Actual Increase Percent Actual Increase Amount Apply Increase for Employee On Leave Extract Type

49 50 51 52 53 54 55 54 57

Proposed Increase Amount New Salary New Actual Salary BIL Pay BIL Actual Increase Percent Actual Increase Amount Apply Increase for Employee On Leave Extract Type

54

12/16/2002

8

HUCTW Progression Reference Tables

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

Earnings Codes
BIL

BEX BIL BPE BPU BPV BRT BSN BUN SMR

AH AJ

12/16/2002

9

HUCTW Progression Reference Tables

BB

12/16/2002

10

HUCTW Progression Reference Tables

Description
Bonus in Lieu of Increase

Bonus Expected Bonus in Lieu of Increase Bonus Project Expected Bonus Project Unexpected Bonus Performance/ Variable Bonus Retention Bonus Sign On Bonus Unexpected/Spot Summer Salary

HUCTW Progression Table Grade-Plan Full Effective 6-12 Month Effective 47-CT35 0.53750 0.26875 47-CT37 0.53750 0.26875 47-CT40 0.53750 0.26875 48-CT35 0.57193 0.28596 48-CT37 0.57193 0.28596 48-CT40 0.57193 0.28596 49-CT35 0.59258 0.29629 49-CT37 0.59258 0.29629 49-CT40 0.59258 0.29629 50-CT35 0.63114 0.31557 50-CT37 0.63114 0.31557 50-CT40 0.63114 0.31557 51-CT35 0.55477 0.27739 51-CT37 0.55477 0.27739 51-CT40 0.55477 0.27739 52-CT35 0.56455 0.28227 52-CT37 0.56455 0.28227 52-CT40 0.56455 0.28227 53-CT35 0.59315 0.29658 53-CT37 0.59315 0.29658 53-CT40 0.59315 0.29658 54-CT35 0.64307 0.32154 54-CT37 0.64307 0.32154 54-CT40 0.64307 0.32154 55-CT35 0.69781 0.34890 55-CT37 0.69781 0.34890 55-CT40 0.69781 0.34890

12/16/2002

11


				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:9585
posted:2/2/2008
language:English
pages:11