Setting Up Postal Codes

Global Payroll for Switzerland is delivered with Swiss postal codes. The system uses the postal codes to validate and prompt for municipality codes. You can view the contents of the Postal Code table and load updates from the Swiss Post website.

For GP Switzerland users, the menu (Set Up HCM, Product Related, Global Payroll & Absence Mgmt, Framework, Organizational, Postal/Municipality Codes CHE) for updating Postal and Municipality Codes has changed.

GP Switzerland customers are provided features to load the Postal Codes & Municipality Codes by downloading the Ortschaftenverzeichnis der Schweiz Excel Sheet (do-t-09.02-gwr-37), which is available from the Swiss Federal Statistical Office Website

To install the update, the user has to download the data from folder Ortschaftenverz.-Rép. Localités, save this folder as .csv and then upload this .csv by using Load Files CHE, file type Postal Codes.

User may consider as well to upload the enhanced files provided by Oracle along with regular announcements of legal changes. For more information please see Global Payroll for Switzerland Position Statement 2017 (Doc ID 2216589.1)

Load Postal and Municipality Codes CHE

After uploading the file and selecting Run, the following page is displayed.

This example illustrates the fields and controls on the Postal Data page.

The user have to fill in just the current year.

Once data got loaded user can review orphan Postal Code and Municipality Code by using the button ‘Validate Postal Codes’. This returns a list of active assignments for expired Codes. See HCM 92 PI 25 GP Swiss Report samples.

The Municipality Codes CHE page now maintains data from POSTAL_CD_CHE (formerly GPCH_TX_VILLAGE) and is displayed as:

Municipality Codes CHE page