PeopleSoft Enterprise Payroll for North America 9.1 PeopleBook

(USF) Setting Up and Processing Agency Interfaces

This chapter discusses how to:

Set up electronic certification system (ECS) controls.
Prepare ECS off-cycle disbursements.
Run the ECS interface.
Set up the Treasury and Federal Reserve Bank (FRB) Bond interface.
Set up and run the Thrift Savings Plan (TSP) interface.
Run the Reserve Bank Information and Transfer System (RITS) interface process.

Setting Up ECS Controls

This section provides an overview of the ECS interface process and discusses how to:

Establish ECS control information.
Enter transmission information.
Enter extract control information.
Define formats for summary payments.

Understanding the ECS Interface Process

The PeopleSoft Electronic Certification System interface process generates a file that you can load into a U.S. Department of Treasury-provided ECS. Here's a summary of the process:

Create the ECS control.
Run the Treasury and Bond interface, using the ECS control information.

The Treasury and Bond interface updates the ECS control with DOS file and extension names.
Run the ECS interface, using the DOS file and extension names from the ECS control.

Pages Used to Set Up Electronic Certification System Controls

Page Name	Definition Name	Navigation	Usage
Identify ECS Controls (identify electronic certification system controls)	GVT_ECS_CONTRO_TBL	Payroll for North America, Payroll Distribution, Additional Integrations USF, Identify ECS Controls, Identify ECS Controls	Establish ECS control information for payroll schedules.
ECS Transmission Data/Summary (electronic certification system transmission data/summary)	GVT_ECS_TRAN_SEC	Click the ECS Transmission Data/Summary (electronic certification system transmission data/summary) link on the Identify ECS Controls page.	Enter or review schedule control information for the ECS transmittal.
ECS Extract Controls (electronic certification system extract controls)	GVT_ECS_CNTL_SEC	Click the ECS Extract Controls (electronic certification system extract controls) link on the Identify ECS Controls page.	Extract control information for the ECS transmittal.
ECS Schedule Account Information (electronic certification system schedule account information)	GVT_ECS_ACCT_SEC	Click the ECS Schedule Account Info (electronic certification system schedule account information) link on the Identify ECS Controls page.	Enter an account symbol and a total account amount for each ECS transmittal. Enter a maximum of 10 rows per schedule.
ECS Summary Detail (electronic certification system summary detail)	GVT_ECS_SUMM_SEC	Click the ECS Summary Detail (electronic certification system summary detail) link on the Identify ECS Controls page.	Define the schedule and formats for the Treasury interface for summary payments such as check, electronic file transmission (EFT), VENMIS (vendor/miscellaneous), or bonds.
ECS Summary Remarks (electronic certification system summary remarks)	GVT_ECS_REMARK_SEC	Click the ECS Summary Remarks (electronic certification system summary remarks) link on the Identify ECS Controls page.	Add remarks to the ECS transmittal. Use up to seven lines of 72 characters each.
ECS Summary Reel Numbers (electronic certification system summary reel numbers)	GVT_ECS_REEL_SEC	Click the ECS Summary Reel Numbers (electronic certification system summary reel numbers) link on the Identify ECS Controls page.	Enter reel numbers that are provided to you by the treasury to identify the location of your summary payment transactions. This is for your information only.

Establishing ECS Control Information

Access the Identify ECS Controls page (Payroll for North America, Payroll Distribution, Additional Integrations USF, Identify ECS Controls, Identify ECS Controls).

Schedule Number

This field accepts up to 14 characters, but the ECS accepts only the first 10. If you enter more than 10, you receive a warning message.

Schedule Type

Determines the type of off-cycle distribution of deductions and net salary payments. Select:

03 (Salary ACH (Automated Clearing House) Payment Schedule): Select for off-cycle EFT distribution.

05 (Summary Schedule): Select for on-cycle payments.

07 (Misc. Check Payment Schedule): Select for off-cycle check distribution.

08 (Misc. ACH (Automated Clearing House) Payment Schedule).

Regional Finance Center

Select the U.S. Financial Management Service (FMS) Regional Finance Center that's appropriate for your company.

Off-Cycle?

You must select this check box for schedule types 03 and 07.

Process Controls

The links in this group box activate a series of pages where you define ECS process controls. The options that are available to you depend on the schedule type.

Entering Transmission Information

Access the ECS Transmission Data/Summary page (click the ECS Transmission Data/Summary (electronic certification system transmission data/summary) link on the Identify ECS Controls page).

Requested Payment Date	For on-cycle (summary) schedules, the system provides this date. For off-cycle schedules, enter this information.
Number of Payments in Schedule and Schedule Total Amount	For summary schedules, the Treasury interface provides this information. For off-cycle schedules, the ECS interface provides this information.

Entering Extract Control Information

Access the ECS Extract Controls page (click the ECS Extract Controls link on the Identify ECS Controls page).

DOS File Name and DOS File Extension	For summary schedules, the Treasury interface updates the DOS file name and extension of the extract file to be transmitted to the treasury. The file name and extension are required on the Electronic Certification System Interface run control.
ECS Transmission Extract Dt (electronic certification system transmission extract date)	Date on which the ECS interface generated the ECS file.
ECS Transmission Generation Dt (electronic certification system transmission generation date)	Date on which the ECS schedule had all of the required information. This depends on the schedule type.

Defining Formats for Summary Payments

Access the ECS Summary Detail page (click the ECS Summary Detail link on the Identify ECS Controls page).

Prenotification Schedule?	Not currently used.
Summary Payment Type 1	Select the type of payments: Salary or Vendor (VENMIS).
Summary Payment Type 2	Select the method of payment: Check or EFT (electronic file transmission).
MAC Payment Data (MAC payment data)	Optional, for your information only.

Preparing ECS Off-Cycle Disbursements

This section provides an overview of ECS off-cycle disbursements and discusses how to:

Create the ECS control schedule.
Select net payment transactions.
Select deductions transactions.

Understanding ECS Off-Cycle Disbursements

Use off-cycle processing to process off-cycle deductions and net payment amounts through ECS and to track deduction disbursements.

To prepare for off-cycle disbursements:

Define the deduction as time sensitive.
Calculate and confirm the off cycle.
Create the ECS control schedule.
Select the off-cycle transactions for inclusion in processes.
Run the ECS interface.

Pages Used to Prepare ECS Off-Cycle Disbursements

Page Name	Definition Name	Navigation	Usage
Identify ECS Controls (identify electronic certification system controls)	GVT_ECS_CONTRO_TBL	Payroll for North America, Payroll Distribution, Additional Integrations USF, Identify ECS Controls, Identify ECS Controls	Create the ECS control schedule.
Off Cycle Net	GVT_ECS_OFF_NET	Payroll for North America, Payroll Distribution, Additional Integrations USF, Process ECS Off Cycle, Off Cycle Net	Select net payments for ECS off-cycle disbursements. You can view data by schedule or by eligible payments.
Off Cycle Net Check Summary Information	GVT_ECS_OFF_N_SEC	Click the Detail button on the Off Cycle Net page.	View off-cycle net check summary information.
Off Cycle Net Payment ID Information	GVT_ECS_NET_SEC	Click the Line ID Data button on the Off Cycle Net page.	View off-cycle payment ID information for each eligible payment.
Off Cycle Deduction	GVT_ECS_OFF_DED	Payroll for North America, Payroll Distribution, Additional Integrations USF, Process ECS Off Cycle	Select deductions for ECS off-cycle disbursements. You can view data by schedule or by eligible payments.
Off Cycle Deduction Summary Information	GVT_ECS_OFF_D_SEC	Click the Detail button on the Off Cycle Deduction page.	View off-cycle deduction summary information.
Off Cycle Deduction Payment ID Information	GVT_ECS_DED_SEC	Click the Line ID Data button on the Off Cycle Deduction page.	View off-cycle deduction payment ID information for each eligible payment.

Creating the ECS Control Schedule

Access the Identify ECS Controls page (Payroll for North America, Payroll Distribution, Additional Integrations USF, Identify ECS Controls, Identify ECS Controls).

Use the same Identify ECS Controls page for off-cycles as you do for on-cycle processing. The difference is in the schedule type.

See Establishing ECS Control Information.

Selecting Net Payment Transactions

Access the Off Cycle Net page (Payroll for North America, Payroll Distribution, Additional Integrations USF, Process ECS Off Cycle, Off Cycle Net).

Eligible Payment Count

(Visible only in View Eligible Payments mode). This is the total payments that are eligible to be disbursed for this schedule number.

View Eligible Payments

Click to change to View Eligible Payments mode.

View Specific Schedule

Click to change to View Schedule mode.

Remove Selected

(Available in View Eligible Payments mode). Remove payments from the selected schedule. Select the Select check box for each payment that you're removing, then click Remove Selected.

Remove All

(Available in View Schedule mode). Remove all payments from the selected schedule.

Add Selected

(Available in View Eligible Payments mode). Add payments to the selected schedule. Select the Select check box for each eligible payment that you're adding then click Add Selected.

Add All

(Available in View Eligible Payments mode). Add all eligible payments to the selected schedule.

Payments Included with Schedule

Information in this group box depends on which mode you're in:

Mode	Data Displayed
View Specific Schedule	All payments included in the schedule.
View Eligible Payments	All payments eligible to be included in the schedule.

Select	Select an eligible payment to be added or removed.
Net Pay	The net pay amount for each payment.
Detail	Click to display the Off Cycle Net Check Summary Information page.
Line ID Data	Click to display the Off Cycle Net Payment ID Information page.

Selecting Deductions Transactions

Access the Off Cycle Deductn page (Payroll for North America, Payroll Distribution, Additional Integrations USF, Process ECS Off Cycle, Off Cycle Net).

The fields on this page are the same as the Off Cycle Net page with the following exceptions.

Payments Included with Schedule

Information in this group box depends on which mode you're in:

Mode	Data Displayed
View Specific Schedule	All deductions included in the schedule.
View Eligible Payments	All deductions eligible to be included in the schedule.

Pay Period End Date	Pay period end date of the listed deduction.
Plan Type	Plan type of the listed deduction.
Deduction Code	Identifies the listed deduction.
Current Deduction	Current dollar amount of the listed deduction.
Detail	Click to display the Off Cycle Deductions Summary Information page.
Line ID Data	Click to display the Off Cycle Deduction Payment ID Information page.

Running the ECS Interface

This section discusses how to run the ECS interface.

Page Used to Run the ECS Interface

Page Name	Definition Name	Navigation	Usage
Electronic Certification System Interface	RUN_FGPY004	Payroll for North America, Payroll Distribution, Additional Integrations USF, ECS Interface, Electronic Certification System Interface	Creates the ECS interface file for off-cycle disbursements.

Running the ECS Interface

Access the Electronic Certification System Interface page (Payroll for North America, Payroll Distribution, Additional Integrations USF, ECS Interface, Electronic Certification System Interface).

The same Electronic Certification System Interface run control page is used for off-cycles and on-cycles. The output is determined by the ECS control schedule number.

Schedule Number	Select all the ECS schedules that are currently available to be formatted for ECS transmission. Eligible schedules are those with a payment date, more than zero records, and an amount greater than zero. After you run this process, you can no longer modify the ECS control information for the selected schedules.
File Name and Extension	Enter the exact DOS file name and extension of the schedule from the ECS Extract Controls page on the Identify ECS Controls page.

Click Process Request to run this request. PeopleSoft Process Scheduler runs the ECS Interface (electronic certification system interface) Structured Query Report (SQR) Report process (FGPY004) at user-defined intervals.

Setting Up the Treasury and FRB Bond Interface

This section provides an overview of the Treasury and FRB bond interface and discusses how to set up the Treasury and FRB bond interface.

Understanding the Treasury and FRB Bond Interface

Agencies must process all payments through the Treasury Department/Financial Management Services (FMS). There are four basic payroll transactions to be transmitted to the treasury: check, electronic funds transfer, bonds, and taxes.

Page Used to Set Up the Treasury and FRB Bond Interface

Page Name	Definition Name	Navigation	Usage
Treasury/Federal Reserve Bank Bond Interface	RUN_FGPY003	Payroll for North America, Payroll Distribution, Additional Integrations USF, Treasury/FRB Bond Interface, Treasury/Federal Reserve Bank Bond Interface	Select the control information that identifies the schedules to include in the Treasury Interface SQR Report process (FGPY003).

Setting Up the Treasury and FRB Bond Interface

Access the Treasury/Federal Reserve Bank Bond Interface page (Payroll for North America, Payroll Distribution, Additional Integrations USF, Treasury/FRB Bond Interface, Treasury/Federal Reserve Bank Bond Interface).

Treasury Interface Control Inf

Salary Check	Select the schedule of the checks in the payroll run, and enter the file name and extension.
Salary EFT (salary electronic file transmission)	Select the schedule of the EFT transactions of the payroll run, and enter the file name and extension.
VENMIS EFT (vendor/miscellaneous electronic file transmission)	Select the schedule of the EFT tax payment in the payroll run, and enter the file name and extension.
VENMIS Check (vendor/miscellaneous check)	Select the schedule of the check tax payment of the payroll run.

Include Eligible Off Cycle

Include Off Cycle Net Pay	Select to include unprocessed off-cycle net pay in the Treasury interface processing.
Include Off Cycle Deductions	Select to include unprocessed off-cycle deductions in Treasury interface processing.

Fed Reserve Bond Processing

Process Bonds

Select to process Federal Reserve bonds with the run. The other controls in this group box appear only when you select this check box.

Payroll for North America

Setting Up and Running the TSP Interface

This section discusses how to:

Set up a TSP voucher.
Enter off-cycle TSP voucher information.
Run the TSP interface.

Pages Used to Set Up and Run the TSP Interface

Page Name	Definition Name	Navigation	Usage
TSP Vouchers (Thrift Savings Plan vouchers)	GVT_TSP_VCH_TBL	Payroll for North America, Payroll Distribution, Additional Integrations USF, Identify TSP Voucher Info, TSP Vouchers	Define the header information for a TSP voucher file or to print a cancelled TSP voucher.
TSP Voucher Detail (Thrift Savings Plan voucher detail)	GVT_TSP_V_DET_TBL	Payroll for North America, Payroll Distribution, Additional Integrations USF, Identify TSP Voucher Info, TSP Voucher Detail	View a high-level breakdown of a TSP voucher file and enter information for off-cycle vouchers. For on-cycle vouchers, the TSP Interface SQR Report process (FGPY002) populates this page.
Thrift Savings Plan Interface	RUN_FGPY002	Payroll for North America, Payroll Distribution, Additional Integrations USF, TSP Interface, Thrift Savings Plan Interface	Transfer employee information, TSP deductions, and investment elections to the National Finance Center, the record keeper for the Thrift Board.

Setting Up a TSP Voucher

Access the TSP Vouchers page (Payroll for North America, Payroll Distribution, Additional Integrations USF, Identify TSP Voucher Info, TSP Vouchers).

TSP Voucher Number (Thrift Savings Plan voucher number)

The system issues and tracks TSP voucher numbers. The first 2 digits indicate the year, which is from the Agency table. The remaining 4 digits are the voucher sequence number in that year. The system automatically increments the voucher sequence for each row that you add.

Note. You must update the Agency table each year to restart the TSP voucher number sequence.

Routine Pay Submission?

This check box is for system use only. The TSP Interface process selects this check box when you process a voucher for a regular, on-cycle payroll.

EFT Deposit? (electronic file transmission deposit)

This is for your information only.

Reel Number and Date Reel Created

Enter the reel number and date that are provided by the Thrift Savings Board.

Backup and Backup Date

The Thrift Savings Board provides this information.

Total Records

The TSP Interface process provides this number.

Magnetic Tape/Disk Records

For on-cycle TSP vouchers, the system generates the count for each of the categories in this group box. For all other TSP vouchers, you must enter each amount.

Entering Off-Cycle TSP Voucher Information

Access the TSP Voucher Detail page (Payroll for North America, Payroll Distribution, Additional Integrations USF, Identify TSP Voucher Info, TSP Voucher Detail).

Note. You can enter information only for off-cycle vouchers. For on-cycle vouchers, the TSP Interface SQR Report process (FGPY002) populates this page.

Current and Late Payments

For off-cycle vouchers, select a Thrift Savings Plan and enter contribution amounts.

Negative Adjustments

This group box contains negative adjustment amounts and totals for the same categories as in the Current and Late Payments region.

Running the TSP Interface

Access the Thrift Savings Plan Interface page (Payroll for North America, Payroll Distribution, Additional Integrations USF, TSP Interface, Thrift Savings Plan Interface).

Interface File Name

Enter the file name of the TSP interface destination.

Include Eligible Off Cycle

Include Off Cycle Deductions

Select to include unprocessed off-cycle deductions in processing.

Click Process Request to run this request. PeopleSoft Process Scheduler runs the TSP Interface process at user-defined intervals.

Running the RITS Interface Process

This section discusses how to run the RITS Interface SQR Report process (FGPY001).

Page Used to Run the RITS Interface Process

Page Name	Definition Name	Navigation	Usage
Reserve Bank Information and Transfer System interface	RUN_FGPY001	Payroll for North America, Payroll Distribution, Additional Integrations USF, RITS Interface, Reserve Bank Information and Transfer System Interface	Run the RITS Interface process. The output file for the Office of Personnel Management records deduction distributions for retirement Civil Service Retirement System, Federal Employee Retirement System, Federal Employee Health Benefits, health insurance, and Federal Employee Group Life Insurance.

Running the RITS Interface SQR Report Process (FGPY001)

Access the Reserve Bank Information and Transfer System Interface page (Payroll for North America, Payroll Distribution, Additional Integrations USF, RITS Interface, Reserve Bank Information and Transfer System Interface).

Pay Run ID

Select the pay run ID that identifies the on-cycle payroll for which you want to process the RITS interface.

Pay Period Code

Enter the pay period (1 to 26) for which you want to process the RITS interface.

Original or Supplemental

Indicate whether this is the original or a supplemental submission of this RITS process.

2812 File Name

Enter the name of the output file to which the RITS 2812 transmission is written.

Include Eligible Off Cycle

Include Off Cycle Deductions

Select to include unprocessed off-cycle deductions in processing.

Click Process Request to run this request. PeopleSoft Process Scheduler runs the RITS Interface process at user-defined intervals.

Schedule Number	This field accepts up to 14 characters, but the ECS accepts only the first 10. If you enter more than 10, you receive a warning message.
Schedule Type	Determines the type of off-cycle distribution of deductions and net salary payments. Select: 03 (Salary ACH (Automated Clearing House) Payment Schedule): Select for off-cycle EFT distribution. 05 (Summary Schedule): Select for on-cycle payments. 07 (Misc. Check Payment Schedule): Select for off-cycle check distribution. 08 (Misc. ACH (Automated Clearing House) Payment Schedule).
Regional Finance Center	Select the U.S. Financial Management Service (FMS) Regional Finance Center that's appropriate for your company.
Off-Cycle?	You must select this check box for schedule types 03 and 07.

Eligible Payment Count	(Visible only in View Eligible Payments mode). This is the total payments that are eligible to be disbursed for this schedule number.
View Eligible Payments	Click to change to View Eligible Payments mode.
View Specific Schedule	Click to change to View Schedule mode.
Remove Selected	(Available in View Eligible Payments mode). Remove payments from the selected schedule. Select the Select check box for each payment that you're removing, then click Remove Selected.
Remove All	(Available in View Schedule mode). Remove all payments from the selected schedule.
Add Selected	(Available in View Eligible Payments mode). Add payments to the selected schedule. Select the Select check box for each eligible payment that you're adding then click Add Selected.
Add All	(Available in View Eligible Payments mode). Add all eligible payments to the selected schedule.

TSP Voucher Number (Thrift Savings Plan voucher number)	The system issues and tracks TSP voucher numbers. The first 2 digits indicate the year, which is from the Agency table. The remaining 4 digits are the voucher sequence number in that year. The system automatically increments the voucher sequence for each row that you add. Note. You must update the Agency table each year to restart the TSP voucher number sequence.
Routine Pay Submission?	This check box is for system use only. The TSP Interface process selects this check box when you process a voucher for a regular, on-cycle payroll.
EFT Deposit? (electronic file transmission deposit)	This is for your information only.
Reel Number and Date Reel Created	Enter the reel number and date that are provided by the Thrift Savings Board.
Backup and Backup Date	The Thrift Savings Board provides this information.
Total Records	The TSP Interface process provides this number.

Pay Run ID	Select the pay run ID that identifies the on-cycle payroll for which you want to process the RITS interface.
Pay Period Code	Enter the pay period (1 to 26) for which you want to process the RITS interface.
Original or Supplemental	Indicate whether this is the original or a supplemental submission of this RITS process.
2812 File Name	Enter the name of the output file to which the RITS 2812 transmission is written.