graduate studies title codes:

• 1501 Associate-In (9 mos)
• 1506 Associate-In (9 mos) 1/9
• 1511 Associate-In (11 mos)
• 2286 Nursery School Assistant
• 2288 Remedial Tutor I
• 2289 Remedial Tutor II
• 2305 Community Teaching Fellow
• 2310 Teaching Assistant
• 2330 Physical Activities Assistant
• 2340 Language Assistant
• 2500 Reader (Non-student)
• 2850 Reader (Graduate Studies)
• 2860 Graduate Tutor
• 3240 Postgraduate Researcher (Non-student)
• 3253 Postdoctoral Scholar — Fellow
• 3254 Postdoctoral Scholar — Paid Direct
• 3282 Graduate Student Researcher
• 3370 Visiting Post Doctoral Scholar or (title code = 9995 and DOS=PDS)

number 5:student status code

Student status is '1' for title code 2500, 3240, 3253, 3254, 3370, 9995(DOS Code "PDS")

Student status is either '2', '4', '5' or '7' for all other Graduate Studies title codes.

number 7: date of hire

Hire date should be less than or equal to appointment begin date.

number 8: date of birth

Birth date should be less than hire date; greater than or equal to 16 years and no higher than 100 years.

number 9: appointment number

Not Implemented. Appointment is enforced by the PPS production system..

number 11: proposed position title

Not implemented. Proposed Position Title is not a database field.

number 12: personnel program code

Not implemented. The code is automatically derived by the production system based on the title code.

number 13: appt type (EDBAPP.APPT_TYPE)

Appointment type code is always 5 except when title code is equal to 9995 and DOS code is 'PDS', then appointment type code is '4'.

number 14: academic basis/paid over

Academic basis is '11' and appointment paid over is '12' for title codes 1511, 3240, 3253, 3282.

Academic basis and appointment paid over should be blank for title codes 9995 and 3254.

Academic basis is '9' and appointment paid over is '9' or '12' for title codes 1501, 1506, 2310.

Academic basis and appointment paid over are not checked for the rest of the Graduate Studies title codes.

number 15: appointment/distribution begin date
and appointment/distribution end date

Appointment begin date must be less than or equal to the distribution date associated with each of the appointments.

Appointment end date and distribution date cannot be NULL.

Appointment end date must be greater than or equal to the distribution date associated with each of the appointments.

number 17: % full time

Total appointment percent for all appointments can never be over 100%. When checking for total appointment percent, ignore all future appointments (appointment begin date greater than current run date). Use all active appointments title codes (Graduate Studies title codes + non-Graduate Studies title codes).

Total % for each appointment should be zero for title code 3254. This title code is a "without salary" appointment.

Total % for each appointment is not checked for title code 9995.

Total % for each appointment should not be zero for all the other Graduate Studies title codes.

Total % of all appointments can be up to 100% for title codes 3240, 3253, 3370. Total appointment % for title code 3240 cannot be greater then 50% when this title code is combined with another academic title code.

Total % of all appointments is less than or equal to 50% for all other Graduate Studies title codes. During the summer (7/1/ to 9/30) total appointment % for these title codes can be over 50% but never more than 100% .

number 18: f/v (EDBAPP. FIXED_VAR_CODE)

Fixed variable code is 'F' for title codes 1501, 1506, 1511, 2286, 2305, 2310, 2330, 2340, 2860, 3240, 3253, 3282, 3370 and 9995.

Fixed variable code is 'F' or 'V' for title codes 2288, 2289, 2850, 2500.

number 19: appt annual/hourly Rate (EDBAPP.PAY_RATE)

(tie to Number 35) HOLD
based on title code and step/Grade.

This requires new table set up in PPSDW, a whole new project.

number 20: rate code

Rate code is always 'A' for title codes 1501, 1506, 1511, 2310, 3240, 3253, 3282.

Rate code is always BLANK for title codes 3254 and DOS code WOS. Rate code is always 'A' for title code 3370 and DOS code REG.

Rate code is always 'H' for title codes 2288, 2289, 2500, 2850.

Rate code is always 'B' for title code 9995.

Rate code is not checked for the rest of the Graduate Studies title codes.

number 21: pay schedule

Pay schedule is always "BW" for title codes 2288, 2289, 2500, 2850. The only exception is if the employee has another appointment with a monthly pay schedule. Then the pay schedule for that appointment should be entered.

Pay schedule is always "MO" for title codes 1501, 1506, 1511, 2310, 3240, 3253, 3254, 3282, 9995.

Pay schedule is always BLANK for title code 3370 and DOS code WOS. Pay schedule is always "MO" for title code 3370 and DOS code REG.

Pay schedule is not checked for the rest of the Graduate Studies title codes.

number 22: time

Program Coordinators should review departmental policy and procedure manuals for guidelines for entering the time reporting code. This relates to keeping and submitting time sheets for students and non-students in these title codes.

Time reporting code is not checked for the Graduate Studies title codes.

number 23: leave

Leave Code is always 'N' for title codes 1501, 1506, 1511, 2310.

Leave code is either 'F', 'D' or 'N' for title code 3240:
— Leave code is 'F' for appointment greater than or equal to 50 % and less than six consecutive months;
— Leave code is 'D' for appointment % greater than or equal to 50% and appointment period is six consecutive months or more;
— Leave code is 'N' if appointment is less than 50% time, regardless of duration.

Leave code is 'F' for title code 3253.

Leave code is 'N' or 'E' for title code 3282:
— Leave code 'N' is for appointments less than six consecutive months OR less than 50%;
— Leave code 'E' is for appointments of six months or more AND at least 50% time or greater.

Leave code is always 'N' for title code '3370' and DOS code 'WOS'.

Leave code is either 'F' or 'D' for title code 3370 and DOS code REG:
— Leave code is 'F' for appointment % less than 50%.OR appointment % is greater than or equal 50 % and less than six consecutive months;
— Leave code is 'D' for appointment % greater than 50% and appointment period is six consecutive months or more.

Leave code is not checked for the rest of the Graduate Studies title codes.

number 25: distribution dept. code

Distribution department code cannot be blank. Home department is used for the department on the report when the distribution department code is blank.

Distribution department code may not exist in the department look up translation table. If the distribution department code does not existed in the department look up translation table (CTVHME), use the home department code for the department on the report.

Home department code may not exist in the department look up translation table. If the home department code does not existed in the department look up translation table, use 'DEPT: XXXXXX' (XXXXXX is the home department code) as the department name on the report.

number 28: chart - not blank

Chart cannot be blank.

Chart must be one character length long.

The database stores a dash for chart when chart is blank.

number 29: account - not blank

Account cannot be blank.

Account must be seven characters in length.

The database stores seven dashes for account values when account is blank.

number 31: object - not blank

Object code cannot be blank.

Object code must be four characters in length.

The database stores four dashes for object code value when object code is blank.

number 34: distribution %

When checking for distribution percent, ignore all future distribution (distribution begin date greater than current run date).

Total distribution % minus the work study distribution % (work study program code is not null) should be equal to the appointment percent and no more than 50% for title code 3282. Total distribution can be over 50% but never more than 100% during the summer (7/1 to 9/30).

Total distribution % for an appointment is equal to the appointment percent within plus/minus 1% of a 100% and no more than 100% for title codes 3240, 3253, 3370. Total distribution % cannot be greater 50% for 3240, 3253 when either title code is combined with another academic title code.

Total distribution % for an appointment should be zero for title code 3254 (without salary title code).

Total distribution % is not checked for 9995.

Total distribution % for an appointment is equal to the appointment percent and no more than 50% for all other title codes. Total distribution % can be over 50% but never more than 100% during the summer (7/1 to 9/30).

Appointment % uses two decimal digits, distribution % uses four decimal digits, truncate distribution % to two decimal digits.

number 35: step (EDBDIS. DIST_STEP) HOLD

Required only with 3240 (PGR) -step must be 1-17. 3282 (GSR) must be 1-10. Student status (EDBPER.STUDENT_STATUS) code = 4. All others blank.

Step needs to match title (EDBAPP.TITLE_CODE), Appt Annual/Hourly Rate and Monthly Rate (EDBAPP.PAY_RATE)

All other TC not check.

number 36: pay period rate/amount: (EDBDIS.PAY_RATE) HOLD

Title codes for GSR, TA, PGR, Associate In and visiting postdoctoral scholars (1501, 1506, 1511, 2310, 3240, 3253, 3282, 3370) follow the monthly pay schedule. The monthly pay period rate must be the monthly amount for these title codes.

Readers and Tutors follow the bi-weekly pay schedule with an hourly rate.

If a Reader or Tutor title is combined with one of the above monthly title codes, all pay follows the monthly pay schedule.

Requires a new table in PPSDW.

number 37: DOS code (EDBDIS.DOS)

DOS code is 'WOS' for title code 3254 (without salary). Only 'WOS' is correct.

DOS code is 'REG' for title code 1501, 1506, 1511, 2288, 2289, 2310, 2500, 2850, 2860, 3240, 3253 and 3282. Only 'REG' is correct.

DOS code is either 'REG' or 'WOS' for title code 3370.

DOS code is 'PDS' for title code 9995. Do not check other 9995s for any purpose

DOS code is not checked for the rest of the Graduate Studies title codes.