Sample Request: Graduate Assistant Timebase Change

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.

 

EX AC

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;

END

 

-*

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 ' '

end

 

For additional information on writing defined fields, please refer to the refer to your FOCUS documentation or the Advanced Reporting Agenda and Modules.