(USF) Treasury Interface Extract Process

The system includes two error messages to ensure that the required source records are encrypted when running the Treasury Interface Extract process (FGPY040.SQR).

This example illustrates the error message that appears online when the PeopleSoft Payroll for North America: Treasury Interface Extract Page is saved in any of these scenarios: 1) DIR_DEP_DISTRIB is encrypted and GVT_PAM_SAL_DTL is decrypted, or 2) GVT_PAM_SAL_DTL is encrypted and DIR_DEP_DISTRIB is decrypted.

Out-of-sync message for unencrypted Direct Deposit Distribution Detail and PAM Salary Detail records

This example illustrates the error message that appears online when the PeopleSoft Payroll for North America: Treasury Interface Extract Page is saved and one or more of the bank account numbers is not encrypted on these records: GENL_DEDUCTION, GVT_DED_DIST, GVT_GARN_SPEC, GVT_GARN_SPEC, GVT_PAM_VEN_SUM, and GVT_TAX_ROUTING.

Out-of-sync message for other unencrypted Federal-specific records

If the Treasury Interface Extract run control page was saved in the database before encryption was run, the Out-of-Sync messages will not appear online when the page is saved. Instead, the Out-of-Sync messages will be added to the FGPY040 log file.

To ensure that the Treasury Interface Extract process runs successfully, you must first encrypt these source records:

  • DIR_DEP_DISTRIB

  • GENL_DEDUCTION

  • GVT_DED_DIST

  • GVT_GARN_SPEC

  • GVT_PAM_SAL_DTL

  • GVT_PAM_VEN_SUM

  • GVT_TAX_ROUTING