Sample Request: Estimating Number Of W2

The sample report request below can be used to obtain the estimated number of W-2's for your campus.   

 

EX PHS

TABLE FILE PHS

SUM CNT.DST.PHS:SSA

IF PHS:TAXYEAR EQ 2002

END

 

  • The Payment History Summary (PHS) file is used because it includes data for a calendar (tax) year.  The other payment files (PH, PY) could also be used for this request, but using PH would require a match between fiscal years and using PY would require creating a hold file and an extract file.

  • The direct operators, CNT. and DST. are used to obtain a count of distinct occurrences of social security numbers.  When direct operators are used, SUM must be used as the verb.  

  • Note:  The request must be executed using Batch because the PHS file is not available in the online FOCUS  environment.   

 

See also:  Payment History Summary (PHS) File.