This chapter provides an overview of local country functionality set up and discusses how to:
(CHE) Maintain Swiss postal codes.
(DEU) Set up German industrial inspection codes.
(ITA) Set up Italian city tables.
(JPN) Set up Japanese control tables.
(NLD) Load Dutch postal codes.
(ESP) Set up Spanish control tables.
(GBR) Set up national insurance prefixes for the U.K.
If you’re administering a local or multinational workforce, you must set up certain tables that are referenced in the core control tables to support local country requirements. Do this before you set up core control tables, such as for pay groups, or define companies, locations, departments, and job codes.
To maintain Swiss postal codes, use the Load Postal Codes CHE component (POSTAL_LOAD_CHE).
This section provides an overview of Swiss postal code maintenance and discusses how to update Swiss valid addresses.
To update postal codes:
Download the latest update of postal codes from the website of the Swiss Post and note the path to the file in which you save it.
Download the latest update of alternate names from the website of the Swiss Post and note the path to the file in which you save it.
Use the Load Valid Addresses CHE page to enter the file paths and load the valid addresses and alternate names files to the Valid Addresses table.
The system uses the information on the Valid Addresses table to validate municipalities against the postal code.
Page Name |
Object Name |
Navigation |
Usage |
POSTAL_LOAD_CHE |
Set Up HRMS, Install, Product and Country Specific, Load Postal Codes CHE |
Load Swiss postal code information into the Valid Addresses table. |
Access the Load Valid Addresses CHE page.
Postal Codes File |
Enter the complete path to the Postal Code file that you downloaded from the Swiss Post. |
Alternate Names file |
Enter the complete path to the Alternate Names file that you downloaded from the Swiss Post. |
Load Data |
Click to load the postal code data into the Valid Addresses table. |
State, Postal Code, and City |
Initially, these fields display the current data from the Valid Addresses table. After you run the load process, the updated information appears. |
To set up German industrial inspection codes, use the Industrial Inspection component (IDUST_INSPEC_GER).
This section discusses how to set up German industrial inspections codes.
Page Name |
Object Name |
Navigation |
Usage |
INDUST_INSP_GER |
Set Up HRMS, Product Related, Workforce Administration, Workforce Data DEU, Industrial Inspection |
Set up German industrial inspection codes that you associate with locations in your organization. |
Access the Industrial Inspection page.
Industrial inspection codes aren’t effective-dated and have no status.
City |
Specify the city that is associated with this industrial inspection code according to the German Berufsgenossenschaft. |
To set up Italian city codes, use the Load Cities ITA component (RUNCTL_CITYUPDATE).
This section lists the page used to load Italian city data.
See Also
Setting Up Country-Specific Tables
Page Name |
Object Name |
Navigation |
Usage |
RUNCTL_CITYUPDATE |
Set Up HRMS, Install, Product and Country Specific, Load Cities ITA, ITA City Update |
After downloading the city code data file from the Ministero delle Finanze, run the ITA City Update process to update Italian city data. |
To set up Japanese control tables, use the Postal Code Table JPN component (POSTAL_CODE_TBL), the Education Level component (EDLVLAG_TBL_JPN), and the Calculation Rules Settings component (SETUP_SALCOMP_JPN).
This section provides an overview of education level age and discusses how to:
Set up the Education Level Age table.
Establish Japanese salary component settings.
Set up the Postal Code table.
Maintain the Postal Code table.
The Education Level Age Table enables you to link highest education levels—already in the system—to what we call the Education Level Age Basis (as of hire). The system uses the Education Level Age Basis in the calculation of a worker’s Education Level - Adjusted Birth Date, which is in turn used in the calculation of a worker’s Education Level Age at any point in time. The system uses a worker’s Education Level Age in education level age-related pay calculations. Education level age-related pay is a form of seniority pay.
Calculating a Worker's Education Level Age
This section discusses how the system uses the Education Level Age Basis in the eventual determination of a worker’s education age-related pay. This section uses many acronyms, so here’s a quick reference:
Acronym |
Meaning |
ELABa |
Education Level Age Basis (as of Hire) |
AELABa |
Adjusted Education Level Age Basis (as of Hire) |
ELABi |
Education Level - Adjusted Birth Date |
SCB |
Standard Calculation Birthday |
CSD |
Company Seniority Date |
ELA |
Education Level Age |
Company A has set the Education Level Age Basis (ELABa) for four years of college at 22. The company also set the Standard Calculation Birthday (SCB)—the anniversary for incrementing years of service—to April 1.
Hiroshi was born on February 6, 1972 and graduated after four years of college on March 23, 1994 at age 22. He then spent two years travelling around the world. Company A hired him on June 1, 1996. He is not hired on April 1 because he didn't get back from his travels until May 1996. At the time he is hired, he is 24 years old.
For the purpose of calculating Hiroshi’s education age-related pay, each year the system needs to calculate Hiroshi’s Education Level Age. It will use his Education Level - Adjusted Birth Date to do this.
In calculating a worker’s ELABi, the system uses the ELABa, the Company Seniority Date (CSD), and the company’s SCB.
The relationship between the worker’s CSD and the company’s SCB may result in an adjustment to the worker’s ELABa, called the Adjusted Education Level Age Basis or AELABa. If the month/day of a worker’s hire date (as determined by the CSD field) is after the company’s SCB (that is, CSD is greater than SCB), the worker’s ELABa is decreased by 1.
In Hiroshi’s case, because his June 1 month/day hire date (also his CSD) falls after the company’s April 1 SCB, his ELABa is decreased by 1. If he had been hired on or before April 1, there would be no adjustment to his ELABa.
This is how to get Hiroshi’s AELABa:
Since CSD month/day (Jun 1) > SCB month/day (Apr 1), adjustment = -1
Using this -1 you get:
ELABa – 1 = AELABa
Which in Hiroshi’s case is:
22 – 1 = 21
The system now uses the AELABa (21) to determine Hiroshi’s ELABi year.
This formula is:
Year of Hire – AELABa = ELABi (year)
or
1996 – 21 = 1975
So for education age-related pay calculations, Hiroshi’s ELABi is April 1, 1975, the combination of the company’s SCB month/day and Hiroshi’s ELABi year (remember, he was born February 6, 1972).
Now we can look at how important that ELABi is.
One year later, 1997, the system needs to know Hiroshi’s ELA. This is the calculation:
SCB (including Year of Calculation) – ELABi = ELA
or
April 1, 1997 – April 1, 1975 = 22
This is the same ELA as a graduate who started with the company immediately after college. This set of calculations has, then, effectively adjusted Hiroshi’s ELA, upon which education age-related pay is based, to take into account the two years that he spent traveling and the fact that he started work after the company’s SCB.
Note. If your company considers that the lapse of two months from April to June is not significant, you can adjust Hiroshi’s ELABi from April 1, 1975 to April 1, 1974. Then, for the same 1997 calculation, Hiroshi’s ELA is 23 (April 1, 1997 to April 1, 1974), the same as a new graduate who has worked for one year.
See Also
Access the Education Level Age Tbl JPN page.
The system uses these age bases in the calculation of a worker’s Education Level-Adjusted Birth Date, which is, in turn, used in the calculation of the worker’s Education Level Age and education level age-related pay.
Education Level Age Basis |
This is the value you associate with the Highest Education Level that you selected in the first field. The system uses this in calculating a worker’s Education Level-Adjusted Birth Date, which is used in the calculation of a worker’s education level age. |
Note. The Highest Education Level values are translate values from the Highest Education Level table. You access the table to put workers’ highest education levels on their Personal History page in Personal Information. If you change any of these translate values (inactivate them, for example), you will need to change any worker records that were using the value to use another value. If you add a translate value and you want to associate an education level age basis with it, you must also add it to this page and allocate an Education Level Age Basis to keep it synchronized with the Highest Education Level table. If you don’t add it, and you use the new Highest Education Level value—in Personal Data, Personal Profile, for example—the system will not be able to calculate the worker’s Education Level - Adjusted Birth Date (it will remain blank). Consequently, the system will not be able to calculate the worker’s Education Level Age.
Access the Load Postal Codes JPN page.
Note. Before using this page, you must download and extract the CSV file from Japan Post's website and post it to a FTP server located at your site. The CSV file must be encoded in Shift-JIS character set. You must define URL data in the PeopleTools Utilities menu before using this Load Postal Code process.
See Specifying the Address Format for a Country.
URL Identifier |
Select the FTP Uniform Resource Locator (URL) where the CSV file that contains the postal codes is located. |
All Prefectures |
Select this option to load postal data for all prefectures. Note. Because there are more than 120,000 postal codes rows, consider batch performance when importing all rows. |
Selected Prefecture |
Select this option to load postal codes for a specific prefecture. |
Load Results
If the length of Address1 or Address AC1 is more than 55 characters, the fields are left blank. Also, if the length of Address1 or Address AC1 is too long and divided into multiple rows, only the first row is imported and the rest of the rows are printed on the log reports as unimported rows.
If you want to remove “Not listed as below” as the Address 1 and AC Address 1, register these text strings in the Strings Table; the Program ID is HGJPPSTL. Set the text that you want to remove to String Text fields.
All rows might not appear when there are multiple rows for a single postal code with the same State, City, Address1, but different Address1_AC because of different pronunciation.
If expected data is not loaded, add it or edit it on the Postal Code JPN page.
Postal Code Load Process Log Reports
After completion of this process, the system generates a process log report that lists the number of rows imported, the number of rows not imported, and a detailed reason for the latter. Possible reasons for not importing rows include:
The import file was not found.
The file is formatted incorrectly.
The import file is for a different prefecture from the one specified in the Selected Prefecture field.
Access the Postal Code Table page.
Municipal Code |
Enter the code for the Japanese municipality that this postal code belongs to. |
Prefecture |
Select the prefecture for this postal code from the list. |
Access the Calculation Rule Settings JPN page.
Standard Calculation Birthday
This is the single date, or anniversary, on which your workers’ education level ages increment by one.
Educ Lvl Month (education level month) |
Enter the month, where January = 1, February = 2 and so on. This sets the month of your organization’s Standard Calculation Birthday, the date on which all workers’ company years of seniority increment by one year. It is used in the calculation of each worker’s Education Level Age. |
Educ Lvl Day (education level day) |
This is the day of the month of the Standard Calculation Birthday. For example, Month 4, Day 1 sets the Standard Calculation Birthday as April 1. |
Defined Range Check |
Select to ensure the system checks that any record added to a Job Data - Compensation page with a compensation rate code of class Defined Rate of Pay (DFRPAY) is within the range that you have defined for that grade on the Salary Grade Table. The check applies to both a manually added record and an automatically added record. Selecting this check box also ensures that only one compensation rate code of the class DFRPAY can be entered on a worker's Compensation page. |
See Also
Entering Compensation Information
To load Dutch postal codes, use the Postal Codes NLD component (RUN_POSTAL_NLD).
This section discusses how to import postal codes into the Postal Code table.
Page Name |
Object Name |
Navigation |
Usage |
RUNCTL_POSTAL_NLD |
Set Up HRMS, Install, Product and Country Specific, Load Postal Codes NLD |
Import postal codes into the NLD Postal Code table in your human resources system. |
Access the Load Postal Codes NLD page.
The Dutch postal authority provides a postal code table to which you can subscribe. The Load Postal Code Table process loads all of the postal codes provided in a source file by the Dutch Post (TPG Post) into your human resources system.
Report Request Parameters
Initial Postal Code Loadfile |
Enter the initial postal code load file, including the path information, if you’re adding Dutch postal code data to your system for the first time. |
Update Postal Code File |
Enter the updated postal code file, including the path information, if you’re doing a periodic update of the Dutch Postal Code Table. |
Run |
Click to run this request. PeopleSoft Process Scheduler runs the NLD Load Postal Code Table process at user-defined intervals. |
To set up Spanish control tables, use the Insurance Company Table component (INSUR_COMPANY_ESP) and the Industry Activity Table component (INDUSTRY_ACT_ESP).
If you do business in Spain, enter the information that is required by the Spanish government concerning your organization’s primary industry activity and the insurance company that you use for workplace accidents or illnesses.
The Spanish government also requires every Spanish worker to belong to a Social Security Work Center. Employers use the work center number information to report worker information to the Spanish Social Security National Institute (Instituto Nacional de la Seguridad Social).
See Also
Adding Organizational Instances for Employees, Contingent Workers, and POIs
Page Name |
Object Name |
Navigation |
Usage |
INSUR_COMP_CD_ESP |
Set Up HRMS, Product Related, Workforce Administration, Workforce Data ESP, Insurance Company Table, Insurance Company |
Enter information about your organization’s insurance company. |
|
INDSTRY_ACT_CD_ESP |
Set Up HRMS, Product Related, Workforce Administration, Workforce Data ESP, Industry Activity Table, Industry Activity |
Define the codes that are needed by your organization. |
This section provides an overview of national insurance prefixes and discusses how to:
Review national insurance prefixes.
Update national insurance prefixes.
Starting in the tax year 2004/2005, the Inland Revenue requires that employers’ year-end reporting contains valid national insurance prefixes only. Submissions with invalid national insurance prefixes will be rejected.
Use the delivered setup table to define valid national insurance prefixes. When you enter a person's national insurance code on the Biographical Details page, the system validates the prefix against this national insurance prefix table.
The format of national insurance numbers is defined on the National ID Type Table page, which is described in this PeopleBook.
See Also
Entering Name and Biographical Data
Page Name |
Object Name |
Navigation |
Usage |
NID_PREFIX_GBR |
Set Up HRMS, Install, Product and Country Specific, NID Prefix GBR |
View the existing NID prefixes. |
|
NID_PR_GBR_SEC |
Click a NI prefix link or click the Add button on the NID Prefix GBR page. |
Set up a new NID prefix or change the status of an existing prefix. |
Access the NID Prefix GBR page.
By default, this page lists the NID prefixes that are active as of the current date. Click the NID prefix link to view and update the effective date and status of the selected NID prefix.
Effective and Status |
To display NID prefixes that are active as of a different date or to display NID prefixes with a different status, update the Effective field and/or the Status field and click the Refresh button |
Refresh |
Click to refresh the page. Use this button when you change the Effective or Status fields. |
Add |
Click to add a new NI prefix. The NID Prefix Details page appears. |
Access the NID Prefix Details page.
Use this page to add a new NID prefix or change the status of an existing NID prefix. To change existing prefixes, add a new row.
Select the date that the prefix becomes Active or Inactive and select the status in the Status field.