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.
(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 APE Table (APE_TABLE_FRA), the INSEE Table (INSEE_TABLE_FRA), the External Variables (EXTERNAL_VARIABLES), URSSAF Table (URSSAF_TABLE_FRA), FRA CPAM Table (CPAM_TABLE_FRA), FRA CRAM table (CRAM_TBL_FRA), Hour Type table (HOUR_TYPE_TABLE), and Occupational Illness (OCC_ILLNESS_FRA) components.

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

Maintain INSEE codes.
Enter salary and social security ceiling information.
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 and Safety business process in PeopleSoft Enterprise Human Resources.

See Also

Creating and Tracking Incidents

Pages Used to Set Up French Workforce Tables

Page Name	Object Name	Navigation	Usage
APE Table	APE_INDSTRY_CD_FRA	Set Up HRMS, Product Related, Workforce Administration, Workforce Data FRA, APE Table	Maintain APE codes for your French organization. APE codes are used to classify the type of industry (such as software, banking, and insurance) that a company represents. APE codes are a normalized set of codes that are required by law and are used on Training Report 2483 (TRN029).
Insee Table Fra	INSEE_TABLE_FRA	Set Up HRMS, Product Related, Workforce Administration, Workforce Data FRA, INSEE Table	Maintain INSEE codes for your French organization.
External Variables	EXT_PARM_CD_FRA	Set Up HRMS, Product Related, Workforce Administration, Workforce Data FRA, External Variables Set Up HRMS, Product Related, Workforce Monitoring, Regulatory Requirements FRA, External Variables	Enter information that is related to the salaries and Social Security ceilings that are established by the French government each year.
URSSAF Table	URSSAF_TABLE_FRA	Set Up HRMS, Product Related, Workforce Administration, Workforce Data FRA, URSSAF Table	Set up URSSAF codes. The URSSAF is a French administration that collects the worker and employer contributions for Social Security. This table stores the codes for the local URSSAF offices.
FRA CPAM Table	CPAM_TABLE	Set Up HRMS, Product Related, Workforce Administration, Workforce Data FRA, CPAM Table, FRA CPAM Table	Modify or add a CPAM ID to your human resources system.
FRA CRAM Table	CRAM_TBL	Set Up HRMS, Product Related, Workforce Administration, Workforce Data FRA, CRAM Table, 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, Hour Type Table	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, Occupational Illness	Enter French occupational illness codes.

Maintaining INSEE Codes

Access the Insee Table Fra page.

The system displays the description that you enter for this code on pages or reports in PeopleSoft Enterprise Human Resources that reference the INSEE code.

These values are set by the INSEE and classify job codes. Link INSEE codes to job codes that are used in French organizations on the Job Data - Evaluation Criteria page.

Special ability

Select if this INSEE code represents a job that requires a special ability.

An worker who is assigned (through the job code) an INSEE code with this check box selected can’t be listed as disabled on the French Disability report.

Population Category

Select the population category associated with this INSEE code. Population codes are used in the definition of contingency contracts to identify the population covered by a contract. Population codes are also used by the DUCS reporting in PeopleSoft Enterprise Global Payroll for France.

See Also

Classifying Jobs

Setting Up French Regulatory Requirements

Entering Salary and Social Security Ceiling Information

Access the External Variables page.

The values that you enter act as a reference for salary and payroll processing in PeopleSoft Human Resources.

Leg&Reg Report Parameters (legislative and regulatory report parameters)

Minimum Salary, Retail Price Index, and Minimum Salary Guaranteed	Enter a minimum salary, retail price index, and guaranteed minimum salary for this external variable. The French government sets the amounts.
Disability Report Rate	Prior to launching the Disability report (DIS001), enter a disability report rate. The rate is set by the French government, and the current rate is 6 percent (a field value of 0,06). The disability report rate is set up in the External Variables Table.

Social Security Ceiling

These ceiling values are determined every year by the French Social Security Administration; the values that you enter are the ceiling values that define different income brackets for French workers. They are also used as a reference for payroll calculations for French workers because many types of Social Security contributions are calculated based on the Social Security income bracket into which an worker’s salary falls.

For example, if you enter the following Social Security ceilings for Social Security Ceiling A, B, and C, and the tax rates for each bracket of income are as shown:

	Bracket A	Bracket B	Bracket C	Above
Ceiling	2279 EUR	9116 EUR	18233 EUR
Tax Rate	10%	15%	18%	20%

Then an worker whose salary is 31000 EUR per month, based on this Social Security and tax rate scenario, is required to pay the following Social Security premium:

(2,279 X 10%) + (9,116 X 15%) + (18,233 X 18%) + (1,372 X 20%)

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 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 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, BA Cd Table	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, Function Code Table	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, Nation Duvo Table	Add or update nation DEUEV information.
Industrial Inspection	INDUST_INSP_GER	Set Up HRMS, Product Related, Workforce Administration, Workforce Data DEU, Industrial Inspection, 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, SI 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.

Note. From December 31, 2003 the SAMEN law is no longer a legislative requirement. However, we continue to provide the ability to track employees' national origin to enable you to monitor workforce diversity.

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, SAMEN Country Table	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), INPS Site (INPS_SITE_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 Integrativo 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 (Istituto 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. Note. The INPDAI codes are used for historical data only. The INPDAI is no longer a legal body in Italy and these codes are no longer required.
INPS Site	INPS_SITE_ITA	Set Up HRMS, Product Related, Workforce Administration, Workforce Data ITA, INPS Sites, INPS Site	Set up INPS (Istituto Nazionale per la Previdenza Sociale) site codes. Link INPS sites to INPS codes on the ITA INPS Table page.
ITA INPS Table	INPS_TBL_ITA	Set Up HRMS, Product Related, Workforce Administration, Workforce Data ITA, INPS Codes, ITA INPS Table	Define INPS 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 - CIA Codes	EST_CIA_ITA	Set Up HRMS, Product Related, Workforce Administration, Workforce Data ITA, Company/Estab Codes, CIA 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	Set up 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 the company activity description to be reported on the INPS declarations.

INPS Position Code

Enter the company INPS position codes.

INPS Site

Select the INPS site to which the company must send declarations. Set up INPS site codes on the INPS Site page.

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” pay group 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

Understanding Supervisor Levels

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

Setting Up Company Data for Intercompany Transfers

Access the IC Trans External Company/Dept page.

The Effective Date must be prior to any intercompany transfer effective dates to transfer to the external company, and the Status option must be Active.

Enter required rows in the Department Information group box.

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

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

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, Disability Codes	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), Social Security Data (SSEC_DATA_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:

Enter 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 needed for Social Security reporting.
Define a social security time limit for FDI data.
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, Social Security Country Codes	Enter country codes valid for social security reporting purposes.
Industry Activity	INDUSTRY_ACT_CD_ESP	Set Up HRMS, Product Related, Workforce Administration, Workforce Data ESP, Industry Activity Table, Industry Activity	Enter industry activity codes and descriptions. The industry activity code helps determine the employer social security number.
Insurance Company	INSUR_COMP_CD_ESP	Set Up HRMS, Product Related, Workforce Administration, Workforce Data ESP, Insurance Company Table, Insurance Company	Enter insurance company descriptions and address information.
Social Security Risk Code	SOCS_RISKCD_ESP	Set Up HRMS, Product Related, Workforce Administration, Workforce Data ESP, Social Security Risk Code, Social Security Risk Code	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, Social Security 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, Social Security 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,Social Security 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, Social Security Company Setup, Company Setup	Enter specific company information, including data needed for social security purposes.
Social Security Data	SOCS_DATA_ESP	Set Up HRMS, Product Related, Workforce Administration, Workforce Data ESP, Social Security Data, Social Security Data	Define a time limit for transferring FDI medical report data to the social security agency.
Hiring Center	HIRING_CENTER_ESP	Set Up HRMS, Product Related, Workforce Administration, Workforce Data ESP, Hiring Center Table, Hiring Center	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 Industry Activity Codes

Access the Industry Activity page.

Enter the effective date, status, description, and short description of the industry activity.

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 Social Security 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 to pay social security contributions.

Holder Name

Enter the name the company uses at the bank.

Delta Data

Preventive

Identify the kind of labor risk prevention management that the company uses. Valid values are:

Business owner: The company assumes responsibilities. Fills the <asunpersona> tag.
Designated Workers: Managed by designated employees. Fills the <trabdesigna> tag.
External: Managed by an external service outside of the company. Fills the <serprevpro> tag.
Internal: Managed by a service organization within the company. Fills the <serprevaje> tag.
None: The company does not manage labor risk prevention. Fills the <ninguna> tag.
Shared: Managed jointly by several services. Fills the <serprevman> tag.

See Managing Delta Communications.

Defining a Social Security Time Limit for FDI Data

Access the Social Security Data page.

WS File Version

This field identifies the version of the Winsuite software used by the social security agency for reporting. As this software is updated, you must update the file version.

Sick Note

Specify the time limit (in days) for transferring sick note data to the social security agency following receipt of the note from an employee. If you select the Add Security Period check box on the Create FDI File ESP page (discussed below), the system compares the date on which the file with the sick note data is transferred to the agency (system date) to the absence begin date. If the number of days between the file transfer date and the absence begin date exceeds the time limit for sick notes, the system marks the employee as Late on the Create FDI File ESP page.

Medical Discharge

Specify the time limit (in days) for transferring medical discharge data to the social security agency following receipt of a discharge note from an employee. If you select the Add Security Period check box on the Create FDI File ESP page (discussed below), the system compares the date on which the file with the medical discharge note data is transferred to the agency (system date) to the absence end date. If the number of days between the file transfer date and the absence end date exceeds the time limit for medical discharge notes, the system marks the employee as Late on the Create FDI File ESP page.

Confirmation Note

Specify the time limit (in days) for transferring confirmation note data to the social security agency following receipt of the note from an employee. If you select the Add Security Period check box on the Create FDI File ESP page (discussed below), the system compares the date on which the file with the confirmation note data is transferred to the agency (system date) to the confirmation date you entered on the Additional Data page. If the number of days between the file transfer date and the confirmation date exceeds the time limit for medical discharge notes, the system marks the employee as Late on the Create FDI File ESP page.

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, Establishment ID Type	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, Centralization Data	Group establishments to obtain centralized data for multiple reports such as SEFIP and CAGED.

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

Estab Responsible by Agreement (establishment responsible by agreement)	When you select this check box, the CAIXA Agency field appears.
CAIXA Agency	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.
Work 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 the company activity description to be reported on the INPS declarations.
INPS Position Code	Enter the company INPS position codes.
INPS Site	Select the INPS site to which the company must send declarations. Set up INPS site codes on the INPS Site page.
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 to pay social security contributions.
Holder Name	Enter the name the company uses at the bank.

WS File Version	This field identifies the version of the Winsuite software used by the social security agency for reporting. As this software is updated, you must update the file version.
Sick Note	Specify the time limit (in days) for transferring sick note data to the social security agency following receipt of the note from an employee. If you select the Add Security Period check box on the Create FDI File ESP page (discussed below), the system compares the date on which the file with the sick note data is transferred to the agency (system date) to the absence begin date. If the number of days between the file transfer date and the absence begin date exceeds the time limit for sick notes, the system marks the employee as Late on the Create FDI File ESP page.
Medical Discharge	Specify the time limit (in days) for transferring medical discharge data to the social security agency following receipt of a discharge note from an employee. If you select the Add Security Period check box on the Create FDI File ESP page (discussed below), the system compares the date on which the file with the medical discharge note data is transferred to the agency (system date) to the absence end date. If the number of days between the file transfer date and the absence end date exceeds the time limit for medical discharge notes, the system marks the employee as Late on the Create FDI File ESP page.
Confirmation Note	Specify the time limit (in days) for transferring confirmation note data to the social security agency following receipt of the note from an employee. If you select the Add Security Period check box on the Create FDI File ESP page (discussed below), the system compares the date on which the file with the confirmation note data is transferred to the agency (system date) to the confirmation date you entered on the Additional Data page. If the number of days between the file transfer date and the confirmation date exceeds the time limit for medical discharge notes, the system marks the employee as Late on the Create FDI File ESP 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.

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.