EE Group A2:G22
|
Duration |
Job Code |
Recommended Appt Types |
Required Fields to Complete |
Automatically Updating Fields |
Formulas |
Notes |
01-Lectures |
12 Month |
0393 2359 2369 2391 |
002-12 Month |
Appt Type WTU FTE Eff Dt End Dt |
WTU (if FTE entered) FTE (if WTU entered) Actual Comp Rate (Based on Formula) |
1. Base Rate x FTE = Actual Comp Rate |
1. There are additional fields that can be completed but not noted on spreadsheet 2. No more than three(3) appointments can be entered at a time |
Academic Year (AY) |
0357 0360 0361 0364 0365 0557 0560 0564 2158 2308 2358 2393 2458 |
001-Acad Year 003-Ent Y1 006-Semester 014-Ent 1 of 3 015-Ent 2 of 3 016-Ent 3 of 3 017-Multi AY |
Term Session (if outside regular session 1) Appt Type WTU FTE |
Eff Dt (Based on Term/Session Entered) End Dt (Based on Term/Session/Appt Type Entered) Multi Term End Dt (Based on Term/Session Entered) WTU (if FTE entered) FTE (if WTU entered) Actual Comp Rate (Based on Formula) Term Rate (Based on Formula) |
1. Base Rate x FTE = Actual Comp Rate 2. Actual Comp Rate x Number of pay checks (comes from the term table) = Term Rate |
1. There are additional fields that can be completed but not noted on spreadsheet 2. Use the Adjust field to open up the Effective Date/Term End Date fields 3. Late Start/Early Term: Daily Rate x FTE x Number of Days= Late Start (Total Term) Daily Rate x FTE x Number of Days= Early Term (Total Term) Remember: The daily rate is different per term, as the number of days in the term can differ. So the calc would be days work divided by days in the term times the term total = late start/early term total 4. No more than three(3) appointments can be entered at a time |
02-Counselors |
12 Month |
2338 2436 2437 3070 3072 3074 |
002-12 Month |
Appt Type Eff Dt End Dt WTU FTE |
WTU (if FTE entered) FTE (if WTU entered) Actual Comp Rate (Based on Formula) |
1. Base Rate x FTE = Actual Comp Rate |
1. There are additional fields that can be completed but not noted on spreadsheet 2. No more than three(3) appointments can be entered at a time |
Academic Year (AY) |
3071 3073 3075 |
001-Acad Year 006-Semester 017-Multi AY |
Term Session (if outside regular session 1) Appt Type WTU FTE |
Eff Dt (Based on Term/Session Entered) End Dt (Based on Term/Session/Appt Type Entered) Multi Term End Dt (Based on Term/Session Entered) WTU (if FTE entered) FTE (if WTU entered) Actual Comp Rate (Based on Formula) Term Rate (Based on Formula) |
1. Base Rate x FTE = Actual Comp Rate 2. Actual Comp Rate x number of payments = Term Rate |
1.There are additional fields that can be completed but not noted on spreadsheet 2. Use the Adjust field to open up the Effective Date/Term End Date fields 3. Late Start/Early Term: Daily Rate x FTE x Number of Days= Late Start (Total Term) Daily Rate x FTE x Number of Days= Early Term (Total Term) Remember: The daily rate is different per term, as the number of days in the term can differ. So the calc would be days work divided by days in the term times the term total = late start/early term total 4. No more than three(3) appointments can be entered at a time |
03-Librarians |
10 Month |
2913 2919 2926 |
012-10 Month |
Appt Type Eff Dt End Dt Months Off #1 Months Off #2 Hours FTE |
Hours (if FTE entered) FTE (if Hours entered) Actual Comp Rate (Based on Formula) |
1. Base Rate x FTE = Actual Comp Rate |
1. There are additional fields that can be completed but not noted on spreadsheet 2. No more than three(3) appointments can be entered at a time |
12 Month |
2914 2920 2927 |
002-12 Month |
Appt Type Eff Dt End Dt Hours FTE |
Hours (if FTE entered) FTE (if Hours entered) Actual Comp Rate (Based on Formula) |
1. Base Rate x FTE = Actual Comp Rate |
1. There are additional fields that can be completed but not noted on spreadsheet 2. No more than three(3) appointments can be entered at a time |
04-Coaches |
10 Month |
2374 2377 2380 2383 |
012-10 Month |
Appt Type Eff Dt End Dt Months Off #1 Months Off #2 FTE |
Actual Comp Rate (Based on Formula) |
1. Base Rate x FTE = Actual Comp Rate |
1. There are additional fields that can be completed but not noted on spreadsheet 2. No more than three(3) appointments can be entered at a time |
12 Month |
2373 2376 2379 2382 |
002-12 Month |
Appt Type Eff Dt End Dt FTE |
Actual Comp Rate (Based on Formula) |
1. Base Rate x FTE = Actual Comp Rate |
1. There are additional fields that can be completed but not noted on spreadsheet 2. No more than three(3) appointments can be entered at a time |
Academic Year (AY) |
2375 2378 2381 2384 |
001-Acad Year 006-Semester 017-Multi AY |
Term Appt Type Session (if outside regular session 1) FTE |
Eff Dt (Based on Term/Session Entered) End Dt (Based on Term/Session/Appt Type Entered) Actual Comp Rate (Based on Formula) |
1. Base Rate x FTE = Actual Comp Rate |
1. There are additional fields that can be completed but not noted on spreadsheet 2. Use the Adjust field to open up the Effective Date/Term End Date fields 3. Late Start/Early Term: Daily Rate x FTE x Number of Days= Late Start (Total Term) Daily Rate x FTE x Number of Days= Early Term (Total Term) Remember: The daily rate is different per term, as the number of days in the term can differ. So the calc would be days work divided by days in the term times the term total = late start/early term total 4. No more than three(3) appointments can be entered at a time |
05-Summer |
|
2357 2368 2457 |
010-Summer Ses |
Term Session (if outside regular session 1) Appt Type WTU Rate Per WTU (if not 2360 job code) |
Eff Dt (Based on Term/Session Entered) End Dt (Based on Term/Session/Appt Type Entered) WTU (if employees primary job code is 2360) Reduce Rate (Based on Student Count entered, if student count is not entered field will be blank and the Total Comp Field will populate instead) Total Comp Field (Based on Formula) |
1. Monthly AY x 12/number of units in the term table = Rate Per WTU 2. Rate Per WTU x WTU = Total Comp 2. Rate Per WTU x WTU X % of Full Pay=Reduced Rate |
1. There are additional fields that can be completed but not noted on spreadsheet 2. No more than three(3) appointments can be entered at a time 3. Immediate pay should have no more than 1 decimal place |
06-Substitute Faculty |
|
2356 |
005-Immediate Pay |
Grade Term Appt Type Eff Dt End Dt Lecture/Lab Lec/Lab Hrs |
Lec/Lab Rate (Based on what was entered in the Grade field and whether Lab/Lec was selected, the amount pulls from CSU TAE Substitute Appt Tbl) Lec/Lab Total Amt (Based on formula) |
# of Hours x Lec/Lab Rate= Lec/Lab Tot Amt |
1. There are additional fields that can be completed but not noted on spreadsheet 2. No more than two(2) appointments can be entered at a time 3. Base Rate Field is not used to process any calculations, but is still required. If the employee is new, then a rate must be entered. It is recommended that the user enter the same amount in the Base Rate field as the Lab/Lecture Rate. 4. Immediate pay should have no more than 1 decimal place |
07-Extension |
|
2322 2323 |
005-Immediate Pay |
Term Session (if outside regular session 1) Appt Type Rate Per WTU WTU FTE |
Eff Dt (Based on Term/Session Entered) End Dt (Based on Term/Session/Appt Type Entered) WTU (if FTE entered) FTE (if WTU entered) Total Comp (Based on Formula) |
1. WTU X Rate Per WTU= Total Comp |
1. There are additional fields that can be completed but not noted on spreadsheet 2. No more than three(3) appointments can be entered at a time 3. Immediate pay should have no more than 1 decimal place |
08-Additional Employment |
|
2403 |
020-AE-16th WTU |
Term Session (if outside regular session 1) Appt Type WTU AY Monthly Base Rate (if applicable) |
AY Monthly Base Rate (if employee has an active 2358 appt in the same department) Eff Dt (Based on Term/Session Entered) End Dt (Based on Term/Session Entered) FTE (Based on WTU) Total Comp Rate (Based on Formula) 2403 Base Rate (Based on Formula) |
•Total Comp = (AY Monthly Base X 12 /30) x WTU •2403 Base Rate= Total Comp Rate/ FTE x (1/( # of Days working in January/ # of day in January Pay Period) + (# of Days working in February/ # of day in February Pay Period) + (# of Days working in March / # of day in March Pay Period) + (# of Days working in April/ # of day in April Pay Period) + (# of Days working in May / # of day in May Pay Period) + (# of Days working in June/ # of day in June Pay Period) + (# of Days working in July / # of day in July Pay Period) + (# of Days working in August / # of day in August Pay Period) + (# of Days working in September / # of day in September Pay Period) + (# of Days working in October / # of day in October Pay Period) + (# of Days working in November / # of day in November Pay Period) + (# of Days working in December / # of day in December Pay Period)) • Monthly Actual Pay Amount = ((2043 Base Rate/Days in Pay Period) x FTE) x # of Days Working |
1. There are additional fields that can be completed but not noted on spreadsheet 2. No more than three(3) appointments can be entered at a time |
|
2403 |
021-AE-Lump Sum |
Appt Type Eff Dt End Dt FTE Total Comp Rate |
2403 Base Rate (Based on Formula) |
•2403 Base Rate= Total Comp Rate/ FTE x (1/( # of Days working in January/ # of day in January Pay Period) + (# of Days working in February/ # of day in February Pay Period) + (# of Days working in March / # of day in March Pay Period) + (# of Days working in April/ # of day in April Pay Period) + (# of Days working in May / # of day in May Pay Period) + (# of Days working in June/ # of day in June Pay Period) + (# of Days working in July / # of day in July Pay Period) + (# of Days working in August / # of day in August Pay Period) + (# of Days working in September / # of day in September Pay Period) + (# of Days working in October / # of day in October Pay Period) + (# of Days working in November / # of day in November Pay Period) + (# of Days working in December / # of day in December Pay Period)) •Lump Sum = 2403 Base Rate x FTE |
1. There are additional fields that can be completed but not noted on spreadsheet 2. No more than three(3) appointments can be entered at a time 3. FTE cannot be greater than .25 |
|
2403 |
022-AE AY Daily Rate-172 |
Appt Type Eff Dt End Dt AY Month (if applicable) |
AY Monthly Base Rate (if employee has an active 2358 appt in the same department or an active 2360 in any department) Total Comp Rate (Based on Formula) 2403 Base Rate (Based on Formula) |
•Daily Rate= Monthly Base x 12 / by the number of days (Can be 170 or 172) •Total Comp= Daily Rate x # of days need to pay •2403 Base Rate= Total Comp Rate/ FTE x (1/( # of Days working in January/ # of day in January Pay Period) + (# of Days working in February/ # of day in February Pay Period) + (# of Days working in March / # of day in March Pay Period) + (# of Days working in April/ # of day in April Pay Period) + (# of Days working in May / # of day in May Pay Period) + (# of Days working in June/ # of day in June Pay Period) + (# of Days working in July / # of day in July Pay Period) + (# of Days working in August / # of day in August Pay Period) + (# of Days working in September / # of day in September Pay Period) + (# of Days working in October / # of day in October Pay Period) + (# of Days working in November / # of day in November Pay Period) + (# of Days working in December / # of day in December Pay Period)) |
1. There are additional fields that can be completed but not noted on spreadsheet 2. No more than three(3) appointments can be entered at a time |
09-TA |
12 Month |
2353 |
002-12 Month |
Appt Type Eff Dt End Dt WTU FTE |
WTU (if FTE entered) FTE (if WTU entered) Actual Comp Rate (Based on Formula) |
1. Base Rate x FTE = Actual Comp Rate |
1. There are additional fields that can be completed but not noted on spreadsheet 2. No more than three(3) appointments can be entered at a time |
Academic Year (AY) |
2354 |
001-Acad Year 006-Semester |
Term Session (if outside regular session 1) Appt Type WTU FTE |
Eff Dt (Based on Term/Session Entered) End Dt (Based on Term/Session/Appt Type Entered) Multi Term End Dt (Based on Term/Session Entered) WTU (if FTE entered) FTE (if WTU entered) Actual Comp Rate (Based on Formula) Term Rate (Based on Formula) |
1. Base Rate x FTE = Actual Comp Rate 2. Actual Comp Rate x number of payments = Term Rate |
1. There are additional fields that can be completed but not noted on spreadsheet 2. Use the Adjust field to open up the Effective Date/Term End Date fields 3. Late Start/Early Term: Daily Rate x FTE x Number of Days= Late Start (Total Term) Daily Rate x FTE x Number of Days= Early Term (Total Term) Remember: The daily rate is different per term, as the number of days in the term can differ. So the calc would be days work divided by days in the term times the term total = late start/early term total 4.No more than three(3) appointments can be entered at a time |
10-GA |
12 Month |
2325 2326 |
002-12 Month |
Appt Type Eff Dt End Dt FTE Hours |
Hours (Based on FTE) FTE (Based on Hours) Actual Comp Rate (Based on Formula) |
1. Base Rate x FTE = Actual Comp Rate |
1. There are additional fields that can be completed but not noted on spreadsheet 2. No more than three(3) appointments can be entered at a time |
Academic Year (AY) |
2355 |
001-Acad Year 006-Semester
|
Term Session (if outside regular session 1) Appt Type FTE Hours |
Eff Dt (Based on Term/Session Entered) End Dt (Based on Term/Session Entered) Hours (Based on FTE) FTE (Based on Hours) Actual Comp Rate (Based on Formula) Term Rate (Based on Formula) |
1. Base Rate x FTE = Actual Comp Rate 2. Actual Comp Rate x number of payments = Term Rate |
1. There are additional fields that can be completed but not noted on spreadsheet 2. Use the Adjust field to open up the Effective Date/Term End Date fields 3. Late Start/Early Term: Daily Rate x FTE x Number of Days= Late Start (Total Term) Daily Rate x FTE x Number of Days= Early Term (Total Term) Remember: The daily rate is different per term, as the number of days in the term can differ. So the calc would be days work divided by days in the term times the term total = late start/early term total 4. No more than three(3) appointments can be entered at a time |
11-ISA |
|
1150 1151 1152 1153 |
011-ISA |
Term Session Eff Dt (only if Term/Session not used) End Dt (only if Term/Session not used) Appt Type Hourly Rate Min Hours Max Hours |
Eff Dt (Based on Term/Session Entered) End Dt (Based on Term/Session Entered) |
Hourly- no formula |
1. There are additional fields that can be completed but not noted on spreadsheet 2. No more than three(3) appointments can be entered at a time 3. If Appt Type Semester or AY are used, then Final Approver will need to make sure that the AY Duration field is blank on the My Approval page
|
0 Comments
Add your comment