|
|
Campus Information Retrieval System CIRS Human Resources, Data Operations |
|
User Manual | Data Element Dictionary | Tutorials | Systemwide HR | Support |
|
|
|
Campus Information Retrieval System CIRS Human Resources, Data Operations |
|
User Manual | Data Element Dictionary | Tutorials | Systemwide HR | Support |
|
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.