Extracting Pay Data For Uploaded SSN's

​If you maintain a file on your PC for a group of employees whose payment history needs to be monitored, you can upload those SSN's to your CIRS PERMSML file and then generate a Payment Extract (PY) file for that group. The steps below outline the process.  

Note:  You cannot use the upload function unless you have upload authority.  Contact your CIRS Security Coordinator for more information.  

Step 1:  

Create a list of SSN's on your PC.

            • Use only one SSN per line (row).
            • The SSN's can be typed with or without hyphens.   
            • ​Save the file as a text (.TXT) file.

Step 2:  

Upload your PC file to your PERMSML file in CIRS.    

            • From action bar on the main CIRS menu, select OTHER and choose option 1.
            • Read and follow the instructions at the Upload screen.

Step 3:  

Create a Payment Extract (PY).  For example, to extract payment data for the current and prior 36 business months, use the selections below.  Do not proceed to Step 4 until you confirm a successful extract.

            • SSN Option:  SSN'S In Hold File PERMSML
            • Date Type & Range:  Pay Periods From 0105 To 0405
            • File Source:  Current & Prior 36 Months
            • ​Output File:  PY

​Step 4:

Generate the needed report using the extracted pay data.  For example, the report below generates a running total of gross pay, by pay period, for each employee:

 

EX PY

TABLE FILE PY

SUM PY:GROSSPAY

AND COMPUTE RUN_TOT/P12.2 =

    IF PY:SSA EQ LAST PY:SSA

    THEN (RUN_TOT + PY:GROSSPAY)

    ELSE PY:GROSSPAY;

BY PY:SSA

BY PY:WNAME

BY PY:PAYPERIOD

END​



Last Updated: February 27, 2024

​