The sample report below provides year-to-date payment and withhold information for your noncitizen employees with visa type J or F. In order to identify all your faculty, staff and student employees, a match is needed between the Active Current Status (AC) file and the Student (ST) file. After that data is gathered and held, it is then matched to the Payment History (PH) file to get the pay data information.
SSA PH:WNAME VISA PH:GROSSPAY PH:FEDWH PH:STEWH
--- -------- ---- ----------- -------- -------
000-00-0001 FOX, E J J00N062005 $3,734.27 .00 .00
000-00-0002 PENGUIN, H O FOON062007 $641.67 15.42 .00
000-00-0003 ANT, A S JOON062005 $6,000.00 1107.00 361.74
The report request below is in the common library as FOC5003.
Note the following:
-
The verb SUM is used in the AC and ST files to get only one row of data for each employee.
-
The merge phrase OLD-OR-NEW is used for the AC and ST file to gather all data from either file that meets the selection criteria.
-
The merge phrase OLD is used between the AC/ST data and the PH file to keep all data for noncitizen employees and incorporate any matching data from the PH file.
-
If you only want to get pay data issued by your campus, include a screening statement for your campus (e.g., IF PH:CAMPX EQ _) in the portion of the request that is gathering data from the PH file.
EX AC
EX ST
EX PH
-*
MATCH FILE AC
SUM AC:NONCITZN
BY AC:SSA AS 'SSA'
IF AC:VISA EQ J OR F
RUN
-*
FILE ST
SUM ST:NONCITZN
BY ST:SSA AS 'SSA'
IF ST:VISA EQ J OR F
AFTER MATCH HOLD AS PERMLRG OLD-OR-NEW
RUN
-*
FILE PH
SUM PH:GROSSPAY PH:FEDWH PH:STEWH
BY PH:SSA AS 'SSA'
BY PH:WNAME
IF PH:ISSUEDTE GE 2005/01/01
AFTER MATCH HOLD AS PERMLRG OLD
END
-*
DEFINE FILE PERMLRG
VISA/A10 = IF AC:NONCITZN EQ ' ' THEN ST:NONCITZN ELSE AC:NONCITZN;
END
TABLE FILE PERMLRG
PRINT PH:WNAME VISA PH:GROSSPAY PH:FEDWH PH:STEWH
BY SSA
IF PH:GROSSPAY GT 0
END
Last Updated: March 1, 2024