The sample request below gathers payment information from the Payment History Data (PH) file for a group of SSN's held in your PERMSML file using the Match command. If you'd like to copy the request and modify it for your use, it's available in the CIRS common library as FOC3200.
Note: The example below presumes your PERMSML file was populated with SSN's by executing a report request that holds data to the file. If you'd like to populate your PERMSML file by uploading SSN's from your PC, contact the CIRS Hotline for instructions.
The first part of the request executes the standard defines for the PH file and begins the match request by summing gross pay for each SSN, for a specific pay period and your campus code.
EX PH
MATCH FILE PH
sum PH:GROSSPAY
by PH:SSA
IF PH:PAYPERIOD eq __
IF PH:CAMPX EQ __
RUN
-*
The second part of the match compares the SSN's held in your PERMSML file to the PH data using the match option NEW, and holds the matched data to your PERMRPT file. The fieldname E01 is the alias for the data held in PERMSML. Note that E01 was renamed to PH:SSA so FOCUS will recognize that field as the same sort field used for the PH data.
file permsml
print e01
by e01 as 'ph:ssa'
after match hold as permrpt
new
end
-*
The final part of the report request generates the output from the matched data held in PERMRPT.
table file permrpt
print ph:grosspay
by ph:ssa
end
For complete information on matching files, refer to your FOCUS documentation. Alternately, you can refer to the training module titled 'Holding & Matching Data' from the Advanced Reporting Agenda.