Matching PH File To PERMSML File

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.