Setting Up Country-Specific Tables

This chapter provides an overview of country-specific table setup and discusses how to:

(FRA) Set up French workforce tables.
(DEU) Set up German workforce tables.
(NLD) Set up Dutch SAMEN countries.
(ITA) Set up Italian workforce tables.
(JPN) Set up intercompany transfer company data.
(JPN) Set up Japanese supervisor levels.
(MYS and SGP) Set up festive advance religions tables for the Singapore and Malaysia.
(NZL) Set up New Zealand disability codes.
(ESP) Set up Spanish workforce tables.
(BRA) Set up Brazilian establishments.

Understanding Country-Specific Table Setup

Once you’ve set up the tables that you’ll use to administer your core workforce functionality in PeopleSoft Enterprise Human Resources, you may also need to set up additional tables to manage the Administer Workforce business process for specific countries.

You need to set up only the tables that are relevant to your organization’s business needs.

(FRA) Setting Up French Workforce Tables

To set up the French workforce tables, use the FRA CPAM Table (CPAM_TABLE_FRA), FRA CRAM table (CRAM_TBL_FRA), Hour Type table (HOURS_TYPE_FRA), and Occupational Illness (OCC_ILLNESS_FRA) components.

This section provides an overview of maintaining French social security tracking codes and discusses how to:

Define hours type codes.
Enter French occupational illness codes.

Understanding French Social Security Tracking Code Maintenance

In France, CPAMs are the local social security offices that manage health coverage for French workers. The French government establishes and regulates CPAMs. If you’re managing a French workforce, you’ll need to identify and track the CPAM offices that impact your enterprise.

The CRAM is the regional social security body that oversees the running of CPAMs. CRAM offices work with companies to both prevent and compensate workers for vocational or personal injuries.

Use the French setup tables to maintain Caisse Primaire d'Assurance Maladie (CPAM) and Caisse Regionale d'Assurance Maladie (CRAM) codes for compliance with French social insurance regulations.

Track and report on occupational injuries for French workers using the Monitor Health/Safety application in PeopleSoft Human Resources.

See Also

Creating and Tracking Incidents

Pages Used to Set Up French Workforce Tables

Page Name	Object Name	Navigation	Usage
FRA CPAM Table	CPAM_TABLE_FRA	Set Up HRMS, Product Related, Workforce Administration, Workforce Data FRA, CPAM Table	Modify or add a CPAM ID to your human resources system.
FRA CRAM Table	CRAM_TBL_FRA	Set Up HRMS, Product Related, Workforce Administration, Workforce Data FRA, CRAM Table	Modify or add a CRAM code to your human resources system.
Hour Type Table	HOURS_TYPE_FRA	Set Up HRMS, Product Related, Workforce Administration, Workforce Data FRA, Hours Type	Define hours type codes that you’ll use to track job hours information for French workers.
Occupational Illness	OCC_ILLNESS_FRA	Set Up HRMS, Product Related, Workforce Monitoring, Health and Safety, Occupational Illness Tbl - FRA	Enter French occupational illness codes.

Defining Hours Type Codes

Access the Hour Type Table page.

Hours Type

Enter the hours type code you are defining. Add rows to define as many hours type codes as needed.

Hours Type	Description
3*8	Indicates a shift work pattern. For example, in the manufacturing or industrial sector, production can go on round the clock. The production workers are split into three groups—each group is working one after the other, eight hours a day. Every month, for example, the workers shift to another group. Shift workers who were working the 12 p.m. to 8 a.m. shift move to the 8 a.m. to 4 p.m. shift. Because this type of work schedule implies a lot of constraints in their personal life, those workers are often paid a shift bonus.
2*8	Works the same way as the 3*8 option, but indicates that there are two work shifts as opposed to three.
STA	Indicates that the work hours follow a regular pattern using the job’s standard hours as indicated on the Job Information page.
IND	Indicate that the worker’s hours follow an individualized pattern that is different from the company’s default standard hours. Indicate this amount in the Standard Hours field on the Job Information page. This field is used by the French Employee report (indicator 413 of the Employee Survey for the Trade/Services industry).

Entering French Occupational Illness Codes

Access the Occupational Illness page.

Use this page to define occupational illness categories for French workers. Use the categories when you enter information on the Disability page.

Note. The French Occupational Illness table (OCC_ILLNESS_FRA) is used as a prompt table on the Prof. Dis(Professional Disease) field for the Disability page. While there is another Occupation Illness table (OCC_ILLNESS_TBL) used in the Monitor Health and Safety business process, they aren’t the same page. If you’re entering information about disabilities for French employees on the French Disability page, you must complete this table.

Professional Disability

Enter codes for the occupational illnesses that you want to track in your system.

(DEU) Setting Up German Workforce Tables

To set up the German workforce tables, use the Accident Insurance table (ACCDT_INS_TABLE), BA Cd table (BA_CD_TABLE), Function Code Table (FUNCTION_CD_TBL), Nation Duvo table (NATION_DUVO_TABLE), Industrial Inspection (INDUST_INSP_GER), and SI Unit (SI_UNIT_GER) components.

This section provides an overview of social insurance in Germany and discusses how to:

Define accident insurance codes.
Enter German national DEUEV codes.

Understanding Accident Insurance

Accident insurance in Germany is maintained and administered by private organizations (Berufsgenossenschaften) that act as employer’s liability insurance associations. Employers pay out a certain amount in the form of premiums to these associations, who administer and pay out funds to workers injured on the job. To manage the amount your company contributes to the fund, set up information regarding accident insurance codes and accident insurance hazard codes. The insurance associations usually determine these codes.

To determine your premium, track the number of employees who belong to a hazard class. This number is multiplied by a hazard factor, and the results are supplied to the social insurance provider, which determines the required premium for your organization. These contribution amounts are based on the number of organizations that the provider serves; for example, if one of the companies in the group goes bankrupt, the other member companies may have to pay higher premiums.

Pages Used to Set Up German Workforce Tables

Page Name	Object Name	Navigation	Usage
Accident Insurance - Accident Insurance Table	ACCDT_INS_TABLE	Set Up HRMS, Product Related, Workforce Administration, Workforce Data DEU, Accident Insurance, Accident Insurance Table	Define accident insurance codes for German employees.
Accident Insurance - Accident Insurance Address	ACCDT_INS2_TABLE	Set Up HRMS, Product Related, Workforce Administration, Workforce Data DEU, Accident Insurance, Accident Insurance Address	Enter address information for this accident insurance provider.
BA Cd Table (Bundesanstalt fur Arbeit Code Table)	BA_CD_TABLE	Set Up HRMS, Product Related, Workforce Administration, Workforce Data DEU, BA Codes	Add or update Bundesanstalt fur Arbeit job codes. PeopleSoft maintains the BA Code table so that you can add or update it. All job codes are published by the German Federal Labor Office (Bundesanstalt fur Arbeit) in Verzeichnis der Berufsbezeichnungen and are required on reports to the German Federal Labor Office.
Function Code Table	FUNCTION_CD_TABLE	Set Up HRMS, Product Related, Workforce Administration, Workforce Data DEU, Function Code	Add or maintain job codes for conducting statistical analyses of your workforce in Germany. For example, you can use the codes that you establish here to examine how many consultants, administrators, support staff, or sales representatives make up your workforce.
Nation Duvo Table	NATION_DUVO_TABLE	Set Up HRMS, Product Related, Workforce Administration, Workforce Data DEU, Nation Duvo	Add or update nation DEUEV information.
Industrial Inspection	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. Note. Industrial inspection codes are not effective-dated and have no status.
SI Unit (social insurance unit)	SI_UNIT_GER	Set Up HRMS, Product Related, Workforce Administration, Workforce Data DEU, Social Insurance Unit	Set up German social insurance unit codes that you associate with locations in your organization.

Defining Accident Insurance Codes

Access Accident Insurance - Accident Insurance Table page.

Hazard

Enter the code for the hazard type.

Note. German hazard codes are regulated and standardized by the German government.

Hazard Class

Enter the class, or degree, of the covered hazard.

Entering German Nation DEUEV Codes

The Nation DEUEV table is maintained by PeopleSoft and stores nationality codes specified by the German DEUEV Directive that regulates how data is to be provided to the German social insurance administration by companies doing business in Germany. Using these codes is required for compliance with the German DEUEV (data transmission/transfer) Directive.

Note. The nation codes on the Nation DEUEV table are different from the country codes on the Country table. Nation DEUEV codes are specific to the German DEUEV Directive and are not based on ISO.

Access the Nation Duvo Table page.

Note. The DEUEV Directive specifies the nationality key for each DEUEV country. Don’t change it here unless the DEUEV Directive changes the nationality key.

Nationality	Enter the nationality associated with this country. For example, the nationality associated with The Netherlands is Dutch.
Nationality Code	The DEUEV Directive specifies a unique two-character nationality code for each nationality key. These nationality codes are different from the three-character ISO country codes stored on the Country table.
Country	Indicate an ISO country code to be associated with the DEUEV Directive nationality key.
OECD Country (Organization of Economic Cooperation and Development country)	Select to indicate the nationality key is for an OECD country. Germany carefully regulates the types of industries in which citizens of non-OECD countries, like Iraq, can work. For example, non-OECD nationals are restricted from working in defense-related industries or for companies that produce products involving protected trade technologies. Note. There isn’t always a one-to-one correspondence between ISO countries on the Country table and the nationality keys on the Nation DEUEV table. The German DEUEV Directive makes nationality distinctions that have no direct relationship to ISO country standards.
EU-Land (European Union country)	Select to indicate this is European Union country. Workers from European Union nations are tracked for purposes of reporting to the German Social Insurance administration.

Note. Nationality keys are attached to an employee’s job data on the Job Data Identity/Diversity page. If you’re entering information for German workers, the system prompts for the worker’s nationality code using the DEUEV nations on the Nation DEUEV table.

(NLD) Setting Up Dutch SAMEN Countries

This section provides an overview of SAMEN (Wet Stimulering Arbeidsdeelname Minderheden) country setup and discusses how to update the list of SAMEN countries.

To set up the Dutch SAMEN Country tables, use the SAMEN Country Table (SAMEN_CNTRY_NLD) component.

Understanding SAMEN Country Setup

If you’re administering a Dutch workforce, you’ll need to track information on the national origin of an employee. Employee national origin is based on either their birthplace or their parent’s birthplace. Establishing the ethnic status of workers complies with the SAMEN diversity law or the “law to promote equal labor participation for persons of a different ethnic origin” in The Netherlands.

The SAMEN law provides for equal employment opportunities for immigrant workers and their children. Children of immigrant workers are subject to this law as well, even if they were born in The Netherlands, and even if the parents have been naturalized, as long as one of the parents was born in one of the SAMEN countries. Every two years, the Dutch Ministry of Social Affairs reviews the list of countries that are designated as SAMEN countries. This decision mainly depends on employment statistics for immigrant workers and their children from certain countries.

Note. NATO countries (except Turkey) and EEC countries can’t, by law, be included on the list of SAMEN countries.

Page Used to Set Up Dutch SAMEN Country Table

Page Name	Object Name	Navigation	Usage
SAMEN Country Table	SAMEN_CNTRY_NLD	Set Up HRMS, Product Related, Workforce Administration, SAMEN Country NLD	Update the current list of SAMEN countries.

Updating the List of SAMEN Countries

Access the SAMEN Country Table page.

To add or update countries for SAMEN reporting purposes, either add or delete a country from the list.

If a country code isn’t listed among your SAMEN countries on the SAMEN Country Table page, the system doesn’t include this country in the target group for the SAMEN law when you indicate the national origin of a Dutch worker’s birth parents on the NLD SAMEN Registration page. However, employees have the right to object to this registration, in which case they aren’t included in the SAMEN reporting.

(ITA) Setting Up Italian Workforce Tables

To set up the Italian Workforce tables, use the ITA C.I.A. table (CIA_TBL_ITA), Cities table (CITY_TABLE_ITA), ITA INAIL table (INAIL_TBL_ITA), ITA INPDAI table (INPDAI_TBL_ITA), ITA INPS table (INPS_TBL_ITA), ITA PREV table (PREV_TBL_ITA), Company Codes (COMP_CD_ITA), Company/Estab Codes (COMP_ESTAB_CD_ITA), IT Country FCode (COUNTRY_TABLE_ITA), ITA Seniority Notification (SENIORIT_NOTIF_ITA), Turnover Action (TRV_ACTREAS_ITA), and Productive Unit (UNITA_PROD_TBL) components.

This section discusses setting up Italian workforce tables and how to:

Define Istituto Nazionale per la Previdenza Sociale (INPS) codes.
Define seniority notification periods.

Pages Used to Set Up Italian Workforce Tables

Page Name	Object Name	Navigation	Usage
ITA C.I.A. Table (Contratto Intergrativo Aziendale)	CIA_TBL_ITA	Set Up HRMS, Product Related, Workforce Administration, Workforce Data ITA, C.I.A., ITA C.I.A. Table	Enter company integrative contract information.
ITA City Table	CITY_TABLE_ITA	Set Up HRMS, Product Related, Workforce Administration, Workforce Data ITA, Cities, ITA City Table	Use the Italian City Table page to maintain the city data. Update the table by downloading the file supplied annually from the Ministero delle Finanze website and the running the Italian City Update process. You can enter the postal codes for cities to expedite data entry during the hiring process
ITA INAIL Table	INAIL_TBL_ITA	Set Up HRMS, Product Related, Workforce Administration, Workforce Data ITA, INAIL Codes, ITA INAIL Table	Define the INAIL (Instituto Nazionale per l'Assicurazione degli Incidenti sul Lavoro) position code and rate for INAIL contribution.
ITA INPDAI Table	INPDAI_TBL_ITA	Set Up HRMS, Product Related, Workforce Administration, Workforce Data ITA, INPDAI Codes, ITA INPDAI Table	Define the INPDAI (Istituto Nazionale di Previdenza per I Dirigenti di Aziende Industriali) position codes for pension funds.
ITA INPS Table	INPS_TBL_ITA	Set Up HRMS, Product Related, Workforce Administration, Workforce Data ITA, INPS Codes, ITA INPS Table	Define INPS (Istituto Nazionale per la Previdenza Sociale) data for social security contributions and information needed for social security reporting (DM10).
ITA PREV Table	PREV_TBL_ITA	Set Up HRMS, Product Related, Workforce Administration, Workforce Data ITA, PREV Codes, ITA PREV Table	Define PREVINDAI codes, descriptions, and PREVINDAI position codes.
Company Codes - INPS Codes	COMP_INPS_ITA	Set Up HRMS, Product Related, Workforce Administration, Workforce Data ITA, Company Codes, INPS Codes	Link the company with INPS codes.
Company Codes - INAIL Codes	COMP_INAIL_ITA	Set Up HRMS, Product Related, Workforce Administration, Workforce Data ITA, Company Codes, INAIL Codes	Link the company with INAIL codes.
Company Codes - INPDAI Codes	COMP_INPDAI_ITA	Set Up HRMS, Product Related, Workforce Administration, Workforce Data ITA, Company Codes, INPDAI Codes	Link the company with INPDAI codes.
Company Codes - PREV Codes	COMP_PREV_ITA	Set Up HRMS, Product Related, Workforce Administration, Workforce Data ITA, Company Codes, PREV Codes	Link the company with PREV codes.
Company Codes - C.I.A. Codes	COMP_CIA_ITA	Set Up HRMS, Product Related, Workforce Administration, Workforce Data ITA, Company Codes, C.I.A. Codes	Link the company with C.I.A. codes.
Company/Estab Codes - INPS Codes	EST_INPS_ITA	Set Up HRMS, Product Related, Workforce Administration, Workforce Data ITA, Company/Estab Codes, INPS Codes	Link the company and establishment with INPS codes.
Company/Estab Codes - INAIL Codes	EST_INAIL_ITA	Set Up HRMS, Product Related, Workforce Administration, Workforce Data ITA, Company/Estab Codes, INAIL Codes	Link the company and establishment with INAIL codes.
Company/Estab Codes - INPDAI Codes	EST_INPDAI_ITA	Set Up HRMS, Product Related, Workforce Administration, Workforce Data ITA, Company/Estab Codes, INPDAI Codes	Link the company and establishment with INPDAI codes.
Company/Estab Codes - PREV Codes	EST_PREV_ITA	Set Up HRMS, Product Related, Workforce Administration, Workforce Data ITA, Company/Estab Codes, PREV Codes	Link the company and establishment with PREV codes.
Company/Estab Codes - C.I.A. Codes	EST_CIA_ITA	Set Up HRMS, Product Related, Workforce Administration, Workforce Data ITA, Company/Estab Codes, C.I.A. Codes	Link the company and establishment with C.I.A. (Contratto Intergrativo Aziendale) codes.
IT Country FCode	COUNTRY_DEFN_ITA	Set Up HRMS, Product Related, Workforce Administration, Workforce Data ITA, Country Fiscal Codes, ITA Country FCode	Define the city fiscal code.
ITA Seniority Notification	SENIORIT_NOTIF_ITA	Set Up HRMS, Product Related, Workforce Administration, Workforce Data ITA, Seniority Notification Periods, ITA Seniority Notification	Define seniority termination notification periods for employment categories.
Turnover Action	TRV_ACT_REAS_ITA	Set Up HRMS, Product Related, Workforce Administration, Workforce Data ITA, Turnover Reasons, Turnover Action	Setup action reasons for job turnover actions.
Productive Unit	UNITA_PROD_TBL	Set Up HRMS, Product Related, Workforce Administration, Workforce Data ITA, Production Unit, Productive Unit	Define production units based on your company's agreements with the unions.

Defining INPS Codes

Access the ITA INPS Table page.

INPS Activity Desc (INPS activity description)

Enter company activity description to be reported on the INPS declarations.

INPS Position Code

Enter company INPS position codes.

INPS Site

Enter INPS sites to which the company must send the declarations.

Stat Contr Code(statistical contribution code)

Enter the statistical contribution code to be reported on the INPS declarations.

INPS Fiscal Code

Enter the company fiscal code.

Authorization Number

Enter the authorization codes to be reported on the INPS declarations.

Istat Code

Enter the Istat code to be reported on the INPS declarations.

Defining Seniority Notification Periods

Access the ITA Seniority Notification page.

Category

Select the job category to which this labor agreement notification applies.

Subcategory

Select the job subcategory to which this labor agreement notification applies.

Subcategory 2

Select the job subcategory 2 to which this labor agreement notification applies.

From Seniority

Enter the beginning of the seniority period to which this labor agreement notification applies. The seniority must be entered in month units.

To Seniority

Enter the end of the seniority period to which this labor agreement notification applies. The seniority must be entered in month units.

Notif. Days (notification days)

Enter, in days, the seniority applicable to this period. For example, a labor agreement might require that employees employed for more than 6 months but less than 12 months have a notification period of 30 calendar days.

Type of Day

Indicate whether the notification uses working days or calendar days.

(JPN) Setting Up Intercompany Transfer Company Data

To set up intercompany transfer company data, use the IC Trans External Company/Dept (INTCPX_CPY_JPN) and IC Trans External Superv Lvl (INTCPX_SPV_JPN) components.

This section provides an overview of the setup of company data for intercompany transfers and describes how to set up company data for intercompany transfers.

Understanding Setup of Company Data for Intercompany Transfers

In any intercompany transfer, one of the companies is outside of the PeopleSoft database in which your organization's company data has been set up. Therefore it is necessary to create data in the database for those companies. These setup steps are for that purpose.

To set up company data for intercompany transfers for Japan:

Set up a “dummy” paygroup to use as the compensation indicator if you create intercompany transfers in which the host company is responsible for paying the employee.
Set up company and department codes to use for companies outside of the database.
Set up supervisor level codes to use for companies outside of the database.

See Also

Working with Payee Data

Indicating the Home or Host Compensation Owner

Pages Used to Set Up Intercompany Transfer Company Data

Page Name	Object Name	Navigation	Usage
IC Trans External Company/Dept (internal company transfer external company/department)	INTCPX_CPY_JPN	Set Up HRMS, Product Related, Workforce Administration, Workforce Data JPN, IC Trans External Company/Dept	Set up company and department codes for companies outside the database to use for intercompany transfers.
IC Trans External Superv Lvl (intercompany transfer external supervisor level)	INTCPX_SPV_JPN	Set Up HRMS, Product Related, Workforce Administration, Workforce Data JPN, IC Trans External Superv Lvl	Set up supervisor level codes for companies outside the database to use for intercompany transfers.

(JPN) Setting Up Japanese Supervisor Levels

Supervisor levels are a class of position such as Division Manager and Section Chief. They represent levels of some managerial or supervisory significance that bear responsibility for work above a certain level in order to achieve the organization’s management goals.

The concept of employees’ supervisor level is a central one in Japanese companies’ human resources management. It may or may not be related to an employee’s “job.” Companies usually use supervisor level as another type of employee identifier. Companies that do not use capability grades (or Job Management) may still require the tracking of supervisor levels. Many companies pay employees a component of pay related to their supervisor level.

Supervisor levels usually combine with departments to define positions or posts within an organization, as shown in this sequence of three tables:

Table 1: Supervisor Levels

Supervisor Level	Description
01	Director
02	Senior Manager

Table 2: Departments

Department ID	Description
100	Development
102	Development Section One
200	Sales
210	Sales - West Division

Table 3: Position, Supervisor Level, and Departments

Position or Post	Supervisor Level	Department ID
Director of Development	01	100
Senior Manager of Development Section One	02	102
Director of Sales	01	200
Senior Manager of Sales - West Division	02	210

When you create or update employee Job records, you can enter the supervisor levels that you set up in the Supervisor Level table on the Job Information page. And, because supervisor level is an employee identifier just like job code, position, or manager level, it appears throughout the system. You can view it or enter it on many of the pages on which you can also view or enter job codes, positions, and manager levels. You can also view it on Job Summary and throughout the Plan Careers and Successions and Track Global Assignments business processes.

Page Used to Set Up Japanese Supervisor Levels

Page Name	Object Name	Navigation	Usage
IC Trans External Superv Lvl (intercompany transfer external supervisor level)	INTCPX_SPV_JPN	Set Up HRMS, Product Related, Workforce Administration, Workforce Data JPN, IC Trans External Superv Lvl	Add and modify supervisor level data. Note. This table has SetID as its key.

Page Name

Object Name

Navigation

Usage

IC Trans External Superv Lvl (intercompany transfer external supervisor level)

INTCPX_SPV_JPN

Set Up HRMS, Product Related, Workforce Administration, Workforce Data JPN, IC Trans External Superv Lvl

Add and modify supervisor level data.

Note. This table has SetID as its key.

(MYS and SGP) Setting Up Festive Advance Religions Tables for Singapore and Malaysia

To set up festive advance religions, use the Religions MYS/SGP (RELIGION_TBL_FA) component.

Regulations in some countries require ethnic group tracking by employers. The system tables contain predetermined values for defining ethnic groups and religions. You can add or edit values and descriptions.

This section lists the pages used to set up festive advance religions for Singapore and Malaysia.

Page Used to Set Up Festive Advance Religions for Singapore and Malaysia

Page Name	Object Name	Navigation	Usage
Religions MYS/SGP	RELIGION_TBL_FA	Set Up HRMS, Product Related, Workforce Administration, Religions MYS/SGP	Define religions and festive advance types for Malaysia and Singapore. Select the appropriate festive advance type from the FA Holiday Type field associated with this religion

(NZL) Setting Up New Zealand Disability Codes

To set up New Zealand disability codes, use the Disability Codes (DISABILITY_TBL_NZL) component.

This section discusses how to define disability codes used to track employee disabilities for New Zealand.

Page Used to Set Up New Zealand Disability Codes

Page Name	Object Name	Navigation	Usage
Disability Codes	DISABILITY_TBL_NZL	Set Up HRMS, Product Related, Workforce Administration, Disabilities NZL	Create new disability type codes or modify existing codes.

(ESP) Setting Up Spanish Workforce Tables

To set up Spanish workforce tables, use the Social Security Country Code (SOCS_CNTRY_ESP), Industry Activity (INDUSTRY_ACT_ESP), Insurance Company (INSUR_COMPANY_ESP), Social Security Risk Code (SOCS_RISKCD_ESP), Social Security Scheme (SOCS_SCHEME_ESP), Social Security Company Setup (SOCS_SETUP_ESP), and Hiring Center Table (HIRING_CENTER_ESP) components.

If your organization does business in Spain, you must set up several tables to track information required by the Spanish government for Spanish workers.

This section discusses how to:

View country codes for social security reporting.
Enter Industry Activity codes.
Enter insurance company descriptions and address information.
View risk codes.
Define maximum and minimum social security ceilings.
Define maximum and minimum social security bases by work group.
Define contribution rates and percentages.
Enter company information.
Define Spanish hiring centers.

Pages Used for Spanish Workforce Tables

Page Name	Object Name	Navigation	Usage
Social Security Country Codes	SOCS_CNTRY_ESP	Set Up HRMS, Product Related, Workforce Administration, Workforce Data ESP, Country Codes Table	Enter country codes valid for social security reporting purposes.
Industry Activity	INDUSTRY_ACT_ESP	Set Up HRMS, Product Related, Workforce Administration, Workforce Data ESP, Industry Activity Table	Enter industry activity codes and descriptions. The industry activity code helps determine the employer social security number.
Insurance Company	INSUR_COMPANY_ESP	Set Up HRMS, Product Related, Workforce Administration, Workforce Data ESP, Insurance Company Table	Enter insurance company descriptions and address information.
Social Security Risk Code	SOCS_RISKCD_ESP	Set Up HRMS, Product Related, Workforce Administration, Workforce Data ESP, Soc. Sec. Risk Code Table	View the risk codes that can apply to employees in your organization.
Scheme	SOCS_SCHEME_ESP	Set Up HRMS, Product Related, Workforce Administration, Workforce Data ESP, Soc. Sec. Scheme Table, Scheme	Review or define maximum and minimum social security ceilings, as well as review or define the minimum hourly rate for each social security scheme.
Work Group	SOCS_WRKGRP_ESP	Set Up HRMS, Product Related, Workforce Administration, Workforce Data ESP, Soc. Sec. Scheme Table, Work Group	Define maximum and minimum social security bases by work group, as well as the minimum hourly rate used to calculate the base for part-time employees.
Contribution	SOCS_CONTRIB_ESP	Set Up HRMS, Product Related, Workforce Administration, Workforce Data ESP, Soc. Sec. Scheme Table, Contribution	Define the contribution rates and percentages for both employees and employers used in the social security calculation.
Company Setup	SOCS_SETUP_ESP	Set Up HRMS, Product Related, Workforce Administration, Workforce Data ESP, Soc. Sec. Company Setup	Enter specific company information, including data needed for social security purposes.
Hiring Center	HIRING_CENTER_ESP	Set Up HRMS, Product Related, Workforce Administration, Workforce Data ESP, Hiring Center Table	Define the hiring centers you will attach to employee personnel records on the Contract Data page. You connect every Spanish employee with a hiring center.

Entering Country Codes for Social Security Reporting

Access the Social Security Country Codes page.

Country

Enter the standard ISO country code.

Social Security Country Code

Enter the country code used for social security processing.

Entering Insurance Company Descriptions and Address Information

Access the Insurance Company page.

Edit Address

Click to enter or modify address information.

Viewing Risk Codes

Access the Social Security Risk Code page.

Note. The Spanish government requires employers to assign jobs a social security risk code that rates the risk of illness, accident, or death connected with that type of job.

The PeopleSoft system delivers all social security risk codes as system data.

Social Security Risk Code	The code that you entered to access this page. This is the code defined on this page.
IMS Risk Rate (Riesgo de Invalidez/Muerte/ Supervivencia)	Displays the IMS risk rate that applies to this social security risk code. The Spanish government assigns IMS risk rate codes that assess the risk of work-related disability, death, or survival.
IT Risk Rate (Riesgo de Incapacidad Temporal)	Displays the IT risk rate that applies to this social security risk code. The Spanish government assigns IT risk rate codes to assess the risk of work-related temporary disability, such as respiratory problems for miners or injuries for construction workers.
Total Rate	The system automatically calculates the total rate, the sum of the IMS risk rate, and the IT risk rate.

Defining Maximum and Minimum Social Security Ceilings

Access the Scheme page.

Lower Ceiling

Enter the lower ceiling amount used to calculate the professional contingencies funding base.

Upper Ceiling

Enter the upper ceiling amount used to calculate the professional contingencies funding base.

Minimum Hourly Rate

Enter the amount used to calculate the professional contingencies funding base in the case of employees working part-time.

Important! To trigger the correct part-time calculation of the base, you must specify whether the employee is working on a full or part-time basis in the Full/Part field on the Job Information page.

Defining Maximum and Minimum Social Security Bases by Work Group

Access the Work Group page.

Once you’ve reviewed the ceilings and hourly rate on the Scheme page, use the Work Group page to view and update the maximum and minimum bases for regular employees, and the minimum hourly rate used to calculate the funding base for part-time employees. If you need to define rates and percentages for schemes other than the general scheme, you can do so on this page as well.

Social Security Work Group	All employees who contribute to social security must be assigned to social security work groups (also known as contribution groups) based on their level of education, professional skills, and job title. The SS Work Group field displays the numerical code for each group.
Frequency	This field displays an M (Monthly) or a D (Daily), depending on whether members of the social security work group have their contributions calculated on a daily basis or a monthly basis.
Minimum Amount	Enter the minimum amount used to calculate the common contingencies funding base.
Maximum Amount	Enter the maximum amount used to calculate the common contingencies funding base.
Minimum Hourly (Part Time)	Enter the minimum hourly rate used to calculate the common contingencies funding base for part-time employees. Important! To trigger the correct part-time calculation of the base, you must specify whether the employee is working on a full or part-time basis in the Full/Part field on the Job Information page.

See Also

Entering Job Information

Defining Contribution Rates and Percentages

Access the Contribution page.

If you need to define rates and percentages for schemes other than the general scheme, you can do so on this page.

Contribution ID	In PeopleSoft Enterprise Global Payroll for Spain, there are multiple contribution IDs for each scheme ID, and each contribution ID is associated with its own rates and percentages. To view the different contribution ID classes and their corresponding rates or percentages, use the scroll arrows in the Contribution and Contribution-Concepts scroll areas. Possible values for the contribution ID are: General Empleado Regular (general regular employee) Empleado Regular Tiemp Completo (full-time regular employee) Empleado Reg Tiempo Parcial (part-time regular employee) Empleado Regular E.T.T. (E.T.T. regular employee) Training Contracts Apprenticeship Contract Note. You must associate individual employees with a Scheme and SS Contribution ID on the Contract Data page.
Social Security Number Type	Select one of the following values: Regular: Select to define the percentages used to calculate the contributions of employees with regular contracts. Apprentice: Select to define rates used to calculate the contributions of apprentices. Training: Select to define rates used to calculate the contributions of employees with training contracts.
Contribution Type	Select Percentage if you will be entering percentages in the Employer Percentage or Employee Percentage fields. If you select Percentage, the Employer and Employee Rate fields become unavailable for data entry. Select Rate if you will be entering rates in the Employer or Employee Rate fields. If you select Rate, the Employer and Employee Percentage fields become unavailable for data entry. Important! You should always select Percentage for regular employees, and Rate for apprentices and trainees.
Concept	Indicates the type of contributions for which the system displays corresponding employee or employer contribution rates or percentages in the Contribution-Concepts grid. Possible values are: Common Contingency FOGASA Non Structural Overtime Permanent Disability D & S Professional Training Structural Overtime Temporary Disability Unemployment
Employer Rate	Displays the employer contribution rate associated with the concept listed in the left-hand column of the grid. If you are defining a new rate, enter the rate in this field. Note. Only contributions of apprentices and trainees are based on fixed rates.
Employer Percentage	Displays the employer contribution percentage associated with the concept listed in the left-hand column of the grid. Social security contributions of regular employees are calculated as percentages of a funding base. If you are defining a new percentage, enter the percentage in this field.
Employee Rate	Displays the employee contribution rate associated with the concept listed in the left-hand column of the grid. If you are defining a new rate, enter the rate in this field.
Employee Percentage	Displays the employee contribution percentage associated with the concept listed in the left-hand column of the grid. Social security contributions of regular employees are calculated as percentages of a funding base. If you are defining a new percentage, enter the percentage in this field.

Entering Company Information

Access the Company Setup page.

Social Security Country Code

Enter the social security country code for the company.

Silcon Key

Enter the key provided by the Social Security General Treasury to identify your company during electronic file transfers and to access the shared network.

Deliver Process Code

Select how the company submits social security reports to the Social Security General Treasury. Values include MS DOS, Magnetic D, or Winsuite. Winsuite is the official system for sending flat files containing monthly reports and human resource changes using software provided by the Social Security General Treasury and payroll flat files (like those generated by PeopleSoft Enterprise Global Payroll).

Authorization Key

Enter the authorization code to access Winsuite provided by the Social Security General Treasury.

Source Bank ID

Enter the name of the bank the company uses.

Holder Name

Enter the name the company uses at the bank.

Defining Spanish Hiring Centers

Access the Hiring Center page.

Hiring Center Code

The hiring center code that you entered to access this page.

Responsible ID

Select the employee ID of the person in your organization who is responsible for signing employment contracts at this hiring center.

Responsible Role

Enter a description of the job responsibilities of the person who you designated in the Responsible ID field.

Unemployment Office

Enter a description of the unemployment office for this hiring center.

Signature City

Spanish contracts must be stamped with the date and the name of the city where the contract was signed. Enter the city’s name here.

(BRA) Setting Up Brazilian Establishments

To set up Brazilian establishments, use the Establishment ID Type (ESTAB_TYPE_BRA), Establishment BRA (ESTAB_TBL_BRA), and Centralization Data BRA (CENTRALIZATION_BRA) components.

A company may have several establishments. You must enter data required for reporting purposes for each establishment, such as different ID types.

Note. All Brazilian establishments must belong to a company.

This section discusses how to:

Enter types of establishment ID codes.
Set up establishments.
Group establishments for centralized data.

Pages Used to Set Up Establishments

Page Name	Object Name	Navigation	Usage
Establishment ID Type	ESTAB_TYPE_BRA	Set Up HRMS, Product Related, Workforce Administration, Establishment ID Type BRA	Enter types of establishment ID codes and the format for each ID.
Additional Info - Brazil (additional information - Brazil)	ESTAB_TBL_BRA	Set Up HRMS, Product Related, Workforce Administration, Establishment BRA, Additional Info - Brazil	Set up establishments.
Centralization Data	CENTRALIZATION_BRA	Set Up HRMS, Product Related, Workforce Administration, Centralization Data BRA	Group establishments to obtain centralized data for multiple reports such as SEFIP and CAGED.

Enter Types of Establishment ID Codes

Access the Establishment ID Type page.

Type

Enter the type of establishment ID code. You can enter ID types that are not legal IDs (national IDs) but are required for certain reports.

Default

Select to establish this type of ID code as the default for the selected country.

ID Format

Specify the format of the ID code. Enter a 9 for each digit of the ID number.

The system has edit masks that apply special formatting to some of the ID types you enter on this page. The system applies the following formatting to these ID types:

CNPJ: 99.999.999/9999-99

CNAE: 99.99-9

Setting Up Establishments

Access the Additional Info - Brazil page.

County Code

Enter the county code.

Inscr. Type (inscription type)

Select the company inscription type. Values are: CNPJ or CEI.

Estab Type Cd (establishment type code)

Select the establishment type code, which is based on the size of the establishment. Values are: Micro, Other, and Small.

Note. The following sections contain setup data for various reports. PeopleSoft delivers only the GPS, SEFIP, and CAGED reports. The other reports will be delivered later.

PIS Data

Enter information used to generate the Programa de Integração Social (PIS) report.

PV Adm (PV administration)	Enter the number of the Caixa Economica Federal (Federal Saving Bank) branch that generates the file with the issued resources for the PIS payment of employees (TSO file).
Date	The date the Federal Saving Bank generated the TSO file.

RAIS Data

Enter information used to generate the Relação Anual de Informações Sociais (RAIS) report.

RAIS Estab Pref (RAIS establishment prefix)	Enter the prefix only if the establishment register appears for RAIS as a key differentiation. RAIS assigns the establishment prefix.
# of Owners (number of owners)	Enter the number of owners working in the establishment.
Own Serv % (owner service percentage)	Enter the owner service percentage.
Kit Admin % (kitchen administration percentage)	Enter the kitchen administration percentage.
Meals Agr % (meals agreement percentage)	Enter the meals agreement percentage.
Trans Meals % (transported meals percentage)	Enter the transported meals percentage.
Food Basket % (food basket percentage)	Enter the food basket percentage.
Feeding Agr % (feeding tickets agreement percentage)	Enter the feeding tickets agreement percentage.
Closing Activities RAIS	Select to indicate that the establishment closed its activities during the base year (the year for which you are currently reporting). A RAIS report uses this information.
PAT Participation Option (Programa de Alimentação do Trabalhador participation option)	Select to indicate the establishment participates in PAT.

GPS/SEFIP Data

Enter information used to generate the Guia de Recolhimento da Previdência Social/ Sistema Empresa de Recolhimento do FGTS e Informações à Previdência Social(GPS/SEFIP) report.

GPS Pay Code	Enter the company’s social security contribution code.
SAT Code	Enter the work accident insurance code.
FPAS Code	Enter the FPAS (Fundo de Previdência e Assistência Social) social assistance and pension fund code. The activity type of the company determines this code. The system identifies all third parties and their respective percentages assigned to this code and generates a total percentage of collection for the establishment.
Third Party Code	Enter the code of the third-party that collected service from the establishment. The system uses these codes to identify the third parties involved in a specific collection. The SEFIP report uses this code to get the GFIP value.
SS 3th Party % (social security third-party percentage)	Enter the total percentage of social security contributed by a third-party for a specific collection. The system uses this value to obtain the Other Entities Amount on the social security payment form (GPS).
SAT % 15 Years (SAT percentage up to 15 years), SAT % 20 Years (SAT percentage up to 20 years), and SAT % 25 Years (SAT percentage up to 25 years)	Enter the percentages that apply to only the eligible employees for each case of special retirement (with 15, 20, and 25 years of service). The system uses this percentage to obtain the special retirement component of the INSS total amount for collection.
Worth Risk %	Enter the establishment’s identified predominant worth risk percentage. The system uses this percentage to obtain worth risk component of the INSS total amount for collection.
Company %	Enter the percentage to use to obtain the company component of the INSS total amount for collection.
Independent %	Enter the percentage to use to obtain the independent component of the INSS total amount for collection.
Philant. Exemp % (philanthropy exemption percentage)	Enter the percentage to use to obtain the philanthropy exemption component of the INSS total amount for collection.

DIRF Responsible

Complete this group box only for Declaração de Informações à Receita Federal (DIRF) centralizing establishments.

DIRF Rep Type (DIRF representative type)	Select whether the party responsible for generating the DIRF file is a Company, Employee, or Non Empl (non-employee).
DIRF Resp ID (DIRF responsible ID)	Enter the company code or employee ID of the party responsible for generating the DIRF file.

SEFIP Responsible

SEFIP Rep Type (SEFIP representative type)	Select whether the party responsible for generating the SEFIP file is a Company, Employee, or Non Empl (non-employee).
SEFIP Resp ID (SEFIP responsible ID)	Enter the company code or employee ID of the party responsible for generating the SEFIP file.

RAIS Responsible

Complete this group box only for RAIS centralizing establishments.

RAIS Rep Type (RAIS representative type)	Select whether the party responsible for generating the RAIS file is a Company, Employee, or Non Empl (non-employee).
RAIS Resp ID (RAIS responsible ID)	Enter the company code or employee ID of the party responsible for generating the RAIS file.

Establishment ID

Type	Enter an establishment ID type.
ID	Enter the establishment’s ID.

Grouping Establishments for Centralized Data

Access the Centralization Data page.

Process Type

When you add a record, select the type of data that you want to centralize, such as SEFIP or CAGED.

Centralizer

Enter the name of the establishment that creates centralized data for reporting purposes.

Establishment ID

Enter the IDs of all establishments whose data the centralizer collects.

INPS Activity Desc (INPS activity description)	Enter company activity description to be reported on the INPS declarations.
INPS Position Code	Enter company INPS position codes.
INPS Site	Enter INPS sites to which the company must send the declarations.
Stat Contr Code(statistical contribution code)	Enter the statistical contribution code to be reported on the INPS declarations.
INPS Fiscal Code	Enter the company fiscal code.
Authorization Number	Enter the authorization codes to be reported on the INPS declarations.
Istat Code	Enter the Istat code to be reported on the INPS declarations.

Category	Select the job category to which this labor agreement notification applies.
Subcategory	Select the job subcategory to which this labor agreement notification applies.
Subcategory 2	Select the job subcategory 2 to which this labor agreement notification applies.
From Seniority	Enter the beginning of the seniority period to which this labor agreement notification applies. The seniority must be entered in month units.
To Seniority	Enter the end of the seniority period to which this labor agreement notification applies. The seniority must be entered in month units.
Notif. Days (notification days)	Enter, in days, the seniority applicable to this period. For example, a labor agreement might require that employees employed for more than 6 months but less than 12 months have a notification period of 30 calendar days.
Type of Day	Indicate whether the notification uses working days or calendar days.

Country	Enter the standard ISO country code.
Social Security Country Code	Enter the country code used for social security processing.

Social Security Country Code	Enter the social security country code for the company.
Silcon Key	Enter the key provided by the Social Security General Treasury to identify your company during electronic file transfers and to access the shared network.
Deliver Process Code	Select how the company submits social security reports to the Social Security General Treasury. Values include MS DOS, Magnetic D, or Winsuite. Winsuite is the official system for sending flat files containing monthly reports and human resource changes using software provided by the Social Security General Treasury and payroll flat files (like those generated by PeopleSoft Enterprise Global Payroll).
Authorization Key	Enter the authorization code to access Winsuite provided by the Social Security General Treasury.
Source Bank ID	Enter the name of the bank the company uses.
Holder Name	Enter the name the company uses at the bank.

Hiring Center Code	The hiring center code that you entered to access this page.
Responsible ID	Select the employee ID of the person in your organization who is responsible for signing employment contracts at this hiring center.
Responsible Role	Enter a description of the job responsibilities of the person who you designated in the Responsible ID field.
Unemployment Office	Enter a description of the unemployment office for this hiring center.
Signature City	Spanish contracts must be stamped with the date and the name of the city where the contract was signed. Enter the city’s name here.

County Code	Enter the county code.
Inscr. Type (inscription type)	Select the company inscription type. Values are: CNPJ or CEI.
Estab Type Cd (establishment type code)	Select the establishment type code, which is based on the size of the establishment. Values are: Micro, Other, and Small.

Process Type	When you add a record, select the type of data that you want to centralize, such as SEFIP or CAGED.
Centralizer	Enter the name of the establishment that creates centralized data for reporting purposes.
Establishment ID	Enter the IDs of all establishments whose data the centralizer collects.