Employee ID

Routine to assign a check digit and a routine to validate the id using the check digit on input.

Insure the id is valid at all points of input, batch and on-line. Prevents transpositions and other errors from inadvertently causing an update to wrong employee.

Minor amount of local code added to 7 Base modules.

Time Reporting

Support electronic interface for two depts. with large volume of positive time reporting.

Provide a more integrated solution for two depts. with specialized timekeeping systems to save their duplicate data entry.

Two local "pre-edit" programs to validate and control file receipt prior to input into Base PPS.

SurePay and Checks

Support Berkeley’s stock for checks and

SurePay earnings statements. Allow for a Payroll Office pickup option for designated departments. Provide certain info on stubs/statements at local request, such as check date and bank id. Provide requested breakdowns of check totals and SurePay totals.

Customizations to an over/under check and impact SurePay privacy mailer were made in 1980’s. Berkeley intends to move to laser printing and Base forms. The option for dept. pickup meets the physical and organizational needs of the campus and will continue, as will provision of additional totals.

Minor changes to 5 on-line, Base PPS programs; significant changes to two on-line (PPWECHK, PPEC108) and two batch (PPP420, PPP430); and one local control table.

Expense Distribution

Meet Berkeley requirements regarding perquisites, certain unique funds, control totals and other breaks between location J and 1, and a separate sort for hardcopy report with home dept. address pre-printed in "Mail To"

Meet requirements driven by local general ledger requirements and ease distribution of a voluminous paper report between locations and between departments for Payroll.

Minor change to one program (PPP520) and moderate change to reporting program (PPP530).

Costing Process

Meet campus requirement to produce one version of costing reports in Home Department sequence.

Ease the distribution of a large report among 300 campus departments.

One local program that is a version of PPP9803, to create the report in home dept. sequence.

Local Pay on-line

This is the equivalent of on-line Time Reporting, THF Update and Abeyance features.

Improve accuracy and timeliness of time input and compute transactions through on-line edit/update. Berkeley’s local process, dating from 1987, is scheduled to be replaced by OP’s OPTR and DB2 THF update during 1997.

Batch Purge Process

Changes to EDB Maintenance to NOT purge monthly but only annually.

Meet Berkeley requirements to leave employee id and other skeleton data on data base for an inactive employee until there has been no earnings in the calendar year.

Minor change to one batch program (PPP130).

Fee Remission Cost Recovery

Meet requirement for an electronic input of fee remission amounts and allow uncollected amounts to suspend for subsequent collection, generally when student is paid off cycle.

Provide a more integrated solution for the Graduate Division to apply remission records to PPS based on their in-house system for award monitoring.

Minor change to one Base batch program (PPP870) and two local programs to handle fee remission generation and input.

Work Study Limits Processing

Meet requirement for electronic input of limits by the Work Study Office.

Provide an integrated solution for the Financial Aid Office between their financial aid system and PPS for work study earnings limits posting.

One local "pre-edit" program to validate and control limits input to Base PPS file maintenance.

Leave Accrual Process

Meet campus requirement for hourly leave accrual basis. Provide a time reporting worksheet for usage reporting separate from hours worked reporting, following the end of the month.

Hours vrs. factored basis for leave accrual represents a local campus management decision. The reporting worksheet requirement arises from the number of employees on exception time, paid monthly.

Local values in a table and one local program to produce the usage reporting worksheet.