PeopleSoft Enterprise Global Payroll for Japan 9.1 PeopleBook

Working with Banking

This chapter provides an overview of the banking process and discusses how to:

Set up banking.
Set up alternate source banks.
Generate banking electronic funds transfer (EFT) files and report.

Understanding the Banking Process

The following is a brief summary of the direct deposit banking process that is used for net payments to employees in Japan. Subsequent sections provide more details about these steps:

Set up bank accounts and schedule disbursements.
Run payroll.
Run the Banking process.
Run the Japan EFT process, which automatically generates the EFT file and Structured Query Report (SQR).

Terms and Definitions

The following terms are used in discussing the banking process:

Source bank	The bank that pays out the funds.
Transfer bank	The bank that receives the funds.

For direct deposit, the source bank is the company's bank and the transfer bank is the employee's bank.

Delivered Elements

The PeopleSoft system delivers a query that you can run to view the names of all delivered elements designed for Japan. Instructions for running the query are provided in the PeopleSoft Enterprise Global Payroll 9.1 PeopleBook.

Setting Up Banking

Setting up banking involves entering three categories of information on up to 11 pages. The setup involves:

Identifying banks, branches, and accounts for your company and payees.
Identifying source banks and defining the level of funding.
Identifying transfer banks and scheduling disbursements.

Employees can specify percentage or amount disbursements to any number of bank accounts for each payment type (salary or bonus).

Banking setup steps are documented fully in the "Understanding Banking" chapter of the core PeopleSoft Enterprise Global Payroll 9.1 PeopleBook. However, there are some details about following these steps that are important for banking in Japan.

Banking Setup Details

The following table lists the details for using the banking setup pages to set up banking in Japan:

Page Name	Element	Instructions
Bank Table	AC Bank Name (alternate character bank name).	Enter the bank name in single-byte Katakana format.
Bank Branch Table	Branch Information group box.	Specify a branch for every source bank and transfer bank that you set up. The EFT process halts with an error message when it encounters a net payment that does not have a branch associated with it.
Bank Branch Table	AC Branch Name (alternate character branch name).	Enter the branch name in single-byte Katakana format.
Source Bank Accounts	AC Account Name (alternate character account name).	Enter the bank account name in single-byte Katakana format.
Source Bank Accounts	Other Required Information.	Click this link to access the Japan Bank Additional Data page, where you must enter the company code and account type. If you leave the Account Type field blank, the EFT process supplies the Regular value.
Bank Account Information	AC Account Name (alternate character account name).	The default value is the alternate character name from the AC Name field on the Personal Data page.

Note. All alternate character (AC) fields appear only if you enabled AC functionality on the Organization Defaults by Permission List page.

See Also

Defining Banking Instructions

Setting Up and Working with Languages

Setting Up Alternate Source Banks

This section provides an overview of alternate source banks and discusses how to define alternate source banks.

Understanding Alternate Source Banks

If needed, you must define multiple pay entity source banks and multiple organizational unit source banks before running the banking process. Doing so establishes the appropriate source bank for each payee based on the recipient bank account.

While running the Global Payroll for Japan banking process, the system tries to match the payee's bank with the source bank in the following order:

The organization's default source bank.
The organization link's alternate source banks.
The pay entity's default source bank.
The pay entity's alternate source banks.

When a matching bank is found, the system uses this value for the remainder of the banking process.

Pages Used to Set Up Alternate Source Banks

Page Name	Definition Name	Navigation	Usage
Pay Entity Source Bank JPN	GPJP_PE_ALT_SBANK	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Framework, Organizational, Pay Entity Source Bank JPN, Pay Entity Source Bank JPN	Define alternate source banks for pay entities and organizations.
Alternate Source Bank	GPJP_ALT_SBANK_SEC	Click the Alternate Source Bank link on the Pay Entity Source Bank JPN page.	Define the alternate source banks for an organization link.

Defining Alternate Source Banks

Access the Pay Entity Source Bank JPN page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Framework, Organizational, Pay Entity Source Bank JPN, Pay Entity Source Bank JPN).

Enter one or multiple source banks for the pay entity level or the organizational link or both. The Global Payroll for Japan banking process uses these values to override the source bank that is used for each payment row on the payment processing results table (GP_PAYMENT).

Click the Alternate Source Bank link to further define the source bank associated with the organizational link.

Generating Banking EFT Files and Report

This section provides overviews of the EFT process flow and processing steps, lists a prerequisite, and discusses how to:

Run the banking process.
Create EFT payment files.

Understanding the EFT Process Flow

This diagram illustrates the payroll EFT process flow for Japan, which includes descriptions of each step from the finalization of payroll to the printing of reports or the creation of a flat output file:

Payroll EFT process flow for Japan, including descriptions of each step to either print a report of the final payment or create a flat output file.

Understanding the Processing Steps

The steps in this section correspond to the numbers in the preceding diagram:

Process payroll in the Global Payroll core application.
Run the Global Payroll for Japan banking process.

This process populates the GP_PAYMENT output record.

Note. Select the Finalize check box on the Banking Run Control page when you run the Banking process. If you do not, there won't be any data available for the next step.
Run the Global Payroll for Japan EFT process (GPJP_BA01_AE).

This process selects all rows in GP_PAYMENT that have a status of Finalized for the specified calendar group ID, run type name, and source bank ID.

The process populates the following records, which form the header, transaction, and trailer of both the EFT file and the printed report:
- GPJP_BA_HEADER: The data in this record comes from the run control parameters that you enter on the EFT page.
  
  It identifies the company and the source bank account information.
- GPJP_BA_TRANS: The data in this record comes from GP_PAYMENT and from the source and transfer bank data that you set up previously.
  
  It details the employee information, the transfer bank account information, and the amount of the transfer.
- GPJP_BA_TRAILER: This record stores totals, such as the number of records in the TRANS record and the total amount of money being transferred.
  
  The process changes the status of rows in GP_PAYMENT from Finalized to Transferred.
The EFT process consolidates the data from the three records into one EFT file that you send to the source bank.

It uses the file name and character set from the File Handles JPN page.
The EFT process launches the SQR program (GPJPBA01 SQR).
The SQR program prints the Banking report in the standard character set by using data from the same three records as the EFT file.

See Also

Understanding Banking

Prerequisite

You must set up file handles on the File Handles JPN page before you can run the EFT process. The file handle looks up the file name and character set (single-byte Katakana) that is used to generate the file.

See Also

Setting Up File Handles

Pages Used to Run the Banking and EFT Processes and Print the Report

Page Name	Definition Name	Navigation	Usage
Run Banking Process JPN	GPJP_RC_BA02	Global Payroll & Absence Mgmt, Payment Processing, Run Banking Process JPN, Run Banking Process JPN	Run a process to create a payment file that contains banking details.
File Handles JPN	GPJP_FILE_HANDL	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Reports, File Handles JPN, File Handles JPN	Assign a handle to each file that you want to export.
Create EFT Payment File JPN (create electronic funds transfer payment file Japan)	GPJP_RC_BA01	Global Payroll & Absence Mgmt, Payment Processing, Create EFT Payment File JPN, Create EFT Payment File JPN	Create EFT payment file. Run the EFT process, which prepares the EFT flat file that you transmit to the appropriate bank and launches the SQR program that prints the Banking report (GPJPBA01).

Running the Banking Process

Access the Run Banking Process JPN page (Global Payroll & Absence Mgmt, Payment Processing, Run Banking Process JPN, Run Banking Process JPN).

Calendar Group

Select a calendar group for which to run the process. The system processes any items (segments) that are approved or finalized by the payroll process.

Stream Number

If the Process Streams check box is selected, and you select Calculate in the Processing Options group box, you must select the stream number to process. Each stream number represents a predefined range of payees.

Process Streams

The Process Streams check box is selected automatically if you selected the stream processing option when defining the calendar group.

Processing Options

Calculate

Select to have the system create the payment file by matching the approved and finalized results from the payroll process with information that you defined in banking setup.

You can run the calculate step repeatedly until you finalize the banking process.

Finalize

Select, after everything is calculated. (If you use stream processing for the Calculate phase, the system finalizes all streams for the calendar group simultaneously.)

Note. If you're not using streams, you can select Calculate and Finalize at the same time.

Update Statistics

Select to have the banking system generate statistics to help the data administrator fine-tune system performance.

Streams

This group box displays all streams that are associated with the calendar group.

Calendars in Run

After you run the Calculate phase, this group box displays information for each calendar in the calendar run.

See Also

Creating Process Streams

Creating EFT Payment Files

Access the Create EFT Payment File JPN page (Global Payroll & Absence Mgmt, Payment Processing, Create EFT Payment File JPN, Create EFT Payment File JPN).

All of the fields on this page are required to run the process.

Calendar Group ID	The EFT process uses the values that you select in the Calendar Group ID, Run Type Name, and Source Bank ID fields to extract the appropriate information from the GP_PAYMENT table.
File Handle	The file handle set up on the File Handles JPN page that identifies the file name and character set used in this process.
Payment Type	Valid values are Salary and Bonus. This data appears in the header of the EFT file.
Deposit Date	This date appears in the header of the EFT file.

Calendar Group	Select a calendar group for which to run the process. The system processes any items (segments) that are approved or finalized by the payroll process.
Stream Number	If the Process Streams check box is selected, and you select Calculate in the Processing Options group box, you must select the stream number to process. Each stream number represents a predefined range of payees.
Process Streams	The Process Streams check box is selected automatically if you selected the stream processing option when defining the calendar group.