The sample report below is based on a request developed by Fausto Caceres at Los Angeles to process changes for active Graduate Assistants (class 2325, 2326, and 2355) whose time base and salary must be amended per a side-letter agreement between the USA and the CSU. For complete information, please refer to technical letter HR/EHDB 2005-10 on the Systemwide HR web site.
soc doc new new
sec posit tran proc eff time base
nbr nbr code nbr date eh remarks base pay
--- -------- ---- --- ---- ---------- ---- ----
123-45-6789 000-111-2325-001 405 0010 08/02/2005 hr/sa 2005-10 001002 $1,800.00
Note: The actual report contains additional fields that could not be displayed here due to the width.
The report request is available in the CIRS Common Library as FOC5006 and uses several defines to create new fields. The report can be used as-is from the common library, or copied to your personal library and modified (e.g., add or delete fields, format for downloading purposes, etc.). Please refer to the comments in the request for additional information.
DEFINE FILE AC ADD
-*the defines below are text fields to be printed for each selected record
trancode/a3 = '405';
effdate/a10 = '08/02/05';
remarks/a14 = 'HR/SA 2005-10';
-*THE DEFINES BELOW CONVERT the old time base to the new time base
TIMEBASE/A6 = IF AC:TIMEBASE EQ 'FT' THEN '0001001' ELSE AC:TIMEBASE;
oldnum/a3 = edit (timebase, '999$$$');
oldden/a3 = edit (timebase, '$$$999');
newden1/I3 = edit (oldden);
newden2/I3 = newden1*2;
newden3/a3 = edit(newden2);
newtb/a6 = oldnum|newden3;
-*THE DEFINE BELOW Calculates the new base pay
NEWBP/P12.2M = AC:BASEPAY*2;
TABLE FILE AC
PRINT AC:SSA as 'soc,sec,nbr'
AC:POSIT16 as 'posit,nbr'
AC:DOCT as 'doct,proc,nbr'
trancode as 'tran,code'
effdate as 'eff,date'
remarks as 'eh remarks'
ac:timebase as 'old,time,base'
newtb as 'new,time,base'
ac:basepay as 'old,base,pay'
newbp as 'new,base,pay'
if ac:class eq 2355 or 2325 or 2326
if ac:sepcode eq ' '
For additional information on writing defined fields, please refer to the refer to your FOCUS documentation or the Advanced Reporting Agenda and Modules.
Last Updated: August 3, 2005