CMPPAY-L Archives

UC Payroll Release Distribution Notes

CMPPAY-L@LISTSERV.UCOP.EDU

Options: Use Forum View

Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Barbara Vanden Borre <[log in to unmask]>
Reply To:
UC Payroll Release Distribution Notes <[log in to unmask]>
Date:
Wed, 16 Nov 2005 23:25:40 -0800
Content-Type:
text/plain
Parts/Attachments:
text/plain (146 lines)
Release 1670 makes significant changes to the system with respect to
severance pay processing.  ASUCLA and Hastings, although you don't
participate in the program, we still need to install the release for you.

There are two primary functional aspects that you can read about in detail
in the SR 81309 Requirements document.  Note that these apply to Senior
Management participants, but not Health Sciences participants.  The Health
Sciences severance pay program is unchanged.  Where not qualified below,
references are to the Senior Management program.

- Participants will be able to invest their monies in defined
   contribution plan accounts administered by FITSCo.
- A UCOP Senior Management Compensation group "will
   maintain the SPP balances, apply quarterly STIP interest,
   and coordinate disbursements for the separated participants."

That sounds pretty simple, but the supporting changes to PPS are broad-ranging.

SEVERANCE PAY PROCESSING
Currently three batch programs are used by campuses:
- PPP810 is run on a monthly basis to calculate eligible
   contributions for both Senior Management and Health
   Sciences participants, and it can be run on an ad hoc basis
   to perform adjustments to already calculated values stored
   in the SPP table.  All components relating to the Senior
   Management population are disabled/removed in r1670, and
   only those sites with Health Sciences participants will continue
   to run it.  Nominally that would be the hospital campuses (for us,
   Davis and San Diego), but I see that SD has no Health Sciences
   members, so it will be only Davis.
- PPP820 is run quarterly to calculate interest earnings, using
   the current STIP rate, on severance pay contributions.  It is
   modified to bypass these computations for Senior Management.
   This also will be run for only those sites with Health Sciences
   members (Davis).
- PPP830 is run on an ad hoc basis to produce a report showing
   severance payout amounts based on last day on pay date for
   selected employees.  Components related to Senior
   Management are disabled, thus there will be no need to run it
   in the future for any site except Davis.

DATA ELEMENTS AND GTN NUMBERS
   Six new GTN entries are defined for SMS contributions, two for DCP, two
for 403(b), and two for 457(b).  Descriptions for them are added to the
Code Translation Table, and information about them will be passed through
the monthly UCRS interface and the nightly IVR interface.  Current SMS data
in the SPP table will be frozen in December, staying in place in that DB2
table, but with the fields removed from the data element table.  They're
also removed from the monthly Corporate Personnel file interface.

COMPUTE

A new calculation routine, 55, which will be coded in the new GTN entries,
is added to the compute to check on the eligibility of Senior Managers to
take those deductions.  The rule is that their SMS Eligibility Indicator
must have a value of 'A', 'B', 'C', 'D', or 'E'....or their SMS Pay
Exception Indicator must be 'Y'.  These new investments are managed by
FITSCo and therefore the information must be passed in the NACHA file
created by program PPP430.  They are not lumped in with other FITSCo
activity, but instead are split into three new batches, according to the
type of investment, with the criteria for those batches recorded in the NGO
(NACHA GTN Organization) table.

EXPENSE DISTRIBUTION

PPP520 will prorate the cost of the severance pay benefit across eligible
payments in the same manner that it uses for health, dental, vision, and
legal benefits.  You'll be able to see the new amounts broken out by GTN
number on the PPP5001 report and a total amount representing EDW type 2
records in the PPP5202 report.  The PPP5302 report, as usual, presents a
challenge in finding a place to squeeze in the new values for individual
employees.  You'll find them in the column that currently displays Matching
Retirement and Faculty Summer Salary benefits.

An alert for technical staff: the record length of the expense distribution
workfile is increased from 8714 to 8914 because of the addition of a new
'benefits bucket'.  Where there used to be 28 buckets, there will be 29
buckets.

That new bucket is a new IDC-BENE-CODE entry in copymember CPWSXIC5 and,
like all the others, includes a balance sheet FAU:

     05  IDC-BENE-CODE-36        PIC X(53)   VALUE
     '29*8660SR MGMT SUPPL   3115935

For the sites using the standard UCOP FAU format, we will substitute the
appropriate location code values.  For Davis, Riverside, and San Diego,
we'll need to know your preferred FAU.

REPORTING AND DISPLAY

There are two CICS function codes/screens for display of severance pay
data.  IHSP is for Health Science participants and is unchanged.  ISSP is
for Senior Management and is significantly modified.  The six monthly
contribution fields, total interest, and total contribution/interest fields
are removed and are replaced by displays of amounts for the six new GTN
numbers.

The EELI function is modified to allow entry of B-balance amounts for up to
3 of the new GTN numbers.

A new batch reporting program, PPP538, is provided to produce a report of
employees receiving the Senior Management Contributions.  In a sense it's a
replacement for the old PPP810 reporting, but the data for PPP538 comes
from the EDW.  The spec card offers a choice of name or FAU order for the
PPP5381 report.  We will run this program for all of the campuses but not
for ASUCLA or Hastings.

TABLE UPDATES

   Transactions are provided with which to update these tables:
- data element
- message
- code translation
- NACHA GTN organization

   Template transactions are provided for adding the six new GTN
numbers.  I recommend that we add them for ASUCLA and Hastings even though
they're not participating in the severance pay program, just to ensure the
system doesn't misbehave due to references to them in copymembers, etc.  We
will need priority numbers from all sites.  Davis, Riverside, and San
Diego, please advise us what liability FAU you would like coded.  The
template transactions have the flag for inclusion in the IGTN screen turned
on, but not for IDED, IRTR, or IRET.

IMPLEMENTATION

R1670 is date-mandated to be installed before November month-end processing
and no later than 12/1, which doesn't sound too bad except for Davis and
San Diego, which have monthly reporting scheduled early (Wednesday 11/23
for SD and Monday 11/28 for Davis) due to the way their biweekly cycles
fall.  However, the release also must be installed in time to allow for
processing of one-time SMS DS transactions for pay date 12/1, which
effectively means getting it done before all of the campus MO computes.

You can see the extreme urgency for implementation of r1670, so we would
appreciate it if you would provide us with approval to install at your
earliest convenience plus:

- priority numbers for GTN transactions
- any special instructions for the GTN liability FAUs
- any special instructions for the new IDC-BENE-CODE entry in CPWSXIC5
- your preferred sort sequence for the new PPP5381 report

   bvb

ATOM RSS1 RSS2