Creating SPS Payment Summary Files

SPS supports both bulk and non-bulk electronic payments. If you send bulk payment Standard Payment Request (SPR/PAM) schedule data through SPS, you must enter SPS summary data into the database after you receive that data from the Department of Treasury. You then use that data to generate an SPS Summary Certification file to upload to SPS and certify the payment schedules.

The process for submitting SPS bulk payment schedule files and SPS Summary Certification files include the following steps:

1. Submit the bulk SPS payment to the Department of Treasury via magnetic tape or file transfer.

2. The Department of Treasury loads the payment data into their system and provides summary data back to a certifying officer at your agency.

3. Your certifying officer enters this summary data into the PeopleSoft system using the SPS Summary Totals page.

4. You run the APS8004 SQR process to generate the SPS Summary Certification file from the data you entered from the SPS Summary Totals page.

5. Your certifying officer uploads the SPS Summary Certification file to the SPS system to certify the payment schedules.

SPS Summary APS8004.SQR process for GWA Reporters supports the SPS file format for the componentized TAS/BETC. The SPS formats provide specifications for populating TAS and BETC information and grouping of payments. TAS and BETC values are populated in the VCHR_FUND_PCT table from the Voucher component based on the establishment of GL TAS and BETC set up and these values can be used to populate 07 records for GWA Reporters in SPS Summary file. In the SPS Summary file, is credit flag is set to 1 for credit and 0 for debit.

Use the SPS Summary Totals page (GFAP_SPS_SUMMARY) to enter payment information for the summary file.

Navigation:

Accounts Payable > Payments > Pay Cycle Processing > SPS Summary Data > SPS Summary Totals

Accounts Payable > Payments > Pay Cycle Processing > Generate SPS Summary File > SPS Summary Totals

This example illustrates the fields and controls on the SPS Summary Totals page. You can find definitions for the fields and controls later on this page.

After you receive data from the Department of Treasury, use the SPS Summary Totals page to enter the payment information that you will use to create the SF1166 Summary Certification file for each payment schedule. Only exceptions are discussed in this section.