Setting Up Local Country Functionality

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.

Understanding Local Country Functionality Setup

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.

(CHE) Maintaining Swiss Postal 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.

Understanding Swiss Postal Code Maintenance

To update postal codes:

1. 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.

2. 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.

3. Use the Load Postal Codes 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 Used to Maintain Swiss Valid Addresses

Updating Swiss Valid Addresses

Access the Load Postal Codes CHE page (Set Up HRMS, Install, Product and Country Specific, Load Postal Codes CHE, Load Postal Codes CHE).

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.

(DEU) Setting Up the German Control Table

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 Used to Set Up German Industrial Inspection Codes

Setting Up German Industrial Inspection Codes

Access the Industrial Inspection page (Set Up HRMS, Product Related, Workforce Administration, Workforce Data DEU, Industrial Inspection, Industrial Inspection).

Industrial inspection codes aren't effective-dated and have no status.

(ITA) Setting Up Italian City Codes

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 Used to Load Italian City Data

(JPN) Setting Up Japanese Control Tables

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.

Understanding Education Level Ages

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:

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

Administering Seniority Pay

Pages Used to Set Up Japanese Control Tables

Setting Up the Education Level Age Table

Access the Education Level page (Set Up HRMS, Product Related, Workforce Administration, Workforce Data JPN, Education Level, Education Level).

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.

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.

Establishing Japanese Salary Component Settings

Access the Calculation Rule Settings page (Set Up HRMS, Product Related, Workforce Administration, Workforce Data JPN, Calculation Rule Settings, Calculation Rule Settings).

Standard Calculation Birthday

This is the single date, or anniversary, on which your workers' education level ages increment by one.

See Also

Entering Compensation Information

Setting Up the Postal Code Table

Access the Load Postal Codes JPN page (Set Up HRMS, Install, Product and Country Specific, Load Postal Codes JPN, Load Postal Codes JPN).

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.

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 Codes 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.

Maintaining the Postal Code Table

Access the Postal Codes JPN page (Set Up HRMS, Install, Product and Country Specific, Postal Codes JPN, Postal Codes JPN).

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.

(NLD) Loading Dutch Postal Codes

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 JPN .

Page Used to Load Postal Codes

Importing Postal Codes Into the Postal Code Table

Access the Load Postal Codes NLD page (Set Up HRMS, Install, Product and Country Specific, Load Postal Codes NLD, Load Postal Codes NLD).

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

(ESP) Setting Up Spanish Control Tables

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

Pages Used to Set Up Spanish Control Tables

(GBR) Setting Up National Insurance Prefixes for the U.K.

To set up national insurance prefixes for the UK, use the NID Prefix GBR (NID_PREFIX_GBR) component.

This section provides an overview of national insurance prefixes and discusses how to:

• Review national insurance prefixes.

• Update national insurance prefixes.

Understanding 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

Defining National ID Types

Entering Name and Biographical Data

Pages Used to Set Up National Insurance Prefixes

Reviewing National Insurance Prefixes

Access the NID Prefix GBR page (Set Up HRMS, Install, Product and Country Specific, NID Prefix GBR, NID Prefix GBR).

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.

Updating National Insurance Prefixes

Access the NID Prefix Details page (click a NI prefix link or click the Add button on the NID Prefix GBR 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.