Getting Campus Name In Payment Data Reports

The Payment History Data (PH) file is unique from the other payment files because it has all payments issued to your employees - including those issued by other campuses.   So, it's helpful to include campus name in report requests that use this file.  However, campus name is not a field in the PH file.  The solution?  Use the pre-programmed join:  JPHAG.  

 

That join links the PH file to the Agency/Campus/Fund file which contains the field Campus Name, Abbreviated (CAMPUS).   To use the join, simply execute the join name instead of the standard defines. When executed, the join enables you to use any field in either file.  For example:

 

Report Commands:

Report Generated:

EX JPHAG

TABLE FILE PH

SUM PH:GROSSPAY

BY CAMPUS

END

CAMPUS            GROSS PAY

-------          ----------

SACRAMENTO   $12,222,991.87

CHICO             $4,123.11

 

Notice the field name CAMPUS does not have a file prefix.  That is because fields in the AGYCAMP file do not have file prefixes. Also note that unlike some joins, the JPHAG join does not require any screening statements in order to activate the key fields.