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.