This chapter provides overviews of social insurance (SI) and flexible worktime for Germany and discusses how to:
Enter social insurance data.
Set up accident insurance.
Set up contribution groups.
View pension insurance providers.
View and load provider information.
Set up social insurance providers.
Import health insurance rates.
Set up social insurance provider rates.
Define income limits.
As an employer, you are legally required to maintain and report a variety of tax and social insurance data about your employees. You must register employees with the health insurance providers that they select, and you are responsible for control notifications. For example, you are responsible for control notifications if a new employee has not submitted a social insurance ID within three days of beginning work.
Enter employee social insurance data in the Social Insurance component, which consists of the Contributions, SI Details, and Retiree Health Insurance pages.
Social insurance consists of the following types of insurance: health, nursing care, retirement or pension, and unemployment. View the individual types by using the inner scroll arrows. You must enter all social insurance information before you can save your data.
Global Payroll for Germany handles the calculations necessary to accommodate flexible worktime agreements between an employer and an employee. The only data that you need to supply the system is the effective date of the flexible worktime contract.
Flexible worktime functionality addresses the following payroll processing needs:
Collecting savings for flexible worktime.
Savings are input using earnings (one for monetary savings and another for time savings). These earnings contribute their amounts/hours, depending on the social insurance region, to corresponding accumulators.
Collecting SI-Gross Space.
The gross space is the amount between the contributed gross and the monthly limit for that social insurance branch.
Calculation of social insurance contributions during the regular spending of flexible worktime earnings.
When employees are spending their saved amounts in a free time phase, then the amounts are used as the base for the calculation of contributions the same way as normal gross payment.
Calculation of social insurance contributions for disruptive events (Stoerfall).
If an employee does not use the saved amounts for free time phases, but gets the amounts paid back partly or in full, then a disruptive event happens. In this case the amount is insured similar to a bonus, but the cumulated gross space of the whole flexible worktime period is used to determine the insurable gross, not only the gross space of the current year. A disruptive event also happens when the employee dies before he can make use of the free time phase.
DEUEV reporting.
The existence of a disruptive event (Stoerfall) needs to be reported as a DEUEV event.
Flexible Worktime Element Naming Conventions
To clarify the identification of element functionality, most PeopleSoft-delivered elements used by the flexible worktime calculations process follow a specific naming convention, which is described in this table:
Flexible Worktime Element Type |
Element Name Format |
Accumulator |
DE_FL_A<code> |
Savings (Wertguthaben) |
DE_FL_W<code> |
Gross Space (Luft) |
DE_FL_L<code> |
Earnings/Deduction |
DE_FL_E<code> |
The <code> portion of the element name is a three-digit code, followed by the letter E or S, and then followed by a final digit. Element names follow one of two specific <code> formats:
<owner><unit><region>E<usage> <owner><unit><region>S<SI branch>
This table details the meanings of the digits and letters in the <code> portion of an element name.
Digit/Letter |
Purpose |
Values |
1 (first) |
Owner/Calculation Type |
0 = Calculation K = Customer P = PeopleSoft |
2 (second) |
Unit |
0 = Not Applicable 1 = Units/Hours |
3 (third) |
Region |
0 = Not Applicable 1 = East 2 = West |
4 (fourth) |
Earnings Type or Social Insurance Branch |
E = Earnings Type S = Social Insurance Branch |
5 (fifth) |
Usage or SI Branch |
If the fourth letter is an E: 0 = Amount/Balance 1 = Amount to save 2 = Free time payback 3 = Stoerfall payback If the fourth is an S: 0 = Not Applicable 1 = Health Insurance 2 = Home care Insurance 3 = Pension Insurance 4 = Unemployment Insurance |
Examples
DE_FL_E001E2 = Free time payback amount earning for the east region used in the calculation.
DE_FL_A012E3 = Stoerfall payback time in units accumulator for the west region used in the calculation.
The PeopleSoft system delivers a query that you can run to view the names of all delivered elements designed for Germany. Instructions for running the query are provided in the PeopleSoft Global Payroll PeopleBook.
See Also
Understanding How to View Delivered Elements
This section discusses how to:
Set up SI data for employees.
Enter additional social insurance details for employees.
Enter retiree health insurance data.
Set up multiple employments data.
Set up flex time entry.
Set up a pay entity location.
Report social insurance cContributions - GPDESI10.
Access the Maintain Social Ins Data DEU - Contributions page (Global Payroll & Absence Mgmt, Payee Data, Social Security/Insurance, Maintain Social Ins Data DEU, Contributions).
Note. Save the employee social insurance data only after
you enter all the required data in the pages of this component.
Use the scroll arrows to select the individual types of social insurance
types.
Effective Date |
The system automatically sets this field to the employee's hire date. You can override this and enter another effective date for processing the employee's social insurance contributions. |
DEUEV Contribution Group Code |
The DEUEV contribution group code of the employee. |
SI Provider (social insurance provider) |
The entity that provides the insurance coverage type that you specify as the primary provider. The value of this field remains the same for all social insurance types. Note. The system populates this field for the coverage type Health Insurance. This field is blank if the employee is privately insured. |
Miners' Social Insurance |
Select if the employee is a member of a miners' insurance association. |
Insurance Details
SI Coverage Type (social insurance coverage type) |
The individual types of insurance. |
Primary Provider |
Select to specify that the selected insurance provider is also the primary provider for social insurance contributions. The DEUEV reports will be sent to this provider. Warning! If no social insurance provider has been assigned to the selected primary provider, the system issues a warning. Only one insurance type can be specified as the primary provider. It is possible, however, not to assign a primary provider to an employee. |
Insurance Coverage Type |
Select your employee's coverage type: Mandatory, None, Private, or Voluntary. If the employee's coverage type is Mandatory or Voluntary, the system enables you to specify the contribution group. |
Region |
Select your employee's region: East or West. The region of the primary health care provider is the default setting. |
Contribution Group |
If the employee's Insurance Coverage Type is Mandatory or Voluntary, the system allows you to specify the contribution group. |
Social Insurance Provider |
Select the health insurance provider that insures this employee. |
Calculation Rate |
The calculation rate. This is a reference to the contribution rates of the provider. |
Total Computed Cost |
This field becomes available for entry if you enter Private in the Insurance Coverage Type field. The value that you enter for Total Computed Cost must be greater than zero. |
ER Remits |
If the employer pays health insurance contributions, select this check box. This option is available only if you select Private in the Insurance Coverage Type field. |
Employer Contribution |
This field becomes available for entry if you enter Private in the Insurance Coverage Type field. The value in this field must not be greater than the Total Computed Cost (0 is a valid value). If the Total Computed Cost is greater than zero, the system calculates the value in the Employer Contribution field as follows: Employee Contribution = Total Computed Cost − Employer Contribution The value you enter here must not be greater than the Total Computed Cost (0 is a valid value). |
Access the Maintain Social Ins Data DEU - SI Details page (Global Payroll & Absence Mgmt, Payee Data, Social Security/Insurance, Maintain Social Ins Data DEU, SI Details).
Note. You can save the employee social insurance data only after you enter all the required data in the pages of this component.
Date of Birth |
Populates from the employee's personal data. |
Country |
Must be DEU. |
National ID Type |
Select VSNR for German Social Insurance Number or EUVSNR for European Social Insurance Number. |
National ID |
Enter the employee's social insurance number. |
Primary ID |
Select if the National ID has to be used for the German DEUEV process. |
EU Social Insurance Number |
Enter the employee's EU social insurance number. |
Insurance Details
Effective Date |
Populates from the Contributions page. |
DEUEV Contribution Group Code |
The DEUEV contribution group code of the employee. |
Employee Category |
Enter the code applicable to the employee. |
BA Code (German Federal Employment Services Office code) |
Select the employee's job code in accordance with the official codes of the German Federal Employment Services Office. |
Employment Type |
Enter the employee's employment type. You can save the social insurance data only when you enter a value here and select a value in the Position field. |
Position |
You can save the social insurance data only when you select a value here and in the Employment Type field. Select the employee's position:
|
Education |
Select the employee's education code in accordance with the official codes of the German Federal Employment Services Office:
|
Pension Type |
Enter the type of pension that the employee receives. This entry is used to classify employees. |
Insignificant Employment |
If the Employee Category field is equal to 109, then Insignificant employee appears. Otherwise, Not insignificant appears. |
SI Card Date Presented |
Enter the date on which the employee submitted his or her SI card. |
Glidezone Calculation Method |
Enter the method used to calculate SI contributions when the employee belongs to the so-called Glidezone (between 400,- to 800,- Euro income). The employee contribution is calculated with a reduced percentage. |
SI-Technical Hire |
Select if the employee ID or employee record belongs to a person that is exiting employment. The system uses this field to calculate certain special cases for employees who are insignificantly employed. |
Access the Maintain Social Ins Data DEU - Retiree Health In page (Global Payroll & Absence Mgmt, Payee Data, Social Security/Insurance, Maintain Social Ins Data DEU, Retiree Health In).
Maximum Health Insurance Gross |
The maximum income limit. The health insurance provider notifies you of the amount of the contributory pension benefits. In order to allow the social insurance contribution recipient to make a correct contribution statement, the health insurance provider must also specify whether the pension recipient receives multiple pension payments and which contribution rate applies to the pension recipient's health insurance. |
Minimum Rule Applicable |
Pension benefits are noncontributory if the pension benefits do not exceed a certain amount (low-income limit). The limit is 1/20 of the monthly base amount in accordance with § 18 of the Social Security Code IV. If the compensation for your employees is less than this limit, select this check box. |
The contribution transfer process must be carried out for the health and nursing care contributions of retirees with mandatory health insurance. The contribution must be paid by each company based on the payments made in the respective company.
You do not have to pay contributions for retirees with voluntary insurance coverage. However, you must notify the social insurance provider of the amount of the pension benefits and any changes. For this reason, you must record these pension recipients and their contributions on the contribution statement. The pension recipients are assigned to a social insurance provider without contribution payments being made.
Because a third-party income can lead to the maximum contribution limit being reached, also consider other earnings in order to ensure correct contribution statements.
The maximum contribution limit (contribution payment limit) is the difference between the income limit for health and nursing care insurance and the gross pension of the statutory pension insurance.
Note. If pension benefits are paid in intervals of more than one month, they must be distributed in order to verify whether they are below the lower contribution limit. The low-income earner limit is not used if the pension benefits themselves exceed the limit, but the contributory portion is below the limit due to the Maximum Health Insurance Gross amount specified.
Access the Maintain Social Ins Data DEU - Multiple Employments page (Global Payroll & Absence Mgmt, Payee Data, Social Security/Insurance, Maintain Social Ins Data DEU, Multiple Employments).
Effective Date |
Enter the effective date for multiple employment data. This is the date from which the data is valid for payroll calculation |
Multiple Employment Records |
Select to indicate that there are multiple employments in other companies for this employee. |
SI Gross |
Enter the social insurable gross from the other employments; one row for each employment. |
Currency |
Select the currency. |
Force AV Calc |
If this check box is selected, the entered SI-gross will be used for unemployment insurance calculation in every case (even when the entered amount is beyond 400,- Euro). |
Access the Maintain Social Ins Data DEU -Flex Time Entry page (Global Payroll & Absence Mgmt, Payee Data, Social Security/Insurance, Maintain Social Ins Data DEU, Flex Time Entry).
Effective Date |
Enter the effective date for flexible worktime details. |
Flexible Worktime Indicator |
Select if the employee has a flexible worktime contract as of the effective date. Deselect to indicate that the employee does not work with a flexible worktime contract anymore. |
Saving Amount Third Party East |
Enter savings for flexible worktime from former employers for SI region East. |
Income Reduction Begin Date |
Enter the date when the reduction of income happens the first time. |
Saving Amount Third Party West |
Enter savings for flexible worktime from former employers for SI region West. |
Begin Work off Phase |
Enter the beginning date of the work off phase (when employee starts free time span). |
End Work off Phase |
Enter the ending date of the work off phase (when employee come back from free time span). |
Access the Pay Entity Location DEU page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Framework, Organizational, Pay Entity Location DEU, Pay Entity Location DEU).
See Setting Up a Pay Entity Location.
Access the SI Contributions Report DEU(Global Payroll & Absence Mgmt, Social Security/Insurance, SI Contributions Report DEU, SI Contributions Report DEU).
Provider ID |
Once you select the provider ID, the system populates the Address group box. |
Use the Accident Insurance component (ACCDNT_INS_TABLE) to set up accident insurance information.
This section discusses how to:
Set up accident insurance details.
Set up accident insurance address information.
Page Name |
Definition Name |
Navigation |
Usage |
ACCDT_INS_TABLE |
Set Up HRMS, Product Related, Workforce Administration, Workforce Data DEU, Accident Insurance, Accident Insurance Table |
Set up your accident insurance details. |
|
ACCDT_INS2_TABLE |
Set Up HRMS, Product Related, Workforce Administration, Workforce Data DEU, Accident Insurance, Accident Insurance Address |
Set up your accident insurance address information. |
|
Accident Insurance Upload |
HRDE_AI_UPLOAD |
Set Up HRMS, Product Related, Workforce Administration, Workforce Data DEU, Accident Insurance, Accident Insurance Upload |
Upload accident insurance data. |
Access the Accident Insurance Table page (Set Up HRMS, Product Related, Workforce Administration, Workforce Data DEU, Accident Insurance, Accident Insurance Table).
Accid Ins Lim (accident insurance limit) |
Enter the limit amount for the accident insurance. |
Hazard |
Enter a hazard code. |
Hazard Class |
Enter the accident insurance hazard class. |
Access the Accident Insurance Address page (Set Up HRMS, Product Related, Workforce Administration, Workforce Data DEU, Accident Insurance, Accident Insurance Address).
Country |
Select the appropriate country. The remaining address fields comply with PeopleSoft standard address formats. |
Access the Accident Insurance Upload page (Set Up HRMS, Product Related, Workforce Administration, Workforce Data DEU, Accident Insurance, Accident Insurance Upload).
UVGT File |
Enter the path of the UVGT file. |
UVSD File |
Enter the path of the UVSD file. |
Load Data |
Click to upload accident insurance data. |
This section lists common elements and discusses how to:
Define contribution group codes.
Define rate codes.
Define group rate codes.
Define coverage types.
Contribution groups are delivered and maintained by PeopleSoft.
SI Coverage Type (social insurance coverage type) |
The social insurance type that you selected to access this page. |
Coverage Type |
The type of calculation to be done for the employee. |
Contribution Group |
The group defined on the Contribution Groups page. |
Page Name |
Definition Name |
Navigation |
Usage |
GPDE_SI_STATCD |
Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, Contribution Groups DEU, Contribution Grp |
Define the contribution group codes for contribution statements. PeopleSoft delivers and maintains the Contribution Groups table. |
|
GPDE_SI_RATE_CD |
Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, Contribution Groups DEU, Rate Codes |
View the possible calculation rate codes for each insurance type. PeopleSoft delivers and maintains the Contribution Groups table. |
|
GPDE_SI_STAT |
Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, Contribution Groups DEU, Grp / Rate Codes |
View the relationship between the contribution group and the corresponding rate code. |
|
GPDE_SI_COV |
Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, Contribution Groups DEU, Coverage Types |
View the possible contribution groups for each coverage type. PeopleSoft delivers and maintains the Contribution Groups table. |
Access the Contribution Grp page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, Contribution Groups DEU, Contribution Grp).
The contribution groups vary based on the social insurance coverage type:
SI Coverage Type |
Insurance Coverage Type |
Contribution Group |
Health insurance |
0 - None |
0 - No contribution (default) |
|
1 - Mandatory |
1 - Normal contribution (default) |
|
|
2 - Increased contribution |
|
|
3 - Reduced contribution |
|
|
4 - Farmers health insurance |
|
|
5 - Employer's contribution to farmer's health insurance |
|
|
6 - Insignificant employee contribution |
|
2 - Voluntary |
0 - No contribution (default) |
|
|
9 - Voluntary contribution |
|
3 - Private |
0 - No contribution (default) |
Nursing care insurance |
0 - None |
0 - No contribution (default) |
|
1 - Mandatory |
0 - No contribution (default) |
|
|
1 - Full contribution |
|
|
2 - Half contribution |
|
2 - Voluntary |
0 - No contribution (default) |
|
|
1 - Full contribution |
|
|
2 - Half contribution |
|
3 - Private |
0 - No contribution (default) |
Old age pension insurance |
0 - None |
0 - No contribution (default) |
|
1 - Mandatory |
1 - Blue collar full contribution (default) |
|
|
2 - White collar full contribution |
|
|
3 - Blue collar half contribution |
|
|
4 - White collar half contribution |
|
|
5 - Lump sum for insignificant blue collar worker |
|
|
6 - Lump sum for insignificant white collar worker |
|
2 - Voluntary |
Illegal (default) |
|
3 -Private |
0 - No contribution (default) |
Unemployment insurance |
0 - None |
0 - No contribution (default) |
|
1- Mandatory |
1 - Full contribution (default) |
|
|
2 - Half contribution |
|
2 - Voluntary |
Illegal |
|
3 - Private |
Illegal |
Access the Rate Codes page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, Contribution Groups DEU, Rate Codes).
Rate Code |
The rate codes defined on this page will be used in the definition of the contribution rates for the various SI Coverage Types and for the Health Insurance providers. |
Default Rt Code (default rate code) |
When the actual values for a contribution rate are entered, the system will calculate a default for the rate code in the Rate Code field based on the value for the rate code entered here. |
Access the Grp / Rate Codes page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, Contribution Groups DEU, Grp / Rate Codes).
Contribution Group |
The group defined on the Contribution Groups page. |
Rate Code |
Rate code for the calculation of contributions. |
Set As Default |
Select if you want this set as the default. |
Access the Coverage Types page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, Contribution Groups DEU, Coverage Types).
This section discusses how to view Germany pension insurance providers.
Page Name |
Definition Name |
Navigation |
Usage |
GPDE_SI_P_PROVDR |
Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, Pension Ins Providers DEU, Pension Ins Providers DEU |
Lists all pension insurance providers in Germany. The table is updated regularly by PeopleSoft. You can update the table yourself if necessary. |
Access the Pension Ins Providers DEU page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, Pension Ins Providers DEU, Pension Ins Providers DEU).
You can view all of your pension providers.
Pension Area |
The ID that you selected when you accessed the page. |
Pension Type |
Enter the pension insurance provider. |
Pension District |
Enter the associated district. |
This section provides an overview on the changes to the load file, provides field mapping information for row types, shows an example of a data file, and discusses how to view and load information related to German pension insurance providers.
The Provider ID table has changed since version 1.0. Version 1 was a pure comma separated file (CSV) without additional information and with equal field count rows. Version 2.0 has kept the general storage format of a CSV file, but we have introduced different record types, and the first field in a row identifies the type. Depending on the type, the rows have different meanings.
This table illustrates how a file is built:
Part |
Row Types |
Number of Rows |
Description |
HDR (header record) |
|||
KKI |
0 to many |
Information about health insurance providers |
|
DAV |
0 to many |
Information about entities or organizations that are receiving, forwarding, or distributing health insurance information. |
|
TRL (trailer) |
Because of this new structure, a file can no longer be loaded in a simple way because the first and last rows (HDR and TRL information) must be filtered. The file name has a base-pattern of BN plus a 6-digit date (ddmmyy). The file extension has changed from .csv to .bnr.
This table shows how you should map your fields for your Provider ID table:
File Field Number |
PeopleSoft Field Name |
File Field Name |
Remarks |
1 |
SATZKENNUNG |
Row Label: KKI or DAV (skip when HDR or TRL) |
|
2 |
GPDE_SI_PROV_ID |
BETRIEBSNUMMER |
|
3 |
BGN_DT |
BNR_GUELTIG_AB |
DATE(10), may be NULL |
4 |
GPDE_SI_ORG_TYPE |
ORG_ART |
|
5 |
GPDE_SI_PROV_ID_SU |
NACHFOLGE_BNR |
May be blank |
6 |
EXPIRATN_DT |
BNR_GUELTIG_BIS |
May be NULL |
7 |
GPDE_DV_RCVER_ID |
DAV_BNR |
|
8 |
GPDE_DV_FWD_ID |
WTL_BNR |
|
9 |
GPDE_DV_DEC_ID |
SLB_BNR |
|
10 |
DESCR50 |
BEZ_KURZ |
|
11 |
DESCR100_GER |
FA_NAME_1 |
|
12 |
DESCR100_2_GER |
FA_NAME_2 |
|
13 |
DESCR100_3_GER |
FA_NAME_3 |
|
14 |
ADDRESS100 |
ADR_ANS |
Street address |
15 |
POSTAL |
ADR_PLZ |
|
16 |
CITY50 |
ADR_ORT |
|
17 |
ADDRESS100_OTHER |
POSTFACH_ANS |
Post box address |
18 |
POSTAL_OTHER |
POSTFACH_PLZ |
|
19 |
CITY50_OTHER |
POSTFACH_ORT |
|
20 |
EMAILID |
KOMM_EMAIL |
|
21 |
GPDE_SI_FTAM_ID |
KOMM_FTAM |
|
22 |
GPDE_AL_PROV_TYPE |
KASSENART |
Char 02,XLAT |
23 |
EFFDT |
Here is an example of a data file containing a header (HDR), one line of data (KKI), and a trailer (TRL):
"HDR";"BN060927.BNR";"ITSG GmbH";"27.09.2006";"10:12:55" "KKI";"01000068";"";"01";"90235319";"31.12.2002";"01000262";"01000262";"01000262";"⇒ ⇒ ⇒ ⇒ ⇒ AOK Berlin";"AOK Berlin Rechtskreis Ost";"";"";"Wilhelmstr. 1";"10957";"Berlin";"";⇒ ⇒ ⇒ ⇒ ⇒ "";"";"da@dta.aok.de";"";"14";"04.03.2004" "TRL";"BN060927.BNR";"ENDE"
Page Name |
Definition Name |
Navigation |
Usage |
GPDE_SI_PROV_ID |
Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, SI Provider IDs DEU, Provider IDs |
View information associated with the provider, including successor, receivers, name, postal address, postbox address, and email address. |
|
GPDE_SI_PROV_LOAD |
Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, SI Provider IDs DEU, Load Provider IDs |
Load new provider information into the database. |
Access the Providers IDs page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, SI Provider IDs DEU, Provider IDs).
Provider ID
Displays the provider's ID, organization type, provider type, and effective date.
Successor
Displays the provider's ID, the provider's ID as a successor, the begin date, and the expiration date.
Receivers
Displays the provider's ID as well as the provider's number as a Deuev Receiver, forwarding institution, and decoding institution.
Name
Displays the provider's ID and description.
Postal Address
Displays the provider's ID, address, postal code, city, and address.
Postbox Address
Displays the provider's ID, postal code (other city).
Email Address
Displays the provider's ID, email ID, and Etam address.
Access the Load Provider IDs page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, SI Provider IDs DEU, Load Provider IDs).
Enter the path and name of the file in the File Name field.
This section discusses how to:
Entering Basic Social Insurance Provider Data.
Entering Social Insurance Provider Bank Data.
Viewing Social Insurance Contribution Rates Data.
Viewing Social Insurance Refund Insurance Rates Data.
Entering Pay Entity Social Insurance Data.
Entering Pay Entity Social Insurance Refund Information.
Note. Use the Pay Entities DEU (GPDE_AL_PAYENTITY) component to set up social insurance providers.
Access the Insurance Providers DEU - Provider Data page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, Insurance Providers DEU, Provider Data).
Provider Type |
Select the type of health insurance provider based on the classification due to DEUEV. |
Provider ID |
Enter a provider ID. This number is defined by you and signifies an internal logical order. You can select your own number (for example, 0001, 0002, and so on). |
Head Office |
Select if this is the head office for the provider. |
Deuev Receiver |
Select if this provider is a DEUEV receiver. |
Prov Nbr of Higher Lvl Office (provider number of higher level office) |
Select the provider number of the higher level office. |
Provider Nbr of Deuev Receiver (provider number of DEUEV receiver) |
Select the provider number of the DEUEV receiver. |
Access the Insurance Providers DEU - Bank Data page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, Insurance Providers DEU, Bank Data).
Country Code |
Select the country for the provider's bank account. |
International ACH Bank Account (international automatic clearing house bank) |
Select to indicate that the bank is located outside the territorial jurisdiction of the United States. Note. This field appears only if you have PeopleSoft Payroll for North America or PeopleSoft Global Payroll for United States installed. |
Already have an IBAN Number |
Select to indicate that the provider has an IBAN. When you select this check box, the Bank ID, Bank Branch ID, and Account Number fields become display-only and the IBAN field and Validate button become available. If you deselect this check box for a provider who already has an IBAN entered and validated in the IBAN field, the system alerts you that this action will result in clearing the IBAN and bank account detail fields. You can click OK to continue, or Cancel to leave the check box selected. Note. This check box appears on this page only when the IBAN Enabled check box is selected and the IBAN Required check box is deselected on the IBAN Country Setup page. |
IBAN (International Bank Account Number) |
Enter the IBAN for the provider. This field is editable only if you select the Already have an IBAN Number check box or if the IBAN Required check box is selected on the IBAN Country Setup page. |
Validate |
Click to validate the number entered in the IBAN field. The validation process alerts you if there is an error in the entered IBAN. In addition, the validation process populates the Bank ID, Bank Branch ID, and Account Number fields based on the entered IBAN. This button is available only if you select the Already have an IBAN Number check box or if the IBAN Required check box is selected on the IBAN Country Setup page. |
Bank ID and Account Number |
When the Already have an IBAN Number check box is selected or if the IBAN Required check box is selected on the IBAN Country Setup page, these fields are not editable. The system populates them based on the entered IBAN when you click the Validate button. For accounts without an IBAN, manually enter values in the Bank ID and Account Number fields. |
Bank Branch ID |
Enter the bank branch ID for the provider. |
Account Name |
Enter the account name for the provider. |
Currency Code |
Select the code of the currency in which the account is maintained. The code you enter in this field is for informational purposes only and is not used by the banking process. |
Deposit Schedule |
Select the bank deposit schedule for the provider. |
Access the Insurance Providers DEU - Contribution Rates page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, Insurance Providers DEU, Contribution Rates).
When you access this page, the contribution rates for the social insurance provider appear. Select the Modify Rates link to access the Health Rates page in the Insurance Provider Rates component and modify the rates.
Access the Pay Entities DEU - Refund Ins Rates page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, Insurance Providers DEU, Refund Ins Rates).
When you access this page, the refund insurance rates for the social insurance provider appear. Select the Modify Rates link to access the Refund Insurance Rates page in the Insurance Provider Rates component and modify the rates.
Access the Pay Entities DEU - SI Data page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Framework, Organizational, Pay Entities DEU, SI Data).
Local Office |
Select the local office of the social insurance provider. |
Customer Nbr (customer number) |
Enter the customer number. |
Pens Cust Nbr (pension customer number) |
Enter the pension customer number. |
Default Prov (default provider) |
Select if this social insurance provider is the default provider for this pay entity. |
Access the Pay Entities DEU - Refund Ins Data page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Framework, Organizational, Pay Entities DEU, Refund Ins Data).
Select the Refund Insurance check box if refund insurance has to be paid for the employer. If you select this option, then the Provider field must contain at least one entry, one of which must be the default provider. Each provider must list Blue Collar Worker and Maternity among their contribution groups.
This section provides overviews of the health insurance rates import process and details about that process, and discusses how to import health insurance rates into the system.
The German SI providers supply an XML data file that contains the health insurance rates for all German health insurance providers. This XML file can be imported into the PeopleSoft Global Payroll for Germany application. To import the XML file, you must first complete these tasks:
The health insurance rates must be maintained through an import functionality. The payroll clerk or administrator creates an SI provider ID and then enters the health insurance information using the Provider Data page.
To connect the provider with the rates, the payroll clerk or administrator enters the provider ID. The system then links the health insurance provider to the stored rates.
To maintain the rates from the SI Provider, the payroll clerk selects the Head Office check box on the Provider Data page.
The payroll clerk gets the file location and file name from their information technology department and then enters it in the File Name field on the Load Health Insurance Rates page.
To import the data, the payroll clerk clicks the Load Health Rates button.
The XML data file contains four different areas:
Addresses of the health insurance provider (first column = 'ADR').
Health insurance rates for regular employees (first column = 'BTS').
Health insurance rates for retired employees (first column = 'VSS').
Refund insurance rates (first column = 'UML').
Refund insurance (first column = 'UME').
After the load of the data file has started, the system reads the given file and imports all the rates into the German health rate table and into the refund insurance table.
This table provides the data definition for the German SI Health Rate record (GPDE_SI_HLTH_RT):
No |
Field Name |
Type |
Length |
Description |
1 |
GPDE_SI_PROV_ID |
Character |
8 |
Provider ID (Betriebsnummer) |
2 |
EFFDT |
Date |
10 |
Effective Date |
3 |
GPDE_SI_REGION |
Character |
1 |
SI Region |
4 |
GPDE_SI_RATE_CD |
Character |
3 |
Calculation Rate (for example, '1' = normal; '500' = voluntary normal, and so on) |
5 |
GPDE_SI_PCT |
Number |
3.2 |
Health Percentage Total |
6 |
GPDE_SI_PCT_EE |
Number |
3.3 |
Health Percentage Employee |
7 |
GPDE_SI_PCT_ER |
Number |
3.3 |
Health Percentage Employer |
8 |
GPDE_SI_TOTAL_COST |
Number |
15.3 |
Health Rate Voluntary Total |
9 |
GPDE_SI_EE_COST |
Number |
4.2 |
Health rate voluntary Employee |
10 |
GPDE_SI_ER_COST |
Number |
4.2 |
Health rate voluntary Employer |
11 |
CURRENCY_CD |
Character |
3 |
Currency |
This table provides the data definition for the German SI Health Rate Refund record (GPDE_SI_RFND_RT):
No |
Field Name |
Type |
Length |
Description |
1 |
GPDE_SI_PROV_ID |
Character |
8 |
Provider ID (Betriebsnummer) |
2 |
EFFDT |
Date |
10 |
Effective Date |
3 |
GPDE_SI_REGION |
Character |
1 |
SI Region |
4 |
GPDE_SI_RFND_TYP |
Character |
1 |
Type of Refund Insurance ( 1 = Blue Collar Worker; 2 = Maternity) |
5 |
GPDE_SI_RFND_GRP |
Character |
2 |
Refund Insurance Contribution Group |
6 |
LAST_UPDATE_DATE |
Date |
10 |
Date of last update |
7 |
GPDE_SI_PCT |
Number |
6.3 |
Percent |
8 |
GPDE_REF_PCT |
Number |
6.2 |
Percent Refund |
9 |
GPDE_LIM_U1_U2_MAT |
Number |
1 |
Limit U1/U2 Maternity |
10 |
GPDE_LIM_U2_EMP_BN |
Number |
1 |
Limit U2 Employment Ban |
11 |
GPDE_REF_CONTR_A_L |
Number |
1 |
Refund Contribution Actual/Lump Sum |
12 |
GPDE_REF_ACT_LP |
Number |
7.3 |
Percent Refund ACT/LP |
Page Name |
Definition Name |
Navigation |
Usage |
Load Health Insurance Rates |
GPDE_SI_IMP_RATE |
Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security/Insurance, Load Health Insurance Rates |
Load a provider's health insurance rates into the database. |
Access the Load Health Insurance Rates page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security/Insurance, Load Health Insurance Rates).
Enter the path of the XML file that contains the health insurance rates that you want to load, and click Run.
Use the Insurance Provider Rates DEU (GPDE_SI_PROV_RT) component to set up social insurance provider rates.
This section discusses how to:
Set up social insurance provider health insurance rates.
Set up social insurance provider refund insurance rates.
Access the Insurance Provider Rates DEU - Health Rates page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, Insurance Provider Rates DEU, Health Rates).
Region |
Select General if the rates are used in the east or west SI regions. Select East if the rates are used in the east SI region. Select West if the rates are used in the west SI region. |
Calculation |
The relationship between the calculation rate codes for health insurance and the rate of the provider. |
Pct (percent) |
The full percentage for the calculation rate code. |
% ER (percentage employer) |
The portion of the percentage that the employer pays. |
% Empl (percentage employee) |
The portion of the percentage that the employee pays. |
Cost |
The full amount of health insurance if the calculation rate is 500, 501, or 600. |
ER Contr (employer contribution) |
The employer's portion of the full amount of health insurance if the calculation rate is 500, 501, or 600. |
Access the Insurance Provider Rates DEU - Refund Ins Rates page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, Insurance Provider Rates DEU, Refund Ins Rates).
Region |
Select General if the rates are used in the east and west SI region, East if the rates are used in the east SI region, or West if the rates are used in the west SI region. |
Rfnd Type (refund type) |
Type of refund insurance to which the employer contributes. |
Contrib Grp (contribution group) |
Contribution group to which the employer pays the contribution for refund insurance. |
Pct (percentage) |
The full percentage for the calculation. |
This section discusses how to:
Set up income limits reference amounts.
Set up income limits for health insurance.
Set up income limits for nursing care.
Set up income limits for old age pension insurance.
Set up income limits for unemployment insurance.
Set up rates for nursing care.
Set up rates for old age pension insurance.
Set up rates for unemployment insurance
Note. PeopleSoft delivers and maintains the Income Limits table, but you can also change the data yourself if necessary.
Page Name |
Definition Name |
Navigation |
Usage |
GPDE_SI_REF_AMT |
Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, Income Limits DEU, Reference Amounts |
Define certain reference amounts for the various income limits for insurance. |
|
GPDE_SI_LIMITS_01 |
Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, Income Limits DEU, Limits Health |
View and set up income limits for health insurance. |
|
GPDE_SI_LIMITS_02 |
Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, Income Limits DEU, Limits Nursing |
View and set up income limits for nursing care insurance. |
|
GPDE_SI_LIMITS_03 |
Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, Income Limits DEU, Limits Pension |
View and set up income limits for pension care insurance. |
|
GPDE_SI_LIMITS_04 |
Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, Income Limits DEU, Limits Unemployment |
View and set up income limits for unemployment insurance. |
|
GPDE_SI_RATES_02 |
Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, Income Limits DEU, Rates Nursing |
Define nursing care insurance contribution rates. PeopleSoft delivers and maintains these tables. |
|
GPDE_SI_RATES_03 |
Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, Income Limits DEU, Rates Pension |
Define old age pension insurance contribution rates. PeopleSoft delivers and maintains these tables. |
|
GPDE_SI_RATES_04 |
Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, Income Limits DEU, Rates Unemployment |
Define unemployment insurance contribution rates. PeopleSoft delivers and maintains these tables. |
Access the Reference Amounts page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, Income Limits DEU, Reference Amounts).
Region |
In this field, East indicates the new German states (neue Bundesländer) and West indicates the old states (alte Bundesländer). General indicates that the input is valid for both east and west SI regions. |
Low Income Monthly Gross |
Applies to low-income earners and is prescribed by law. Enter a new value if this amount changes. |
Monthly Pension Gross |
Base Value for Pension is required for retiree health insurance. |
Monthly Gross |
Monthly average income. |
Annual Gross |
Yearly average income. |
Daily Gross |
Daily average income. |
Miners' Social Insurance |
Select Yes if the input data are only relevant for the miners' insurance association; select No if not. Select N/A (not applicable) if the input data is relevant for miners and non-miners. |
Percent for Insolvency |
Percentage of the Refund Insurance for Insolvency that the company pays to the German Employment Agency. |
Maximum Tax-free Amount |
The highest nontaxable contribution that the employer can make to private health insurance. |
PI Min Amount for Insig. Empl (pension insurance minimum amount for insignificant employee) |
Minimum limit to calculate pension insurance contribution if the employee is an insignificant employee and wishes to be insured in the pension insurance. Note. An insignificant employee is defined as someone who is not a regular employee. |
Access the Limits Health page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, Income Limits DEU, Limits Health).
Region |
In this field, East indicates the new German states (neue Bundesländer) and West indicates the old states (alte Bundesländer). General indicates that the input is valid for both east and west SI regions. |
Maximum Monthly Gross |
The monthly gross income limit prescribed by law for this limit type. If any changes occur in these amounts, enter them in the respective fields. |
Maximum Daily Gross |
The daily pay income limit prescribed by law for this limit type. |
Note. Change health insurance data at the employee level in the Social Insurance component.
See Also
Entering Social Insurance Data
Access the Limits Nursing page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, Income Limits DEU, Limits Nursing).
The fields on this page are identical to those on the Limits Health page.
See Also
Setting Up Income Limits for Health Insurance
Access the Limits Pension page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, Income Limits DEU, Limits Pension).
Miners' Social Insurance |
Select Yes if the input data are only relevant for the miners' insurance association; select No if not. Select N/A (not applicable) if the input data is relevant for miners and non-miners. |
The remaining fields on this page are identical to those on the Limits Health page.
See Also
Setting Up Income Limits for Health Insurance
Access the Limits Unemployment page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, Income Limits DEU, Limits Unemployment).
The fields on this page are identical to those on the Limits Health page.
See Also
Setting Up Income Limits for Health Insurance
Access the Rates Nursing page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, Income Limits DEU, Rates Nursing).
Region |
In this field, East indicates the new German states (neue Bundesländer) and West indicates the old states (alte Bundesländer). General indicates that the input is valid for both east and west SI regions. |
Rate Code |
The relationship between the calculation rate codes for the SI branch and the rate. |
Pct (percentage) |
The full percentage for the calculation rate code. 50% of the value entered in this field will be entered as a default into the fields %ER and %EE, respectively. |
% ER (percentage employer) |
The employer's percentage for the calculation rate code. The default is 50 percent of the value entered in the Pct field. You can change this value. The fields %ER and %EE must add up to the value entered in the Pct. field. If this field is changed, the value in %EE is adjusted accordingly. |
% Empl (percentage employee) |
The employee's percentage for the calculation rate code. The default is Pct - %ER. You can change this value. The fields %ER and %EE must add up to the value entered in the Pct field. If this field is changed, the value in %ER is adjusted accordingly. |
Cost |
The actual cost for the calculation rate code. The system calculates it by multiplying the income limit for Nursing Care Insurance in the selected region with the percentage entered in the Pct field. |
ER Contrib (employer contribution) |
The employer's cost for the calculation rate code. The system calculates it by multiplying the income limit for Nursing Care Insurance in the selected region with the percentage entered in the %ER field. |
Access the Rates Pension page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, Income Limits DEU, Rates Pension).
Miners' Social Insurance |
Select Yes if the input data are only relevant for the miners' insurance association; select No if not. Select N/A (not applicable) if the input data is relevant for miners and non-miners. |
The remaining fields on this page are identical to those on the Rates Nursing page.
See Also
Setting Up Rates for Nursing Care
Access the Rates Unemployment page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, Income Limits DEU, Rates Unemployment).
The fields on this page are identical to those on the Rates Nursing page.
See Also
Setting Up Rates for Nursing Care