PeopleSoft Enterprise Global Payroll for Germany 9.1 PeopleBook

Managing Social Insurance

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.

Understanding Social Insurance Data

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.

Understanding Flexible Worktime

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.

Viewing Delivered Elements

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 Enterprise Global Payroll 9.1 PeopleBook.

Entering Social Insurance Data

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.

Pages Used to Enter Social Insurance Data

Page Name	Definition Name	Navigation	Usage
Maintain Social Ins Data DEU - Contributions	GPDE_SI_DATA1	Global Payroll & Absence Mgmt, Payee Data, Social Security/Insurance, Maintain Social Ins Data DEU, Contributions	View and set up income limits for individual types of social insurance. PeopleSoft delivers and maintains the Income Limits Table, but you can change the data if necessary.
Maintain Social Ins Data DEU - SI Details (social insurance details)	GPDE_SI_DATA3	Global Payroll & Absence Mgmt, Payee Data, Social Security/Insurance, Maintain Social Ins Data DEU, SI Details	Enter additional social insurance data.
Maintain Social Ins Data DEU - Retiree Health In (retiree health insurance)	GPDE_SI_DATA4	Global Payroll & Absence Mgmt, Payee Data, Social Security/Insurance, Maintain Social Ins Data DEU, Retiree Health In	Enter retiree health insurance data.
Maintain Social Ins Data DEU - Multiple Employments	GPDE_SI_MUL	Global Payroll & Absence Mgmt, Payee Data, Social Security/Insurance, Maintain Social Ins Data DEU, Multiple Employments	Select a check box to indicate that the employee is employed by multiple employers for DEUEV.. For each employment, you can also enter the gross amount that is covered by social insurance from the other employments.
Maintain Social Ins Data DEU - Flex Time Entry	GPDE_FL_DATA	Global Payroll & Absence Mgmt, Payee Data, Social Security/Insurance, Maintain Social Ins Data DEU, Flex Time Entry	Enter data for the flex time agreement between employer and employee.
Pay Entity Location DEU	GPDE_AL_PE_LOC	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Framework, Organizational, Pay Entity Location DEU, Pay Entity Location DEU	Each location of a company has a reporting number for reporting social insurance contributions to the pension provider. Enter the social insurance reporting number of the paying entity location here. This information is used in the SI Contributions Report DEU.
Compulsory Health Ins Rpt DEU (compulsory health insurance report DEU)	GPDE_RC_SI09	Global Payroll & Absence Mgmt, Social Security/Insurance, Compulsory Health Ins Report DEU, Compulsory Health Ins Rpt DEU	Helps employers to decide about the right health insurance contribution class (voluntary versus mandatory).
SI Contributions Report DEU	GPDE_RC_SI10	Global Payroll & Absence Mgmt, Social Security/Insurance, SI Contributions Report DEU, SI Contributions Report DEU	Summarizes all social insurance data relevant to all employees. Displays all the values that are set for a specific organization.

Setting Up SI Data for Employees

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

Entering Additional Social Insurance Details for Employees

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: 0 Applicant 1 Blue Collar, non prof (nonprofessional) 2 Blue Collar Prof (blue-collar professional) 3 BC Master (blue-collar master) 4 White Collar 5 Homeworker; domestic business 8 Part Time < 18 Hrs. (18 hours) 9 Part Time >= 18 Hrs
Education	Select the employee's education code in accordance with the official codes of the German Federal Employment Services Office: 0 N/A 1 General Secondary w/o Prof 2 General Secondary with Prof 3 Gen Univ Entr no Prof Train 5 Technical College Degree 6 University Degree. 7 unknown degree Gen Univ Entr w/Prof Train
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.

Entering Retiree Health Insurance Data

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.

Setting Up Multiple Employments Data

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

Setting Up Flex Time Entry

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

Setting Up a Pay Entity Location

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.

Reporting Social Insurance Contributions - GPDESI10

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.

Setting Up Accident Insurance

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.

Pages Used to Set Up Accident Insurance

Page Name	Definition Name	Navigation	Usage
Accident Insurance Table	ACCDT_INS_TABLE	Set Up HRMS, Product Related, Workforce Administration, Workforce Data DEU, Accident Insurance, Accident Insurance Table	Set up your accident insurance details.
Accident Insurance Address	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.

Setting Up Accident Insurance Details

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.

Setting Up Accident Insurance Address Information

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.

Uploading Accident Insurance Data

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.

Setting Up Contribution Groups

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.

Common Elements Used in This Component

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.

Pages Used to Set Up Contribution Groups

Page Name	Definition Name	Navigation	Usage
Contribution Grp (contribution group)	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.
Rate Codes	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.
Grp / Rate Codes (group / rate code)	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.
Coverage Types	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.

Defining Contribution Group Codes

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

Defining Rate Codes

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.

Defining Group Rate Codes

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.

Defining Coverage Types

Access the Coverage Types page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, Contribution Groups DEU, Coverage Types).

Viewing Pension Insurance Providers

This section discusses how to view Germany pension insurance providers.

Page Used to View Pension Insurance Providers

Page Name	Definition Name	Navigation	Usage
Pension Ins Providers DEU (pension insurance providers DEU)	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.

Viewing Germany Pension Insurance Providers

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.

Viewing and Loading Provider Information

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.

Understanding Changes to the Load File

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.

Field Mapping for Row Types KKI and DAV

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

Example: Data File

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"

Pages Used to View Pension Insurance Providers

Page Name	Definition Name	Navigation	Usage
Provider IDs	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.
Load Provider IDs	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.

Viewing Provider Information

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.

Loading Provider Information

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.

Setting Up Social Insurance Providers

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.

Pages Used to Set Up Social Insurance Providers

Page Name	Definition Name	Navigation	Usage
Insurance Providers DEU - Provider Data	GPDE_SI_PROV	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, Insurance Providers DEU, Provider Data	Set up basic information about social insurance providers.
Insurance Providers DEU - Address	GPDE_SI_PRV_ADR	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, Insurance Providers DEU, Address	Set up address information for social insurance providers.
Insurance Providers DEU - Bank Data	GPDE_SI_PRV_BNK	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, Insurance Providers DEU, Bank Data	Set up bank data for social insurance providers.
Insurance Providers DEU - Contribution Rates	GPDE_SI_HRT_DISP	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, Insurance Providers DEU, Contribution Rates	View and modify contribution rates for social insurance providers.
Insurance Providers DEU - Refund Ins Rates (refund insurance rates)	GPDE_SI_RFRT_DISP	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, Insurance Providers DEU, Refund Ins Rates	View and modify refund insurance rates for social insurance providers.
Pay Entities DEU - SI Data (social insurance data)	GPDE_AL_PE_SID	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Framework, Organizational, Pay Entities DEU, SI Data	Enter social insurance data for a pay entity.
Pay Entities DEU - Refund Ins Data (refund insurance data)	GPDE_AL_PE_RFND	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Framework, Organizational, Pay Entities DEU, Refund Ins Data	Enter refund insurance data for this pay entity.

Entering Basic Social Insurance Provider Data

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.

Entering Social Insurance Provider Bank Data

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

Bank ID

Select the bank ID for the provider.

Account Nbr (account number)

Enter the provider's bank account number.

Deposit Schedule

Select the bank deposit schedule for the provider.

Viewing Social Insurance Contribution Rates Data

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.

Viewing Social Insurance Refund Insurance Rates Data

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.

Entering Pay Entity Social Insurance Data

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.

Entering Pay Entity Social Insurance Refund Information

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.

Importing Health Insurance Rates

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.

Understanding the Health Insurance Rates Import Process

The German SI providers supply a data file that contains the health insurance rates for all German health insurance providers. This data file can be imported into the PeopleSoft Enterprise Global Payroll for Germany application. To import the data 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 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')

Understanding Processing Details

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	GPDE_SI_PCT	Number	3.2	Refund Insurance Rate (percentage)

Page Used to Load Health Insurance Rates

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.

Importing Health Insurance Rates

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 file that contains the health insurance rates that you want to load; click Run.

Setting Up Social Insurance Provider Rates

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.

Pages Used to Set Up and Load Social Insurance Provider Rates

Page Name	Definition Name	Navigation	Usage
Insurance Provider Rates DEU - Health Rates	GPDE_SI_HLTH_RT	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, Insurance Provider Rates DEU, Health Rates	Set up social insurance provider health insurance rates.
Insurance Provider Rates DEU - Refund Ins Rates (refund insurance rates)	GPDE_SI_RFND_RT	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, Insurance Provider Rates DEU, Refund Ins Rates	Set up social insurance provider refund insurance rates.

Setting Up Social Insurance Provider Health 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.

Setting Up Social Insurance Provider Refund Insurance Rates

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.

Defining Income Limits

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.

Pages Used to Define Income Limits

Page Name	Definition Name	Navigation	Usage
Reference Amounts	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.
Limits Health	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.
Limits Nursing	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.
Limits Pension	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.
Limits Unemployment	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.
Rates Nursing	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.
Rates Pension	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.
Rates Unemployment	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.

Setting Up Income Limits Reference Amounts

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.

Setting Up Income Limits for Health Insurance

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

Setting Up Income Limits for Nursing Care

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.

Setting Up Income Limits for Old Age Pension 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.

Setting Up Income Limits for Unemployment 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.

Setting Up Rates for Nursing Care

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.

Setting Up Rates for Old Age Pension Insurance

Access the Rates Pension page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Social Security / Insurance, Income Limits DEU, Rates Pension).

The remaining fields on this page are identical to those on the Rates Nursing page.

See Also

Setting Up Rates for Nursing Care

Setting Up Rates for Unemployment Insurance

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

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

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

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.

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.

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.

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.

Bank ID	Select the bank ID for the provider.
Account Nbr (account number)	Enter the provider's bank account number.
Deposit Schedule	Select the bank deposit schedule for the provider.

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.

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.

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.

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.

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.